Grades

Grade Book Excel Spreadsheet Activity Use the following information to set up a spreadsheet to keep track of all the grades for the following students. You will need to find an Average grade for each student. Read over all the suggestions below before starting. NOTE: Grades are entered in as decimals.

Worksheet A: .97 Worksheet B: .94 Quiz 1: .82 Quiz 2: .84 Test: .90 Activity: .98 ||  ||   ||   || = Jenny = Worksheet A: .86 Worksheet B: .92 Quiz 1: .93 Quiz 2: .94 Test: .96 Activity: .87 ||  ||   ||   || = Owen = Worksheet A: .76 Worksheet B: .78 Quiz 1: .83 Quiz 2: .84 Test: .86 Activity: .92 ||  || Worksheet A: .67 Worksheet B: .88 Quiz 1: .85 Quiz 2: .77 Test: .80 Activity: .88 ||  ||   ||   || = Kyle = Worksheet A: .96 Worksheet B: .93 Quiz 1: .87 Quiz 2: .97 Test: .83 Activity: .92 ||  ||   ||   || = Maggie = Worksheet A: 1.0 Worksheet B: .99 Quiz 1: .93 Quiz 2: .95 Test: .91 Activity: .98 ||
 * ||  || = Bella =
 * ||  || = Christian =
 * ||  || = Christian =



Think??? What are you going to use for your row headings?: //**Rows are Horizontal Headings are at the beginning of the row.**//

Think???? What will be your column headings?: //**Columns are vertical Headings are at the top of the column**//


 * DO NOW: Now create a spreadsheet using EXCEL or Google Docs Sheets, with all the above data. Make sure that you enter your % as decimals. You can format them later using the menu bar.**


 * Then calculate the average GRADE for each student and THEN create a graph with this data. Try to just select the student name and average. (Hint: CTRL key)**


 * Save as last name_Grade