This article explains two ways you can import tests that students completed offline to the application. With YouTestMe GetCertified, you can generate tests for offline use. Print hard copies, and after students complete them, you can enter test attempts back into the system. Test attempts will be automatically graded as tests conducted online.
Creating a CSV file #
Once you have created and published the test (for more information on how to create a simple test, please visit How to create a simple test without sections and assign candidates to it), you can import the exam responses using a Scantron machine or Excel files. This allows you to transfer results from paper to electronic form.
To do this:
– If you use a Scantron machine, scan the results, and convert them to CSV files.
– If you do not have a Scantron machine, create an Excel file manually and follow the instructions:
- In the first column, enter the usernames of all candidates who took the test.
- Leave the next two columns blank.
- The fourth column should contain the answer a candidate gave to the first question in the test.
- The fifth column represents the answer to the second question etc.
- If the candidate answered with the first offered answer, enter the letter A. If he/she selected the second answer, enter B, etc.
- If multiple answers were selected, you must enter a space between the letters (as shown in the picture).
- After entering the answers to all questions, save the file as CSV.
Note: Ensure that the preferred delimiter, usually called “List separator”, is set to be “,” (comma) so the file can be successfully uploaded. This setting is located in the Regional Settings / Additional Settings of the Control Panel on your computer.
Adding the test results to the application #
To import a CSV file in the application, follow the instructions below:
- Hover over the Tests in the main menu and select Manage tests.
- Select the desired test.
- Navigate to the Candidates tab.
- Select the desired session, and the list of candidates will be displayed. Ensure that the order of the candidates in this session matches the order of candidates in the Excel/CSV file.
- Click the Data Transfer button and select the Import Scantron results from the dropdown menu.
If you do not see the Import Scantron results option, the test contains question types that are not supported. It is possible to import test results for single-choice, multiple-choice, and true/false questions and only for a test without sections.
- Click the Select file button to choose the CSV file.
- Click the Upload button to import the test responses.
After uploading, you can see the reports of the candidates whose results you have added.
For video instructions, please watch this video.
