Information Technology students from Minnesota School of Business in Blaine completed a service learning project, aimed at improving the Blaine campus. The MSB Online Suggestion Box (OSB) provides students and staff members the opportunity to electronically make suggestions that will improve the campus.
The Database Design class applied classroom skills to create the OSB. The purpose of the OSB is for students and staff to have the opportunity to offer suggestions regarding the campus, that will be reviewed and possibly impact change. Through the OSB, suggestions can be made either anonymously or with identification. If identification is provided, feedback on the suggestion is entered into the system.
There is a facility in the OSB for suggestion reporting. A report is generated that displays suggestions that were input during a certain date range. An additional report lists all suggestions input to date. Check boxes by each suggestion indicate either an open or closed status. If an email address was given by the individual who submitted the suggestion, that information will be hyperlinked next to the suggestion in the report.
As currently implemented in Microsoft Access 2010, the OSB is resident on only one computer and is not connected to a network. The second stage of the project is currently underway by the students in Database Implementation (DB311). These students have the option of changing nearly anything about the database to improve its functionality or performance.
“We hope that the OSB will eventually be implemented in a networked environment, so users can make suggestions from any computer connected to the Internet, either on campus or at home,” says John Daley, Information Technology Program Chair and instructor of the course. “Furthermore, we hope the administrator will be able to pull reports and update statuses from any computer, and suggestions can be routed to the assigned action person electronically.”
Kevin Harjamaki, a student in the Database Design class found this class experience to be valuable. “This project took what we learned in class, and gave us a practical application of the information we learned,” he said. “It allowed us to further our knowledge beyond what was covered in class.”