IB Questionbank

User interface language: English | Español

Date	May 2018	Marks available	2	Reference code	18M.2.SL.TZ0.4
Level	SL	Paper	2	Time zone	no time zone
Command term	Calculate	Question number	4	Adapted from	N/A

Question

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 dm³
(note that 1 dm³ = 1 litre).

Ralph is going to use a spreadsheet to model this information.

The spreadsheet model will inform Ralph as to whether he should buy an item. The decision to buy is based on the following rules:

the default values for the items are; furniture $100, lamp $30, musical instrument $80
multipliers are applied to these default values depending on the volume of the item;
for volumes that are 500 dm³ or above it is 0.7, for volumes less than or equal to 30 dm³ it is 1.2, for any other volume it is 1.

Ralph will not buy any item with a value calculated to be over $90.

The model is also used to calculate his final selling price for each item. This price is calculated using the following rules:

initial selling value is 5 times the original default value
a multiplier of 1, 2 or 3 is applied to reflect the brand recognition (a “top brand” receives a multiplier of 3)
another multiplier is applied to reflect the volume occupied. This multiplier is 5 when the volume is greater or equal to 500 dm³, 3 for volumes between 30 and 500 dm³ and 1 for other volumes
a further multiplier is applied depending upon the item’s condition. This multiplier is 2 or 3 when conditions are good or very good, but is 0.8 if the item is damaged.

Copy and complete the following table showing the variables, each variable’s data type and range of values that would represent the information shown above.

[4]

Using the above rules, construct the pseudocode that will help Ralph in deciding whether to buy an item.

[4]

b.i.

Describe two items that would have a calculated value of more than $90.

[2]

b.ii.

Calculate the selling price of a top brand guitar with a volume of 96 dm³ that was damaged. You should show your working.

[2]

With the help of a diagram, suggest an appropriate design for a spreadsheet used to calculate the final selling price, following this model.

[4]

Identify two tests that should be included in the test plan for this model.

[2]

Markscheme

Award [4 max]:
Award [1] for each fully correct row indicating variable name, type, and values (no marks for incomplete information, but do allow abbreviated strings)

e.g.

Note: If a full column is missing, then award [1] for each correct column (for a max of [2]).

Award [4 max]:
Award [1]: correct initialisation of Initvalue.
Award [1]: correct calculation of Temp.
Award [1]: correct comparison of Temp with 90.
Award [1]: correct return/output.

proc Decide(Item, Vol)
Var Temp
if Item = f then Initvalue = 100
  else if Item = l then Initvalue = 30
    else if Item = m then Initvalue = 80;
endif
if Vol >= 500 then Temp = 0.7 * Initvalue      // accept <,>
  else if Vol =< 30 then Temp = 1.2 * Initvalue
    else Temp = Initvalue;
endif
if Temp > 90 then
  return "Reject"            // accept any 2 reasonable outputs
  else return "Accept";
endif

b.i.

Any item of furniture with a volume $<$ 500 dm³;
Any musical instrument with a volume $\leq$ 30 dm³;

Example answers:
A piece of furniture with volume of 400 dm³;
A piece of furniture with volume $<$ 30 dm³;
A flute with volume of 1 dm³;

b.ii.

Award [2 max]:
Award [2] for completely correct answer (only the left or right-hand side needs to be shown).
Award [1] for correctly writing just 4 factors from the left-hand side.

5 * 80 * 3 * 3 * (80/100) = $2880

Alternative expression for the left-hand side:

5 * (Item.IType.Initvalue) * (Item.IType.IBrand) *
(Item.IVol.Percentage) * (Item.ICond.Multiplier)

Award up to [4 max].
Award [1] for some layout design.
Award [1] for each of the following elements:

correct formula for Itype
correct formula for Ivol
correct formula for Icond
correct formula for Selling Price.

Example for [2]:
Award [1] for the general layout.
Award [1] for detail (Vlookup table, explanations).

Award [3 max]:
Type consistency, e.g. currency, integer, floating
Range consistency, depending on the decision procedure,
Value at the limits given by the specification (e.g. < or =<)

Accept any testing that relates to