Calculate areas of rooms in a house

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

A surveyor has measured the rooms in a house and produced the following drawing (not to scale):

Plan drawing of a house, with rooms and their dimensions labelled.

Measurements are given in metres.

Give any introductory information the student needs.

			Name	Type	Generated Value

raw_spreadsheet	spreadsheet	HTML node
dimensions_spreadsheet	spreadsheet	HTML node
spreadsheet	spreadsheet	HTML node
dimensions_spreadsheet	spreadsheet	HTML node
areas_spreadsheet	spreadsheet	HTML node
filled_spreadsheet	spreadsheet	HTML node

			Name	Type	Generated Value

dimensions

list

Nested 5×2 list

			Name	Type	Generated Value

x1	number	1.62
x2	number	1.39
x3	number	1.15
y1	number	1.87
y2	number	1.2
y3	number	1.48
names	list	List of 5 items
dims	list	List of 5 items
areas	list	List of 5 items
total_area	number	18.928
highlight_style	dict	Dictionary with 1 entries

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`

Room	Width	Height	Area
Kitchen
Dining room
Hallway 1
Hallway 2
Living room
		Total Area

→ Used by:

spreadsheet

Parts

Spreadsheet

Spreadsheet

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

Fill in this survey form. Give lengths in metres to the nearest centimetre, and areas in square metres to the nearest cm².

Help with this part type

Marks

Show correct answer on reveal?

Show score feedback icon?

Initial sheet

xxxxxxxxxx
 
spreadsheet

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:D1", "A1:A6","A7:C7"]

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

Ranges to mark

xxxxxxxxxx
 
["Dimensions": "B2:C6", "Areas": "D2:D6", "Total area": "D7"]

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.01

Advice

First write in the dimensions given on the drawing:

{update_range(dimensions_spreadsheet, "B2:C6", highlight_style)}

Next, calculate the area of each room, by multiplying the width by the height. Round to the nearest cm², or 0.0001 m².

{update_range(areas_spreadsheet, "D2:D6", highlight_style)}

Then, add up the areas to find the total area:

{update_range(filled_spreadsheet, "D7", highlight_style)}

Give a worked solution to the whole question.

URL

Text alternative

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 Christian's workspace.
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

Calculate areas of rooms in a house

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`