Can spreadsheets be used with LockDown Browser?
Posted by Respondus Support

LockDown Browser includes a tool that enables .xls/.xlsx spreadsheets to be viewed and manipulated during an exam session. This functionality is available for Windows, Mac, and iPad editions of LockDown Browser.

Within the quiz tool of the learning system, an instructor should add a link to the spreadsheet in the question wording.  When a student selects the link within LockDown Browser, an Excel-like spreadsheet tool will open.  The spreadsheet can be pre-populated with content or it can be a blank spreadsheet created in Excel that students use to prepare their answers.

As an example, the spreadsheet tool might be used with a multiple choice question. As shown below, a link provides access to a pre-populated spreadsheet. The student calculates the answer and then selects one of the answer choices.

The image below shows the spreadsheet that was used for this exam question.

Alternatively, an instructor can require students to create or modify a spreadsheet and submit it for grading. The example below shows how a short answer or essay question can be used for this purpose.

The question wording itself should provide guidance on the steps a student should follow. As shown above, students are instructed to 1) select the link that opens a pre-populated spreadsheet, 2) create the required formula or calculation, 3) select the button “Click here to save your work”, and 4) paste the resulting URL into the answer field for the essay or short answer question.

After the spreadsheet file has been saved, a dialog will remind students to copy the resulting URL to the answer field using CTRL + V.

Following the exam, the instructor will see a unique URL within the LMS for each student who provided an answer for the essay or short answer question. Upon selecting the URL with a standard browser (not LockDown Browser), the Excel-like spreadsheet tool will  open and the student’s work will be shown for that question.