Information like the exercise title and assignment text can be put in the meta sheet. The data in the meta sheet can be seen as key-value pairs (for example
title: Sheets course). The data is described in column
A and column
A holds the keys (like
B holds the values (like
Sheets course). An example of what this looks like is below:
The following naming convention should be used for the meta sheet:
Exercise <exercise number> - Meta .
Specifically, the following fields can be set:
- title: title of the exercise - plain text
- assignment: assignment of the exercise - markdown rendered text
- instructions: instructions of the exercise - markdown rendered text, maximum of 4 bullet points
- hint: hint of the exercise - markdown rendered text, maximum of 4 bullet points
- highlight: specifies which parts of the sheet are highlighted when the user lands on the exercise - one range (e.g. F5, F5:G6, ...) or a list of ranges, separated by a semicolon (e.g. F5;F5:G6)
- success_message: success_message of the exercise. This is the message students see when an exercise is completed.
- type: the type of the exercise. More on this in the section about other exercises. If no type is defined, the default type will be used.
- data_selectors: this is a field that gives you control over which data is preserved between exercises. More information on this field below.
The value of the data_selectors field should be a list of keywords separated by commas, e.g.
values, formulas .
The keywords are:
- values: the raw values in each cell, no formulas
- formulas: the formulas in each cell
- numberFormat: the number format in each cell. This controls whether 0 is shown as $0 or 0.00, for example
- pivotTables: all pivot tables in the sheet
- charts: all charts in the sheet
- conditionalFormats: all conditional format rules in the sheet
- styles: all style information in the sheet. This includes column widths, row widths, borders, and number format. It does not include merging cells or conditional formatting. Note that including styles will cause the highlight field to be ignored. This keyword is a superset of numberFormat. You can use them both, but using only styles will have the same effect.
If no data_selectors are set, the default is
values, formulas, numberFormat, pivotTables, charts .
Setting the field to only include keywords that are necessary for the exercise can make it faster. Omitting a required keyword will lead to unexpected behaviour.