Difference between revisions of "TSDL/CVR"

From EDgearWiki
Jump to navigationJump to search
 
(118 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
'''NOTE: THIS IS NO LONGER THE EAGLE UPLOAD AS OF 2015.''' Go to [[DRC E-Direct Export]]
+
__NOTOC__
 +
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/EOC''' program serves two purposes:  
+
'''The TSDL /CVR (Curriculum Verification & Roster Portal) program serves two purposes:'''
  
−
(1) Create '''EOC files''' for the state EOC testing system (www.louisianaeoc.org)
+
*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.
 +
*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.
  
−
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.
+
==Menu Location==
  
 +
'''Student > Interfaces > TSDL/CVR'''
  
−
===How-to===
+
==Setup Options==
−
In the left navigation panel, go to '''Student Master''', '''Interfaces''', then '''TSDL/CVR'''.
 
  
 +
[[File:tsdlsetup3.png]]
  
−
'''Setup Box Options'''
+
'''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==
 +
 
 +
[[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]].
  
−
To find definitions for standard setup values, follow this link: '''<span style="background:yellow">[[Standard Setup Options]]</span>'''.
 
  
−
For other set up values not listed in the standard set up list:
 
  
−
* '''School''':  Click then select some or all of the schools.
 
−
**'''NOTE''':  Some large districts are reporting that the TSDL system cannot process the entire district at one time.  Therefore, if a large district, it may be necessary to select a group of schools at a time to split the district into several files. 
 
−
* '''Course Grades''':  Leave blank unless user wishes to only send courses for selected grade levels.
 
−
* '''As of Date''':  Usually set for current date. This is looking at the "as of" student enrollment date.
 
−
* '''Semesters''':  Select all semesters.
 
−
* '''Transcript Groups''':  Leave blank, or select all.  (Same)
 
−
* '''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.
 
−
* '''Upload Type:''' Choose a district upload or a school upload
 
−
* '''File Format:''' Determine what processing period you are in:
 
−
**Use '''1415 TSDL Format''' during the TSDL processing period.
 
−
**Use '''EOC Format''' after the TSDL processing period is over and it is time for EOC testing.
 
−
* '''Pacific Metrics Agreement:''' Select this  option for record formatting if your district has an agreement with Pacific Metrics.  Leave this box unselected if your district does not have an agreement with Pacific Metrics.
 
−
* '''Use SIS School:'''  Click if your district is using SIS School functionality.
 
−
* '''Show only courses with final weight:'''  Select if building a file for EOC system, otherwise, leave deselected for TSDL file creation.
 
−
* '''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.
 
−
<br>*[[File:EOC setup.png]]<br><br>
 
−
Click the '''OK''' button to begin the file creation.
 
 
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.
−
The '''EOC''' will use the [[Jdive]] mthod and the '''TSDL''' will use the '''Save As''' method.
+
*The '''EOC''' will use the [[JDrive]] 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>
+
*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'''. <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.
+
 
 +
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.
  
  
Line 50: Line 165:
  
 
----
 
----
−
[http://wiki.edgear.net/wiki/w/index.php?title=Student_Master '''Student Master''' Main Page]
+
[[Student Master|'''Student Master''' Main Page]]
 +
----
 +
[[WebPams|'''JCampus''' Main Page]]

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