9626_w17_qp_11
A paper of Information Technology, 9626
Questions:
11
Year:
2017
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
1
Tick the most accurate statement about the use of a compiler. P A compiler executes a high-level program one statement at a time before translating the next statement. A compiler converts object code into source code. A compiler translates machine code into a high-level language program. A compiler often produces a separate object code program. Tick the most accurate statement about the use of a linker. P A linker executes a high-level program one statement at a time before translating the next statement. A linker takes one or more source code files and combines them into a single executable file. A linker takes one or more object files and combines them into a single executable file. A linker is used in conjunction with an interpreter.
2. Hardware and software  →  2.2. System software
Open
2
Many schools want IT departments to introduce lessons emphasising aspects of e-safety. Tick four of the following statements which offer good advice. P It is alright to send an email to a person you do not know as it does not matter if they find out your email address. You should always attach a photograph of yourself to an email so they know who you are. You should only use websites recommended by teachers. It is acceptable to post a photograph of your school on a social media site as so many students go there. You should always think twice before opening an email from an unknown person as it might be spam. It is okay, for the first time, to meet a person you only know from the internet on your own. You should know how to block and report unwanted users from social media sites. It is acceptable, if you trust them, to give someone you have only met on the internet your name and address. When using instant messaging it is okay to use bad language if you are among friends. When playing games on the internet you should never use your real name.
12. IT in society  →  12.4. The impact of IT
5. eSecurity  →  5.1. Personal data
Open
3
A health inspector, Josefine, is investigating the health of students. She wishes to study the effect on them of traffic on roads passing close to the school. One road seems to be causing more problems than others. She is going to collect data regarding the amount of traffic and its effect on their health. Describe, with specific reference to the investigation, how she could gather data from direct data sources. Describe the drawbacks of gathering data from direct data sources. Give reasons why the information that Josefine collects may be inaccurate. The school’s students have collected data about cars for a maths project. The teacher has decided to code the data. Here is some of the data. The codes he will use are in brackets. Colour Make Male or female driver Approximate age of driver Light blue (B) Frod (F) Male (M) 50–59 (50) Green (G) Olep (O) Female (F) 30–39 (30) Dark blue (B) Vagen (Female (F) 20–29 (20) Give three reasons why the teacher is planning to code the data. Give three reasons why the IT teacher has warned against some of the coding the maths teacher plans to use.
1. Data processing and information  →  1.1. Data and information
Open
4
Jasvinder has just become manager of the ticketing department in an airport. Part of her job is to provide tickets for passengers who have decided to fly at the last minute. She uses computers to produce the tickets. She also has to produce hard copy of the details of every flight, including passenger names, prior to each flight. Evaluate the output devices which Jasvinder might use, including their specific use in this system.
16. System life cycle  →  16.3. Design
16. System life cycle  →  16.7. Evaluation
Open
5
Below is an extract from a spreadsheet showing details of one day’s train journeys between London and Paris. A hyphen, ‘-’, in a cell indicates that the train does not stop at that station. I J K L M N LONDON St Pancras Intl PARIS Gare du Nord EBBSFLEET International ASHFORD International Train No. 05:40 05:58 06:24 09:17 09:47 10:17 11:17 11:47 12:47 13:17 13:47 14:17 14:47 15:17 15:47 16:47 17:17 17:47 18:47 19:17 19:47 06:55 09:55 16:55 Number of non-stop trains 08:12 08:38 09:34 10:42 12:42 06:18 07:01 07:55 08:19 09:17 10:01 10:24 11:01 11:31 12:01 12:24 13:31 14:01 14:31 15:31 16:01 16:22 – – – – – – – – – – – – – – – – – – – – – – – – – – Michelle, the train controller in London, wants to use this spreadsheet to count the number of trains that do not stop at any station between London and Paris. Write down the formula which should go in cell M22 to give her this information. = You can use the space below for any working you need. Describe the steps that Michelle would need to carry out if she wanted to print out the Train No. of the trains that do not stop at any station between London and Paris.
8. Spreadsheets  →  8.1. Creating a spreadsheet
8. Spreadsheets  →  8.3. Using a spreadsheet
Open
6
Below is an extract from a company’s database which shows the details of their factory workers. Workers_Id Cisse Traore Dia Kone Diop Fall Contee Keita Gallo Diallo Koulthum Adama Omar Mame Souleymane Leo Henry Sundiata Jerry Noumu Extrusion Cold rolling Cold rolling Tube production Tube production Extrusion Extrusion Foundry Foundry Hot rolling Family_Name First_Name Department Salary $43,000.00 $35,000.00 $39,000.00 $34,500.00 $32,000.00 $37,500.00 $36,000.00 $29,000.00 $41,500.00 $28,500.00 Describe the steps you would use to create a report containing the Workers_Id number and Salary only, using the most efficient method to extract all the Hot rolling or Cold rolling workers whose salary is greater than $35,000.
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
8
A college keeps records of its A Level students and the subjects they study in a database. It has the following tables: Students’ names Students’ other personal data Details of when they started studying the subject All the possible subjects which can be taken by A Level students. These tables are linked as shown below. students_2 Student_ID Phone_number Address Date_of_birth students_1 Student_ID First_name Last_name joined_subject Student_ID Subject_code Date_joined subjects Subject_code Subject_name Subject_description Using examples from the tables shown above or otherwise: Describe the three relationships: one-to-one one-to-many many-to-many Define ‘referential integrity’ and explain why it is so important.
10. Database and file concepts  →  10.1. Creating a database
Open