Dynamic Web-based Department Profiles Using ASP & Other New Technologies - PowerPoint PPT Presentation

JasminFlorian
dynamic web based department profiles using asp other new technologies l.
Skip this Video
Loading SlideShow in 5 Seconds..
Dynamic Web-based Department Profiles Using ASP & Other New Technologies PowerPoint Presentation
Download Presentation
Dynamic Web-based Department Profiles Using ASP & Other New Technologies

play fullscreen
1 / 21
Download Presentation
Dynamic Web-based Department Profiles Using ASP & Other New Technologies
269 Views
Download Presentation

Dynamic Web-based Department Profiles Using ASP & Other New Technologies

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. SAIR Biloxi, MS October 19, 2004 Denise S. Gater Will Collante Dynamic Web-based Department ProfilesUsing ASP & Other New Technologies

  2. Purpose and Goals • the Fact Book! • Quick & User-Friendly • Interactive • Web-based • Starting point is functional area (vs. subject area) • Beyond

  3. Purpose and Goals • Data Integrity • Automated Process • Design Flexibility

  4. Audience & How Used • Audience/Users … campus staff and administrators • Uses … • Decision-making • Reporting • Grant Proposals • Program/Budget Reviews • Enrollment Planning

  5. 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

  6. 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

  7. How is it Organized? • Multiple Years of Data (1999-2000 through 2003-04) • Administrative Unit Data + College/Department Data • College-wide & Unit-WideSummaries • Drill-down to Details

  8. What Data are Included? • Academic Data • Enrollment (by major) • Student Credit Hours • Degrees Awarded, by Level • Faculty Counts (Headcount & FTE) • Faculty Effort

  9. What Data are Included? • Financial Profile • Balances • Expenditures • Revenue • Transfers • Space Data

  10. MS Excel MS Access Data Sources Student Data Course File Operating Budget File Personnel File Faculty Activity File DepartmentProfiles Website Space File

  11. Data Tables

  12. Data Tables

  13. Data Tables

  14. Technology • Macromedia Dreamweaver MX • MS Access • Active Server Pages 3.0 (ASP)

  15. Macromedia Dreamweaver MX • Design View / Code View • Color coded • Drag & Drop • Code helper • Properties Inspector • Point to file feature • Files Manager

  16. MS Access • Relational Database • Description in Table • Design SQL Query Design View • Integration with Excel • Updates to Data

  17. Active Server Pages 3.0 • Connection String • Modular – include files • Integration with Access and Excel

  18. Improvements in Navigation of Site Definitions Technology ASP.net SQL Server More interactive Build own reports Query tool Feedback from Users! Future Plans & Enhancements

  19. Links • Presentation:http://www.ir.ufl.edu/sair/ • Macromedia: http://macromedia.com • MS Access:http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28000522 • ASP: http://www.aspfree.com

  20. The End Questions?