Guro Hub
๐Ÿ“ŠClassroom Management System

TeacherEase โ€” Complete Classroom Management System

A connected spreadsheet system for student records, attendance, grades, and parent communication.

Overview

About TeacherEase Classroom Management

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.

The TeacherEase Complete Classroom Management System is designed for teachers who want to organize student information, track attendance, calculate grades, monitor performance, identify at-risk students, and document parent communication โ€” all from one connected Excel workbook. You enter information once in the Student Masterlist and Settings. Every other sheet โ€” Attendance, Gradebook, Performance, At-Risk Students, Analytics, Reports โ€” updates automatically through formulas and dropdown menus. No manual cross-referencing. No duplicate data entry.

Our Philosophy: Technology in the classroom should serve the teacher, not become an added administrative burden. TeacherEase is explicitly built not as a substitute for thoughtful pedagogy or meaningful teacher-student relationships, but as an administrative co-pilot. By automating repetitive task work like manual tallying, cross-referencing names, and calculating weighted component grades, educators gain back valuable time to focus on what matters most: inspiring students, preparing engaging lessons, and providing timely individual support.

Key Features

13 Interconnected Worksheets & Modules

Explore each worksheet included in the TeacherEase system.

13 Connected Worksheets
๐Ÿ“ŠOverview

Dashboard

An executive overview that automatically aggregates key metrics from every other sheet โ€” total students, active count, class average, passing rate, and at-risk count.

View sheet details โ†’
๐Ÿ‘ฅData Entry

Student Masterlist

The 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.

View sheet details โ†’
โœ…Tracking

Attendance Tracker

Record daily attendance using simple codes: P = Present, A = Absent, L = Late, E = Excused. The sheet automatically calculates totals and attendance percentage per student.

View sheet details โ†’
๐Ÿ“Grading

Gradebook

An automated gradebook supporting DepEd's WW/PT/Exam grading structure. Enter raw scores and the sheet calculates weighted percentages, final grades, and remarks automatically.

View sheet details โ†’
๐Ÿ“ˆMonitoring

Student Performance

Automatically compares previous grades to current grades, showing the change, trend direction, and overall performance status for each student.

View sheet details โ†’
โš ๏ธIntervention

At-Risk Students

Automatically identifies students at risk based on failing grades, low attendance, or missing assessments. Track interventions and follow-up dates.

View sheet details โ†’
๐Ÿ“Analysis

Class Analytics

Statistical analysis of class performance โ€” mean, median, mode, standard deviation, score distribution, and grade ranges.

View sheet details โ†’
๐Ÿ“„Reports

Student Report

Generate a printable individual student report by selecting a student from a dropdown. Shows profile, grades, attendance, and performance status in one clean layout.

View sheet details โ†’
๐Ÿ“žCommunication

Parent Communication Log

Document every parent communication โ€” phone calls, messages, emails, conferences. Track reasons, summaries, follow-up requirements, and status.

View sheet details โ†’
๐Ÿ—“๏ธPlanning

Teacher Planner

Manage your tasks with priorities, due dates, and automatic days-remaining calculation. Categories include Lesson Planning, Grading, Meetings, and Admin.

View sheet details โ†’
๐Ÿ“‹Assessment

Assessment Tracker

Track all assessments โ€” quizzes, activities, projects, exams โ€” with type, date, total points, weight, status, average score, and pass rate.

View sheet details โ†’
โš™๏ธConfiguration

Settings

Central configuration hub. Set teacher name, school name, school year, grading weights (WW/PT/Exam), passing grade threshold, and class information.

View sheet details โ†’
Workflow

How It Works

Simple 3-step connected workflow designed for zero duplicate data entry.

1
โœ๏ธ

Enter Data Once

Add student details once in the Student Masterlist and configure your grading weights in Settings. You never need to type names or IDs again.

2
โšก

Watch Everything Connect

Log daily attendance and raw assignment scores. Built-in formulas automatically compute component percentages, final grades, and at-risk indicators.

3
๐Ÿ“Š

Generate Reports Automatically

Select any student from a dropdown to generate clean, printable individual progress reports, class statistics, and parent communication logs.

Key Benefits

Why Teachers Use TeacherEase

Designed around DepEd grading structures and everyday classroom needs.

  • โœ“

    Substantial Time Savings

    Eliminates repetitive data entry across attendance records, gradebooks, and individual student reports.

  • โœ“

    Computation Error Reduction

    Automated formula calculations for Written Works, Performance Tasks, and Exam weights prevent grading mistakes.

  • โœ“

    Better Class Organization

    Consolidates student profiles, attendance, grades, and task planning into 1 structured workbook.

  • โœ“

    Early Learner Intervention

    Automatically flags struggling students based on grade thresholds and attendance drops before terms end.

  • โœ“

    Professional Documentation

    Provides clean, print-ready individual student summaries and parent communication logs for conferences.

Target Audience

Who It's For

Filipino K-12 Teachers & Advisers: Built specifically for elementary, junior high, and senior high school teachers handling a primary class or advisory section who want to digitize their records without paying for subscription software.

Teachers Seeking Simplicity: Ideal for educators who have basic spreadsheet familiarity (entering data, selecting from dropdowns) but don't want to build complex formula systems from scratch.

Offline-Ready Classrooms: Works 100% offline in Microsoft Excel or LibreOffice Calc โ€” no stable internet connection required for daily attendance or grade recording.

๐Ÿ‡ต๐Ÿ‡ญ

Tailored for Philippine school requirements and DepEd grading components (WW / PT / Exam).

Questions & Answers

Frequently Asked Questions

Common questions regarding compatibility, usage, and setup.

Is this free?โ–ผ

Yes. The spreadsheet is free for individual teacher use. You may customize it for your own classroom.

Do I need Excel to use it?โ–ผ

No. It works in Google Sheets, LibreOffice Calc, and Numbers (macOS) as well. All formulas use standard functions.

How many students can it handle?โ–ผ

It's pre-formatted for 50 students per class. You can extend formulas to handle more by dragging them down.

Can I track multiple classes?โ–ผ

This version is designed for one class. Duplicate the workbook for additional classes, or upgrade to TeacherEase Pro for multi-class support.

Are there macros or add-ins?โ–ผ

No. All automation is formula-based. No macros, no VBA, no plugins. Just standard Excel functions.

Will it work on my phone?โ–ผ

Yes, in the Excel mobile app or Google Sheets app, though the small screen makes data entry less convenient.

Technical Details

Version & Compatibility Info

Version

1.0.0

Last Updated

August 2026

File Size

~86 KB

Format

.xlsx

Software Compatibility

Microsoft Excel 2016+Google SheetsLibreOffice CalcNumbers (macOS)

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
License: 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.

Ready to Streamline Your Classroom Records?

Download the TeacherEase Classroom Management System spreadsheet and get your student masterlist configured in minutes.

Related Teaching Resources & Tools