Can spreadsheets be used with LockDown Browser?
Posted by Respondus Support
LockDown Browser includes a basic spreadsheet 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. Exactly how this link is determined and then added to the question differs with each LMS. In most cases, you should:
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 spreadsheet tool will open and the student’s work will be shown for that question.
Note: the spreadsheet tool is not available for the McGraw-Hill ALEKS or Pearson MyLab integrations.