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


Note:  The .csv file type is not supported. Please convert this file type to .xls/.xlsx before attempting to use it with Respondus LockDown Browser.


  1. Locate and Build the exam in your course.
  2. Locate a question to use for the Excel portion of your test and Edit the question.
  3. In the Text Editor, select Insert Document.
  4. Select Upload Document.
  5.  Select one Excel file, open it, and once the question is finished, click Done the bottom of the question.
  6. The Excel file is now in the Exam question.


When a student selects the download link within LockDown Browser, a spreadsheet tool will open in a new tab.  The spreadsheet can be pre-populated with content, or it can be a blank spreadsheet created in another spreadsheet app,  which students use to prepare their answers.




NOTE!!  If the student selects the name of the file, nothing will happen.  They MUST select the download arrow to open the excel spreadsheet in the test.


The question wording itself should guide the student through the steps of submitting their spreadsheet. As shown above, students are instructed to 1) select the download 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 question.


After the spreadsheet file has been edited and the link selected "CLICK HERE TO SAVE YOUR WORK", 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 to the essay 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.