NCEA Level 1 Information Management (90035) 2007 — page 1 of 2

Assessment Schedule – 2007

Information Management: Manage information using spreadsheet and text applications (90035)

Evidence Statement

Task / Achievement / Achievement with Merit / Achievement with Excellence
ONE
Spreadsheet / A spreadsheet and graph are printed.
Most given text is entered correctly. / Most given text is entered correctly. / All given text is entered correctly.
Most given numerical data are entered correctly. / All given numerical data are entered correctly. / As for Merit plus:
Management of numerical data is effective (eg consistent number of decimal places).
A high-quality spreadsheet is produced that is easy to interpret.
There is some evidence to indicate management of numerical data. / There is clear evidence to indicate competent management of numerical data (ie all required figures are correct).
There is some evidence of formatting. / Text and numerical data are formatted competently.
Graph / A graph is evident. / A pie chart is evident (a line or bar graph is NOT suitable).
Only information on the average number of jobs is graphed. / Only information on the average number of jobs is graphed.
A heading or some accurate labelling is included which indicates what the graph represents. / Heading must reflect the purpose of the graph.
Accurate and relevant labelling is evident, including the percentage figures.
The graph is in proportion and displayed beneath the spreadsheet.
Formulae / Formulae are printed. / Correct formulae are used.
  • Allow B2+B3+B4 etc.
  • = average (B11,B12)
/ Functions are used for formulae that are consistent with spreadsheet and give correct results.
  • = sum(B2:B5)
  • = average(B2:B5)
  • = subtotal(109, B2:B5)
  • = subtotal(101, B2:B5)

Formulae are accurate but not most efficient. / All formulae are legible.
Task / Achievement / Achievement with Merit / Achievement with Excellence
TWO
Text application / Text has been retrieved, manipulated, reformatted appropriately and printed.
Information has been retrieved. / Information has been retrieved. / Information has been retrieved.
All text is evident.
There is evidence of information in column format. / Columns are used, but may not be even. / Columns are used effectively and reflect balance.
Some required formatting features are used to enhance the document. / Most required formatting features are applied competently. / Most required and additional formatting features are applied effectively to produce a high-quality document.
A border and shading has been applied to final paragraph (may include “Presentations” section as well). / Final paragraph has a border and shading applied.

Judgement Statement

The minimum requirements to meet each grade are set out below.

Achievement / Achievement with Merit / Achievement with Excellence
Task One – Spreadsheet / A / M / E
Task One – Graph / A / A / M
Task One – Formulae / A / M / E
Task Two / A / M / E