Tag: Database Reporting

Progress:

1. Centered the “Go” and “Clear” buttons on the Kids-U site and moved them to the bottom of the selection box to avoid user errors
2. Changed the “Site Coordinator” dropdown option to “OKM” (On-Site Kids-U Manager) on the staff page of the website
3. Met with Shawn Weisfeld to gain a better understanding of the database’s functions, understood the disparity between the EPICS and Kids-U copies of the repository, and discussed ways to resolve it.

Goals for the Semester:

1. Complete the poster and final report with project details, as well as provide complete information and references for future teams.
2. Present our project to the partner and the judges, as well as discuss the progress we have made this semester at the EPICS exhibition
3. Meet with Mr. Weisfeld to merge the team branch on a public repository with the main branch, fix any migrations and runtime errors, and archive the EPICS repository.

Progress:

1. Met with our mentor, Terrence Jones, and discussed ways to fix the database sorting function that fails to display the students by grade in the correct order
2. Gained a better understanding of the code and the database
3. Found a user manual located on the website under “Help”, which eliminated the need to provide the partner with a handbook on using the database

Goals for April:

1. Center the “Go” and “Clear” buttons on the Kids-U site and move them to the bottom of the selection box to avoid user errors
2. Change the “Site Coordinator” dropdown option to “OKM” (On-Site Kids-U Manager) on the staff page of the website

Goals for Semester:

1. Fix the sorting for “Grade Ascending” and “Grade Descending” to correctly sort the kindergarten students in the list
2. Remove the edit page and replace it with the required fields on the edit page form

If time permits, we intend to create a forgot password function that will allow users to create a new password if they forget their previous one, as well as look into the online form.

Progress:

1. Gained access to student database
2. Gained access to website code via GitHub
3. Fixed the database sorting function (user error)
4. Finished project plan and charter

Goals for the rest of March:

1. Meet with mentor (Terrence Jones) to understand code line by line, which will require a functional understanding of C# and the ASP.NET MVC Framework

Goals for rest of semester (database project requirements):

1. On the staff page, people with the roses listed as “Site Coordinator” need to change to OKM (On-site Kids-U Manager.
2. Limit amount of information shown when getting fluency test reports to only: full name, grade, gender, score on test
3. When pulling testing the spreadsheet should show all students and not just the students who were tested.  This allows Kids-U to know who has been tested and who has not.
4. Give the partner a handbook/guideline on using the database

We have recently realized that understanding the given code may be more difficult than we estimated. As a result, we may have to leave the completion of part 2 of our project, the online form, to a future team.

1. Finished the data entry section of the databasem including student enrollment, outcome measurements, and report cards.
2. Finished the management section of the webpage, with sub-sections including program sites (states the active operating locations), schools, school districts, oragnizations (sponsors for Kids-U), staff directory, and a help page (includes a description for what each sub-section is)
3. Here is a link to the demo video of what we accomplished this semster: https://drive.google.com/file/d/1TaOR_fw904li5W7Zgl1osVtx6xmfTEuM/view?usp=sharing

1. Deployed website on EverLeap: can be accesssed using staff.kids-u.org
2. Added option to input new staff members and included security barrier where certain administrators can only vew certain students

3. Added the option to input organizations/sponsors within Kids-U

Added the ability to filter out students by certain attributes such as race/gender/year of attendence/income/etc and incorporated a report card feature where up to 5 grades can be inputted. Also added an outcome measurement page to show the cumulative grades.