A spreadsheet instructional component allows the author to enter data and perform calculations in Möbius, with the details to be made available for students to interact with during their activity attempt.
This component is ungraded, and can't be manually updated in the Gradebook to add points to a student's grade.
The spreadsheet instructional component is helpful if you want to provide the student with tabulated data, and the student can change data or perform spreadsheet calculations within Möbius.
The Gradebook and the post-submission feedback for the activity will show a read-only static rendering of the component, including any changes made by a student during their activity attempt.
To add a spreadsheet instructional component
To author a question with a spreadsheet instructional component:
Enter the question statement in the Question Text pane of the Question Editor.
Click Möbius component.
Click Spreadsheet from the list of instructional components.
In a cell of the spreadsheet, right-click to use the context menu. You can do any of the following:
Insert row/column — Add a row or column to the table, either before or after the selected row or column.
Remove row/column — Delete the selected row(s) or column(s) from the table.
Undo/Redo — Undo the most recent change to the table, or redo the most recent change that was undone.
Read only — Lock the contents of the selected cell(s) so they can't be changed by students answering the question.
Alignment — Change the horizontal or vertical alignment of text within the selected cell(s).
Copy/Cut — Copy or cut the contents of the selected cell(s).
Enter text or formulas into cells as desired, using the Read only option in the context menu to prevent students from changing the cells.
Click Insert to add this instructional component to the question.
The instruction spreadsheet is inserted into your question.
Click Preview to trial your content to ensure that it behaves as expected.
Click Save to save your new question. Your new question is now stored in the Questions pane of the Content Repository.
Formulas and functions in the spreadsheet
To enter a formula to calculate the value of a given cell, double-click on the cell and then type the formula starting with an equal sign (=):
Cell references are written as either an upper-case or lower-case letter followed by a number (Example — write A2 or a2 to reference the value in the first column and second row).
Use a colon between two cell references (Example — A1:A10) to denote the range of cells between them.
The two spreadsheets defined in question authoring are updated by Möbius when grading, and are referenced as follows:
S1— the completed Spreadsheet to be presented to students that also contains the student's response, and;
S2— the completed Spreadsheet to provide optional grading formulas.
To reference a cell from one spreadsheet (Example — B2 in the student's response) in a different spreadsheet, enter the name above followed by the cell reference (Example — S1!B2).
