student data management career and technical education pathways updated july 18, 2013 an equal...
TRANSCRIPT
Student Data ManagementStudent Data Management
Career and Technical Education Pathways
Updated July 18, 2013
An Equal Employment/Educational Opportunity AgencyThe Kansas State Department of Education does not discriminate on the basis of race, color, national origin, sex, disability, or age in its programs and activities. The following person has been designated to handle inquiries regarding the non-discrimination policies: KSDE General Counsel, 120 SE 10th Ave., Topeka, KS 66612 785-296-3201
Kansas State Department of Educationwww.ksde.org
This can be done as soon as KIDS SCRS are done for the year
Kansas State Department of Educationwww.ksde.org
Overview Assign Teachers to Pathways (*June 15th-August 15th) Assign Students to Pathways (*June 15th-August 15th) Update student statuses as participants or concentrators for the
2011-2012 school year (*June 15th-August 15th) Enter the previous year’s Follow-up Data for VE-2 and Pathways
Students (Due April 15th)
*This can be done as soon as the KIDS EOYA and STCO are done for the year.
Kansas State Department of Educationwww.ksde.org
Slide OrderSlide 6-10: RegistrationSlide 11-27: Pathway Assign Teacher, Assign Student, Update
Student
Slide 15-16: Assign Teacher (Future Automation)Slide 17-20: Assign StudentSlide 21-22: Student Data Upload OptionSlide 23-27: Update Student Data
Slide 25: Pathways without concentratorsSlide 26-27: Career Goal DataSlide 28-36: ReportsSlide 37 – 39: Student Follow UpSlide 40: Questions?
Kansas State Department of Educationwww.ksde.org
RegistrationRegistration
New Users
Kansas State Department of Educationwww.ksde.org
Kansas State Department of Educationwww.ksde.org
This step is for new usersComplete the information on the registration sheet.
Choosing a building (the high school) from the building drop down box allows the user to apply for a school-type role “School Update or Approve” that is connected to only that one building.
By choosing all buildings the user will be able to choose the “District/Org Update” role.
Kansas State Department of Educationwww.ksde.org
*This step is for new users only*
Once registered:• Follow up with
superintendent to ensure he/she is aware of pending user approval.
• Call the helpdesk at (785) 296-7935 if issues are encountered
Kansas State Department of Educationwww.ksde.org
Click Here
Data Entry: Data Entry:
Pathways: Assign/Update
Kansas State Department of Educationwww.ksde.org
1. Click on “My CPPSA’s.”2. Select “Approved by KSDE” as the status.3. Change the “School Year” to the year you will be
completing data for (2012-2013)4. Click “View/Filter CPPSA’s.”
Kansas State Department of Educationwww.ksde.org
Under “Actions,” there are five options:• View/Print-View and or print the CPPSA that was approved by KSDE.• Assign Teachers-Assign teachers to the courses in the pathway. Each course must have
at least one teacher. A teacher can be assigned to multiples courses in multiple pathways.
• Assign Students-This section is to assign students to a pathway. Students can only be assigned to one pathway per year.
• Update Current Students-Student data is recorded here for single parent, status, 3rd party assessment, competency profile, and certification data.
Kansas State Department of Educationwww.ksde.org
Assign Teachers:• Click on Assign Teachers under “Actions” next to the pathway.
Kansas State Department of Educationwww.ksde.org
1. Click on “Edit” in the Teachers column.
Assign Teachers
Kansas State Department of Educationwww.ksde.org
Assign Teachers• A new window will
appear. Click on the box next to the teacher (s) to assign.
• Click on “Save Teachers.”
• Repeat for all courses taught for the year.
Kansas State Department of Educationwww.ksde.org
Assign Students
Click on “Assign Students” under Actions in the My CPPSA’s screen
Kansas State Department of Educationwww.ksde.org
Assign Students The students that come up on the “assign students” screen {next
slide} are students that:• have an EOYA record sent by any building in the state AND• STCO Record that includes:
The school identifier is the building for which the pathway is approved, and
The SSID for the student, and The course code for the SCRS completion record is for a course that is
part of the approved pathway, and The educator identifier was assigned to the course on the assign
teachers screen, and The school year field has a value for the current year, and The completion status on the STCO record has a value of 01
Kansas State Department of Educationwww.ksde.org
Assign Students
1. Under the “In this Pathway?” column, select any students that are to be assigned to this pathway and have at least one credit in this pathway. Students can only be assigned to one pathway, and if they are previously assigned to another pathway, you will take them out of that pathway by clicking in the “In this pathway?” column. The page will automatically save.
2. If a student (s) is missing, click on the “Show All Students” link at the top of the page.
Kansas State Department of Educationwww.ksde.org
Assign Students Screen
Kansas State Department of Educationwww.ksde.org
Upload Students
The data uploaded in Pathways in the Assign Students Screen must contain proper linking information and can be in the format of Comma-Separated Values (.csv) only.
Click on “Browse” at the bottom of the screen.
Kansas State Department of Educationwww.ksde.org
Data Specifications for Uploading Students to a Pathway
Position Field Maximum Length Format Comments/Values1 State Student
Identifier (SSID)10 Integer Must be a valid SSID
2 Status 1 Integer 1 = Participant2 = Concentrator3 = Concentrator who exited4 = Concentrator who exited for other reasons
3 Single Parent Status 1 Integer 0 = Not a single parent1 = Single Parent
4 Competency Score 3 Integer Blank or 0-1005 Reason 1000 characters Alphanumeri
c
6 KCP Career Goal 7 characters 99.9999 Must be a valid CIP Code7 Career Goal 1 1000 characters Alphanumeri
c
8 Career Goal 2 1000 characters Alphanumeric
9 Career Goal 3 1000 characters Alphanumeric
10 Career Goal 4 1000 characters Alphanumeric
11 Career Goal 5 1000 characters Alphanumeric
Position Field Format Required/Optional Validation
1State Student Identifier Integer,
10 digits Required Must be 10 digitsVerified against the same students as listed on the Assign Students screen
2
Pathway Student Status Integer, 1 digit Required
1 = Participant2 = Concentrator3 = Concentrator who exited4 = Concentrator who exited for other reasonsMust be 1, 2, 3, or 4Seniors cannot be 1 - Participant
3Single Parent Status Integer,
1 digit Required 0 = Not a single parent1 = Single Parent
4 Competency Percent( For Status 3 only)
Integer,3 digits Required May be an integer from 0-100
5 Reason for Concentrators that Exited for Other Reasons
Alphanumeric1000 Char. Optional Any text, but may not contain commas due to the comma delimited format
6CIP Code 11.1111 Optional
Must follow the format example of two digits, a period, then four digitsIf the format is correct, the data is not saved but no error returnedIf the value matches an existing CIP Code, a name will be displayed
7 Career Goal 1 alphanumeric Optional Any text, but may not contain commas due to the comma delimited format
8 Career Goal 2 alphanumeric Optional Any text, but may not contain commas due to the comma delimited format
9 Career Goal 3 alphanumeric Optional Any text, but may not contain commas due to the comma delimited format
10 Career Goal 4 alphanumeric Optional Any text, but may not contain commas due to the comma delimited format
11 Career Goal 5 alphanumeric Optional Any text, but may not contain commas due to the comma delimited format
Kansas State Department of Educationwww.ksde.org
Update Current Students1. Update single parent status (see below)
2. Update status on right as participant, concentrator, concentrator who exited, or concentrator who exited for other reasons.
3. For concentrators who exit, insert pass/fail for the assessment, indicate any certifications, and/or list the competency percentage.
4. Click “Save Students” at the bottom of the page.
Kansas State Department of Educationwww.ksde.org
What do these statuses mean?
Participant: A student who has earned one (1) but less than three (3) secondary level credits in a single career and technical education (CTE) pathway
Concentrator: A student who has earned three (3) or more secondary level credits in a single CTE pathway, with two (2) of those credits being at the technical and application level
*Concentrator who Exited: A student who has met the criteria to be considered a concentrator AND has graduated secondary education with their cohort class AND has met at least 80% of their pathway competencies.
Concentrator who Exited for Other Reasons: A student who has met the criteria to be considered a concentrator who exited but has either 1) not met at least 80% of the competencies by graduation or 2) will not graduate with their cohort class. The reasons for this include but are not limited to the student: transferring out of district, dropping out of high school, or passing away.*These are the students who will be followed up on in the following Spring (2013).
Kansas State Department of Educationwww.ksde.org
Pathways without Concentrators
Kansas State Department of Educationwww.ksde.org
Entering Career Goal Data
Save the “Update Students” page before clicking on “Edit Goals” for a student.
The career goals data section is not required for student data reporting.
If the student has an account in the Kansas Career Pipeline with their KIDS ID number, this information will automatically pull in.
Kansas State Department of Educationwww.ksde.org
Entering Career Goal Data
Reports:Reports:
Kansas State Department of Educationwww.ksde.org
User Accounts with Access To Reports District/Org Update School Approve District/Org Approve
Kansas State Department of Educationwww.ksde.org
1. Click on “Reports”
Kansas State Department of Educationwww.ksde.org
1.A new window will appear-allow for pop-ups with pathways.2.In the window, select the school year for the reports to be accessed. 3.At this point, the user can choose more specific details to select by adding
the building number, cluster, or pathway/VE-2 program, or the user can select to export the report to a PDF, Excel, or CSV.
4.Select PDF or Excel.5.Select Open, Save, or cancel.
Kansas State Department of Educationwww.ksde.org
Kansas State Department of Educationwww.ksde.org
Non-CAR Report Definitions:
Certifications and Credentials: This report lists each Pathway or VE-2 Program and the certifications and/or credentials that have been assigned to it by the district.Downloadable Basic Enrollment: This report lists all students, and will have additional filters by student statuses: All Students, Participants, Concentrators, Concentrators who exited, Concentrators who exited for other reasons.Downloadable Basic-Exiters (Completers): This report displays data for students with the “Concentrator who exited” status.Downloadable Basic Follow-up: This report lists the students who were reported for Follow-up. This list of students only includes students who had a “Concentrator who exited” status, and were reported the following year. Exiters (Completers): This report displays data for students with the “Concentrator who exited” status. Minority Gender Concentrator Detail Report: This report will function the same was as the Minority-Gender Detail Report, except it will not include Participants.
Kansas State Department of Educationwww.ksde.org
NON-CAR Report Definitions, cont.
Minority Gender Detail Report: This report replaces the Basic Grant Cluster Report. This report will have an additional filter that allows it to be run with students listed as two or more races for CAR reporting, and with the individual race selections for other reports. Pathways: This report is a list of the pathways separated by building number and listing all courses in the pathway.Pathways Without Students: The Pathways Without Students report lists any Pathway that has zero participants or concentrators (any of the three types) for the selected year. Potential Students-Not Assigned: The Potential Students – Not Assigned lists any student who is not marked as a participant or concentrator (any of the three types) for the selected year. Program Pathway Courses: This report will list all of the courses available at a district or building for pathways or VE2 programs for each unique CIP Code, Course number, and Teacher ID combination. Total Concentrators: This report lists all students with the “Concentrator”, “Concentrator who exited”, and “Concentrator who exited for other reasons’” statuses. VE2 Program Details: This report shows the teachers assigned and Ve2 programs available
Kansas State Department of Educationwww.ksde.org
CAR Reports/Indicator Definitions
1S1-Academic Attainment – Reading (NCLB): Numerator: Number of CTE concentrators who have met the “meets standard” or above level on the statewide high school reading/language arts assessment based on the scores that were included in the state’s computation of AYP and who left secondary education in the reporting year. Denominator: Number of CTE concentrators who took the reading/language arts assessment and who left secondary education in the reporting year.
1S2-Academic Attainment-Math (NCLB): Numerator: Number of CTE concentrators who have met the “meets standard” or above level on the statewide high schools mathematics assessment based on the scores that were included in the state’s computation of AYP and who left in the reporting year. Denominator: Number of CTE concentrators who took the mathematics assessment and who left secondary education in the reporting year.
2S1-Technical Skill Attainment: Numerator: Number of CTE concentrators who passed the technical skill assessments that are aligned with industry-recognized standards, if available, and appropriate, during the reporting year. Denominator: Number of CTE concentrators who took the assessments during the reporting year.
3S1-School Completion: Numerator: Number of CTE concentrators who earned a regular secondary school diploma. Denominator: Number of CTE concentrators who left secondary education during the reporting year.
Kansas State Department of Educationwww.ksde.org
CAR REPORT/Indicator Definitions, cont.
4S1-Student Graduation Rate: Numerator: Number of CTE concentrators who, in the reporting year, were included as graduated in the state’s computation of its graduation rate. Denominator: Number of CTE concentrators who, in the reporting year, were included in the state’s computation of its graduation rate.
5S1-Total Placement: Numerator: Number of CTE concentrators who left secondary education and were placed in postsecondary education or advanced training, in the military services, or employment in the second quarter following the program year in which they left secondary education. Denominator: Number of CTE concentrators who left secondary education during the reporting year.
6S1-Nontraditional Program Participation: Numerator: Number of CTE participants from underrepresented gender groups who participated in a program that leads to employment in nontraditional fields during the reporting year. Denominator: Number of CTE participants who participated in a program that leads to employment in nontraditional fields during the reporting year.
6S2-Nontraditional Program Completion: Numerator: Number of CTE concentrators from underrepresented gender groups who completed a program that leads to employment in nontraditional fields during the reporting year. Denominator: Number of CTE concentrators who completed a program that leads to employment in nontraditional fields during the reporting year.
Summary Report – This report pulls a summary of the other 7 reports
Student Follow-upStudent Follow-up
Due on April 15th the year after the student was marked as a concentrator
who exited
Kansas State Department of Educationwww.ksde.org
Student Follow-up
Kansas State Department of Educationwww.ksde.org
Follow-up Data
Column Name Datatype Comment
StudentKIDSId Char(10) Link to the Student DataStatus Integer 1 = Employed – Related to Program
2 = Employed – Not related to Program
3 = Continued Education
4 = Military
5 = No Placement
6 = Unknown
7 = Advanced Training (Not 2 or 4 year degree)
ProgramSatisfication Integer 1 = Very Satisfied
2 = Satisfied
3 = Unsatisfied
Kansas State Department of Educationwww.ksde.org
Questions???
Contact the Pathways Help Desk at [email protected] with any
questions. Or contact
Angela Feyh, 785-296-4908, or
Sherry Webb, 785-296-3784.