Student Records

1
Student Records Registration IncrementPre-Regi
stration and RegistrationGo-Live on March
22,2004
2
What Systems Should I Learn First?

• Become familiar with Banner and Web For first
• Learn Banner screens
• Attend Banner training sessions
• Get comfortable with data entry in Banner
• Learn about standard (UI-Integrate) reports
• What reports are available?
• Where are they stored?
• What data can I get from them?
• If standard reports do not meet your needs (or if
  you are a current report developer), you or your
  staff may need to create your own reports using
  the Data Warehouse.

3
What are Standard Reports?

• UI-Integrate has developed and will publish a
  series of standard reports to meet many
  operational PRR reporting needs.
• These reports will be stored in several places
  EDDIE, View Direct, Banner, and Web For.
• A listing of standard reports under development
  by UI-Integrate can be found athttp//www.ui-int
  egrate.uillinois.edu/docs/RR_Reports_Detail.xls
• UI-Integrate processes access requests to use
  these standard reports, regardless of where they
  are published (EDDIE, View Direct, etc.).
• Questions about these reports can be directed to
  UI-Integrate.

4
When Should I Access the Data Warehouse?

• UI2 Standard Reports for Pre-Reg Reg can be
  found at
• http//www.ui-integrate.uillinois.edu/docs/RR_Rep
  orts_Detail.xls
• Pre-Reg Reg go-live is March 22, 2004

5
Registration

• General Student Analysis
• Enrollment Analysis

6
Enrollment Management

• Who
• Analysts in Academic Colleges and Departments
• Task
• Provide counts of registered students by
  course/section, grouped by various
  characteristics (e.g. course attributes, subject,
  level, etc.)
• Purpose
• Monitor the number of students registered for
  courses offered by the college to assess current
  demand and ensuring adequate course capacity
  (sections and seats)
• Identify trends in demand for courses over time
  for future planning
• Need
• Detailed information combining course and section
  information, student information, and student
  registration activity over time
• Ability to create summary reports that aggregate
  registered student counts, credit hours, etc.

7
Student Counts

• Who
• Analysts in Academic Colleges and Departments
• Task
• Provide counts of registered students, grouped by
  various characteristics (e.g. student level,
  FT/PT status, academic program, attributes, etc)
• Purpose
• Monitor the number of students in each program
• Identify trends in demand for programs over time
  for future planning
• Analyze trends in student population served by
  the college for planning
• Monitor special groups or populations of students
  for targeted services
• Need
• Detailed information on students in the college,
  including bio/demo data
• Ability to create summary reports that aggregate
  student counts, credit hours, etc.
• Ability to create counts for specific sub-sets of
  students

8
Student Counts

• Who
• Analysts in Offices of Admissions and Records
• Task
• Provide total student counts for the campus,
  grouped by various characteristics (e.g. student
  level, FT/PT status, academic program,
  attributes, registration status, etc)
• Purpose
• Monitor the overall registration process
• Analyze trends in student population served by
  the campus for planning
• Monitor special groups or populations of students
  for targeted services
• Need
• Detailed information on students across the
  campus, including bio/demo data and registration
  information
• Ability to create summary reports that aggregate
  student counts, credit hours, etc.
• Ability to create counts for specific sub-sets of
  students

9
Registration EDW
EDW Model Summary

• New EDW tables 62
• Existing EDW tables in Model 97
• Subject Areas Covered by These 159 Tables
• General Student
• Person
• Registration/Schedule
• Faculty
• Rooms/Meeting Times
• Financial Aid Applicant Status
• Course
• General Person
• Human Resources

10
Registration EDW
Business Objects Universes Summary

• Registration Universes
• Registration Complete offers full details
  (Functional Offices, Colleges and IR Offices)
• Registration Limited same subjects as
  Registration Complete, with less detail for ease
  of use (Functional Offices, Colleges and IR
  Offices)
• Directory access to directory information only
  (CITES, ACCC, CTS, Housing, Other Service Units)
