Create a pivot table from your master list:
This gives you a heat map. If you see 200 B1 words still "Not Started" after a month, you know exactly where to focus. oxford 3000 excel
| Word | Part of Speech | CEFR Level | Definition | Example Sentence | | ---------- | ------------------ | -------------- | ------------------------------------------- | ------------------------------------------------- | | a/an | article | A1 | used before singular nouns | I need a pen. | | abandon | verb | B2 | to leave someone or something permanently | The ship was abandoned by the crew. | | ability | noun | A2 | the skill or power to do something | She has the ability to learn quickly. | | able | adjective | A2 | having the power or skill to do something | He is able to solve complex problems. | | about | preposition/adverb | A1 | on the subject of; approximately | Tell me about your trip. | | above | preposition/adverb | A1 | at a higher level or position | The sun rose above the mountains. | | abroad | adverb | A2 | in or to a foreign country | She dreams of studying abroad. | | accept | verb | A2 | to agree to take or receive something | He accepted the job offer. | | access | noun/verb | B1 | the right or opportunity to use/enter | Students have access to the library. | | accident | noun | A2 | an unexpected event causing damage/injury | She was injured in a car accident. | | accompany | verb | B1 | to go somewhere with someone | I will accompany you to the station. | | account | noun | B1 | a bank account or a description of events | He gave a detailed account of the meeting. | Create a pivot table from your master list:
This is the secret sauce. Spaced repetition is a learning technique where you review words just before you forget them. Add these columns: This gives you a heat map
| Column G | Column H | Column I | | :--- | :--- | :--- | | Last Review Date | Next Review Date | Correct Streak |
Use the formula in Column H: =G2+7 (if you want to review after 7 days). As the streak increases, increase the interval (e.g., 7 days, 14 days, 30 days).