TRAIN TRACK® Web Edition Help Manual

Import Exam Records

TRAIN TRACK® allows you to import exam questions and answers from a template. When you import exams, the training title or number must match existing database records in order for the exams to be recorded correctly.

Import Exam Records

To import exam records, follow these steps

Step	Illustration
1. From the navigation bar, select Import > Exams.
2. The import screen will open. Click the Download link to download the template.
3. A browse box will open. Browse to where you want to save the file and click Save. Make a note of where you saved the file.
4. Open the file you saved by clicking the download icon on your browser. A list of downloaded files should open. Click on the file name. Note: if you do not see the option to open the file from your browser, locate the file from Windows Explorer and open it.
5. Paste your data into the Excel template. You will need to leave all of the column headings in place (do not alter them or move them), and paste your data below them. If you don't have data for some of the columns, just leave them blank. Please see below for details about the data you may paste into each column.
6. Save the file as a .csv file.
7. Click Choose File (or Browse, depending on your web browser). Browse to the file you saved above and click Open.
8.Click Import Exams. The status of your import will be displayed along with any error messages. Note that after adding the exam questions and answers, you will still need to set the passing score and indicate that the exam is required from the Training record.
9. Open the Training Detail screen and click Exam.
10. The Exam Questions screen will open. Set the Passing Score. The passing score must be less than or equal to the possible points, which are automatically calculated.
11. Check Exam Required and click Save Changes. Now your exam is required and employees will need to pass the exam in order for the training to be completed.

Exam Template Columns

The template used to import exam records includes the following columns:

Training Title: Training title.
Training Number:Training number.
Question Order: Number the questions starting with 1.
Question: Exam question.
Answer Letter: Letter the answers starting with a.
Answer: Exam answer selection.
Points: Points associated with the answer. Use zero for wrong answers. The passing score must be less than or equal to the total possible points.

.
.