• Instructor Assignment - What types of instructors
  are teaching how many hours of what types of
  classes to how many students? (Functional
  Offices, Colleges and IR Offices)
• In Beta testing currently limited to select
  users
• Central Reporting UI Integrate Reports

11
Registration EDW
General Student Analysis Detail

• General Student Record
• Associated Information
• Student Attributes
• Cohorts
• Sports Information
• Advisors
• Cooperative Education Information
• Student Veteran Information
• Stored at both Effective Term Based and Term
  Based Levels for Flexibility
• Effective Term information accessed via ODBC -
  Student History table

12
Other Useful Information ODBC Connection
http//www.ds.uillinois.edu/Docs/how_to.asp
13
Registration EDW
General Student Analysis Detail

• Person Related Information from previous
  increments
• Names, Addresses, Phone and E-mail Addresses
• Race/Ethnic, Citizenship and Gender
• Prior High Schools and Subjects
• Prior Colleges Attended, Prior Majors, Prior
  Degrees
• Test Scores
• Admission Application Decisions
• Financial Need Information
• Holds

14
Registration EDW
Registration Data Detail

• Student Registration History primary
  registration record for the term, including
  changes within a term
• Student Course Registration History records for
  each students registration for each specific
  section for each term, including
• Course Registration Status
• Billing and Credit Hours
• Schedule Type
• Grading Mode
• Level Code
• Restriction Override Indicators
• Grade
• Section and Session Information basic section
  and session information from Catalog Schedule
  EDW increment

15

• Student Advisor Advisor EDW Id, Advisor Type
  and Indicator (The information in this class may
  not be populated by a college/ department.
  Located only in the Registration-Complete
  Universe)
• Student Open Learning Used by Academic
  Outreach. This is a stand alone table. No other
  classes or objects can be combined with its
  objects. (Visible in Registration - Complete
  Universe)
• Student Registration Registered Hours,
  Registration Status and level, Enrollment and
  IPEDS Time Status, and IPEDS Time Status, Course
  Registration, Registration Group, Enrollment
  Withdrawal, and NSC Enroll Time Status
• Represents the most recent or current course
  registrations for a student (end result of their
  changes and attempts) based on when the EDW
  Extract was taken.
• Student Registration Activity Archive Section
  Enrollment Sequence Number, Archive CRN Student
  Level, Add Date, Archive Course Registration
  Status, Activity Code, Message, etc.
• Represents the actual registration changes,
  attempts, adds, drops, etc. a student has made
  based on when the EDW Extract was taken.
• Student Registration vs. Student Registration
  Activity Do not combine the objects from these
  classes with each other. Comparing the current
  Registration Status to the Activity records is
  not a viable.
• Eligible to Register vs. Registered Students
  The Student Term table contains those students
  who are ELIGIBLE to register and have registered.
  If you want a list of students who are ELIGIBLE
  to register but have not registered, you will
  need to use the Student History table via an ODBC
  connection.

16
Registration Project Status

• We are Live!
• March 21 Banner/Web For Registration Go-Live
• March 22 Data Warehouse Open for Custom Report
  Development
• March 22 Pre-Developed reports available in
  EDDIE, View Direct, Banner, and Web For
• Registration information for Fall 2004 will be
  available April 6 after students commence
  registering April 5 on all campuses
• Handful of registrations in the EDW by April 3
• Registration information for Fall 2003 and Spring
  2004 limited to total registered hours no class
  detail Financial Aid uses this
• Training and Access
• Data Education and Business Objects Training -
  continues at all campuses
• 2 more weeks, 2-3 week break, resume

17
Registration EDW
More to come

• Registration Snapshot
• Census Reporting Frozen data for point in time
  analysis on certain snap shot dates will
  go-live in July , 2004.
• Registration and Transfer Articulation
• Student Analysis Universe A universe that
  covers information from Recruiting and
  Admissions, Financial Aid, Pre-Registration and
  Registration, and Records increments will be part
  of the Student Records project which will go-live
  in September, 2004.