NQ Administration

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)

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

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

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

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

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

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

Workshop

NQ Administration