Student Records - PowerPoint PPT Presentation

1 / 17
About This Presentation
Title:

Student Records

Description:

Sports Information. Advisors. Cooperative Education Information. Student Veteran Information ... Section and Session Information basic section and session ... – PowerPoint PPT presentation

Number of Views:153
Avg rating:3.0/5.0
Slides: 18
Provided by: lcour
Category:
Tags: records | student

less

Transcript and Presenter's Notes

Title: 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.
Write a Comment
User Comments (0)
About PowerShow.com