first spreadsheet

( Latest revision: October 2008 )

FIRST SPREADSHEET PROJECT ASSIGNMENT

IMPORTANT

Read all these directions before starting to do this project.

MAKE A GRADE BOOK

Create a grade book for a class of 10 students. Build the spreadsheet across a page, with each graded activity having one column and each student having one row.

The first column of the grade book must contain the student names, written in the form: last name, first name. Note: It is important that the names not be in alphabetical order when you enter them originally.

The grade book must include at least seven graded activities for each student. The activities can be exams, quizzes, projects, or what have you. You must use the same scale for all the activities. For example, all activities could be worth 100 points, or all could be worth 25 points. Each column must have a title indicating the content of that column.

Finish entering all the data into the grade book, including numerical grades for all the activities of all the students. Make sure that all the grades are uniformly and appropriately formatted (a fixed, right-justified decimal representation with no more than two digits to the right of the decimal point). Create a title, header, or footer containing your name, "CS 4000", "First Spreadsheet Project" and "Version #1". Next save and print the grade book.

Next, sort the spreadsheet in ascending order, according to the last names of the students. Make sure that the sorting keeps each student name together with its row of grades! Alter your title, header, or footer to identify the document as version #2, and print this sorted version. Save the document under a name different from version #1.

Now add a column of formulas which show, for each student, the average of her/his seven grades. Also add a row of formulas that give, for each activity, the average student score. You must use formulas to create this column and row. Add titles for your new column and row. Alter your document title, header, or footer to identify the document as version #3. Format the new cells so that all numbers are displayed uniformly with an appropriate decimal format, as described above. Save the document under a name different from versions #1 and #2. Now print the grade book showing the values for the averages.

Finally, alter your title, header, or footer to identify the document as version #4 and print the grade book again showing the formulas you used. This last printout is very important. I need to be able to verify that you have used correct formulas. (In Excel, you can toggle the formula-display mode with the key combination: ctrl-` ("control-backquote"). In Appleworks, you choose Display from the Options menu and then check the Formulas box.)

Because the formulas take up a lot of room, you may need to make some cells larger so that the entire formula is displayed. If I can't see the entire formula, I may not be able to give you full credit. This is your responsibility.

MAKE SURE TO SAVE YOUR WORK

For the second spreadsheet project, you will be asked to make a new version of the grade book. In order to avoid considerable duplication of effort, be sure to keep a copy of version #3.

NOTE ON GRADING CRITERIA

Your grade book will be graded for accuracy and readability. Consider using boldface for some cells, or other formatting 'tricks' to make your spreadsheet more readable. Be very attentive to checking the correctness of your formulas. This will count heavily. After you succeed in making an answer appear in a cell you need to verify it.

WHAT TO TURN IN

You must turn in one copy of each of the four printouts you made.

THE DUE DATE OF SPREADSHEET ASSIGNMENT #1

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 'counter' before class starts.