Difference between revisions of "Cohort Year Import"
| Line 4: | Line 4: | ||
The layout listed below is the correct format. The file should be a .csv file without headers. | The layout listed below is the correct format. The file should be a .csv file without headers. | ||
| + | |||
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. | ||
Revision as of 07:26, 3 April 2018
The purpose for this program is to import the Cohort Year data for students into JCampus from a the Cohort Year file downloaded from the LDOE using a .csv.
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.
Accessing the Cohort Year Inport Program
JCampus > Student Master > Loaders > Cohort Year Import
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 your security settings. You will be limited to your district only.
- Choose 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 site. Once the file is selected, the name of the file will be displayed to the right of the Choose File button.
- Clicking on the OK button to bring up the following Warning window:
Cohort Year Import Warning
- Click Yes to continue with the import or click No to abort the export.
Cohort Year Import Report Columns
Once the import has completed, the records imported will be displayed in a report with the following columns:
- 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.
Buttons at the Bottom of the Page
- Setup: Clicking the Setup button will display the original setup box with the previously selected settings displayed.
- Print: Clicking the Print button will bring up the Print Dialog box.
- Help: Clicking on the Help button will take you to Student Master in the help system.
Last Updated: 2015-11-23 (rd)
