210 likes | 438 Views
Today's Topics. BackgroundTaskMethodCourse Registration ProfileEnrollment ProfileOther ActivitiesQuestions. Background. Senior Administration: Need for better" access to data and informationA data warehouse???Planning
E N D
1. Using SAS® to Create Dynamic Web Sites Sabrina Andrews
Evangeline Collado
University of Central Florida
FAIR Conference
July 18, 2002
2. Today’s Topics Background
Task
Method
Course Registration Profile
Enrollment Profile
Other Activities
Questions
3. Background Senior Administration: Need for “better” access to data and information
A data warehouse???
Planning & Evaluation team
Academic Affairs
Statistics
Business
PeopleSoft Implementation
Charge to develop 3 prototypes
Addressing unmet university needs
4. Task 3 prototypes
Static web site with quick facts, trends and comparisons (HTML)
Institutional Dashboard (Crystal)
Data Mart (SAS)
Objective: Develop a management information system for use in planning, decision making, and evaluation
Easily accessible – Understandable
Graphical – Clearly defined
5. Methods – Static HTML web site
6. Methods – Static HTML web site
7. Methods – Static HTML web site
8. Methods – Static HTML web site Advantages
Aesthetically pleasing
High quality graphs
More control
Disadvantages
VERY labor intensive
Limited term data
9. Methods – SAS® IntrNet
10. Methods – SAS® IntrNet
11. Methods – SAS® IntrNet Advantages
“Interactive”/User control
Graphical Capability
More user options
Less programmer time to maintain
Disadvantages
Look and feel of “generated” tables and graphs
Less control over data sources
12. Meeting the Unmet University Needs PeopleSoft reporting
Access to the data
Users unrest
Responding to user needs
Course Registration Profile
Enrollment Profile
13. Course Registration ProfileBackground Originated as planning tool for Dr. Taylor Ellis in the College of Business
Static web pages were created daily and stored on local machine
Course information, e.g., prefix, number, etc., was entered manually into programs
High maintenance required
14. Course Registration ProfileTasks Create a planning tool to provide registration information for university community
Give user control of information access
Create historical data file for future trend comparisons
DEMO
15. Course Registration ProfileFeedback & Future Enhancements Favorably received by college faculty, administrators and schedulers
Enhancements based on user feedback
Retrieve data directly from PeopleSoft using SAS/ACCESS®
Overlay previous year’s data on trend plot for comparisons
16. Enrollment ProfileBackground Faculty & staff want to see enrollment statistics during 1st week of classes
Replicate University headcount reports generated each semester
One-click access to total university headcount
17. Enrollment ProfileTasks Create dynamic access to current and historical headcount numbers and percentages
Give user capability to see headcount statistics by college, major, gender, ethnicity, classification, and course load
Show enrollment trends
DEMO
18. Enrollment ProfileFeedback & Future Enhancements Faculty & administrative staff are using the site frequently
Enhancements made based on user requests
Collect data from RDS instead of legacy data bases for current enrollment
Additional views – replicate/replace some hard copy reports (e.g. geographical report)
19. Other Activities PeopleSoft RDS Development
Executive Dashboard Development
Query Library Development
PeopleSoft Portal
Architecture for data warehouse
20. Questions