Journey record

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

{data_spreadsheet}

You are travelling from {from} to {to}.

You travel {distance_description}.

Give any introductory information the student needs.

			Name	Type	Generated Value

			raw_data_spreadsheet	spreadsheet	HTML node
			data_spreadsheet	spreadsheet	HTML node

			Name	Type	Generated Value

cities

list

List of 4 items

			Name	Type	Generated Value

co2_per_km	list	List of 5 items
cost_per_km	list	List of 5 items
speed	list	[ 65, 75, 175, 5, 27 ]
journey_cost	list	List of 5 items
journey_co2	list	List of 5 items
journey_time	list	List of 5 items
totals	list	[ 21.00, 0.64, 0.00, 96.00 ]

			Name	Type	Generated Value

			raw_spreadsheet	spreadsheet	HTML node
			filled_spreadsheet	spreadsheet	HTML node

			Name	Type	Generated Value

mode_distances	list	[ 0, 0, 0, 5, 16 ]
distance	number	21
transport_modes	list	List of 5 items
distance_description	string	5km on foot, and the rest on b

			Name	Type	Generated Value

			from	string	Sunderland
			to	string	Durham

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`

Travel distances
	Newcastle	Sunderland	Middlesbrough	Durham
Newcastle		23	66	30
Sunderland			49	21
Middlesbrough				43
Durham

Mode of transport	Cost (£/km)	CO2 emissions (g/km)	Speed (km/h)
By car
By bus
By train
On foot
On bike

→ Used by:

data_spreadsheet

Parts

Spreadsheet

Spreadsheet

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

Using the data sheet above, fill in the journey record form below.

Round costs to the nearest penny, CO2 emissions to the nearest gram, and time to the nearest minute.

Help with this part type

Marks

Show correct answer on reveal?

Show score feedback icon?

Initial sheet

xxxxxxxxxx
 
raw_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","A2:A3","A4:D4","A5:D5", "A5:A11"]

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

Ranges to mark

xxxxxxxxxx
 
[
  "From and To": "B2:B3",
  "Distance travelled": "B6:B10",
  "Cost": "C6:C10",
  "CO2 emissions": "D6:D10",
  "Time": "E6:E10",
  "Totals": "B11:E11"
]

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

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.
Test set of example questions by Nicholas English in Nicholas's workspace.
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

Journey record

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`