An app for a teacher to distribute and collect class assignments.
How we built this appWe built this app by first creating a workbook with two worksheets. Then we connected the spreadsheet to AppSheet via the Google Sheets add-on. 1. We added two tables from the spreadsheet to the app via Advanced Editor > Data > Tables > +Table. “Assignments" shows the assignments and contains the PDF documents students can download, and “Submit” contains the appropriate fields for students to submit their work. 2. We created a reference between the column “Assignment" in the Submit table and the "Assignments” column in the Assignments table. We did this by going to Advanced Editor > Data > Column Structure, selecting “Assignment" and then changing its type to “Ref". When we selected “Ref", we needed to select the table we want to reference to. Now, when a student adds an assignment, the Assignment will be auto-populated with a drop-down showing the corresponding value from the course menu. 3. We also created a slice in order to display past assignments solely for the user who is signed in (since the professor does not want students to be able to view others’ work). We did this from Advanced Editor > Data > Slices. First we named the slice “Student Work”, then chose the source table (which is the Submit table), and made sure the update mode was “ADDS_ONLY” (so students cannot edit past work). Then we added the filter column, which in this case is Student. The correct filter condition is “Matches the user name”— this ensures that the app will only display submissions that match the current signed in user’s name.
Education & Training