Tech skill area: Spreadsheet and charting Project  Create a grade book Create a grade book In column A1 place the header STUDENT A2 place the names of 6 students In row B1 to B7 place the names of different assignments for example test, quiz, worksheet, project, papers... Now fill in the cells, give each student a different grade for each assignment. NO ONE can have the same grade on any assignment. Now total the number of points for each student. SUM in the total column, then drag over the 6 grades and click enter Next divide by SUM in the %Grade then points earned /points possible times 100 to change the decimal to a % grade. Challenge, can you find the class GPA? Place the spreadsheet onto your Google Portfolio Web site Answer this question: Where else could you use a spreadsheet to help you do large amounts of math?

