Test Score Import Setup and Evaluation

Updated
Watermark Support
  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.

    The navigation bar showing tabs labeled Folios & Web Pages, Lessons, Units & Rubrics, Standards, Communications, Resources, and TS Coordinator, with TS Coordinator highlighted.

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

    The DRF Assessment System page showing options labeled DRF Template Builder, DRF Programs, and DRF Program Reports, with DRF Template Builder highlighted. The page also showing Supporting Tools listing Rubric Wizard and Form & Survey Builder buttons.

    The Manage DRF Templates page showing a folder filter set to 'Happy Path DRFs' with an Update List button, and a title search field with a Search button. A template titled Core/Unit Assessment DRF is listed and highlighted. Buttons for Edit, Copy, Rename, and Delete appear on the right, along with a View Folder Details link.

    The action prompt section showing options labeled Do Not Edit – Back to All DRF Templates and Proceed with Editing DRF Template, with Proceed with Editing DRF Template highlighted.

  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.

    The requirement setup section showing category lists on the left and an options menu offering Add Category and Add Requirement choices, including Test or Exam, highlighted. A form below showing fields for Title and Descriptor with the Title field filled as 'Praxis I Reading.' Cancel and Create buttons appear at the bottom, with Create highlighted.

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

    The navigation tabs showing All Templates, Format, Structure/Requirements, Evaluation, and Preferences, with Evaluation highlighted.

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

    The evaluation setup section showing the DRF Area list with an item labeled Praxis I Reading, and an Evaluation Method column on the right. A button labeled Define Import Parameters highlighted.

  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.

    The import settings section showing fields for maximum score and ID/Description, with the maximum score set to 250. Cancel and Apply Changes buttons appear below, with Apply Changes highlighted.

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.

    The DRF Program section showing a DRF icon on the left and a program link labeled Unit Assessment Spring 2017 highlighted. Links for Evaluation Required, Awaiting Release, and Reports appear below with count indicators.

  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.

    The evaluation grid showing columns for Praxis I Writing, Praxis I Reading, Praxis II Writing, Application to Education Program, and Admissions Artifacts. Each column header contains an Import or QuickScore button, with the Praxis I Reading Import button highlighted. Rows for individual authors display score details, View/Edit links, and Evaluate buttons.

  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.

    The import section showing an option to auto-generate a template with the Auto‑Generate Template button highlighted. A file upload field for selecting a CSV file appears above Import File and Cancel buttons. A second panel below shows a list of authors with checkboxes and a Generate Template button highlighted.

  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.

    The import template table showing columns for External ID, Taskstream ID, First Name, Last Name, Value/Score, and Date, with the Value/Score and Date columns highlighted.

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

    The save dialog showing a file name field labeled Score Import and a file type dropdown set to CSV (Comma delimited) (*.csv) highlighted. A Save button appears on the right.

  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.

    The import panel showing a Select .CSV File field with the Choose File button highlighted before selection and then displaying Score Import.csv after selection. The Skip first row/header option appears below. Cancel and Import File buttons appear on the right, with Import File highlighted.

  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.

    The data validation section showing a table of imported records with checkboxes, displaying External ID, Taskstream ID, First Name, Last Name, Value/Score, and Date. Two validated rows appear in the table. A Cancel button and an Import button, with Import highlighted.

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

    The confirmation section showing a message that 2 rows were successfully processed, with the message highlighted. Buttons below offer options to go back to the evaluation grid or process another CSV file.

Was this article helpful?
0 out of 1 found this helpful

Articles in this section

See more
How to Contact Support
There are many ways to reach out! Click the icon above for our support options.
Watermark Academy
Click the icon above 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!