QQI Level 5N1977 Spreadsheet Methods Assessment Brief – Project

5N1977 ASSESSMENT BRIEF

Assessment Title	Project	Maximum Mark	50%
Programme/Centre	VESD/ Ennis	LOs to be assessed	1 – 10
Module/Component Name	Spreadsheet Methods	Date of Issue	01/10/2025
Module/Component Code	5N1977	Submission Date	07/12/2025 by 11.59pm

Instructions

Learner is required to:

Design, implement and modify a spreadsheet project will be based on a topic you have individually researched and decided upon.

The spreadsheet should contain at least 10 records with a minimum of 6 column headings. The data needs to include both character and numeric types, at least one main heading (merged), column/row headings, at least two different alignments and a range of cell formats e.g. currency, %, decimal.

Presentation Of Evidence

• Design Phase documentation included details of the project as specified.
• Implementation Phase documentation including PDF print outs as specified & soft copy of the project.
• Modification Phase documentation
• Reference your work – Ai is not permitted

Assessment/Performance Criteria And Marks

	Maximum Mark
Design		20
Project with aims clearly described (5) Investigate a range of common uses for spreadsheets (1) Demonstrate common spreadsheet usability features (1) Spreadsheet, data capture form and screen layouts well designed to include accurate detail (4) Specifications for input data, processing and output (4) Description of the proposed macro (2) Specification of the proposed graph (2) Description of how the filtering will be used in the assignment (1)
Implementation		25
Data and labels accurately inputted (4) Formulae and functions accurately applied (10) Chart and Macro clearly identified (2) Variable change clearly demonstrated (4) Versions of spreadsheet accurately saved and printed, showing the entire spreadsheet, the spreadsheet with formulae and after recalculation and after the use of a filter (5)
Modifications	Relevant modifications or improvements suggested	5

Submission Details