TableQuiz is a tool that allows teachers to create, assign, and grade short-answer quizzes in a table format. By using this tool, teachers can grade a large number of short answer quizzes in minutes, while still accounting for spelling mistakes and any other unexpected answers that students may provide. Get TableQuiz here!
- All quizzes grade themselves immediately as students submit. Correct answers are highlighted green; incorrect answers are highlighted red. A tool-tip appears over every answer showing students what the correct answer is from the answer key.
- Teachers can quickly look at all incorrect answers and add any acceptable answers to the key. This way, teachers can still award credit to students who answer using synonyms and spelling errors. The program then saves these answers to the key, so you only need to catch each mistake once!
- Quizzes are generated and organized in a clear, professional layout. Minimal knowledge of Google Sheets is required!
- All student scores are conveniently stored on one page for easy transfer to the Gradebook.
- Created by a teacher for teachers!
Creating a New TableQuiz
Step 1 - Activate TableQuiz
Create a new spreadsheet in Google Drive.
Click Add-ons => TableQuiz => I'm the Teacher
This will add an option to create a new TableQuiz.
Click Add-ons => TableQuiz => New TableQuiz
This will create and format all of the necessary sheets for TableQuiz to function.
Before You Get Started:
- NEVER CHANGE THE FONT FOR ANY CELLS ON THE SPREADSHEET. Do not bold/unbold any font or change font size. TableQuiz navigates your quiz by examining the font size of each cell. Changing font sizes may prevent TableQuiz from grading each quiz correctly.
- DO NOT SWITCH BETWEEN GOOGLE ACCOUNTS WHILE MAKING AND USING TABLEQUIZZES. TableQuiz links each quiz key to your google account to protect it from students. This prevents students from modifying the key or their individual scores, but if you attempt to access the file with a different account, you will not be able to make changes.
Step 2 - Name Your Quiz
Enter the name of your class or subject in the upper left-hand corner. In the cell below, enter the title for your Quiz. You can also rename the file to help organize your drive, but make sure that you include the word KEY in your file to avoid confusion in later steps.
Step 3 - Format Your Quiz
Click Add-ons => TableQuiz => Format Quiz.
A sidebar will appear that allows you to add multiple tables to your quiz. Rename the first table as you see fit.
Enter the number of columns and rows that you would like students to complete in your table. Generally, the number of rows corresponds to the number of questions that you would like to ask. The number of columns corresponds to how many answers students must provide for each question. For example, a simple vocab quiz where students must provide a synonym for 10 different words would have:
- 10 Rows (1 for each word)
- 1 Column (since students only need to provide a synonym)
Once you enter in the number of rows and columns that you desire, TableQuiz will immediately begin to draw your table. If you want to change the table, simply adjust the numbers and the table will automatically redraw itself.
If you press next, you can cycle to another table and create it just like the first. You can create a quiz with up to 10 separate tables in TableQuiz. By clicking previous, you'll cycle to a previous table. If you click DELETE, then the current table will be deleted, and your quiz will be redrawn accordingly.
Once you have settled on a quiz layout, you can close the sidebar by clicking Close or the X in the upper right-hand corner. If you need to make changes, you can reopen the sidebar from the Add-ons menu at any time. Once finished, your quiz should look something like this:
Step 4 - Fill In Your Template
Now that your quiz layout is formatted correctly, you need to type in information for each subheading and question. If you are unsure about what to put in each box, a tool-tip will appear if you mouse over the upper right-hand corner of each box.
Enter in the correct answer(s) to each question in the appropriate boxes. If your question has multiple answers, enter all possibilities separated by commas. For example, a box that contains "rat, mouse, rodent" will be marked correct if a student enters any of those 3 possibilities.
If some boxes are too small, you can resize any columns as you would in a normal spreadsheet. If you would like an answer to be filled in for students, type "ungraded, " before the text that you would like to appear in the cell.
If at any time you need to adjust the layout of the tables in your quiz, you can do that by clicking Format Quiz in the TableQuiz menu. To the best of its ability, Tablequiz will save any information that you have already entered before it redraws your quiz.
Step 5 - Create Your Key
Once you have filled in all of the information for your quiz, click Add-ons => TableQuiz => Create Key. This will re-format the entire file so that it can be used as a key for your quiz. Make sure that everything is entered correctly before creating your key. If any mistakes were made, you will need to revert to an earlier version of the file or restart the process.
Once the key is created, all answers will be moved to a separate sheet, and they will be replaced with numbers that point the program to each answer. All tool-tips will also be removed.
In the top right-hand corner, the total number should be updated to accurately represent the number of questions in the quiz. You can adjust this number if you would like students to be able to miss blanks and still receive a 100%.
Step 6 - Create Your Quiz
With the key created, you can now create your quiz file. This is the file that you will distribute to your students for them to complete the quiz.
Click Add-ons => TableQuiz => Create Quiz. A prompt will appear that asks you to create a name for the quiz file. To avoid confusion, make sure that the name for the new file is different from the name for your key file!
The new quiz file will be created in the same folder as the key file.
That's it! Your TableQuiz is now created! If you open the new file, it will look something like this:
Giving Your TableQuiz in Class
TableQuizzes are assigned through Google Classroom, so make sure that you have familiarized yourself with setting up and using a Google Classroom before assigning TableQuizzes in your class.
Posting Your TableQuiz
To post your TableQuiz to Google Classroom, create a new assignment as you normally would. Title the assignment accordingly.
Click the drive icon to add your TableQuiz to the assignment. You will be adding 2 files:
- Add quiz file created in Step 6. Make sure that you set it to "Make a copy for each student". This is the quiz file that each student will complete.
- Add the key file that contains the key for the TableQuiz. Make sure that you set it to "Students can edit file." Students need access to the key so that the program can grade their TableQuiz and compile their scores in the key file. Students shouldn't actually be opening the key. If they do by mistake, a message is at the top of the key to tell students that they are in the wrong spot. Don't worry, the key does not contain information that students can easily use to help on the quiz!
Once both files are added, assign the assignment as you would normally do. At first, students may need help opening the correct file, but after their first few TableQuizzes, the process will become second nature. Remember, the key file is protected, so even though students can access the file, they cannot make changes to their score or the key.
Taking a TableQuiz
Students complete the quiz in a straightforward manner. Once they have filled in all of the blanks and they have entered their name, then they can submit their TableQuiz to be graded. To do this, they must click Add-ons => TableQuiz => Submit. They will be warned that they cannot change any of their answers once they submit. If it is a student's first time using TableQuiz, they will be prompted to get the Add-on first.
Once submitted, each incorrect answer on the student's quiz will be highlighted red. Likewise, each correct answer will be highlighted green. A tooltip will appear over each answer, showing students the answer from the key. Finally, their final score will appear in the upper right-hand corner. Students can take this time to examine their results and learn from any mistakes. Their screen will look something like this:
Remember, TableQuiz allows you to update the key with any spelling errors or unexpected answers that students may have provided. Encourage students to check the correct answer from each tooltip, and reassure them that they will receive credit if their answer should be marked correct.
Compiling and Adjusting Grades
At this point, most of the grading has already been taken care of by TableQuiz. If you open the key file and click on the Results sheet, you will see the overall scores for each student.
There is no need to open each student's individual quiz file. If you would like to check an individual file, you can do so by clicking the link on the results sheet.
To provide quick, at-a-glance feedback, important score thresholds are highlighted for you:
- All scores above a 90% are highlighted green.
- All scores between a 60% and 70% are highlighted yellow.
- All scores below a 60% are highlighted red.
Like any other spreadsheet, you can sort this page by last-name, first-name, score, etc. by clicking Data => Sort Sheet By [Selected Column]. If necessary, you can add additional columns to this sheet for adding extra-credit, converting scores, etc.
These scores are only a rough estimate of students' final scores! They do not account for any spelling errors or answers that--while still being correct--may have differed from those in your key. However, you can account for these answers by opening the Incorrect Answers sheet (see below).
Editing the Key
If you click the Incorrect Answers sheet, you will see a quick view of every incorrect answer that a student provided. The red column (Answer) contains the incorrect answer that the student provided. The green column (Keyed Answer) contains the original answer on the key. The blue column (Acceptable?) is blank by default.
- If a student's answer is an acceptable answer to the question, simply type "Y" or "Yes" in the blue column. This will add the answer to the key so that all future students will get credit whenever they enter this answer. In the future, this answer will no longer appear on the Incorrect Answers sheet.
- If the answer is not acceptable, type "N" or No" in the blue column. This will blacklist the answer so that it no longer appears on the Incorrect Answers sheet when a student enters it. This prevents you from constantly re-examining the same incorrect answers whenever you give the quiz in the future.
Once you have marked all of the acceptable and unacceptable answers, click Add-ons => TableQuiz => Add Answers to Key. Doing so will clear all the incorrect answers that you have examined. Students with answers marked acceptable will have their scores adjusted, and these boxes will be changed to green on their individual quizzes. Once you have done this, you can encourage students to check their quiz once again for their final score.
Let's look at how our quiz from earlier updated:
This process gets very quick with a bit of practice! As a teacher, once you make a TableQuiz, you only need to post it and go over the incorrect answers once students take the quiz. The more you use a particular quiz, the fewer answers you need to check on the "Incorrect Answers" sheet.
If you want to use more advanced features in TableQuiz, check out the advanced page here.