Gradebook

Creating a Gradebook using Excel:


 * 1) Use the copy of the spreadsheet below as a starting point.
 * 2) Your goal is to create the same finished Gradebook that is pictured on this page.
 * 3) Work together with your classmates in solving any problems you have with creating this spreadsheet. Use your prior knowledge of Excel, your intuition, and the help included in the software program (the ? icon located in the upper right corner). What can you do to improve the general appearance of this page?
 * 4) Raise your hand when you are done to have your Gradebook checked for accuracy.
 * 5) When done, you will become a coach and help other teams in the class complete their gradebooks.
 * 6) After everyone is done, we will review the activity as a class. Be prepared to be called upon to share how you solved each problem.
 *  Gradesheet ||
 * || Class Assignment 1 || Class Assignment 2 || Class Assignment 3 || Class Assignment 4 || Class Asssignment 5 || Total ||
 * Adams ||  20 || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 30  || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 30  || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 15  ||   || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 95  ||
 * <span style="font: normal normal normal 9px/normal Arial; letter-spacing: 0px; margin: 0px;">Lee || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 10 || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 23  || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 32  || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 23  ||   || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 88  ||
 * <span style="font: normal normal normal 9px/normal Arial; letter-spacing: 0px; margin: 0px;">Nickel || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 15 || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 10  || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 15  || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 8  ||   || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 48  ||
 * <span style="font: normal normal normal 9px/normal Arial; letter-spacing: 0px; margin: 0px;">Ranch || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 23 || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 17  || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 14  || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 20  ||   || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 74  ||
 * <span style="font: normal normal normal 9px/normal Arial; letter-spacing: 0px; margin: 0px;">Smith || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 40 || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 15  || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 8  || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 13  ||   || <span style="display: block; font: normal normal normal 9px/normal Arial; margin: 0px; text-align: right;"> 76  ||