We wanted to make an easy way for students to visualize their grades and track their progress in all their classes.
What it does
Gets information for the grade of each of a student's classes on Infinite Campus and returns it in the form of a spreadsheet.
How we built it
We used a Python based web-scraping tool called Selenium to retrieve the information from our school's grade portal. We also used Google API's to upload the data to Google Sheets.
Challenges we ran into
Finding the information on the html page was challenging, the data we wanted was hidden inside many classes and took some effort to access.
Accomplishments that we're proud of
Being able to navigate to the website and retrieve the data we needed was a significant accomplishment for us since we had no prior experience with web scraping and web automation.
What we learned
We learned about the Selenium library and its uses, as well as how to navigate through a lengthy HTML file and make sense of it. We also learned the power of the Google API and how we can connect Python and Google Sheets seamlessly.
What's next for Infinite Campus Web Scraper
- Integrating the product with google sheets
- Creating a user friendly interface to run the program
- Automating the execution of the program