Test Score Import Setup and Evaluation

1. To begin, log into your account with TS Coordinator access.

2. Select TS Coordinator from the navigation bar at the top of the screen.

Screen_Shot_2022-09-23_at_11.55.46_AM.png

3. Select the DRF Template Builder link and then select the name of the DRF Template you would like to edit.

Screen_Shot_2022-09-23_at_11.55.55_AM.png

Screen_Shot_2022-09-23_at_11.56.04_AM.png

Screen_Shot_2022-09-23_at_11.56.22_AM.png

4. If you are creating a new Test/GPA requirement, hover your mouse over a category and select the downward face arrow. A menu will appear where you may select either Test or Exam or GPA. After you make a selection, enter a title for your new requirement.

Screen_Shot_2022-09-23_at_11.56.36_AM.png

5. Once your new requirement has been added to your DRF Template, select the Evaluation tab to define the import parameters.

Screen_Shot_2022-09-23_at_11.56.46_AM.png

6. In the Evaluation tab, select Define Import Parameters for your Test/Exam, or GPA.

Screen_Shot_2022-09-23_at_11.56.55_AM.png

7. On the next page, you will be asked to enter a maximum score that may be entered by an Evaluator or Evaluation Manager. You will also have the option to enter an ID/Description. Once you’ve entered a maximum score, select Apply Changes.

Screen_Shot_2022-09-23_at_11.57.06_AM.png

Importing Scores into Taskstream LAT by Watermark

1. When you’re ready to import test scores, log into your account with Evaluator access and select the DRF Program in which you’d like to import scores.

Screen_Shot_2022-09-23_at_11.57.14_AM.png

2. Select the groups and/or search criteria on the next page and then click Continue at the bottom of the page. The next page will display the evaluation grid with all the students you have access to. Locate the test/exam or GPA and select the Import button.

Screen_Shot_2022-09-23_at_11.57.21_AM.png

3. On the next page, select the Auto-Generate Template button at the upper right-hand corner. This will open a pop- up window which will display all the students who will be included in the template. You may uncheck any names on this list. Once you’ve reviewed the list of students, select the Generate Template button.

Screen_Shot_2022-09-23_at_11.57.34_AM.png

4. After you’ve selected Generate Template, open the downloaded template in Microsoft Excel. Enter the test/exam scores or GPAs in the Value/Score column. If you are entering test/exam scores, enter the date the student took the test/exam in the Date column. If you are entering GPAs, enter the date that the GPA was last valid in the Date column instead.

Screen_Shot_2022-09-23_at_11.57.43_AM.png

5. Once you’ve entered all your scores/GPAs and dates, save the spreadsheet on your computer as a CSV file.

Screen_Shot_2022-09-23_at_11.57.52_AM.png

6. Return to LAT and select the Choose File button to browse for your saved file. Once you’ve selected your file, click the Import File button.

Screen_Shot_2022-09-23_at_11.58.02_AM.png

7. The next page will display the data that can be imported. You may unselect any students on this page. This page will also display any errors in red text. Once you’ve reviewed the data, select Import.

Screen_Shot_2022-09-23_at_11.58.09_AM.png

8. After you select the Import button, you will be navigated to a confirmation screen with the number of rows that were successfully processed.

Screen_Shot_2022-09-23_at_11.58.16_AM.png

Articles in this section

See more
How to Contact Support
There are many ways to reach out! Click here for our support options.
Watermark Academy
Click to access the Watermark Academy for consultation, training, and implementation companion courses.
Customer Community
Can’t find the answer? Ask fellow users how they’re making the most of Watermark in our Community!