Tip: Choose Save as PDF in the print dialog to download. Use A4 paper size.
Shade in the A or B circle for each question.
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 122.4, 22.4, 22.4, 22.4, 22.4, 22.4 | Aoffset = 0.0 - reading_in_ice_water | |
| 221.8, 22.0, 150.3, 22.1, 21.9 | BAssuming a sensor is always accurate. Ice water should read about 0, so the sensor has an offset and needs calibrating. | |
| 3Calibrate a sensor by comparing it with a known value and working out the offset | CA stuck reading: the value never changes, which suggests a faulty sensor or a frozen logger | |
| 4Flag readings that fall outside the range the sensor can possibly give, as a check for spikes | D=IF(OR(B2<-10,B2>50),"Check","OK") | |
| 5Sensor reads 3 degrees in ice water, so no action is needed because sensors are always accurate | EAn impossible spike: one value far outside what is possible, likely caused by electrical noise or a fault | |
| 6A sudden reading of 999 is kept because it is real data and must never be questioned | FKeeping an impossible spike without checking it. Readings that are out of range may be noise or a fault and should be checked. |
Complete each line of code by filling in the missing parts.
Shade in the letter of the line that contains an error.
sensor error — A reading that is wrong due to a faulty or uncalibrated sensor or electrical noise, so check for stuck values, impossible spikes and offsets against a known value.=MAX(B2:B100)=IF(B3=B2,"Stuck","OK")=B2-E1=IF(B2>50,"Spike","OK")=AVERAGE(B2:B6)