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.
This is visually represented in the following diagram:
A sample of the same line in the report, which was used in the previous example, appears below.
The following diagram shows how this relates to the original rubric.