1 / 21

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

SAIR Biloxi, MS October 19, 2004 Denise S. Gater Will Collante Dynamic Web-based Department Profiles Using ASP & Other New Technologies Purpose and Goals the Fact Book! Quick & User-Friendly Interactive Web-based Starting point is functional area (vs. subject area) Beyond

Download Presentation

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

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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?

More Related