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. Lesson 8 is a fun an interactive assignment best done together as a class, but it does include a step by step video.
This fun lesson has several parts to it. First, students will be introduced to Excel templates by the use of the loan ammortization chart. After figuring out the cost of their dream house and dream car, as well as some other items on their future "wish list" students will literally "roll a life." With the press of a button, they will be assigned a job, an income, a spouse, number of kids, etc. They then will make a budget within the confines of this income, and int the end may have to make some tough and realistic choices about what they really want. This assignment also facilitates a fascinating discussion about the consequences of choices.
This assignment was written for the state of Utah, and some of the information on occupation income may not be accurate for your state. If you would like to change this part of the assignment and are having a hard time figuring out how, please contact me and I will help you.