Community Partnered Projects from Year 2017 - 2018
(Fall 2017 and Spring 2018)
Search this site:
Alumni Information Management and Outreach System for DePaul School
Students: Kevin Bell, Andrew Greer, Stephen Hartman, and Lindsey Wanta
Community Partner: DePaul School of Northeast Florida
Industry Mentor: Nathan Stetter from Intuitive Reason
The DePaul School of Northeast Florida is a small private school that specializes in serving elementary and middle school students who have learning differences. The DePaul School is Jacksonville's first full-time school for children with dyslexia. The problem was that the DePaul School was managing alumni relations using a simple contact form on their website and local spreadsheets using Excel. Collecting alumni information for reports was tedious as it involved manually searching through their various spreadsheets. Also, event details and volunteer opportunities were managed through a second party tool. Thus, it was difficult to connect alumni data with volunteer opportunities. To address the problems faced by DePaul, we developed a web app that optimizes alumni data collection process by developing a dynamic database that would provide instant and reliable storage and retrieval, as well as analytics. Additionally, the app includes functionality relating to volunteer opportunities, blog posts, and donation opportunities for alumni and parent users to participate in. The ultimate goal is to grow the DePaul community by increasing the connections and relationships between the school administration, parents, alumni, and students.
- Web-based forms for alumni to submit their information
- On periodic basis, sends private link to alumni and request them update their information
- Dashboard with standardized trends with alumni information
- Ability to search for alumni based on variety of characteristics
- Ability to download alumni information to excel and then manipulated as needed
- Ability to manage event and volunteer opportunities information
- Ability to manage blog postings
Resident Information Management System for Five STAR Veterans Center
Students: Frank Butler, Tytus Hamilton, and David Thompson
Community Partner: Five S.T.A.R. Veterans Center
Industry Mentor: Lisa Lamontagne and Gregory Read from Step Up For Students
Five Star Veterans Center is primarily a residential center for homeless veterans that houses 20–30 residents at any given time. Five Star Center helps veterans who are struggling in the civilian world by providing safe and secure supportive housing with wraparound services and holistic counseling that promotes mental and physical wellness. The center has specific challenges when it comes to keeping records as their record keeping workflow involved multiple spreadsheets. Employee prints out relevant sheets and interprets the data to produce residence reports. This project automated their record keeping ability by developing a web-based system for storing and retrieving information about residences. The web application has data entry forms for gathering information about the residents and displays the data collected in charts and graphs. The system also generates custom and ad hoc reports allowing them to communicate intelligently with their sponsors easier and more efficiently.
- Data entry forms for volunteer and resident sign-ins, resident application information, and donation and meals information.
- Dashboard that shows summarized information and relevant trends in the information gathered.
- Restricted access by user permissions (for privacy issues).
- Tabulation of resident demographics including various parameters such as percent residents graduated from the program.
- Reports (Quarterly, Semi-annual, Annual, and on-demand) based on room number, residence, and program participation.
Course Planning and Advising Tool (CPAT) for UNF School of Computing
Students: Madison Gourde, Reggie Jackson, Logan Sirdevan, and Wesley Tucker
Community Partner: UNF School of Computing
Industry Mentor: Jitesh Doshi from Spinspire
In college, it makes sense for students to plan out their graduation path. The current course planning software informs students which courses they have taken and the ones they should take each semester but due to the static nature student may easily get off track. The static view means it doesn’t allow for students to have a personal map, or allow for update their graduation path when they change. Another issue students frequently run into include when looking into future courses, there is no way to determine which elective courses are part of the offered curriculum, as only hard requirements are displayed on the course map. Team 3Peat was tasked with creating an application that provides a dynamic experience to not only for the students but also for the faculty of the school making it easier on all fronts. The application contains a wizard where students answer a few questions about their academic career to help organize their graduation map. By answering the questions, the map will be able to generate a graduation path to exclude courses the student has taken. Once on the current map page created, students can drag and drop certain courses to help build and plan their graduation path. They can now see what would happen if they chose to drop a class or if they fail a certain course, and how it will affect their graduation plans. Building this path makes it clear what courses should be taken for each semester and students will know the exact courses they must take. Advisors will also find benefits with the new CPAT software, as it will allow them to assist students by editing student maps around and leaving comments during advising sessions, which students can access later. Faculty members will also find great benefit from the updated software such as spotting trends between course maps and mass emailing entire groups of students registered to a specific course during a specific semester.
- Ability for student, advisors, and administrator access the system
- Ability to upload course and student information via CSV files
- Ability for students to create a course plans and path to graduation
- Ability for advisors to search for students, and view and modify their course plans
- Generate reports based on course demand per term and student usage
- Course plan module should include dynamic interface
- Ability to drag and drop courses
- Color code courses based on requisite restrictions as there are added to course plan
- Easily access course descriptions, requisite information, and important concepts
- Show potential registration conflicts and relevant policies
- Ability for students to update progress made with a class (passed or not)
- Ability for students to ask what if scenarios to help make decisions on which course to register
Survivors Survey Data Analysis Dashboard System for Hubbard House
Students: Dustin Go, Dorian Johnson, James Smith, and Elizabeth Thompson
Community Partner: Hubbard House, Inc.
Industry Mentor: Tim Butts from LoanLogics
Hubbard House receives feedback from victims who have received services through numerous surveys. These surveys allow Hubbard House executives to identify areas of improvement and demonstrate their success through victim responses. Currently, two systems track and manage information taken from surveys. However, retrieval is slow and individual data points do not allow for thorough analysis. Executives are unable to create reports or draw results from the data. A system in which reports can be dynamically generated based on a variety of factors will provide executives at Hubbard House accurate information to make business decisions. For instance, victim’s satisfaction with the shelter resources from year to year represented in a user-friendly chart would allow for fast and accurate analysis of the current environment at the Hubbard House Shelter. The system we developed is web-based, and it is hosted locally at the Hubbard House shelter and accessible through their local area network. The analysis system includes a dashboard which provides a brief overview of the data in user friendly graphs and charts, an editor to import data based on the survey and survey version, an interface to dynamically generate graphs and charts using a specified set of data, and an account management system, which makes use of role-based authentication for security.
- Forms for data entry of surveys completed in the paper format. There three different surveys – outreach centers, emergency shelters, and county shelters
- Ability to change data entry forms when relevant survey questions are changed
- Dashboard to show trends with the survey data
- Trends on responses to questions/category
- Yearly, quarterly, and weekly trends
- Ability to drill down view response data
- Ability to mass upload and download data
- Ability to search on textual responses
- Extract meaningful information from textual responses
Honorable Mention Award in the Spring 2018 School of Computing Symposium
Data Tracking System for Yoga 4 Change
Students: Katharine Grubbs, Hinal Pandya, Cindy Pham, and Matthew Ramsay
Community Partner: Yoga 4 Change
Industry Mentor: Nicholas Campanini and Caitlin Terzieff from feature
Yoga 4 Change collects student data on notecards at the beginning and end of each of their yoga classes. Employees then enter this data into Microsoft Excel spreadsheets, so that it can later be used to track students’ wellbeing and any trends in the data. Due to time taken on inputting these notecards, Yoga 4 Change can’t easily track how students have improved from attending yoga classes. The organization receive grants from multiple sponsors and this tracked data is a necessity proving that their classes do provide benefits to participating students. The Change Makers has provided a solution through a web application that will allow Yoga 4 Change to efficiently input and track data while having the feature for admins to manage all notecards, facilities, classes, and users. Admins will have access to the export to Excel feature and calculate statistics feature that will assist with data presentation to sponsors. The web application is hosted through Microsoft Azure. With this application, Yoga 4 Change has a more quick and efficient system to input notecard data that is less prone to errors. Compared to the current Excel sheet, the web application will allow multiple users to input data and display the information in a more organized manner.
- Dashboard that displays classes scheduled for each user (teachers)
- Ability for teachers to enter notecards data gathered from their classes. Forms for recording pre & post stress and mood levels, blood pressure, and heart rate for each student
- Ability for administrator to manage teacher information and their schedules
- Ability to track data entered for scheduled classes
- Ability to export data in Excel formatted file
First Place in the Spring 2018 School of Computing Symposium
Client and Donor Management System for Cornerstone SEA
Students: David Atkins, Xhensila Gjika, and Kevin Serrano
Community Partner: Cornerstone Special Education Alliance
Industry Mentor: Ernest Mombay from Life Specialty and Ventures
Cornerstone Special Education Alliance specializes in assisting special needs students. Cornerstone works closely with parents and school faculties to make sure students are getting the education they deserve. Cornerstone wished to replace their existing “build your own website” application created with Knack for managing client and donor data. We developed the client and donor management system as a web-application with a database of clients, donations, and advocates.
- Separate sections for clients (parent and children) and donors – for collect client & donor information
- An administrator dashboard to be able to oversee all users, assign clients to advocates, add tasks, prepare reports
- Ability to generate customized reports based on all fields of information for clients and donors
Duval County Schools Data Collection System for Jacksonville Public Education Fund
Students: Jon-Michael Gyland, Lorenzo Jenkins, Shannon Powell, and Timothy Tuite
Community Partner: Jacksonville Public Education Fund
Industry Mentor: Jordan Burnam from EverBank (TIAABank)
Jacksonville Public Education Fund (JPEF) conducts research to inform action and connect people with resources to address the most pressing needs in our public education system. School Facts Jax is a data tool that contains visualizations of critical details about each school in Duval County. Those details include school location, principal name and contact information, school grade, student demographics, trends in high school graduation rates, pass rate on standardized state tests, and more. However, some of the school facts that are most important to parents/caregivers are missing. They have expressed an interest in knowing about the academic tracks and programs offered at the school, which magnet programs exist, afterschool programs, extracurricular activities, etc. Additionally, some school board members have expressed concerns that some of the schools in the district have negative perceptions within the community, which is impacting enrollment and school performance. We developed a data collection system to aid JPEF's effort to gather information from principals at each school in the district about which programs are offered. The main components of the application are the ability to post videos, the ability to compare schools side by side, and the ability to update programs directly. These features will assist with solving perception issues by providing principals with a medium to communicate with caregivers and positively impact their initial impressions. These caregivers will have an opportunity to observe a prominent member of the schools teaching staff. Principals will now be able to keep school data current with their ability to modify school info which includes program offerings. Administrators will have the capability to control content to ensure consistency with goals and values. Caregivers can compare grades, location, programs and activities for up to three schools at once. This web app provides links to each school's website and a schedule that lists the different schools’ tour dates so that parents can schedule a visit to the campus.
- A web form for principals to provide information about programs that are available at the school and upload links to videos
- Alert notifications for JPEF staff to review submitted information
- Ability for sending private school info page link to principal for review before it goes live
- Ability for principals to update information annually
- Prominent display of principal and Teach of the Year video about the school on the school page
- A search function that allows stakeholders to search the schools by the programs that are offered
Impact Dashboard for City Year Jacksonville
Students: Dorothy Charpentier, Chloe Cruz, Eric Mwaura, and Wafaa Safar
Community Partner: City Year Jacksonville
Industry Mentor: Raymond McDermott from feature
City Year works with students in urban communities to motivate them and help them flourish in their education. Their ultimate goal is to lower the high school dropout rate. Their organizational activities benefit the urban communities because students can become more motivated in their studies and gain knowledge enough to help them in their future careers. City Year Jacksonville measures their data cross-departmentally on an Excel spreadsheet and need a way to visualize their goal progress better. They use the spreadsheet to input the data received by the teachers (impact), development, operations and executive management, and RAD teams. Each quarter the team leader creates a report to track progress made. City Year Jacksonville needs data visualization in the form on a dashboard to transform their data into useful information. The dashboard allows department directors to input the data for each department and select departments to display the data for with graphs. The dashboard application organizes the data better and presents the goals in a more visually pleasing way with the charts. The charts enable City Year Jacksonville to understand their goals and progress more easily. The dashboard indirectly helps the stakeholders involved such as teachers and the students by targeting and separating the goals more clearly to see which areas to focus more on.
- Ability for department directors to enter goals, relevant measures, and progress made towards those goals.
- Ability for all staff members to monitor progress.
- Dashboard to view annual and quarterly trends on goals and relevant measures.
- Admin access for creating and managing department director user accounts.
- Other staff members should be able to view dashboard without login.
- Dashboard should provide a side-by-side comparison of what goal was set and the actual goal that they accomplished to show if they reached their target or have more to work toward the overall goal.
- Dashboard should contain workstream pages that displays the graphs about selected workstream. For example, the Service Delivery page presents the charts for all quarter, annual, and best of city year goals for each category and subcategory within.
- The graphs should be separated to help guide quarterly review meetings so that each department can view their goal progress directly from the charts produced for each quarter’s goals.
Quarterly Employment Report Dashboard for Challenge Enterprises
Students: Ali Amin, Andrew Hall, Chelsea Saffold, and Christina Wilson
Community Partner: Challenge Enterprises of North Florida, Inc.
Industry Mentor: David Haney from Stack Overflow
Challenge Enterprises of North Florida, Inc. seeks to empower individuals living with disabilities and assist in providing the opportunity to embrace the challenges in their lives so that they may become enterprising members of their community. Challenge Enterprises spends many hours downloading the needed information from the Great Plains payroll system and into an excel spreadsheet every quarter. This is a very large excel spreadsheet and is then manipulated several times to generate the needed information to stay in compliance with the federal AbilityOne program. Challenge Enterprises wanted a computer program to assist with preparing this report and also ensure the accuracy of the data. The Quarterly Employment Dashboard is a web-based application that focuses on preparing a quarterly employment report for compliance with the federal AbilityOne program. This dashboard tracks direct labor hours and wages for employees with and without a disability and veterans for products and services to determine a ratio and average wages for Non-AbilityOne and AbilityOne contracts. Also, this dashboard shows sales for the various departments by products and services, new employees with a disability, employees who have received a pay increase or a transfer to a new department for Non-AbilityOne and AbilityOne contracts. Challenge Enterprises can now generate the report more frequently and use the dashboard as a tool for compliance and maintaining current information.
- Ability to manage data on direct labor hours and labor wages for employees, with and without disabilities or veteran status, by department, products, or services.
- Calculate labor ratio for employees with and without veteran status by department, products, or services.
- Ability to manage data on sales by department, products, or services.
- Ability to add new employees by department for total agency and for AbilityOne products and services.
- Ability to monitor pay increases for employees with a disability and/or with or without veteran status for Non-AbilityOne and AbilityOne departments, products, or services.
- Ability to manage employee transfers for Non-AbilityOne and for AbilityOne departments.
- Ability to filter and view data.
Angel Tree Drive Requests Fulfillment System for Child Guidance Center
Students: Ryan Aft, Christian Diaz, and Daniel Koker
Community Partner: Child Guidance Center
Industry Mentor: James Hlavac from GleanView
The Child Guidance Center’s mission is to provide counseling and support services to assist children and families in reaching their fullest potential. The Child’s Guidance Center faces the reoccurring issue of data collection and management during their annual Christmas drive. The CGC was looking for a way to collect, store and use event data in an efficient way. The senior project team has created a donation management software which is a web-based application that will allow the CGC to manage and analyze information for their Christmas toy drive through the use of a simple application. Significant benefits of the product include the minimization of physical forms, of redundancy in user submitted information, and the institution of a streamlined platform to simplify the project and its current procedures. Major features that are provided by the product include a web system with login and registration functionality, forms for gathering user information, a database for housing and sorting information based on a predefined schema and exporting information into a concise format.
- Web-based forms for therapists to enter holiday wish lists for their clients. Form should contain information for client name, grade level, gender, products requested, comments, any restrictions, client’s siblings, and ethnicity.
- Ability to make special product request that is not part of holiday or school supplies drive.
- Ability for Assistant to view and monitor special request, holiday wish list, and school supplies requests.
- Ability to update system when requested items for a client has been purchased or obtained from a donor.
- Ability to sort data by product, client/siblings, and by “Angel”.
- Ability to export data into an Excel file.
- Dashboard to track number of requests made and requests fulfilled.
Employees Professional Development Tracking System for Episcopal Children’s Services
Students: Michael Dimmit, Austin Dolby, Christopher Kingdon, and Jerrad Monagan
Community Partner: Episcopal Children’s Services, Inc.
Industry Mentor: Jonathan Ohlrich from Imagined.Cloud
Episcopal Children’s Services helps underserved children in Northeast and Central Florida build a strong foundation for educational success. Working with children from birth to age 5 – the most critical years for cognitive development – ECS’s dedicated teachers and staff use curriculums based on the latest research and best practices to help families ensure their youngsters enter school ready to learn. Episcopal Children’s Services provides educational services in the form of teachers to the community. Granting agencies require teachers to be certified and maintain these certifications. Excel spreadsheets based means of managing and tracking when a teacher needs to be certified were cumbersome, needs too much oversight, and not conducive to growth of Episcopal Children’s Services. The solution we developed to solve the problem was a MVC .net core web application. The web application system provides administrators the ability to add, edit and delete staff information. That information is processed by the software and displays generic reports to view only managers. The software also provides administrators the ability to generate custom reports for their managers based on any combination of the results they wish to check. The reports also display a color scheme if certifications are required, and they are going to expire. An additional feature you can track anything under the certification category that has a start date and expire length in months. For example, you can track a CPR training that is required every twelve months for people of a specific group or position. The program runs on internal network behind the Episcopal Children’s Services infrastructure. Episcopal Children Services benefits from completion of teacher certification objectives, now being able to control access with admins having write access and viewers being able to export reports and look at predefined filters. The tracking system assures that qualified teachers are impacting the community in a positive manner.
- Manage information about staff such as position, center location, date of hire, and education credential. Include major minor for each Associate, bachelor, and master’s degree.
- Track completion status of Department of Children and Families Day Care Licensing DCF 45 hours (7 classes and 6 tests required).
- Track Child Development Associate (CDA) credential status: who has an infant/toddler, pre-k, or home visitor CDA.
- Track staff with director’s credentials and renewal dates List of staff enrolled in a degree program.
- List of staff using ECS tuition assistance: CDA online classes, CDA certification, college, other credentials.
- Track status of annual training hours (15 for all staff as required by HS, 40 for center staff). Training must be completed between July 1 and June 30th each year.
- Track staff (family advocates and home visitors) with Family Development Credential (FDC).
- Track staff with Classroom Assessment Scoring System (CLASS) certifications and renewal dates for infant CLASS, toddler CLASS, Pre-K CLASS.
- Track status of professional development plans: Initial plan completed, mid-year update, end of year update.