Date: Junior - October 2019, Senior year of high school
Google spreadsheets allows users to write code in the language of Java Script to interact with and manipulate spreadsheet data. I learned this after Mr. Andruschak asked me if I could help him create an innovative solution to a google sheet. To be honest, I do not remember which it was, as over the following years, I have worked on many google spreadsheet projects throughout the district. This one in particular, necessitated a easy to comprehend readout to be created for a series of tests taken by hundreds of Pre-K students. This is a project that I am very proud of, and it saved a lot of time and effort for everyone who used it.
Here is the raw data, in a very hard to read format. Each child had test information in 7 different tabs, for 7 different tests. Teachers and parents would have to go through 7 different tabs to find all of their children's information! That is ludicrous!
Here, is the solution we came up with. The teacher would type the students name into the box, and my code would then find all of there information from throughout the sheets, and combine it all. If they got a question right, it was highlighted in green, and wrong in red. Yellow was for the rhyming, which was up to the teachers to determine if it was right or wrong. This is much easier to view than the above rows and columns.
One of the coolest parts of this project, was the image, and email below.
Below, is some of the code, for those interested.