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.
This project is covered in VELS 5 standard for Creating:
"Students independently apply a range of processing skills, functions and equipment to solve problems and create products which contain minimal functional, typographical, formatting and readability errors. During the processing stage of collaborative work, students monitor project plans and record reasons for adjusting them." Vels 5 Standards
To enhance this project I have created a three part video.
While I did not use this video for the original project I feel that it could be used as a great resource for students who are unsure of how to completely use the features of excel. The video is a screen casting of a skype conversation (created by me) between a student and a teacher. The teacher is explaining the steps to completing the project while the student goes through the steps as it is explained. In the video the students computer screen can be viewed, thus the steps to the project can be seen as a moving image as well as text.
I see these videos being used to help students with certain aspects of the project, they may skip through parts of the videos to watch just one or two steps they are unsure of. It could also be used for an overseas student or a student that will not be in classes for an extended period of time but still needs to complete class work.
If I were to use these videos in a school setting it would most likely be posted on a class or subject wiki and then students would have to send/post their completed projects back to me in a private post thus covering another aspect of Vels 5 Standard for Communicating: "Students share their ideas through their blog, website or other public forums, which are correctly formatted, comply with ICT conventions and demonstrate an awareness of the characteristics that contribute to products meeting their purpose."
The example of the project in excel can be viewed on the LAIT wiki and my screen casting videos can be viewed below. To best view the videos the use of the full screen is suggested Enjoy.
Part 1
Part 2
Part 3
No comments:
Post a Comment