Course Catalog

1
Course Catalog Schedule Detailed Universe
GuideLast Updated March 2011
2
Table of Contents

• Decision Support Contact Overview
• Accessing the Universes
• Universe Overviews
• Key Concepts
• Sample Reports
• Saving Reports

3
Decision Support Contact Overview
4
Resources and Contacts

• Need Help? File Issue via email or on-line at
• servicedeskaits_at_uillinois.edu
• https//sd.uillinois.edu/CAisd/pdmweb.exe
• Want to see if someone has created a query you
  could use, or share one youve created?
• Browse and post queries in the QCH at
  https//www.ds.uillinois.edu/reports/qch/
• Want to know what standard reports are available?
• Try the Standard Report Directory at
  https//www.ds.uillinois.edu/Reports/Directory/Bro
  wse.aspx
• How can I get access to standard reports?
• Follow the instructions at http//www.ds.uillinois
  .edu/web/Home/GetAccess/StdReports.aspx

5
More Resources and Contacts

• Need help creating a report, or having a problem,
  try these 5 solutions?
• Drop in at regularly scheduled practice labs to
  get one-on-one help from the experts in an open
  lab setting.
• See the Events for times and locations
  http//www.ds.uillinois.edu/events.asp
• Come to scheduled Custom Labs to get assistance
  writing reports for your needs
• Call AITS Help Desk 312-996-4806 (UIC) or
  217-333-3102 (UIS or UIUC)
• Send E-mail to servicedeskaits_at_uillinois.edu
• If you have access to Clarify, send a Clarify
  Ticket directly to the Decision Support Queue
  well take it from there the appropriate person
  will respond to you.
• How can I get access to create my own reports
  using the Data Warehouse?
• Follow the instructions at http//www.ds.uillinois
  .edu/web/Home/GetAccess/RequestProcess.aspx
• Want to talk about collaborating with DS or about
  our planned projects or services?
• Call your Student DS Coordinator Michelle
  Bergman at 217-265-6541 or e-mail
  bergman_at_illinois.edu

6
Accessing the Universes
7
www.ds.uillinois.edu
You can go directly to EDDIE.DS.UILLINOIS.EDU or
select To EDDIE from the DS Main Menu
8
Click Log in to EDDIE
9
Enter Username Password
9
10
Click NEW icon Select Desktop Intelligence
10
11
Wait a moment while Desktop Intelligence opens
Click on Begingt
12
Select Universe
Click on Nextgt
13
Select EDW STU Course Catalog
Click on Finishgt
14
Select EDW STU Course Schedule
Click on Finishgt
15
Universe Overviews
16
Course Catalog Universe
Review of Classes Objects in Course CATALOG
Universe
17
Course Catalog EDW Universe

• Offers general information regarding the general
  set-up of courses offered by the University of
  Illinois and its campuses.
• Offers Course Listing, Course General Set Up,
  Restriction, Course Attribute, Course Grading
  Mode, Course Level, Course Schedule Type, Course
  Fee, Related Courses and Schedule History
  information.
• PLEASE NOTE This universe offers information
  regarding COURSES only. No section or schedule
  related information is available.

18
Course CATALOG UniverseBO CLASSES and SUBCLASSES
(page 1)

• Counts Count (all), Count Distinct (determined
  by Course Id)
• Time Term Code/Desc Part of Term Code/Desc
• Course Listing Course Id, Course Subject
  Code/Desc, Course Number, Course Title, Course
  Long Title, Course Description Text, Course Desc
  Text Effective Date, Course Status Code/Desc,
  Course CIP Code
• Organization (Campus College Dept)
• Course Hours sourced from Course General Info
  (Max/Min/Variable Credit/Bill/Contact Hours)
• Course Set Up sourced from Course General Info
  (Repeat Limits, Repeat Status, CAPP Prerequiste
  Test Info)
• Course Supplemental Information (Coop Ed Ind,
  Graduate/Undergraduate Credit Amount, Language
  Skill Code, Remedial Code)

19
Course CATALOG Universe BO CLASSES and
SUBCLASSES (page 2)

• Course Restrictions Course Prerequisite, Course
  Co-requisite, Course Test Restriction, Course
  Class Restriction, Course Campus Restriction,
  Course College Restriction, Course Department
  Restriction, Course Degree Restriction, Course
  Level Restriction, Course Major Restriction,
  Course Term Restriction, Course Academic Program
  Restriction, Course Area Restriction)
• Course Attribute Course Attribute Code/Desc
• Course Grading Mode Course Grading Mode
  Code/Desc, Grading Mode Default Indicator
