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?