CALPADS File Submission Content Overview for State Reporting LEAs

1
CALPADS File Submission Content Overview for
State Reporting LEAs

• The session will begin in a few minutes.
• Please be sure you have printed the session
  handouts http//www.csis.k12.ca.us/e-learning/cl
  ass-desc.aspSR-CP
• Training Session Presentation
• Selected CALPADS Data Elements
• State Data Collections Transitioning to CALPADS
• Gap Analysis Tool

2
Session Purpose

• To provide an overview of the proposed CALPADS
  file formats
• Session will NOT
• Cover data population rules
• Cover translation rules
• Cover technical specifications such as user
  interfaces
• Cover every data element in the file formats
• Fully equip you for CALPADS reporting

3
Objectives

• Which file formats are expected
• When those files are expected to be submitted
• Differences from what you may be collecting
• Rationale for changes
• State-level collection transitions
• Local preparation

4
Local Implications CALPADS Changes

• CALPADS requires more data than was reported via
  CSIS State Reporting, such as discipline data
• This is your planning and preparation year for
  CALPADS

5
Submission Timeline
6
Local Implications CALPADS Changes

• Work with SIS Vendors for CALPADS Updates
• Schedule and install updates
• Determine how changes are made to state code sets
• If using Custom SIS
• Identify needed changes
• Develop, test and implement changes

7
Local Implications CALPADS Changes

• Local Support
• Update local forms as needed
• Update procedures manuals and other support tools
• Train staff on changes

8
Local Implications Data Submissions

• Create or revise existing Data Management
  Calendar to address
• Timeline for analyzing CALPADS requirements
• Timeline for conducting gap analysis
• Timeline for auditing data on an ongoing basis
• Who is responsible for each action

9
Local Implications Data Submissions

• Create 2009/10 Data Management Calendar to
  address
• Timeline for meeting submission requirements
• Timeline for review, correction, and approval of
  submissions
• Timeline for updating data on an on-going basis
• Who is responsible for each action

10
State Data Collections Transitioning to CALPADS

• Sections of Part I of the Consolidated
  Application
• Majority of the CBEDS CDIF, SIF, and PAIF
• Sections of the Carl Perkins Data System
• Student National Origin Report (SNOR)
• Parts of the Language Census

11
Local Implications State Reporting

• CALPADS is the next evolution of state reporting.
  Consider
• Examining the representation and structure of
  your data management team
• Examining the depth and breath of communication
  within your LEA

12
Local Implications State Reporting

• Data collections are
• No longer stand alone collections
• Ongoing throughout the school year

13
New Federal Requirements Race and Ethnicity
14
New Federal RequirementsCollecting and
Reporting Race and Ethnicity

• A two-part question will be required to collect
  race and ethnicity information from students and
  staff.
• Race and ethnicity data will be aggregated and
  reported using 7 categories.
• There will be no category for Unknown or
  Decline to State.

15
New Federal RequirementsCollecting and
Reporting Race and Ethnicity

• Re-identification using the final guidance is not
  required.
• Schools and districts must begin collecting race
  and ethnicity data according to the final
  guidance beginning in 2009-2010 with CALPADS
  implementation.
• Original individual documents supporting the
  reporting of race/ethnicity should be retained
  for a minimum of 3 years.

16
New Federal Requirements The Two-part
Race/Ethnicity Question

• Please answer both questions 1 and 2.
• 1. Are you Hispanic or Latino? (choose only one)
• No, not Hispanic or Latino
• Yes, Hispanic or Latino
• 2. What is your race? (choose one or more)
• American Indian or Alaska Native
• Asian
• California law requires continued collection of
  Asian subcategories
• Black or African American
• Native Hawaiian or Other Pacific Islander
• California law requires continued collection of
  Pacific Islander subcategories
• White

17
The New Federal RequirementsWhat Do the
Aggregate Reporting Categories Look Like?

• Hispanic or Latino of any race and, for
  individuals who are non-Hispanic/Latino only,
• American Indian or Alaska Native
• Asian
• Black or African American
• Native Hawaiian or Other Pacific Islander
• White
• Two or more races

18
The New Federal Requirements What Does This Mean
For Me?

• Make sure your student and human resources
  information systems can capture the data
  according to the new scheme.
