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 7, student go a little deeper with more complicated graphs, and also begin to understand the concept of gathering data and setting it up in Excel. This lesson is designed to be done as a class, but can be done alone with or without the video. Most students tend to perform better, however, with video instruction rather than just written ones.
In this lesson, students will create three charts that are a bit more advanced. First, a line chart graphing the rank of baby names in popularity. Students will gather the data themselves and figure out how to enter it into Excel to make it work correctly. They will also create a stacked column chart, and a scatter chart.
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.