You can do the following with the Class Assignments App:
- Track and download homework assignments. The Tasks view shows all assignments in order of when they are due. Within any assignment, clicking the little file icon next to each assignment in the “Materials” field allows you to download the assignment to your phone as a PDF.
- Submit assignments. Each assignment has a “Submit” field, which is actually a reverse ref to another table I’ve included in the app. Clicking “View” allows the student to view past work they’ve submitted for that assignment. Clicking “New” takes users to a new page where their names are autofilled in (because we’ve required user authentication), the corresponding assignment is auto-chosen from the a dropdown menu, the student can submit a document link, and where the timestamp is auto-recorded so the professor knows when the work was submitted.
- View past work. As described in the last item, students can click into individual assignments and hit the “View” button to see their past submissions for that particular assignment.
Education & Training
An app for a teacher to distribute and collect class assignments.
We 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.
Choose a Sheet
To find the ID of a sheet, go to the Smartsheet site, open the Properties of the sheet, and copy the ID property.