Data Extracts

Export Raw Data
All data collected within LiveText can be exported to three data export features for LiveText administrators. These features are for administrators who use other data analysis tools in addition to the LiveText reporting and display features. The data is exported in a common file format, CSV, and can be imported into most data analysis tools. These data files can also be connected to LiveText documents and stored in the ExhibitCenter™.

NOTE: This report requires that a special permission be placed on the account with the approval of the institution. If you do not see the Export buttons on the Tools tab in your administrator account, please email support@watermarkinsights.com.

Export Assessments
The Export Assessment button creates a raw data file in a CSV format for all assessment data collected across all rubrics linked in the ExhibitCenter™ (data collected in the Send for Review process)

To export assessment data using Export Assessments:

  1. From within the Tools tab click the Reports tab
  2. Click the Export Assessments button
1.jpg
  1. Select whether to open the file immediately with Excel (if installed) or to save the file to the local computer. Click the OK button

Export Assessments - fields
The following table lists the fields in the exported file, the data contained in each, and what the data represents. Each rubric within the assessment document will have its own line in this export. Each assessment will be tagged with the following data fields in the export.
 

Column Field Title Data
A Rec ID A serial number used by the system that is unique and non-repeating.
B Assessee Username The username of the author of the assessed document.
C Assessee Full-Name The full name of the author that assessed the document.
D School ID The school ID of the author entered in user Account Info page or when the user registered with LiveText.
E Assessor Username The username of the evaluator of the document.
F Assessor Full-Name The full name of the evaluator
G Artifact ID The Document ID of the assessed document. It is unique to each LiveText document and in the URL (e.g. https://www.livetext.com/doc/10325837).
H Artifact Title The title of the assessed document.
I Assessment ID The Document ID of the assessed document used to evaluate the artifact. It is unique to each LiveText document and in the URL (e.g. https://www.livetext.com/doc/10325837).
J Assessment Title The title of the document used to assess the artifact.
K Rubric ID The section ID of the rubric within the assessment document. It is unique to each section of the LiveText document and in the URL (e.g.https://www.livetext.com/doc/10401030/46579080).
L Rubric Title The title of the rubric section within the assessment document.
M Data Assessed The date the assessment was last modified, saved or submitted.
N Milestone The milestone selected at the time of the assessment.
O Scoring P indicates that Practice was selected when the assessment was last modified, saved, or submitted. O indicates that Official was selected.
P Status S indicates that the assessment was Submitted using the “Save and Submit Assessment” button at the time of the assessment. P indicates that the assessment was Pending. It was saved but has not been submitted.



Export 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.

Screenshot_2022-05-17_150510.jpg
These values are visually represented in the following diagram:
2.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.
3.jpg
In this example, the rows have weights of 2, 4, 2, 1 and 1 respectively. The columns have 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 diagram below shows how this relates to the original rubric.
4.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.




Export Rubric Standards
The Export Rubric Standards button creates a raw data file in a CSV format of all standards that are aligned with elements in rubrics within all assessments that are linked in the ExhibitCenter™. It is intended to be combined with the information generated by the Export Assessment feature to connect the assessment data with standards.

To export a list of standards in rubrics using Export Rubric Standards:
  1. From within the Tools tab click the Reports tab.
  2. Click the Export Rubric Standards button.
5.jpg
  1. Select whether to open the file immediately with Excel (if installed) or to save the file to the local computer. Click the OK button

The following table lists the fields in the exported file, the data contained in each, and what the data represents. Each standard within the rubric document will have its own line in this export. For example, if an element of the rubric contains five standards, the rubric element will have five separate lines in the export.

Export Rubric Standards - fields

Column Field Title Data
A Rubric ID The Section ID of the rubric within the assessment document. This is the same information that appears in the Export Assessments report.
B Element Identifies the row in the rubric that the standard is aligned with.
C Standard The number of the standard.
D Standard Set The source of the standard set
6.jpg
When combined with the assessment export in a data analysis tool, this report can be used to create a report of student performance as well as instructor and/or program effectiveness that links information to standards.



Export Course Assessments
The Export Course Assessments button creates a raw data file in a CSV format of all assessment data collected in all rubrics. The data collected allows administrators to view student growth within courses. Once the data is exported, the information can be sorted by course(s), student(s), faculty, assessment(s), and term(s).

To export all course-based assessment data using Export Course Assessments
  1. From within the Tools tab, click the Reports tab.
  2. Click the Export Course Assessment button.
7.jpg
  1. Select whether to open the file immediately with Excel (if installed) or to save the file to the local computer. Click the OK button.


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.
 
Was this article helpful?
0 out of 0 found this helpful

Articles in this section

How to Contact Support
Click the "Submit A Request" button at the top right or bottom of the screen to create a case.
Watermark Academy
Click to access the Watermark Academy for free webinars, workshops, certifications, and free on-demand training