This article explains how to format numbers using the built-in secure spreadsheet tool in LockDown Browser. It covers functions like TEXT and ROUND to control decimal points and other formatting options such as DOLLAR and FIXED. Additionally, it describes how students can copy and paste values into an essay question for further formatting using the LMS rich text editor. Instructions for using Excel instead of the built-in tool are also referenced.
Summary: The LockDown Browser secure spreadsheet tool allows students to organize and manage tabular data using functions like TEXT and ROUND to format numbers with specific decimal points, as well as other text- and number-based functions. Students can also copy and paste values into an essay question's rich text editor for additional formatting.
Note: This article refers to a built-in “spreadsheet” tool for LockDown Browser. To enable students to use MS Excel during an online exam, see Using Excel with Respondus Monitor. To update the instructor settings so Excel is used instead of the built-in spreadsheet tool, follow these instructions.
----
The secure spreadsheet tool in LockDown Browser is intended to provide the prime purpose of a spreadsheet to organize, manipulate and manage tablular data.
To format the data with a set number of decimal points, the student can use the "=TEXT(value, format_text)" function such as "=TEXT(B1,"0.00")" or the "=ROUND(value, digits)" function such as ""=ROUND(F5, 2)". They can also use a number of other text-based and number-based functions such as DOLLAR, ROUNDUP, ROUNDDOWN, FIXED and TRIM.
As an alternative, the student can copy and paste the values from the spreadsheet into an essay question and use LMS essay question rich text editor to finish formatting the values. The copy/paste keyboard shortcuts are available between the browser tab displaying the exam and the browser tab displaying the spreadsheet.
Original source: Formatting numbers in the LockDown Browser secure spreadsheet tool. | Respondus-Source-ID: 4409595658139 | Source-Updated: 2025-08-27T23:10:21Z
Comments
0 comments
Please sign in to leave a comment.