SECOND SPREADSHEET PROJECT ASSIGNMENT



MAKE A NEW VERSION OF THE GRADE BOOK

Some teachers use a grading scheme in which the lowest score is dropped.  
Starting with a copy of the grade book you created for the first 
spreadsheet project, add another column which calculates the final score by 
dropping the lowest score and averaging the remaining scores.  Then create 
a line graph that graphs the old (raw) averages versus the new (adjusted) 
averages.  

SUGGESTION

Start by making a duplicate of a finalized version of your first 
spreadsheet.  Since version #4 shows formulas, you should use version #3.  
Make a copy of version #3 under a new name by using the "Save As" option in 
the File menu.  Next modify the copy of version #3 to create the new grade 
book.  This way, you know that if you have to, you will be able to start 
over, beginning by making another copy of the original of version #3.

FORMAT

For the numerical entries, adhere to the formatting standards described in 
the first spreadsheet project assignment.

NOTE ON GRADING CRITERIA

Your grade book will be graded for accuracy and readability. Think about 
using boldface or other formatting 'tricks' to make your spreadsheet more 
readable.  Be very attentive to checking the correctness of your formulas.  
This will count heavily. Just because an answer appears in a cell, does not 
mean you have the CORRECT answer.

WHAT TO TURN IN

Turn in three separate printouts: one printout showing the new version of 
the spreadsheet *values*, one printout showing all the *formulas*, and one 
printout showing both the raw and adjusted averages on one line graph.  
Everything must be labelled appropriately, so that there is no mistaking 
what one is looking at.

THE DUE DATE FOR THIS PROJECT

Check the class schedule for the due date.  Late projects will not be 
accepted.

HOW TO TURN IN THIS PROJECT

Turn in the project in class on the due date or on any class day before the 
due date.  Put your paper on the desk before class starts.

================================================== 
==================================================