20.2. Manipulate data
A subsection of Information and Communication Technology, 0417, through 20. Spreadsheets
Listing 3 of 3 questions
Justdiscs Limited stocks many music CDs. Below is a small selection of CDs stored on their database. The data has been sorted on two fields. Number_of_tracks Year_released Price CD_title Artist_name $10.99 Let Em Ave It Giggs $9.99 Heroes Sabiton $8.99 Alright on Top Luke Slater $8.99 Humbug Arctic Monkeys $8.99 Definitely Maybe Oasis $7.99 Erasure Erasure $4.99 Cool Blues Jimmy Smith Write down the field which was used as the primary sort in the database and the order in which it was sorted. Write down the field which was used as the secondary sort in the database and the order in which it was sorted. Peter is the owner of the shop. He receives requests from customers about the CDs he has in stock. He converts these requests into search criteria using comparison and Boolean operators. For example, one customer might ask for CDs which were released after 2002 and also those that have at least 11 tracks. Peter would write this down as: Year_released > 2002 OR Number_of_tracks >= 11 Write down the search criteria for a customer who wants a list of all the CDs which were released before 2010 but only if they cost less than $8.99 Write down the names of the artists whose records match the requirements of part . [ 1 17
0417_s16_qp_11
THEORY
2016
Paper 1, Variant 1
View
A student is setting up a database of information about volcanoes for a Geography project. The following is part of the database. Name_of_volcano Country Height State Last_eruption Volcano_type Usu Japan Active Stratovolcano Tor Zawar Pakistan Dormant Fissure Datong China Extinct Cinder Cone Changbaishan China Active Stratovolcano Stromboli Italy Active Stratovolcano Tengchong China Dormant Pyroclastic cone Wudalianchi China Dormant Multi-coned Operators such as AND, OR, NOT, LIKE, >, >=, can be used to search the volcano database. The search criteria for all the dormant volcanoes with a height of less than 1000 metres would look like this: State = “Dormant” AND Height write down the names of the volcanoes that match the requirements of part . The data is sorted into ascending order of height. Write down the name of the volcano which would now be in the first record. Drones are remote-controlled flying devices. Data can be collected by drones that fly through the gas cloud of the volcano. The drones have sensors attached to them which send the data to a computer. The computer analyses the data. Discuss the benefits and drawbacks of using this method of measurement. Explain why the data collected by the sensors cannot be read directly by the computer.
0417_w18_qp_12
THEORY
2018
Paper 1, Variant 2
View
Recaud Inc. stock many CDs. Below is a small selection of CDs stored on their database. ID number Artist_name CD_title Price (Rs) Year_released Number_of_tracks Nayan Pancholi Maa Na Nayan 249.00 Nayan Pancholi, Gargi Vora Maa Amba 145.00 Lakshmi Shankar Ecstasy 120.00 Anindo Chatterjee Anindo and His Tabla 230.00 Jagjit Singh Greatest Hits 255.00 Write down the most suitable data type for the following fields. CD_title Price (Rs) Year_released Number_of_tracks Describe the range check which could be carried out on the Price (Rs) field. The maximum price and the minimum price are shown in the table above. The owner of the shop, Alam, receives requests from customers about the CDs he has in stock. He makes a note of these requests using comparison and Boolean operators. For example, a customer might ask for a CD which was released after 2002 and has at least 7 tracks. Alam would write this down as: Year_released > 2002 AND Number_of_tracks >= 7 Write down a request for a customer who wants a list of all the CDs which were released before 2007. This list must also contain all the CDs which cost at least 145 rupees. Write down the ID numbers of those records which would match your criteria in .
0417_m15_qp_12
THEORY
2015
Paper 1, Variant 2
View
Questions Discovered
3