Difference between revisions of "TSDL/CVR"

From EDgearWiki
Jump to navigationJump to search
 
(44 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
__NOTOC__
 
__NOTOC__
−
'''NOTE: THIS IS NO LONGER THE EAGLE UPLOAD AS OF 2015. Go to [[DRC E-Direct Export]]'''
+
NOTE: DOE no longer uses TSDL anymore for EDLink. See the [[LA EDLink Reporting]] > [[Staff tab]] page > CVR Partial StaffID's information.
  
 +
'''The TSDL (Teacher Student Data Link) report links between students and the teachers who provide instruction to them. TSDL assessment collections goes to DRC (Data Recognition Corporation).''' 
  
−
The '''TSDL''' Teacher Student Data Link /'''CVR''' Curriculum Verification & Roster Portal /'''EOC''' End of Course program serves two purposes:
+
'''The TSDL /CVR (Curriculum Verification & Roster Portal) program serves two purposes:'''
  
 
*To create student rosters for test booklets and '''TSDL/CVR''' files for the state  Teacher Student Data Link system.
 
*To create student rosters for test booklets and '''TSDL/CVR''' files for the state  Teacher Student Data Link system.
−
*To create '''EOC files''' for the state EOC testing system (www.louisianaeoc.org).
+
*To create '''EOC (End of Year) files''' for the state EOC testing system (www.louisianaeoc.org).
 
    
 
    
−
The primary '''difference''' between the two is:
+
'''The primary difference between the two are:'''
 
*When '''Show only courses with final weight''' is not selected, the system assumes a '''TSDL''' file is being created, and all selected courses are included in the TSDL file.  
 
*When '''Show only courses with final weight''' is not selected, the system assumes a '''TSDL''' file is being created, and all selected courses are included in the TSDL file.  
 
*When '''Show only courses with final weight''' is selected, the system assumes that an '''EOC''' file is being created.  Only EOC courses, that have a final weight in the course catalog, are included in the file that will be submitted.   
 
*When '''Show only courses with final weight''' is selected, the system assumes that an '''EOC''' file is being created.  Only EOC courses, that have a final weight in the course catalog, are included in the file that will be submitted.   
Line 14: Line 15:
 
==Menu Location==
 
==Menu Location==
  
−
[[File:tsdlmenu.png]]
+
'''Student > Interfaces > TSDL/CVR'''
−
 
 
−
On the left navigation panel, select '''Student Master''' > '''Interfaces''' > '''TSDL/CVR'''.
 
−
(TSDL is the acronym for Teacher Student Data Link)
 
  
 
==Setup Options==
 
==Setup Options==
  
−
[[File:tsdlsetup.png]]
+
[[File:tsdlsetup3.png]]
  
 
'''Year''' - Defaults to the current year. A prior year may be accessed by clicking in the field and making the appropriate selection from the drop down list.
 
'''Year''' - Defaults to the current year. A prior year may be accessed by clicking in the field and making the appropriate selection from the drop down list.
Line 29: Line 27:
 
'''School''' - Default value is based on the user's security settings. If the user is assigned to a school, the school default value will be their school site code.  
 
'''School''' - Default value is based on the user's security settings. If the user is assigned to a school, the school default value will be their school site code.  
  
−
'''Course Grades''' - Leave blank unless user wishes to only send courses for selected grade levels.
+
'''Course Grade''' - Leave blank unless user wishes to only send courses for selected grade levels.
 +
 
 +
'''Student Grade''' - Select student's grade(s) to process.
  
 
'''As of Date''' - This choice will list only those students who are actively enrolled as of the date selected in the date field.
 
'''As of Date''' - This choice will list only those students who are actively enrolled as of the date selected in the date field.
Line 37: Line 37:
 
'''Transcript Group''' - The user can leave blank (or use the select all), to have all transcript groups included in the file. Otherwise, choose specific groups.
 
'''Transcript Group''' - The user can leave blank (or use the select all), to have all transcript groups included in the file. Otherwise, choose specific groups.
  
−
'''Courses''' - The user can leave blank (or use the select all), to have all courses included in the file. Otherwise, choose specific courses that can be limited to the transcript groups chosen above.
+
'''Courses''' - Choose specific courses that can be limited to the transcript groups chosen above.
  
 
'''Upload Type''' - Choose a district upload or a school upload. If using a large district, select one or more schools at a time.
 
'''Upload Type''' - Choose a district upload or a school upload. If using a large district, select one or more schools at a time.
  
−
'''Upload Type (File Format)'''  
+
'''Upload Layout''' - Select option '''TSDL 1.2, TSDL 2.2 or EOC'''. It will default to TSDL 2.2 when the user first runs the program. The upload layout will be saved when OK is clicked on the setup and restored upon the next execution. The TSDL 2.2 layout requires that all students have a ELL status reported.  
−
*'''Send in 1415 TSDL Format'''  - Select to build a TSDL formatted file for use during the TSDL processing periods.  
 
−
*'''Send in EOC Format''' THIS SELECTION IS NO LONGER NEEDED SO DO NOT USE! 
 
  
 
'''Pacific Metrics Agreement''' - THIS SELECTION IS NO LONGER NEEDED SO DO NOT USE!  
 
'''Pacific Metrics Agreement''' - THIS SELECTION IS NO LONGER NEEDED SO DO NOT USE!  
Line 52: Line 50:
  
 
'''Show whole student name''' - Select to show the student's whole first and last name in the file. If not checked, you will only see the first letter of the first name and the first three  
 
'''Show whole student name''' - Select to show the student's whole first and last name in the file. If not checked, you will only see the first letter of the first name and the first three  
−
letters of the last name.
+
letters of the last name. Changing the Upload Layout to TSDL 2.2 will uncheck the 'Show Whole Student Name' box but the user will be allowed to enter a check in the box.
  
 
'''OK''' - Click to continue.
 
'''OK''' - Click to continue.
  
 
To find definitions for standard setup values, follow this link: [[Standard Setup Options]].
 
To find definitions for standard setup values, follow this link: [[Standard Setup Options]].
 +
 +
==Main==
 +
 +
[[File:tsdlmain.png]]
 +
 +
===Column Headers===
 +
 +
'''Sysi''' - System indicator.
 +
 +
'''Dist''' - District number.
 +
 +
'''Type''' - Record Type.
 +
 +
'''Site''' - Site code (district and school).
 +
 +
'''Teacher First Name''' - Teacher's first name.
 +
 +
'''Teacher Middle Name''' - Teacher's middle name.
 +
 +
'''Teacher Last Name''' - Teacher's last name.
 +
 +
'''Suffix''' - Teacher's generational suffix.
 +
 +
'''State Code''' - State code.
 +
 +
'''PD''' - Sections class period.
 +
 +
'''Class Code''' - Class code.
 +
 +
'''Class Type''' - Class type (0-day or 1-night).
 +
 +
'''Student First Name''' - Student's first name.
 +
 +
'''FName Filler''' - Student's first name filler.
 +
 +
'''Student Last Name''' - Student's last name.
 +
 +
'''LName Filler''' - Student's last name filler.
 +
 +
'''State ID Number''' - Student's state identification number.
 +
 +
'''Student DOB''' - Student's date of birth.
 +
 +
'''Gender''' - Student's gender.
 +
 +
'''GD''' - Student's grade of enrollment.
 +
 +
'''ED Class''' - Student's education classification.
 +
 +
'''LEP''' - Student is designated as being Limited English Proficient.
 +
 +
'''Lunch''' - Student's lunch eligibility.
 +
 +
'''Mig''' - Student's migrant status.
 +
 +
'''504''' - Is student 504.
 +
 +
'''Pri Exc''' - Primary exceptionality.
 +
 +
'''Hispanic''' - Hispanic/Latino.
 +
 +
'''Indian''' - Student is American Indian/Alaskan Native.
 +
 +
'''Asian''' - Student is Asian.
 +
 +
'''Black''' - Student is Black/African American.
 +
 +
'''Pacific Islander''' - Student is Native Hawaiian/other Pacific Islander.
 +
 +
'''White''' - Student is White/Caucasion.
 +
 +
'''Homeless''' - Student's homeless code.
 +
 +
'''Car Dip''' - Student's career option.
 +
 +
'''Teacher SSN''' - Staff member's Social Security Number.
 +
 +
'''SDate''' - Section's start date.
 +
 +
'''EDate''' - Section's end date.
 +
 +
To find definitions of commonly used column headers, follow this link: [[Common Column Headers]].
  
  
Line 70: Line 150:
  
 
Open up the T'''SDL or EOC [http://www.louisianaeoc.org/] upload site''', then upload the file to the system following the Louisiana Dept of Education procedures for their website.
 
Open up the T'''SDL or EOC [http://www.louisianaeoc.org/] upload site''', then upload the file to the system following the Louisiana Dept of Education procedures for their website.
 +
 +
==Bottom==
 +
 +
[[File:tsdlbottom.png]]
 +
 +
'''Setup''' - Click to go back to the Setup box.
 +
 +
'''Help''' - Click to view written instructions and/or videos.
 +
 +
'''Export''' - Click to create the TSDL fixed length file for export, or the EOC commas separated value file(s) depending on your options.
 +
  
  

Latest revision as of 09:12, 20 July 2023

NOTE: DOE no longer uses TSDL anymore for EDLink. See the LA EDLink Reporting > Staff tab page > CVR Partial StaffID's information.

The TSDL (Teacher Student Data Link) report links between students and the teachers who provide instruction to them. TSDL assessment collections goes to DRC (Data Recognition Corporation).

The TSDL /CVR (Curriculum Verification & Roster Portal) program serves two purposes:

  • To create student rosters for test booklets and TSDL/CVR files for the state Teacher Student Data Link system.
  • To create EOC (End of Year) files for the state EOC testing system (www.louisianaeoc.org).

The primary difference between the two are:

  • When Show only courses with final weight is not selected, the system assumes a TSDL file is being created, and all selected courses are included in the TSDL file.
  • When Show only courses with final weight is selected, the system assumes that an EOC file is being created. Only EOC courses, that have a final weight in the course catalog, are included in the file that will be submitted.

Menu Location

Student > Interfaces > TSDL/CVR

Setup Options

Tsdlsetup3.png

Year - Defaults to the current year. A prior year may be accessed by clicking in the field and making the appropriate selection from the drop down list.

District - Default value is based on the user’s security settings. The user will be limited to their district only.

School - Default value is based on the user's security settings. If the user is assigned to a school, the school default value will be their school site code.

Course Grade - Leave blank unless user wishes to only send courses for selected grade levels.

Student Grade - Select student's grade(s) to process.

As of Date - This choice will list only those students who are actively enrolled as of the date selected in the date field.

Semesters - Select all semesters, unless using a large district. In that case, choose one semester at a time.

Transcript Group - The user can leave blank (or use the select all), to have all transcript groups included in the file. Otherwise, choose specific groups.

Courses - Choose specific courses that can be limited to the transcript groups chosen above.

Upload Type - Choose a district upload or a school upload. If using a large district, select one or more schools at a time.

Upload Layout - Select option TSDL 1.2, TSDL 2.2 or EOC. It will default to TSDL 2.2 when the user first runs the program. The upload layout will be saved when OK is clicked on the setup and restored upon the next execution. The TSDL 2.2 layout requires that all students have a ELL status reported.

Pacific Metrics Agreement - THIS SELECTION IS NO LONGER NEEDED SO DO NOT USE!

Use SIS School - Check if your district is using SIS School functionality.

Show Only Courses With Final Weight - To submit your EOC courses to TSDL, choose the "Send in 1415 TSDL Format" and then select "Show only Courses with Final Weight".

Show whole student name - Select to show the student's whole first and last name in the file. If not checked, you will only see the first letter of the first name and the first three letters of the last name. Changing the Upload Layout to TSDL 2.2 will uncheck the 'Show Whole Student Name' box but the user will be allowed to enter a check in the box.

OK - Click to continue.

To find definitions for standard setup values, follow this link: Standard Setup Options.

Main

Tsdlmain.png

Column Headers

Sysi - System indicator.

Dist - District number.

Type - Record Type.

Site - Site code (district and school).

Teacher First Name - Teacher's first name.

Teacher Middle Name - Teacher's middle name.

Teacher Last Name - Teacher's last name.

Suffix - Teacher's generational suffix.

State Code - State code.

PD - Sections class period.

Class Code - Class code.

Class Type - Class type (0-day or 1-night).

Student First Name - Student's first name.

FName Filler - Student's first name filler.

Student Last Name - Student's last name.

LName Filler - Student's last name filler.

State ID Number - Student's state identification number.

Student DOB - Student's date of birth.

Gender - Student's gender.

GD - Student's grade of enrollment.

ED Class - Student's education classification.

LEP - Student is designated as being Limited English Proficient.

Lunch - Student's lunch eligibility.

Mig - Student's migrant status.

504 - Is student 504.

Pri Exc - Primary exceptionality.

Hispanic - Hispanic/Latino.

Indian - Student is American Indian/Alaskan Native.

Asian - Student is Asian.

Black - Student is Black/African American.

Pacific Islander - Student is Native Hawaiian/other Pacific Islander.

White - Student is White/Caucasion.

Homeless - Student's homeless code.

Car Dip - Student's career option.

Teacher SSN - Staff member's Social Security Number.

SDate - Section's start date.

EDate - Section's end date.

To find definitions of commonly used column headers, follow this link: Common Column Headers.


The program will work a while, then present a listing of class records to be included in the file. Click the Select All box in the upper left.
EOCExportSelectAllRecords.png

Click the Export button at the bottom of the screen.

  • The EOC will use the JDrive method.
  • The TSDL will use the Save As method.

For the Save As method, the program will open another screen with class records. Right click anywhere on the screen and select Save as.
EOCExportSelectAllFileCreate.png

Browse to where you would like to store the file, then click the Save button.
EOCExportSaveFile.png

The file will be placed in the location saved.

Open up the TSDL or EOC [1] upload site, then upload the file to the system following the Louisiana Dept of Education procedures for their website.

Bottom

Tsdlbottom.png

Setup - Click to go back to the Setup box.

Help - Click to view written instructions and/or videos.

Export - Click to create the TSDL fixed length file for export, or the EOC commas separated value file(s) depending on your options.



Student Master Main Page

JCampus Main Page

Retrieved from EDgear Wiki