- description: a multiuser WordPress website and plugin that provides a portal for parents to view their child’s grades from the teacher’s .xlsx based class gradebook stored in Microsoft OneDrive.
- built for my 2024-25 grade four homeroom
- developed rapidly to fit my existing grade management process (Microsoft Excel)
- website
- github
- architecture:
- ui: PHP based WordPress shortcode. JS/JQuery for AJAX request and data rendering
- internationalization and localization: Polylang (landing page translates to Mandarin)
- api: PHP REST API route fetches student data from OneDrive spreadsheet via Microsoft Graph API and serves it to the frontend
- theme: OnePress
- next steps:
- full scale data integration with MySQL. Move all the data to the database and build a teacher view for inputting grades. Redesign the app to enable scaling to multiple teachers, classes, or schools. Probably move away from WordPress at some point
- build intelligence features for parents to visualize the data and better understand their child’s performance and needs
- use the WordPress blog feature to post articles about how to use the site
- full coverage of Mandarin translations throughout the app
- Visit this page for a demo of this project.
