| Pitfall | Excel Solution |
| :--- | :--- |
| Overloading with data | Keep columns to fewer than 8. Don't add phonetic symbols until Band 3. |
| No context | Force yourself to fill the "Example Sentence" column before marking "Learned." |
| Losing motivation | Use the SPARKLINE function to create a mini graph of weekly new words learned. |
| Forgetting older words | Set up a recurring filter: "Review Date is less than today" and "Status is Mastered" |
Create a new column called "Cloze Sentence." For the word "analyze," write: "The scientist needed to ______ the data before publishing the results." This forces active recall, not passive recognition.
This script:
| Word | Band | |------|------| | able | W2/S2 | | about | W1/S1 | | above | W2/S2 | | accept | W2/S2 | | across | W1/S1 | | act | W1/S1 | | add | W1/S1 | | afraid | W2/S2 | | after | W1/S1 | | again | W1/S1 |
⚠️ Not all Band 1 words start with A – this is just a fragment. longman 3000 words excel
You can replicate this structure in Excel or on paper:
| Word | Part of Speech | Band | Example Phrase | |------|----------------|------|----------------| | the | det. | W1/S1 | the book | | be | v. | W1/S1 | to be happy | | and | conj. | W1/S1 | you and me | | of | prep. | W1/S1 | part of the day | | a | det. | W1/S1 | a car | | to | particle | W1/S1 | go to school | | in | prep. | W1/S1 | in the house | | that | conj./det. | W1/S1 | that man | | have | v. | W1/S1 | have a problem | | I | pron. | W1/S1 | I think | | Pitfall | Excel Solution | | :---
(Continue for 3,000 rows)
| Pitfall | Excel Solution |
| :--- | :--- |
| Overloading with data | Keep columns to fewer than 8. Don't add phonetic symbols until Band 3. |
| No context | Force yourself to fill the "Example Sentence" column before marking "Learned." |
| Losing motivation | Use the SPARKLINE function to create a mini graph of weekly new words learned. |
| Forgetting older words | Set up a recurring filter: "Review Date is less than today" and "Status is Mastered" |
Create a new column called "Cloze Sentence." For the word "analyze," write: "The scientist needed to ______ the data before publishing the results." This forces active recall, not passive recognition.
This script:
| Word | Band | |------|------| | able | W2/S2 | | about | W1/S1 | | above | W2/S2 | | accept | W2/S2 | | across | W1/S1 | | act | W1/S1 | | add | W1/S1 | | afraid | W2/S2 | | after | W1/S1 | | again | W1/S1 |
⚠️ Not all Band 1 words start with A – this is just a fragment.
You can replicate this structure in Excel or on paper:
| Word | Part of Speech | Band | Example Phrase | |------|----------------|------|----------------| | the | det. | W1/S1 | the book | | be | v. | W1/S1 | to be happy | | and | conj. | W1/S1 | you and me | | of | prep. | W1/S1 | part of the day | | a | det. | W1/S1 | a car | | to | particle | W1/S1 | go to school | | in | prep. | W1/S1 | in the house | | that | conj./det. | W1/S1 | that man | | have | v. | W1/S1 | have a problem | | I | pron. | W1/S1 | I think |
(Continue for 3,000 rows)