Excel | Longman 3000 Words

# Pad remaining words definitions += [""] * (len(words) - len(definitions)) pos_list += [""] * (len(words) - len(pos_list))

: Indicates the word is among the top 1,000, 2,000, or 3,000 most frequent words in Spoken English. longman 3000 words excel

Create a temporary column next to your data and enter the formula =RAND() . Drag it down all 3,000 rows. Sort the spreadsheet by this random number column to generate a unique, randomized mix of words for your daily study session. The Spaced Repetition Formula # Pad remaining words definitions += [""] *

On weekends, sort your sheet by the Last Reviewed date. Pull up words you haven't looked at in a month to ensure they haven't slipped from your long-term memory. Conclusion Sort the spreadsheet by this random number column

When populating your column, use Longman's official markers to prioritize your study time: S1, S2, S3: Top 1000, 2000, and 3000 spoken words. W1, W2, W3: Top 1000, 2000, and 3000 written words.