2210_w23_qp_23
A paper of Computer Science, 2210
Questions:
10
Year:
2023
Paper:
2
Variant:
3
Login to start this paper & get access to powerful tools
3
Four pseudocode descriptions and five pseudocode keywords are shown. Draw one line to link each pseudocode description to the most appropriate pseudocode keyword. Not all pseudocode keywords will be used. Pseudocode description Pseudocode keyword Give two reasons for storing data in a file. stores data in a file retrieves data from a file displays data on a screen enters data from a keyboard OUTPUT WRITE READ OPEN INPUT
8. Programming  →  8.3. File handling
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
Open
4
A programmer is writing a data entry program for booking theatre seats. The programmer needs the program to accept only whole numbers that are greater than or equal to one and less than or equal to six. Give the names of two validation checks that are required for this program. Complete this pseudocode to perform your two validation checks, using your answers given in : OUTPUT "Please enter the number of seats you want to book " INPUT Seats Give one item of test data to use when testing this program. State the reason for your choice of test data. Test data Reason for choice
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
8. Programming  →  8.1. Programming concepts
Open
5
An algorithm has been written in pseudocode to check if a new password is in a list of previously used passwords OldList[] If the password is not found, the new password will be stored at the end of the list to replace "XXXX" already stored there. 01 OUTPUT "Enter your new password " 02 INPUT NewPassword 03 Posn 04 Found FALSE 05 REPEAT 06 IF Password = OldList[Posn] 07 THEN 08 Found TRUE 09 ELSE Posn Posn + 1 10 ENDIF 11 UNTIL Found AND OldList[Posn] = "XXXX" 12 IF Found 13 THEN 14 OUTPUT "Password has been used before" 15 ELSE 16 INPUT "New password accepted" 17 OldList[Posn] NewPassword 18 ENDIF Identify the three errors in the pseudocode and suggest corrections. Error 1 Correction Error 2 Correction Error 3 Correction Complete this flowchart for the corrected algorithm: START STOP
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
8. Programming  →  8.1. Programming concepts
Open
6
There are three descriptions of logic gates. Each logic gate has two inputs A and B with one output X. Identify each logic gate. Complete a truth table for each logic gate. The only time the output is 1 is when both inputs are 1. Logic gate Complete the truth table for this description. The output is 1 when both inputs are different. Logic gate Complete the truth table for this description. The only time the output is 1 is when both inputs are 0. Logic gate Complete the truth table for this description. A B X A B X A B X Consider this logic expression: X = (NOT A OR NOT B) OR NOT C Draw a logic circuit for this logic expression. Each logic gate must have a maximum of two inputs. Do not attempt to simplify this logic expression. X B A C
10. Boolean logic  →  10. Boolean logic
Open
8
This is an algorithm to find if a batch of parts has been manufactured successfully. Accept INPUT PartOK IS PartOK = 'Y'? IS Accept = 10 ? IS Reject > 1 ? Accept OUTPUT "Too many rejected ", Error, "% error" OUTPUT "Success" Accept + 1 Reject Reject Reject + 1 Error Reject/Accept * 100 Yes Yes Yes No No No START STOP Complete the trace table using this data: Y, Y, Y, N, Y, Y, Y, Y, N, Y, Y, Y, Y Accept Reject PartOK Error OUTPUT Describe how the algorithm should be changed to accept ‘Y’ or ‘y’ for a successfully manufactured part.
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
Open
9
A sanctuary for pheasants has set up a new database table called PheasantList to store details of the different species of bird at the sanctuary. Part of this table is given, showing: species, description, number of birds at the sanctuary, if the birds are breeding or not, and number of young born this year. Species Description NumberBirds Breeding Young Edwards blue-black with white tail Yes Japanese green dark green with pale grey tail Yes Reeves golden, white and red scaled plumage Yes Crawfords Kalij glossy blue-black plumage No Crested fireback blue-black with black tail No True silver white laced top half and black lower half Yes Siamese fireback grey plumage with crimson legs and feet No Mikado iridescent plumage with white striped wings Yes Red junglefowl many colours Yes Himalayan monal many colours with metallic green crest Yes White eared white with ear tufts Yes Brown eared brown with ear tufts Yes Ring necked long tail with white ring neck Yes Golden rainbow coloured Yes State the number of records and fields in this part of the database table. Records Fields Give the name of a field that could be used for the primary key. Explain why the sanctuary might decide not to use the field in as the primary key. A new field SpeciesID is added to the database table. This field contains a six-character code, for example Ph0001. Give a reason why this field would be a better primary key. Write the output that would be given by this structured query language (SQL) statement: SELECT Species, Description FROM PheasantList WHERE NumberBirds > 6; Complete this SQL statement to display all the species of pheasant where the birds are breeding and there were no young born this year: SELECT FROM WHERE ;
9. Databases  →  9. Databases
8. Programming  →  8.1. Programming concepts
Open
10
A weather station takes temperature readings once an hour for a week. These temperatures are stored in a two-dimensional (2D) array Temperatures[] Each column contains 24 readings for a single day. The first temperature is recorded at 00:00 and the final temperature at 23:00. There are seven columns, one for each day of the week, starting with Monday and ending with Sunday. The variables MaxDay, MinDay and AvDay are used to store the maximum, minimum, and average temperatures for a day. The variables MaxWeek, MinWeek and AvWeek are used to store the maximum, minimum, and average temperatures for the week. The array has already been set up and the data stored. Write a program that meets the following requirements: • finds the maximum and minimum temperatures for each day • calculates the average temperature for each day • outputs for each day: – name of the day, for example Monday – maximum temperature – minimum temperature – average temperature • finds the maximum and minimum temperatures for the week • calculates the average temperature for the week • outputs: – maximum temperature for the week – minimum temperature for the week – average temperature for the week. All temperatures output must be rounded to two decimal places. You must use pseudocode or program code and add comments to explain how your code works. All inputs and outputs must contain suitable messages. You do not need to declare any arrays or variables; you may assume that this has already been done. You do not need to initialise the data in the array Temperatures[]
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
8. Programming  →  8.2. Arrays
Open