• Make sure student enrollment forms and staff
  personnel documents include the two-part
  question, where appropriate.
• Review your existing databases for missing race
  and ethnicity information.
• Train your staff.
• Be prepared to make the change beginning in 2009.

19
The New Federal Requirements I Need More
Information

• Get more detailed information from Federal
  sources at
• http//www.ed.gov/policy/rschstat/guid/raceethnici
  ty/index.html (Outside source)
• http//nces.ed.gov/pubs2008/2008802.pdf (Outside
  source)
• Send your questions to Marsha Devine at
  CALPADS_at_cde.ca.gov, subject line, Race Ethnicity
  Federal Guidance

20
Content to be Presented

• For each file, will highlight
• ONLY selected elements
• Element number
• Public name
• Definition (on handout)
• Change
• Rationale for change
• Local Implications

21
SSID Enrollment File
22
Purpose of the SSID Enrollment File

• To request SSIDs
• To report annual enrollment
• To update enrollment changes

22
23
Fields Where Code Sets Have Changed
24
Element 1.23

• CSIS Name Enrollment Date
• Student School Start Date
• Change LEAs currently report enrollment date
  only
• Rationale To promote consistency in the data
  being collected.

25
Element 1.24

• CSIS Name Student Enrollment Status
• Enrollment Status Code
• Change Adding two enrollment types
• Short-term Enrollment
• Receiving Specialized Services Only (CAHSEE
  Intensive Instruction)
• Rationale Allows for additional enrollment types

26
Element 1.28

• CSIS Name High School Graduation Status
• Student School Completion Status
• Change Used in conjunction with Student Exit
  Reason Code
• Rationale Allows more flexibility for students
  who may have completed but returned and exited
  again (e.g. GED, then returns for diploma)

27
Element 1.29

• CSIS Name Receiver School
• Expected Receiver School of Attendance
• Change Applies to two scenarios
• Expelled students going to Educational Options
  schools (juvenile hall, community schools)
• Students leaving Educational Options schools
  (juvenile hall, community schools)
• Rationale Needed to track high-risk students

28
Local Implications SSID Enrollment

• CALPADS has new and revised data elements and
  code sets.
• Best Practice is to map CALPADS data to your
  Systems of Record and identify
• Who is responsible?
• How is it collected?
• Where is it stored?
• Timeline for collection?Gap AnalysisTool Demo

29
Student Information File
30
Purpose of the Student Information File

• Provide additional student information (e.g.
  demographics, EL, immigrant status) after SSID
  assignment
• To update changes in student information
• To report required NCLB elements

30
31
Fields Where Code Sets Have Changed
32
Element 2.34

• CSIS Name Interdistrict Transfer Student
• Interdistrict Transfer Code
• Change May not be collected at all
• Rationale Required for federal reporting on
  School Choice and Persistently Dangerous Schools

33
Element 2.35

• CSIS Name Students District of Residence
• District of Geographic Residence
• Change Required for all interdistrict transfer
  students
• Rationale Required for state reporting on
  interdistrict transfers

34
Elements 2.36 2.40

• CSIS Name Address Lines 1 and 2, City, State,
  Zip or Postal Code
• Residential Address
• Change Will be collected for all students except
  homeless
• Rationale Needed for Direct Certification

35
Element 2.42

• CSIS Name Date Redesignated RFEP
• English Language Acquisition Status Start Date
• Change Will be collected all students for every
  status (EO, EL, IFEP, RFEP)
• Rationale Needed for Federal Title III reporting

36
Element 2.44

• CSIS Name Birthplace Special Circumstances
• Student Ineligible SNOR Indicator
• Change Collected for foreign born U.S. citizens
• Rationale Needed for Student National Origin
  Report

37
Element 2.47

• CSIS Name High School Graduation Date
• Student Expected Graduating Class Year
• Change Collected for all students 7-12
• Rationale Needed for graduation rates

38
Elements 2.48 2.49

• CSIS Name N/A
• CTE Pathway Code and Pathway Completer Indicator
  
• Change
• Pathway must be indicated for CTE Concentrators
• Pathway Completion Indicator must be set for
  students passing local skill assessment.
• Rationale Needed for Carl Perkins reporting

39
Local Implications Student Information

