Cambridge A Level Applied Information and Communication Technology 9713 — 2017 Feb/March Paper 3 · Variant 2

1 Describe features of the purpose-built computer-aided design software that would assist the salesperson in designing a new kitchen for a customer. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[8]

Mark scheme: Question Answer Marks 1 Eight from e.g.: 8 Design accurate drawings of kitchen components/parts «using database/library of pre-prepared components/parts to speed up design process Component tested/matched before produced «under variety of conditions/positions/configurations Can be saved/edited/copied for later use/sending to company 3D views to allow walk-around/view final product «zoom feature to show enlarged views Total cost of whole kitchen can be calculated «using a database of parts/prices held by program

2 Explain how a wireless connection to the internet can be set up to try to ensure that the data that is transferred is kept secure. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[6]

Mark scheme: 2 Six from e.g.: 6 SSID hidden/not broadcast «so network is not visible to public RF shielding «covering windows/buildings to attenuate Wi-Fi signals MAC filtering «only known MAC addresses allowed to connect Static IP address used «users required to enter own IP address deters (causal) intruders Network/encryption key required to join/connect to wireless network «use of latest encryption system/do not use WEP «transfer of data by wireless uses strong encryption Use of USB/software/smart card tokens «combined with server/router software will change encryption key at intervals File encrypted «using keys known only to users

3 Describe ways in which the salesperson could use the internet to keep in contact with the company. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[6] Scenario 2 Questions 4 and 5 A cinema has an online booking system that allows customers to choose and pay for specific seats in the cinema. The cinema shows digital movies. It also shows live events, such as rock concerts, from around the world using satellite technology.

Mark scheme: 3 Six descriptions from e.g.: 6 Email can be used to send messages Email messages can have documents attached Messages can be sent via webmail using the company website Documents can be transferred by using FTP VoIP used for telephone calls to/from company personnel Group discussions/visual discussions can be carried out by video conferencing Chat rooms can be used for discussions/sharing information Text messages can be sent using proprietary software Private connections can be made to company intranet via VPN

4 Describe the inputs, processing and outputs that take place when two customers try to book the same seat simultaneously over the internet. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[8]

Mark scheme: 4 Eight from: 8 Requests queued by booking system as received Input – choice/requested seat by first in queue Process – check if seat available/has seat already been booked? «if already booked then output request for booking declined «if available then seat is flagged as reserved/booked/not available «output – message that seat is booked for user/ticket issued Input – second request to book/reserve seat Process – check seat availability/seat is booked Output – message that seat not available

5 Describe how satellite technology enables a live event to be viewed in the cinema. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[6] Scenario 3 Questions 6, 7 and 8 A government of a country is concerned about the unequal access to the internet by its citizens. The government is trying to reduce the digital divide.

Mark scheme: 5 Six from: 6 Event recorded/captured by digital video camera Video/audio encoded for transmission to studio Video/audio sent to studio for editing/commentary Video/audio transmitted via microwave/cable/communications link to studio Video/audio sent from studio to uplink station Signal uplinked to satellite Satellite transponder changes signal carrier frequency Satellite broadcasts signal to cinema dish Dish connected to decoder at cinema Decoder uses codec to decode signal into video/audio for display Digital projector used to display event on screen

6 Describe the factors that would lead to unequal access to the internet by citizens. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[6]

Mark scheme: 6 Six from e.g.: 6 Infrastructure/telecommunications system/mobile phone network may not be adequate Computing devices may not be available Cost as access to internet is not free Language difficulties as most of internet may not be in native language Literacy as use of internet requires ability to read/comprehend Age issues – older people have difficulties with technology Disabilities – physical/cognitive difficulties may deter users

7 Explain why reducing the digital divide is important to the government. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[6]

Mark scheme: 7 Six from e.g.: 6 Economy improves due to an increase in business opportunities/access to global markets Social mobility as a result of access to education/employment opportunities by citizens leads to improved quality of government members Members of the government have easier access to opinions of citizens Members of the government can explain their views more easily to citizens Government dissemination of information can reach more citizens Government provision of online services makes centralisation of records easier Increased status of country in technological world «leading to increase in international influence

8 Describe the increased costs for the government in order for them to reduce the digital divide amongst its citizens. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[6] Scenario 4 Questions 9, 10 and 11 A software company sells its software as downloadable files purchased by customers via a website. A web server stores the company website where customers can choose and pay for software. A file server is used to store files for download. Customers may use file transfer protocol (FTP) to log in and download their chosen software. A number of different protocols are used to transfer the files and the website data over the internet. Customers are required to log in to the servers using their own computers in order to purchase and download software. The customers often use firewalls to protect their own computers but these firewalls may cause FTP to fail.

