User Guide — TeacherEase Pro

TeacherEase Pro is our flagship 32-sheet management system. It integrates grading, lesson planning, curriculum alignment, behavior tracking, and administrative reports into a single, seamless Excel file.

1. Open the workbook and land on the Main Dashboard sheet.
2. Review the color-coded sheet tabs at the bottom: Blue (Overview/Dashboard), Green (Grades & Attendance), Purple (Curriculum & Lessons), Amber (Behavior & Engagement), Rose (Parent & Reports).
3. Always save a blank master template before entering live class data.

Configure global parameters on the Settings & Configuration sheet to set up default school branding and DepEd grading defaults.

1. Enter Teacher Name, Employee ID, School Name, School ID, Division, and Region.
2. Set default grading scale parameters (Written Works, Performance Tasks, Exam weights).
3. Set passing criteria (≥75) and target attendance thresholds (e.g. 80%).

Specifically designed for teachers handling multiple subjects or multiple sections (e.g. High School or Subject Specialists).

The heart of the entire 32-sheet workbook. Data entered here synchronizes across Gradebook, Attendance, Behavior, Conferences, and Report Cards.

1. Input Student ID/LRN, Last Name, First Name, Middle Name, Sex (M/F), Birthdate, and Contact Numbers.
2. Fill in Guardian details, address, and special medical/educational notes.
3. Use the Status dropdown (Active, Transferred, Dropped) to control active roster filters.

Track daily attendance across months with automatic monthly summary totals and percentage calculations.

• Use standard codes: P (Present), A (Absent), L (Late), E (Excused).
• View auto-calculated Monthly Summaries for DepEd Form 2 / SF2 reporting.

Complete DepEd Class Record spreadsheet with support for 10 Written Works, 10 Performance Tasks, and Quarterly Exams per quarter.

1. Enter Maximum Scores in row 4 for each assessment.
2. Enter student raw scores in unshaded cells.
3. Initial percentage grades automatically transmute into DepEd Final Quarterly Ratings.

Consolidates Q1 through Q4 grades with general average calculations, honor roll eligibility flags, and promotion/retained status.

Automated flagging for learners needing remediation or guidance intervention.

• Auto-flags students with grades <75 or attendance <80%.
• Provides structured fields for Intervention Strategy, Implementation Date, Remediation Results, and Follow-up Status.

TeacherEase Pro includes three dedicated curriculum worksheets aligned with DepEd MELCs and MATATAG curriculum framework:

Includes 4 connected lesson planning tabs: Weekly Planner, Daily Planner, Completion Tracker, and Reflection Log.

1. Weekly Lesson Planner: Map Monday–Friday objectives, learning tasks, and evaluation strategies in a side-by-side grid.
2. Daily Lesson Planner: Streamlined ILAW format (Intentions, Learning Experiences, Assessment, Ways Forward).
3. Lesson Completion Tracker: Mark lessons as Completed, Carried Over, or Adjusted due to class suspensions or activities.
4. Teaching Reflection Log: Record post-lesson observations: what strategies worked, student engagement levels, and notes for future remediation.

Track classroom dynamics beyond academic grades with 3 specialized tools:

• Participation Tracker: Record recitation points, group work contributions, and formative checks.
• Behavior & Discipline Tracker: Log minor/major classroom incidents, anecdotal notes, and positive reinforcement points.
• Recognition & Achievement: Document student awards, perfect attendance certificates, and class commendations.

Maintain professional logs for parent-teacher associations (PTA), quarterly card distribution, and individual parent consultations.

• Parent Communication Log: Quick recording of SMS, calls, and messenger notes.
• Parent Conference Tracker: Formal meeting records including discussed agenda, parent signature confirmation, and follow-up action items.

Manage your professional time effectively and prevent burnout.

• Task Tracker: Eisenhower matrix categorization (Urgent/Important) for DepEd deadlines.
• Workload Tracker: Log actual hours spent on teaching, lesson prep, paper grading, ancillary duties, and admin meetings.

Catalog learning materials, DepEd SLMs (Self-Learning Modules), online video links, slide decks, and reference books by subject and quarter.

Plan school-wide events (Nutrition Month, Intramurals, Science Fair, Graduation) with committee task assignments and budget tracking.

Includes Assessment Item Analysis (frequency of correct responses per item) to pinpoint difficult test questions and guide item revision.

Print-ready formatted templates for SF9 (Report Card slip), SF10 summary notes, and parent feedback slips. Select Student ID from the dropdown, preview, and print!

• 1Start Small: You don't need to fill out all 32 sheets on Day 1. Start with Settings, Masterlist, Attendance, and Gradebook, then explore lesson planning tabs as your week progresses.
• 2Use Google Sheets for Cloud Sync: Uploading TeacherEase Pro to Google Drive lets you access your gradebook and lesson plans from your school laptop, home PC, or mobile phone.