AppleWorks/ClarisWorks Practice Activity 2
Back to Spreadsheet Main Menu
IMPORTANT: YOU MAY WANT TO PRINT THESE INSTRUCTIONS OUT IN ORDER TO REFER TO THEM AS YOU COMPLETE THE ACTIVITY; TO PRINT THIS DOCUMENT, SELECT PRINT FROM THE FILE MENU.
Opening the Program
PC Look for the AppleWorks (ClarisWorks) Program Icon in the Quick Start menu (Windows 98 and above), in the Start menu (Programs), or in the C drive under Program Files: Microsoft Office. When prompted, double click on the Spreadsheet option.
Mac Either look for the AppleWorks (ClarisWorks) Program Icon in the launcher, or in the Applications folder of the Hard Drive, or in the Microsoft Office Folder on the Hard Drive. When prompted, double click on the Spreadsheet option.
Note: When you see terms enclosed with brackets (e.g., <return>) it is asking you to strike that key.
Items in bold are highlighted to show what is to be typed into a cell. They do not need to be typed in bold.
1. Cell A1 should be highlighted, type: Last Name <return>
2. Fill in the last names as listed below and pressing <return> after each one.
3. Click on cell B1 and type: First Name <return>
4. Fill in the last names as listed below and pressing <return> after each one.
5. Follow the same procedure to fill in Test 1, Test 2, and Final Scores as listed below.
Last Name First Name Test 1 Test 2 Final
Roe Rachel 86 83 83
Doe John 72 80 76
Moe Noah 66 58 68
Coe Karen 90 97 97
Calculate average score for each student
1. Click on F1 and type: Average <return>
2. In F2, type: = AVERAGE(C2..E2) <return> (Don't forget = sign!) The number 84 should appear.
3. In cell F3, type: =AVERAGE(C3..E3)
4. In cell F4, type: =AVERAGE(C4..E4)
5. In cell F5, type: =AVERAGE(C5..E5)
Change a score (and the average).
1. For example, you notice that Karen Coe's score on Test 2 should be 94, not 97.
2. Click on that cell and type 94. click away (note that her average is automatically adjusted).
Round off decimals.
1. Highlight all of Column F by clicking on the letter F.
2. From Format menu, click on Numbers.
3. Choose Fixed.
Create a space between column headings and names and scores
1. Highlight all of row 2 by clicking on the number 2
2. From Calculate menu, select Insert Cells.
Adjust width of columns
1. Move the mouse to the border of C and D. The mouse changes to an arrow. Click and drag to left so that there is only room for the words Test 1.
2. Do the same for all columns so that they are evenly proportioned.
Calculate the Standard Deviation for Each Student
1. In cell B9 type: Stan. Dev
2. In cell C9, type: =STDEV(C3..C6) <return>
3. In cell D9 type: =STDEV(D3..D6)
4. In cell E9 type: =STDEV(E3..E6)
5. In cell F9 type: =STDEV(F3..F6)
Give final exam twice as much weight as the other tests
1. Click on Cell F3.
2. Type: = (C3+D3+E3+E3)/4 <return>
3. In cell F4 type: =(C4+D4+E4+E4)/4
4. In cell F5 type: =(C5+D5+E5+E5)/4
5. In cell F6 type: =(C6+D6+E6+E6)/4
Center data entries in cells
1. Highlight the test scores from C3 through F9.
2. From Format menu, select Alignment and Center.
Sort by alphabet
1. Highlight from cell A3 through F6.
2. From Calculate menu, select Sort.
3. Click OK in the box that appears. (Your spreadsheet is now sorted by last name in ascending or alphabetical order)
Save Your Spreadsheet
1. Under the file menu select Save As.
2. Type in a name for your spreadsheet and choose a location to save to (disk, hard drive).
3. Click OK
Quitting the Program
1. After saving your work, select Quit from the File menu.