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 6, students continue 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 create 8 charts, learning column and composite charts. There are two additional sections that require a higher level of thinking--students will first be given three types of raw data and must figure out which graph type is best and graph it. Second, they will be given an image of a graph--they must re-create the data and then re-create the graph in the image. Step by step instructions for these sections are NOT included in the video, but finished graphs are included in the teacher's key.
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.