BORG Data Cubes

B.O.R.G. Data Cubes

The purpose of B.O.R.G. (Best Organizational Research Gauge) Data Cubes is to help the campus with evidence-based decision making by providing access to real-time data.  The reports are only available to District Employees and accessible to those logged into the District Network.  If you have suggestions for additional reports or changes to the ones listed below, please contact Giovanni Sosa by email at gsosa@craftonhills.edu or by phone at extension 3206.  Future reports will include visually appealing and more user friendly dashboards.

Disproportionate Impact (DI) Calculator

PPR Instructional Data

• Course Completion and Success Rate (Rubric Items 5.a.i and 5.a.ii)
• FT/PT Faculty Ratio (Rubric Item 5.a.iii)
• WSCH/FTEF Ratio (Rubric Item 5.a.iv)
• Fill Rate (Rubric Item 5.a.v)
• Demographics (Unduplicated by Year) (Question 6.a)
• Degree and Certificate Completion (Question 6.b)
• SLO Competency by Demographics

Academic Success

• Tutoring Center Utilization by Course Success
• STEM Center Success & Completion Rates

Equity Reports for Instructors

• Equity Report: Class Roster by Race
• Equity Report: Course Success Rate by Section and Ethnicity
• Equity Report: Course Success Rate by Section and Ethnicity--Combined Sections
• Equity Report: Course Success Rate by Section and Age
• Equity Report: Course Success Rate by Section and Gender

Tracking Enrollment

• Current RFTES, Enrollment, and Unduplicated Headcount (Updated Manually Daily)
• Progress on RFTES Annual Targets (Updated Manually Daily - Requires Login)
• Active Section Enrollments (All Active Sections)
• High School Enrollment by Fall Term
• Number of Students on Wait List by Section (Only includes sections that haven't started.)
• Emails of Students on Wait List by Section (To Contact Students from Above Report)
• Number of Students on Wait List by Section with Emails (Only includes sections that have already started.)
• Number of Students on Wait List by Course (Includes all students on wait list to indicate demand.)

Enrollment Planning and Scheduling

• Calculator: Scheduling, FTES, and Hours and Units for COR
• Fill Rate by Section (EIS Data)
• Fill Rate by Section (EIS Data - Can export the data to Excel and Includes Course Title)
• Enrollment Management - Includes Fill Rate, estimated FTES, cost, and possible revenue generated)
• Room Number Search (Example of Use: Enter room number to identify open times for scheduling.)
• Schedule (View Schedule by Instruction Method)
• Faculty Schedules (Can also use to search for sections with missing faculty)
• Faculty Overload
• Faculty Key Report for Facilities

Contacting Students

• Contacting Students Enrolled in a Specified College, Term, Location, and Student Demographics
• Emails of Students Actively Enrolled by Term in Less than Specified Unit Value
• Emails of Students who Applied and are Currently NOT Enrolled in the Specified Term
• Emails and SMS Phone Numbers Only of Students who Applied and are Currently NOT Enrolled in the Specified Term
• Emails, Phone Numbers, and Addresses of Students who Successfully Completed Specified Course, in a Specified Major, and is Currently Enrolled in Specified Term
• Emails of Students Actively Enrolled in Online Section
• Hispanic Student Enrollment by Section
• Probationary Students (Contact information of students on probation. Search by Term or SID)
• Contacting Students who Successfully Completed a Specified Course in a Specified Term (Emails, Phone, and Addresses)
• Contact Information by SID - Can enter up to 150 SIDs.
• Application Contact Information by Specified Start Term and Location (Examples of Use: Contact Information for Road Runner Rally Participants)
• New CHC Students Who Have Undecided Majors with Contact Information
• Academic Programs of Students Enrolled in Specified Term & College
• Emails and Phone for Actively Enrolled Students (Search by Term, Faculty, Discipline, Section, or Course)
• Emails and Phone for Students who Dropped and Active Section
  Emails and Phones for Students Enrolled in Cancelled Section (Search by Term, Discipline, Section, or Course)
• Currently Enrolled Students by College and Term - mailing addresses and emails
• BOG Fee Waiver Awardees by Award Year - mailing addresses and emails
• First-Time CHC Students by Prior Institution

Open Sections

• Open Sections by Late Start Sections and Discipline
• Online Open Sections by Late Start Sections and Discipline
• Open Sections by Late Start Sections - Short Term Sections Only
• Open Sections at Specified Start Time and Day (Report can be used to generate list of sections to provide to students who had a section cancelled. Step-by-step directions are also available.)

Instruction

• Deans List (Under Development) - Contact information for students who completed 12 or more units within the semester specified, with a 3.5 GPA or higher.
• Honors List (Under Development) - Contact information for students who completed 6-11.99 units within the semester specified, with a 3.5 GPA or higher.
• Courses - Search Active Courses to check information that may require a substantial change to be filed with the California Community College Chancellor's Office.
• Total Adjunct Faculty Load - Check of 67% rule
• Total FT Contract Faculty Load Only to check .950 to 1.05 Bargaining Agreement Rule
• Total FT Contract Faculty Overload
• Active Courses (Provides list of all currently active courses.)
• Emails of Faculty in Specified Term Teaching an Online Section
• Emails of Faculty in Specified Term Teaching any Section
• Dual Enrolled Students at CHC Off Campus
• Faculty Employment Verification
• Course Prerequisite Report
• Student Grades and Schedule - Includes transcript and course schedule meeting times.
• Scheduling Spreadsheet
• Positive Attendance Tracking Training Video
• Positive Attendance Daily Attendance Tracking Excel Sheet

Other Sources

• Executive Information System (EIS) - EIS gives decision makers at CHC and SBCCD a data-driven method of answering commonly asked questions about enrollment, FTES, student characteristics, and academic performance. Data is presented in Microsoft Excel, making extensive use of pivot table features. Although using pivot tables may be intimidating, training documentation and a video illustrating how to set-up and use EIS is available.
• California Community College Chancellor's Office Data Mart - The data mart provides statewide, district, and college-specific information about students, courses, student services, outcomes, faculty, and staff. This source is available outside of the District Network.
• California Community College Student Success Metrics - The Student Success Metrics dashboard contains information on student enrollment, information on the types of students attending the college, information about their academic success, momentum points along their academic journey, employment and earnings data. Data is reported for each college according to gender, age and ethnicity of students.