Agenda: Monday, 11/28/16

Review Spreadsheet Concepts

• formula
• cell reference
• autofill handle

Redo Spreadsheet practice (create a sheet that calculates your grades)

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!

(5th and 6th hour) Create a spreadsheet that acts as a checkbook

1. Include columns for 
1. the item (paycheck, eating out, etc)
2. income
3. expenses
4. total in account; don't forget to include the starting amount
2. The "total" column should update automagically whenever you add income or subtract an expense. Create a formula that will do either so you can copy it down the "totals" column.
3. Submit via Google Classroom