Computer Science · May / June 2018 · Paper 2 SL · Question 4
Adapt for 2027Choosing data types and writing the selection rules fit B2.1 and B2.3 in Python or Java, but the spreadsheet design and test plan parts came from the old modelling option.
IBCS
As printed in the paper
The question as text
4. Ralph owns a furniture store that trades in second-hand furniture, lamps and musical instruments. He buys these items, repairs them where necessary and then resells them. He calculates the value of each item using the information below: • type: furniture, lamp, musical instrument • brand recognition: 1 (low), 2 (medium), 3 (high) • condition: “very good”, “good”, “needs repair” • estimated volume of item: maximum volume accepted is 2000 dm3 (note that 1 dm3 = 1 litre). Ralph is going to use a spreadsheet to model this information.
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
4(a)[4]
4(b)(i)[4]
4(b)(ii)[2]
4(c)[2]
4(d)[4]
4(e)[2]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.