Scribd
Upload
16 views2 pages

Student Report Card Generator Tool

The Student Report Generator is an automated tool for creating student report cards using Microsoft Excel and VBA, involving multiple sheets for data entry, marks input, and report generation. Users can add or remove students, assign subjects, and enter marks with password protection for each subject. The tool also features a class summary, report generation options, and a missed subjects tracker to ensure all marks are accounted for.

Uploaded by

kondwanimtambo888
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
16 views2 pages

Student Report Card Generator Tool

The Student Report Generator is an automated tool for creating student report cards using Microsoft Excel and VBA, involving multiple sheets for data entry, marks input, and report generation. Users can add or remove students, assign subjects, and enter marks with password protection for each subject. The tool also features a class summary, report generation options, and a missed subjects tracker to ensure all marks are accounted for.

Uploaded by

kondwanimtambo888
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Project: Student Report Generator

Technology Used: Microsoft Excel, VBA

Overview:

This tool automates the generation of student report cards and exports them as PDFs. It uses
two Excel files: "Book1" (the working file) and "Template" (used for formatting — do not edit
unless necessary).

Instructions:

1. Setup (Sheet1 - Student & Subject Entry):

- Enter student names in Column A.

- Click "ADD SUBJECT ENTRY" to register each student.

- To remove a student, select their name and click "DELETE SUBJECT ENTRY".

- Use checkboxes to assign subjects to students.

- Use subject buttons above columns to filter the student list by subject.

- Click "REMOVE FILTERS" to reset and show all students.

-The default password for sorting by 1st name is PASSWORD.

-There’s a search box that can be used to search for names.

2. Marks Entry (Sheet2):

- First, go to Sheet1 and filter by subject.

- Then go to Sheet2, click "APPLY FILTER", then "HIDE EMPTY NAMES" to show only students
taking that subject.

- Use "SHOW ALL SPACE" to manually unhide rows, or use "REMOVE FILTERS" in Sheet1 to
unhide all.

- You cannot enter marks for a student who is not registered for that subject in Sheet1.

- Each subject column in Sheet2 has its own password to prevent editing marks for the
wrong subject.
- The default passwords are the short forms of the subject's names (e.g., AGR, BK), all
uppercase. If uppercase doesn’t work try lowercase (that’s an error I often make).

-The default password for the whole Sheet is PASSWORD.

-Some cells on this Sheet are red/maroon/grey/darkened/ made to stand out in some way to
indicate that a student doesn’t take the Subject of that column.

-There’s also a search box that can be used to search for names.

-I intend to add a search box for looking up marks.

3. Data Display (Sheet3):

- Displays marks and positions for individual subjects.

- Do not edit this sheet unless you know what you are doing.

4. Class Summary & Report Generation (Sheet4):

- Displays class points and rankings.

- Also displays a list of the students sorted by positions in class

- To generate report cards:

- Click "CREATE REPORTS OF ALL" to generate for the whole class (takes time).

- Or double-click a student’s name to generate/update a single report card.

5. Missed Subjects (Sheet5):

-Shows students whose marks are missing for the subjects that they are registered for.

-Orange under a subject means that the marks have not been entered in Sheet 2.

You might also like