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.)
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.
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
NOTE ON GRADING CRITERIA
- Your Name,
- "CS 4000",
- "Second Spread Sheet Project"
- "Min Score Dropped"
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
WHAT TO TURN IN
three separate printouts:
Everything must be labelled appropriately, so that there is no mistaking what
one is looking at.
- one printout showing the new version of the spreadsheet values,
- one printout showing all the formulas, gridlines, row & column
- one printout showing both the raw and adjusted averages on one line
THE DUE DATE OF SPREADSHEET ASSIGNMENT #2
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.