A professor at a large, urban university has requested an interactive learning tool through which instructors can assign students a series of experiences, each of which has associated tasks. Experiences will be scheduled by each student, completed in real-time, and may include a variety of questions and media submission types.
Previously, PHP code, database structure, and low-fidelity designs were created. This semester a high-fidelity, interactive prototype with the following criteria was completed:
- Improved the user interface to increase mobile usability.
- Modified formatting to match new designs from client.
- Completed distinct functions for instructors and students.
- Created a new structure for experiences, tasks, and deliverables.
- Changed programming and database to display reminder text for experiences and tasks.
Project Student: Heidi L. Davis
After researching and testing, the solution to this problem was JQuery’s UI Draggable Collision (UIDC) plugin. Over 4500 lines of code were reviewed and dissected, and the UIDC solution was successfully implemented in the code. Now, objects in the floorplan are prevented from colliding. A second task was to insert newly-designed images into the code of the plugin, which was also accomplished.
Project Student: Thomas Wilson
An application is needed for a local company that creates clinical trials and treatments using recent scientific discoveries. The company is funded by multiple state universities along with other private and public partnerships. Currently, this company uses Excel spreadsheets to track their budget and disbursement of funds.
The goal of this application is to give them a web based system to track the information they have each year. Previous work on this project has included building a database with Oracle and creating a front side user interface application on Microsoft Visual Studio utilizing ASP.NET MVC with AJAX and Razor views. All of the pages have been updated to include functional, interactive tables. Pages for calculation details showing how funds are disbursed for payments still need to be created, as well as a history page to allow the company to view past record updates.
Project Student: David Hahn
An Indiana landscaping company wants a new system to store information on their inventory and billing. They have been using Excel spreadsheets to keep track of everything up to this point. This set up has been successfully replaced with a database using SQL Server. The front end was created in Microsoft Visual Studio with web forms. The web forms application has a good start, but still requires a login system, better control of the action buttons, and more CSS to give it the look the company would prefer. It also needs systems for notifications and reporting.
Project Student: David Hahn
The purpose of this project is to make necessary modifications to a database in order to handle the information of the current and new games in order to meet the client’s requirements. First it was necessary to create a new ER diagram to analyze, understand, and document the functions of the database. Following that, the PHP files that insert to and modify the database were analyzed and developed to improve communication between the game websites and the database.
Project Team Members: John Foust, Juancarlos Martinez
An educational entity requested a solution that is capable of auditing their workstations. Their primary goal is to monitor logins to ensure that workstations are not being accessed after open hours. The ideal solution would also generate and send emails as alerts.
Expanding on the original scope of the solution, LibreNMS was chosen for its capability to monitor events at a system level through syslogs as well as provide a centralized, web-accessible platform to analyze overall network traffic, addressing information, and system specifications. Batch scripts were written to automate the configuration of the workstations’ SNMP and syslogs. A combination of batch scripts and task scheduling were used to identify workstation logins at specific times.
Project Student: Keith Cornell
A local non-profit organization website dedicated to finding foster homes and adoptive owners for dogs in the state of Indiana needs their adoption process updated. Currently the application process to adopt a dog is done via a pdf that has to be either scanned and emailed, or sent out by regular mail to the organization.
The goal of the project is to turn those pdf forms into actual online forms where the user can fill out and submit them on the same site, without having to physically send them or email them. The purpose is to create a better experience and facilitate the job of their personnel making it easier for them to track and file the applications.
WordPress is the content management system used for the site. To create the forms, a plugin called FormidablePro will be utilized, as it allows for the creation of easy forms that can integrate into a WordPress site with ease.
Project Student : Jorge Valdivieso
This project is to design and implement a Compensation Calculator for a local government personnel website. The personnel department would like to add to their website a web application that will help a new or potential associate calculate the total amount of compensation to be received in their new position based off the current year’s benefit rates found on their website. The department currently uses an excel spreadsheet designed to use the posted salary amount, then gives an estimated total of compensation expected to be received as remuneration. A web application with a small database was designed and implemented, and still in the design stages.
Project Student: Bonani Ndabambi
Our client would like to develop a mobile application that the instructor can track their students. They would like the students to be able to: post their location, submit their assignments, use different media to submit their assignments (picture, video, voice), be able to send a notification to the instructor if they need assistance, and be able to clock their time on the assignment site. They would like the instructor to be able to: create assignments, deadlines, and quizzes; be able to track their students location, be able to assign grades through the application as it is also interfaces with a Learning Management System (such as Canvas), and be able to notify students via notifications as well.
Project Students: Darius Mpinga, Ronny Ovando, Amadou Traore
A local organization facilitates the translation of scientific discoveries in the lab into clinical trials and new patient treatments in Indiana and beyond.
The organization has numerous spreadsheets to assist in their budgeting and application of benefits for those involved in the trials, including the doctors, staff, etc. Previous work done by the Living Lab has created a database (in Oracle) which contains tables and stored procedures, along with a basic website for viewing, editing, and creating data. The focus of the continued development will be to continue working on the creation and editing of the data via a website, and making it so data can be imported (such as a Fringe Benefit schedule) at any time.
The website application has been updated so that quick entry of data can be entered without the user needing to click update constantly (using AJAX). Also, the users can now import a file with the correct columns and update certain areas very quickly using an export from other various systems. Along with these updates, some database structure changes were made to better fit the .NET Entity Framework and additional fields were added for auditing purposes. Along with these fields, an auditing factory was integrated so that any inserts, updates, or deletions would be tracked. The user interface was updated so the user does not have to “page” through data one web page at a time, and not get a list of hundreds of records at a time, a search function was integrated, along with other various improvements. Finally, the application now uses IU CAS authentication to provide security of the website. Overall, this was a fun, and at times frustrating, project to work on, and I feel confident leaving the project in the hands of the next programmer. Utilizing the resources I have already worked into the main parts, and expanding on those to the other areas that are in need, along with the documentation I am providing, they should be able to get started quickly and efficiently move through the rest of the requirements for the client.
Project Student: Chad Beckner