Question 11 mark
Question
Tick (✓) one external device. A sound card B pen drive C motherboard D ROM [1]
Mark scheme
1 Pen drive 1
Free until 14 Nov · 80% off for the first 100 · Pricing
Cambridge IGCSE Information and Communication Technology (0417), Paper 1 Theory, October/November 2023. Read both free below, or download them. Done the paper? Get it marked by AI against this mark scheme.
0417_w23_qp_120417_w23_ms_120417/12/O/N/23
Each question as it's printed, and the mark scheme's points for it, as text. Diagrams, tables and graphs are in the PDFs above.
Question
Tick (✓) one external device. A sound card B pen drive C motherboard D ROM [1]
Mark scheme
1 Pen drive 1
Question
A computer system uses both analogue and digital data. (a) Explain what is meant by these types of data. (i) analogue data …… [1] (ii) digital data …… [1] (b) Digital data is processed in a computer system. Sometimes digital data needs to be converted to analogue data. Explain why digital data may need to be converted to analogue data. …… [1] (c) Use the most appropriate phrase from the list to complete the sentences. Your answer must be different in each case. analogue data digital data display a graph on a monitor input the maximum safe water level for a river measure acidity levels in a river control humidity levels open the windows in a greenhouse (i) A motor is used to …… [1] (ii) A DAC outputs …… [1] (iii) A sensor is used to …… [1]
Mark scheme
2(a)(i) One from: 1 • Continuous data • Any values in a range 2(a)(ii) One from: 1 • Discrete data • Binary 2(b) One from: 1 • To control an external device • To be sent to an actuator 2(c)(i) Open the windows in a greenhouse 1 2(c)(ii) Analogue data 1 2(c)(iii) Measure acidity levels in a river 1
Question
Identify three different network communication devices and describe what each one does. Device 1 …… Description …… Device 2 …… Description …… Device 3 …… Description …… [6] 4 A teacher is creating a database for a class library. The teacher types the details of each book into the database. The teacher has entered a number of records. Book_number Name_of_book Publisher Date_acquired ISBN 1101 Build a computer JB Books 02/11/2020 9780119192065 1012 IT terms MMA Books 16/05/2021 0893603944 Databases are 1414 Cam Press 01/10/2009 0090116393 fun Identify and describe a validation check based on the data shown in the database table, which could be applied to the data as it is entered into each of the fields. Each validation check must be different. Book_number Validation check…… Description…… Date_acquired Validation check…… Description …… ISBN Validation check…… Description…… [6]
Mark scheme
3 One mark for a correct network device and one mark for a description of what 6 it does Router One from: • Allows a LAN to be connected to a WAN/Internet • A router allows data packets to be sent to LAN/WAN Hub One from: • Connects computers/devices so data can be broadcast to all devices Expands a LAN • Network interface Card (NIC) • Connect computers/devices to a network Bridge One from: • Connects two LANs of the same protocol together • A bridge creates a single LAN from separate parts Switch One from: • Connects computers together to form a LAN • Allows data to be sent to individual devices
Question
A group of pupils is planning to create a newsletter for a history project. The group can either use a smartphone or a phablet computer. (a) Explain what is meant by a phablet computer. …… [2] (b) Discuss the advantages and disadvantages of using a phablet computer rather than a smartphone for this project. …… [6]
Mark scheme
5(a) Two from: 2 Smartphone and tablet hybrid A tablet that functions as a smartphone It is a device that has the features/properties of a smartphone/tablet computer The device size is in between a smartphone and a tablet 5(b) Six from: 6 Advantages A phablet has a larger screen size so it is easier to read the text/navigate/click on icons/type/edit text Better control over the layout of the screen/newsletter Due to the screen size more people can view at the same time The onscreen keyboard is larger making it easier to enter the data Easier to connect devices onto a phablet Disadvantages Less portable than a smartphone More difficult to record audio messages due to its size If cameras are to be used then it is easier to use a camera with a smartphone Pupils are more likely to have smartphones with them To gain full marks the candidate must have both advantages and disadvantages. If only a list then only five marks can be awarded
Question
Many teachers use multimedia projectors in their lessons. (a) State two health issues associated with the use of multimedia projectors. 1 …… 2 …… [2] (b) State two safety issues associated with the use of multimedia projectors. 1 …… 2 …… [2]
Mark scheme
6(a) Two from: 2 Eye problems Headaches Burns 6(b) Two from: 2 Projector falling on the presenter Electrical fire due to overheating of the projector Electrocution caused by liquid spilling on the projector Tripping over trailing cables
Question
A video of a race can be recorded using a camera either on an autonomous flying vehicle (drone) or in a helicopter. A person would be needed in the helicopter to operate the camera. Describe two advantages and two disadvantages of using an autonomous flying vehicle (drone) to record the video of the race. Advantage 1 …… Advantage 2 …… Disadvantage 1 …… Disadvantage 2 …… [4]
Mark scheme
7 Two from: 4 Advantages Safer to use drones than risking the humans filming in the helicopter Cheaper to use a drone rather than using a helicopter The drone could fly closer to the competitors than a helicopter Drones can be used in areas that would not be accessible to the helicopter Two from: Disadvantages More difficult to fix camera problems as no humans present The range of the drone may be smaller The drone may become a distraction as it is closer to the race It can fly out of range and lose control signal
Question
State the most appropriate storage medium from its description. (a) A storage medium that stores data on the internet. …… [1] (b) Internal storage where the current instruction is stored. …… [1] (c) A solid-state storage that is used in digital cameras. …… [1] (d) An optical storage medium that stores high-definition (HD) movies. …… [1]
Mark scheme
8(a) Cloud storage 1 8(b) Random Access Memory/RAM 1 8(c) One from: 1 SD/xD/cFast/Memory card Flash memory 8(d) Blu-ray disc 1
Question
A hospital administrator enters data from medical forms into a database. Validation and verification are both used when entering data to minimise errors. Explain what is meant by validation and verification and why they are both needed in this scenario. …… [6]
Mark scheme
9 Max two from: 6 Validation • Validation is an automatic computer check • Validation ensures that the data entered is sensible/reasonable • Ensures the data entered fits the set criteria Max two from: Verification • Verification checks that the data on the original source document is identical to the data that you have entered into the system • Verification ensures that the data is copied/entered correctly Max three from: • Because it is personal data the data needs to be correct • Data should be error free to ensure patients are safe • If data is incorrect it could lead to consequences • Individually they cannot detect all errors
Question
The manager of the Tawara Hotel has decided to computerise the hotel’s room booking system. The new booking system will allow customers to book rooms online using an app on their smartphones. The manager has employed a systems analyst who will carry out research into the current system by examining existing documentation and completed questionnaires from staff. (a) One item of information that the systems analyst will need to identify is problems with the current system. State three other items of information that the systems analyst will need to identify. 1 …… 2 …… 3 …… [3] (b) Following the analysis, the systems analyst will implement the new system using either parallel running or direct changeover. Evaluate these different methods of implementation. …… [6] (c) Describe the benefits and drawbacks of using an online booking system. …… [5] (d) The hotel uses both a WAN and a WLAN. Describe the differences between a WAN and a WLAN. …… [4]
Mark scheme
10(a) Three from: 3 • The inputs/processing/outputs of the current system • The user requirements for the new system • The information requirements for the new system • Hardware/software requirements 10(b) Six from: 6 Parallel running • Data would need to be entered twice this could cause issues with double booking • Staff can be gradually trained on the new system which takes a longer time • Parallel running is more expensive to operate as there are two sets of staff/two systems operating • In parallel if the new system fails, the old system is still available • In parallel running a system is always in place Direct changeover • Faster method of full implementation as the hotel will not want the system to be out of use • Immediate benefits • System is thoroughly tested before use, therefore less chance of it being faulty • Staff have to be trained before the new system is implemented this can be difficult as they are still working • Training takes place on non-live systems which may mean problems can be missed • Data can be lost as the old system has been removed • No system will be in place during the changeover To gain full marks there needs to be both direct changeover and parallel running 10(c) Five from: 5 Benefits • Available 24/7 therefore helps customers to book when they want • Fewer problems with the bookings/double bookings • Faster booking system as not waiting in queues • Immediate confirmation of the booking • Easier to cancel/change bookings Drawbacks • Relies on telecommunications to make the booking • Needs internet access/connection • Security issues due to fraud/others seeing personal data • Wrong information may be added accidently and this may be difficult to correct To gain full marks the candidate must have both benefits and drawbacks
Question
A clothing retailer only sells its clothes on the internet. (a) Discuss the benefits and drawbacks to the clothing retailer of using internet shopping. …… [6] (b) A customer is purchasing some new clothes from this retailer. Describe the steps the customer would take when purchasing the new clothes using internet shopping. …… [5]
Mark scheme
11(a) Six from: 6 Benefits • Saves the cost of having a store • Saves cost of rent/insurance/utilities/costs/business rates • Saves cost as less staff required • Larger customer base therefore increases profits • The selling is not limited to shop opening hours therefore increases sales Drawbacks • Increased costs more staff needed to operate/develop the website/drivers • Needs large warehouse space/distribution system • Reliant on the technology • Operates 24/7 therefore increases overheads • Relies on customers that only shop online To gain full marks the candidate must have both benefits and drawbacks 11(b) Five from: 5 Customer: • Loads up the website • Sets up an account • Logs into the website • Enters a password • Browses through the online catalogue • Clicks on the items required • Enters the quantity/colours/size of items • Adds items to the virtual basket/cart • Clicks on the virtual checkout • Chooses payment method • Chooses delivery method • Adds payment/delivery/personal details • Checks the details entered • Logs out of system
Question
The manager of a sports club is designing an online form for members to enter their personal details. The form must be accessible to all members of the club. (a) State four characteristics of a good form design. 1 …… 2 …… 3 …… 4 …… [4] (b) State two characteristics of good form design that would help users with visual impairment to enter their data. …… [2]
Mark scheme
12(a) Four from: 4 • Clear and visible labels for each field • Font size is large enough to read • Easy data entry • Language used is simple to understand • Appropriate size of data entry sections • Good use of white space//Fills the screen • Use of sensible error messages • Use of navigation buttons/drop down boxes/radio buttons • Use/location of Help buttons/instructions 12(b) Two from: 2 Only allow the first two answers and then place a MAX • Buttons are large enough to see • Font size is large enough to read • Use of high contrast colours • Use of voice entry • Use of text to speech
Checked your answers against these? Let AI mark the whole paper, on your own working.
Mark my 0417/12Examiners follow the generic marking principles at the front of the scheme, then each question's points: method (M), accuracy (A) and independent (B) marks, error carried forward where the scheme allows it, and positive marking, so you're credited for what you got right.
Done this paper? Upload your script and CIE Buddy's AI marker marks it question by question against this exact scheme, puts the ticks on your own working and says what each lost mark needed.
Question papers and mark schemes © Cambridge University Press & Assessment. CIE Buddy is independent and not connected to Cambridge.
On this page, free: the mark scheme for IGCSE Information and Communication Technology 0417/12, October/November 2023 (0417_w23_ms_12), and the question paper (0417_w23_qp_12), to read or download, with each question's marking points written out underneath.
Information and Communication Technology 0417/12 for October/November 2023 is out of 100 marks, with 1 hour 30 minutes to answer it.
Yes. Upload your answers to 0417/12/O/N/23 as a PDF or photos, and CIE Buddy marks every question against this paper's official mark scheme, using Cambridge's marking rules. You get your score, each lost mark explained on your own script, and the topics to revise. It's a guide, not an official Cambridge grade.