( Latest revision: October 22, 2006 )

## 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 (chart) that graphs the old (raw) averages versus the new (adjusted) averages. (In class, I'll explain how to do these things.)

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.

Remember to update the title, header, or footer of your spreadsheet. It should contain:
• "CS 4000",
• "Second Spread Sheet Project"
• "Min Score Dropped"
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 it is correct.

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, gridlines, row & column headings, 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 OF SPREADSHEET ASSIGNMENT #2

Check the class schedule for due dates.

HOW TO TURN IN THE ASSIGNMENT

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