A professional, secure, and mobile-responsive web application for publishing student grades. This tool allows students to view their scores, class averages, and performance charts using a private ID.
- Secure Access: Privacy-focused login using unique hashed IDs.
- Data Visualization: Interactive charts comparing individual performance vs. class averages.
- Formal Design: Professional UI with Dark Mode support.
- PDF Reports: One-click generation of official grade reports.
- Universal: Works for any subject (Math, History, Science, etc.).
- Create a Google Sheet.
- Row 1: Headers (e.g., ID, Name, Test 1, Homework 2...).
- Row 2-8: Statistical metadata (Max Score, Average, Median).
- Note: Student data must start at Row 9.
- Column A: The unique Hashed ID for each student.
- In your Google Sheet, go to Extensions > Apps Script.
- Paste the code from
backend/Code.gs. - Click Deploy > New deployment.
- Type: Web App.
- Execute as: Me.
- Who has access: Anyone.
- Copy the resulting Web App URL.
- Open
js/app.js. - Paste your Web App URL into the
SCRIPT_URLvariable. - Open
index.htmland update the<title>and<h1>tags with your School/Subject name.
Upload the files to any web host (GitHub Pages, Netlify, etc.).