R060 Student Self-Reflector

Data manipulation using spreadsheets (West View Hotel)

Task 1: Planning & Design (23 Marks)

1A: Spreadsheet Design (Max 10)

Spreadsheet Design Planning of sheets, columns, and rows
Formula Planning Planning +,-,*,/ and functions (IF, VLOOKUP)
Chart/Graph Selection Identifying data to be visualised
Data Source Mapping How WVH CSV files will be used
Likely Mark: - 0

1B: Analysis of Brief (Max 13)

Purpose & Audience Explaining why WVH needs the spreadsheet
User Requirements Technical specs (Summary sheet, totals)
Hardware/Software List Tools needed for development
Constraints Analysis Legal (GDPR) or technical limits
Likely Mark: - 0
Task 2: Creation & Quality (23 Marks)

2A: Processing & Functions (Max 10)

Importing Data Integration of CSV assets correctly
Formula Implementation Use of IF, VLOOKUP, SUM, etc.
Likely Mark: - 0

2B: Presentation & Dashboard (Max 13)

Formatting & Consistency Currencies, dates, and cell styles
Chart Accuracy Correct axes, legends, and titles
User Navigation (UX) Buttons, clear labels, and flow
Likely Mark: - 0
Task 3: Testing & Review (14 Marks)

3A: Spreadsheet Testing (Max 7)

Test Coverage Testing of formulas and sorting
Results Documentation Screenshots of testing outcomes
Changes/Fixes Correcting errors found in testing
Likely Mark: - 0

3B: Review & Reflection (Max 7)

Review of Design Did it meet WVH requirements?
Software Evaluation Excel features used (VLOOKUP, etc.)
Lessons Learnt Future improvements for the system
Likely Mark: - 0

Likely Grade: 0 / 60