Transcript Slide 1
MIS Reporting
California Community Colleges
System Office
Management Information Systems
April 29, 2008
29% of
Credit Students
attend more than one
college during their
academic career
10.25% of
credit students attend
more than one college
during an academic year
91.7% of
New Credit Students
are reported with a SSN
r
47.3% of
New Non-Credit Students
are reported with a SSN
r
82,519
AA/AS Degrees
were awarded in
2006-07
1,047,196.45 Credit FTES
90,216.56 Noncredit FTES
All Activity for 2006-07
What?
What kind of data are collected?
When?
When are the data collected?
How?
How are the data used?
Where?
2008 Annual CACCRAO Conference
Where to find the data?
Why?
What?
Student Data
What kind of
data are
collected?
Demographic
Enrollments
Categorical Programs
Matriculation, EOPS, DSPS
Perkins (VTEA)
Financial Aid
Assessment
Program Awards (Degrees & Certificates)
Courses
Sections, Sessions, Instructional
Assignments
Employee
College Calendar
2008 Annual CACCRAO Conference
CCC MIS Database
EOPS
DSPS
VTEA
PBS
Emp.
Assign.
Matric.
Student
Demographics
(SB)
Fin.
Aid
Emp.
Demo.
CalWORKs
Assess.
2008 Annual CACCRAO Conference
Enrollments
(SX)
Pgm.
Awds.
Calendar
Sessions
Sections
Courses
(CB)
Assignments
2
1
Data Entered Into System
4
User Reviews Data
2008 Annual CACCRAO Conference
System Office
Data Base
4
(Data Mart and
Reports)
External Entities
DOF, Newspapers,
Legislature, etc.
3
Data Review
Data Source
Resubmit Data
5
MIS Dept
At Districts
Data
Good Data at the Source
=
Accurate View of
Your College
Why?
When?
When are the
data
collected?
Term . . . . 30 days after end of term
Calendar . . . 30 days after end of spring term
Program Award . . . Due September 1st
Financial Aid . . . . . Due October 1st
Assessment . . . . . . Due October 1st
Employee Data . . . Opens November 1st
Due by January 15th
2008 Annual CACCRAO Conference
Why?
How?
How are the
data used?
Matriculation Justification/Funding
EOPS /DSPS / CalWorks
Funding/Justification
Perkins / CTE
Perkins IV Core Indicator Reports
Perkins IV Allocations
BOGW Administrative Funding
Federal Integrated Postsecondary
Education Data System (IPEDS)
Reporting
CCC Data Mart
ARCC – Focus on Results:
Accountability Reporting for the
Community Colleges
2008 Annual CACCRAO Conference
Why?
How?
How are the
data used?
Data Matches
Transfer to UC/CSU/NSC match
Dept. of Social Services / Military Match
EDD/UI Match/Wage Study
FTES – 320 vs. Special Request
Identifying “moonlighters”
Identifying “freeway flyers”
Annual Staffing Report
2008 Annual CACCRAO Conference
Why?
How?
Research Questions
How are the
data used?
2008 Annual CACCRAO Conference
Legislative Analyst Office
Department of Finance
California Postsecondary Education
Commission
California Student Aid Commission
Public Policy Institute
UC/CSU
Legislature – Committees and individual
members
Community College Organizations
Newspapers
Labor Unions
Why?
Where?
Where to find
the data?
Annual Headcounts Reports
Preview of Funding Numbers for
Categorical Programs
EOPS/DSPS reports available after
submission of Spring Term data
Perkins reports available after
submission of Financial Aid data
Time to validate and resolve issues
prior to use in allocations
Password Protected
2008 Annual CACCRAO Conference
Why?
Where?
Where to find
the data?
CCC Data Mart
Public site / No username or password required
Headcount Status: A,B,C,F
Minimum ½ credit unit OR 8hrs Positive
Attendance
Examples of Available Queries:
Student Information
Assessment, Program Award
EOPS/DSPS/CalWORKs
Financial Aid, Staffing, FTES
Distance Education
Success and Retention
2008 Annual CACCRAO Conference
Student
Identifier
Clean Up
Course
Control Number
FTES
320 vs MIS FTES
Data
Review
2008 Annual CACCRAO Conference
The Life Cycle of a Student Identifier
One
Student
District Fantasy
Spring 2004
• 123456789
Spring 2007
• 789123DEF
• ABC456123
• 123456789
Fall 2002
Fall 2006
Three
Students
CCCSO Reality
2008 Annual CACCRAO Conference
Why?
CB00
Improve the quality of course data
reported to the System Office.
Collect a new MIS data element
Course
Control
Number
2008 Annual CACCRAO Conference
that identifies
“Stand Alone Courses” (AB 1943).
Modify the MIS database to meet
the legislative accountability
reporting requirements of SB 361
Why?
Why is SOMIS FTES Used
vs. 320 FTES?
FTES
Fiscal
vs.
CCCSO MIS
2008 Annual CACCRAO Conference
320 FTES is reported at a high level
SOMIS FTES is reported at the
lowest level with value-added
attributes
SOMIS FTES can be sliced and
diced for many purposes
Wide spread use of FTES by
internal and external requestors
Why?
FTES
Requestors of System Office FTES
Financial Aid Augmentation
$34.2 million
Fiscal
Department of Finance
vs.
Legislative Analyst’s Office
CCCSO MIS
Public Policy Institute
Categorical Program Justification
Newspapers, Unions, Legislators
2008 Annual CACCRAO Conference
Why the differences?
Why?
FTES
Fiscal
Academic Year vs. Fiscal Year
Summer, Fall, Spring vs.
7/1/xx – 6/30/yy
Summer Session Option
You may decide which fiscal year
a Summer Daily Census section
may be counted
Student / Course Repeatability
Some student repeats may not be
counted for FTES twice
vs.
CCCSO MIS
2008 Annual CACCRAO Conference
Why the differences?
Why?
FTES
SB09 – Residency Code
“50000” not reported for a
student at time of MIS data
submission
SO not using F-Factor
Daily and Positive Attendance
sections have a factor applied for
320 reporting when the college
has a flex calendar
Fiscal
vs.
CCCSO MIS
2008 Annual CACCRAO Conference
April 29th
2008
2008 Annual CACCRAO Conference