Academic Department Profiles: Creating an On-Line Budget Support Notebook Karen A. DeMonte University of Delaware http://www.udel.edu/IR/presentations What Is It?
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.
Karen A. DeMonte
University of Delaware
The Budget Support Notebook is a resource document that assists administrators, chairs, and deans in their decision making process.
Three years of institutional workload data are displayed for the Fall and Spring semesters, respectively, as well as an Annual Average for the academic years.
For each of the three fiscal years, data are extracted from the Financial Information System for direct expenditures.
The notebook is organized by college, and by departments within the college. Each section begins with a college-wide summary, then moves to the department level.
Perl Program/HTML Template
To ensure that the departments get full credit for courses taught, Department Chairs verify course and instructor information.
Data from the Student Records, Human Resources, and Financial Information systems is extracted and imported into Microsoft Access
Several tables, queries, and forms work together to present or calculate data points that are ultimately merged into a single tab-delimited file.
Degrees granted EVERY
Fall semester major counts
Spring semester major countsData Entry: Access Forms
Sets the structure for creating the college level and department directories on the IR server. It also serves as the basis for the .htaccess security file.
The TAB-delimited file is exported from Access to our IR server. Each variable name inside the notebook data set corresponds to a variable in the Perl program.
The template.html file is a normal HTML document. Inside of this HTML fileare codes which correspond to variables in the Perl program.
Static Web Pages
.htaccess Security Files
ALLIN A SINGLE COMMAND
Karen A. DeMonteOffice of Institutional Research
Institutional Research Analyst
University of Delaware
325 Hullihen Hall
Newark, DE 19716-0172