AS & A Level Information Technology (9626) — October–November 2023, Paper 02
18 questions · every question answerable online with instant point-by-point AI marking against the official mark scheme.
Start with Question 1 →Task 1 You will create a spreadsheet for a quantity surveyor to calculate the amount of concrete required for the foundations for a wall or building. You have been supplied with…
Answer this question and get it marked →Task 2 Examine the data in the files n23climate.csv and n23soil.csv. Import these files into your workbook, using appropriate worksheet names. The data in these worksheets will be…
Answer this question and get it marked →Task 3 In the worksheet created in step 1 make sure that cells B3 and B4 can only contain a blank cell or the letter Y in upper or lower case. Add appropriate text for the user.…
Answer this question and get it marked →Task 4 In cells B6 and B7 make sure that users can select from drop down lists the soil type and climate type. Use the worksheets imported in step 2.
Answer this question and get it marked →Task 5 Enter a function in cell B14 to look up the width of the footing in metres. Use the soil data imported in step 2.
Answer this question and get it marked →Task 6 Enter a function in cell B15 to look up the depth of the footing in metres. Use the soil data imported in step 2.
Answer this question and get it marked →Task 7 Edit the formula placed in step 6 to increase the depth of the footing by the Frost factor percentage. Use the climate data imported in step 2. Depth of footing = Value…
Answer this question and get it marked →Task 8 Enter a formula in cell B16 to calculate the length of the footing in metres. Length of footing = Length of the wall + Width of the footing – 0.1
Answer this question and get it marked →Task 9 Enter a formula in cell B17 to calculate the volume of the footing rounded up to the nearest 0.1 m³. Volume = Width × Depth × Length
Answer this question and get it marked →Task 10 Place formulae in cells F14 and F15 to copy the values from cells B14 and B15.
Answer this question and get it marked →Task 11 Enter a formula in cell F16 to calculate the length of the rectangular footing in metres. Length of footing = 2 × (Length of the building + Width of the building) – 0.4
Answer this question and get it marked →Task 12 Enter a formula in cell F17 to calculate the volume of the footing rounded up to the nearest 0.1 m³. Volume = Width × Depth × Length
Answer this question and get it marked →Task 13 Enter formulae in cells B18 and F18 to calculate the cost of the concrete, rounded to and displayed to the nearest dollar. Concrete costs $124.3654 per cubic metre.
Answer this question and get it marked →Task 14 Edit the formulae placed in steps 5 to 13 so that if the soil is not suitable for strip foundations appropriate messages are displayed in these cells.
Answer this question and get it marked →Task 15 Place formulae in your spreadsheet so that when the letter Y is placed in cell: - B3, the contents of cells in the range E8:G18 are not visible - B4, the contents of cells…
Answer this question and get it marked →Task 16 Test your spreadsheet with the following test data. Save each test as a spreadsheet with the given file name followed by your centre numbercandidate number. QSA2: A…
Answer this question and get it marked →Task 17 There is a problem in the design of this spreadsheet. Identify this problem. Enter in cell A20 of QSA5 what the problem is and how you would resolve this problem. Note you…
Answer this question and get it marked →Task 18 The quantity surveyor provides services for each customer. He sends an invoice to customers when he has finished the work to ask for payment. He wants to use a database to…
Answer this question and get it marked →← October–November 2023 Paper 04 · May–June 2023 Paper 33 →
← All AS & A Level Information Technology (9626) past papers