Free until 14 Nov · 80% off for the first 100 · Pricing

Get started

Information Technology 9626/11 May/June 2019: question paper and mark scheme

Cambridge AS & A Level Information Technology (9626), Paper 1 Theory, May/June 2019. Read both free below, or download them. Done the paper? Get it marked by AI against this mark scheme.

9626_s19_qp_119626_s19_ms_119626/11/M/J/19

Mark my answers with AIRead the paper and scheme
Paper
Paper 1 Theory
Total marks
90
Time
1 hour 45 minutes
Code on the paper
9626/11/M/J/19
9626_s19_ms_11.pdf

9626/11 mark scheme, question by question

Each question as it's printed, and the mark scheme's points for it, as text. Diagrams, tables and graphs are in the PDFs above.

Question 14 marks

Question

The coding of data refers to using M for male and F for female, for example. Tick the four most accurate statements regarding the coding of data. ✓ Data becomes easier to interpret Coding of value judgements is always very accurate The coding of data saves storage space Codes cannot be used in a relational database It speeds up data entry All data can be coded There are fewer mistakes when entering data Codes are not too complicated so there are never any errors on data entry Validation is easier to perform on data Coded data makes the computer slower when searching for data [4]

Mark scheme

1 4 Data becomes easier to interpret Coding of value judgements is always very accurate The coding of data saves storage space 3 Codes cannot be used in a relational database It speeds up data entry 3 All data can be coded There are fewer mistakes when entering data 3 Codes are not too complicated so there are never any errors on data entry Validation is easier to perform on data 3 Coded data makes the computer slower when searching for data

Question 24 marks

Question

The management of a hotel is introducing a computer system for producing bills for their customers. They are considering which type of printer to use. Tick the four most accurate statements regarding different types of printer, if used in the hotel reception area. ✓ Laser printers produce very high quality output A dot matrix printer would produce higher quality output than an inkjet printer An inkjet printer would be slower at producing output than a dot matrix printer Dot matrix printers use continuous stationery Dot matrix printers need the ink cartridge changing more frequently than inkjet printers Dot matrix printers are very quiet which is important in a hotel reception area A laser printer can operate in harsh conditions, unlike a dot matrix printer A laser printer toner cartridge is more expensive to buy than an inkjet cartridge Multi-part stationery is easier to use with laser printers than with dot matrix printers Inkjet printers are cheaper to buy than dot matrix printers [4]

Mark scheme

2 4 Laser printers produce very high quality output 3 A dot matrix printer would produce higher quality output than an inkjet printer An inkjet printer would be slower at producing output than a dot matrix printer Dot matrix printers use continuous stationery 3 Dot matrix printers need the ink cartridge changed more frequently than inkjet printers Dot matrix printers are very quiet which is important in a hotel reception area A laser printer can operate in harsh conditions unlike a dot matrix printer A laser printer toner cartridge is more expensive to buy than an 3 inkjet cartridge Multi-part stationery is easier to use with laser printers than with dot matrix printers Inkjet printers are cheaper to buy than dot matrix printers 3

Question 36 marks

Question

Items of data could be the following: 45612, fred, π, £, ≥ or Explain, by describing what is meant by information, why these are just items of data. ……[6]

Mark scheme

3 Six from: 6 Data on its own has no meaning Only when it is interpreted does data take on meaning and become information Data consists of raw facts and figures Data has to be processed (into sets) to become information Data needs to have a context in order to become information Data can be in the form of numbers, characters, symbols, images as shown in the example (must have three) Information is what you get after a piece of data is processed and organised and is easily interpretable unlike the examples given Marks are available for explained examples of how data becomes information

Question 46 marks

Question

Most schools have introduced e-safety lessons because teachers are becoming concerned about the way their students use the internet when not in school. One of their concerns is that students may be revealing personal information about themselves. Describe the problems associated with this and other problems that arise from students using the internet. ……[6]

Mark scheme

4 Six from: 6 Unauthorised access to personal information The risk of being subject to grooming by those with whom they make contact on the internet The sharing / distribution of personal images without an individual’s consent or knowledge Inappropriate communication / contact with others, including strangers Cyber-bullying by fellow students Other problems Access to unsuitable video / internet games An inability to evaluate the quality, accuracy and relevance of information on the internet Plagiarism and copyright infringement Illegal downloading of music or video files giving rise to the potential for excessive use which may affect the social and emotional development and learning of the student Access to illegal, harmful or inappropriate images or other content Must have at least two of each to gain full marks