Mark scheme: 8 Six from e.g.: 6 Investment in infrastructure «provision of telecommunication systems Costs of ICT training provision Cost of ICT equipment provision/subsidies Cost of recycling ICT equipment Cost of increased provision of laptops/computers in schools/for children Cost of the provision of ICT/internet connected ‘drop in’ centres

9 (a) Describe how an FTP connection using active mode is established between the file server and the customer’s computer. ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ...............................................................................................................................................[4] (b) FTP connections are not usually secure. Describe how FTP connections may be secured to protect data. ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ...............................................................................................................................................[4]

Mark scheme: 9(a) Four from: 4 Works at Application layer Uses two ports «data port and command port Client initiates connection on any port (>1023) «to connect to servers command port (port 21) «tells server which port it is listening on for data Server sends back response to client «initiates data connection to client’s data port Client acknowledges server’s response 9(b) Four from: 4 Use secure FTP/SFTP/FTPS over SSL/TLS «to encrypt the data during transmission «require digital certification Change the port number «to an obscure number/port number not usually known for use with FTP «so not recognised by others/port scanners as FTP traffic

10 Explain why a customer’s firewall may cause the FTP connection to fail and describe how this problem may be overcome. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[4]

Mark scheme: 10 Four from: 4 Issue: (Firewall problem with active mode FTP is on the client side) FTP client tells the server what port it is using for listening on «the server connects back to the specified port on the client Client firewall sees this as outside system initiating a connection to an internal client/device« «blocks the connection as this is not allowed Solution: Use passive (PASV) mode for FTP« «server tells client which port to use for data «client initiates connection so firewall allows it Use web browser to connect/as an FTP client« «web browsers only use passive mode for FTP connections Max 3 for all issue or all solution

11 HyperText Transfer Protocol (HTTP) is used by the World Wide Web. Describe the purpose of this protocol. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[3] Scenario 5 Questions 12 and 13 A company uses software to automatically produce business documents such as letters, memos and address labels. Users can select the data to be merged into the business documents using the facilities provided by the software. The company has an intranet which can be used to access the business documents stored on the company servers.

Mark scheme: 11 Three from: 3 Defines the action of web servers in response to requests from web browsers Defines how data is transmitted« «and formatted Defines the action of a web browser in response to commands in the data« «to display and format contents of message/data Sets up a ‘stateless’ connection« «command has no idea of the commands that preceded it Sets up a client server connection Converts a URL into an IP address« «which is used to locate the server

12 (a) Describe the use of each of the following features in selecting data to merge into a business document. (i) hyperlink: ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... .......................................................................................................................................[2] (ii) drop-down menu: ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... .......................................................................................................................................[2] (b) Describe the use of object link embedding (OLE) in the creation of the documents. ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ...............................................................................................................................................[3]

Mark scheme: 12(a)(i) Piece of text/object contains address of/reference to item/page/document 2 When clicked on/selected directs user to new item 12(a)(ii) (Graphical) control box 2 Contains list of items/objects chosen by select/click by user 12(b) Three from: 3 Part of document is exported to editor/document edited «imported back to original document Different data can be added to main document« «by linking e.g. images/text Changes in master document are/should be reflected in any document that references master document Creates compound documents/documents with parts/data from different sources Used for drag and drop of items from clipboard/storage area

13 Discuss the benefits and drawbacks to the company of having an intranet. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ......................................................................................................................................................[6]

Mark scheme: 13 Six from: 6 Enables collaboration between staff on documents/projects« «speed of information flow is increased c.f. paper trails «group could be informed when a deadline is near/when project has been completed Data/documents/protocols/resources/policies/memos can be stored for all staff to access «only one copy needs to be updated/no need to send updated versions of documents to all staff Automatically alert specific authors/users about/dates of documents/projects data/ documents/protocols/ resources/ policies/memos due to expire Backup/security is managed centrally/not dependant on individual staff Can manage access to external sites/information «can automatically provide live information/RSS feeds Drawbacks: Security of information issues All staff may not read all of the information available/memos Reduced face-to-face interaction between staff Cost of setup/maintenance Max 5 marks for all benefits or all drawbacks One mark available for a reasoned conclusion. Total: 80