Information and Communication Technology 0417/11 October/November 2021: question paper and mark scheme

Mark scheme

1(a) The physical components of the computer 1 1(b) Two from: 2 Processor Motherboard Video/graphic card Sound card 1(c) One from: 1 Programs for controlling the operation of a computer Programs for processing of electronic data Program/data/applications 1(d) Two from for example: 2 Word processing Spreadsheet Database Presentation

Mark scheme

2 Car production workers 2 Payroll workers

Mark scheme

3 Two from: 2 Tends to be a faster to load up the operating system They are more lightweight so can be carried anywhere//More portable Don’t generate as much heat Lower power consumption therefore batteries last longer

Mark scheme

4 4 Looking at Observation Questionnaire existing paperwork This method gives the Π systems analyst an overall view of the system Individuals can remain Π anonymous This method allows Π information to be collected that cannot be obtained from any other method This method gives the Π quickest analysis of the data

Mark scheme

5(a) Six from: 6 Each module is tested separately Modules are tested by the programmers Modules/system are tested with live data Errors and problems are noted Improvements are made to the module The module/system is retested Modules are combined and tested together System is tested as a whole System is tested to meet the user’s requirements 5(b) Eight from: 8 Advantages Prevents double booking The customer can see immediately when the holiday has been booked Bookings can be made 24/7 No need to travel to the booking office/queue up so saves time Can be booked from any location Saves cost of travelling to the booking office Tickets are usually sent online and therefore paperless//Saves printing and postal costs Usually cheaper as lower/fewer overheads Customers can more easily see the tours that are available Disadvantages Setting up is expensive//maintenance is expensive Internet access is needed to run the booking system therefore the cost may be increased More reliant on server/network Booking mistakes can be more easily made Mistakes are more difficult to rectify due to the speed of booking If the system crashes during the booking the booking may not be made To gain full marks there must be at least one advantage and one disadvantage

Mark scheme

6 Problem: 6 Award a mark for each problem identified I avoid back and neck problems I avoid eye strain I avoid getting headaches I avoid epilepsy Strategies: Max four from: Make sure the top of the screen is at eye level Make sure that I adjust the tilting screen correctly Take regular breaks Do neck/back exercises Make sure I use blue lens spectacles Use a screen filter Use a matt/anti-glare screen Turn the screen away from the window Use a computer screen for a short time/take regular breaks Have my eyes tested regularly Improve the lighting in the room Sitting further away from the screen Keeping the screen clean Position the screen to reduce glare Use a non-flickering screen/LED/LCD Turn the brightness down on the screen

Mark scheme

7 Four from: 4 Smartphone sends data to its Bluetooth connector Data is converted to radio waves The smartphone automatically detects nearby devices The smartphone pairs to the other device if in range The smartphone randomly chooses one of 79 possible channels If the channel is in use, it randomly chooses another The connection changes channels, every few seconds Sends the radio wave to the other device

Mark scheme

8(a) Four from: 4 Internet is used to share and distribute information outside the organisation whereas the intranet within an organisation Internet is used to send and receive emails and messages outside the organisation whereas intranet sends and receives messages within an organisation The intranet meets the needs of the organisation whereas internet aims to meet the needs of everybody The internet facilitates collaboration with others whereas the intranet is only used to collaborate with other members within an organisation The internet is used to browse the World Wide Web 8(b) 4 Facial Voice recognition Password Recognition This method cannot access the smartphone Π unintentionally The accuracy of this method Π can be affected by noise This method requires the use Π of the smartphone’s camera This method could be compromised by shoulder Π surfing

Mark scheme

9(a) Two from, for example: 2 Fit windscreens Fit the wheels Welding body panels Move cars from one place to another Fit engines 9(b) Six from: 6 The depth of the paint is read by the sensor The depth of paint is sent from the sensor to the ADC/microprocessor The digital data from the ADC is read by the microprocessor The microprocessor compares this data to the minimum depth of the paint/preset value If the data is less than the minimum depth/preset value, the microprocessor sends a signal to the actuator If the data is more than the minimum depth/preset value microprocessor does nothing Process is continuous 9(c) Six from: 6 Advantages They can work in areas where it would be harmful for humans They can work 24/7 Cheaper in the long run Higher productivity The finish is more consistent Disadvantages Expensive to purchase Skills can be lost Expensive to maintain/reprogram Expensive to start up//train staff to operate the robots To gain full marks there must be at least one advantage and one disadvantage

Mark scheme

10(a) Three from: 3 LOOKUP allows for horizontal and vertical searching whereas VLOOKUP allows for vertical searching LOOKUP does not require an index value/only works on the second row/column whereas VLOOKUP requires an index value LOOKUP usually only works when the data is sorted VLOOKUP only returns data to the right of the searched column VLOOKUP user can select either an approximate or exact match to the lookup value 10(b)(i) Three from: 3 The formula looks up the value in D2… …In the (range) A2 to A7 And returns the corresponding value In the 3rd column/Column C 10(b)(ii) Add FALSE/0 to the end of the formula – 1 mark 2 Sort the range into ascending order of column A – 1 mark 10(c) Poor 1 10(d) Four from: 4 Quicker to type in the formula Fewer mistakes when typing in the formula Easier to spot mistakes Easier to expand the range Takes up less storage space Easier to remember when retyping

Mark scheme

11(a) Two from for example: 2 Email address Real names DOB Home address Contact phone number Membership card number Location data Internet Protocol (IP) address Picture of yourself Gender 11(b) Two from: 3 Password should not relate to personal details Should be a long password Not previously used password Should not include repeating/obvious patterns//predictable words Password should be strong 11(c) Six from: 6 Use anti-spyware/up to date antivirus software Play the games with the firewall operational Play only with authorised versions of games which you have purchased from the correct sources and for which you have a licence Download/buy files and new software from reputable sources Do not forget to delete your account details when you are not playing again Keep the game software up to date. When disposing of your gaming device ensure all of your personal information has been deleted. Choose a username that does not reveal any personal information Be aware of criminals buying or selling ‘property’ that exists inside a computer game, in the real world

Mark scheme

12(a) Two from: 2 Dedicated website/app/platforms It interacts with other users Can be used to find people with similar interests 12(b) Six from: 6 Communicating with friends and colleagues all over the world Promotes collaboration and teamwork Instant communication Easy to find other people with common interests Allows the exchange of content or documents Allows people to share best practice/knowledge/skills It can help in community projects Gives up to date information Can give more confidence to some people who may be shy//develop social skills As it is seen by a lot of people helps advertising Easier for online buying and selling//market products Can be used more easily for analytics and market research It can promote talent quickly, musicians Make/socialise with new friends

Mark scheme

13(a) Four from: 4 Load the document Highlight the text Click Insert then Table Select Convert text to table Click on 2 columns Click separate by : Click ok 13(b) Two from: 2 Compares each typed word… …with its dictionary/database Uses algorithms to check the spelling 13(c) Two from: 2 Real names are not recognised Badly spelt words will not be recognised Incorrect grammar may not be recognised It will not find words that sound the same but have been used incorrectly Some words may be spelt incorrectly but form another word They do not learn from their mistakes unless added to the dictionary They may use the wrong dictionary