Developing a Dynamic Faculty Activity Reporting System

1
Developing a Dynamic Faculty Activity Reporting
System

• Betty Miller SAIR Conference
• Shiva Jaganathan Biloxi, MS
• University of Central Florida October 18, 2004

2

Topics for Today

• Background
• Key Reporting Requirements
• Stages of Development
• Application Development Issues
• Legacy System vs. Web System
• Questions

3

University of Central Florida

• Established in 1963 in Orlando, Florida
  (1968-first classes) Metropolitan Research
  University
• Over 42,000 students 35,200 undergraduate and
  7,400 graduate
• Academic Programs - 86 Bachelors, 68 Masters, 3
  Specialist, and 24 PhD
• 1,000 faculty and 2,800 full-time staff

4

Institutional Research (IR)

• Part of a comprehensive Information, Analysis,
  and Assessment Unit
• Operational Excellence and Assessment Support
• University Analysis and Planning Support
• Institutional Research
• Staffing in IR
• 10 full-time
• 1 Director, 1 Assistant Director, 3 Coordinators
  of Computer Applications, 3 Coordinators of
  Statistical Research, 2 Support Staff
• 2 Part-time

5

Background

• Universitys Migration to PeopleSoft environment
• Legacy System - Not User Friendly
• Inability to Produce High Level Management
  Reports
• Maintenance of Faculty Activity Reporting System
• Few Edit Checks

6

Key Reporting Requirements

• Collect All Instruction and Research Activities
  by Term Faculty Activity Reporting System
• Annual Instruction Research Data File
• Annual UCF Teaching Incentive Program
• Faculty and College Annual Reports

7

Stages of Development

• Web Application Design
• Specification Flow Charts Development,
  Functional Experts Inputs
• Web Technology Used
• Microsoft ASP and SAS web technologies
• Internet Information Server (5.0) on Windows 2000
  Servers
• Microsoft SQL Server and Access databases
• Application Testing and User Inputs

8

Application Development Issues

• Business Rules and Data Validation Implementation
• Security and Login Privileges
• Session Based Application
• Porting Web Application on to a Secure Server
• VPN Requirement for Access to the Application

9

• Legacy-Based Faculty Activity System

Security/Login Screen
1172 000000000 pass
10

Legacy-Based Faculty Activity System
Initial Screen After Login
AUTHORIZED TO UPDATE DEPT 1172
11

• Legacy-Based Faculty Activity System

Budget Record Screen
12

Legacy-Based Faculty Activity System
System Add Menu
13

Legacy-Based Faculty Activity System
Other Activity Add Screen
14

Legacy-Based Faculty Activity System
Course Related Activity Add Screen
15

Legacy-Based Faculty Activity System
PARS/12 Hour Rule Verification Screen
16

Legacy-Based Faculty Activity System
Ordering Print of Academic Assignment Reports
17

Web-Based Faculty Activity System
Login
18

Web-Based Faculty Activity System
Login Unsuccessful
19

Web-Based Faculty Activity System
Login Successful
20

Web-Based Faculty Activity System
Change Password
21

Web-Based Faculty Activity System
Department Summary
22

Web-Based Faculty Activity System
Employee Listing
23

Web-Based Faculty Activity System
Individual Employee Record
24

Web-Based Faculty Activity System
Adding Activities Drop Down Menu
25

Web-Based Faculty Activity System
Course Related Activity Add Screen
26

Web-Based Faculty Activity System
Academic Advising Activity Add Screen
27

Web-Based Faculty Activity System
Printing of Academic Assignments
28

Web-Based Faculty Activity System
Printing of Academic Assignments-Select Category
29

Web-Based Faculty Activity System
Printing of Academic Assignments-Select
Individual(s)
30

Web-Based Faculty Activity System
Sample Academic Assignment Report
31

Questions
32

For Additional Information Contact

• Betty Miller bmiller_at_mail.ucf.edu
• Shiva Jaganathan shiva_at_mail.ucf.edu
• Kash Sivaji ksivaji_at_mail.ucf.edu
• Office of Institutional Research
• [phone]
• www.iroffice.ucf.edu