Create Scholar tests with Microsoft Excel

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

  1. Type Code
  2. Question Text
  3. Sample Answer

Fill in the Blank

FIB

  1. Type Code
  2. Question Text
  3. Answer Text (for multiple answers, use subsequent cells)

Matching

MAT

  1. Type Code
  2. Question Text
  3. Item to Match
  4. 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

  1. Type Code
  2. Question Text
  3. Answer Text
  4. Correct or Incorrect

Repeat #3 and #4 for multiple choices

Multiple choice

MC

  1. Type Code
  2. Question Text
  3. Answer Text
  4. Correct or Incorrect

Repeat #3 and #4 for multiple choices

Numeric Response

NUM

  1. Type Code
  2. Question Text
  3. Answer
  4. Answer Range

Ordering

ORD

  1. Type Code
  2. Question Text
  3. Answer Text (repeat for all answers)

True/False

TF

  1. Type Code
  2. Question Text
  3. 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:

Excel Test 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


Sample Text Expanded Column


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.  

Excel Save As Filetype


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


Scholar Upload Test Questions

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

Upload Questions Locate Files

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