Download Classroom Management System
A connected spreadsheet system for student records, attendance, grades, and parent communication.
TeacherEase โ Complete Classroom Management System
A complete classroom management system built in Excel. Enter student data once and watch attendance, grades, performance trends, and at-risk flags update automatically across 13 connected worksheets.
Quick Feature Overview
Includes all 12 core modules built into the workbook
Dashboard
OverviewAn executive overview that automatically aggregates key metrics from every other sheet โ total students, active count, class average, passing rate, and at-risk count.
Student Masterlist
Data EntryThe central student database. Every other sheet references this data. Enter Student ID, name, sex, birthdate, age, parent/guardian, contact, email, address, enrollment status, and notes.
Attendance Tracker
TrackingRecord daily attendance using simple codes: P = Present, A = Absent, L = Late, E = Excused. The sheet automatically calculates totals and attendance percentage per student.
Gradebook
GradingAn automated gradebook supporting DepEd's WW/PT/Exam grading structure. Enter raw scores and the sheet calculates weighted percentages, final grades, and remarks automatically.
Student Performance
MonitoringAutomatically compares previous grades to current grades, showing the change, trend direction, and overall performance status for each student.
At-Risk Students
InterventionAutomatically identifies students at risk based on failing grades, low attendance, or missing assessments. Track interventions and follow-up dates.
Class Analytics
AnalysisStatistical analysis of class performance โ mean, median, mode, standard deviation, score distribution, and grade ranges.
Student Report
ReportsGenerate a printable individual student report by selecting a student from a dropdown. Shows profile, grades, attendance, and performance status in one clean layout.
Parent Communication Log
CommunicationDocument every parent communication โ phone calls, messages, emails, conferences. Track reasons, summaries, follow-up requirements, and status.
Teacher Planner
PlanningManage your tasks with priorities, due dates, and automatic days-remaining calculation. Categories include Lesson Planning, Grading, Meetings, and Admin.
Assessment Tracker
AssessmentTrack all assessments โ quizzes, activities, projects, exams โ with type, date, total points, weight, status, average score, and pass rate.
Settings
ConfigurationCentral configuration hub. Set teacher name, school name, school year, grading weights (WW/PT/Exam), passing grade threshold, and class information.
System Requirements
- Microsoft Excel 2016 or newer, or Google Sheets, or LibreOffice Calc 7.0+
- Basic familiarity with spreadsheets (entering data, using dropdown menus)
- No macros or add-ins required โ all automation is formula-based
Installation Instructions
- 1Download the file: Save the
.xlsxfile directly to your desktop or laptop computer. - 2Open in Excel or Google Sheets: Double-click to launch in Microsoft Excel 2016+ or upload to Google Drive for online access.
- 3Go to Settings sheet: Configure your school year, section details, and default grading parameters.
- 4Enter teacher/school info: Customize subject names, teacher profile, and DepEd grading weights (Written Works, Performance Tasks, Exam).
- 5Go to Student Masterlist & start adding students: Enter student LRN/IDs and full names. All other 12 sheets will automatically sync!
License & Usage Terms
Free for individual teacher use. You may customize the workbook for your own classroom. Please do not redistribute or resell the file. Share the download page link instead.
Related Resources
TeacherEase Pro
Explore our full suite including curriculum mapping, lesson planners, and workload trackers.
Interactive ToolsTeacher Tools & Utilities
Timers, randomizer, seating chart generator, and classroom management apps.
PedagogyTeaching Strategies
Actionable guides on formative assessment, differentiated instruction, and class culture.