• Race/Ethnicity changes to student and staff
  forms
• Adopt Postal Addressing Standards for student
  addresses http//pe.usps.gov/cpim/ftp/pubs/Pub28/p
  ub28.pdf

40
Student Program File
41
Purpose of the Student Program File

• To collect program eligibility and participation
  data
• To update program eligibility and participation
  data
• To meet state and federal reporting requirements

41
42
Program Data to be Collected in the Fall
42
43
Program Data to be Collected in End-of-Year
43
44
Element 3.13

• CSIS Name Special Program Type
• Education Program Code
• Changes
• Some Educational Options Programs will now be
  collected at student level
• Neglected and Delinquent Programs will be
  collected at student level
• Rationale Will provide more accurate program
  participation for federal and state reporting

45
Educational Options
46
Educational Options
47
Element 3.14 3.16

• Education Program Membership Code
• Change For each program, LEAs must specify
  eligible or participating
• Education Program Membership Start and End Dates
• Change Collected for each Membership Category
  Code for each program
• Rationale Better data quality

47
48
Element 3.17

• CSIS Name Instructional or Support Service
  Received
• Education Service Code
• Changes
• New student-level element
• Categories modified from the Consolidated
  Application
• Rationale To build in more flexibility for
  future state and federal reporting

48
49
Element 3.18

• CSIS Name N/A
• California Partnership Academy ID
• Change New student-level element
• Rationale To identify Academies offered at LEAs
  and counts of students in those academies

50
Element 3.21

• CSIS Name Students District of Residence
• District of Special Education Accountability
• Change Formerly known as District of Residence
• Rationale Needed to make distinction between
  District of Geographic Residence

51
Local Implications Student Program

• COMPLETE student enrollment is a multiple step
  process
• Enrollment File
• Download SSIDs to local SIS
• Information File
• Program File
• Clearly communicate
• Program Eligibility (NSLP GATE)
• Program Participation

52
Local Implications Student Program

• Where you code information in your SIS may change
  (i.e. Independent Study)
• If data location changes, local queries will need
  to change (i.e. reconcile counts)

53
Student Discipline File
54
Purpose of the Student Discipline File

• To collect student discipline information to meet
  state and federal reporting requirements
• To collect truancy data to meet state and federal
  reporting requirements
• Only required for the most severe offense for a
  single incident

54
55
Fields Where Code Sets Have Changed
56
Elements 4.13 4.14

• CSIS Name N/A and Date of Incident
• Disciplinary Incident ID Local and Disciplinary
  Incident Occurrence Date
• Change New student-level element
• Must assign a Local ID to each incident
• Must include the date the incident occurred
• Weapon Category Code expanded
• Rationale Needed to meet federal reporting
  requirements

57
Element 4.21

• CSIS Name Discipline Status
• Student Instructional Support Indicator
• Change Currently an embedded fact in the
  Discipline Status code set
• Rationale Needed to meet federal reporting
  requirements on placements after disciplinary
  actions

58
Element 4.23

• CSIS Name N/A
• Student Truant Indicator
• Change New student-level element
• Rationale Needed to meet federal reporting
  requirements

59
Local Implications Student Discipline

• Ensure consistency in how discipline is entered
  in SIS
• Ensure required information is reported and local
  use data isnt
• Protect privacy
• Include Child Welfare and Attendance staff on
  Data Management Team
• Consider expanding local code sets

60
Student Waiver File
61
Purpose of the Student Waiver File

• To collect CAHSEE waiver information
• To streamline reporting to the State Legislature

61
62
Element 6.13

• CSIS Name Exit Withdrawal Reason 106
  Graduated with CAHSEE Waiver
• Education Regulatory Exemption Code
• Change CAHSEE Waivers will be collected here
  rather than in an Exit Category
• Rationale Will allow flexibility in CALPADS to
  accommodate additional waiver data

63
Element 6.14

• CSIS Name Authorization /Prohibition /Waiver
  Type
• Education Regulatory Exemption Outcome Code
• Change May not be currently collected
• Rationale Needed for state reporting to the
  legislature

64
Element 6.15

• CSIS Name Authorization/Prohibition/
• Waiver Request Date
• Education Regulatory Exemption Outcome Start
  Date
