CCC411

1
CCC411

• Jing Luan (Chief Planning and Research Officer)
• Al Holbert (Chief Technology Officer)
• Patrick Perry (Vice Chancellor)

2
Background

• Two Goals
• Development of 5 student learning measures
• 2) Web access to standardized MIS data

3
Goal One

• Development of 5 student learning measures
• Access
• Course Completion
• Degree and Certificate
• Basic Skills
• Transfer

4
Goal Two

• Web access to standardized MIS data
• BrioInsight
• Star Schema

5
Work Accomplished

• Web site operational
• Five measures
• Multiple sources of bugs eliminated
• Star Schema Design in place
• Hardware operational
• Web servers operational

6
Work Accomplished

• Ad hoc query server operational
• Full documentation of system
• Modified demographic information to adjust for
  college size rather than a uniform number
• District information added to five measures, i.e.
  70-odd districts and 108 colleges with full data
  available (1.5 mos down to 8 days)
• Brio On-Demand Server purchased

7
Work To Be Accomplished

• Brio On-Demand Server installed and configured
• BrioInsight tested and distributed to select
  schools (trial and error, nip and tuck with new
  Brio)
• Virtual campuses established with measures
  available (pending software/expertise)
• Uniform naming convention documented for Star
  Schema

8
Next Two Years

• Next 2 Years starting July 1 (we hope it will
  stretch for two years)
• Maintenance mode minimum three data updates per
  year, refresh star schemata three times per year,
  develop training for researchers using
  BrioInsight and Star Schemata.
• Continue with the Advisory Committee
• Welcome feedback, error reportingonly you know
  your data.

9
Dont Trust Technology, rely on screen shots!
10
(No Transcript)
11
(No Transcript)
12
Features of CCC411.net

• Password protected
• Both tech and English definitions
• Excel download
• Drill-down possible by gender, age, ethnicity,
  and disability
• Staffed tech support
• Theory based
• High tech driven
• FAQ

13
What Else Is Going On

• Virtual College
• - Using cross-validating models to process
  select factors to achieve optimal Euclidean
  distances,
• or
• - Find colleges that are similar in key
  factors.

14
What Else Is Going On

• Transfer Pipeline Theory (TPT)
• Everybody is good at counting the hatched chicks,
  the real smart ones know that eggs arent hatched
  by counting the chicks!
• TPT is same as assembly line model.

15
Star Schema

• Bill Inmon (relational)
• One key in each file
• Ralph Kimball (star schema)
• All keys from all files are in one file
• Result
• Faster retrieval
• Less prone to error

16
Transfer Pipeline Theory (TPT)

• No excuse for not using data
• Cluster transfer students
• Conducted association analysis
• Refine transferability index

17
Venn Diagram

• How best to explain the pipeline theory

All Those Who Are Classified As With High
Transferability Index
All Students in College X
All Those Who Took Transfer Courses
18
Transfer Pipeline Theory

• Transfer Pipeline Theory (TPT)
• CCC411 Transfer Pipeline
• Perry and Meehans discovery
• 12 units
• Taking math, English
• The use of Rule Induction Algorithm of
  Clementine
• Rule 1 12 units, taking mathHello!

19
Contacts

• Jing Luan (Chief Planning and Research Officer)
• Cabrillo College
• jing_at_cabrillo.cc.ca.us
• Al Holbert (Chief Technology Officer)
• Cabrillo College
• al_at_cabrillo.cc.ca.us
• Patrick Perry (Vice Chancellor, Information,
  Planning and Research)
• Chancellor Office
• pperry_at_cccco.edu