Figma
compiled database on google sheets
user input database
app #1 through mit app inventor
app #2 through figma
Apps Script

Overview

We had an overarching idea of creating a Covid app as a resource for Wellesley students. There are 3 main components: reporting cases, tracking cases, and resources page.

Reporting cases: There is a self-report feature for students and a "report for others" page for staff. This makes it so that there is one central place for all covid-reporting. For each report, the app will get the student's information, such as the dorm, student ID, and date of test.
Tracking cases: Users can view data based on the dorm. The program would enter the information from the previous section into a database and automatically create these graphs. There is also an additional dashboard that would provide summary statistics about cases school-wide.
Resources page: Users will be directed to multiple links based on what they need. They will also be directed to contact the Wellesley Covid Action Plan.

How we built it

We split up this work using 3 different platforms: Figma, Snap, MIT App Inventor

Figma:

This was our main overarching prototype. It shows how all of the components come together and is focused on the UI aspect of the project.

Snap:

This is our program that would allow users to report and check cases.

MIT App Inventor:

This app can enter reported cases into google sheets. Google sheets processes the data so that through the app, we can see the number of cases and percentages in each dorm.

Inspiration:

We wanted to improve on the school's resources right now and combine all possible aspect of Covid-reporting into one simple app. This way, it will be easier for students and staff to access anything they need.

Challenges we ran into

We didn't know how to use any of these programs, so our challenge was learning how to do everything from scratch. We learned a lot through this process and have a better understanding of these programs