NQ ADMINISTRATION

1
NQ Administration
Principles for Marking ITFM and ITFA
Eileen McHugh and Anne Bradley
2
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

3
Mark Allocation - Database
Intermediate 1 level only
Creating a database task Accuracy is important
as this is where maximum marks can be gained
4
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
5
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
6
Mark Allocation - Database

• FORMS
• Creation/print - 1
• Headers and footers 1 each

Logo - 1 Order - 1 Specified fields - 1 Field
formatting - 1
7
Mark Allocation - Database

• REPORTS Intermediate 2

Creation/print - 1 Fields 1 Title - 1 Headers
and footers 1 each
8
Mark Allocation - Database

• REPORTS Higher

Logo 1 Grouping 1 Sorting 1 Field headings
-1 Calculations -1 Formatting of new fields -1
9
Mark Allocation - Database
LABELS

• Correct selection of fields - 2
• Sort -1
• Header/footer - 1

10
Mark Allocation - Spreadsheet
Intermediate 1 level only
Creating a spreadsheet task Accuracy is
important as this is where maximum marks can be
gained
11
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
12
Mark Allocation Spreadsheet

• Formulae and Functions

All basic formulae 1 Complex arithmetic
formulae 2 Absolute cell (named) 1 Use of
sum and average function
13
Mark Allocation Spreadsheet
IF STATEMENTS

• 1 or 2 marks depending on complexity

Nested IF 3 marks
14
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
15
Mark Allocation Spreadsheet

• REPLICATION

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

• Value view 1
• Formulae view 1 at Int 1
• Formulae view 0 at Int 2 and Higher
• Specific instructions 1

17
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)

18
Mark Allocations Word Processing
LAYOUT OF BUSINESS DOCUMENTS
Memos - 2 Letters marks depend on problem
solving element/instruction Other business
documents - 2
19
Mark Allocations Word Processing
FORMATTING
Marks depend on the instruction/problem solving
element
20
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
21
Mark Allocations Word Processing
TABLES
Creation and text 1 Deletion of text
1 Calculation 1 Sort - 1
22
Mark Allocations Word Processing
TABLE OF CONTENTS
Headings 2 Separate page - 1
23
Mark Allocations Word Processing
Miscellaneous Functions
ALL OF THE FOLLOWING ARE ONE MARK
Comments Headers/Footers Page numbers/breaks Orien
tation Footnotes/Endnotes Inserting file(s) Mail
Merge 1 or 2
24
Workshop