MZUZU UNIVERSITY
FACULTY OF SCIENCE, TECHNOLOGY & INNOVATION
DEPARTMENT OF ICT
Course: Computer Application (FOCA1201)
Assignment Title: Excel Grade Book and Report Card
Due Date: Monday 11 August 2025
Submission Format: Excel Workbook
Assignment Brief:
In this assignment, you are required to create a student grade book in Microsoft Excel that
automatically generates a report card using formulas, specifically the VLOOKUP function.
The aim is to help you gain practical experience using Excel for data management, grade
processing, and report generation, skills essential in real-world administrative and office
tasks.
Requirements
Your workbook must include the following components:
1. Grade Entry Sheet
A table that lists:
o Student IDs
o Names
o Courses
o Raw Scores (e.g., out of 100)
o Grade (A, B, C, etc. based on score)
2. Grading Criteria Sheet
A reference table with:
o Score ranges (e.g., 80–100)
o Corresponding letter grades (A, B, etc.)
o Remarks (e.g., Excellent, Good, Pass)
Use VLOOKUP to automatically assign grades and remarks in the Grade Entry Sheet.
3. Report Card Sheet
A template that:
o Retrieves student details (ID, Name)
o Lists all their courses and grades
o Displays their overall average
o Provides an overall remark (e.g., "Distinction", "Credit", etc.)
Use dropdowns or VLOOKUP to allow report generation by selecting a student ID.
Assessment Criteria
Criteria Marks
Correct use of VLOOKUP 25
Proper data organization and structure 20
Functional and dynamic report card 25
Use of formulas, formatting, and layout 20
Clarity, neatness, and professionalism 10
Total 100
Submission Guidelines
Submit one Excel workbook (.xlsx) with all required sheets clearly labelled.
Ensure your name and student ID appear on the Report Card sheet.
Send your work via email (thondoya.v@[Link])
If you need assistance with using VLOOKUP or setting up the report card, please refer to the
class notes or contact me during the week.
Best of luck!
Vision Thondoya
Computer Applications Lecturer
