That Blue Square Thing

Applied ICT A Level Unit 10 - Advanced Spreadsheets

Note: this page applies to the AQA Applied ICT A level specification. This exam was withdrawn in 2012, with final exams in 2013. The content will be retained as an archive and because it has some stuff that might be quite useful for someone or other

Circuit board imageSection D - Evaluation Criteria:

For each client need you need at least one evaluation criteria. You may want more than one.

You need to have the standard things:

It's then important to say clearly why each criteria is appropriate to assess a specific client need.

Presenting the Evaluation Criteria:

A tabular format is fine here.

No. Evaluation Criteria Quant or Qual? Client Need Why is this appropriate for assessing this need?
1 System is effectively password protected to avoid users editing cells other than those which require entryQual 5 Client specifies the need to avoid user error. Password protection of sheets is the most effective way to do this. Passwords should be secure rather than generic words.
2 VAT will be correctly calculatedQuant 3 Syst em needs to include VAT on all orders. This needs to be calculated separately using a named cell as the VAT rate may changed. Calculations need to be accurate as they form part of the costs paid by customers.

I would think that each client need would require at least one evaluation criteria.

Some of your qualitative evaluation criteria - for example, the layout and colour scheme of the interface for the spreadsheet - may need to be assessed by the client. You should make this clear in your criteria. You can then actually assess them before the exam by showing sketches and designs (see section E) to your client and getting their feedback. You'll need to show evidence that the work has their approval though, so perhaps some comments written on the designs would help.

The Markgrid:

Here's the markgrid...

Markgrid image for row d
Note: this markscheme is a copy of one which was available freely on the AQA Applied ICT webpages. It is copyright AQA and reproduced here simply to make access easier for students. No attempt to claim copyright is being made, although I could have copied the text into my own interpretation...