( Latest revision: October 21, 2008 )

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 minimum" 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.)

REQUIREMENTS:
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 that all numbers have to be formatted the same way - with the same number of digits after the decimal point.

Remember to update the title, header, or footer of your spreadsheet. It should contain: 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: 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.