You have an AP, SAT or ACT exam coming and you want three things clear: how many days are left, whether your practice-test scores are approaching your target, and whether you are really studying as many hours as you planned. The free AP and SAT prep planner puts those answers in one place, from data you type yourself.
The problem it solves
Preparing for these exams takes long: registration dates with different bodies, scattered practice tests, and a revision plan that changes every week. Usually the dates sit in a message, the scores on loose papers and the plan in your head. Then the exam is two weeks away and you do not know if you are progressing, or how many hours you studied against what you promised yourself.
How the sheet works, step by step
- In Settings you write today's date (or =TODAY() to update itself) and how many days count as "soon".
- In Exams (المواعيد) you write each exam you registered for: name, type (AP, SAT, ACT or other), the date as you know it from the registration body, your target score and the full score on the scale you use.
- In Practice tests (الاختبارات) you log each practice test: date, the exam from a list, a label such as Practice test 1, and the score.
- In the Plan (الخطة) you write, per week, the exam you focus on, what you will review and the planned hours, then the actual hours when the week ends.
- The sheet calculates the days left, the latest score and its gap to the target, the gain since the first test, and the percentage of hours achieved.
What each sheet does
- Settings: today's date and the day limit that makes an exam "soon".
- Exams: each exam with its date and target, plus days left, status (upcoming, soon, today, ended), number of tests, first and last score, gap to target, readiness, and planned and actual hours.
- Practice tests: each test with its score against the target and its status: above, on or below the target.
- Plan: planned versus actual hours for each week and the week's status: met, below, above, or actual hours not recorded.
- Summary: the nearest exam and its days, how many exams reached their target, and total hours and completion rate.
Benefits
- You see the days left for every exam without counting on a calendar.
- You know whether you are approaching your target from the latest score and the gap, not from a feeling.
- You notice the week you missed your plan before the delay piles up.
- You set the scale and the exam names yourself; the sheet imposes none.
Why it matters
Pre-exam anxiety grows when you cannot see where you stand. Small numbers, such as 20 days left or 2 points under target, turn it into a specific task: what do I study this week?
A quick walk-through with the sample
The numbers below come from the sample sheet. Its dates and scores are made up, not official dates or any exam's scoring scale. Today in the sample is 1 November 2026. There are five exams: one ended, one "soon" in 20 days, two upcoming, and ACT with no target written. The nearest upcoming exam is "SAT (second attempt)" in 20 days.
For it, four practice tests rose from 62 to 78 (a gain of 16), against a target of 80: the gap is -2 and the status "below target". "SAT (first attempt)" has a last score of 77 against 75, so "reached target". AP Calculus AB's last test is 79 against 85, 6 below.
The plan has seven weeks with 64 planned hours. For the four weeks with actual hours recorded, 36 were planned and 32 studied, about 89%. A week that passed with no actual hours shows "actual not recorded". A test for AP Chemistry, missing from Exams, turns red and says "exam not found".
The online version
The same sheet runs online: it opens on the worked example, you change any cell and see the result at once, add a practice test from a form, and import or export an .xlsx file. Your data stays in your browser. Try it from the template page.
Who it suits
- A student in the American diploma preparing for AP, SAT or ACT.
- A parent following a revision plan by the numbers.
- A tutor or advisor who wants a simple record for a student sitting several exams.
The sheet knows neither exam dates nor how scores are calculated; you type all of it. If you study IGCSE, see the IGCSE past papers log, and for your school's own exam timetable the exam schedule sheet.