Study Smarter with Numbers: Study Hours, Spaced-Repetition Schedules, Exam Weights & Target Scores

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn Lina's eight exam topics into weighted study hours, add them up with SUMPRODUCT and work out how many weeks she has and how many hours per week the plan needs.
• Total Lina's available hours, split them across the eight topics in proportion to their weighted hours, rounded to half hours with a remainder fix, and see in which week the whole syllabus is covered once.
• Build a spaced review calendar from first-study dates and expanding gaps, count the flashcard reviews due per day and per week with COUNTIFS, and find out whether the last topic's schedule still fits before the exam.
• Apply a simplified, fictional flashcard rule set: adjust each card's ease by the answer grade with a floor, compute the new interval with IFS and turn it into the next due date.
• Turn ten practice tests into scores and a 3-test rolling average, compute the accuracy per topic and name the weakest topics with SMALL and INDEX/MATCH.
• Add up the weighted points Lina has already earned, work out the score she needs on the final for each grade band, flag which bands are out of reach and project her overall grade.
• Turn the exam length and marks into working minutes per mark, budget each section in whole minutes and write clock-time checkpoints with TIME and TEXT.
• Compare planned and actual study hours week by week, measure overall plan achievement, extend the practice-score trend to the exam week with FORECAST.LINEAR and chart planned vs actual hours.