Open AppleWorks
Choose spreadsheet from new file type
Save to data disk as assignment 10
Use View/Page view
Use File/Page Setup/Orientation/Landscape
Use Format/Document/Margins Left=.25 Right=.25
Use Format/Document/Size Columns across=7 Rows down=21
Select all
Use Format/Column width = 100pt
Use Format/Row height = 25pt
Use Format/Size = 14pt
Deselect
In cell A1 type Grade Book for (your name)
In cell A3 type Name
In cell B3 type Test One
In cell C3 type Test Two
In cell D3 type Test Three
In cell E3 type Test Four
In cell F3 type Total Points
In cell G3 type Average
In cells A4...E7 type the following data:
Mary 45, 33, 44, 14
Bill 44, 40, 36, 20
Jim 39, 39, 36, 18
Sue 33, 41, 38, 15
In cell F4 type the formula =B4+C4+D4+E4
Select cells F4...F7
Use Calculate/Fill Down
In cell A9 type Total Points
Fill in points possible to cells B9...E9 (45, 45, 40, 20)
In cell F9 type the formula =SUM(B9...E9)
In cell G4 type the formula =F4/$F$9
Select cells G4...G7
Use Calculate/Fill Down
Use Format/Number/Percent
In cell A10 type Class Points
In cell B10 type the formula =AVERAGE (B4...B7)
Select cells B10...F10
Use Calculate/Fill Right
In cell A11 type Class Average
In cell B11 type the formula =B10/B9
Select cells B11...F11
Use Calculate/Fill Right
Use Format/Number/Percent
Select row 3
Use Format/Alignment/Center
Select A1...E7
Use Options/Make Chart/Bar
Move the chart to the lower right of the page
Save to disk
Use File/Print (turn off print column headings, row headings, and cell grid)
Submit printout for evaluation.