Agenda: Friday, 11/18/16

Spreadsheet practice: create a sheet that calculates your grades

1. Review these websites for info on working with spreadsheets:
1. Spreadsheet basics
2. Using formulas (this one is really important)
3. Cell borders and colors (The link takes you to the last page of the tutorial; don't worry about the previous pages)
2. Use this information and your notes to complete this assignment:
1. 1st and 2nd hour: see Google Classroom (½) for the assignment.
2. 5th and 6th hour:  see Google Classroom (5/6) for the assignment.
3. Instructions:
1. Create a spreadsheet that helps you calculate your grades. You will need:
1. A column for the assignment name
2. A column for the assignment type (quiz, homework, project, etc.)
3. A column for the number of points possible
4. A column for the number of points you actually earned
5. A column that uses a formula to actually calculate your grade on the assignment (format it as a percentage)
6. A cell that averages your grades into one overall percentage.
2. Fill in the data for 8 assignments and find out the grades. You may use real or made-up data; do not give yourself a 100% on everything!
3. There are several variations listed for the assignment; these are optional for anyone who would like a challenge.