LEPT Review Tracker - Elementary (Google Sheets)

Review for the LEPT Elementary with a tracker built on the 2025 table of specifications. It covers every learning outcome, weighted the way the exam is, in one Google Sheets file that works on your phone.

Built on the 2025 table of specifications

Subjects, weights and learning outcomes follow BPT Resolution No. 11, s. 2025, Annex A. That’s 46 learning outcomes across 15 subjects:

• General Education: 10 subjects, 20 learning outcomes, 40% of your rating
• Professional Education: 5 subjects, 26 learning outcomes, 60% of your rating

Every learning outcome has its own row with a permanent ID, so nothing gets lumped together.

What’s inside (11 tabs)

• Dashboard: your countdown, weighted mastery, hours this week, and the pace you need to finish on time. Study Next lists the topics that weigh most and that you know least. Due for Review shows what your spaced review dates say is due.
• Topics: set a status (Not started, In progress, For review, Mastered, Needs work, On hold) and a confidence level from 1 to 5. Tick Pass 1, Pass 2 and Final as you go. Your next review date sets itself: 1, 3, 7, 14 or 30 days, depending on your confidence.
• Scores: log your diagnostic tests and pre-boards. The Dashboard turns your latest scores into an estimated rating using PRC’s part weights, and checks the passing rule: a general average of 75% or more, with no part below 50%.
• Plan: a week-by-week plan from your start date to exam day. Pass 1 takes the first 55% of your study days, Pass 2 runs to 85%, and the rest is final review. Planned hours sit next to logged hours.
• Study Log, Mistakes and Subjects: log every session, write down what you missed and the concept behind it, re-test yourself on a set date, and see your progress per subject.
• Checklist: PRC steps from applying to exam day, each with its PRC source.
• Start Here, Settings and Sources: setup in five steps, and the resolutions and PRC documents behind every subject and weight.

Easy to use

• Fill in Settings once: your exam date, study hours and rest days. Everything else updates itself.
• Dropdowns and checkboxes for every entry.
• Works in the Google Sheets app on your phone.
• No add-ons and no scripts.

What you get

A link that makes your own copy of the tracker in your Google Drive. You need a free Google account.

This tracker is an independent study aid. It is not affiliated with or endorsed by the Professional Regulation Commission or the Board for Professional Teachers.