Import an Answer Key
Last Updated: September 19, 2018Import an Answer Key
Create an answer key in a CSV file
- You can prepare a CSV file to import your key in one of three ways:
- Create an answer key in Google Sheet or Microsoft Excel and save it as a CSV file then import the CSV file to GradeHub
- Export an empty answer key from GradeHub, fill it out, then import it as a CSV file
- Export the CSV file from GradeHub from a previously created answer key
- Each method uses a CSV file typically viewed through a spreadsheet, such as Excel. An example file format is provided below.
- The CSV file has column headers in row and values for each item (i.e., question)
- The first column is the question (ITEM #)
- Column two is the correct response to each question (EXPECTED)
- Column three is the question type (TYPE)
- " * " TYPE - if the TYPE is "*," then a student that selects any value in the EXPECTED column will receive credit for the answer. For example, if a student selects "A" on her answer sheet for item #1, she will receive credit for the response. Similarly, if a student selects "A" or "B" for item #2, she will receive credit for the question
- " & " TYPE - if the TYPE is "&," then a student must select ALL the values in the EXPECTED column to receive credit. For example, if a student selects A and B for item #5, she will receive credit. If the student selected just "A" or "A" and "C," then she would not receive credit for the question.
- Complete the information for your exam in a spreadsheet application and then save the spreadsheet as a CSV file for upload to GradeHub.
Import an Answer Key from a CSV file
- Choose Your Exam and Click Edit Answer Key
- The Answer Key Pop-up will appear, choose Import.
- Choose the answer key you want to import by selecting the Browse file button or using the drag-and-drop box.
- Answer key to import will appear in a CSV Format in the box.
- Review the information for import and select Next to begin matching your CSV file fields to GradeHub's required fields.
- As you map the information, the CSV column headers from the uploaded file will appear on the left with the GradeHub required fields for mapping on the right-hand side. Map the fields you uploaded to the fields in GradeHub by the three drop-down boxes on the right.
- Map the question to "<item #>"
- Map answer to each question to "<expected value>"
- Map question type to "<type>"
- Note: type is optional if all questions are "*" (see above)
- Note: type is optional if all questions are "*" (see above)
- Click Submit, and you will be directed to the Answer Key pop-up where the answer key is automatically filled out.
- Note: Double check if the Answer Key is correct as well as the Answer Key version.
- Click Save to finish importing your answer key.