Dynamic web based department profiles using asp other new technologies
Download
1 / 21

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


  • 268 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Dynamic Web-based Department Profiles Using ASP & Other New Technologies' - JasminFlorian


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Dynamic web based department profiles using asp other new technologies l.jpg

SAIR

Biloxi, MS

October 19, 2004

Denise S. Gater

Will Collante

Dynamic Web-based Department ProfilesUsing ASP & Other New Technologies


Purpose and goals l.jpg
Purpose and Goals

  • the Fact Book!

  • Quick & User-Friendly

    • Interactive

    • Web-based

    • Starting point is functional area

      (vs. subject area)

  • Beyond


Purpose and goals3 l.jpg
Purpose and Goals

  • Data Integrity

  • Automated Process

  • Design Flexibility


Audience how used l.jpg
Audience & How Used

  • Audience/Users … campus staff and administrators

  • Uses …

    • Decision-making

    • Reporting

    • Grant Proposals

    • Program/Budget Reviews

    • Enrollment Planning


What are others doing l.jpg
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 l.jpg
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 l.jpg
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


What data are included l.jpg
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 included10 l.jpg
What Data are Included?

  • Financial Profile

    • Balances

    • Expenditures

    • Revenue

    • Transfers

  • Space Data


Data sources l.jpg

MS Excel

MS Access

Data Sources

Student Data Course File

Operating Budget File

Personnel File

Faculty Activity File

DepartmentProfiles Website

Space File





Technology l.jpg
Technology

  • Macromedia Dreamweaver MX

  • MS Access

  • Active Server Pages 3.0 (ASP)


Macromedia dreamweaver mx l.jpg
Macromedia Dreamweaver MX

  • Design View / Code View

    • Color coded

    • Drag & Drop

    • Code helper

  • Properties Inspector

    • Point to file feature

  • Files Manager


Ms access l.jpg
MS Access

  • Relational Database

  • Description in Table

  • Design SQL Query Design View

  • Integration with Excel

  • Updates to Data


Active server pages 3 0 l.jpg
Active Server Pages 3.0

  • Connection String

  • Modular – include files

  • Integration with Access and Excel


Future plans enhancements l.jpg

Improvements in Navigation of Site

Definitions

Technology

ASP.net

SQL Server

More interactive

Build own reports

Query tool

Feedback from Users!

Future Plans & Enhancements


Links l.jpg
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


The end l.jpg
The End

Questions?


ad