• Course Level Course Level Code/Desc
• Course Schedule Type Course Schedule Type
  Code/Desc, Workload Amt, Adj Workload Amt,
  Workload Max Enrollment
• Related Courses - Renumbered Course, Cross Listed
  Course, Similar Course
• Schedule History Schedule History Course
  Subject Code/Desc, Number, Type Code, Offer
  Section Total, Enrollment Total, Census Enrollment

20
Course CATALOG Universe BO CLASSES and
SUBCLASSES (page 3)
21
Course CATALOG Universe BO CLASSES and
SUBCLASSES (page 4)
22
Course CATALOG Universe BO CLASSES and
SUBCLASSES (page 5)
23
Course CATALOG Universe BO CLASSES and
SUBCLASSES (page 6)
24
Course SCHEDULE Universe
Review of Classes Objects in Course SCHEDULE
Universe
25
Course SCHEDULE Universe

• Offers scheduling information on sections
  available for registration by term at University
  of Illinois and its campuses.
• Offers Section, Section Enrollment, Cross Listed
  Enrollment, Section Restrictions, Section
  Attribute, Section Reserved Seat, Section Fee,
  Section Set-Up, Section Time, Section Meeting,
  Instructor, Building and Room information.
• Offers Course, Course Section Contract and
  Continuing Education Self Support Program
  information
• PLEASE NOTE This universe offers information
  regarding the SECTIONS offered by Term.
  Additional Course information is available to
  combine with the Section Information.

26
Course SCHEDULE Universe BO CLASSES and
SUBCLASSES (page 1)

• Counts Count (all) and Distinct Count
  (determined by CRN)
• Time Term Code/Desc and Part of Term Code/Desc
• Please Note ALWAYS designate a TERM or List of
  Terms as a condition in your reports
• Section Information CRN, Course Id, Course
  Subject Code/Desc, Course Number, Course Title,
  Section Number, Section Long Title, Section
  Description Text, Section Comment Text, Section
  Link Id, Section Link Connection, Section Status
  Code/Desc, Section Grading Mode Code/Desc, Grade
  Scale Name, Cross Listed Group Id, Schedule
  Type/Desc, Instructional Method Code/Desc, Block
  Schedule Code/Desc
• Section Enrollment Information (Max/Min
  Enrollment Counts, Available Seats, Wait List
  Enrollments, Prior Enrollment, Census
  Enrollments)
• Cross Listed Enrollment Information (Cross Listed
  Group Id, Cross Listed Section Enrollments)
• Section Restrictions (Prerequisite Restrict,
  Corequisite Restrict, Test Restrict, Class
  Restrict, Campus Restrict, College Restrict,
  Degree Restrict, Level Restrict, Major Restrict,
  Academic Program Restrict, Section Area Restrict)

27
Course SCHEDULE Universe BO CLASSES and
SUBCLASSES (page 2)

• (Section Information Continued)
• Section Reserved Seat (Level/Major/Class Reserve
  Code/Desc, Reserve Enrollment/Available
  Seat/Waitlist)
• Section Fee (Section Fee Amount, Detail Code,
  Level Code, Fee Type Code)
• Section Setup (Section Gradable Ind, Grade Mode
  Override, Tuition Fee Exempt Ind, Special
  Approval Code, Attendance Accounting Method,
  Academic/Billing Credit Hour Override, Section
  Max Extension Number)
• Section Time (Term, Census Two Date, Process/Drop
  Course Cut off Date, Part of Term Start/End Date,
  Part of Term Week Number)
• Section Meeting (Section Room Number, Day Number,
  Day of Week Code/Desc, Section Start/End Time,
  Start/End Date, SMTWThFSa Meet Ind)
• Course Information (Course Section Contract
  Code/Desc, Contract Percentage, Primary
  Indicator)
