9626_m18_qp_12
A paper of Information Technology, 9626
Questions:
14
Year:
2018
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
1
Tick the four most accurate statements regarding knowledge, data and information. ✓ Knowledge is remembering a set of facts. 5, 10, 15, 20 are examples of information. Knowledge is just learning items of data by rote. Knowledge never requires the understanding of information. Knowledge is the use of information to solve problems. Information is data that needs to be processed to give it meaning. Understanding that 25 is the fifth answer in the five times table requires knowledge. Tacit knowledge is knowledge that is easy to pass on to someone else. A list of all the books written by Shakespeare is just raw data. Being aware that Pride and Prejudice was not written by Shakespeare requires knowledge.
1. Data processing and information  →  1.1. Data and information
17. Data Analysis and Visualisation  →  17.1. Data Analysis and Visualisation
Open
2
Tick the four most accurate statements regarding encryption protocols. ✓ None of the web browsers currently in use support TLS. SSL stands for Secure Socket Layer. TLS was used before SSL came into being. TLS and SSL are protocols that provide security of communication in a network. SSL uses asymmetric cryptography only. Encryption protocols prevent hackers from intercepting a message. TLS stands for Transport Layer Socket. Client-server applications use TLS in a network to try to prevent eavesdropping. Encryption protocols enable credit card payments to be made securely. SSL does not require a handshake to be carried out.
1. Data processing and information  →  1.3. Encryption
Open
6
Jasvir works in a town in the south of India. He uses email to stay in contact with his parents who live in the north. Apart from email and video conferencing, describe four other ways he could use the internet to communicate with his parents, giving a different drawback for each method. Way 1 Drawback Way 2 Drawback Way 3 Drawback Way 4 Drawback
16. System life cycle  →  16.5. Implementation
14. Communications technology  →  14.5. Data transmission across networks
14. Communications technology  →  14.1. Networks
Open
8
Jagwant has typed data into a spreadsheet. Part of the spreadsheet is shown below. For each column, explain in detail why the data is not fully visible, and describe the most efficient way he could use to make all the data fully visible by only using the mouse. jasvinder william joseph j A B C D ########### ########### ########### C1 ⁝ fx ✘ 4.678932156 4.678932 5.986433 7.325689
8. Spreadsheets  →  8.3. Using a spreadsheet
17. Data Analysis and Visualisation  →  17.1. Data Analysis and Visualisation
8. Spreadsheets  →  8.1. Creating a spreadsheet
Open
10
A clothing manufacturer uses codes to store information about its clothes. For example, a pair of blue trousers with a waist of 80 cm and a leg length of 77 cm could be coded as BT8077. Explain what each part of the code GT8878 could mean and why there may be problems with coding other items of clothing in this way. Include in your explanation ways of improving this method.
4. Algorithms and flowcharts  →  4.1. Algorithms
1. Data processing and information  →  1.5. Data processing
16. System life cycle  →  16.5. Implementation
Open
12
Below are two tables from a college database. A relationship links the two tables. Studentid F1278 F3794 F4921 F9153 Phone First_name Ravinder Avtar Shokat Ravinder Coursecode P301 F402 B115 B115 Coursecode Courses Students P301 E402 B115 M301 Course_Title Physics English Biology Maths Explain which fields would be set for primary keys, a compound key and a foreign key, giving reasons for each choice. A list is required of all the students studying Biology. Write down the steps you would need to take to produce this list using the Students table only. You may assume the database is already open.
10. Database and file concepts  →  10.1. Creating a database
Open
13
Sachin has typed in three dates in column A in the spreadsheet shown below. He has used the formula =TEXT(A1,"dd mmmm yyyy") in C1 and replicated it down. He has used another formula in column E to extract the name of the month from C1. Write down the formula he used in E1 which he then replicated down to E3 to extract the months shown. 03/11/2017 26/09/2017 03/06/2017 03 November 2017 26 September 2017 03 June 2017 November September June A B C D E = You can use the space below for any working out.
8. Spreadsheets  →  8.1. Creating a spreadsheet
8. Spreadsheets  →  8.3. Using a spreadsheet
Open