0478/21 · May/June 2023
Download PDFFour descriptions of stages in the program development life cycle are shown. Draw one line to link each description to its most appropriate program development life cycle stage. Not all program development life cycle stages will be used.
Identify three of the component parts after a problem has been decomposed. 1 ................................................................................................................................................ ................................................................................................................................................... 2 ................................................................................................................................................ ................................................................................................................................................... 3 ................................................................................................................................................ ...................................................................................................................................................
Describe what is meant by data validation.
A validation check is used to make sure that any value that is input is an integer between 30 and 200 inclusive. Give one example of each type of test data to check that the validation check is working as intended. Each example of test data must be different. Give a reason for each of your choices of test data. Normal test data ....................................................................................................................... Reason ..................................................................................................................................... ................................................................................................................................................... Abnormal test data ................................................................................................................... Reason ..................................................................................................................................... ................................................................................................................................................... Extreme test data ..................................................................................................................... Reason ..................................................................................................................................... ...................................................................................................................................................
Explain the purpose of the library routines DIV and ROUND DIV ................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ROUND .............................................................................................................................................. .......................................................................................................................................................... .......................................................................................................................................................... ..........................................................................................................................................................
An algorithm has been written in pseudocode to allow some numbers to be input. All the positive numbers that are input are totalled and this total is output at the end. An input of 0 stops the algorithm. 01 Exit ← 1 02 WHILE Exit <> 0 DO 03 INPUT Number 04 IF Number < 0 05 THEN 06 Total ← Total + Number 07 ELSE 08 IF Number = 0 09 THEN 10 Exit ← 1 11 ENDIF 12 ENDIF 13 ENDIF 14 OUTPUT "The total value of your numbers is ", Number
Identify the four errors in the pseudocode and suggest a correction for each error. Error 1 ....................................................................................................................................... Correction ................................................................................................................................. ................................................................................................................................................... Error 2 ....................................................................................................................................... Correction ................................................................................................................................. ................................................................................................................................................... Error 3 ....................................................................................................................................... Correction ................................................................................................................................. ................................................................................................................................................... Error 4 ....................................................................................................................................... Correction ................................................................................................................................. ...................................................................................................................................................
Describe how you could change the corrected algorithm to record and output how many positive numbers have been included in the final total. You do not need to rewrite the algorithm.
State two features that should be included to create a maintainable program. Give a reason why each feature should be used. 1 ....................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... 2 ....................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ..........................................................................................................................................................
The flowchart represents an algorithm. The table represents the two-dimensional (2D) array Word[] which stores the first half of the phonetic alphabet used for radio transmission. For example, Word[10,1] is 'J'.
| Index | 1 | 2 |
|---|---|---|
| 1 | A | Alpha |
| 2 | B | Bravo |
| 3 | C | Charlie |
| 4 | D | Delta |
| 5 | E | Echo |
| 6 | F | Foxtrot |
| 7 | G | Golf |
| 8 | H | Hotel |
| 9 | I | India |
| 10 | J | Juliet |
| 11 | K | Kilo |
| 12 | L | Lima |
| 13 | M | Mike |
Complete the trace table for the algorithm by using the input data: F, Y, D, N
Identify the type of algorithm used.
Describe one problem that could occur with this algorithm if an invalid character was input.
The function LENGTH(Phrase) calculates the length of a string Phrase
Write the pseudocode statements to: • store the string "The beginning is the most important part" in Phrase • calculate and output the length of the string • output the string in upper case.
Write the output your pseudocode should produce.
Consider this logic expression.
Draw a logic circuit for this logic expression. Each logic gate must have a maximum of two inputs. Do not simplify this logic expression.
Complete the truth table from the given logic expression.
A database table called TVRange shows the main features and prices of a range of televisions.
Give the name of the field that is most suitable to be the primary key. State the reason for this choice. Field .......................................................................................................................................... Reason ..................................................................................................................................... ...................................................................................................................................................
The database uses the data types: • text • character • Boolean • integer • real • date/time. Complete the table to show the most appropriate data type for each field. Each data type must be different.
Complete the structured query language (SQL) query to return the television (TV) code, screen size and price of all Smart TVs in the database table. SELECT TVCode, ......................................................., ....................................................... ....................................................... TVRange WHERE SmartTV = .......................................................;
A one-dimensional (1D) array Days[] contains the names of the days of the week. A two-dimensional (2D) array Readings[] is used to store 24 temperature readings, taken once an hour, for each of the seven days of the week. A 1D array AverageTemp[] is used to store the average temperature for each day of the week. The position of any day’s data is the same in all three arrays. For example, if Wednesday is in index 4 of Days[], Wednesday’s temperature readings are in index 4 of Readings[] and Wednesday’s average temperature is in index 4 of AverageTemp[] The temperature readings are in Celsius to one decimal place. Temperatures can only be from –20.0°C to +50.0°C inclusive. Write a program that meets the following requirements: • input and validate the hourly temperatures for one week • calculate and store the average temperature for each day of the week • calculate the average temperature for the whole week • convert all the average temperatures from Celsius to Fahrenheit by using the formula Fahrenheit = Celsius * 9/5 + 32 • output the average temperature in Celsius and in Fahrenheit for each day • output the overall average temperature in Celsius and in Fahrenheit for the whole week. 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. All data output must be rounded to one decimal place. You will need to initialise and populate the array Days[] at the start of the program.