M+&+M+Excel+Project

As my 4th resource and my mash-up for assignment 2 I have used a project that I had a year 7 ICT class complete during my placement. The basis of the assignment was for the individual students to complete a table and pie chart in Microsoft Excel as well as creating totals and averages for their tables.

The reason it is called the M & M Project is due to the data resource. To begin the class needs to be devided into 5 groups, this usually means 5 students per group. Each group is given a bag of M & M's and has to count how many of each colour of M & M's there are. This is then recorded for the rest of the class to view.

Each student then has to use the information to create their own spreadsheet/table and pie chart using excel.

This project worked really well with my year 7 class and was a great way to get to know the students more. I would suggest 2 to 3 periods/class to be set aside for this project as the students can take a long time to collect and organise the data.

Below are the project description and example in an excel spreadsheet as well as my mash-up which is a three part video.

This video was created with the intention of it being viewed by year 7 students of an ICT class that are learning excel. It is to be a backup set of instructions for the students. It is a screen cast of a students computer while they are skype chatting with the teacher. The teacher is leading the student through the assignment steps as the student completes the steps on their own computer. The full description of the mash-up video can be found on my blog.

Part 1

media type="youtube" key="W4BR59maQdE?hl=en" height="349" width="425"

Part 2 media type="youtube" key="CXviMCJbFSY?hl=en" height="349" width="425"

Part 3

media type="youtube" key="8vOQCuzTRcI?hl=en" height="349" width="425"