Transcript Slide 1
Dynamic Web-based
Department Profiles
Using ASP & Other New
Technologies
SAIR
Biloxi, MS
October 19, 2004
Denise S. Gater
Will Collante
Purpose and Goals
Beyond the Fact Book!
Quick & User-Friendly
– Interactive
– Web-based
– Starting point is functional area
(vs. subject area)
Purpose and Goals
Data Integrity
Automated Process
Design Flexibility
Audience & How Used
Audience/Users … campus staff and
administrators
Uses …
– Decision-making
– Reporting
– Grant Proposals
– Program/Budget Reviews
– Enrollment Planning
What Are Others Doing?
FSU (Academic Dept. Profiles)
http://www.ir.fsu.edu/Academic_Profiles/
Berkeley (Cal Profiles)
http://calprofiles.vcbf.berkeley.edu/
University of Illinois (Campus Profiles)
http://www.dmi.uiuc.edu/cp/cppickyr.asp
Key Challenges & Issues
Linkage of Account Numbers and
Departments
– 17 colleges, 339 departments, 216 admin units
Initial Coding Up-Front
Security Issues
Capacity of Database
How is it Organized?
Multiple Years of Data
(1999-2000 through 2003-04)
Administrative Unit Data +
College/Department Data
College-wide & Unit-Wide
Summaries
Drill-down to Details
What Data are Included?
Academic Data
– Enrollment (by major)
– Student Credit Hours
– Degrees Awarded, by Level
– Faculty Counts (Headcount & FTE)
– Faculty Effort
What Data are Included?
Financial Profile
– Balances
– Expenditures
– Revenue
– Transfers
Space Data
Data Sources
Student Data
Course File
MS Excel
MS Access
Space File
Department
Profiles
Website
Operating Budget File
Personnel File
Faculty Activity File
Data Tables
Academic
Enrollment
Degree
SCH
Faculty
Effort
Year
Year
Year
Year
TotalPT
TotPTFTE
Year
L3L4
L3L4
L3L4
deptcode
TotalPTWM
TotPTWMFTE
source
Major
Major
Lower
unitcode
TotalPTWF
TotPTWFFTE
ccode
a
bachelor
Upper
classcode
TotalPTBM
TotPTBMFTE
L3L4
b
master
Gr_Class
Classification
TotalPTBF
TotPTBFFTE
undergrad
c
doctorate
T_D
TotalFT
TotalPTHM
TotPTHMFTE
grad
d
professional
Grad_I
TotalFTWM
TotalPTHF
TotPTHFFTE
gradIII
e
gender
Grad_II
TotalFTWF
TotalPTAM
TotPTAMFTE
otherInstruct
f
race
Keyf
TotalFTBM
TotalPTAF
TotPTAFFTE
ClinicalTeaching
Term
TotalFTBF
TotalPTIM
TotPTIMFTE
acadAdvise
h
TotalFTHM
TotalPTIF
TotPTIFFTE
research
Race
TotalFTHF
publicService
Gender
TotalFTAM
admin
TotalFTAF
other
TotalFTIM
total
TotalFTIF
Type
g
Data Tables
Financial and Space Data
Balances
Expenditures
Revenue
Transfers
Space
Year
Year
Year
Year
Year
Macct
Source
Dcode
dcode
Dcode
Oacct
DeptCode
Ccode
ccode
Ccode
mgg
Ccode
mgg
uffTrans
classroom
aux
Salary
spon
ufrfcg
classlab
returned
ops
aux
ufrf_licenses
researchlab
uff
support
uff
ufrfcgOverhead
office
ufrf
total
ufrf
ufrf_licensesOverhead
library
carry
Scode
aef
DSO
medical
aef
DisplayName
localFunds
housing
support
other
total
Data Tables
Colleges & Administrative Units, Departments, Accounts, Majors
Organization
Unit
Account
Majors
Code
unitcode
Unitcode
Mcode
name
name
Deptcode
Name
url
orgcode
Academic
data
url
ShowAcademic
description
Samas
generic
Academic
Technology
Macromedia Dreamweaver MX
MS Access
Active Server Pages 3.0 (ASP)
Macromedia Dreamweaver MX
Design View / Code View
–Color coded
–Drag & Drop
–Code helper
Properties Inspector
–Point to file feature
Files Manager
MS Access
Relational Database
Description in Table
Design SQL Query Design View
Integration with Excel
Updates to Data
Active Server Pages 3.0
Connection String
Modular – include files
Integration with Access and Excel
Future Plans & Enhancements
Improvements in Navigation of Site
Definitions
Technology
ASP.net
SQL Server
More interactive
– Build own reports
– Query tool
Feedback from Users!
Links
Presentation: http://www.ir.ufl.edu/sair/
Macromedia:
http://macromedia.com
MS Access:
http://msdn.microsoft.com/library/default.asp?url=/nhp/defa
ult.asp?contentid=28000522
ASP:
http://www.aspfree.com
The End
Questions?