Project: SIS Custom Pages

Over the years, I have done a substantial amount of custom web page development work for a K12 school district student information system. My most noteworthy project was back in 2023. I worked on a report card generation applet inside the system. This applet was originally developed in 2019 by a third-party software company to generate report cards for one specific school. In the fall of 2022, the principal of a different school contacted me to request that we pay the same company to build a new report card for their school. Teachers there were planning to change how they handled grading.

In late 2022, I was able to arrange these services to develop our new report card, however months into the project, our assigned developer randomly stopped communicating. I tried re-establishing communications to someone else, directly through the company's website, but nobody responded. Luckily, the woman who was working for us shared all of her progress with me up until that point. Since I knew we had the other school’s fully functional report card to use as a guide, I decided to take a stab at picking up from where she left off. The report cards were generated using a combination of HTML, CSS, Javascript, and SQL running in the web browser. Since none of the code was compiled, I was able reverse engineer how it worked and then finish a working prototype of the new report card for our other school. The school principal who originally made the request was incredibly relieved and spoke highly of my talents.

My second noteworthy project was in the summer of 2024. I created a comprehensive reporting page to complement the school district’s newly acquired electronic registration system. The new system included some built-in reporting functionality, but the reports lacked key at-a-glance information. The custom reporting page I made aggregated the data such that our secretarial staff could easily tell how many students had completed registration at each building. It also included the ability to filter the data down by key metrics and had the ability to export the data to a text file, making it easy to work with the data in other programs. The page was made using HTML, CSS, Javascript, and SQL.

- James