Question 56 marks

Question

Many companies with different branches have Local Area Networks (LANs) which connect to form a Wide Area Network (WAN). Compare and contrast the characteristics of a LAN and a WAN owned by one company. ……[6]

Mark scheme

5 Six from: 6 Both are used to connect computers together providing all the advantages of a computer network Both can be connected using copper cable or fibre optic cable Both are used to share files Data transfer rates are faster within a LAN Data transmission errors are fewer within a LAN WANs cover a larger geographical area than a LAN LAN can be more secure as can be confined to one building and not connected to outside users/hackers As WANs tend to consist of more complex systems so they are less fault tolerant LAN shares the information needed by each branch whereas WAN shares the information needed by all branches Must have at least one difference and one similarity to gain full marks

Question 65 marks

Question

Louis has partly typed up the notes from his IT lesson. He wants to complete these at home. Sophia, a fellow student, tells him that it may be difficult as he has been using proprietary software. Explain what is meant by proprietary and open-source file formats, giving reasons why open-source file formats are needed. ……[5]

Mark scheme

6 Five from: 5 Open source formats are often called free file formats if they are not covered by any copyrights/patents Open file formats can be used by both proprietary and open source software A proprietary file format has been created by a software company using a particular encoding scheme... ...designed by the company such that the decoding of this stored data is only easily done with software that the company itself has developed The specification of the data encoding format is usually kept secret only the company itself/ users with licences may use it Open-source file formats are needed: Because not everyone can afford proprietary software When transferring data from one area to another as the computers being used may not have compatible software Archived proprietary files may be difficult to read by new software

Question 74 marks

Question

An operating system is system software that manages computer hardware and software resources. Describe the tasks that an operating system carries out. ……[4]

Mark scheme

7 Four from: 4 Allocates memory to software Sends data/instructions to printers Responds to input devices Opens and closes files on storage devices In multi-tasking/multi-programming systems allocates equitable processing time to each task/program Sends error messages to applications/users Handles user logins Handles file permissions/security settings Provides the interface between the user and the computer

Question 86 marks

Question

There are a number of ways that fraudsters can obtain money from customers’ bank accounts. (a) Describe how the fraudster would use vishing to obtain a customer’s personal data. ……[3] (b) Describe how the fraudster would use smishing to obtain a customer’s personal data. ……[3]

Mark scheme

8(a) Three from: 3 Fraudster phones the victim pretending it is a call from the bank Fraudster claims that there has been some fraudulent activity on the customer’s account/customer has made certain purchases – could they confirm? Often involves getting the customer to phone the bank Fraudster’s computer redirects phone call to own phone Gives customer their bank details to get their confidence Gets customer to log on to bank’s site and enter their details to transfer money to their new account which has been set up This account is actually the fraudster’s own bank account 8(b) Three from: 3 Fraudster sends a cell phone text message to persuade customer to divulge their personal Information inviting the receiver to go to the fraudster’s website They include a telephone number in the message that connects to an automated voice response system They include in the message something that demands the target's immediate attention such as "We confirm that you have signed up to our service. You will be charged $2 a day unless you cancel your order on this URL” The user then goes on to a seemingly legitimate website that asks them to "confirm/enter your personal financial information”

Question 9

Question

Paolo is the owner of a small company with ten workers. He is developing a spreadsheet to calculate the payroll. He has started by importing a text file of the workers’ names. The list consisted of each worker’s family name followed by a comma then a space then their first name. He wants to split the names into separate family names and first names by finding the position of the comma in each cell in column A. He has discovered a new function, LOCATE, which gives the position of the first occurrence of a single character in a word. For example, =LOCATE(“e”,I4) gives the result 2. His first attempt at the spreadsheet is shown below. A B C D E F G H I J K L M Position of Rate per Hours 1 Name comma Family name First name Job Weekly pay hour worked 2 3 Smith, John Polishing 450 15 30 4 McDonnell, Louise Secretary 500 10 50 5 Hernandes, Juan Welding 450 10 45 6 Kennedy, Sean Orders 500 16 31.25 7 Gustaffsson, Johan Fitter 500 20 25 8 Davies, Iueuan Electrician 550 11 50 9 Lopez, Ramon Manager 500 25 20

Mark scheme

9(a) =LOCATE(“,”,A3) =LOCATE(,A3) 1 mark 1 “,” 1 mark 1 9(b) =LEFT(A3,C3-1) =LEFT() 1 A3, as first item 1 C3-1 as second item 1 9(c) =RIGHT(A3,LEN(A3)-C3-1) =RIGHT(A3, ) 1 LEN(A3) 1 -C3-1) 1 9(d) Three from: 3 Highlight J3:J12 Click on format then format cells Click on currency then select $ symbol Select 0 decimal places 9(e)(i) Select A3:M12 1 Sort in ascending order of column J 1 Add a level and sort in descending order of column I 1 9(e)(ii) Select A3:M12 1 Sort in descending order of column J 1 Add a level and sort in ascending order of column I 1

Question 10

Question

Garcia, Isabel Painting 550 20 27.5

Mark scheme

10 Four from: 4 Induction loop / pressure sensor sends signal/data to microprocessor Analogue to digital converter changes the analogue input to digital for the microprocessor to process Microprocessor compares reading with pre-set value If pressure is greater than/if inductance is different to preset value Microprocessor sends a signal to an actuator which raises the barrier Light sensor detects the break in the beam of light When the beam of light resumes the microprocessor sends a signal to an actuator which lowers the barrier

Question 11

Question

Costa, Albertina Invoices 450 15 30

Mark scheme

11(a) Teacher record table Subject record table ᴕ Teacher_ID 1 ᴕ Subject_code Family_name Subject_name First_name Subject_level Subject_ID Number_of_lessons ∞ Number_of_classes All Teacher records and Subject records with correctly titled tables 1 Primary key fields identified 1 Relationship line between correct two fields 1 One to many indicated 1 11(b) Four from: 4 Teacher_ID is identified/selected as the primary key in Teacher Table and Subject_code is identified/selected as primary key in Subjects Table Click on relationships in (database) tools Click on add tables and select Teacher Table and Subjects Table Select Subject_code in Subject records table and connect it to Subject_ID in the Teacher records table Enforce referential integrity/Click on save changes

Question 1233 marks

Question

Fernandez, Mariela Sales 550 11 50 13 (a) Using this LOCATE function, write down the formula he would use in cell C3. The formula must be easy to replicate. = ……[2] You can use the space below for any working you need. (b) He will use a formula in cell E3 to produce Smith. Making use of cell C3, write down the formula, without using the MID function, which must be easy to replicate. There must be no spaces, before, or after the name. = ……[3] You can use the space below for any working you need. (c) He will use a formula in cell F3 to produce John. Making use of cell C3, write down the formula, without using the MID function, which must be easy to replicate. There must be no spaces before, or after, the name. ……[3] You can use the space below for any working you need. (d) Describe the steps he would use to format the Weekly pay column so that the only difference that would be made would be to place a $ sign in front of the value. ……[3] (e) Using only the sort feature on columns I and J, explain how you would be able to get the following values in the given cells. You need to ensure data integrity is maintained. (i) 500 in cell J6 with Secretary in cell I6 and Davies, Iueuan in A12. ……[3] (ii) 500 in J7 with Orders in I8 and Smith, John in A11. ……[3] 10 A car park has a barrier which operates automatically. It opens when a car approaches it and closes when the car is clear of the barrier. Describe, including the use of sensors, how a microprocessor controls this operation. ……[4] 11 Maria, the A level students’ secretary, has been given the task of creating a database. It will store the records of each subject taught and the records of the teachers involved. She has decided to produce a relational database. The Teacher records will have the fields Teacher_ID, Family_name, First_name, Subject_ID and Number_of_classes. The Subject records will have the fields Subject_code, Subject_name, Subject_level and Number_of_lessons. (a) Complete the diagram below to show how the tables will be combined. [4] (b) Using the design of your database from part (a), describe how you would create it. ……[4] 12 A government database stores the licence plates of cars. In this particular country they all follow the same pattern, e.g. BG136KG CD125FH FT342LM NQ439SR Apart from a presence check, describe two appropriate validation checks which could be applied to licence plates. For each check give an appropriate example of invalid data that would be rejected. Each example must be different. 1 …… 2 …… ……[4]

Mark scheme

12 Length check to no more or no less than/exactly 7 characters are entered 1 Any suitable example of less than/greater than 7 characters 1 Format check to ensure that all licence plates are two letters followed by 1 three digits followed by two letters Any suitable example not consisting of two letters followed by three digits 1 followed by two letters

Question 138 marks

Question

IT professionals often use command line interfaces (CLIs) to communicate with computers. Office workers, however, prefer graphical user interfaces (GUIs). In the home, gesture based interfaces (GBIs) are increasingly being used. Evaluate these three types of interface. ……[8]

Mark scheme

13 Eight from: 8 Users with physical handicaps may not be able to use a keyboard or mouse For reasons of hygiene a doctor may not be allowed to touch a display or device so need to use gesture based interface Appropriate gestures is a more hygienic way to control the device Gestures may be a quicker way of initiating a response from a device Certain gestures may not be socially acceptable which is not a problem with the other interfaces Some gestures may be unintentional but still initiate a reaction from the device GUIs tend to be more accurate than relying on gestures CLI requires user to have to learn many commands unlike the others CLI commands are more difficult to edit CLI is more difficult to view different items on one screen when multitasking CLI processing speed tends to be faster than the others CLI uses less memory than the others CLI is less likely to change over time whereas GUIs tend to change regularly meaning less need to learn how to use a new system One mark is available for an appropriate opinion

Question 148 marks

Question

Many students use the internet in school to search for information to help with their classwork. Apart from e-safety, discuss the benefits and drawbacks of students using the internet for this purpose. ……[8]

Mark scheme

14 This question to be marked as levels of response: 8 Level 3 (7–8 marks) Candidates will discuss the benefits and drawbacks of using the internet The information will be relevant, clear, organised and presented in a structured and coherent format There may be a reasoned conclusion/opinion Specialist terms will be used correctly and appropriately Level 2 (4–6 marks) Candidates will discuss the benefits and drawbacks of using the internet although development of some of the points will be limited to one side of the argument For the most part, the information will be relevant and presented in a structured and coherent format Specialist terms will be used appropriately and for the most part correctly Level 1 (1–3 marks) Candidates will present benefits or drawbacks of using the internet There will be little or no use of specialist terms Answers may be simplistic with little or no relevance Level 0 (0 marks) Response with no valid content. Candidates may refer to e.g. Benefits Internet tends to be up to date Internet has vast amounts of information/ wide range of information/ wide variety of sources Use of search engines makes it quicker to find information than looking in books Multimedia sources are available on the internet unlike text books Interactive sites can be found on the internet unlike text books Drawbacks Danger of accessing inappropriate websites. Can take long time to find required information Can access biased/inaccurate websites Lack of expertise leads to inefficient searching Easy to plagiarise information The internet is not regulated Internet provides a variety of answers so it is difficult to decide which answer is correct

Checked your answers against these? Let AI mark the whole paper, on your own working.

Mark my 9626/11

How this paper is marked

Examiners follow the generic marking principles at the front of the scheme, then each question's points: method (M), accuracy (A) and independent (B) marks, error carried forward where the scheme allows it, and positive marking, so you're credited for what you got right.

Check your answers against it

Done this paper? Upload your script and CIE Buddy's AI marker marks it question by question against this exact scheme, puts the ticks on your own working and says what each lost mark needed.

Other variants, May/June 2019

9626/11 in other series

Find another Information Technology paper

Every AS & A Level Information Technology mark scheme

Question papers and mark schemes © Cambridge University Press & Assessment. CIE Buddy is independent and not connected to Cambridge.

9626/11 questions

Where can I find the 9626/11 May/June 2019 mark scheme?

On this page, free: the mark scheme for AS & A Level Information Technology 9626/11, May/June 2019 (9626_s19_ms_11), and the question paper (9626_s19_qp_11), to read or download, with each question's marking points written out underneath.

How many marks is 9626/11 out of?

Information Technology 9626/11 for May/June 2019 is out of 90 marks, with 1 hour 45 minutes to answer it.

Can I get my 9626/11 answers marked?

Yes. Upload your answers to 9626/11/M/J/19 as a PDF or photos, and CIE Buddy marks every question against this paper's official mark scheme, using Cambridge's marking rules. You get your score, each lost mark explained on your own script, and the topics to revise. It's a guide, not an official Cambridge grade.