User Guide — Classroom Management System

Welcome to the TeacherEase Classroom Management System! This workbook is engineered to save you hours of repetitive data entry by auto-calculating attendance, grades, and risk status across 13 sheets.

1. Open the file in Microsoft Excel (2016 or newer) or upload it to Google Sheets.
2. Read the orientation overview on the START HERE sheet to familiarize yourself with color coding: white/blue cells are for data entry; gray/shaded cells contain formulas.
3. Save a clean master copy on your computer or Google Drive as a backup before entering live student data.

The Settings sheet acts as the command center. Information entered here propagates across all report headers, grade calculations, and summary sheets.

The Masterlist is the single source of truth. Every other sheet uses the Student ID to pull names and demographics automatically.

1. Student ID Format: Use a standardized ID format such as STU-001, STU-002, or official LRNs.
2. Name Entry: Type Last Name, First Name, and Middle Name in separate columns. The Full Name column concatenates them automatically.
3. Auto-Calculated Fields: Age automatically calculates from the Birthdate field using DATEDIF. Do not type manually in the Age column.
4. Enrollment Status: Select Active, Transferred, or Inactive from the dropdown menu. Transferred students will automatically be excluded from active class averages.

Record daily attendance in under 2 minutes using simple one-letter codes.

• Date Headers: Double-click row 4 date cells to select or type the exact calendar date for each lesson.
• Auto-Totals: Total Present, Absent, Late, Excused, and Attendance Percentage recalculate automatically on the right margin.
• Low Attendance Alert: Students whose attendance falls below 80% receive a soft highlight to prompt parent contact.

Designed around DepEd Form 138 / Class Record structure with automatic weighted score computation and transmuted final grades.

1. Set Max Scores First: Before typing student scores, enter the Maximum Score for each Written Work (WW), Performance Task (PT), and Quarterly Exam in Row 4.
2. Enter Raw Scores: Input raw student scores in the unshaded cells. Percentage scores compute automatically.
3. Weighted Average: The sheet multiplies WW %, PT %, and Exam % by their configured weights from Settings.
4. Final Transmuted Grade: The initial grade is converted to DepEd Transmuted Grade via automated lookup table logic.

View individual and class-wide academic trajectories. Compare quarter-by-quarter performance to spot growth or sudden drop-offs early in the school year.

• Tracks Quarterly Grades (Q1, Q2, Q3, Q4) and calculates the Final Rating.
• Shows automatic Performance Status badges: Outstanding (90-100), Satisfactory (80-89), Fair (75-79), Did Not Meet Expectations (<75).

Automated early warning system for academic failure and chronic absenteeism.

• Automatic Flagging: Any student with a grade below 75 or absences exceeding 3 consecutive days appears automatically on this list.
• Intervention Tracking: Enter remediation details, intervention dates, parent contact notes, and outcome status (e.g. Improved, Ongoing, Escalated).

Provides essential summary statistics required for school head reviews and DepEd SMEA (School Monitoring, Evaluation, and Adjustment) reports.

Generate individual student progress slips ready for printing or parent card distribution.

1. Go to the Student Report sheet.
2. Select a student from the dropdown menu at the top.
3. All fields (grades, attendance totals, conduct notes) populate instantly.
4. Press Ctrl + P (or Cmd + P on Mac) to print a clean 1-page progress report.

Document all phone calls, face-to-face dialogues, home visits, and messenger communications for accountability.

• Log Date, Student Name (dropdown), Guardian Name, Contact Number, Mode of Contact (Call, SMS, Visit), Reason, and Action Agreed.

Keep track of administrative deliverables, DepEd report submission deadlines, and lesson prep.

• Enter task details, priority level (High, Medium, Low), and due date.
• The Days Remaining column auto-calculates days left using TODAY() and highlights urgent tasks in red.

Catalog all quizzes, formative checks, summative tests, and performance tasks along with the corresponding DepEd Learning Competencies (MELCs / MATATAG).

• 1Follow the Setup Sequence: Settings → Student Masterlist → Attendance/Gradebook. Following this order guarantees smooth auto-population.
• 2Check the Dashboard Weekly: Spend 2 minutes every Monday reviewing the Dashboard metrics to catch failing or chronically absent students early.
• 3Keep a Monthly Backup: Save a copy named Classroom_Management_MonthYear.xlsx at the end of every month.