Creating Scholar Tests in Excel

A quick way to create simple tests in Scholar is to type the questions into a spreadsheet and import them into a test in Scholar. To do so, open up Excel, and create a new sheet.

DO NOT create any sort of header row; it will not be processed. Instead, use one line for each question in the test. The first cell in each line should be a code representing what type of question it is. Subsequent cells will vary based on the type of question. It is very important that you don’t skip a cell or copy and paste anything with line breaks into a cell. Doing so will cause your questions not to import correctly. The following table gives the format for the most popular question types. Each number is a column

Question Type	Code	Format
Essay	ESS	Type Code Question Text Sample Answer
Fill in the Blank	FIB	Type Code Question Text Answer Text (for multiple answers, use subsequent cells)
Matching	MAT	Type Code Question Text Item to Match Matching Item Repeat #3 and #4 for multiple items to match. There must be a one-to-one relationship for matched items to work
Multiple Answer	MA	Type Code Question Text Answer Text Correct or Incorrect Repeat #3 and #4 for multiple choices
Multiple choice	MC	Type Code Question Text Answer Text Correct or Incorrect Repeat #3 and #4 for multiple choices
Numeric Response	NUM	Type Code Question Text Answer Answer Range
Ordering	ORD	Type Code Question Text Answer Text (repeat for all answers)
True/False	TF	Type Code Question Text True or False

Once you’ve completed all of the questions, it’s important to check your spreadsheet for the two most common types of errors: blank cells and inadvertently-included line breaks.

A blank cell may be covered with the question text:

If your column widths are small, line breaks may not be immediately obvious, as they will be mixed in with wrapped lines:

Question Text Sample Wrapped Text

However, expanding the width of the column should make them stand out

When you’ve completed your checks, you should save the file as a tab-delimited text file.

To do so on Office 2016, click the File menu, and choose Save As. Then, click either the folder to which you’d like to save the file or Browse to select a new one.

Excel Save As

In the window that pops up, change the value in “Save as type:” to “Text (Tab-delimited)” and save the file.

Once you’ve saved the file, create a test in Scholar as normal. When you get to the Test Canvas, click on Upload Questions.

On the next screen, click Browse to select a file, and enter the number of points per question.

Click Submit, and your questions will be imported. You will be notified of any detected errors in the file.

Browser not supported