Formatting a record of pupils' achievements
This spreadsheet shows a simple record keeping system in which codes are used to record pupils' attainments in relation to ten learning objectives (LO1 to LO10). The spreadsheet can be sorted and formatted to make it clearer and more informative.
Download the file - record.xls 
To sort the pupil list on any learning objective:
- Select any cell in the data part of the spreadsheet and select Sort... from the Data menu.
- Select the desired LO from the drop-down menu in the resulting dialog.
- Click OK and the data will be sorted on the chosen learning objective.
- By looking at the selected LO, you should see that pupils with the same level of achievement have been grouped together.
- To save this sorted data, click on the Select All button (the grey cell in the top left of the spreadsheet where the column headings and row labels meet) to select the entire sheet.
- Select Copy from the Edit menu.
- Go to the sheet tabs in the bottom left of the spreadsheet and select a blank worksheet by clicking on a tab. If no blank sheets are available, select Worksheet from the Insert menu.
- Paste the sorted data in to the blank worksheet using Paste in the Edit menu.
- Go back to the original data by clicking on the appropriate tab.
To highlight levels of achievement to gain a clearer overview of teaching effectiveness, you will need to use conditional formatting. To highlight a level of achievement :
- Click and drag from cell B2 to P20 so that just the codes are selected.
- Select Conditional Formatting from the Format menu.
- In the resulting dialog, use the drop-down menu to select "Cell Value Is" > "equal to" and type a code in the empty box on the right.
- Click on the Format... button to select a format for the data.
- Choose Bold and the colour red to highlight the chosen code.
- Click OK and the record sheet will clearly show the chosen level of achievement and indicate more clearly the levels of success (or lack of it!) across pupils/learning objectives.
- To save this view, repeat steps 5 to 9 above.