• Cont Ed Self Support Program (Program Code/Des,
  Coop Ed Ind, Section Learner Registration From/To
  Date, First/Last Start Date, Program Percentage,
  Primary Indicator

28
Course SCHEDULE Universe BO CLASSES and
SUBCLASSES (page 3)

• Instructor Edw Person Id, UIN, Instructor
  First/Middle/Last/Suffix Name, Confidentiality
  Ind
• Instructional Assignment (Primary Instructor Ind,
  Resonsibility Percentage, Session Percentage,
  Override Ind, Position Number, Instructional Type
  Code/Desc
• Non Instructional Assignment (Assign Code/Desc,
  Weekly Contact Hour, Non Instructional Assign
  Campus/College/Dept/Term/Type Code/Desc, Workload
  Amount
• Building Information Building
  Campus/College/Dept Code/Desc, Building
  Code/Desc, Building Address, Telephone Number
• Room Information Room Term Code, Room Number,
  Room Type Code/Desc, Room Capacity, Room Max
  Capacity, Room Area, Room Status Code/Desc, Room
  Attribute Code/Desc

29
Course SCHEDULE Universe BO CLASSES and
SUBCLASSES (page 3)
30
Course SCHEDULE Universe BO CLASSES and
SUBCLASSES (page 4)
31
Course SCHEDULE Universe BO CLASSES and
SUBCLASSES (page 5)
32
Course SCHEDULE Universe BO CLASSES and
SUBCLASSES (page 6)
33
Course SCHEDULE Universe BO CLASSES and
SUBCLASSES (page 7)
34
Course SCHEDULE Universe BO CLASSES and
SUBCLASSES (page 8)
35
Key Concepts
36
Key Concepts Effective Term vs. Term

• In Banner, Catalog records based on effective
  term
• starting term for range of terms over which the
  record is active
• not a record for every term, for example
• the first record is effective (i.e. active) for
  all terms from Fall 04 - Fall 05, instead of
  having a separate record for each term
• Reports are difficult, because you cant just
  create a report for effective term Fall 2005
  there may not be a record for Fall 2005!
• Have to create complicated logic to pick whatever
  record was active for Fall 2005

37
Key Concepts Effective Term vs. Term (cont.)

• In the EDW, Catalog records based on term
• Create a record for every term, for example
• Reports are much easier, because you can pick the
  term you want and records for that term will be
  included
• For example, term Fall 2005 will give you the
  correct result, because there is a record for
  Fall 2005

38
Key Concepts Course Records in Banner (page1)

• Separate course record for each listing of a
  course in the Catalog
• For example, at UIS Auditing Concepts and
  Responsibilities cross-listed in Catalog as both
  Accountancy 464 and Public Administration 421
• Banner has a separate course record for each
• Subject code and course number used to uniquely
  identify each course (e.g. ACC 464)
• Course Identifier used to uniquely identify each
  overall course (e.g. Auditing Concepts and
  Responsibilities)
• as cross-listings will each have same Course ID
• also applies to renumbered Courses both the
  original listing and the new listing will have
  same Course ID

39
Key Concepts Course vs. Course Listing records
in EDW (page2)

• Course Listing record structured like in Banner
• For example, two separate records for Auditing
  Concepts and Responsibilities Accountancy 464
  and Public Administration 421
• Subject code and course number used to uniquely
  identify each course (e.g. ACC 464, PAD 421)
• Course record corresponds to the overall course
• For example, only a single Course record for
  Auditing Concepts and Responsibilities will
  exist in the EDW, regardless of how many
  different listings are included in the Catalog
• Course Identifier used to uniquely identify the
  Course record and the concept of an overall
  Course record does not exist in Banner
• If existing Subject/Course Number combination
  re-used for completely different Course, a
  different Course ID will be assigned and a new
  record in the EDW will exist
• Basic info from the controlling Course Listing
  included in Course record, such as course title
  and description, department, credit and contact
  hours which is useful for creating lists or
  counts that require a single record per Course,
  e.g. for some external surveys

40
Key Concepts Course vs. Course Listing records
in EDW (page3)

• Course Listings for Accounting at UIS
• Course Listings for Auditing Concepts Resp

41
Key Concepts Section Records in Banner (page4)

• Specific offering of a Course (Subject/Course
  Number) for a particular Term
• CRN used to uniquely identify Section records
  this is the call number used by students to
  register for a course
• e.g. CRN 0085 offering of ACC 464 for Spring
  2003 term at UIS that meets on Monday evenings
• Often multiple Sections of the same Course are
  offered during a Term, i.e. multiple Section
  records (CRNs) for a single Course
• Different Sections may represent different
  meeting times, locations, and instructors
• For cross-listed courses, two different Section
  records refer to the same meeting time, location,
  and instructor
• May be separate Sections for different components
  of a course, such as a lecture and lab (students
  register for multiple Sections for a given
  course)
• Packaging can also be used group multiple
  course components, e.g. lecture and lab, into a
  single CRN (students register for single Section
  for given course)

42
Key Concepts Section vs. Session Records in
Banner (page 5)

• Section record structured like in Banner
• Single record for each CRN
• Session record in the EDW represents a specific
  component of a Course offering for a term
• Single Session record for each component, even
  when it is listed more than once in the Schedule
• e.g. Auditing Concepts and Responsibilities may
  be listed in the Schedule under ACC 464 with a
  CRN of 0085 and also listed under PAD 421 with a
  CRN of 2820
• Both of these CRNs actually refer to the same
  Course, meeting time and place, and instructor
• Each CRN would have a separate Section record,
  but only a single Session record for Auditing
  Concepts and Responsibilities, i.e. the Session
  record is based on the Course (using Course
  Identifier) and not the Course Listing
  (Subject/Course Number)

43
Key Concepts Section vs. Session Records in
Banner (page6)

• Also applies to components listed in multiple
  CRNs using packaging
• Even through a given component listed more than
  once in the Schedule, only one Session record
• Concept of a Session record does not exist in
  Banner
• Record derived in the EDW based on Section and
  Meeting records in Banner
• Some of the information from the Meeting record
  in Banner is moved to the Session record in the
  EDW, such as credit hours and schedule type.
• Session record is very useful for many types of
  counts and totals (e.g. total credit hours),
  because it eliminates double-counting due to
  packaging and cross-listing

44
Sample Reporting These queries are also
available at DS Query Clearinghousein Student
Catalog Schedulehttps//www.ds.uillinois.edu/re
ports/QCH/browse.aspx
45
Course Catalog Top Requirements
Course Example, C1 List all courses offered in
a term by Course Subject Code (i.e., MATH,
ENGL). Course Example, C2 List ALL courses
associated with a specific Course Id by Course
subject code, Course Number, Course
Title. Course Example, C3 List of ALL courses
offered for a term by status (Inactive, Active,
Canceled). Course Example, C4 List of ALL
courses offered for by Instructor and
term. Course Example, C5 List of Instructors by
their non-instructional assignment and
term. Course Example, C6 List of Courses by
their Group Id and Term.
Course Analysis
46
Course Schedule Top Requirements
Schedule Example in Solution Library EDW
Section Tally http//www.ds.uillinois.edu/web/Home
/SolLib/StuSol/SectionTally.aspx Schedule
Example in Solution Library Offered Section
Counts http//www.ds.uillinois.edu/web/Home/SolLib
/StuSol/OfferedSectionCount.aspx Schedule
Example in Solution Library Available
Seats http//www.ds.uillinois.edu/web/Home/SolLib/
StuSol/AvailableSeats.aspx Schedule Example in
Solution Library Classroom Usage http//www.ds.u
illinois.edu/web/Home/SolLib/StuSol/ClassroomUsage
.aspx Schedule Example in Solution Library
Section Attributes http//www.ds.uillinois.edu/web
/Home/SolLib/StuSol/SectionAttributes.aspx Schedu
le Example in Solution Library Part of Term
Sections http//www.ds.uillinois.edu/web/Home/SolL
ib/StuSol/PartOfTermSections.aspx
Schedule Analysis
47
Saving your Reports
48
4 Options for Saving

• Option 1 File gt Save gt .rep
• This is the Business Objects default. This saves
  the document to your hard drive. The location is
  under My Documents gt My Business Objects
  Documents gt User Docs
• Option 2 File gt Save As gt .xls
• This allows you to choose the location to save
  the document and change the file type to Excel
  (.xls). This location could be on your hard
  drive, on a CD or USB drive or on a network
  share, for example. Saving document as .xls may
  cause formatting issues after opening in Excel.
• Option 3 File gt Save As gt .txt
• This allows you to choose the location to save
  the document and change the file type to Text
  (.txt). This location could be on your hard
  drive, on a CD or USB drive or on a network
  share, for example. Saving the document as .txt
  will remove any formatting to the report once it
  has been opened via Excel using the File Format
  Wizard.
• Option 4 File gt Export/Import To Repository
• This sends the document to be stored on the
  Decision Support server. You can then retrieve
  the document from any location or computer.
• This option is very useful when you have created
  the document at a workstation that is not your
  own and you want to be able to retrieve it back
  at your desk or you create the document at your
  desk and want to be able to retrieve it in a lab
  setting.

49
Option 4 Export to Repository

• Select File
• Select Export To Repository
• Select Favorites
• Click Add
• Click OK on Add Documents pop-up
• Click OK on Export pop-up
• Now you can import this document from any
  computer if BO XI is installed.

50
Option 4 Export to Repository
Click OK Now you can import this document from
any computer if BO XI is installed.
51
Option 4 Import from Repository

• 1. Select File
• Select Import from Repository
• Select Folders
• Locate .rep file from list
• Click Retrieve
• You will then be able to retrieve a saved
  document.

52
Option 4 Import from Repository
Click OK in the Import Results box You will then
be able to retrieve a saved document.
53

• Good Luck Have Fun Creating YOUR OWN Reports ?