2210_s24_qp_22
A paper of Computer Science, 2210
Questions:
11
Year:
2024
Paper:
2
Variant:
2
Login to start this paper & get access to powerful tools
4
A program needs to make sure the characters input for a product code meet these rules: • The product code is six characters in length. • The first two characters must be “PD”. • The last four characters must be a number in the range 1000 to 9999 inclusive. Identify three validation checks and state how each check would make sure the product code met one of these rules. Check 1 Check 2 Check 3 The program design will include a pseudocode algorithm. Assume that the product code is stored in the variable Product Write the pseudocode to make sure that the product code is six characters in length. Write the pseudocode to make sure that the first two characters of the product code are “PD”.
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
2. Data transmission  →  2.2. Methods of error detection
Open
6
Totalling and counting are standard methods of solution. Numbers are input. The number 9999.9 is the last number to be input and is ignored. Write an algorithm in pseudocode to total the numbers input and to output the total. You do not need to validate the input. Write an algorithm in pseudocode to count and output the number of input values that are greater than 100. You do not need to validate the input.
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
8. Programming  →  8.1. Programming concepts
Open
7
An algorithm has been written in pseudocode to find and display the maximum and minimum values in an array of 1000 positive numbers. The array List[] starts at index 1 01 Max List 02 Min List 03 FOR Counter 2 TO 1000 04 IF List[Counter] Selection statement Iteration statement Identify the line numbers of the three errors in the pseudocode and suggest a correction for each error. Error 1 line number Correction Error 2 line number Correction Error 3 line number Correction
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
8. Programming  →  8.1. Programming concepts
Open
9
This flowchart represents an algorithm. A FALSE B 1 IS List[B] > List[B + 1]? T List[B] START No STOP List[B] List[B + 1] List[B + 1] T A TRUE B B + 1 IS B = 5? IS A = TRUE? Yes Yes Yes No No The array List[1:5] used in the flowchart contains this data: List List List List List Complete the trace table using the data given in the array. A B List List List List List T Describe what the algorithm represented by the flowchart is doing.
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
Open
10
A television subscription service has a new database table named Contract to store details of their subscribers’ contracts. The table contains these fields: • ContractNumber – the contract number, for example CT567 • Months – the length of the contract in months, for example 6 • EndDate – the date the contract finishes, for example 30 November 2024 • News – the news service, yes or no • Movie – the movie service, yes or no • Sport – the sports service, yes or no • Junior – the children’s service, yes or no. Identify the field that will be the most appropriate primary key for this table. Complete the table to identify the most appropriate data type for these fields in Contract Field Data type ContractNumber Months EndDate Sport Explain the purpose of these structured query language (SQL) statements. Statement 1: SELECT SUM (Months) FROM Contract; Statement 2: SELECT COUNT (News) FROM Contract WHERE News; Statement 1 Statement 2 Complete this SQL statement to find the contract numbers of the subscribers that take both the news and sports services. SELECT FROM Contract WHERE AND ;
9. Databases  →  9. Databases
Open
11
A one-player game uses the two-dimensional (2D) array Grid[] to store the location of a secret cell to be found by the player in 10 moves. Each row and column has 5 cells. Start Grid[1,1] At the start of the game: • The program places an ‘X’ in a random cell (not in Grid[1,1]) and empties all the other cells in the grid. • The player starts at the top left of the grid. • The player has 10 moves. During the game: • The player can move left, right, up or down by one cell and the move must be within the grid. • “You Win” is displayed if the player moves to the cell with ‘X’ and has played 10 moves or less. • “You Lose” is displayed if the player has made 10 moves without finding the ‘X’. Write a program that meets these requirements. 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.
8. Programming  →  8.1. Programming concepts
Open