Construct a spreadsheet from scratch

Error

There was an error loading the page.

Contributors

History

○

Christian Lawson-Perfect 1 year, 9 months ago

Published this.

○

Christian Lawson-Perfect 1 year, 9 months ago

Created this.

There is only one version of this question that you have access to.

There are 2 other versions that do you not have access to.

Question statement

Here is a score sheet from the local games league.

{spreadsheet}

Give any introductory information the student needs.

			Name	Type	Generated Value

scores	list	[ 7, 2, 7 ]
times	list	[ 50, 30, 30 ]
spreadsheet	spreadsheet	HTML node
spreadsheet_to_fill	spreadsheet	HTML node
points_per_second	list	[ 7/50, 1/15, 7/30 ]
filled_spreadsheet	spreadsheet	HTML node

Automatically regenerate variables?

Name

Data type

Value

xxxxxxxxxx
 
repeat(random(1..10),3)

JME function reference

Description

Describe what this variable represents, and list any assumptions made about its value.

Can an exam override the value of this variable?

Generated value: `list`

[ 7, 2, 7 ]

This variable doesn't seem to be used anywhere.

Parts

Spreadsheet

Spreadsheet

Ask the student a question, and give any hints about how they should answer this part.

Fill in the "points per second" row. Round values to 2 decimal places.

Help with this part type

Marks

Show correct answer on reveal?

Show score feedback icon?

Initial sheet

xxxxxxxxxx
 
spreadsheet_to_fill

A spreadsheet object giving the initial state of the sheet that the student should fill in.

Correct answer

xxxxxxxxxx
 
filled_spreadsheet

A spreadsheet object representing a correct answer to the part.

Ranges to disable

xxxxxxxxxx
 
["A1:A4", "A1:D3"]

A list of cell or range references, denoting the cells that should not be editable.

Ranges to mark

xxxxxxxxxx
 
[ "Points per second": "B4:D4" ]

A dictionary of cell or range references, mapping names to ranges of cells, denoting the cells that should be compared for equality with the expected answer.

Marking method

Allowed margin of error

xxxxxxxxxx
 
0.005

Advice

To calculate points per second, divide score by time.

For example, for person {spreadsheet["B1"]}, the points per second is:

$\simplify[basic]{{scores[0]} / {times[0]} = {points_per_second[0]}} = \var{precround(points_per_second[0],2)} \text{ to 2 decimal places}$

Give a worked solution to the whole question.

Use this tab to check that this question works as expected.

There was an error which means the tests can't run:

Part	Test	Passed?
Spreadsheet
Spreadsheet		Hasn't run yet

This question is used in the following exams:

Spreadsheets extension by Christian Lawson-Perfect in Demos.
Kopy of Spreadsheets extension by Raul Duarte in kopiador.

Loading...

Error

Metadata

Taxonomy: mathcentre

Taxonomy: Kind of activity

Taxonomy: Context

Contributors

History

Comment

Checkpoint description

Christian Lawson-Perfect 1 year, 9 months ago

Christian Lawson-Perfect 1 year, 9 months ago

Error in variable testing condition

Error

Warning

Generated value: `list`

Parts

Spreadsheet

Loading...

Error

Construct a spreadsheet from scratch

Metadata

Taxonomy: mathcentre

Taxonomy: Kind of activity

Taxonomy: Context

Contributors

History

Comment

Checkpoint description

Christian Lawson-Perfect 1 year, 9 months ago

Christian Lawson-Perfect 1 year, 9 months ago

Error in variable testing condition

Error

Warning

Generated value: list

Parts

Spreadsheet

Generated value: `list`