Paste your Apps Script Web App URL then click Connect.
MASKON Student Report System
📆 School Calendar
📋 Upcoming Events
Dashboard
Welcome back, Admin! 👋
Select campus to begin.
Active Term
—
Academic Year
—
Term Start
—
Term End
—
👩🎓
0
Students
👨🏫
0
Teachers
🚪
0
Classes
📚
0
Programs
📖
0
Subjects
✅
—
Present Today
⏰
—
Late Today
❌
—
Absent Today
📋
—
Permission Today
🏫 Class Progress
Loading...
📋 Recent Students
ID
Name
Class
Program
Term
Status
👩🎓 Students
👨🏫 Teachers
📊 Score Reports
📊
Select a Class and Term to load the gradebook
📋 Attendance Register
📋
Select a class and term
🏫 Campus
📅 Academic Years
🗓️ Terms
📚 Programs
🚪 Classes
📖 Subjects
📈 Score Summary
📈
Select a Class and Term to view the score summary
📝 Key Assessments & Teacher Comments
📝
Select a Class and Term
⚖️ Rubric Weights
⚖️
Select class, term, and subject to configure weights
🎓 Report Cards
🎓
Select a Class and Term to generate report cards
🏢 Buildings
🏢
No buildings yet
🚪 Rooms
🚪
No rooms yet
📅 Class Schedule
📅
Select a class to view its schedule
🏫 Add Campus
Basic Info
Logo
📁 Upload campus logo
📅 Academic Year
🗓️ Term
📚 Program
🚪 Class
📖 Subject
Foundation subjects appear in their own section on the report card.
💡 Choose Direct Mark for subjects not linked to any Rubric Weight. Choose Linked to Rubric Weights to enable the detailed HW/Quiz/Exam breakdown in Score Reports.
Tick classes that share this same subject
👨🏫 Add Teacher
Identity
Professional
Contact
Assignment
Select year first
Profile Avatar (auto-assigned)
?
Avatar is automatically generated from the teacher's name. It will update when you enter the name.
Login Credentials
Teacher can log in with this username/password to enter scores for their assigned classes only.
Digital Signature (for Report Card)
✍️ Upload signature image (PNG with transparent bg recommended)
👩🎓 Add Student
Identity
Contact
Academic Placement
Parent / Guardian
Profile Avatar (auto-assigned)
?
Avatar is automatically generated from the student's name. It will update when you enter the name.
📋 Mark Attendance
Student — Date
📅 Add Attendance Dates
Date Range
Include Weekends
Or Add a Single Date
⚙️ Configure Key Assessments
Add, remove, or rename assessment categories. Changes are saved to your browser (localStorage).
⚙️ Report Card Settings
School Information
📁 Upload School Logo
PNG, JPG recommended. Or paste URL below.
Grading Scale (Core Subjects)
Foundation Subjects
These subjects appear with a Performance rating (not a numeric score). They map to Key Assessment dropdowns.
Performance Scale (Foundation Subjects)
Personal & Social Development Skills
These are character/behaviour skills assessed with a progress rating per student.
Signatures
ℹ️ Automatic Signatures from Teacher Roles
Report cards now use signatures from teacher profiles automatically:
• Sig 1 — Homeroom teacher's uploaded signature
• Sig 2 — Program coordinator's signature (matched by student's program)
• Sig 3 — School director's signature (appears on every card)
To assign: go to People → Teachers, open a teacher, set their Role/Position
(School Director / Nursery Coordinator / etc.) and upload their signature there.
To remove a directly-uploaded signature below: click the ✕ Clear button next to it.
👥 Current Staff by Role
Set teacher roles in People → Teachers to assign signatures automatically.
Signature 1 — Homeroom Teacher (auto-linked from class)
Signature 2 — Coordinator
ℹ️ Coordinator signatures come from teacher profiles. Go to People → Teachers, set the teacher's Role to the appropriate coordinator, and upload their signature there.
Signature 3 — Additional Coordinator (Optional)
ℹ️ School Director signature comes from the teacher whose Role is set to School Director. Upload their signature in their teacher profile.
Signature 4 — School Director
Footer Text
🎨 Report Card Template Manager
📍 Template Scope
Class-specific overrides Term-wide → Year-wide → Global Default
🎨 Report Card & Key Assessment Templates
🗑️ Recycle Bin
📖 MASKON Help Guide
🚀 Getting Started — Setup Flow
Connect your Google Sheets API URL on the login screen
Go to Actions → Setup and run the sheet setup once
Create a Campus first (Setup → Campus)
Add an Academic Year linked to the campus (e.g. "2024-2025")
Create Terms (T1, T2, T3, T4) under the academic year with start/end dates. Mark one as Active.
Add Programs (Nursery, Early Years, Primary, Secondary)
Create Classes linked to campus, academic year, term, and program
Add Subjects per class, then configure Rubric Weights
Enrol Students and add Teachers with login credentials
👥 People — Students
Add Student: Click "+ Add Student" → fill name, ID, gender, DOB, class → save
Profile Icon: Upload a photo or pick an animal emoji from the picker
Edit: Click any row to open the edit modal. Photo is preserved across saves.
Search: Use the search box to filter by name or student ID instantly
Sort: Click any column header (ID, Name, Class…) to sort ascending/descending
👥 People — Teachers
Add Teacher: Fill name and subject. Credentials auto-generate when you leave the Last Name field
Auto-generate: Click "⚡ Auto-generate" anytime to create a new username/password
Password: Admin and System Admin can see the stored password in the edit modal (👁️ to show/hide)
Signature: Upload the teacher's signature image — stored separately to avoid size limits
Sort: Click any column header to sort the teacher list
📊 Academic — Score Reports (Gradebook)
Filters: Academic Year → Program (Primary/Secondary) → Term → Class
Enter scores per student per subject: Homework, Quiz, Exam, Participation, Project
Save All Scores — only changed cells are sent to the sheet (fast save)
Nursery and Early Years classes are excluded — use Score Summary for those
📈 Academic — Score Summary
Filters: Academic Year → Program (All / Nursery / Early Years / Primary / Secondary) → Term → Class
View per-term: total score, average, grade, rank for each student
School Year Report: Click "📊 School Year Report" to see T1–T4 side by side with overall average, grade, and last KA comment
Print A4 Landscape from inside the report
📝 Academic — Key Assessments & Report Cards
Key Assessments: Select Class + Term → enter assessment comments per student per criterion
Report Cards: Select Class + Term → Generate → preview cards → edit inline → Print All (A4, color-preserved)
Coordinator signature appears based on the program assignment set in Setup → Report Card Settings
School Director signature appears on all cards across all programs
📋 Attendance
Register: Select Class + Term → "+ Add Date" (date range picker with Sat/Sun toggles)
Multi-Class Dates: "+ Multi-Class Dates" to add the same date range to multiple classes at once
Mark status: Click cells to cycle: ✅ Present → ❌ Absent → ⏰ Late → 📝 Permission
Quick Take (mobile): "📱 Take Attendance" for large colored buttons per student
Save: Only changed records are sent — shows "X new + Y updated"
Daily Report: View daily/weekly/monthly/by-term summaries with Print support
⚙️ Setup — Subjects & Rubric Weights
Subjects table view: lists all subjects with code, class, term, year
Subjects card view (☑): groups subjects by class card — drag rows to reorder, click "+" on any card to add a subject directly to that class
Rubric Weights: Academic Year → Term → Class → Subject. Set % for Homework/Quiz/Exam/Participation/Project (must total 100%)
Card view in Rubrics shows all subjects with color-coded progress bars
⚙️ Setup — Buildings, Rooms & Schedule
Buildings & Rooms: Setup → Buildings & Rooms. Add buildings first, then add rooms linked to each building
Class Schedule: Campus → Academic Year → Term → Class. Configure custom days/periods with ⚙️ Configure
Click empty timetable cell to add a slot. Choose subject, teacher, room, and color.
Drag-and-drop slots to rearrange. Selected color shows a purple ring.
Views: █ Timetable | ☰ List | ☑ Cards. Print with 🖨️
⚙️ Setup — School Calendar
Select the academic year → 12-month grid with color-coded events
Click any day to open Add Event with that date pre-filled
Event types: Holiday, Exam, School Event, Term Date, Other
Upcoming Events shown below the grid. Print A4 Portrait.
🔧 Actions
User Management: Add admin, teacher, viewer accounts. Teacher accounts use the same username as their teacher profile.
RC Settings: Set school name, logo, coordinator and director signatures. Coordinator signature is assigned per program (Nursery/EY/Primary/Secondary). Director signature appears on all cards.
Promote Records: Move students from one class/term to the next
Recycle Bin: Restore or permanently delete records
📅 Attendance Dashboard
👥 User Management
Manage System Admin and Campus Admin accounts. Teachers are managed in the Teachers section.
User Details
📱 Take Attendance
Date:
✅ Present🔴 Absent🟡 Late🟠 Half-day
🏢 Add Building
🚪 Add Room
Add Event
📅 Add Slot
⚙️ Configure Schedule
e.g. Monday, Tuesday, Wednesday, Thursday, Friday, Saturday
Tip: use "Break" or "Lunch" for non-teaching slots
📅 Add Date Range to Multiple Classes
Select Classes
🚀 Promote Records
Copy records (Students, Teachers, Classes, Subjects, Rubric Weights, RC Templates)
from one Academic Year / Term to another.
Source
Destination
What to Promote
⚠️ Existing records in the destination with the same name/ID will be skipped.
Classes are promoted first so Students, Teachers and Subjects can be linked correctly.
📦 Transfer Student to Another Class
Destination
What to Transfer
⚠️ The student record and all selected linked data will be updated to the new class.
This cannot be undone automatically.
🤖
MASKON Assistant
🟢 Online — ask me anything
⚙️ Manage FAQ Q&A
Add questions and answers below. Teachers will see matched responses when they type.
🤖MASKON Assistant✕
👋 I'm your AI Assistant! Click to ask me anything.
📌 Assign Teacher to New Term / Year
Adds a new class assignment. The teacher keeps their same username, password and role
and will see all assignments when they log in.
New Assignment
⚠️ If a class with the same name exists in the target term it will be linked automatically.
🏫 Copy Data to Another Campus
Select what to copy, filter the source data, then choose the target campus.
New IDs are generated and campus assignments updated automatically.
Source Filter (optional)
Target Campus
AcademicYears, Terms & Programs will be copied as new records in the target campus.