How to choose a car you can afford! This team MS Excel project challenges students to figure out which car they can afford based on a number of criteria. They are challenged to create a spreadsheet using some sample data in Excel, then answer some questions to fill in the gaps. This exercise focuses on how to create a budget, analyze data, make connections, solve problems, investigate solutions and test theories. It works best as a team assignment, as many of the problems get difficult fairly quickly. This project also assumes that students have a basic to intermediate understanding of Excel, and at least a working knowledge of how to create functions using the function wizard and basic logic. The file attached has a blank worksheet, a 'cheatsheet' students can use to get started on each problem, and a complete answer key. It works well as an Excel project, but is also able to be completed in Google Spreadsheets if necessary.
The data provided in the table is best copied on to a 'live' spreadsheet so students can see if their functions and formulas actually work. Students should open and read the instructions, create the 'live' Excel file, then work through the problems.
As the teacher, you can give them the 'cheatsheet' a few classes into solving the problems, if you see they are having difficulty. The cheatsheet works well to provide them some direction without showing the complete formulas.
This is a challenging activity, works well with 9th and 10th graders, with Excel experience.