ACCESSING DATA 2: HOW TO GET AVAILABLE DATA FOR PLANNING AND PROGRAM REVIEW

1
ACCESSING DATA 2 HOW TO GET AVAILABLE DATA FOR
PLANNING AND PROGRAM REVIEW

• Office of Research Planning

2
Overview

• Expectations?
• Current sources of supporting data overview
• ORP website
• Survey data
• Datatel
• Reports
• Query builder
• EIS
• Registration by Section
• Totals by Day
• ERIS

3
Datatel

• Who has access?
• Why/how do you use it?
• Query builder training?
• Reports?
• Examples
• For what purpose?
• ORP reports
• Persistence
• National Clearinghouse
• Etc

4
Datatel
5
Datatel
6
Datatel
F10 to execute and continue
7
Datatel
Choosing a printer HHold PPrint EEmail
8
Datatel
NNo YYes Running it in background mode will
take longer
9
Datatel
10
Datatel Query Builder
11
Datatel - Query Builder
12
EIS
CLICK HERE
13
EIS - Registration by section
Refresh all
Select C from the dropdown menu for Crafton
14
EIS Registration by Section
Right click in the pivot table area to view the
field list
15
EIS

• Different sheets
• On screen examples (refer to handout)
• Questions

16
ERIS

• New data management system
• Fully supported by the district at the end of
  this summer
• Web-based reports

17
ERIS - http//csb-sql-028080/default.asp
18
ERIS
19
ERIS
CLICK HERE
20
ERIS
CLICK HERE
21
ERIS Annual Planning Longitudinal Data
CLICK HERE
22
Annual Planning Longitudinal Data
Includes both discipline and department data
Only accurate for completed terms
23
Data Dictionary

• Definition of terms for longitudinal data
• Term Fall, Summer, or Spring Semester
• Sec Total number of sections offered for
  course of department for specific term
• Cap Maximum number of students allowed to
  enroll in each course (based on room size)
• EnrBeg Number of students enrolled at the
  beginning of each course
• EnrFinal Number of students enrolled in the
  course, as of the last day
• EnrMax - Number of students registered at any
  time, less those who dropped before section start

24
Data Dictionary

• Definition of terms for longitudinal data
  continued
• CenTotal - Number of students enrolled on the
  census date. Census date is 20 of the term
• of Fill - CenTotal divided by the Cap
• FtesTotal - Full-time Equivalent Students -- One
  FTES represents 525 student contact hours. A
  Full Time Student can be considered one who takes
  15 units per week for two 17.5 week semesters or
  a student who takes 12 units per week for two
  17.5 week semesters and 6 units in the summer
• WSCH - Weekly Student Contact Hours -- The number
  of weekly contact hours multiplied by the number
  of students

25
Data Dictionary

• Definition of terms longitudinal data continued
• FacLoad - Total load assigned to faculty members
• Wsch/FacLd - Weekly Student Contact Hours divided
  by the Faculty Load (525 Magical number)
• Retent - EnrFinal divided by CenTot
• PassCount - The total number of students who
  received a grade of C or better in a course
• Pass - PassCount divided by EnrFinal

26
ERIS Course enrollments by dept
CLICK HERE
27
ERIS Course enrollments by dept
28
ERIS GPA by ethnicity
Completed Annual Plans
29
GPA by ethnicity
30
Headcount trends by age
CLICK HERE
31
Headcount trends by age
32
Headcount trends by disability
CLICK HERE
33
Headcount trends by disability
34
Headcount trends by ethnicity
CLICK HERE
35
Headcount trends by ethnicity
36
Headcount trends by gender
CLICK HERE
37
Headcount trends by gender
38
Other reports

• Headcount by class and gender
• Headcount by age
• Headcount by program
• Ethnicity by residency
• Student headcounts
• Top 10 majors by graduates
• Students by ethnicity
• Students by program
• Enrollment by division
• FTE summary report
• Etc.

39
Research Requests
CLICK HERE
40
Research Requests
CLICK HERE
41
Research Requests
CLICK HERE
OR HERE
42
Research Requests
43
Research Requests
44
Research Requests
45
Questions/Discussions

• Questions?
• Please fill out the Professional Development
  Evaluation form and hand it in to Michelle Riggs
  before you leave