Difference between revisions of "Cohort Year Import"
| (17 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__ | ||
| − | '''The purpose for this program is to import the Cohort Year data for students into JCampus from the file | + | '''The purpose for this program is to import the Cohort Year data for students with the most recent file layout into JCampus from the file provided from the LDOE FTP site.''' |
| − | |||
'''NOTE:''' The layout listed below is the correct format. The file should be a .csv file without headers. | '''NOTE:''' The layout listed below is the correct format. The file should be a .csv file without headers. | ||
| Line 7: | Line 6: | ||
Here is the list of headers: | Here is the list of headers: | ||
Cohort Start Year, Last Name (first 3 letters) , First Name (first 3 letters), LASID, 2017-18 LEA Code, 2017-18 LEA Name, 2017-18 School Site Code, 2017-18 School Name, Include in LEA Rate, Include in Site Rate, Last Grade Enrolled*, Cohort Status as of Oct 1, 2017, Diploma Pathway, Age Risk, Credits Earned, Credits Risk, Algebra 1 Level, Algebra 1 Risk, Geometry EOC Level, Geometry EOC Risk, English II EOC Level, English II Risk, English III EOC Level, English III EOC Risk, Biology EOC Level, Biology EOC Risk, US History EOC Level, US History EOC Risk, ACT Composite, ACT Risk, LAA 1 Participant, Discipline Incidences Days, Discipline Incidences Risk, Mobility Number of school, Mobility Risk, Days Absent, Days Absent Risk. | Cohort Start Year, Last Name (first 3 letters) , First Name (first 3 letters), LASID, 2017-18 LEA Code, 2017-18 LEA Name, 2017-18 School Site Code, 2017-18 School Name, Include in LEA Rate, Include in Site Rate, Last Grade Enrolled*, Cohort Status as of Oct 1, 2017, Diploma Pathway, Age Risk, Credits Earned, Credits Risk, Algebra 1 Level, Algebra 1 Risk, Geometry EOC Level, Geometry EOC Risk, English II EOC Level, English II Risk, English III EOC Level, English III EOC Risk, Biology EOC Level, Biology EOC Risk, US History EOC Level, US History EOC Risk, ACT Composite, ACT Risk, LAA 1 Participant, Discipline Incidences Days, Discipline Incidences Risk, Mobility Number of school, Mobility Risk, Days Absent, Days Absent Risk. | ||
| − | |||
==Menu Location== | ==Menu Location== | ||
| − | |||
| − | + | '''Student > Loaders > Cohort Year Import''' | |
==Setup Options== | ==Setup Options== | ||
| + | |||
[[File:cohort info 1.png]] | [[File:cohort info 1.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''' | + | '''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. | ||
| + | |||
| + | '''Grade''' - Leave blank or select all to include all grade levels. Otherwise, choose the desired grade level. | ||
'''File''': Clicking on the '''Choose File''' button will bring up dialog box that will allow the user to navigate to file that was downloaded from the LDOE FTP site. Once the file is selected, the name of the file will be displayed to the right of the '''Choose File''' button. | '''File''': Clicking on the '''Choose File''' button will bring up dialog box that will allow the user to navigate to file that was downloaded from the LDOE FTP site. Once the file is selected, the name of the file will be displayed to the right of the '''Choose File''' button. | ||
| − | + | '''Print''' - To find the print instructions, follow this link: [[Standard Print Options]]. | |
| + | |||
| + | '''OK''' - Click to continue. | ||
[[File:cohort info 2.png]] | [[File:cohort info 2.png]] | ||
| Line 34: | Line 38: | ||
===Column Headers=== | ===Column Headers=== | ||
| − | |||
| − | ''' | + | '''School''' - Displays the school ID Number. |
| − | ''' | + | '''First Name''' - Displays the student's first name. |
| − | ''' | + | '''Last Name''' - Displays the student's last name. |
| − | '''Cohort Year''' | + | '''SIDNO''' - Displays the student's 7-digit student ID number. |
| + | |||
| + | '''Cohort Year''' - Displays the student's 4-digit cohort year. | ||
| + | |||
| + | To find definitions of commonly used column headers, follow this link: [[Common Column Headers]]. | ||
==Bottom== | ==Bottom== | ||
| − | |||
| − | '''Setup''' | + | [[File:sch9.png]] |
| + | |||
| + | '''Setup''' - Click to go back to the Setup box. | ||
| + | |||
| + | [[Standard Print Options | '''Print''']] - This will allow the user to print the report. | ||
| + | |||
| + | '''Help''' - Click to view written instructions and/or videos. | ||
| + | |||
| + | =='''Q & A'''== | ||
| − | ''' | + | '''Q''' - If a student graduates high school a year earlier than their original cohort, should their 9th grade entry year be changed so that their data can be included with the cohort they finished with or should nothing be changed and their data be included a year later with their original cohort? |
| − | ''' | + | '''A''' - There will be no need to change the cohort year for early grads because the cohort year is only used when the student's graduation year is more than 4 years after the fall of the cohort year. |
| − | |||
Latest revision as of 15:56, 18 July 2023
The purpose for this program is to import the Cohort Year data for students with the most recent file layout into JCampus from the file provided from the LDOE FTP site.
NOTE: The layout listed below is the correct format. The file should be a .csv file without headers.
Here is the list of headers: Cohort Start Year, Last Name (first 3 letters) , First Name (first 3 letters), LASID, 2017-18 LEA Code, 2017-18 LEA Name, 2017-18 School Site Code, 2017-18 School Name, Include in LEA Rate, Include in Site Rate, Last Grade Enrolled*, Cohort Status as of Oct 1, 2017, Diploma Pathway, Age Risk, Credits Earned, Credits Risk, Algebra 1 Level, Algebra 1 Risk, Geometry EOC Level, Geometry EOC Risk, English II EOC Level, English II Risk, English III EOC Level, English III EOC Risk, Biology EOC Level, Biology EOC Risk, US History EOC Level, US History EOC Risk, ACT Composite, ACT Risk, LAA 1 Participant, Discipline Incidences Days, Discipline Incidences Risk, Mobility Number of school, Mobility Risk, Days Absent, Days Absent Risk.
Menu Location
Student > Loaders > Cohort Year Import
Setup 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.
Grade - Leave blank or select all to include all grade levels. Otherwise, choose the desired grade level.
File: Clicking on the Choose File button will bring up dialog box that will allow the user to navigate to file that was downloaded from the LDOE FTP site. Once the file is selected, the name of the file will be displayed to the right of the Choose File button.
Print - To find the print instructions, follow this link: Standard Print Options.
OK - Click to continue.
Click Yes to continue with the import or click No to abort.
Main
Column Headers
School - Displays the school ID Number.
First Name - Displays the student's first name.
Last Name - Displays the student's last name.
SIDNO - Displays the student's 7-digit student ID number.
Cohort Year - Displays the student's 4-digit cohort year.
To find definitions of commonly used column headers, follow this link: Common Column Headers.
Bottom
Setup - Click to go back to the Setup box.
Print - This will allow the user to print the report.
Help - Click to view written instructions and/or videos.
Q & A
Q - If a student graduates high school a year earlier than their original cohort, should their 9th grade entry year be changed so that their data can be included with the cohort they finished with or should nothing be changed and their data be included a year later with their original cohort?
A - There will be no need to change the cohort year for early grads because the cohort year is only used when the student's graduation year is more than 4 years after the fall of the cohort year.
