NQ Administration

NQ Administration Principles for Marking ITFM and ITFA Eileen McHugh and Anne Bradley Understanding Standards

GENERAL PRINCIPLES • For all features or functions used one mark is awarded – may be a ceiling/maximum • Keying-in of data awarded marks proportionately • More complex features awarded 2 Understanding Standards

Mark Allocation - Database Intermediate 1 level only Creating a database task: Accuracy is important as this is where maximum marks can be gained Understanding Standards

Mark Allocation - Database Within a database task: Add a record -2 Deletions -1 Formatting –1 Sorting - 1 or 2 Printing – 1 or 2 All LEVELS Understanding Standards

Mark Allocation - Database SEARCH/QUERY Per criteria – 1 Aggregated and calculated fields – 2 Field names – 1 Formatting of new fields – 1 Printing – 1 or 2 Understanding Standards

Mark Allocation - Database FORMS Creation/print - 1 Headers and footers – 1 each Logo - 1 Order - 1 Specified fields - 1 Field formatting- 1 Understanding Standards

Mark Allocation - Database REPORTS – Intermediate 2 Creation/print - 1 Fields – 1 Title - 1 Headers and footers – 1 each Understanding Standards

Mark Allocation - Database REPORTS – Higher Logo – 1 Grouping – 1 Sorting – 1 Field headings -1 Calculations -1 Formatting of new fields -1 Understanding Standards

Mark Allocation - Database LABELS Correct selection of fields - 2 Sort -1 Header/footer - 1 Understanding Standards

Mark Allocation - Spreadsheet Intermediate 1 level only Creating a spreadsheet task: Accuracy is important as this is where maximum marks can be gained Understanding Standards

Mark Allocation – Spreadsheet Creation – 1 Insertion of rows and columns – 1 Deletion of rows and columns – 1 Formatting – 1 Input data – 1 or 2 Sorting - 1 or 2 Linking and naming – 1 All LEVELS Understanding Standards

Mark Allocation – Spreadsheet Formulae and Functions All basic formulae – 1 Complex arithmetic formulae – 2 Absolute cell (named) – 1 Use of sum and average function Understanding Standards

Mark Allocation – Spreadsheet IF STATEMENTS 1 or 2 marks depending on complexity Nested IF – 3 marks Understanding Standards

Mark Allocation – Spreadsheet Higher only V/H lookups - 2 Sumif - 2 Countif – 2 Rounding/up/down – 1 Grouping/Subtotals – 1 or 2 Comments – inserting/deleting – 1 Understanding Standards

Mark Allocation – Spreadsheet REPLICATION All LEVELS 1 mark each time to a maximum of 2 per worksheet. Understanding Standards

Mark Allocation – Spreadsheet PRINTING Value view – 1 Formulae view – 1 at Int 1 Formulae view – 0 at Int 2 and Higher Specific instructions – 1 Understanding Standards

Mark Allocation – Spreadsheet CHARTS Correct data and chart – 1 Labels and headings – 2 Key/legend and Series – 1 (not at higher) Printing – 1 (not at higher) Understanding Standards

Mark Allocations – Word Processing LAYOUT OF BUSINESS DOCUMENTS Memos - 2 Letters – marks depend on problem solving element/instruction Other business documents - 2 Understanding Standards

Mark Allocations – Word Processing FORMATTING Marks depend on the instruction/problem solving element Understanding Standards

Mark Allocations Word Processing INSERTING TEXT Set maximums for each level These are approximate and can vary slightly at each level Manuscript corrections are part of the keying-in mark per flagged section At Int I level the manuscript correction is allocated a separate mark Understanding Standards

Mark Allocations – Word Processing TABLES Creation and text – 1 Deletion of text – 1 Calculation – 1 Sort - 1 Understanding Standards

Mark Allocations – Word Processing TABLE OF CONTENTS Headings – 2 Separate page - 1 Understanding Standards

Mark Allocations – Word Processing Miscellaneous Functions ALL OF THE FOLLOWING ARE ONE MARK Comments Headers/Footers Page numbers/breaks Orientation Footnotes/Endnotes Inserting file(s) Mail Merge – 1 or 2 Understanding Standards

Workshop Understanding Standards

NQ Administration