To those that are unfamiliar as to how my high school works, if a teacher is absent from school a certain day, the students get to go to the cafeteria and work on whatever they choose. So, I found it incredibly annoying that I walk all the way across school, find out that a teacher is not present, and then walk back across the whole school to sign into the cafeteria

What it does

The teacher that will not show up the next day has to fill out a very small form that has 2 questions. The questions get uploaded to a google spreadsheet. Within that spreadsheet, there is a regular sheet and a sorted sheet. The sorted sheet then has google scripts running in the background, then manages them and gets rid of the very old dates.

How I built it

I built this app using android studio and various google products such as their apis and their office products i.e. sheets, forms, and scripts.

Challenges I ran into

I ran into many challenges during this project because I was completely unfamiliar with the Google Api module/library. There was a really big learning curve that was needed to complete this project.

Accomplishments that I'm proud of

What I learned

I learned how to use the google api libraries and how to use google sheets as a cloud database for android studio. As well as many features in git/github and android studio has a whole.

What's next for BCATeacherAbsence

Next for this app, I will be working on a one time setup for the first time download of this app that will give personalized notifications. I will also be building a web app for this.

Share this project: