18.3. Present data
A subsection of Information and Communication Technology, 0417, through 18. Databases
Listing 6 of 6 questions
Many database software packages have a report generation feature. The following is part of a video hire shop database showing films available in Blu-ray format. Film_name Director Price ($) Regions Length Rush Ron Howard 12.99 A Last Vegas Jon Turtletaub 17.72 B Captain Phillips Paul Greengrass 14.99 Free Saving Mr Banks John Lee Hancock 15.00 C Each of the following fields contains data that is numeric. Give a more precise data type for each of these fields. Price Length Blu-ray discs have one of three region codes or are region-free. Describe how the field Regions could be set up to reduce the possibility of inaccurate data entry. Describe, in detail, how you would create a formatted report which does not show regions and only shows films which are longer than 110 minutes.
0417_w15_qp_12
THEORY
2015
Paper 1, Variant 2
View
A school is planning to change the way it reports back to parents about their child’s academic progress. They plan to produce a mail merged document and then email this to parents. They have created a spreadsheet which shows the pupil’s name, target, attainment and effort levels for Maths and the Science subjects. Part of the spreadsheet is shown. A B C D E F Name Target level Maths Attainment Effort Attainment Effort Attainment Effort Attainment Effort Biology Chemistry Physics Ahmal Wulandan Nurul Prakoso G H I J K Design a suitable document layout to display the information of one pupil. The name of the pupil must be clearly shown separated from the rest of the data. It must have appropriate spacing. Do not include the pupil’s data. The attainment levels range from 1 to 9 and the effort levels range from 1 to 3. Before teachers are allowed to enter data, the spreadsheet needs to be tested. Write down one example of extreme data to test the attainment field and one example of abnormal data to test the effort field. Attainment – extreme data Effort – abnormal data Describe four advantages of using a mail merge for this document. When the mail merge is created, a special field containing the date needs to be added. This date will change automatically each time the merged document is sent or printed. Explain how the date field can be added.
0417_w21_qp_12
THEORY
2021
Paper 1, Variant 2
View
Questions Discovered
6