AO5

Name: / Group: / Tutor:

Unit 1 – ICT Skills for Business

Pupil Record Sheet

AO5 – Create and use a simple business spreadsheet.

OCR Nationals ICT Level 2 Moulton School ICT Department

Pass- Level 4 / Tick
Box / Merit- Level 5 / Tick
Box / Distinction- Level 6/7 / Tick Box
I have created a very simple business spreadsheet using a limited number of calculations. / I have created an effective business spreadsheet displaying accurate figures. / I have created an effective business spreadsheet displaying accurate figures.
The functions/formulas may not be efficient, but do still work. / I have used several different formulas and at least one function. / I have used formulas efficiently and have included the appropriate use of more than one function.
I have used sufficient row/column headings to make the spreadsheet reasonably easy to understand. / I have edited the spreadsheet by inserting/deleting rows. / I have edited the spreadsheet by inserting/deleting rows.
I have shown some formatting but there is little evidence. / I have shown some evidence of a range of formatting. / I have formatted the spreadsheet effectively using a range of format options.
I have shown evidence that some of the data has been changed to obtain different results. / I have shown evidence that some of the data has been changed to obtain different results. / I have shown evidence that some of the data has been changed to obtain different results.
I have printed out the spreadsheet although the format of these print outs might not be suitable. / I have previewed and printed out the spreadsheet using appropriate page orientation and number of pages. / I have previewed and printed out the spreadsheet using appropriate page orientation and number of pages.
I have used appropriate headers and footers and have set other print layout features appropriately.
Date: / Pass / Merit / Distinction
Comments:

OCR Nationals ICT Level 2 Moulton School ICT Department