✍️ Get Writing Help
Uncategorized

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

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

admin

Expert academic writer and education specialist helping students in the UK, USA, and Australia achieve their best results.

Need help with your own assignment?

Our expert writers can help you apply everything you've just read — to your actual assignment.

Get Expert Help Now →
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, how can I help?