Open Excel, OpenOffice Calculator or another spreadsheet program.
Highlight the first cell of the first four columns -- A1, B1, C1 and D1 -- by clicking on A1 and dragging it to D1. Right click and select "Format Cells." Select a dark background color and a light text color.
Highlight cells A2 through D4 by clicking on the A2 cell and dragging the mouse to D4. You should have three rows highlighted. Right click and select "Format Cells. " Go to the "Borders" tab and select the option that has an outside border as well as a border for each individual cell. Click "OK."
Type "Verb:" in the A1 cell and "Meaning" in the C1 cell. The student will enter the Spanish verb into B2 and its corresponding English translation into D4. (Example: "hablar" in A2 and "to speak" in D4).
Enter the Spanish pronouns: "yo" in A2, "tú" in A3 and "él/ella/usted" in A4. Put "nosotros/as" in C2, "vosotros/as" in C3, and "ellos/ellas/ustedes" in C4.
Have the student fill in the blank cell to the right of each pronoun with the proper verb conjugation. For example, using "hablar" (to talk): for A2, A3 and A4, have them write "hablo" in B2, "hablas" in B3 and "habla" in B4.
Copy and paste the template multiple times so the student can practice with multiple verbs. Save an empty template that can be copied and used without having to delete all the data.
Have the student log onto the website of the Real Academia Española (Royal Spanish Academy). This is the institution that governs the Spanish language and sets its rules.
Instruct the student to type the infinitive verb into the box on the right under the words "Diccionario de la lengua española" (Dictionary of the Spanish Language) and press "Enter." Infinitive verbs are non-conjugated verbs such as "hablar"; they always end in either "ar," "er" or "ir."
Have the student click the blue box to the left of the verb that says "Conjugar" (to conjugate); this will go to a conjugation chart for all tenses in both the indicative and subjunctive moods. Have the student correct his work by comparing his conjugations to the ones in the chart.
Highlight cells A1, B1 and C1. Right click and select "Format Cells." Apply a dark background.
Enter "English" in A1, "Spanish" in B1 and "Test 1" in C1.
Enter words in English in the English column and have the student fill in the Spanish column. If he does not know the corresponding word, have him search in an online English-to-Spanish dictionary.
Have the student practice the words by reading the English word followed by its Spanish equivalent until he is confident he has them memorized.
Hide the A column by right clicking on the column header (the letter A) and choosing "Hide"; now only the Spanish words should be visible.
Tell the student to translate the words into column C -- the test column. Tell him to make a new list of only the words he could not remember during this first test. Have him memorize only these difficult words by using the same technique of hiding the English version.