Dynamic Web-based Dynamic Web-based Department ProfilesDepartment Profiles

Using ASP & Other New Using ASP & Other New TechnologiesTechnologies

SAIRSAIRBiloxi, MSBiloxi, MS

October 19, 2004October 19, 2004

Denise S. GaterDenise S. GaterWill CollanteWill Collante

Purpose and GoalsPurpose and Goals

the Fact Book!the Fact Book!

Quick & User-FriendlyQuick & User-Friendly– InteractiveInteractive– Web-basedWeb-based– Starting point is Starting point is functional areafunctional area

(vs. subject area)(vs. subject area)

Beyond Beyond

Purpose and GoalsPurpose and Goals

Data IntegrityData Integrity

Automated ProcessAutomated Process

Design FlexibilityDesign Flexibility

Audience & How Audience & How UsedUsed

Audience/UsersAudience/Users … campus staff … campus staff and administratorsand administrators

UsesUses … …– Decision-makingDecision-making– ReportingReporting– Grant ProposalsGrant Proposals– Program/Budget ReviewsProgram/Budget Reviews– Enrollment PlanningEnrollment Planning

What Are Others What Are Others Doing?Doing?

FSUFSU (Academic Dept. Profiles)(Academic Dept. Profiles)

http://www.ir.fsu.edu/Academic_Profileshttp://www.ir.fsu.edu/Academic_Profiles//

BerkeleyBerkeley (Cal Profiles)(Cal Profiles)

http://calprofiles.vcbf.berkeley.edu/http://calprofiles.vcbf.berkeley.edu/

University of Illinois University of Illinois (Campus Profiles)(Campus Profiles)

http://www.dmi.uiuc.edu/cp/cppickhttp://www.dmi.uiuc.edu/cp/cppickyr.aspyr.asp

Key Challenges & Key Challenges & IssuesIssues

Linkage of Account Numbers and Linkage of Account Numbers and DepartmentsDepartments– 17 colleges, 339 departments, 216 admin 17 colleges, 339 departments, 216 admin

unitsunits

Initial Coding Up-FrontInitial Coding Up-Front

Security IssuesSecurity Issues

Capacity of DatabaseCapacity of Database

How is it Organized?How is it Organized?

Multiple Years of Data Multiple Years of Data (1999-2000 through 2003-04)(1999-2000 through 2003-04)

Administrative Unit Data + Administrative Unit Data + College/Department DataCollege/Department Data

College-wide & Unit-WideCollege-wide & Unit-Wide SummariesSummaries

Drill-downDrill-down to Details to Details

What Data are What Data are Included?Included?

Academic DataAcademic Data– Enrollment (by major)Enrollment (by major)

– Student Credit HoursStudent Credit Hours

– Degrees Awarded, by LevelDegrees Awarded, by Level

– Faculty Counts (Headcount & FTE)Faculty Counts (Headcount & FTE)

– Faculty EffortFaculty Effort

What Data are What Data are Included?Included?

Financial ProfileFinancial Profile– BalancesBalances– ExpendituresExpenditures– RevenueRevenue– TransfersTransfers

Space DataSpace Data

Data SourcesData SourcesStudent Data Course File

Operating Budget File

MS Excel MS Access

Personnel File

Faculty Activity File

Space File

Department

Profiles Website

Data TablesData TablesAcademic

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

g Term TotalFTBF TotalPTIM TotPTIMFTE acadAdvise

h TotalFTHM TotalPTIF TotPTIFFTE research

Race TotalFTHF publicService

Gender TotalFTAM admin

TotalFTAF other

TotalFTIM total

TotalFTIF Type

Data TablesData TablesFinancial and Space Data

Balances Expenditures Revenue Transfers SpaceYear 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 TablesData 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

TechnologyTechnology

Macromedia Dreamweaver Macromedia Dreamweaver MXMX

MS AccessMS Access

Active Server Pages 3.0 Active Server Pages 3.0 (ASP)(ASP)

Macromedia Macromedia Dreamweaver MXDreamweaver MX Design View / Code Design View / Code ViewView

–Color codedColor coded–Drag & DropDrag & Drop–Code helperCode helper

Properties InspectorProperties Inspector–Point to file featurePoint to file feature

Files ManagerFiles Manager

MS AccessMS Access

Relational DatabaseRelational Database Description in TableDescription in Table Design SQL Query Design Design SQL Query Design ViewView Integration with ExcelIntegration with Excel Updates to DataUpdates to Data

Active Server Pages 3.0Active Server Pages 3.0

Connection StringConnection String

Modular – include filesModular – include files

Integration with Access and Integration with Access and ExcelExcel

Future Plans & Future Plans & EnhancementsEnhancements

Improvements in Navigation of Improvements in Navigation of SiteSite

DefinitionsDefinitions

Technology Technology ASP.netASP.netSQL ServerSQL Server

More interactiveMore interactive– Build own reportsBuild own reports– Query toolQuery tool

Feedback from Users!Feedback from Users!

LinksLinks

PresentationPresentation:: http://www.ir.ufl.edu/sair/http://www.ir.ufl.edu/sair/

Macromedia:Macromedia:

http://macromedia.comhttp://macromedia.com

MS Access:MS Access: http://msdn.microsoft.com/library/default.asp? http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28000522 url=/nhp/default.asp?contentid=28000522

ASP:ASP:

http://www.aspfree.comhttp://www.aspfree.com

The EndThe End

Questions?Questions?