• Change May not be currently collected
• Rationale Needed for state reporting to the
  legislation

65
Student Health FileOPTIONAL
66
Staff Demographics File
67
Element 7.08

• CSIS Name Statewide Educator Identifier
• (SEID)
• SEID
• Change Required for
• All certificated staff
• Non-certificated administrators and non-core
  charter teachers if their data are being reported
• Rationale To link staff data with CALTIDES

68
Elements 7.28 7.29

• CSIS Name Staff Hire Date and Staff Exit Date
• Staff Employment Start Date and Staff Employment
  End Date
• Change Not currently collected on the PAIF
• Rationale Needed to help track mobility

69
Local Implications Staff Demographics

• Hispanic Ethnicity/Racial Category change
  requires hiring form revisions
• SEID Lookup Websitehttps//info.ctc.ca.gov/fmi/x
  sl/SEIDLookup/lookup.xslSee item 28 in the SEID
  FAQs

70
Local Implications Staff Demographics

• Coordinate with the entity (COE or HR Office)
  that maintains your staff data to identify
• What data is needed
• When the data is needed
• What format will be used to exchange data

71
Staff Assignment File
72
Purpose of the Staff Assignment File

• To collect non-teaching assignment information
  for certificated staff

72
73
Fields Where Code Sets Have Changed
74
Element 8.14

• CSIS Name Percentage of Time Per Assignment
  Full-Time Equivalent (FTE)
• Educator Job Classification FTE Percentage
• Change Will not be collected at assignment level
  only Job Class level (e.g. 50 teacher, 50
  administrator)
• Rationale Will lessen burden on LEAs

75
Elements 8.15 8.21

• CSIS Name Staff Assignment(s)
• Non Classroom Based Job Assignment Code
• Change Teaching assignments will be collected in
  the Course Section record
• Rationale This file should only contain
  non-classroom based or support assignments (e.g.,
  Department Chair, Counselor, etc.)

76
Local Implications Staff Assignments

• Coordinate with the entity (COE or HR Office)
  that maintains your staff data to identify
• What data is needed
• When the data is needed
• What format will be used to exchange data

77
Local Implications Staff Assignments

• Data for staff assignments will be greatly
  reduced with CALPADS
• Report percentage by job classification, not
  assignment
• Report only non-teaching assignments

78
Course Data in CALPADS
COURSE File The organization of subject matter
taught at a school Master Course Catalog
COURSE SECTION File A unique instance of a Course
taught by one or more teachers, in a specific
location, at a particular time Master Schedule
STUDENT COURSE SECTION File A Course Section
assigned to a particular student Student Course
Schedules
79
Course File
80
Purpose of the Course File

• To collect Fall course enrollment data
• To collect End-of-Year course completion data

80
81
Fields Where Code Sets Have Changed
82
Element 9.11

• CSIS Name Course Section Program
• Course Content Code
• Change To qualify a course as a CTE Section
  course
• Rationale To capture CTE courses that may not be
  in the CTE Section of the assignment codes

83
Element 9.13

• CSIS Name N/A
• CTE Technical Preparation Course Indicator
• Change Qualifies a CTE Course as a Tech. Prep.
  course
• Rationale Required for Carl Perkins reporting

84
Local Implications Course

• Establish a single course master for the entire
  district
• Promote consistency in course coding across all
  LEA schools, including charters
• Leadership involvement is needed for both policy
  and implementation
• Additional work will be needed if you have
  placeholder courses (i.e. lunch, homeroom, after
  school, etc) in your SIS

85
Course Section File
86
Purpose of the Course Section File

• To include course section information for Fall
  course enrollment data
• To include course section information for
  End-of-Year course completion data
• To collect HQT information

86
87
Fields Where Code Sets Have Changed
88
Element 10.11

• CSIS Name Statewide Educator Identifier (SEID)
• SEID
• Change Requires a SEID for certificated staff
• Rationale Identifies staff member teaching
  course section
• In the case of distance learning courses, this
  would be the certificated classroom monitor

89
Element 10.13

• CSIS Name N/A
• Class ID
• Change Requires that the SIS be able to uniquely
  identify a Class
• Rationale Will be used for average class size
  and studentteacher ratio

90
Element 10.16

