- Have students open Excel.
- Have students use the given data to create their own spreadsheet.
- Have students create a function that gives the average price of the bikes and create a line graph.
Bicycle Prices Spreadsheet
| SOL - C/T 8.1, C/T 8.2, C/T 8.4 | |
| SWBAT: create a spreadsheet, perform a function and create a chart from the given data. | |
| Before | Review - Parts of a spreadsheet, who uses a spreadsheet and what is a spreadsheet is used for. |
| During |
|
|
|
| After | What problems did you encounter? |