Difference between revisions of "TSDL/CVR"

From EDgearWiki
Jump to navigationJump to search
 
(104 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/CVR/EOC''' program serves two purposes:
+
'''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).'''
  
−
(1) Create '''EOC files''' for the state EOC testing system (www.louisianaeoc.org)
+
'''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).
 
    
 
    
−
(2) Create '''TSDL/CVR files''' for the state TSDL system.
+
'''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.
−
The primary difference between the two is the use of the setting '''Show only courses with final weight'''.  When this is selected, the system assumes that an EOC file is being created, and only EOC courses that have a final weight in the course catalog will be submitted.  When the setting 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==
 
==Menu Location==
  
−
[[File:tsdlmenu.png]]
+
'''Student > Interfaces > TSDL/CVR'''
−
 
 
−
 
 
−
In the left navigation panel, select '''Student Master''' > '''Interfaces''' > '''TSDL/CVR'''.
 
  
 
==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.
  
−
'''District''' - Default value is based on your security settings. You will be limited to your district only.
+
'''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.  
  
−
'''School''' - Default value is based on your security settings. If you are assigned to a school, the school default value will be your school site code. You will not be able to change this
+
'''Course Grade''' - Leave blank unless user wishes to only send courses for selected grade levels.
−
value. If you are a supervisor or other district office employee with access to the Student Information System, you will be able to run programs for one school, a small group of schools, or
 
−
all schools in your district.
 
  
−
'''Course Grades''' - 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.
  
−
'''Semesters''' - Select all semesters.
+
'''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==
 +
 
 +
[[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.
  
−
'''Transcript Groups''' - Leave blank, or select all. (Same)
+
'''Pacific Islander''' - Student is Native Hawaiian/other Pacific Islander.
  
−
'''Courses''' - Click to bring up a list of courses.  Click the '''Select All''' box in the upper left, then click '''OK''' to close the courses pick list.
+
'''White''' - Student is White/Caucasion.
  
−
'''Upload Type''' - Choose a district upload or a school upload
+
'''Homeless''' - Student's homeless code.
  
−
'''File Format''' - Determine what processing period you are in
+
'''Car Dip''' - Student's career option.
  
−
Use '''1415 TSDL Format''' during the TSDL processing period.  
+
'''Teacher SSN''' - Staff member's Social Security Number.
  
−
'''Send in EOC Format''' THIS SELECTION IS NO LONGER NEEDED SO DO NOT USE! 
+
'''SDate''' - Section's start date.
  
−
'''Pacific Metrics Agreement''' - THIS SELECTION IS NO LONGER NEEDED SO DO NOT USE!
+
'''EDate''' - Section's end date.
  
−
'''Use SIS School''' - Click if your district is using SIS School functionality.
+
To find definitions of commonly used column headers, follow this link: [[Common Column Headers]].
  
−
'''Show only courses with final weight''' - To submit your EOC classes to TSDL, choose the "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.
 
  
 
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. <br>[[File:EOCExportSelectAllRecords.png]]<br><br>
 
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. <br>[[File:EOCExportSelectAllRecords.png]]<br><br>
 
Click the '''Export''' button at the bottom of the screen.
 
Click the '''Export''' button at the bottom of the screen.
−
'''NOTE:'''  The '''EOC''' will use the [[JDrive]] method and the '''TSDL''' will use the '''Save As''' method.
+
*The '''EOC''' will use the [[JDrive]] method.
 +
*The '''TSDL''' will use the '''Save As''' method.
  
−
The program will open another screen with class records.  Right click anywhere on the screen and select '''Save as'''. <br>[[File:EOCExportSelectAllFileCreate.png]]<br><br>
+
For the '''Save As''' method, the program will open another screen with class records.  Right click anywhere on the screen and select '''Save as'''. <br>[[File:EOCExportSelectAllFileCreate.png]]<br><br>
 
Browse to where you would like to store the file, then click the '''Save''' button. <br>[[File:EOCExportSaveFile.png]]<br><br>
 
Browse to where you would like to store the file, then click the '''Save''' button. <br>[[File:EOCExportSaveFile.png]]<br><br>
 
The file will be placed in the location saved.
 
The file will be placed in the location saved.
−
Open up the TSDL 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.
 
  
−
To find definitions for standard setup values, follow this link: '''<span style="background:yellow">[[Standard Setup Options]]</span>'''.
+
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