• CSIS Name Language of Instruction
• Language of Instruction Code
• Change Collected at the course section level
• Rationale Will be used for the annual Language
  Census in primary language instruction counts

91
Element 10.17

• CSIS Name Program or Instructional Setting
• Instructional Strategy Code
• Change Includes values for English learner
  strategies, and special education
• Rationale These strategies are attributes of the
  course section rather than an individual student

92
Element 10.18

• CSIS Name N/A
• Independent Study Indicator
• Change New field to capture whether or not a
  course section is taught by way of independent
  study
• Rationale To allow for the collection on
  independent study data separate from
  instructional strategy

92
93
Element 10.19

• CSIS Name N/A
• Distance Learning Indicator
• Change Previously identified at the teacher
  level
• Rationale To provide a more accurate count of
  courses being taught via distance learning.

94
Element 10.21

• CSIS Name Program or Service Funding Source
• Education Program Funding Source Code
• Change Identifies if the course section is
  funded by the CA Partnership Academy or
  Specialized Secondary Program
• Rationale Gives us a more accurate count of
  participants in these two programs.

95
Element 10.22

• CSIS Name Course Section Program
• CTE Course Provider Code
• Change
• Identifies if the CTE course is a district course
  or offered at a ROP
• ROP data are currently not collected in CBEDS.
• Rationale Data needed for Carl Perkins reporting

96
Local Implications Course Section

• Work with vendor and staff on assignment of Class
  ID, for example
• French 4 5 combined class
• Self-contained classrooms
• High School Block Schedule
• HQT has a larger code set
• Prepare to report all the options
• Review and update HR forms

97
Student Course Section File
98
Purpose of the Student Course Section File

• To identify student course section information
  for Fall course enrollment data
• To identify student course section information
  for End-of-Year course completion data

98
99
Element 11.16

• CSIS Name Course Term
• Academic Term Code
• Change Requires the Academic Term be populated
  when sending course completion records
• Rationale Helps identify courses completed
  during specific terms in an academic year

100
Elements 11.17, 11.18, 11.19

• Course Completion Elements
• Student Credits Attempted (Credits Attempted)
• Student Credits Earned (Credits Earned)
• Student Course Final Grade (Course Mark)
• Change Required for course completion for grades
  7-12 (except alternative ed. classes)
• Rationale Allows for analysis of statewide
  course completion

101
Element 11.20

• CSIS Name Course Mark Type
• Student Course Section Final Grade Type
• Change Required for course completion for grades
  7-12 (except alternative ed. classes)
• Rationale Identifies the grading scale used by
  the LEA

102
Local Implications Student Course Section

• Need to plan for the following
• Assignment of course sections for self-contained
  classrooms
• Reporting grades and credits (7-12 only)
• Change in where programs are reported (i.e.
  Independent Study)

103
Assessment (Pre-ID) FileCurrently in development
104
Resources and Contacts

• CALPADS
• http//www.cde.ca.gov/calpads
• CALPADS File Specifications Code Sets (draft)
  ftp//ftp.cde.ca.gov/calpads-sis/cfs
• E-mail calpads_at_cde.ca.gov
• CALTIDES
• http//www.cde.ca.gov/ds/td/lo/caltides.asp
• E-mail caltides_at_cde.ca.gov
• OPUS
• http//www.cde.ca.gov/ds/td/lo/opus.asp
• E-mail cdecsis_at_cde.ca.gov

105
Resources and Contacts

• NCES Publication Safety In Numbers
• http//nces.ed.gov/pubSearch/pubsinfo.asp?pubid20
  02312
• SEID Lookup
• https//info.ctc.ca.gov/fmi/xsl/SEIDLookup/lookup.
  xsl
• E-mail HDESK_at_ctc.ca.gov
• Postal Addressing Standards
• http//pe.usps.gov/cpim/ftp/pubs/Pub28/pub28.pdf
  
• Education Data Newsletter
• http//www.cde.ca.gov/ds/sd/cs/

106
Where You Get More Information from CDE
Brandi Jauregui BJauregu_at_cde.ca.gov
916.323.5298 Paula Mishima PMishima_at_cde.ca.go
v 916.319.0779
107
Where You Get More Information from CSIS
CSIS Support support_at_csis.k12.ca.us 916.325.9210
107