0478_m23_qp_22
A paper of Computer Science, 0478
Questions:
11
Year:
2023
Paper:
2
Variant:
2
Login to start this paper & get access to powerful tools
2
Four descriptions and five pseudocode statements are shown. Draw one line to link each description to its most appropriate pseudocode statement. Not all pseudocode statements will be used. Description Pseudocode statement a statement to count a statement to total a statement to start a pre-condition loop a statement to start a post-condition loop FOR Count 1 TO 10 Value Value + NewValue WHILE Value > 10 DO Value Value + 1 REPEAT Write an algorithm in pseudocode, using a single loop, to output the average of 50 numbers that have been stored in the array Number[]
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
8. Programming  →  8.1. Programming concepts
Open
5
A food ordering system is an example of a computer system that is made up of sub-systems. The food ordering system: • allows the user to enter the details of the food they want to order and to pay for the order • displays food available as pictures or as a list. Complete the structure diagram for the given parts of the food ordering system. Food ordering system
3. Hardware  →  3.1. Computer architecture
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
4. Software  →  4.1. Types of software and interrupts
Open
6
The energy efficiency of an electrical appliance is the percentage of useful energy out compared with the total energy in. An algorithm has been written in pseudocode to calculate the energy efficiency of an appliance. Values for total energy in and useful energy out are input. The efficiency is calculated and output as a percentage. The entry of the number –1 for either value stops the algorithm. 01 REPEAT 02 OUTPUT "Enter total energy in " 03 INPUT TotalEnergyIn 04 OUTPUT "Enter useful energy out " 05 OUTPUT UsefulEnergyOut 06 IF TotalEnergyIn <> -1 AND UsefulEnergy <> -1 07 THEN 08 Efficiency (UsefulEnergyOut / TotalEnergyIn) * 100 09 OUTPUT "Efficiency is ", Efficiency, "%" 10 ENDIF 11 UNTIL TotalEnergyIn <> -1 OR UsefulEnergyOut <> -1 Identify the three errors in the pseudocode and suggest corrections. Error 1 Correction Error 2 Correction Error 3 Correction Write pseudocode to check for an efficiency of 92% or over for this appliance and to output “A-rated” if the efficiency is 92% or over.
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
8. Programming  →  8.1. Programming concepts
Open
8
This flowchart represents an algorithm to find the average value of a number of sales. NumberSales NumberSales + 1 NumberSales 0 Total 0 Average Total / NumberSales Total Total + SaleValue IS SaleValue = 0? INPUT SaleValue OUTPUT "Average sale value ", Average No Yes START STOP Complete the trace table using this data: 5.50, 3.40, 6.25, 3.85, –11.00, 0 NumberSales Total SaleValue Average OUTPUT Identify the error in the algorithm and describe how to correct it. Error Correction
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
Open
9
A shop that sells books has set up a new database table called BookList to store book details. Part of this table is given. CatNo Title Fiction Author PaperBack Price StockLevel BK01 The Princes’ Story Yes B Penn Yes 4.50 BK02 The Princesses’ Story Yes B Penn Yes 4.50 BK03 Computer Science No Way Yu Yes 19.99 BK04 The Modern World No P Patel No 25.00 BK05 The Ancient World Yes P Patel No 25.00 BK06 Computer Science No R Dale Yes 27.35 BK07 The Princes’ Story Yes B Penn No 12.50 BK08 The Princesses’ Story Yes B Penn No 12.50 BK12 Famous Five Yes E Bly Yes 2.75 BK15 Secret Seven Yes E Bly Yes 2.75 BK16 The Last Knight Yes P Mann Yes 5.99 BK17 The Dark Tower Yes P Mann Yes 5.99 BK19 The Final Chase Yes P Mann Yes 5.99 BK21 Maths Today Part 1 No B Ward Yes 6.75 BK22 Maths Today Part 2 No B Ward Yes 6.75 BK23 Maths Today Part 3 No B Ward Yes 6.75 BK26 Maths Today Workbook No B Ward Yes 6.75 BK27 Knitting for Beginners No A Smith Yes 6.99 BK30 Woodwork for Beginners No A Smith Yes 6.99 BK31 Networking for Beginners No A Smith Yes 6.99 State the number of records in this part of the database table. 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 each field based on the data shown in the table BookList Field Data type CatNo Title Fiction Price Write the output from this structured query language (SQL) statement. SELECT CatNo, Title, Author FROM BookList WHERE StockLevel = 0; Complete this SQL statement to display all the titles by the author B Penn. SELECT FROM WHERE ;
9. Databases  →  9. Databases
Open
10
The variables X, Y and Z are used in a program: X stores a whole number, Y stores a decimal number and Z stores a flag that can be set to TRUE or FALSE Write pseudocode statements to declare the variables X, Y and Z The function Same(A,B) returns TRUE if the value of A is the same as the value of B when B is rounded to the nearest whole number and FALSE otherwise. Write pseudocode statements to: • define the function • call the function with X and Y and store the return value in Z Function definition Function call State the difference between defining and calling a function.
8. Programming  →  8.1. Programming concepts
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
Open
11
The one-dimensional (1D) array TeamName[] contains the names of teams in a sports league. The two-dimensional (2D) array TeamPoints[] contains the points awarded for each match. The position of each team’s data in the two arrays is the same. For example, the team stored at index 10 in TeamName[] and TeamPoints[] is the same. The variable LeagueSize contains the number of teams in the league. The variable MatchNo contains the number of matches played. All teams have played the same number of matches. The arrays and variables have already been set up and the data stored. Each match can be played at home or away. Points are recorded for the match results of each team with the following values: • 3 – away win • 2 – home win • 1 – drawn match • 0 – lost match. Write a program that meets the following requirements: • calculates the total points for all matches played for each team • counts the total number of away wins, home wins, drawn matches and lost matches for each team • outputs for each team: – name – total points – total number of away wins, home wins, drawn matches and lost matches • finds and outputs the name of the team with the highest total points • finds and outputs the name of the team with the lowest total points. You must use pseudocode or program code and add comments to explain how your code works. You do not need to declare any arrays, variables or constants; 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 arrays TeamName[] and TeamPoints[] or the variables LeagueSize and MatchNo
8. Programming  →  8.2. Arrays
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
8. Programming  →  8.1. Programming concepts
Open