0478_w24_qp_23
A paper of Computer Science, 0478
Questions:
12
Year:
2024
Paper:
2
Variant:
3
Login to start this paper & get access to powerful tools
6
An incomplete algorithm has been written in pseudocode to count the number of values stored in an array and to find their average. Values have been stored in the array starting at A All the values to be counted are non-zero. A value of zero in the array indicates there are no more values stored. 01 DECLARE A : ARRAY[1:50] OF INTEGER 02 DECLARE C : INTEGER 03 DECLARE W : INTEGER 04 DECLARE X : INTEGER 05 W 06 C 07 WHILE A[C] <> 0 08 W 09 C C + 1 10 ENDWHILE 11 X Complete the given pseudocode algorithm. Write pseudocode to display, with suitable messages: • the number of values stored in the array • the average of those values stored. Meaningful identifiers have not been used in this algorithm. Suggest suitable meaningful identifiers for: The array A The variables C X W
8. Programming  →  8.2. Arrays
8. Programming  →  8.1. Programming concepts
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
Open
7
A programmer is testing a program that requires a positive value between 1 and 100 inclusive to be entered. The range check in the program is to be tested. Identify three different types of test data to be used. For each type of test data, give an example of the valueto be used and the expected outcome. Type 1 Example Outcome Type 2 Example Outcome Type 3 Example Outcome
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
8. Programming  →  8.1. Programming concepts
Open
9
A flowchart checks that values stored in three variables are identical. If they are different, the highest value is stored in all three variables. START STOP Is A = B AND B = C ? Is A >= B OR A >= C ? B A C A Yes Yes No Yes No No Is B >= A AND B >= C ? A B C B A C B C Identify four errors in the flowchart and suggest a correction for each error. You may label each error on the diagram with the corresponding error number. Error 1 Correction Error 2 Correction Error 3 Correction Error 4 Correction
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
2. Data transmission  →  2.2. Methods of error detection
Open
10
An algorithm has been written in pseudocode to check that a password meets a set of rules. 01 OUTPUT "Please enter password " 02 INPUT Password 03 Accept TRUE 04 IF LENGTH(Password) 20 05 THEN 06 Accept FALSE 07 ENDIF 08 IF LCASE(Password) = Password OR UCASE(Password) = Password 09 THEN 10 Accept FALSE 11 ENDIF 12 Index 13 Found FALSE 14 WHILE NOT Found AND Accept AND Index
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
8. Programming  →  8.1. Programming concepts
Open
11
Building materials are sold in bags. A new database table called BuildStock has been set up to store details about the materials for sale. Part of this table is given. MtNo Name InStock WeightKg PricePerBag NumberBags MT01 Builders sand Yes 4.50 MT02 Sharp sand Yes 3.50 MT03 Red sand No 2.75 MT04 Cement No 6.85 MT05 Chippings Yes 35.00 MT06 Cobbles No 67.35 MT07 Pebbles small Yes 34.50 MT08 Pebbles medium Yes 25.50 MT12 Pebbles large Yes 62.75 MT15 Washed gravel Yes 12.75 MT16 Pea gravel Yes 15.95 Write the output from this structured query language (SQL) statement. SELECT MtNo, Name FROM BuildStock WHERE WeightKg = 75 ORDER BY PricePerBag; Complete this SQL statement to display only the names of all the materials that are out of stock. SELECT FROM WHERE Explain how another SQL statement using a different field could be used to display the same information.
9. Databases  →  9. Databases
8. Programming  →  8.1. Programming concepts
Open
12
Members of a litter picking group complete a litter pick every month. Members’ names are stored in one-dimensional (1D) array PickerName[] Each member stores the weight of the litter they have picked in another one-dimensional (1D) array PickedWeight[] The weights are in kilograms with one decimal place, for example 8.4 The position of each member’s data in the two arrays is the same. For example, the member stored at index 10 in PickerName[] and at index 10 in PickedWeight[] is the same. Every month, there is a small prize awarded to the members of the group who have the two heaviest weights. Certificates are awarded to all members with a pick weight of over three kilograms. Write a program that meets the following requirements: • allows the weight of members’ picks to be input and validated • sorts the arrays PickedWeight[] and PickerName[] in descending order of weight • outputs the member names and the pick weights of the members with the two heaviest picks and identifies them as “Best in Group” and “Second best in Group” • stores the names of all the members who will receive a certificate in the array PickerCertificate[] • outputs a message stating the number of certificates to be printed. You must use pseudocode or program code and add comments to explain how your code works. You do not need to declare any arrays or variables; you may assume that this has already been done. All inputs and outputs must contain suitable messages. You do not need to initialise the data in the array PickerName[]
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
8. Programming  →  8.1. Programming concepts
8. Programming  →  8.2. Arrays
Open