All classes will start a new unit on Spreadsheets. After a class discussion on Spreadsheet terms students will work on five practice exercises (2 saved files) which include entering data, surveying, using formulas and creating graphs. Students will also complete a worksheet on reading a spreadsheet.
Spreadsheet Basics 1 Assignment – Example
Objectives:
- I CAN Participate in simple class surveys (Favorite Dessert, How I Get to School, Favorite Pet)
- I CAN Enter data collected in Google Spreadsheet (one survey per sheet)
- I CAN Create a column chart for the data collected from “How I Get to School”
- I CAN Create a pie chart from the data collected from “Favorite Dessert”
- I CAN Create a chart/graph of their choice that best represents the data collected for “Favorite Pet”
- I CAN Recolor all charts and graphs so that the data is visually appealing and easy to read.
Spreadsheet Basics 2 Assignment
For this lesson students will create 2 worksheets in Goggle Sheets (spreadsheet software)
In the first spreadsheet students will organize “How much they made per month in their part-time jobs”.
- I CAN Format cells and numeric data
- I CAN Use formulas to determine total amount earned per month and per job [=SUM]
- I CAN Use formulas to determine the least amount earned and the most amount earned; per month and per job [=MIN, =MAX]
In the second spreadsheet students will organize “student test grades”.
- I CAN Format cells and numeric data
- I CAN Use formulas to determine student & test averages [=Average]
- I CAN Use formulas to determine students lowest and highest test grade [=MIN, =MAX]
The whole group classwork will be scored as follows (total = 100pts):
- Basics 1 – 30 pts
- Basics 2 – 50 pts
- Worksheet – 20 pts