![Page 1: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/1.jpg)
The Data-Savvy Department The Data-Savvy Department HeadHead
December 3, 7, 10 2007December 3, 7, 10 2007
![Page 3: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/3.jpg)
•To better manage your unit
•To know what others know about you
•To respond to inquiries
•To avoid reinventing the wheel
Why be data-savvy?
![Page 4: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/4.jpg)
•Learn what data is on the Management Information web site
•Understand the value of the data for the management of your unit
•Practice retrieving the data
Our Goals for Today
![Page 6: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/6.jpg)
Departments & Executive Officers
•Department codes (old and new)
•Department addresses & phones
•Executive officers
•Staff directories
•Department URLs
![Page 7: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/7.jpg)
Departments & Executive Officers
Example/Demo 1Example/Demo 1
•Find your own unit and its org code
•Move the staff directory for your department into Excel
![Page 8: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/8.jpg)
Student Enrollment Reports“Official 10-day” enrollments
•Final Statistical Abstract: campus totals, use for general information about campus.
•Enrollments by college, dept, program: degree, major, concentration, class, gender, race, citizenship, residency
![Page 9: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/9.jpg)
Student Enrollment Reports
• Trends in time by program• Survey responses• Grant proposals:
institutional characteristics
Typical uses
![Page 10: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/10.jpg)
Teaching Information
•Course Information System
Frozen, historical 10-day data plus “in-process” current year data
• Section Instructor List
Current year 10-day data, still in process
• Consolidated Class Rosters
Updated daily
![Page 11: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/11.jpg)
Course Information System
• All courses, sections, instructors, IUs since 1987
• Helpful FAQ explaining course processing & accounting.
• Many ways of viewing the data
• Course history is tracked despite changes in rubric or number.
![Page 12: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/12.jpg)
Course Information System
Summarize IUs generated by each faculty member paid by your unit for 2006-07
Example/Demo 2Example/Demo 2
![Page 13: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/13.jpg)
Course Information System
Faculty Teaching History
• For P&T documentation
• For annual evaluations
![Page 14: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/14.jpg)
Course Information System
Find all courses taught by your favorite faculty member.
Look at the P&T format and the table format.
Example/Demo 3Example/Demo 3
![Page 15: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/15.jpg)
Course Information System
Get a summary of all offerings of
NRES 293 (or other course) since
1987.
Example/Demo 4Example/Demo 4
![Page 16: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/16.jpg)
Course Information System
- Courses not offered on campus in the past six fall & spring terms
- Courses failing to “make” in the average of the last two offerings:
• 10 students for 100-300 level• 6 students for 400, 600, 700 level• No limit for graduate courses (500 level)
Example/Demo 5: Six-Ten ReportExample/Demo 5: Six-Ten Report
![Page 17: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/17.jpg)
Section Instructor List System
Current year-in-progress section data:
•Enrollments•IUs•Instructors•Contact hours
Class rosters (schedule maintainers)
Cross-list assignment is done here
![Page 18: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/18.jpg)
Debunking a big urban mythDebunking a big urban myth
MythMyth: How a student registers for a
crosslisted course section determines
who gets credit for offering the course.
Truth:Truth: Your department determines
who gets credit for the section
regardless of how the student registers
![Page 19: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/19.jpg)
Two Course Accounting Systems
1. Credit for offering a course
• Entered into SIL by dept
• Must be a crosslisting dept
• Used for external reporting
• Some internal reporting: (class size, who is teaching….)
![Page 20: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/20.jpg)
Two Course Accounting Systems
Credit for paying for a course
• Entered in Activity Reporting System
(ARS)
• Must be a dept paying the instructor(If courtesy - no pay - we use the offering dept)
• Used for internal reporting
(budget allocation, $ per IU, IU per FTE)
![Page 21: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/21.jpg)
Consolidated Class rosters
• Current data, updated daily
• From Summer 2005
• Crosslisted sections are combined
• Student details, e.g. email, program
• Withdrawn students remain on list, in red
• 2 versions: instructor and dept staff
![Page 22: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/22.jpg)
Campus Profile
• Budgets & expenditures• FTE and headcount staff• Student enrollment, qualifications, retention, graduation rates• Course enrollments & IUs• much, much more!much, much more!
Ten years of data summarized by department, college, and campus:
![Page 23: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/23.jpg)
Campus Profile – What’s New
• Strategic Profiles
• % Underrepresented by employee group• % Women & minority students• % Sections under 20 & over 50• Senior survey results* • Graduation & retention rates*• Deferred maintenance*• % Undergraduates on aid*• Major awards* * By college only
![Page 24: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/24.jpg)
Campus Profile Types of Reports Available
Standard ProfileStandard Profile
• One unit
• HTML format
• Most commonly used items
![Page 25: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/25.jpg)
Campus Profile Types of Reports Available
Strategic ProfileStrategic Profile
• One unit
• HTML format
• Metrics to measure progress towards campus or college goals
![Page 26: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/26.jpg)
Campus Profile Types of Reports Available
Custom Reports -- You select:Custom Reports -- You select:
• Units
• Items
• Column order
• Format: HTML or Excel
![Page 27: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/27.jpg)
Campus Profile
• Retrieve a standard Campus Profile for the campus.
• Retrieve a Strategic Profile for the College of ACES (or your choice of colleges)
Example/Demo 6Example/Demo 6
![Page 28: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/28.jpg)
Campus Profile
Create a custom report of all items for the College of ACES.
Look at all the drilldowns!
Example/Demo 7Example/Demo 7
![Page 29: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/29.jpg)
Campus Profile
Graph the six-year graduation rates
for undergraduate colleges (line 4620)
Example/Demo 8Example/Demo 8
![Page 30: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/30.jpg)
Campus Profile
Find out what the Provost will be
discussing with your dean during the
budget meetings: pull a Strategic
Profile for your college.
Example/Demo 9Example/Demo 9
![Page 31: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/31.jpg)
Campus Profile
Find the departments with:
Highest # terms to degree for PhDs (4760)
Highest & lowest Federal G&C exp (2573)
Highest # of honors sections (6660)
Example/Demo 10Example/Demo 10(time permitting)(time permitting)
![Page 32: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/32.jpg)
Proposal Data System
All proposals submitted from FY96
• By Department
• By Agency/Sponsor
• By Investigator
Report may be summarized by department or by agency.
![Page 33: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/33.jpg)
Proposal Data System
You are negotiating with the Arthur P. Sloan Foundation for a grant.
Is it likely you will get any ICR?
Example/Demo 11Example/Demo 11
![Page 34: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/34.jpg)
Proposal Data System
Example/Demo 12Example/Demo 12
It’s time to think about raises for next year. Find all grant proposals written by a faculty member in your
department.
![Page 35: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/35.jpg)
Tuition, Waiver, Appointments
What tuition is being charged to your students and what kind of waivers do they have?
How much will you need to pay another dept for the tuition for the grad asst you’ve hired?
![Page 36: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/36.jpg)
Activity Reporting System
•Mandated by Federal and state reporting requirements
•Activities and cost sharing percents are entered by your staff
•Useful data: current & obligated pay; appts and teaching assignments; salary & appt history to 1988
•Authorized users can change the paying dept for an instructor’s course
![Page 37: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/37.jpg)
Peer salary study
Compares your faculty salaries with selected peer depts at other institutions.
This year, we will be asking deans to update their peer departments to use public peers only.
![Page 38: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/38.jpg)
Faculty Salary Equity Study
Faculty salaries as a function of :•discipline•rank•years from degree•first rank at UIUC•time to tenure•gender•race•administrative post
Which factors contribute significantly?
![Page 39: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/39.jpg)
Faculty Salary Equity Study
Two issues:
1. Campus-wide, do gender and race affect salary significantly?
2. What salary is predicted for each individual and how does it compare to the actual salary?
![Page 40: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/40.jpg)
Course/section Anomaly Report
Normal: instructor is paid on state funds from the unit offering the course.
Anomaly: anything else!
Anomaly reports are available in Course Information System, you will be asked to look at them twice during the year.
![Page 41: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/41.jpg)
Databases outside of DMI
Decision Support data warehouse
• Standard reports: Eddie
• Business Objects: drag & drop create reports
• ODBC connections to EDW
Planning & Budgeting
• IPEDS: enrollments, degrees, faculty
• Campus databook: Retention, new student characteristics
![Page 43: The Data-Savvy Department Head December 3, 7, 10 2007](https://reader035.vdocuments.us/reader035/viewer/2022062722/56649f295503460f94c41be8/html5/thumbnails/43.jpg)
Course Information System
Look at the Course/Section Anomaly report for Entomology for 2005
(in the college of Liberal Arts & Sciences)
What does each report mean?
Bonus Bonus Example/Demo 11Example/Demo 11