In my new series of Excel assignments, students will learn Excel on a deeper level using the video method. In this method, students watch a video that shows how to do each feature in the assignment, but does not take them through the actual assignment. The video now includes a Table of Contents, which allows the student to skip or re-watch needed features. The student then uses the step by step directions to complete the assignment with a provided starter.
This method has proven more effective than traditional demonstration, as it requires a higher level of thinking and retention. In Lesson 5, students begin to explore creating graphs and charts in Excel. Unlike lessons 1-4, the video will give them step by step instruction. It is designed to be done as a class with demonstration by the teacher, and the video as a supplement for confused or absent students. However, the video can be used exclusively if you would like to continue with straight video teaching. In this lesson, students will learn to create Pie, Bar, and Line charts--five charts in all.
If you have purchased my 2010 lessons, this lesson is similar to Lesson 6, but has been updated and changed a lot due to the dramatic changes in graphs in Office 2013.
This lesson is NOT YET CLASSROOM TESTED! I would appreciate any feedback you are willing to give, especially if there are any errors I will miss.