AirSpace is an audience response platform that allows audience members to provide feedback and answer a host user's questions in real-time. Anyone can initiate a session or join existing sessions via phone, tablet, or computer.
Differences from Version 1
- Users login through Google via Passport.js
- Improved accuracy of our current Active Guest Users display and functionality on the Host Dashboard
- Implementing a multiple choice quiz type
- 1. Concept
- 2. Initial Planning
- 3. Database Architecture
- 4 Backend Structure
- 5. Frontend: React and CSS
We developed AirSpace with the intention of creating a multipurpose space where host users could poll an audience, sending information back and forth instantly.
We had seen digital audience response systems like this in videogames (such as Jackbox.tv) and lecture halls (using "clickers"), but not in the form of an easily accessible mobile app that wouldn't require extra hardware software installation.
In this second iteration of AirSpace, we're specifically developing for use by teachers and students in order to facilitate an open and collaborative classroom environment.
2. Initial Planning
- Create schema
- Add dummy data to our tables
- Re-write queries from Version 1:
- Add Host
- Add Client
host_clienttable - Create Survey/Question (referred to as
sq) - Add sq - return id - Add question - return id - Add options - return id - Add linking table
3. Database Architecture
Our database contained five primary tables:
- sq (survey/quiz)
And three linking tables: