Skip to content
Marlbridge

Free flashcards · Cambridge IGCSE · 0417

ICT flashcards

277 cards covering every topic of the 0417 syllabus (2026-2028). Study one topic or mix them all, turn each card, and mark yourself honestly.

Study mode needs JavaScript. Every card is listed below, so you can still cover the answers and test yourself.

All 277 cards

For a quick read-through or printing. Cover the right-hand side to test yourself.

Topic 1: Types and components of computer systems

Hardware vs software
Hardware is the physical components of a computer system. Software is the programs that run on it.
System software vs application software
System software runs the computer: the operating system, utilities, device drivers and compilers. Application software does the user's work: word processors, spreadsheets, browsers, databases.
Is a device driver system software or application software?
System software. Although it relates to one device, it helps run the computer rather than doing a task for the user.
Why must analogue data be converted to digital, and what does it?
The real world is analogue (continuously variable), but a computer only stores and processes digital data. An analogue-to-digital converter (ADC) samples the signal and stores each sample as a binary number.
What does a digital-to-analogue converter (DAC) do?
It turns stored binary values back into a continuously variable signal that a device such as a speaker or motor can use.
What does the CPU do, and what does it contain?
It processes instructions and data. It contains the control unit, the arithmetic logic unit (ALU) and registers.
RAM vs ROM
RAM is volatile, can be written to, and holds the programs and data in current use. ROM is non-volatile, normally read-only, and holds the boot instructions.
Does ROM store the operating system?
No. ROM holds the boot (start-up) instructions that begin loading the operating system. The operating system itself is stored on backing storage and loaded into RAM.
Internal memory vs backing storage
Internal memory (RAM and ROM) is accessed directly by the CPU. Backing (secondary) storage is non-volatile and keeps files permanently, but is not directly accessed by the CPU.
What does an operating system manage?
Memory, files, processes, input and output devices, and it provides the user interface.
Command line interface: advantages and disadvantages
The user types commands. Efficient and powerful for experts, with direct access to the system. But commands must be memorised and typing errors are not forgiven.
Graphical user interface: advantages and disadvantages
Uses windows, icons, menus and a pointer (WIMP). Intuitive for beginners and needs no commands learned. But it uses more memory and processing power.
Dialogue-based and gesture-based interfaces
Dialogue-based: the user speaks commands (voice control), useful when hands are busy, but less reliable in noisy places. Gesture-based: the user controls the device with movements such as swipes.
Name the five types of computer on the 0417 syllabus
Desktop, laptop, tablet, smartphone and phablet.
Desktop vs laptop
A desktop is the most powerful and upgradeable for its cost, but is not portable. A laptop has a built-in screen and keyboard and is portable, with moderate power and a battery.
Tablet vs smartphone
A tablet is very portable and touch-based with a longer battery life, but limited power for heavy tasks. A smartphone is the most portable and always with the user, but has the smallest screen and least power.
What is a phablet?
A device between a large smartphone and a small tablet in size, combining the uses of a phone and a tablet.
What is artificial intelligence (AI)?
Technology that lets a system appear to learn and make decisions rather than simply following a fixed set of instructions, e.g. voice assistants and recommendation systems.
Virtual reality vs augmented reality
Virtual reality (VR) places the user in a fully simulated environment. Augmented reality (AR) overlays digital information on the real world. Both are forms of extended reality (XR).
Give two uses of extended reality
Any two of: gaming, training simulations (e.g. pilots or surgeons), education, virtual tours, viewing products in your own room before buying.

Topic 2: Input and output devices

Name eight input devices on the 0417 syllabus
Any eight of: keyboard, numeric keypad, pointing devices (mouse, touchpad, tracker ball), remote control, joystick or driving wheel, touch screen, scanner, digital camera, microphone, sensors, light pen.
Why is a touch screen suitable for a public information kiosk?
It is intuitive and needs no training, and there are no loose parts such as a mouse or keyboard to be damaged or stolen.
Why are sensors used as input in monitoring and control?
They take continuous, automatic readings with no human error, even in places or at times a person could not.
Is a touch screen an input or an output device?
Both. It is input when the user makes a selection on it, and output when it displays an image or interface.
What is direct data entry?
Data is captured automatically by a device, without a person typing or clicking it in. It is faster, has a lower error rate and needs no one to read or interpret the data first.
OMR vs OCR
OMR (optical mark recognition) reads marks in set positions, e.g. a multiple-choice answer sheet. OCR (optical character recognition) reads printed or handwritten text and turns it into editable text.
Why is RFID preferred to a bar code for tracking a moving object?
An RFID tag is read by radio waves, so it needs no line of sight and can be read while the object moves or the tag is hidden, e.g. a hospital wristband.
Why is MICR used for bank cheques?
Magnetic ink characters are hard to forge and can be read reliably even when the cheque is dirty or creased.
Name six direct data entry devices
Magnetic stripe reader, chip and PIN reader, RFID reader, OMR reader, OCR reader, bar code reader, QR code scanner.
Laser vs inkjet printer
Laser: fast and low cost per page for high-volume printing, but dearer to buy. Inkjet: cheap to buy with good colour and photo quality, but slower and expensive per page for large volumes.
When is a dot matrix printer still used?
For multi-part carbon forms printed in one pass (e.g. a delivery note with copies), or in dusty, harsh places that would damage a laser or inkjet printer. It is noisy and low resolution.
What is a plotter used for?
Large-format, high-precision line drawings such as CAD plans, maps and posters.
What is an actuator?
An output device that turns an electrical signal into physical movement, e.g. opening a valve, moving a robot arm or starting a motor.
Name eight output devices on the 0417 syllabus
Any eight of: monitor, touch screen, multimedia projector, laser printer, inkjet printer, dot matrix printer, plotter, 3D printer, speaker, actuator.

Topic 3: Storage devices and media

Storage device vs storage media
A storage device is the hardware that reads and writes the data (e.g. a DVD drive). Storage media is the material the data is recorded onto (e.g. a DVD disc).
Magnetic storage: devices, strength and weakness
Devices: fixed and portable hard drives, tape drives. Strength: large capacity and low cost per GB. Weakness: slower access, and damaged by strong magnetic fields or shock.
Solid-state storage: devices, strength and weakness
Devices: SSDs, pen drives and flash drives. Strength: no moving parts, so fast and shock-resistant. Weakness: higher cost per GB.
Why does an SSD suit a laptop?
No moving parts, so it survives being carried and knocked; lower power use, so longer battery life; faster and silent. The trade-off is a higher price per gigabyte.
Name the media used in each storage family
Magnetic: magnetic hard disks and magnetic tape. Optical: CD, DVD and Blu-ray discs. Solid-state: memory cards such as SD, xD and CFast.
Order CD, DVD and Blu-ray by capacity
CD (smallest), then DVD, then Blu-ray (largest).
Why is magnetic tape still used for backups?
It has a very low cost per gigabyte at huge capacities. Its access is sequential, so finding one file is slow, but that is acceptable for long-term archiving.
Why might optical media be chosen deliberately?
Read-only and write-once (R) discs mean the data cannot be changed after writing. They are also cheap and widely compatible.

Topic 4: Networks and the effects of using them

What are the three functions of a router?
It connects networks and devices to the internet, stores computer addresses, and routes data packets to their destination.
Hub vs switch vs bridge
A hub sends data to every connected device. A switch learns which device is on which port and sends data only to the intended device. A bridge joins two network segments into one.
Wi-Fi vs Bluetooth
Wi-Fi connects a device to a wider network or the internet over a larger range. Bluetooth connects two devices directly over a short range, with no network needed, e.g. headphones.
Intranet vs extranet vs internet
Intranet: private, for one organisation only. Extranet: private network with controlled access for chosen outsiders such as suppliers. Internet: global and public.
LAN vs WLAN vs WAN
LAN: a small area such as one building, usually cabled. WLAN: the wireless version of a LAN. WAN: a large area joining LANs across sites, cities or countries; the internet is the largest WAN.
Cloud computing: one advantage and one disadvantage
Advantage: accessible from any device with an internet connection, with less need for local storage. Disadvantage: depends on a working connection and on a third party for security and availability.
What makes a password strong?
It is long, mixes character types (upper and lower case, numbers, symbols) and avoids personal information such as names or birthdates.
What are the three types of authentication factor?
Something you know (a password), something you have (a token or card) and something you are (a biometric). Combining them is multi-factor authentication.
What is zero login?
Authentication by passive signals, such as typing pattern, location or device recognition, with no active entry by the user.
Why must anti-malware software be kept up to date?
It relies on a database of known malware signatures, so it cannot recognise malware discovered after its last update.
Video- vs audio- vs web-conferencing
Video: camera, microphone, speakers and a fast connection; suits meetings where seeing people matters. Audio: voice only, lower bandwidth. Web: adds shared documents and screens for collaboration.

Topic 5: The effects of using IT

Name the five areas in which smart devices in the home affect people
Lifestyle, leisure time, physical fitness, security of data and social interaction.
Positive and negative effects of microprocessor-controlled devices in the home
Positive: more leisure time, remote monitoring and control, better home security. Negative: less physical activity, less face-to-face contact, dependence on technology, risk to data if a device is hacked.
Name the three areas for smart devices in transport
Security of data, autonomous vehicles and transport safety.
Give a positive and a negative effect of autonomous vehicles
Positive: less human error, and passengers can use travel time productively. Negative: job losses for professional drivers, safety questions in unusual situations, and risk if the control system is hacked.
RSI: cause and prevention
Repetitive strain injury is caused by repeated small movements such as typing and using a mouse. Prevent it with regular breaks, an ergonomic keyboard or mouse, and a wrist rest.
Back problems: cause and prevention
Caused by poor posture and an unsuitable chair or desk height. Prevent them with an adjustable chair, a screen at eye level and good posture.
Eye problems: cause and prevention
Caused by focusing on a screen for a long time, poor lighting and glare. Prevent them by looking away regularly, using an anti-glare screen and good lighting.
Headaches from IT use: causes and prevention
Causes: eye strain, glare, poor posture and dehydration. Prevention: regular breaks, adjusting screen brightness and contrast, and drinking water.

Topic 6: ICT applications

Newsletter or poster as communication media: advantage and disadvantage
Advantage: no device or internet is needed to view it. Disadvantage: it cannot be updated once distributed, has no interactivity, and has printing and distribution costs.
Website as a communication medium: advantages and disadvantages
It can be updated at any time, hold more content and link to further detail. But it only reaches people with a device and internet access, and they must choose to visit it.
Media streaming vs ePublication
Streaming plays audio or video as the data arrives, without storing the full file, so it needs an ongoing connection. An ePublication is downloaded as a complete file and can then be read offline.
How does VoIP differ from a standard phone call?
VoIP carries voice as data over the internet, not over a dedicated voice channel. It can be much cheaper, especially internationally, but call quality depends on the internet connection.
What is a computer model?
A computer representation of a real system, using data and rules, that predicts what would happen when the inputs change, so "what if" questions can be tested.
Give four uses of computer modelling on the 0417 syllabus
Any four of: personal finance, bridge and building design, flood water management, traffic management, weather forecasting.
Give three advantages of using a computer model
It is cheaper and safer than building or testing the real thing; many "what if" scenarios can be tried quickly; time can be speeded up to see long-term results; it can test situations too dangerous to try for real.
Give two disadvantages of a computer model
It is only as good as the data and rules used, so it may not reflect reality; complex models can be costly to build and need powerful computers and skilled staff.
Give three uses of computer-controlled systems
Any three of: robots in manufacturing (welding, paint spraying, assembly), production line control, autonomous vehicles, automatic warehouses.
Advantages of robots on a production line
They work non-stop without breaks, give consistent quality, are accurate, and can work in conditions that are dangerous to people.
Disadvantages of computer-controlled manufacturing
High set-up and maintenance cost, job losses for unskilled workers, robots cannot easily cope with unexpected situations, and a fault can stop the whole line.
What can a school management system be used for?
Registering attendance, recording and analysing learner performance, organising examinations and creating timetables.
Name three ways a school can register attendance automatically
Any three of: magnetic stripe cards, RFID (smart) cards, biometrics such as fingerprints or face recognition.
Why use biometrics rather than swipe cards for registration?
A biometric cannot be lost, forgotten or lent to another learner, so it is more reliable and secure. It costs more and raises privacy concerns about storing personal data.
Give four uses of online booking systems
Any four of: travel (flights, trains, holidays), concerts, cinemas, theatres, sporting events.
Advantages of online booking for the customer
Book at any time from anywhere; see availability and choose seats; compare prices; receive an e-ticket by email or phone; no queues.
Disadvantages of online booking
Needs a device and internet access; risk of fraud or hacking of payment details; no face-to-face help; some sites charge booking fees.
How does an online booking system prevent double booking?
When a seat is selected it is held, and once payment is confirmed the database is updated at once so the seat shows as unavailable to every other user.
What is electronic funds transfer (EFT)?
Moving money electronically from one bank account to another, e.g. for paying wages, with no cash or paper changing hands.
Give four things a customer can do at an ATM
Withdraw cash, check the account balance, deposit cash or cheques, print a mini statement, change the PIN, pay bills or top up a phone.
Internet banking: advantages and disadvantages
Advantages: bank at any time, no travel, easy to check accounts and pay bills. Disadvantages: risk of hacking and phishing, needs internet access, no face-to-face service, less social contact.
Describe the steps in withdrawing cash at an ATM
The card is inserted and read; the PIN is entered and checked; the amount is chosen; the bank checks the balance; if there is enough money, the account is debited, the card is returned and the cash is issued.
What information systems are used in medicine?
Patient records (details, history, tests, treatments) and pharmacy records (prescriptions, drug stock, checks for drug interactions and allergies).
Give four uses of 3D printing in medicine
Any four of: prosthetics, surgical and diagnostic aids (models of organs to plan operations), tissue engineering, artificial blood vessels, customised medicines.
Why are 3D-printed prosthetics an advantage?
They can be made to fit the individual exactly, quickly and at lower cost than traditional methods, and replaced easily as a child grows.
What is an expert system?
A computer system that copies the knowledge and reasoning of a human expert to give advice or a diagnosis in one subject area.
Name the five parts of an expert system
User interface, inference engine, knowledge base, rules base and explanation system.
Give five uses of expert systems
Any five of: medical diagnosis, car engine fault diagnosis, mineral prospecting, financial planning, chess games, route scheduling for deliveries, plant and animal identification.
What does the explanation system do?
It tells the user how the expert system reached its conclusion, often with the probability that the conclusion is correct.
What is a point-of-sale (POS) terminal?
A checkout till that reads bar codes, looks up each item's price and description in the stock database, adds up the bill, takes payment and prints a receipt.
How does automatic stock control work?
Each sale reduces the stock level in the database. When stock falls to the reorder level, the system automatically orders more from the supplier.
How does contactless card payment work?
The card or phone is held near the reader, which uses RFID or NFC to read the card details. No PIN is needed for small amounts, so it is fast, but a lost card could be misused up to the limit.
Internet shopping: advantages and disadvantages for the customer
Advantages: shop at any time, wider choice, easy price comparison, home delivery. Disadvantages: risk of fraud, cannot see or try goods, delivery costs and waits, needs internet access.
Name five recognition systems on the 0417 syllabus
OMR, OCR, bar code and QR code readers, RFID, and biometric recognition. ANPR (automatic number plate recognition) is a use of OCR.
How does automatic number plate recognition (ANPR) work?
A camera captures an image of the vehicle; software finds the number plate and uses OCR to read the characters; the number is checked against a database, e.g. to open a car park barrier.
Give two uses of QR codes
Any two of: linking to a website or app, adverts, boarding passes and e-tickets, making payments, product information in shops.
Biometric recognition: advantages and disadvantages
Advantages: cannot be forgotten, lost or shared; hard to forge. Disadvantages: expensive equipment, can fail (e.g. a cut finger or poor lighting), and privacy concerns about storing personal data.
How does GPS work out a position?
Satellites send signals with the exact time they were sent. The receiver uses the time each signal takes to arrive to find its distance from at least three satellites, and from these calculates its position.
Satellite navigation: advantages and disadvantages
Advantages: no paper maps, live route and traffic updates, estimated arrival time, fewer people getting lost. Disadvantages: maps may be out of date, signal loss in tunnels or cities, over-reliance by drivers.
What is a geographic information system (GIS)?
A system that captures, stores and displays data linked to locations, building up layers of information on a map, e.g. for planning or emergency services.
What are media communication satellites used for?
Satellite television, satellite phones and internet links, and relaying news broadcasts across the world.

Topic 7: The systems life cycle

Name four methods of researching the current system
Observation, interviews, questionnaires and examining existing documents.
Observation vs interviews
Observation shows what really happens, but staff may behave differently when watched. Interviews give detailed answers with follow-up questions, but take time, so only a few people can be asked.
Questionnaires: advantage and disadvantage
Many people can answer quickly and the results are easy to analyse. But answers may be rushed or untruthful, the response rate may be low and no follow-up questions are possible.
What is a requirements specification?
The agreed list of what the new system must do, produced at the end of analysis, along with the inputs, outputs and processing needed.
What is produced at the design stage?
Data capture forms and screen layouts, report layouts, the file or database structure (field names, data types, lengths, key field), validation routines, verification methods, choice of hardware and software, and a test plan.
Name six validation checks
Range check, length check, type check, presence check, format check and check digit.
Validation vs verification
Validation checks that data is sensible and allowed, but not that it is correct. Verification checks that data has been copied accurately from the source, by visual checking or double data entry.
Normal, abnormal and extreme test data
Normal: valid data that should be accepted. Abnormal: invalid data that should be rejected. Extreme: the largest and smallest valid values, at the edge of the range (some mark schemes say boundary).
A field accepts ages 11 to 16. Is 17 extreme or abnormal data?
Abnormal. It is outside the range, so it should be rejected. The extreme values are 11 and 16, which should be accepted.
What is live data?
Real data whose results are already known from the old system, used to test the new system after testing with test data.
What does a test plan contain?
Each test, the data to be used, the expected result and, once run, the actual result, so the two can be compared.
Direct changeover: advantage and disadvantage
The old system stops and the new one starts at once. It is quick and cheap, but if the new system fails there is nothing to fall back on.
Parallel running: advantage and disadvantage
Both systems run side by side. It is the safest, as results can be compared and the old system is a backup, but it is the most expensive because all work is done twice.
Phased implementation vs pilot running
Phased: the new system is introduced one part at a time, so problems affect one part only, but the change takes longer. Pilot: the whole system is tried in one branch first, so failure affects only that branch.
Why would a hospital avoid direct changeover for patient records?
If the new system failed there would be no working backup, putting patient safety at risk.
Who is technical documentation for, and what does it contain?
For the people who maintain or upgrade the system. It contains the purpose of the system, hardware and software requirements, flowcharts, program listings, file structures, input and output formats, validation rules and test results.
Who is user documentation for, and what does it contain?
For the people who use the system. It contains how to log in and use the features, example screens, error messages and what to do, troubleshooting tips and FAQs.
Give two items in technical documentation but not usually in user documentation
Any two of: flowcharts, program listings, file structures, hardware requirements, validation rules.
What is checked when a new system is evaluated?
Whether it meets the requirements in the original specification, how easy it is to use, how efficient it is, user satisfaction and the appropriateness of the solution.
What evidence is used in an evaluation?
A comparison of results with the requirements specification, user feedback (e.g. questionnaires) and test results.
What happens after evaluation finds limitations?
Improvements are proposed, which can start the analysis stage of the next version, which is why the stages form a cycle.

Topic 8: Safety and security

Trailing cables: harm and prevention
People trip and are injured, or equipment is pulled down. Prevent it with cable ducts or covers, tidy cable routes or wireless connections.
Overloaded sockets: harm and prevention
They can cause a fire. Limit the number of devices per socket, check cables and use surge protectors.
Liquids and exposed wires near computers: harm and prevention
Electric shock, electrocution or short circuits. Ban drinks and food near equipment, and have equipment tested regularly by qualified staff.
Which fire extinguisher is used for an electrical fire?
Carbon dioxide (CO₂) or dry powder, never water.
Why should personal data be kept private online?
Details such as name, address, school, photos or bank details can be used for identity theft, fraud, or to find and harm a person.
Give four eSafety rules for social media
Block and report unwanted users; be aware of the danger of meeting an online contact face to face; do not distribute inappropriate images or use inappropriate language; respect the confidentiality of other people's personal data.
How can you check a website is safe for personal details?
Check that the address starts with https and shows a padlock, and only use trusted, reputable sites. The padlock shows the connection is encrypted, not that the site is honest.
Why is data protection legislation needed?
Organisations hold large amounts of personal data that could be misused, lost or disclosed. The law sets principles, e.g. data must be used only for its stated purpose, kept accurate, kept secure and not kept longer than necessary.
Personal data vs sensitive data
Personal data identifies a living person (name, address, date of birth, a photo in school uniform). Sensitive data, such as medical history, could cause more harm if disclosed. Both must be kept confidential.
Two eSafety rules for online gaming
Do not use your real name, and do not give out personal or financial data.
Phishing vs pharming
Phishing: a fake email or message tricks the user into giving details, often via a link to a fake site. Pharming: malicious code redirects the user to a fake website even when the correct address is typed.
What are smishing and vishing?
Phishing carried out by SMS text message (smishing) and by voice call (vishing).
What does a firewall do, and what does it not do?
It monitors network traffic and blocks unauthorised or suspicious traffic in and out. It does not remove viruses; anti-malware software does that.
Does encryption stop data being intercepted?
No. It scrambles data so that intercepted data cannot be read without the key.
Why does two-factor authentication improve security?
A password alone is not enough: the attacker also needs a second item, such as a code sent to the user's phone.
What are the three types of card fraud named in the 0417 syllabus?
Shoulder surfing (watching someone enter a PIN), card cloning (copying a card's data with a skimmer to make a duplicate) and key logging (software that records keystrokes).
What does a digital certificate contain?
The owner's name, a serial number, an expiry date, the owner's public key and the digital signature of the certificate authority. It proves a website is genuine.
What does SSL do?
Secure socket layer sets up an encrypted link between the server and the client computer, so intercepted data cannot be read. Shown by https and a padlock.
Where is encryption used to protect data?
On hard discs, in email, in cloud storage and on HTTPS websites.
How do you avoid infecting a computer from a downloaded file?
Only download from trusted sources, scan the file with up-to-date anti-virus software before opening it, and do not open attachments from unknown senders.

Topic 9: Audience

What is audience appreciation?
Understanding who will read, view or use your work and adapting it to their age, knowledge, interests, needs and setting.
How should a document for children aged 6 to 8 be designed?
Large rounded font, bright colours, large pictures, simple words and short sentences, with one idea per page.
How should work be adapted for people with a visual impairment?
Use high contrast, large fonts and alt text for images.
How do you earn the mark when describing a design feature for an audience?
Give the feature and a reason linked to the named audience, e.g. "large photographs of animals, because they keep children interested". A feature with no reason earns no mark.
What is copyright?
A legal right that protects the creator of an original work (text, images, music, video, software) and gives them control over how it is copied, shared and sold.
Does naming the source make it legal to use a copyrighted image?
No. Giving credit does not replace permission. You need the owner's permission or a licence that allows reuse.
Give four ways software makers try to prevent illegal copying
Any four of: licence agreements, product keys or activation codes, needing the original disk or an online check, holograms, digital rights management (DRM), watermarks.
Give two risks of using pirated software
It may contain malware, and it gets no updates or support. The user may also face fines or prosecution.

Topic 10: Communication

Cc vs Bcc
Cc (carbon copy) recipients can be seen by everyone who gets the email. Bcc (blind carbon copy) recipients are hidden from the other recipients.
When should Bcc be used?
When emailing a large group, such as all parents, so that their email addresses are not revealed to each other.
What is netiquette? Give two rules for email
The accepted rules of polite behaviour online. E.g. use a clear subject line, be polite and brief, do not write in capitals (it looks like shouting), check spelling, do not copy people in unnecessarily.
What is spam, and how can you reduce it?
Unsolicited junk email sent in bulk. Reduce it with a spam filter, by not publishing your address on websites, not replying to spam and giving your address only to trusted sites.
Internet vs World Wide Web
The internet is the worldwide network of networks. The World Wide Web is the collection of web pages accessed through it using a web browser.
How do you make a web search more effective?
Use specific keywords, quotation marks for an exact phrase, AND, OR and NOT, and advanced options such as date or file type. Look beyond the first results and refine the search.
What does AND do in a search, and what does OR do?
AND narrows a search: both terms must appear. OR widens it: either term may appear. NOT excludes a term.
How can you judge whether a website is reliable?
Check who wrote it and their expertise, when it was published or updated, whether it is biased or selling something, and whether other reliable sources agree. A domain ending is a hint, not proof.

Topic 11: File management

What makes a good file name?
It describes the content, avoids unusual symbols, and may include a version number or date, e.g. Year9_Geography_Draft2.docx.
Save vs Save as
Save overwrites the current file. Save as creates a new file with a different name, location or format, keeping the original.
What is a generic file format? Give examples
A format that many different programs can open, not tied to one manufacturer, e.g. .csv, .txt, .rtf and .pdf.
Why is a backup on the same hard drive not enough?
If the drive fails, both copies are lost. A backup should be on a different device or in a different place, such as an external drive or cloud storage.
Lossless vs lossy compression
Lossless keeps all the data so the original can be rebuilt exactly (ZIP, PNG, GIF). Lossy permanently removes data people are least likely to notice, giving much smaller files (JPEG, MP3, MP4).
Name four ways to reduce a file's size
Compress it; reduce an image's resolution, dimensions or colour depth; crop it or shorten audio and video; reduce the bit rate or sample rate; save in a more efficient format.
How long does a 6 MB file take to send at 12 megabits per second?
6 MB × 8 = 48 megabits. 48 ÷ 12 = 4 seconds.
Which format suits a logo with flat colours and a transparent background?
PNG: it is lossless, so sharp edges stay crisp, and it supports transparency.

Topic 12: Images

Why keep the aspect ratio locked when resizing an image?
It keeps the width and height in proportion. Changing them by different amounts stretches or squashes (distorts) the picture.
An image of 3200 × 2400 pixels is resized to 800 pixels wide, keeping its proportions. What is its new height?
Scale factor 800 ÷ 3200 = 0.25, so the height is 2400 × 0.25 = 600 pixels.
What does text wrapping control? Name three options
How the surrounding text behaves around an image. Options: in line with text, square, tight, top and bottom, behind text, in front of text.
What is cropping?
Removing unwanted edges of an image to change what is visible, without stretching it.
How do you calculate the size of an uncompressed image in bytes?
Width × height × bits per pixel ÷ 8.
Name four ways to reduce an image's file size
Resize it to smaller pixel dimensions; crop it; reduce the resolution; reduce the colour depth; save it in a compressed format such as JPEG.
What is the trade-off when reducing an image's file size?
Quality falls: an image that is too small or too compressed looks blurred or blocky when enlarged or printed.
Why save a reduced image under a new name?
So the original full-quality image is kept and can be used again later.

Topic 13: Layout

Portrait vs landscape orientation
Portrait is taller than it is wide. Landscape is wider than it is tall.
Page break vs column break vs section break
A page break starts a new page. A column break moves text to the next column. A section break allows different settings, such as columns or orientation, in different parts.
A4 is 21 cm wide with 2.5 cm side margins. How wide is each of three columns with 0.8 cm gaps?
Text width 21 − 5 = 16 cm. Two gaps = 1.6 cm. 16 − 1.6 = 14.4 cm ÷ 3 = 4.8 cm per column.
Why use tab stops instead of the space bar to line up text?
Tab stops align text at exact positions (decimal tabs line up numbers), and the alignment stays correct when fonts or text change. Spaces give uneven results.
What is a cell in a table?
The box where a row and a column meet.
How do you make a table title span the whole table?
Merge all the cells in the first row into one cell.
How should text and numbers be aligned in a table?
Text left-aligned; numbers right-aligned or decimal-aligned so the decimal points line up; headings centred if asked.
Name four ways a table can be formatted
Any four of: column width and row height, borders, shading, merging or splitting cells, inserting or deleting rows and columns, sorting, aligning the table on the page.
What are a header and a footer?
Text or images in the top (header) or bottom (footer) margin that repeat automatically on every page.
Name four automatic fields that can go in a header or footer
Page number, total number of pages, date and time, file name and file path.
Why must page numbers be inserted as an automatic field?
A field updates itself on each page. A number typed by hand shows the same number on every page.

Topic 14: Styles

What is a style?
A saved set of formatting, such as font, size, colour, alignment and spacing, applied to text or another object in one step.
Paragraph style vs character style
A paragraph style applies to a whole paragraph (e.g. Heading 1, Body Text). A character style applies to selected words only.
Why use styles instead of formatting by hand?
Formatting is consistent and faster to apply; editing a style updates every paragraph that uses it; heading styles can build a contents list automatically.
Why name a style by purpose (Caption) rather than appearance (BigBlue)?
The appearance may change later, which would make a name like BigBlue misleading.
What is a corporate house style?
A set of rules an organisation uses for all its documents (logo, colours, fonts, layout) so they look consistent and are instantly recognisable as the organisation's.
Name five elements of a corporate house style
Any five of: logo position and size, colour scheme, fonts and sizes, margins and alignment, header and footer layout, slogan, standard wording, chart and image style.
How is a house style usually built into software?
As a template containing the saved styles, header and footer, logo and page setup, so a user can write without formatting from scratch.
Give two benefits and one drawback of a house style
Benefits: professional, consistent documents; easy brand recognition; less time spent formatting. Drawback: it limits creativity, and every document must be updated if the style changes.

Topic 15: Proofing

Why might a spell checker miss an error?
It only checks each word against a dictionary, so a real word used wrongly (there for their, form for from) passes. It also ignores numbers such as a wrong date.
What does a grammar checker look for?
Problems in sentence structure: verbs not agreeing with subjects, missing capitals, repeated words and over-long sentences. Its suggestions are not always right.
Name four other software proofing tools
Any four of: thesaurus, word count, find and replace, automatic correction, show formatting marks, track changes and comments, validation.
What can validation not do?
It cannot check that data is correct, only that it is reasonable. A mark of 68 typed as 86 still passes a range check of 0 to 100.
Name four proofreading techniques
Read slowly, line by line, or aloud; compare with the source item by item; check consistency of fonts and spacing; check numbers, dates and names; use print preview; ask another person to read it.
What are visual verification and double data entry?
Visual verification: reading the entered data against the original. Double data entry: the data is entered twice and the computer compares the two, reporting any differences.
What are widows and orphans?
Single lines of a paragraph left alone at the top or the bottom of a page.

Topic 16: Graphs and charts

Which chart type should you use for each purpose?
Bar or column: comparing categories. Line graph: change over time. Pie chart: parts of a whole. Scatter graph: whether two sets of numbers are related.
Why should you not include the Total row when selecting chart data?
It appears as an extra category (a huge bar or sector) and distorts the chart.
Name five labels a chart may need
Chart title, axis titles (with units), legend (when there is more than one series), data labels, category labels.
When is a legend needed on a chart?
When there is more than one data series, to show what each colour or line represents. It can be removed for a single series.
Books 120, Games 90, Music 60, Toys 30. What angle is the Books sector of a pie chart?
Total = 300. Books = 120 ÷ 300 = 40%, and 0.40 × 360° = 144°.

Topic 17: Document production

Why set page size and orientation before typing?
Changing them later can move tables and images and spoil the layout.
How do you put a full-width heading above a two-column article?
Insert a continuous section break after the heading, so only the article below is set in columns.
What is a margin?
The blank space between the text and the edge of the paper, set separately for top, bottom, left and right.
Name the four types of text alignment
Left, right, centred and justified (lined up with both margins).
When should you use bullets and when numbering?
Bullets for items in no set order; numbering for steps or ranked items where order matters.
Serif vs sans-serif fonts
Serif fonts, such as Times New Roman, have small strokes on the ends of letters. Sans-serif fonts, such as Arial, do not.
First-line indent vs hanging indent
A first-line indent moves only the first line of a paragraph in. A hanging indent leaves the first line out and indents the following lines.
Replace vs Replace all
Replace changes one occurrence at a time. Replace all changes every occurrence at once.
What do "match case" and "find whole words only" do?
Match case makes the search case-sensitive, so Park does not match park. Whole words only stops a search for art matching inside party or start.
What is the danger of Replace all?
Without whole-word matching, it can damage other words, e.g. replacing "it" also changes "with" and "little". Check the result afterwards.
What is a bookmark in a document?
A named place in a document that you can jump back to or link to.
How is a table of contents created automatically?
From the headings formatted with heading styles. It lists them with page numbers and can be updated after changes.
What can a hyperlink in a document link to?
A bookmark or section in the same document, another file, or a web page.
What is pagination?
Dividing a document into pages and controlling where the pages break.
Why use a page break instead of blank lines?
Blank lines move when text is edited, so the new page starts in the wrong place. A page break always starts the next text on a new page.
What does "keep with next" do?
It keeps a heading on the same page as the paragraph after it, so the heading is not left alone at the bottom of a page.
What is a gutter margin?
Extra space added on the inside edge of the page, where it will be bound, so text is not lost in the binding. It is added to the normal margin.
A left margin of 3 cm has a 1 cm gutter on A4 (21 cm) with a 2 cm right margin. How wide is the text?
Text starts 3 + 1 = 4 cm from the left edge. Width = 21 − 4 − 2 = 15 cm.
Where is the gutter with mirrored margins?
On the left of right-hand pages and on the right of left-hand pages, used for booklets and double-sided printing.

Topic 18: Databases

Name the field data types used in 0417 databases
Text (alphanumeric), numeric (integer or real), currency, date/time and Boolean (logical, yes/no).
Primary key vs foreign key
A primary key has a unique value in every record, so each record can be identified. A foreign key is a field in one table that matches the primary key of another, linking the tables.
What is a relational database, and why use one?
A database with more than one linked table. It avoids repeating the same details in many records, which saves space and reduces errors.
What is a lookup check?
A validation check that the value entered comes from a given list, such as a drop-down menu.
What must you check when importing a CSV file into a database?
The correct delimiter, whether the first row holds field names, and that each field has the right data type (e.g. a date not imported as text).
"More than 10" vs "at least 10" as search criteria
More than 10 is > 10 and excludes 10. At least 10 is >= 10 and includes 10.
What is a wildcard in a database search?
A symbol that matches part of a text value. In many systems * stands for any number of characters, so S* finds every entry starting with S.
What is a calculated field, and where is it created?
A new value worked out from other fields, e.g. Price * InStock. It is created in a query and calculated when the query runs, not stored in the table.
Which criteria find fiction books that are in stock?
Genre = "Fiction" AND InStock > 0. AND is used because both conditions, on different fields, must be true.
What is a database report?
A formatted printout of data, usually based on a query, with a title, only the fields required, readable headings and, if needed, grouping and totals.
Give three common mistakes in a database report
Truncated field headings or data, extra fields not asked for, fields in the wrong order, or a missing title or total.
Name three summary calculations a report can show
Any three of: sum (total), count, average, minimum, maximum.

Topic 19: Presentations

What is a slide layout?
A pattern of placeholders for a slide's title, text, images, charts or tables. Placeholders keep their position and style linked to the master slide.
Transition vs animation
A transition is the effect when one slide changes to the next. An animation controls how objects on a slide appear, move or disappear.
What do hyperlinks and action buttons allow in a presentation?
Links to another slide, a file or a web page, so the presentation can be non-linear, e.g. with a home or back button.
Why should transitions and animations be used sparingly?
Too many different effects distract the audience from the message. Use the same transition throughout unless told otherwise.
What is a master slide?
A template that controls the appearance of every slide based on it. Anything set on the master appears automatically on all those slides.
What is normally set on a master slide?
Fonts, sizes and colours for titles and text, bullet styles, background, a logo in a fixed position, slide numbers, date and footer text, and placeholder positions.
Why use a master slide?
Consistency and speed: every slide matches, and one change on the master updates all slides.
What are speaker notes?
Notes attached to each slide for the presenter. They are not shown on screen to the audience but can be printed.
How do you reorder slides?
Drag them into the new order in the slide sorter view or the outline pane.
Why use alignment tools when editing a slide?
They line objects up exactly and space them evenly, which is more accurate than positioning by eye.
Name four ways a presentation can be output
Slide show, printed slides, handouts (several slides per page), notes pages, outline (text only), or a file such as PDF.
Handouts vs notes pages
Handouts show several slides per page (e.g. 2, 3, 4 or 6) for the audience to take away. Notes pages show each slide with the speaker notes below it.
12 slides advance every 25 seconds. How long is the show, and how many pages for 6-per-page handouts?
12 × 25 = 300 seconds = 5 minutes. 12 ÷ 6 = 2 pages.
Why save a presentation as a PDF to share it?
A PDF opens the same on any device without the presentation software, though it can no longer be edited easily.

Topic 20: Spreadsheets

What is a spreadsheet data model?
A spreadsheet set up so that changing an input changes the outputs automatically, so "what if" questions can be tested.
Relative vs absolute cell references
A relative reference (C4) changes when the formula is copied. An absolute reference ($C$4) stays fixed. A mixed reference (C$4 or $C4) fixes only the row or the column.
Why does =D2/$D$7 use dollar signs?
So that when the formula is copied down, every row still divides by the same total in D7, while D2 changes to D3, D4 and so on.
What does =IF(D7>150,D7*0.1,0) return when D7 is 168?
The condition is true, so it returns 168 × 0.1 = 16.8.
What does VLOOKUP do?
It searches the first column of a table for a value and returns the item from a chosen column in the same row. HLOOKUP does the same across rows. Use exact match (FALSE) for codes.
COUNT vs COUNTA vs COUNTIF
COUNT counts cells containing numbers. COUNTA counts non-empty cells. COUNTIF counts only cells that meet a condition, e.g. =COUNTIF(D2:D6,">35").
What is a named range, and why use it?
A meaningful name given to a cell or range, such as VATRate. It makes formulas easier to read and check.
Why select the whole data range before sorting?
If only one column is sorted, the other columns stay where they are and the rows are scrambled.
Sort vs filter
A sort rearranges rows into ascending or descending order. A filter hides rows that do not meet the criteria without deleting them.
What is conditional formatting?
Formatting that changes a cell's appearance automatically when it meets a rule, e.g. shading marks below 40 red.
What does a cell full of hash symbols (####) mean?
The column is too narrow to display the value. Widen the column.
Name five number formats for spreadsheet cells
Integer, a set number of decimal places, percentage, currency, date and time.
Why print a spreadsheet with formulas showing?
It shows the examiner, or a checker, that results come from formulas and cell references rather than typed-in values.

Topic 21: Website authoring

Name the three web development layers and the language for each
Content layer: HTML (text, images and structure). Presentation layer: CSS (colours, fonts, layout). Behaviour layer: usually JavaScript (what happens when the user interacts).
Why separate content from presentation?
The look of a whole site can be changed by editing one stylesheet without touching the content, and the same content can be styled differently for phones and desktops.
Which layer would validate a form or show a menu?
The behaviour layer.
What goes in the head section and the body section of an HTML page?
Head: information about the page, such as its title (shown on the browser tab) and links to stylesheets. Body: everything visible on the page.
Which HTML elements make bulleted and numbered lists?
ul makes an unordered (bulleted) list and ol an ordered (numbered) list. Each item goes in an li element.
What are the src and alt attributes of an img element?
src gives the image file's location. alt gives text shown if the image fails to load and read aloud by screen readers.
Why use relative file paths such as images/logo.png?
They still work when the site's folder is moved to a web server. Absolute paths such as C:\Users\... break on another computer.
Which elements build an HTML table?
table for the table, tr for each row, th for header cells and td for data cells.
What are the parts of a CSS rule?
A selector (what to style) and declarations inside curly brackets, each a property, a colon, a value and a semicolon, e.g. h1 { color: navy; }.
External vs internal vs inline CSS
External: rules in a separate .css file linked from each page; best for a whole site. Internal: rules in a style element in the page head; that page only. Inline: a style attribute on one element.
Class selector vs id selector
A class (.note) can be used on many elements on a page. An id (#banner) applies to one element only, because an id must be unique.
CSS margin vs padding
Margin is the space outside an element's border. Padding is the space inside, between the border and the content.
When CSS rules conflict, which wins?
The more specific rule. An inline style overrides internal and external rules for that element.