Answer
Free flashcards · Cambridge A Level · 9626
Information Technology flashcards
193 cards covering every topic of the 9626 syllabus (2025-2027). 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.
Choose your cards
Session complete
Worth another look:
All 193 cards
For a quick read-through or printing. Cover the right-hand side to test yourself.
AS Topic 1: Data processing and information
- Data vs information
- Data: raw facts and figures with no context, e.g. 37, Smith, 2410. Information: data given context and meaning, e.g. "Patient Smith's temperature is 37 °C".
- Direct vs indirect data sources
- Direct data is collected for the purpose at hand (questionnaires, interviews, data logging, observation). Indirect data was collected for another purpose and reused (census data, the electoral register, weather data).
- Direct data: advantages and disadvantages
- Relevant, current, of known accuracy and in the required format. But costly and slow to gather, and may need a large sample.
- Name five factors that affect the quality of information
- Accuracy, relevance, age, level of detail and completeness.
- Symmetric vs asymmetric encryption
- Symmetric: one secret key both encrypts and decrypts, so it must be shared securely; fast, but key sharing is the weak point. Asymmetric: a public key encrypts and only the matching private key decrypts; solves key sharing but is slower.
- Validation vs verification
- Validation: an automatic check that data is reasonable and of the correct type; it cannot show data is correct. Verification: a check that data has been accurately entered, transferred or copied.
- Consistency check vs limit check
- Consistency: one field is checked against another for a logical match, e.g. a start date before an end date. Limit: a value is checked against one boundary only, e.g. no more than 60 hours.
- Hash total vs control total
- Both are totals compared before and after data entry or transfer. A hash total has no meaning (e.g. a sum of employee numbers); a control total is meaningful (e.g. total hours worked in a batch).
- Batch vs online vs real-time processing
- Batch: data collected and processed later as a group (payroll, utility bills). Online: each transaction is processed as entered while the user waits (online shopping, EFT). Real-time: processed at once and the output affects the input (central heating, traffic lights).
AS Topic 2: Hardware and software
- Mainframe vs supercomputer: what is each built for?
- A mainframe is built for high-volume transaction throughput (e.g. census and transaction processing). A supercomputer is built for raw processing speed (e.g. weather forecasting, quantum mechanics).
- What does RAS stand for?
- Reliability (how rarely it fails), availability (how much of the time it can be used) and serviceability (how quickly and easily it is repaired). It applies to both mainframes and supercomputers.
- What is fault tolerance?
- The ability of a system to keep running, often in a reduced state, when a component fails.
- MIPS vs FLOPS
- MIPS (millions of instructions per second) is usually quoted for a mainframe's transaction workload. FLOPS (floating-point operations per second) is usually quoted for a supercomputer's calculation-heavy workload.
- Name the types of system software on the 9626 syllabus
- Compilers, interpreters, linkers, device drivers, operating systems and utilities.
- Compiler vs interpreter
- A compiler translates and stores the whole program before it is executed. An interpreter translates and executes it line by line, which is why code under development is often run through an interpreter.
- What is a cross compiler?
- A compiler that runs on one type of computer but produces machine code for a different type of computer.
- How can one high-level program run on different computer systems?
- Through interpreters (the same source code runs anywhere a suitable interpreter exists) or cross compilers (machine code is produced for each target system).
- Name six types of utility software on the 9626 syllabus
- Any six of: anti-virus, back-up, data compression, disk defragmentation, formatting, file copying and deleting, file management systems, disk management systems.
- Name the three levels of disk formatting
- Low-level formatting, partitioning and high-level formatting.
- System software vs utility software
- System software manages or translates for the computer itself. Utility software performs a specific maintenance task, such as defragmenting a disk or making a back-up.
- Off-the-shelf software: advantages and disadvantages
- Lower cost, available immediately and well tested by many users. But it may include features that are not needed and cannot be tailored exactly to the organisation.
- Custom-written software: advantages and disadvantages
- It matches the exact requirements and can be adapted as needs change. But it costs more, takes time to develop and depends on ongoing support from the developer.
- Proprietary vs open-source software
- Proprietary software is owned by a company; its source code is kept private and use is licensed. Open-source software has publicly available source code that users can study, change and share.
- Name the four types of user interface on the 9626 syllabus
- Command line, graphical, dialogue and gesture-based.
- Who would a command line interface suit, and why?
- A systems administrator managing many servers: it is fast, precise and scriptable. It would not suit untrained users, who cannot be expected to know the commands.
- Why does a graphical interface suit a public museum kiosk?
- It needs no knowledge of commands and gives immediate visual feedback, so visitors of all ages can use it without training.
AS Topic 3: Monitoring and control
- Monitoring vs control
- Monitoring reads and records values for a person to review, e.g. a weather station logging humidity. Control triggers an automatic response with no human decision, e.g. a greenhouse vent opening at a set temperature.
- Name eight sensors on the 9626 syllabus
- Any eight of: light/UV, temperature, pressure, humidity, pH, gas (oxygen, CO₂, CO, nitrogen oxides), sound, infrared, touch, (electro)magnetic field, proximity.
- One-point vs two-point vs multipoint calibration
- One-point: checks against one known reference value. Two-point: checks at a low and a high point, correcting offset and scale error. Multipoint: checks several points, for the highest accuracy when the response is not linear.
- Why must a working sensor still be calibrated?
- It may respond to changes but give every reading shifted by a consistent offset. Only comparing it with a known reference corrects this systematic error; repeated readings do not.
- Describe the sensor-microprocessor-actuator loop in a greenhouse vent system
- A temperature sensor takes a reading; the microprocessor compares it with a stored threshold; if it is higher, an actuator opens the vent; the sensor is checked continuously and the vent closes when the temperature falls.
- Name six types of actuator on the 9626 syllabus
- Any six of: linear, rotary, soft, hydraulic, pneumatic, electric, thermal, magnetic, mechanical.
- Which sensor would detect an intruder's body heat in a burglar alarm, and which a phone held to the ear?
- Body heat: an infrared sensor (no contact needed). Phone near the ear: a proximity sensor.
- Why is a control system called a closed loop?
- After acting, it keeps re-checking the sensor, so the output affects the next input. It does not act once and stop.
AS Topic 4: Algorithms and flowcharts
- What is a rogue value?
- A value that marks the end of the data, such as -1 or 0, and is not processed.
- WHILE ... ENDWHILE vs REPEAT ... UNTIL
- WHILE tests at the start and continues while the condition is true, so it may run 0 times. REPEAT tests at the end and continues until the condition is true, so it always runs at least once.
- Which loop would you use to re-ask for a PIN until it is valid, and why?
- REPEAT ... UNTIL, because the PIN must be asked for at least once and the test comes after the input.
- What values does FOR K ← 2 TO 20 STEP 6 produce?
- 2, 8, 14 and 20: four passes.
- IF vs CASE
- IF tests any condition. CASE matches the value of one variable against a list of values, with OTHERWISE catching anything not listed.
- What is a nested loop? How many times does the inner body run for an outer loop of 5 and inner of 3?
- A loop inside another loop; the inner loop runs fully on every pass of the outer one. 5 × 3 = 15 times.
- Which flowchart symbols are used for a subroutine and a connector?
- Subroutine: a rectangle with double vertical lines at the sides, holding the procedure's name. Connector: a small circle with a letter, linking two parts of a chart.
- How do you process data ending in a rogue value with a WHILE loop?
- INPUT the first value before the loop; loop WHILE the value is not the rogue value; process it, then INPUT the next value as the last line of the loop body.
- What is a trace table?
- A table that records the value of each variable after each step, used to test an algorithm.
AS Topic 5: eSecurity
- What is personal data?
- Information about a living person who can be identified from it, alone or combined with other data, e.g. name, address, date of birth, bank details, medical records.
- Anonymising vs aggregating data
- Anonymising removes or replaces identifiers such as name and ID number from each record. Aggregating combines many records into totals or averages so no individual record is shown.
- What is a geotag, and why is it a risk?
- A GPS location stored as metadata in a photo or video file. A posted photo could reveal where someone lives.
- Phishing, smishing, vishing and pharming
- Phishing: email with a link to a fake site. Smishing: SMS text message. Vishing: phone call or voicemail. Pharming: malicious code or a tampered DNS redirects the browser even when the correct address is typed.
- Hardware firewall vs software firewall
- A hardware firewall is a separate device that protects every device on the network and uses none of their resources. A software firewall runs on one computer, protects it on any network, and can control which applications use the network.
- Worm vs trojan
- A worm is standalone and spreads across networks by itself. A trojan looks legitimate, has a hidden payload, and relies on a user installing it; it does not replicate.
- What are a rootkit and a malicious bot?
- A rootkit gains administrator-level access and hides itself and other malware. A malicious bot lets an infected computer be controlled remotely as part of a botnet.
- Name four uses of malware
- Fraud, theft (of money, data, identities or intellectual property), industrial espionage and sabotage.
- Signature-based vs heuristic malware detection
- Signature-based matches known malware, so it needs updates and misses new malware. Heuristic spots suspicious behaviour, so it can catch new malware but gives more false positives.
AS Topic 6: The digital divide
- What is the digital divide?
- The gap between people who have access to modern information technology, and the skills to use it, and those who do not.
- Name five groups between which a digital divide exists
- Age groups; cities and rural areas; levels of education; socioeconomic groups; more and less industrially developed nations.
- Why are rural areas affected by the digital divide?
- They often have weaker wireless coverage and slower connections, so people cannot easily work or study online.
- How are socioeconomic groups affected by the digital divide?
- Devices, connections and data cost money, so poorer households may have no device, or a shared low-performance device with limited data.
- Give four services people miss without internet access
- Any four of: online banking, online shopping, online education, online job adverts and applications, government services, health appointments and consultations, email and video calls.
- Why are some older people on the wrong side of the digital divide?
- Some did not use computers at school or work and may lack the skills or confidence, so they are excluded as services move online.
- How can the effects of the digital divide be reduced?
- For example: public access points in libraries, free or low-cost devices and data, better rural broadband and mobile coverage, and digital skills training. Match the measure to the cause.
AS Topic 7: Expert systems
- What is an expert system?
- A computer system that stores the knowledge of human experts in one field and uses rules to reason with it, producing possible solutions and explaining how it reached them.
- Name the components of an expert system
- User interface, inference engine, knowledge base (a database of facts and a rules base), explanation system, and knowledge base editor.
- Inference engine vs explanation system
- The inference engine does the reasoning: it matches facts to rules, fires rules and decides the next question. The explanation system reports how a conclusion was reached and why a question is asked.
- What is the knowledge base editor used for, and by whom?
- To add, edit and delete facts and rules so the system stays up to date. It is used by the knowledge engineer or experts, not by the user entering case data.
- Forward chaining vs backward chaining
- Forward chaining (data driven) starts with known facts and works from IF parts to THEN parts. Backward chaining (goal driven) starts with a goal and works back to test its IF conditions.
- Name six scenarios where expert systems are used
- Any six of: mineral prospecting, investment analysis, financial planning, insurance planning, car engine fault diagnosis, medical diagnosis, route scheduling for delivery vehicles, plant and animal identification.
- Give two advantages and two disadvantages of expert systems
- Advantages: consistent with no tiredness; available any time; combines several experts' knowledge; explains its reasoning. Disadvantages: errors in the knowledge base give wrong advice; no common sense; expensive to build; needs updating.
AS Topic 8: Spreadsheets
- Relative, absolute and mixed cell references
- B4 is relative: both parts move when copied. $B$4 is absolute: nothing moves. $B4 fixes the column; B$4 fixes the row. A two-way table needs mixed references.
- COUNT vs COUNTA vs COUNTBLANK
- COUNT counts cells with numbers only. COUNTA counts any non-empty cell. COUNTBLANK counts empty cells.
- INT vs ROUND. What are INT(-2.3) and ROUND(14.678, 1)?
- INT rounds down to a whole number, so INT(-2.3) = -3. ROUND goes to the nearest value at the stated decimal places, so ROUND(14.678, 1) = 14.7.
- How are the arguments of SUMIF and SUMIFS ordered?
- SUMIF(range, criterion, sum_range) puts the sum range last. SUMIFS(sum_range, range1, criterion1, ...) puts it first.
- How do you write an exact-match VLOOKUP?
- VLOOKUP(lookup value, table, column number, FALSE). The table is an absolute range with the key in its first column; the column is counted from the table's first column; FALSE gives an exact match.
- How do you build nested IF bands?
- List the bands from highest to lowest; test the highest first with >=; put the next IF in each false branch; the last false value is the lowest band; one closing bracket per IF.
- IFERROR vs ISERROR
- IFERROR(formula, message) replaces an error with a value or message. ISERROR returns TRUE or FALSE.
- Pivot table vs subtotals
- A pivot table builds a separate summary and needs no sorting. Subtotals insert totals into the list itself and need the data sorted by the grouping field first.
- Normal, extreme and abnormal test data for a percentage from 0 to 100
- Normal: e.g. 57. Extreme: 0 and 100 (valid, on the limits). Abnormal: e.g. -1, 101 or "pass" (must be rejected).
- Input message vs error message in spreadsheet validation
- An input message appears when the cell is selected and tells the user what to enter. An error message appears when the rule is broken and says what went wrong and what is allowed.
AS Topic 9: Modelling
- What is a computer model?
- A representation of a real system using variables and rules (formulas) to predict how it behaves.
- Model vs simulation
- The model is the set of rules and data. The simulation is the model being run, often over time or with chance events, to see how the system behaves.
- What-if analysis vs goal seek
- What-if: you change an input and see how the output changes. Goal seek: you set a target output and the software finds the input that achieves it.
- What three things does goal seek need?
- The result cell (which must contain a formula), the target value, and the input cell to change (which must contain a value, not a formula).
- Give four uses of what-if analysis on the 9626 syllabus
- Any four of: financial forecasting, population growth, climate change, weather systems, queue management, traffic flow, construction.
- Give four reasons for using computer models
- Cheaper than building or testing the real thing; safer, as nobody is in danger; faster, as time can be speeded up; repeatable with one variable changed; can study things that cannot be tested for real.
- Give three weaknesses of spreadsheet models
- Rules are simplified and not every variable is included; assumptions such as constant rates may not hold; only as accurate as the input data; one formula error spreads; poor at 3D, visual or real-time simulation.
- Name four simulations on the 9626 syllabus
- Natural disaster planning, pilot training, learning to drive a car, and nuclear science research.
- Fixed costs are £1,200 and each ticket makes £8. How many tickets break even?
- 1200 ÷ 8 = 150 tickets.
AS Topic 10: Database and file concepts
- Primary key, foreign key and composite key
- Primary key: a unique value for every record. Foreign key: the primary key of another table stored to make a link; it may repeat. Composite key: two or more fields that are unique together.
- What is referential integrity?
- The rule that every foreign key value must match an existing primary key value. It prevents orphan records.
- How is a many-to-many relationship built?
- As two one-to-many relationships through a link table, e.g. Student and Course linked by an Enrolment table.
- What are the tests for 1NF, 2NF and 3NF?
- 1NF: no repeating groups, atomic values, a primary key. 2NF: 1NF and no field depends on only part of a composite key. 3NF: 2NF and no non-key field depends on another non-key field.
- Employee(EmpID, DeptID, DeptName). Which normal form does it break?
- 3NF. DeptName depends on DeptID, which is a non-key field (a transitive dependency).
- Static vs dynamic parameter query
- A static parameter query has its criterion fixed in the design. A dynamic parameter query asks the user to type the value each time it runs.
- Name the four action queries
- Make-table (copy results into a new table), append (add results to an existing table), delete (remove matching records) and update (change values in matching records).
- Indexed sequential vs direct access files
- Indexed sequential: records in key order plus an index; good for sequential runs and fairly fast single look-ups. Direct access: hashing turns the key into an address; fastest single look-up, poor for processing in order.
- Name eight components of a data dictionary
- Any eight of: field name, data type, field size, format, key, validation rule, error text, default value, whether required, description, table name.
- Conceptual vs logical vs physical ERD
- Conceptual: entities and relationships only. Logical: adds attributes and keys. Physical: adds real table and field names, data types and sizes.
AS Topic 11: Video and audio editing
- Trim vs crop in video editing
- Trimming removes time: unwanted footage from the start or end of a clip. Cropping removes the edges of the frame or image.
- Subtitle vs caption
- Subtitles show the spoken words. Captions show speech and other sounds, e.g. [phone rings], for deaf and hard-of-hearing viewers.
- Interframe vs intraframe video compression
- Interframe stores only the changes between key frames, giving much smaller files, but suffers when the whole picture changes. Intraframe compresses each frame on its own, so files are larger but quality does not depend on other frames.
- Compare MP4, AVI, MOV and WMV
- MP4: small for its quality and plays almost everywhere, but usually lossy. AVI: widely played on Windows but often large. MOV: Apple, high quality, suits editing, but large. WMV: Microsoft, small, weaker support elsewhere.
- What does normalising audio do?
- It applies the same gain to the whole clip so the loudest peak reaches a target level, which may be quieter or louder. Any DC offset should be removed first.
- High pass vs low pass filter
- Named after what they let through. A high pass filter keeps frequencies above the cut-off, removing rumble and hum. A low pass filter keeps frequencies below it, removing hiss.
- Echo vs reverberation
- Echo (delay) gives distinct, quieter repeats after a set time. Reverb is many dense reflections blended together, sounding like a room or hall.
- How do you calculate the size of uncompressed audio?
- Bits = sampling rate × sampling resolution × channels × seconds; ÷ 8 for bytes. E.g. 8,000 Hz × 8 bits × 1 channel × 10 s = 640,000 bits = 80,000 bytes.
- File vs container
- A plain file holds one stream encoded one way. A container such as MP4 or MOV wraps one or more streams plus information about them; the codec inside sets the compression.
- WAV: one advantage and one disadvantage
- Advantage: usually uncompressed, so full quality and best for editing. Disadvantage: very large files.
A Level Topic 12: IT in society
- Virtual currency vs cryptocurrency
- A virtual currency is issued and controlled by its developers and used in one online community. A cryptocurrency is a virtual currency secured by cryptography and recorded on a decentralised ledger.
- Centralised vs decentralised digital currencies
- Centralised: one authority, such as a bank, checks transactions and keeps the record (debit and credit cards, EPOS). Decentralised: a network of peers checks them and every node holds a copy of the ledger (Bitcoin, Litecoin).
- Describe how a blockchain works
- Transactions are grouped into a block; the block stores the hash of the previous block; nodes agree the block is valid; it is added to every copy of the ledger. Editing an old block changes its hash and breaks the link.
- What is data mining?
- Using software to search large data sets for previously unknown patterns, relationships and anomalies, to make predictions and support decisions.
- Name the six stages of data mining in order
- Business understanding, data understanding, data preparation, data modelling, evaluation, deployment.
- Instant messaging vs chat room
- Instant messaging is real-time messaging with known contacts or small groups. A chat room is a real-time, topic-based space open to many users, often strangers.
- Give two negative impacts of social networking on individuals
- Any two of: intellectual isolation, effects on physical and mental health, ideological polarisation, stereotyping, cognitive issues.
- MOOC vs networked course
- A MOOC (massive open online course) is open to anyone at very large scale, with little individual support. A networked course is delivered to a closed group over one network.
- Give one benefit and one drawback of surveillance by the police
- Benefit: CCTV, number plate and facial recognition help detect crime. Drawback: mass surveillance reduces privacy and misidentification can occur.
A Level Topic 13: New and emerging technologies
- AR vs VR
- Augmented reality adds computer images to a live view of the real world. Virtual reality replaces the real world with a fully computer-generated, immersive 3D environment.
- Computer-assisted translation vs machine translation
- In computer-assisted translation a human translates with software help (translation memory, terminology database). In machine translation the software translates on its own.
- How does 3D printing make an object?
- A CAD model is created or scanned; software slices it into thin layers; the printer deposits or hardens material one layer at a time; the object may then be finished.
- How does an autonomous vehicle drive itself?
- Sensors (cameras, radar, lidar, GPS) collect data; AI software identifies objects; the system decides speed and direction; actuators steer, brake and accelerate; the loop repeats many times a second.
- Internet of Things vs wearable computing
- The IoT is any everyday object with sensors and a network connection, such as a smart meter. Wearables are computing devices worn on the body. A connected smartwatch is both.
- What is molecular data storage?
- Data encoded in molecules, such as DNA base sequences. It has extreme density and a long life, but reading and writing are slow and expensive.
- Name the five medical areas affected by new technologies on the 9626 syllabus
- Patient care and monitoring, prosthetics, tissue engineering, artificial blood vessels, and medical tools and equipment.
- Name the five environmental areas affected by new technologies
- E-waste, recycling, power consumption, manufacturing processes, and energy from wireless signals.
- How do new technologies affect power consumption?
- AI data centres and some blockchains use a lot of energy, but smart IoT controls can save energy.
A Level Topic 14: Communications technology
- Physical vs logical topology
- Physical topology is the cabling layout; logical topology is how data flows. A hub-based star is a physical star but a logical bus.
- Hub vs switch
- A hub broadcasts to all ports. A switch sends a frame only to the port of the destination MAC address.
- Bridge vs router vs gateway
- A bridge joins two segments using the same protocol. A router forwards packets between networks by IP address. A gateway joins networks that use different protocols.
- What does a repeater do, and what does a WAP do?
- A repeater regenerates a weak signal. A wireless access point joins wireless devices to a cabled LAN.
- What does a proxy server do?
- It acts as a go-between for internet requests: it filters them, caches pages and hides internal addresses.
- Packet vs circuit vs message switching
- Packet: data split into packets that take separate routes and are reassembled. Circuit: a dedicated channel for the whole session. Message: the whole message is stored and forwarded node by node.
- Static vs dynamic routing
- Static routing uses manually set tables: secure, but cannot adapt. Dynamic routing updates automatically: it adapts to changes but uses bandwidth.
- How does BitTorrent transfer a file?
- The file is split into pieces downloaded from many peers at once, and each peer also uploads pieces to others.
- How is data sent by satellite?
- Data is encoded and modulated, sent from a ground station uplink, amplified by the satellite's transponder, sent down on another frequency, and decoded by the receiving dish.
- How can the effects of a disaster on a network be minimised?
- UPS and surge protection, passwords and access control, anti-malware, off-site back-ups and a tested restore plan.
A Level Topic 15: Project management
- Name the four stages of the project life cycle
- Initiation, planning, execution and monitoring, and close.
- Initiation vs planning
- Initiation decides what the project is and whether to do it. Planning decides how and when, task by task.
- Objective vs success criterion
- An objective is what the project must achieve, e.g. "launch online booking". A success criterion measures whether it was met, e.g. "60% of bookings online within two months".
- What is scope, and what is scope creep?
- Scope is the boundary of the project: what is in and what is out. Scope creep is uncontrolled growth of that boundary.
- What three constraints are monitored during a project?
- Time (against the schedule), cost (against the budget) and quality (against agreed standards, e.g. by testing).
- Name the six uses of project management software
- Planning, scheduling of tasks, allocation of resources, costings, communication, and collaborative working and decisions.
- What is the critical path?
- The longest sequence of dependent activities through a project. It sets the shortest possible project time; any delay to a critical activity delays the whole project. Critical activities have zero float.
- What is float in critical path analysis?
- The time an activity can be delayed without delaying the whole project. Staff can be moved from activities with float to critical ones.
- Why are projects reviewed at close?
- To check objectives and success criteria were met, compare actual time and cost with the plan, find what went well and badly, record lessons for future projects and confirm stakeholders are satisfied.
A Level Topic 16: System life cycle
- Name the stages of the system life cycle in order
- Analysis, design, development and testing, implementation, documentation, evaluation, then maintenance.
- User requirements specification vs design specification
- The user requirements specification says what users need. The design specification says how the system will be built.
- Data flow diagram vs system flowchart
- A DFD shows the movement of data. A system flowchart shows hardware, files and processes.
- Phased vs pilot implementation
- Phased: one part of the system is introduced everywhere at a time. Pilot: the whole system is introduced in one place first.
- Waterfall vs agile development
- Waterfall completes one stage at a time with sign-off: a clear plan, but late changes are expensive. Agile uses short cycles with close customer contact: it handles changing needs but needs constant user time.
- What is RAD?
- Rapid application development: fast prototypes, workshops with users and strict time limits. Quick and user-focused, but poor for large, complex systems.
- Evolutionary vs throwaway prototyping
- An evolutionary prototype is refined until it becomes the final system. A throwaway prototype is discarded once the requirements are clear.
- Name the four types of maintenance
- Corrective (fix a fault), adaptive (the environment changed, e.g. law or operating system), perfective (users want improvements) and preventive (reduce the risk of future faults).
- What criteria are used to evaluate a system?
- Efficiency, ease of use and appropriateness for its intended use, judged by checking against the specifications and user requirements and collecting user feedback.
A Level Topic 17: Data analysis and visualisation
- Cleaning vs transforming data
- Cleaning fixes errors in the data. Transforming reshapes data that is already correct.
- Splitting vs merging fields
- Splitting turns one field into many, e.g. a full name into first name and surname. Merging joins many fields into one.
- Comparing vs consolidating data
- Comparing finds the differences between sources. Consolidating produces one combined data set from them.
- Pivot table vs pivot chart
- A pivot table holds the summary numbers. A pivot chart is a linked chart of them.
- Pivot table vs SUMIF formulas
- A pivot table is quick to rearrange and picks up new categories on refresh. SUMIF needs one formula per total but recalculates automatically.
- Row or column field vs filter field in a pivot table
- A row or column field groups the records. A filter field includes only some of the records.
- Why must dates be stored as true dates, not date-like text?
- Only a true date sorts in date order, groups by month and works in date calculations.
A Level Topic 18: Mail merge
- When is mail merge used?
- When the same document goes to many people with some details different, e.g. letters, invoices, reminders, certificates, badges, labels and directories.
- Why use mail merge?
- The fixed text is typed once; every copy has the same layout; data is not retyped, so there are fewer errors; copies are personalised; rules send copies only where needed.
- Give two drawbacks of mail merge
- One error in the source data repeats in every copy that uses it; set-up time is not worth it for very few documents; bulk post may be seen as junk.
- Fill-in vs Ask fields
- Fill-in shows the user's answer where the field sits. Ask stores the answer so it can be used elsewhere, possibly several times or in a condition.
- If Then Else vs Skip Record If
- If Then Else changes what a copy says. Skip Record If stops that copy being produced at all.
- Skip Record If vs Next Record If
- Skip Record If removes a whole copy. Next Record If moves on one record inside the same document, without re-testing the new record.
- Letter merge vs directory merge
- A letter merge produces one document per record. A directory merge puts all the records into one document.
- Embedded vs linked object in a master document
- An embedded object is a stored copy that does not change when its original file changes. A linked object updates from its file.
A Level Topic 19: Graphics creation
- What happens if an image's resolution is too low or too high?
- Too low: blocky or soft images, worst in print or when enlarged. Too high: no visible gain on screen, but larger files, slower web pages and more storage.
- What is a Bezier curve?
- A vector curve whose shape is set by its end nodes and their control handles, which set the direction and strength of the bend.
- What does tracing a bitmap gain and lose?
- It turns edges and colour areas into vector paths. Gains: scalable, editable, small for simple logos. Losses: detail and shading, many nodes for complex images, and clean-up time.
- Kerning vs letter spacing
- Kerning adjusts the space between one pair of letters. Letter spacing sets even spacing across all the selected letters.
- What does converting text to curves do?
- The letters become paths, so no font is needed and letters can be reshaped, but the text can no longer be edited as text.
- Lossless vs lossy image compression
- Lossless rebuilds the original exactly, e.g. run-length encoding (RRRRBB → 4R 2B), and is best on flat colour. Lossy permanently removes detail for much smaller files, giving artefacts that get worse with each re-save.
- Bring to front vs raise
- Raise moves an object up one step in the stacking order. Bring to front moves it all the way to the top.
- What is the effect of reducing colour depth?
- Fewer bits per pixel give a smaller file but fewer colours, so smooth areas show banding.
A Level Topic 20: Animation
- Key frame vs tweened frame
- A key frame is a frame where you set or change a value. Tweened frames are generated by the software between two key frames.
- Motion tween vs shape tween
- A motion tween moves an object (its position, possibly along a path). A shape tween changes an object's outline into another shape.
- Shape tween vs morphing
- A shape tween changes vector shapes. Morphing warps and cross-fades one image seamlessly into another.
- Layer vs mask
- A layer holds objects that animate independently. A mask is a shape that decides which parts of the layers it masks are visible.
- Stop motion vs time lapse
- Stop motion: you move the objects between photos. Time lapse: the scene changes by itself between photos taken at intervals.
- What is frame rate?
- The number of frames shown per second (fps).
- Primary vs secondary components of an animation
- Primary components are the main focus, e.g. the main characters. Secondary components support them, e.g. sound and background.
- Loop vs stop at the end of an animation
- Loop replays from the start, e.g. banners and loading icons. Stop holds on the final frame, e.g. an advert ending on a logo.
- 2D vs 3D animation
- 2D uses x and y only: quicker, cheaper and smaller files, but less realistic depth. 3D uses x, y and z with models, lighting, camera and rendering: realistic, but complex with long render times.
A Level Topic 21: Programming for the web
- How is JavaScript added to a web page?
- Inside a script element in the HTML, or in an external .js file linked using the script element's src attribute.
- What is a variable in JavaScript, and how is it declared?
- A named store whose value can change, declared with let, const or var.
- Literal vs expression
- A literal is a fixed value written in the code, such as 7, "Lahore" or false. An expression is values and operators that work out to one value, such as price * qty.
- What is a JavaScript array, and where does its index start?
- An ordered list in square brackets. The first index is 0.
- What do alert, confirm and prompt return?
- alert shows a message with OK and returns nothing useful. confirm returns true (OK) or false (Cancel). prompt returns the typed string, an empty string if nothing is typed, or null on Cancel.
- When do onload, onchange, onclick and onkeydown fire?
- onload: when the page or image finishes loading. onchange: when a value changes (a text box fires when it loses focus). onclick: when the element is clicked. onkeydown: when a key is pressed.
- Name four ways JavaScript can display data
- innerHTML, document.write(), window.alert() and console.log().
- How do you change an element's style with JavaScript?
- document.getElementById(id).style.property = new value, e.g. setting style.display or style.visibility to show or hide it.
- setTimeout vs setInterval
- setTimeout runs a function once after a delay. setInterval runs it repeatedly at a fixed interval until cleared.
- What is a JavaScript event?
- Something that happens to an HTML element, such as a click or a page loading, which can trigger code.
Flashcards by topic
- Topic 1 Data processing and information 9 cards
- Topic 2 Hardware and software 17 cards · 5 subtopics
- Topic 3 Monitoring and control 8 cards · 2 subtopics
- Topic 4 Algorithms and flowcharts 9 cards
- Topic 5 eSecurity 9 cards
- Topic 6 The digital divide 7 cards
- Topic 7 Expert systems 7 cards
- Topic 8 Spreadsheets 10 cards
- Topic 9 Modelling 9 cards
- Topic 10 Database and file concepts 10 cards
- Topic 11 Video and audio editing 10 cards
- Topic 12 IT in society 9 cards
- Topic 13 New and emerging technologies 9 cards
- Topic 14 Communications technology 10 cards
- Topic 15 Project management 9 cards
- Topic 16 System life cycle 9 cards
- Topic 17 Data analysis and visualisation 7 cards
- Topic 18 Mail merge 8 cards
- Topic 19 Graphics creation 8 cards
- Topic 20 Animation 9 cards
- Topic 21 Programming for the web 10 cards
Written for Cambridge International AS & A Level Information Technology (9626), syllabus 9626 (2025-2027).
Cards by Marlbridge Academic Team; 67 restate definitions from the 9626 revision notes. This deck has not yet been reviewed as a whole by a subject teacher. Report an error.