1. Data processing and information
A section of Information Technology, 9626
Listing 10 of 132 questions
All the exams taken in a school are marked out of 80. The school has introduced a system of marking where students are awarded 5 marks for just sitting the exam and then, as normal, are awarded further marks for correct answers. The marks are stored in a spreadsheet and validated using a range check. Describe, giving examples, three types of test data that could be used to test the range check. For each type of data, describe an improvement that might be necessary as a result of the testing.
9626_w21_qp_13
THEORY
2021
Paper 1, Variant 3
View
The owner of a book shop has created a database of her books. She will now test that it works. Some of the records are shown. The data shown contains the maximum and minimum values. There are only two types of book. ISBN Title Author Book_type Copies H P H P H Lee Child Isaac Asimov Dan Brown James Patterson David Baldacci Blue Moon Prelude to Foundation Inferno Revenge One Good Deed Describe, in detail, the three most appropriate validation checks, apart from a check digit, type check or presence check, that could be used to validate the data. For each validation check, your description should include the field it could be used for. Each validation check and each field must be different. The owner will also need to verify the data in her database. Using examples from the three fields you used in part , explain why verification is needed in addition to validation.
9626_w22_qp_12
THEORY
2022
Paper 1, Variant 2
View
A company secretary is creating a new database of workers to record: • their six digit ID number • the date they joined the company • their rate of pay per hour up to a maximum rate of $50 per hour. She has entered data from a source document into the database. There was an error in record 3 and an error in record 4 in the source document. The secretary also made an error when copying record 1. Source document Database Record ID number Date joined Rate of pay ID_number Date_joined Rate_of_ pay 13/06/2019 13/06/2020 09/10/2019 09/10/2019 15/08/2020 15/08/2020 23/12/2020 23/12/2020 27/07/2021 27/07/2021 Using this data, explain, in detail, the need for verification and validation when entering data into a database.
9626_w23_qp_12
THEORY
2023
Paper 1, Variant 2
View
A bank stores a database of all its customers. The first field in the database is the account number. The account numbers are different for each customer and consist of 10 digits, for example 7382690643. New accounts are opened in branches of the bank on a regular daily basis. Describe three errors that a person entering the account numbers of new customers might make. For each one describe an appropriate validation check that would trap the error. A range check or limit check would not be suitable. Each validation check must be different. Error 1 Validation check 1 Error 2 Validation check 2 Error 3 Validation check 3 When customers open new accounts, the details are gathered together in a transaction file. At the end of the day a branch transmits the transaction file to head office, using the internet. The transmission of the transaction file is verified using a hash total. Describe this process, explaining why a hash total is used rather than a control total.
9626_w23_qp_13
THEORY
2023
Paper 1, Variant 3
View
Here is a section of a database showing the wages paid and hours worked by some workers in a company. New data is about to be entered but it will need to be validated. Validation rules will need to be created to make sure the data is sensible. Two validation rules would be appropriate for the Telephone field and one for the Weekly wage field. You can assume the wages shown include the minimum and maximum that the company pays. Smith Prudhomme Gonzales Signusson Thorsvald Mueller Lucio Boko Ndlovu James Gordon McDonnell Kelly Family name J215VENUES First name Telephone Weekly wage Hours worked John Pierre Jose Lars Olaf Dieter Silvio Peter Joseph Peter James Jamie Peter 01632 267145 01632 342016 01632 941368 01632 643821 01632 811276 01632 351156 01632 281146 01632 444707 01632 319249 01632 860787 01632 205775 01632 430332 01632 832287 Describe, using examples from the data shown, the validation rules that will be created. For each one, give examples of test data (do not include normal data) that would test the validation rule works and give reasons for each choice. Telephone: Validation rule 1 Test data Reason Validation rule 2 Test data Reason Weekly wage: Validation rule Test data Reason Select an appropriate data type for the Telephone field, explaining why you have chosen it. The data from this section of the database has been imported into a spreadsheet. This is because the manager wants to calculate the average wage earned by the workers who work more than 40 hours a week but less than 50 hours a week. Smith Prudhomme Gonzales Signusson Thorsvald Mueller Lucio Boko Ndlovu James Gordon McDonnell Kelly A B C D E F Family name First name Telephone Weekly wage Hours worked John Pierre Jose Lars Olaf Dieter Silvio Peter Joseph Peter James Jamie Peter 01632 267145 01632 342016 01632 941368 01632 643821 01632 811276 01632 351156 01632 281146 01632 444707 01632 319249 01632 860787 01632 205775 01632 430332 01632 832287 Average Write down the formula which should go in cell D16. = You may use the space below for any working out. Describe how the spreadsheet could be sorted so that Dieter Mueller is the first worker in the list and Pierre Prudhomme is the seventh. The manager has decided that the name fields should be combined. He wants a name field containing the first name initial and the family name. Write down the formula that would give Jamie McDonnell’s name as J McDonnell. = You may use the space below for any working out.
9626_s18_qp_13
THEORY
2018
Paper 1, Variant 3
View
A new app has been created for smartphones, but is unreliable due to some unknown coding errors. A group of testers has been asked to locate the errors and suggest, in a report, corrections that should be made to the code before the app is ready for sale. The testers have been given a list of milestones to record their progress. These are shown: Milestones to be reached: Check that the plan will solve the unreliability issue. Create a plan to correct the code. Create a theory as to which lines/areas/blocks/sections of code are causing the unreliability. Document the results of the testing in a report. Download and install app on the smartphone. Identify the problem with the code by running the app. Suggest corrections that could correct the unreliability. Test the suggested corrections. Test the theory to see if the unreliability can be replicated elsewhere. List, by writing the number of the milestone, the order in which these milestones should be reached by the testers.
9626_w19_qp_32
THEORY
2019
Paper 3, Variant 2
View
Questions Discovered
132