Export Course Assessments

The Export Course Assessments button creates a raw data file in a CSV or Excel format of all assessment data collected in all rubrics. The data collected allows administrators to view student growth within courses.

 

To access the Course Assessment Data Extract:

1. Log into your LiveText administrator account

2. Click Tools

3. Click Export Course Assessments

 

NOTE: If you do not see Export Course Assessments on your Tools page, please email support@watermarkinsights.com to request that it be enabled

 

4. Select one or more Terms to include in the extract

5. Select one or more Colleges

6. Select one or more Departments

7. Select one or more Course Sections

8. Select one or more Rubrics

9. Select one or more Standard Sets

10. Select one or more Standards

11. Select one or more Student Gender

12. Select one or more Student Ethnicity

13. Select one or more Completion Year

14. Select one or more Major

15. Select one or more Academic Program

 

NOTE: Student Gender, Ethnicity, Completion Year, Major, and Academic Program data is added through the Student Profiles import

 

16. Select an Extract Format: Classic Format or Advanced Format

17. Select a format to Export To: Microsoft Excel or Comma Separated Value (CSV)

18. Click Export

 

 


Export Course Assessments – fields

Column Field Title Data
A Rec ID The serial number is used by the system that is unique and non-repeating.
B Term The term/semester in which the assessment took place.
C Course ID The course number that is listed for the course (CRN number).
D Course Code The course code is the number that is listed for each course in the student handbook, e.g. LT 101.
E Course Name The name of the course in which faculty and student are enrolled.
F College The name of the college or school with which the student is associated with, e.g. College of Education or School of Business.
G Department The department or unit with which the student is associated with in the college, e.g. Secondary Education.
H Program The program or area of study within a department, e.g. Special Education, Social Science.
I Section ID The number given to each section of a course.
J Assessee Username The username of the author of the assessed document.
K Assessee Full-Name The full name of the author of the assessed document.



Export Course Assessments – Understanding RL and RS fields
Each row in the export contains columns marked with RL, RS and a number. This is the representation of the collected assessment data. RL is an abbreviation for “Row Level” and represents the rows of a rubric. RL1 is the first row in the rubric, RL2 is the second row, and so on. The number in this field is the position of the selected performance level column. A “1” in this field would indicate that the assessor selected the left-most column of the rubric for an element, a “2” would indicate the next column to the right was selected and so on. The numbers in the RL fields do NOT represent performance level point values or reflect element weighting.

Note: The number of RL columns containing values will depend on the length of the longest rubric in the ExhibitCenter™. Therefore, for shorter rubrics, some RL fields may be empty.

A sample line from the export appears below.

8.jpg

This is visually represented in the following diagram:
9.jpg
RS is an abbreviation for “Row Score” and represents the weighted score the assessee received based on the point value associated with each performance level and the weight value of each row in the rubric. It is calculated by multiplying the point value of the selected performance level by the weight value of that row. A sample of the same line in the report, which was used in the previous example, is displayed below.

A sample of the same line in the report, which was used in the previous example, appears below.
10.jpg
In this example, the rows contain weights of 2, 4, 2, 1, and 1 respectively. The columns contain a score of 3, 2, 1, and 0. Multiplying the selected column by the weight value of that particular row (not the percentage value) produces the scores that appear in the table above.

The following diagram shows how this relates to the original rubric.
11.jpg
Note: The number of RS columns containing values will depend on the length of the longest rubric in the ExhibitCenter™. Therefore, for shorter rubrics, some RS fields may be empty.
 

 

Articles in this section

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!