Fill in table of books per child

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 is one other version that you do not have access to.

Question statement

Give any introductory information the student needs.

			Name	Type	Generated Value

big_spreadsheet	spreadsheet	HTML node
initial_spreadsheet	spreadsheet	HTML node
completed_spreadsheet	spreadsheet	HTML node
num_books	list	[ 135, 166, 155, 194, 109 ]
num_children	list	[ 29, 28, 28, 25, 25 ]
books_per_child	list	[ 4, 5, 5, 7, 4 ]
highlighted_totals	spreadsheet	HTML node
highlighted_books_per_child	spreadsheet	HTML node
first_class_name	string	Reception

Automatically regenerate variables?

Name

Data type

Value

This variable is an interactive HTML node. Interactive HTML nodes can not be relied upon to work correctly when resuming a session - for example, attached event callbacks will be lost, and mathematical notation will likely also break.

If this causes problems, try to create HTML nodes where you use them in content areas, instead of storing them in variables.

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: `spreadsheet`

Class	Books	Children	Books per child
Reception
Y1
Y2
Y3
Y4
Total

→ Used by:

first_class_name
initial_spreadsheet

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 this table. Round the "books per child" down to the nearest whole number.

Help with this part type

Marks

Show correct answer on reveal?

Show score feedback icon?

Initial sheet

xxxxxxxxxx
 
initial_spreadsheet

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

Correct answer

xxxxxxxxxx
 
completed_spreadsheet

A spreadsheet object representing a correct answer to the part.

Ranges to disable

xxxxxxxxxx
 
["A1:D1","A1:A7","B2:C6", "D7"]

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

Ranges to mark

xxxxxxxxxx
 
["Books per child": "D2:D6", "Total books": "B7", "Total children": "C7"]

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

Advice

For the totals on the bottom row, add up the numbers in each column:

{highlighted_totals}

To work out the books per child, divide Books by Children, and round down to the nearest whole number.

For example, in {first_class_name}, the number of books per children is

$\simplify[basic]{ {num_books[0]} / {num_children[0]}} \approx \var{floor(num_books[0]/num_children[0])}$

{highlighted_books_per_child}

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: `spreadsheet`

Parts

Spreadsheet

Loading...

Error

Fill in table of books per child

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: spreadsheet

Parts

Spreadsheet

Generated value: `spreadsheet`