Cambridge A Level Information Technology (from 2017) 9626 — 2017 May/June Paper 3 · Variant 3
9626/33/M/J/17 · 11 questions · 90 marks · ≈101 min
The question paper and its mark scheme, free to read here and free to download. This is Cambridge’s own paper, exactly as it was sat.
Question paper16 pages
















Mark scheme7 pages
Answers below. Sit the paper first if you are practising.







Questions as text
Q1 · A bank has strategies in place to safeguard its information technology (IT) services
1 A bank has strategies in place to safeguard its information technology (IT) services. You have been asked to check and update the strategies that are designed to try and prevent IT disasters from happening, the strategy for disaster recovery management and the strict password policy. (a) Describe how you would use risk analysis to check the strategy for disaster recovery management. ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ...............................................................................................................................................[4] (b) The bank’s strict password policy has rejected these two passwords: abc 1234AAA Explain why they have been rejected. ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ...............................................................................................................................................[6] (c) Explain the precautions that you would take to try and prevent a disaster happening to the data used by the IT services. ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ...............................................................................................................................................[6]
Mark scheme: Question Answer Marks 1(a) Four from: 4 Qualitative risk analysis to prioritise risks for analysis Quantitative risk analysis ...of likelihood of occurrence/probabilities ...of consequences of occurrence To identify effect/cost of risks caused by e.g. ...loss of access to premises ...loss of data ...loss of it function ...loss of skills Produce a computer simulation of the disaster Produce a report of the risks. 1(b) Six from: 6 The abc password is too short and does not meet minimum length requirements/number of character requirements Does not meet requirement for different types of characters Passwords must not be easily guessed and this is a simple pattern 1234AAA password has a sequence of characters/numbers ...has repeating characters Neither have a combination of upper/lower case/number/special characters. 1(c) Six from: 6 Backups made and sent off-site at regular intervals Backups made on-site and automatically copied to off-site disk Backups made directly to off-site/remote/’cloud’ servers Local mirrors of systems and/or data and use of disk protection technology such as RAID Surge protectors to minimize the effect of power surges on computer systems Using uninterruptible power supply (UPS) and/or backup generator to protect against a power failure Use of fire prevention/mitigation systems such as alarms and fire extinguishers Use of anti-virus software to protect data against corruption/loss/deletion Use of firewalls to prevent unauthorised/control access Use of physical security measures to control access by personnel Important passwords/codes should be held by more than one person/in secure conditions, but accessible in an emergency.
Q2 · Project management software is used to create an overview of the tasks or activities…
2 Project management software is used to create an overview of the tasks or activities required in a project. One type is desktop-based project management software. Describe other types of project management software. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[4]
Mark scheme: 2 Four from: 4 Desktop PMS set up as a program that runs on the desktop ...single user Web-based accessed using a web browser Use a smartphone or tablet to gain access to the PMS Use a thin client via a web browser Personal PMS one used at home ...manage lifestyle or home projects Single user programmed so only one person will ever need to edit the project plan at once Collaborative system is programmed to support multiple users once ...web-based tools available.
Q3 · Frank is a web designer who writes his own code and uses JavaScript on his webpages
3 Frank is a web designer who writes his own code and uses JavaScript on his webpages. He wants to print his name on every page. He creates two versions of the code to run his JavaScript on the webpage. These versions are represented here: Version 1: <script language="JavaScript"> document.write ("<p>My name is <b>Frank </b> </p>"); </script> Version 2: <script language="JavaScript" src="FranksJavaScriptcode.js"> </script> where the instructions for writing Frank’s name are in the file called “FranksJavaScriptcode.js” Explain why Frank prefers to use Version 2 of the code. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[6]
Mark scheme: 3 Six from: 6 Can call the code several times/from different pages/re-use the code No need of re-writing/having several copies/copies on each webpage Code only has to be tested once/checked for errors once File/JavaScript is cached by web browser ...reduces network access time/reduces cost of fetching data JavaScript code embedded in webpages can slow loading times/reduce browser performance ...webpage can slow/stop while browser executes code Can separate code into different conceptual/functional areas ...provides modularity to code ...separate html and JavaScript code so easier to read/maintain.
Q4 · A wide area network uses a number of different protocols
4 A wide area network uses a number of different protocols. (a) Describe each of the following wide area network (WAN) protocols. (i) HDLC: ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... .......................................................................................................................................[2] (ii) Frame relay: ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... .......................................................................................................................................[2] (b) An updated version of a free operating system has to be downloaded quickly. The operating system is contained in a very large file. There is a choice of using ‘BitTorrent’ or file transfer protocol (FTP) for the download. Explain, with reasons, which method of download would be preferable. ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ...............................................................................................................................................[4] (c) Describe how a network router provides connectivity between a home network and the internet. ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ...............................................................................................................................................[6]
Mark scheme: 4(a)(i) Two from: 2 (HDLC is): High-Level Data Link Control Layer 2 (data link) protocol Connects point-to-point serial devices/leased lines Uses error correction Routers encapsulate HDLC before putting on LAN. 4(a)(ii) Two from: 2 (Frame relay is): Layer 2 and 3/data link/network layer protocol Puts data into variable-sized packets/frames Does not include error-correction/error corrections is done by devices ...can be unreliable Specifies physical and logical link layers Used in packet switching Used on integrated services digital network (ISDN) Used in permanent virtual circuits (PVC) Can provide QoS ...worth constant bitrate/emulation of circuit switching. 4(b) Four from: 4 If many people want the OS at once bit torrent is resistant to flash-dot/crowds/website overload/dos/FTP is not resistant to flash-dot/crowds/website overload/dos Bit torrents can be paused/stopped and restarted/FTP cannot restart if paused, so if interrupted the download has to be done again Bit torrent makes many small data requests from different IP connections/addresses/FTP is from one IP connection/address so is quicker to download the large OS file Bit torrent downloads file sections randomly/rarest first/ FTP is sequential download of file sections Bit torrent can be slow to get up to full speed/FTP achieves full speed as soon as it starts download and can achieve very high download speeds. 4(c) Six from: 6 Has two or more connections to different networks Router reads address information in the packet header ...to determine destination of packet ...has a routing table/policy ...contains data on all possible routes to groups of addresses ...priorities for connections for handling data packets ...routing tables are dynamic/can be updated ...directs packet to next router if destination address not known ...direct packets to address if destination is known Router updates ‘hop’ count every time it forwards a packet ...when ‘hop’ count limit is reached packet is dropped/discarded ...usually a maximum of 16 hops ...or marked as undeliverable ...so packet does not live forever on network/internet.
Q5 · Discuss the benefits and drawbacks to small businesses of storing their data in the…
5 Discuss the benefits and drawbacks to small businesses of storing their data in the ‘cloud’. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[8]
Mark scheme: 5 Eight from e.g.: 8 Benefits: Reduced IT support requirements/staff so reduced costs to company Reduced requirements for storage devices reduces costs/maintenance costs Backups are managed by ‘cloud’ company so reduced costs of media/staff to carry out backups Files can be accessed from anywhere with internet connection allowing collaboration on documents/allows access to documents from home Drawbacks: Security issues are not under business control ‘Cloud’ service suppliers may go out of business so data is lost Need for a reliable internet service to be able to access the data Data may not be stored in same country as business so may be subject to different laws/regulations. Max 6 for all benefits or all drawbacks. 1 mark available for a reasoned conclusion.
Q6 · A new operating system for tablet computers has been developed and is now ready for…
6 A new operating system for tablet computers has been developed and is now ready for testing to begin. Analyse the difference between white box testing and black box testing. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[8]
Mark scheme: 6 This question to be marked as a Level of Response. 8 Analyse requires that candidates explain the main points in detail, explaining their effectiveness and characteristics. Level 3 (7–8 marks) Candidates will analyse in detail the differences between white box testing and black box testing. There will be a reasoned statement concerning the effectiveness of both types of testing. The information will be relevant, clear, organised and presented in a structured and coherent format. Subject specific terminology will be used accurately and appropriately. Level 2 (4–6 marks) Candidates will explain the differences between white box testing and black box testing. There will be a reasoned statement concerning the effectiveness of one of the types of testing. For the most part, the information will be relevant and presented in a structured and coherent format. Subject specific terminology will be used appropriately and for the most part correctly. Level 1 (1–3 marks) Candidates will describe the differences between white box testing and black box testing. Answers may be in the form of a list. There will be little or no use of specialist terms. Level 0 (0 marks) Response with no valid content. Answers may make reference to e.g.: White Box Testing is a testing method in which the internal structure/ design/ implementation is known to the tester. Black Box Testing is a testing method in which the internal structure/ design/ implementation is NOT known to the tester. In white box testing, programming knowledge is required; in black box testing it is not. In white box testing, programming knowledge is in-house; in black box testing it is not. White box testing needs access to a detailed design specification, black box testing does not. White box testing needs knowledge of the implementation, black box testing does not.
Q7 · Evaluate the use of 3D printing for manufacturing goods
7 Evaluate the use of 3D printing for manufacturing goods. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[8]
Mark scheme: 7 Eight from: 8 Advantages Easier to customise products such as pills to users specific requirements/genetic makeup Printing can be done remotely so no need to transport the final product from factory to destination Prototypes can be produced more rapidly for testing so production is speeded up Manufacturing of product may be faster than traditional methods so product is available sooner Costs may be reduced due to reduction in tooling costs/ less need for specialist machinery No need to store excess inventory/reduced warehouse costs Can produce items/spare parts in harsh environments where traditional methods may not be feasible/possible Disadvantages Limited materials available for printing so product range is restricted/materials may not be suitable for product’s eventual use Copyright issues arise as easier for anyone to print the product Dangerous items can be more easily created e.g. Knives/guns Useless items produced and thrown away these have an environmental impact Limited size of products due to restrictions on size of printer Printing can be quite slow compared to traditional manufacturing. Max 6 for all advantages or all disadvantages. 1 mark available for a reasoned conclusion/opinion.
Q8 · You have been asked to use data mining to analyse economic trends for a business
8 You have been asked to use data mining to analyse economic trends for a business. Describe the tasks involved in data mining that you would have to carry out to produce an overview of an economic trend. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[6]
Mark scheme: 8 Six tasks from e.g.: 6 Identification of unusual data records/anomalies in economic data Searching for relationships between variables/dependency detection in the economic data Clustering /discovering ‘similar’ groups and structures in the economic data Classifying /generalizing known structures to apply to new economic data Finding functions that model the economic data with the least error Summarising the economic data Producing reports on the economic data in a useful format/charts/graphs/tables to show trends in the data.
Q9 · Dylan works for a graphics design company producing images in GIF, JPEG and PNG file…
9 Dylan works for a graphics design company producing images in GIF, JPEG and PNG file formats. He has been asked to produce some high-quality still images for use in advertising on the World Wide Web. He has to choose one of the file formats to store the images. Choose the most appropriate file format by comparing the features of the three different formats. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[4]
Mark scheme: 9 Four from: 4 PNG images are lossless/do not lose data when edited so have higher quality JPEG (jpg) format is compressed with data being lost/data is lost during editing but images are of lower quality/have artefacts compared to PNG images GIF only allows limited number of colours/256 colours so is not suitable for high quality image publication GIF allows several images in one file so animations are possible, but this is not required.
Q10 · A large, profitable manufacturing company wishes to replace its current computer system…
10 A large, profitable manufacturing company wishes to replace its current computer system with a new one. The company employs a large workforce in many different departments. The time to be taken for the implementation is not important but the new system must work as efficiently as possible. The company has chosen the most appropriate method of implementation to suit its circumstances. Identify the chosen method and explain, with reasons, why the company has chosen this compared to other methods. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[8]
Mark scheme: 10 Eight from: 8 Pilot running would not be appropriate as it not likely that each department would need similar aspects of the system Phased implementation would be possible because one department could have their part system implemented... ...when working another part of system could be tried in another department Parallel running would be possible as there are enough workers available to use both systems at the same time Parallel running would be possible as company can afford to employ two sets of workers if more are needed Parallel running is appropriate as the old system continues while problems are fixed with the new system Direct changeover would not be advisable as it may not work properly first time Direct changeover is a quick method but speed of changeover is not an issue Direct changeover is a cheaper method but the cost is not important to the company.
Q11 · A large company employs a small team of workers to design a new, complex product
11 A large company employs a small team of workers to design a new, complex product. They all work on the same site and need to discuss possible designs and costings and to exchange documentation on a weekly basis. Network connections are intermittent. The company could use video-conferencing or face-to-face meetings for the workers’ discussions. Identify, giving reasons, the more appropriate method. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[8]
Mark scheme: 11 Eight from: 8 Video-conferencing is not appropriate as network connectivity would lead to break up of the conference Video-conferencing is not appropriate as the workers are all on the same site so expensive equipment does not need to be purchased Large documents can be more easily shared and worked on Meetings need to regularly held so video conference would need to be set up often which would require technical expertise with recurring costs Inconvenience for technical staff having to be available/on call for video conference each week/regular basis As they are on the same site, the company would not need to pay travel expenses for face-to-face meetings so video-conferencing would not be an advantage As they are on the same site, there is no waste of time travelling to meetings so video-conferencing would not be an advantage The designs would be less likely to be hacked/stolen/copied. Total: 90
What was in this paper
The subtopics covered by these 11 questions, and how many questions each got. Open one in a new tab to see every Cambridge question on it.
What you needed in this session
Cambridge’s own grade thresholds for 2017 May/June, Paper 3 · Variant 3. A higher threshold means an easier paper — the bar moves with how the cohort did.