Spreadsheet (AppleWorks)

Assessment Spreadsheet using Appleworks: by Mary Bucy

1. From the Dock, open AppleWorks
2. Click on Spreadsheet in the Starting Points box
3. Click the cursor in cell 1A. Type "Student Names" and press the return key
4. In Cell 1B, type "Pre-Assessment %"
5. In Cell 1C, type "Post-Assessment %"
6. In Cell 1D, type "(Net) Learning Gain %"
7. Click on the number 1 on the left column to highlight the entire row.
8. From the Format menu, select Style, Bold.
9. Click on the line between the letters at the top of the columns and drag to adjust the column width. (or double click to automatically set correct width)
10. In Column A, type the names of your students (first names only)
11. In Column B, type the pre-test scores (in percentages, or actual scores)
12. Click and drag the mouse to highlight all student names and pretest scores (cell 2A-?B)
13. From the Calculate menu, select Sort
14. In the Order Keys box, change A2 to B2. Click on the radio button next to Descending Order. Then click OK.
15. Divide your scores into four "clusters" from high to low. Clusters do not need to be even-sized.
16. Choose logical break-points between groups of scores. (You must have at least two students in each cluster.)
17. Click on the number in the left column next to the 1st name in your 2nd cluster, to highlight the row.
18. From the Format menu, select Insert Cells. This will insert a row of empty cells between Cluster 1 and Cluster 2.
19. Click on the number in the left column next to the 1st name in your 3rd cluster. Repeat step 17.
20. Click on the number in the left column next to the 1st name in your 4th cluster. Repeat step 17. In the 1st blank cell in column A, type "Cluster 1 Average."
21. In the 2nd blank cell, type "Cluster 2 Average."
22. In the 3rd blank cell, type "Cluster 3 Average."
23. In the cell after the last student name, type "Cluster 4 Average."
24. In Column C, type in the appropriate Post Test Scores for each student
25. In Cell D2, type: =C2-B2
26. Click and drag to highlight Column D from cell D2 to the last student listed.
27. From the Calculate menu, select Fill Down.
28. In Column D, highlight the 0 in each Cluster Average Row and press the delete key to clear it.
29. In the 1st blank cell in column B, type: =average(
30. Click and drag the mouse from the first score in the cluster to the last score in the cluster. This will enter the range of cells into the parentheses.
31. Then type ) to close the parentheses, and press the return key.
32. A number will appear in the blank cell which represents the average of the Cluster 1 scores.
33. To round the number to the nearest hundredth, click on the number to highlight it.
34. From the Format menu, select Number.
35. Click on arrows next to General and drag down to Fixed
36. Make sure Decimal Precision is set to 2
37. Click OK.
38. Click and drag to highlight your Cluster 1 Average and the 2 blank cells to the right of it.
39. From the Calculate menu, select Fill Right.
40. Repeat steps 29--39 for your Cluster 2, 3 and 4 averages.
41. Click on the number in the left column next to Cluster 1 Average to highlight the row
42. From the Format menu, select Style, Bold
43. Repeat steps 41-42 for your Cluster 2, 3, and 4 Averages

Charts

1. Click mouse on cell A1 and drag to the last filled cell in column D, to highlight all information.
2. From the Options menu, select Make Chart
3. Check to make sure the Bar chart option is highlighted.
4. At the bottom of the box, click on the Horizontal button. Click OK.
5. Click on the chart and drag it down the page until it is below the spreadsheet information, and placed near the left margin of the page.
6. Click on the lower right corner of the chart and drag to enlarge it until the student names are readable.
7. From the Window menu, select Page View
8. If the chart does not fit entirely on the first page, drag it down until it is on the 2nd page.
9. Check both your spreadsheet and your chart to see that all edges fall within a single page. If necessary, drag the corner of the chart or the spreadsheet smaller so that it doesn't extend over margins.