Sign in

Hands-on assignments in spreadsheets, surveys, dashboards and code

Students do real work in a spreadsheet, a survey builder, a dashboard or a code editor. Each assignment is split into steps, and the Lab checks each step as soon as the student finishes it. You see a log of everything each student did, step by step, and post the grade to your LMS gradebook.

One assignment, start to finish

A survey assignment from the Lab: the student opens the Campus shopping experience survey, asks the assistant for a hint, adds the rule that ends the survey for anyone under 18, and the step is checked.

How it works

1

You pick an assignment

  • Start from a ready assignment, such as a revenue pivot table or a customer survey, or write your own.
  • Each assignment is a short list of steps, and each step has its own check.
  • Try it in your own copy before your students see it.
Choose an activity4 kinds of tool
SpreadsheetBuild a working sheet in an Excel-style spreadsheet
SurveyBuild and test a survey in a Qualtrics-style builder
DashboardBuild a dashboard from a data source in a Tableau-style tool
CodeWrite and run code in a Colab-style notebook or a VS Code-style editor
2

Students work through the steps

  • Each student opens the assignment in their own copy, in the browser.
  • When a student finishes a step, the Lab checks it right away, so the student knows the step is right before moving on.
  • You can also let students ask the assistant for a hint.
Prepara LabEach student works in a real tool, in their own copy, inside your course.
  1. 1The assignment reaches each student
  2. 2The student does it step by step, each step checked
  3. 3You see each student's steps and grade the work
3

You read the log and grade the work

  • The log shows everything each student did: every change, every error, and when each step was first right.
  • It also shows how long each student worked, with long pauses left out.
  • Each grade starts as a draft. You check it and post it to your LMS gradebook.
Maya Chen’s log16 minutes of work
0:00Opened the assignment
4:12Step 1 checked
6:40Error in a formula
7:25Fixed it, step 2 checked
9:02Asked the assistant for a hint
12:48Step 3 checked
15:30Step 4 checked
Send gradesDraft

Nothing reaches your LMS gradebook until you see the list and press Send.

Maya ChenStep 4 of 4 checked10 / 10
Devon ParkStep 3 of 4 checked8 / 10
Emma SilvaStep 4 of 4 checked10 / 10
Check the drafts, then sendReview and send

How the Lab fits your course

Real tools

Students work in a spreadsheet, a survey builder, a dashboard or a code editor, the same kinds of tools they will use at work.

Each step checked

Each assignment is split into steps, and each step is checked as soon as the student finishes it.

A log of the work

You see everything each student did, step by step, before you grade.

Grades to your gradebook

Each grade starts as a draft for you to check, then goes to your LMS gradebook.

Assignments written for these books

Each of these books comes with two assignments written for its chapters. You can also write your own, for any course and any textbook.

Questions

Which assignments are ready to use?

Ready assignments in a spreadsheet, a survey builder, a dashboard or a code editor, such as a revenue pivot table or a customer survey. You can also write your own.

Do students need to install anything?

No. Each student opens the assignment in their own copy, in the browser.

Does it work with every Prepara book?

Yes. It works with any Prepara book, or on its own: start a class for the Lab and invite your students, or connect it to your LMS course through Prepara.

Can I try an assignment before my students see it?

Yes. Try it in your own copy first. Nothing in it is saved to a class or seen by students.

Try Prepara Lab with one assignment

Request access and we set it up with you, in your Canvas course or by email invitations.

Request access