0478_m24_qp_22
A paper of Computer Science, 0478
Questions:
11
Year:
2024
Paper:
2
Variant:
2
Login to start this paper & get access to powerful tools
2
Four test data types and five descriptions are shown. Draw one line to link each test data type to its most appropriate description. Description a value that is accepted a value that is the highest or lowest value to be accepted and the corresponding lowest or highest value to be rejected a value that is the highest or lowest value to be rejected a value that is rejected a value that is the highest or lowest value to be accepted Test data type abnormal boundary extreme normal An algorithm has been written to test if an integer that is input is in the range 5 to 10 inclusive. Identify an example of suitable test data for each test data type. Abnormal Boundary Extreme Normal
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
8. Programming  →  8.1. Programming concepts
Open
3
A linear search and a bubble sort are standard methods of solution. Fifty numbers are already stored in the array Values[1:50] Write an algorithm in pseudocode to input a number, MyNumber, and use a linear search to test if that number is stored in the array. If the number is found in the array, the position in the array is output. If the number is not found in the array, “Not found” is output. Write an algorithm in pseudocode to sort the array Values[1:50] into ascending order using a bubble sort.
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
8. Programming  →  8.2. Arrays
Open
5
An algorithm has been written in pseudocode to calculate the profit when an item is sold. Values for cost price and selling price are input, the profit is calculated (selling price – cost price) and output. The input of zero for either value stops the algorithm. 01 REPEAT 02 OUTPUT "Enter cost price " 03 INPUT Cost 04 OUTPUT "Enter selling price " 05 OUTPUT Sell 06 IF Cost <> 0 OR Sell <> 0 07 THEN 08 Profit ← Sell - Cost 09 OUTPUT "Profit is ", Profit 10 NEXT 11 UNTIL Cost = 0 OR Sell = 0 Identify the line numbers of three errors in the pseudocode and suggest corrections. Error 1 line number Correction Error 2 line number Correction Error 3 line number Correction This algorithm needs to be improved with a range check. Write pseudocode to reject the input of values less than zero for variables Cost and Sell Describe two other validation checks that should be included in this algorithm. Check 1 Check 2
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
Open
8
This flowchart represents an algorithm to find the average size of groups of visitors to an attraction. NumberGroups NumberGroups + 1 NumberGroups 0 Total 0 Average DIV(Total, NumberGroups) Total Total + GroupSize IS GroupSize = 0? INPUT GroupSize OUTPUT "Average group size ", Average No Yes START STOP Complete the trace table using this data: 7, 10, 2, 8, 3, 9, 0, 6 NumberGroups Total GroupSize Average OUTPUT
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
Open
9
A storage unit rental company wants to set up a new database table for the storage units that can be rented. The table is called StorageUnits and needs to store these details: • SizeMetres – size in square metres • Position – first, second or third floor • Hoist – whether there is a hoist available for the transfer of items • PriceMonth – the price in dollars for a month’s rental • StorageID – the code to identify each storage unit, for example S123 Give the name of the field that would be used for the primary key. State the reason for choosing this field for the primary key. Complete the table to identify the most appropriate data type for these fields in the table StorageUnits Field Data type SizeMetres Position Hoist StorageID Complete this structured query language (SQL) statement to display only the storage code, price and size in square metres of all the storage units where there is a hoist available. SELECT FROM WHERE ;
9. Databases  →  9. Databases
Open
11
Students in a class are recording the amount of time in minutes spent in front of a screen for each day of the week. The one-dimensional (1D) array StudentName[] contains the names of the students in the class. The two-dimensional (2D) array ScreenTime[] is used to input the number of minutes on each day spent in front of a screen. The position of each student’s data in the two arrays is the same. For example, the student stored at index 10 in StudentName[] and ScreenTime[] is the same. The variable ClassSize contains the number of students in the class. Write a program that meets these requirements: • allows all the students to enter their daily minutes of screen times for the past week • calculates the total number of minutes of screen time for each student in the week • counts, for each student, the number of days with more than 300 minutes of screen time • calculates the average weekly minutes of screen time for the whole class • finds the student with the lowest weekly minutes of screen time • outputs for each student: – name – total week’s screen time in hours and minutes – number of days with more than 300 minutes of screen time • outputs the average weekly minutes of screen time for the whole class • outputs the name of the student with the lowest weekly screen time. You must use pseudocode or program code and add comments to explain how your code works. All inputs and outputs must contain suitable messages. Assume that the array StudentName[] and the variable ClassSize already contain the required data. You do not need to declare any arrays or variables; you may assume that this has already been done.
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
8. Programming  →  8.1. Programming concepts
Open