1 / 24

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.

Download Presentation

NQ Administration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


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

  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 Understanding Standards

  3. 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

  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 Understanding Standards

  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 Understanding Standards

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

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

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

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

  10. 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

  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 Understanding Standards

  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 Understanding Standards

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

  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 Understanding Standards

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

  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 Understanding Standards

  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) Understanding Standards

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

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

  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 Understanding Standards

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

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

  23. 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

  24. Workshop Understanding Standards

More Related