Using a Spreadsheet in Appleworks
Creating a Simple Grade Book
Open
a new spreadsheet document.
Enter
the following titles in row one: Student’s
Name, Test 1, Test 2, Test 3, Average
Starting
in row 2, list 5 student names in column A, using this format: Last name, first name
Adjust
the column width by double clicking on the line between the column headings
Enter
a test grade for each student in the cells for each of the 3 tests.
To
find the average for the first student on all 3 tests, click in cell E2.
Click
on the Paste Function button (fx).
Select
the Average function and click OK.
Click,
hold, and drag your mouse over the values in parenthesis in the entry bar to
select them.
Click,
hold, and drag your mouse from cell B2 to D2.
The
formula in the entry bar should now say =AVERAGE(B2..D2).
Click
on the Confirm Entry button(√).
The
first student’s average should be listed.
If you want the number displayed as a whole number: click on the Format menu, select Number, and
then choose Fixed. Type (0) in the box next to
Precision and Click OK.
Click
in cell E2 and drag your mouse down to E6.
Click
on the Calculate menu and select Fill Down.
All
of the students’ grades should now be averaged.
Click
in cell A9 and type “Class Average.”
Click
in cell B9.
Click
on the Paste Function button (fx).
Select
the Average function and click OK.
Click,
hold, and drag your mouse over the values in parenthesis in the entry bar to
select them.
Click,
hold, and drag your mouse from cell B2 to B6.
The
formula in the entry bar should now say =AVERAGE(B2..B6).
Click
on the Confirm Entry button(√).
The
first test’s average should be listed.
If
you want the number displayed as a whole number, see directions above.
Click
in cell B9 and drag your mouse to E9.
Click
on the Calculate menu and select Fill Right.
All
of the tests should now be averaged.
To
make a chart: Click on the Options menu
and select Make Chart
To
print: Select all the cells you want to
print, Click on the Options menu, and select
To
take off column & row headings:
Click on the Options menu, select Display, and uncheck the boxes.