Notes on Creating a Gradebook for EDU 360

Please develop a gradebook with at least 5 student names, 5 assessment measures, and two formulas. Please email the instructor the product as an MS Excel document.

Some notes on developing a gradebook

                       MS Excel, Microsoft's spreadsheet program, is designed for making simple
                       calculations automatically. It is a good tool for developing grade.

 Steps:

Create a new MS Excel document by opening the application.

Label cells A1 and B1 with firstname and lastname respectively.

In C1, write TOTAL.

Place the names of a series of assignments, tests, or other assessment
measures in the next 5 (at least columns - D1, E1, F1, G1, H1, ...

Add names and grades in cells A3, B3, D3, ... at least for 5 records (a horizontal
 line is a record) - A7, B7, D7, E7, F7, G7, H7, ....

FORMULAS
In cell C3, type =sum( and then highlight all of the grades on that
 line - record, then type the final ) to close the formula.  Press Enter.

 This should automatically sum the total of the scores.

 To copy this calculations to the other records, pull the little + (cross) that you
 will see when you place the cursor in the lower right hand corner of C3 down
across the other cells in column C where you would like the sum to appear. The
 sums should reflect the scores in each record.

Find the averages of each measure by placing your cursor in the box below the
scores for each measure. Type =average( and then highlight the scores in the
column. Type the final ) to close the formula.

To copy the average formula, pull the little + (cross) that you will see when you
place the cursor in the lower right hand corner of cell with the forumula across
the other cells on that line where you would like the sum to appear.

A bit complicated - I would be happy to consult with you in class, online, or during my office hours or by phone if you have any questions.