Skip to main content

Creating an Excel Assignment

Guide on how to create and publish an Excel assignment in Vocareum.

A
Written by Akash Cherian
Updated this week

For Teachers and Admins

Introducing Excel in Vocareum

With Excel assignments in Vocareum, learners can access a copy of their Excel assignment with ease. Teachers benefit from submission and grading tools, as well as full-featured Learning Management System (LMS) integration using LTI 1.3.

This guide will walk you through the assignment creation process.

Prerequisites

  1. The Excel assignment type must be enabled for your organization - Please contact support@vocareum.com if you do not see the Excel lab type as an option in assignment creation.

  2. This assignment type is only available in modern Container architecture courses, and cannot be used in Elite architecture courses. See Vocareum Container Architecture for more information.

Assignment Creation

  1. From your course page select "Edit Assignment" then "New Assignment".

  2. Create a name for the assignment and select your lab type. In this case we've called it "Excel" and selected the lab type "Excel". Press "Save and continue".

  3. Now that your first Part has been created, return to the Assignment settings.

Configure Workspace

Now that your Assignment has been created you'll want to populate it with content.

  1. Select Configure Workspace. This will open the teacher authoring environment.

  2. This is where you will be able to upload, create and deliver content and data to your students' Excel environment.

  3. The authoring environment is using the Vocareum Notebook UI. You can create and upload Excel files in this environment.

  4. To the left is the 'Files' browser. You can deliver content a few different ways from here. More detail on Vocareum's file system can be found here. In order for learners to get access to a copy of an Excel file, the file must be placed in /voc/startercode.

  5. If you would like to see how your lab will look to your students in Excel, navigate to the top right and select 'Student View'.

Student View

Instructors and Admins can access a simulated version of the student environment to test their coursework. From either the assignment settings page or the instructor workspace select "Student View" to open.

  1. Following the instructions in the Quickstart document select 'Excel'.

  2. Excel will open in a new tab in your browser, where students can instantly access their coursework. If a student needs to submit their work or need to launch Excel again, then they will need to do so from the Vocareum lab.

    1. When students are ready to submit their coursework they just need to select 'Submit' on the top right of the Vocareum workspace and a copy of their current workspace will be sent to Vocareum for manual grading or AI grading.

      A modal will pop up asking if you would like to submit your work and reminding you to save your work (cmd + s on Mac, ctrl + s on Windows).
      ​

      Students will be alerted once their assignment has been submitted.

  3. Students are able to view grades, due dates, submissions, and feedback from the Grades panel. Note: Submissions made from a Teacher's 'Student View' are not recorded in the gradebook.

Grading

When you use Excel in Vocareum, you can seamlessly accept and grade student submissions. Check out this guide to Setting Up Grading for Excel.

Did this answer your question?