Open Access. Powered by Scholars. Published by Universities.®

Physical Sciences and Mathematics Commons

Open Access. Powered by Scholars. Published by Universities.®

Computer Sciences

1996

Illinois Wesleyan University

Articles 1 - 2 of 2

Full-Text Articles in Physical Sciences and Mathematics

Powerfaids: Building A Road To Financial Aid Efficiency, Lauri Nichols '96 Apr 1996

Powerfaids: Building A Road To Financial Aid Efficiency, Lauri Nichols '96

Honors Projects

To most students, the Financial Aid office is a small room in the basement of Holmes Hall where they are occasionally sent to sign over a paper or two. It has something to do with money, and every so often, these students get something in the mail that tells them just how much it's going to cost them to continue their education here at Illinois Wesleyan. They know that papers are filled out, usually by their parents, and then in a couple of months, a figure jumps out of nowhere and becomes "Your Financial Aid Package."


Improved Data Migration And Processing For Projecting The Financial Aid Budget, Jeffery L. Olson '96 Jan 1996

Improved Data Migration And Processing For Projecting The Financial Aid Budget, Jeffery L. Olson '96

Honors Projects

Last fall, I again resumed work on the budget projection model that encompassed five spreadsheets. Four of these sheets generated a set of statistical averages for each class. Each one consisted of 101 columns containing data for the four-to five-hundred students(rows) in each class. In addition, a fifth sheet used these averages to generate a highly accurate prediction for expenditures in the upcoming year. However, there were two main areas of improvement that became readily apparent: importing data and the sheets themselves.