To achieve a Pass you must show you can:

To achieve a Merit you must also show you can:

To achieve a Distinction you must also show you can:

P1 describe clearly the user’s needs, the information to be processed and the processing required

M1 use software effectively to sort on multiple fields, make use of cell relationships and produce good quality printed copy, showing both data content, formats and formulae (clear and detailed annotation, screen prints or notes must explain why and how all printed items are produced)

D1 show an in-depth understanding of database and spreadsheet systems and evaluate your work to make suggestions for improvement and to describe any problems experienced

P2 create table structures using suitable field names, field lengths, data types, primary keys and relations

M2 make good use of titles, graphic lines, spacing, text size, text enhancement, column and row headers, page headers or footers and graph labels to enhance the presentations, making them easy to read and free of layout errors

D2 use technical language fluently and produce clear, coherent and comprehensive explanations and annotations

P3 create and use suitable spreadsheet row heights, column widths, cell formats, titles, cell references, IF … THEN statements, arithmetic functions and formulae

M3 show you have checked your work for accuracy and corrected obvious errors

D3 make effective and efficient use of complex search criteria on related tables, formulae and absolute cell references to produce the desired outcomes.

P4 use your data-processing skills to enter data, sort, search, calculate, predict results, produce different types of charts or line graphs and create printed reports using related tables

M4 work independently to produce your work to agreed deadlines by carrying out your work plans effectively

P5 produce printed copy showing that you have met the above requirements and explaining your work (this may include screen prints or annotated data output)

M5 organise your work so that it shows clearly how it progresses from the design stage to completion and evaluation.

P6 check the accuracy of your data and keep backup copies of all files.