This project was created for an 8th grade computer applications course and practices skills learned with spreadsheet applications. This project could be easily adapted to use Microsoft Office Excel or Google Sheets at various grade levels.
The following skills should be introduced before beginning this project:
• Creating spreadsheets
• Adjusting cell sizes
• Typing on multiple lines within a cell
• Cell shading and borders
• SUM, AVERAGE, MIN, and MAX formulas
• Formulas using = + - * / ( )
• Creating and formatting bar graphs
• Creating graphs using non-connected cells
• Copying and pasting charts to another document
This project contains the following components:
Dream Cars Part I: Students will research three vehicles that they would like to drive.
Dream Cars Part II: Students will create a spreadsheet comparing the three vehicles. They will also create formulas to calculate the cost per tank of gas, miles per tank of gas, cost per mile, and cost to drive to a destination of their choice.
Dream Cars Part III: Students will create graphs to visually represent their data.
Dream Cars Summary: Students will create a document summarizing the information that they found. You could also have them create a presentation.
Dream Cars Extra Credit: This is a component that I offer to students that finish faster than others.
All of the handouts that I share with my students are included in the full download!