2025 Edexcel IGCSE Information and Communication (ICT) 模擬試題連答案詳解

SSDs use flash memory to store data, meaning they have no moving parts. This makes them highly energy-efficient, producing less heat and using less power than HDDs which rely on physical spinning magnetic platters. SSDs also offer significantly faster read/write speeds, though they generally cost more per gigabyte.

1 mark for the correct answer: c.

TCP (Transmission Control Protocol) is a reliable, connection-oriented protocol that numbers packets, checks that they have arrived successfully, and requests retransmission of any lost or corrupted packets to ensure complete, ordered data delivery.

1 mark for the correct answer: c.

Pharming involves maliciously redirecting internet traffic to a spoofed website, typically by poisoning the DNS cache or modifying hosts files on the user's computer, even if the user typed the correct web address or used a legitimate bookmark. Phishing, by contrast, relies on tricking the user into clicking a deceptive link in an email or message.

1 mark for the correct answer: b.

Version history keeps a record of all modifications made to a document, allowing users to see who made specific edits and to revert to earlier versions if necessary. Real-time chat helps communication but does not track document state changes directly.

1 mark for the correct answer: c.

Virtualisation reduces environmental impact by allowing multiple virtual servers (operating systems and applications) to run on a single physical host server. This decreases the overall physical hardware footprint, power usage, and cooling requirements of a data centre.

1 mark for the correct answer: c.

RFID tags use radio waves to transmit data, meaning they do not require a direct line of sight to be scanned. This allows multiple RFID tags within the range of a reader to be scanned simultaneously, speeding up inventory processes drastically compared to individual optical barcode scanning.

1 mark for the correct answer: c.

A Media Access Control (MAC) address is a physical address burned into the Network Interface Card (NIC) at the time of manufacture and does not change. An Internet Protocol (IP) address is a logical address that is assigned to a device dynamically or statically based on the network it connects to.

1 mark for the correct answer: a.

An incremental backup only copies data that has changed since the last backup (whether it was a full or an incremental backup). This involves copying the smallest possible volume of data daily, making the backup window very short. Differential backups copy everything changed since the last full backup, which takes increasingly longer each day of the week.

1 mark for the correct answer: c.

SMTP (Simple Mail Transfer Protocol) is used to send email messages from a client to a mail server or between mail servers. POP3 and IMAP are protocols used to retrieve email messages from a mail server, and HTTP is used for web page transfer.

Award 1 mark for the correct choice of SMTP (B). Incorrect options represent retrieval protocols (IMAP/POP3) or web transfer protocols (HTTP).

Solid State Drives (SSDs) have no moving parts and use flash memory, making their read/write speeds substantially faster than mechanical storage devices like Hard Disk Drives (HDDs), Optical Discs, or Magnetic Tapes. This makes them ideal for high-performance tasks like high-resolution video editing.

Award 1 mark for identifying Solid State Drive (SSD) (A) as the storage type with the fastest read/write speeds. Other options are slower mechanical/optical storage technologies.

SSDs are faster at reading and writing data, and they do not have moving parts, which makes them more durable and less likely to fail when dropped.

Award 1 mark for each valid advantage up to a maximum of 2 marks. Accept: faster boot/loading times, more robust/durable, lower power consumption, silent operation, runs cooler, lighter weight.

TCP manages the packetization and reliability of the data transfer, while IP handles the addressing of the packets so routers can deliver them to the correct host.

Award 1 mark for describing the role of TCP (packetizing, reassembling, error checking, ordering). Award 1 mark for describing the role of IP (addressing, routing).

A virus must attach to a host file and relies on user action to run and spread. A worm is self-replicating and spreads itself across network connections automatically without human intervention.

Award 1 mark for explaining virus characteristics (needs host file, needs user intervention). Award 1 mark for explaining worm characteristics (standalone, self-replicating, spreads over networks automatically).

Wikis allow multi-user collaborative editing so team members can update content easily. They also feature version control, allowing users to restore previous versions if incorrect changes are made.

Award 1 mark for each feature explained in relation to collaboration up to a maximum of 2 marks. Accept: Multi-user editing, version control/history tracking, discussion/talk pages, easy searchability, hyperlinks for organizing info.

A sensor measures environmental data (e.g., temperature) and sends it to the microprocessor. An actuator receives commands from the microprocessor to perform a physical task (e.g., turning on a heater).

Award 1 mark for explaining the role of the sensor (inputs physical/environmental data). Award 1 mark for explaining the role of the actuator (performs a physical action based on instructions).

Latency is the time delay for data to travel across a network. Even with high bandwidth, high latency means there is a noticeable delay (lag) between a player's action and the server's response, making real-time play difficult.

Award 1 mark for explaining latency as transmission delay/time lag. Award 1 mark for explaining the consequence on real-time gameplay (delayed actions, lag, lack of synchronization).

Individuals and organizations can extend the device lifespan by donating/repurposing them, or ensure they are disposed of safely at dedicated e-waste recycling centers to prevent toxic chemicals from leaking into landfill.

Award 1 mark for each valid method up to 2 marks. Accept: donating/selling for reuse, using accredited e-waste recycling programs, trade-in/refurbishment schemes. Do not accept general 'throw in bin' or unspecific 'recycling'.

The foreign key in a child table references the primary key in a parent table to connect the data records, allowing relationships (like one-to-many) to be formed and maintaining referential integrity.

Award 1 mark for stating that the foreign key references/links to a primary key in another table. Award 1 mark for explaining that this creates a relationship between tables / maintains integrity.

An SSD is highly suitable for outdoor rugged cameras because: 1. It has no moving parts, making it shock-resistant and less likely to fail if dropped. 2. It is lighter in weight and consumes less power, which helps extend the camera's battery life.

Award 1 mark for each valid reason, up to a maximum of 2 marks: - No moving parts / shock resistant / durable (1 mark) - Lightweight (1 mark) - Lower power consumption (1 mark) - Smaller physical size (1 mark) - Faster write speed (to save high-res photos quickly) (1 mark). Do not accept: 'more storage capacity' or 'cheaper'.

Bandwidth refers to the network capacity (often measured in Mbps), representing how much data can flow through it at once. Latency refers to the transmission delay, representing how long it takes for a single packet of data to travel from one point to another.

Award 1 mark for a correct description of bandwidth and 1 mark for a correct description of latency: - Bandwidth: The volume/amount of data that can be transferred over a network per unit of time / network capacity (1 mark). - Latency: The delay/time taken for data/packets to travel from sender to receiver / response time (1 mark).

Phishing relies on social engineering via communication (like emails or messages) to lure victims into clicking a bad link. Pharming is a technical attack that infects DNS servers or local host files to automatically redirect a user to a spoofed website, without requiring them to click a specific email link.

Award 1 mark for explaining phishing and 1 mark for explaining how pharming differs: - Phishing: Uses deceptive emails/messages to trick users into visiting fake websites/revealing details (1 mark). - Pharming: Maliciously redirects traffic to a fake website by manipulating DNS/host files without the user clicking an email link (1 mark). Alternatively, award 1 mark for identifying that phishing requires user action (clicking a link in a message), whereas pharming redirects traffic automatically even if the correct web address is typed (1 mark).

To reduce environmental impact, an office can: 1. Configure devices to automatically enter sleep or hibernation modes when idle to save electricity. 2. Implement a certified e-waste recycling policy to ensure toxic materials do not enter landfills and valuable materials are reclaimed.

Award 1 mark for each valid way, up to a maximum of 2 marks: - Enable power-saving/sleep/hibernation modes on idle devices (1 mark). - Turn off computers/monitors completely overnight/at the end of the day (1 mark). - Use energy-efficient hardware (e.g., Energy Star rated devices) (1 mark). - Donate/recycle old computer equipment through certified e-waste facilities (1 mark). - Reduce paper waste by moving to paperless workflows/duplex printing (1 mark). Do not accept vague answers like 'use computers less' or 'don't use electricity'.

An SSD (Solid State Drive) is highly suitable for outdoor/on-location photography due to several key features: 1. Durability: Since SSDs use flash memory and have no moving parts, they are resistant to physical shocks. If the laptop or external drive is bumped or dropped on location, data is much less likely to be lost compared to a traditional HDD. 2. Speed: SSDs have much higher read and write speeds, which means large raw image files can be transferred and opened in editing software much quicker. 3. Power efficiency: SSDs consume less battery power, extending the working time of the photographer's laptop when working away from mains electricity.

Award 1 mark for each explanation point up to a maximum of 3 marks: - SSDs have no moving parts (1) which makes them shock-resistant/more durable when transported on location (1). - SSDs have faster read/write speeds (1) which allows faster transfer/loading of large photo files (1). - SSDs have lower power consumption (1) which extends laptop battery life when working outdoors/away from mains power (1).

When data is sent across the internet, it is split into packets. Each packet contains a header with the sender's and receiver's IP addresses. When a router receives a packet: 1. It inspects the packet header to find the destination IP address. 2. It consults its routing table, which contains paths to various network destinations. 3. It forwards the packet to the next optimal router or gateway on the network pathway, repeating this process until the packet reaches its final destination.

Award 1 mark for each of the following points, up to a maximum of 3 marks: - The router reads/inspects the destination IP address in the packet's header (1). - It checks/references its internal routing table to determine the most efficient route/path (1). - It forwards the packet to the next router/hop towards the destination (1).

Asymmetric encryption provides secure data transmission by using a key pair: 1. Key Pair: It utilizes two mathematically linked keys: a public key (shared openly) and a private key (kept secret by the owner). 2. Encryption: The sender obtains the recipient's public key and uses it to encrypt the message/data. 3. Decryption: Once encrypted, the data can only be decrypted by the matching private key owned by the recipient. Even if intercepted on a public network, the data remains secure because the public key cannot be used to decrypt it.

Award 1 mark for each of the following points, up to a maximum of 3 marks: - Uses a key pair consisting of a public key (shared) and a private key (kept secret) (1). - The sender encrypts the data using the recipient's public key (1). - Only the recipient's corresponding private key can decrypt the data, ensuring confidentiality (1).

Virtualisation is the process of creating software-based (virtual) representations of physical servers. It reduces environmental impact in the following ways: 1. Server Consolidation: Instead of running multiple physical servers at low capacity, a company can run multiple virtual servers on a single, high-capacity physical host. 2. Energy Savings: Fewer physical servers mean a dramatic reduction in electricity consumed directly by the hardware and indirectly by the cooling systems (air conditioning) needed to prevent overheating. 3. Lower Carbon Footprint/E-waste: Fewer physical machines mean less manufacturing demand, fewer raw resources used, and less electronic waste when the hardware reaches its end-of-life.

Award 1 mark for each of the following points, up to a maximum of 3 marks: - Explanation of virtualisation: running multiple virtual servers/operating systems on a single physical machine (1). - This reduces the physical hardware footprint/number of physical servers required (1). - Leading to lower energy consumption (power and cooling) OR reduced e-waste / resource extraction (1).

Wikis are highly effective collaborative tools because: 1. Shared Editing: Anyone with permission can directly edit the content of the pages using a web browser, allowing continuous, collective updates without sending files back and forth. 2. Version History: The software keeps a record of all previous versions. If someone makes an error or deletes important information, the group can easily compare differences or restore a previous version. 3. Centralized Resource: It acts as a single point of truth where ideas, files, and links can be organized together, and discussion pages allow contributors to talk about changes before implementing them.

Award 1 mark for each of the following points, up to a maximum of 3 marks: - Allows multiple users to edit the same web content directly / asynchronously from anywhere (1). - Keeps a version history / change log to track who made what changes and revert to older versions if needed (1). - Provides a central space / discussion page for planning, coordinating tasks, and collaborating on content (1).

Database locking is essential in transaction processing environments to maintain data integrity: 1. Prevention of Double-booking: When a customer begins the checkout process for a specific seat, that record is locked. This prevents another customer from purchasing the exact same seat simultaneously. 2. Transaction Integrity (ACID properties): The lock ensures that the transaction is fully completed (payment processed and ticket assigned) before the database state is updated for other users. 3. Rollback Mechanism: If the customer cancels the purchase or the payment fails, the lock is released (rolled back), ensuring the seat becomes available to other buyers immediately without leaving the database in an inconsistent state.

Award 1 mark for each of the following points, up to a maximum of 3 marks: - Prevents double-booking / ensures data integrity by preventing concurrent modifications to the same database record (1). - Temporarily locks/reserves the seat/record while the user completes the transaction (1). - Permanently updates the record if successful, or releases the lock (rolls back) if the transaction fails/times out (1).

The digital divide refers to the gap between those who have access to modern ICT and those who do not. It impacts career opportunities in several ways: 1. Job Search and Application: Many employers now exclusively advertise jobs online (e.g., on job boards, LinkedIn) and require online applications. Those without internet access cannot easily find or apply for these positions. 2. Skill Development: Familiarity with software (spreadsheets, word processors, email) is a prerequisite for many careers. Without regular access to digital devices, individuals cannot develop the digital literacy required by modern employers. 3. Remote Working Opportunities: Many high-paying professional roles allow or require remote work. Individuals lacking high-speed home broadband are excluded from these flexible and often lucrative job opportunities.

Award 1 mark for each of the following points, up to a maximum of 3 marks: - Difficulty finding and applying for jobs because vacancies and applications are primarily hosted online (1). - Lack of opportunity to develop essential digital literacy / ICT skills required by modern employers (1). - Exclusion from remote working / flexible employment opportunities that require home internet and devices (1).

A device driver is a specialized piece of software that facilitates communication between the OS and hardware: 1. Interface/Translator: Operating systems are generic, whereas hardware devices (like a specific model of printer or graphics card) require unique commands. The driver acts as an intermediary translator. 2. Command Translation: When the OS wants to perform an action (e.g., print a document), it sends a generic instruction to the driver. The driver translates this into the precise control signals the hardware device needs. 3. Compatibility: Drivers enable new hardware to be connected and used (plug and play) without requiring modifications to the core operating system software.

Award 1 mark for each of the following points, up to a maximum of 3 marks: - Acts as a translator / interface between the operating system and the hardware peripheral (1). - Translates generic OS commands into specific instructions/signals that the hardware can understand (1). - Allows the operating system to support and control new hardware devices without needing to change the OS code itself (1).

1. The VPN client software on the laptop encrypts all data before sending it.
2. The data is transmitted through a secure 'tunnel' over the public internet to the corporate network.
3. Because the data is encrypted, anyone who intercepts it cannot read or understand it without the decryption key.

Award up to 3 marks for three linked points or distinct explanations:
- Data is encrypted/scrambled before it is transmitted over the internet (1 mark)
- The data travels through a secure, private 'tunnel' (1 mark)
- If the data is intercepted, it is unreadable/meaningless without the correct decryption key (1 mark)

1. The online store's server shares its public key with the user's browser.
2. The web browser uses this public key to encrypt the transaction data before sending it.
3. The encrypted data can only be decrypted by the matching private key, which is kept secret by the online store's server.

Award up to 3 marks:
- Identification that a public key is shared/used by the browser to encrypt the data (1 mark)
- Identification that a matching private key is kept secure on the server to decrypt it (1 mark)
- Explanation that data encrypted with the public key cannot be decrypted by any other key than the matching private key (1 mark)

1. Smart heating systems use occupancy sensors or mobile geofencing to detect if anyone is home, turning off the heating when empty.
2. Algorithms learn the family's daily routine, adjusting the temperature so it is only warm when needed.
3. Users can control the system remotely via a smartphone app to switch off heating if they are delayed, preventing wasted energy.

Award up to 3 marks:
- Use of sensors/geofencing to detect occupancy and turn heating down/off when empty (1 mark)
- Learning algorithms that adapt the heating schedule automatically to actual user routines (1 mark)
- Remote control capabilities via smartphone app to prevent heating when plans change (1 mark)

1. Fiber-optic cables transmit data using light pulses, which allows for significantly higher bandwidth and speed compared to electrical signals in copper.
2. They are not susceptible to electromagnetic interference (EMI) from electrical lines, lights, or school equipment.
3. Light signals suffer far less attenuation (signal loss) over distance, allowing cables to span the entire school campus without signal boosters.

Award up to 3 marks:
- Offers higher bandwidth / faster transmission speeds for heavy school traffic (1 mark)
- Immune to electromagnetic interference (EMI) from surrounding devices (1 mark)
- Lower signal degradation over long distances, suitable for wide campus connections (1 mark)

1. Collaborative cloud software allows multiple team members to edit a single document at the same time, reducing project completion time.
2. Changes are saved automatically and synchronized in real-time, ensuring there is a single source of truth without duplicate files.
3. Built-in version history allows users to track edits and roll back to previous versions if mistakes are made.

Award up to 3 marks:
- Simultaneous/real-time editing speeds up work and prevents conflict copies (1 mark)
- Centralized document storage ensures everyone uses the single, most up-to-date version (1 mark)
- Version history and automatic saving minimize data loss risk and allow restoration (1 mark)

1. SSDs use flash memory and have no moving parts, making them highly durable and resistant to physical shock if the laptop is dropped or bumped.
2. They are physically smaller and lighter than HDDs, contributing to a more portable laptop design.
3. They consume less power because there is no mechanical motor to spin, which extends the laptop's battery life.

Award up to 3 marks:
- No moving parts makes them durable/shock-resistant when traveling (1 mark)
- Lower power consumption helps prolong battery run time (1 mark)
- Lighter weight and compact size support thin and portable device form factors (1 mark)

1. Providing fully adjustable office chairs allows employees to keep their feet flat and forearms horizontal to the desk.
2. Ergonomic split-keyboards and vertical mice align hands and wrists in natural positions, reducing muscle strain.
3. Offering wrist supports helps users keep wrists straight and neutral during typing, preventing repetitive compression of nerves.

Award up to 3 marks:
- Providing adjustable chairs/desks to promote correct posture and forearm alignment (1 mark)
- Use of ergonomic keyboards or vertical mice to reduce strain on wrists/hands (1 mark)
- Provision of wrist rests to maintain neutral wrist positions during repetitive typing (1 mark)

Cloud storage benefits:
- Accessibility: Remote workers can access and upload files from any location with an internet connection, reducing the need for complex VPN configurations.
- Collaboration: Real-time collaboration features and version control systems prevent workers from overwriting each other's work.
- Scalability: The company can easily purchase more storage as their graphic design archive grows, paying only for what they use.
- Disaster Recovery: Data is backed up automatically off-site, mitigating risks of physical damage at the main office (fire, theft).

Cloud storage drawbacks:
- Bandwidth dependence: Uploading and downloading large graphic design files (such as high-res video or RAW images) depends heavily on internet connection speeds, leading to potential latency and workflow bottlenecks.
- Long-term cost: Monthly subscription fees can become substantial over time compared to a one-off hardware investment.

Local storage benefits:
- Speed: Local office workers experience high-speed transfers over the LAN, which is crucial for heavy media editing.
- Security and Control: The company has absolute physical control over where their intellectual property is stored, ensuring compliance and data security.

Local storage drawbacks:
- Remote access issues: Remote workers must connect via VPNs, which can be slow, complex to configure, and dependent on the main office's upload speed.
- Maintenance: Requires local IT expertise to manage hardware failures, security updates, and manual backup routines.

Level 1 (1-3 marks):
- Demonstrates basic knowledge of cloud and/or local storage.
- Points are generic (e.g., 'cloud is online', 'local needs hard drives') and lack application to remote workers or large media files.
- Information is presented in a disorganized manner.

Level 2 (4-6 marks):
- Demonstrates a good understanding, discussing both cloud and local storage options.
- Appliable to the scenario (makes reference to remote collaboration or handling large files).
- The comparison is somewhat balanced, and a basic conclusion or recommendation is attempted.

Level 3 (7-8 marks):
- Demonstrates a comprehensive, detailed evaluation of both storage methods.
- Explicitly and consistently applied to the context of a graphic design business with remote workers (e.g., addressing bandwidth limitations for large files vs. collaboration efficiency).
- Includes a well-reasoned, balanced conclusion or justified recommendation based on the evaluation.

Environmental Impacts:
- E-waste accumulation: Millions of tons of obsolete devices are discarded annually. These often end up in landfills, where toxic chemicals (such as lead, mercury, and cadmium) can leak into soil and water systems, poisoning ecosystems.
- Resource Depletion: Manufacturing new devices requires constant extraction of finite raw materials, such as gold, lithium, and cobalt, destroying natural habitats.
- Carbon Footprint: The manufacturing, shipping, and distribution of new devices consume enormous amounts of energy, contributing heavily to global greenhouse gas emissions.

Ethical Impacts:
- Digital Divide: As software updates require newer hardware, individuals and schools in lower-income brackets are priced out, deepening inequality in access to information and education.
- Exploitative Labor: The mining of rare earth elements (e.g., cobalt in the Democratic Republic of Congo) often involves dangerous working conditions, severe health risks, and the exploitation of child labor.
- Global Inequality in E-waste: Developed nations often export electronic waste to developing countries (under the guise of recycling), shifting the toxic burden to communities that lack the infrastructure to process it safely.
- Planned Obsolescence: Some manufacturers intentionally design devices that cannot be easily repaired (e.g., gluing batteries, restricting spare parts), forcing consumers to replace functional devices prematurely.

Level 1 (1-3 marks):
- Identifies isolated environmental or ethical points (e.g., 'pollution from discarded phones', 'poor working conditions').
- Explanations are superficial and lack technical terminology.
- Structure is weak with little cohesive discussion.

Level 2 (4-6 marks):
- Explains both environmental and ethical impacts with some detail.
- Shows understanding of key terms (e.g., e-waste, planned obsolescence, digital divide).
- Discussion is structured, though one aspect (environmental or ethical) may be stronger than the other.

Level 3 (7-8 marks):
- Provides a highly detailed and balanced discussion covering both environmental and ethical dimensions.
- Connects the impacts effectively (e.g., how shipping e-waste to developing nations is both an environmental and ethical issue).
- Employs precise, relevant vocabulary throughout and presents a logical, well-structured argument.

First, open HAWKS_LOGO.PNG in your graphics software. Select the Crop tool and choose a 1:1 square ratio. Position the selection box over the hawk's head, then apply the crop. Next, navigate to the image resizing settings (typically Image > Image Size). Verify that 'Constrain Proportions' or 'Lock Aspect Ratio' is checked to prevent distortion. Change the width to 300 pixels, which automatically scales the height to 300 pixels due to the 1:1 ratio. Finally, use 'Save As' or 'Export As' to save the file as a JPEG, which is a compressed format optimized for web use.

1 mark: Description of cropping using a square / 1:1 selection box.
1 mark: Accessing the resize tool / image size menu.
1 mark: Checking / enabling the 'Constrain Proportions' or 'Keep Aspect Ratio' option.
1 mark: Setting the dimensions to 300 x 300 pixels.
1 mark: Saving / exporting as JPEG (or PNG) format for web optimization.

To reduce the file size of CAMPING.PNG, the student can: 1. Crop the image to remove unwanted outer regions, discarding pixel data. 2. Resize the image to lower pixel dimensions (e.g., from 4000x3000 to 800x600). 3. Apply higher compression during export. Converting the format from PNG to JPEG achieves a much smaller file size because JPEG uses lossy compression, discarding non-essential visual data. However, this conversion reduces image quality by creating compression artifacts, losing fine details, and removing any transparency support present in the original PNG.

1 mark each for any three valid techniques (max 3 marks):
- Crop / trim the image to reduce total pixel count.
- Resize / reduce image dimensions / lower the resolution.
- Apply compression / adjust quality slider.
- Reduce color depth / index colors.

1 mark: Explanation of file size reduction (JPEG uses lossy compression, discarding non-essential data).
1 mark: Explanation of quality impact (loss of detail / compression artifacts / loss of transparency).

To construct the query:
1. Open the query design view and add the SPECIES table.
2. In the design grid, add the Region field and enter the criteria "Savannah".
3. Add the PopulationEstimate field and enter the criteria < 5000.
4. Check the 'Show' boxes only for the fields CommonName and PopulationEstimate. Ensure that the Show boxes for SpeciesID, ConservationStatus, and Region are unchecked.
5. Select 'Descending' in the 'Sort' row of the PopulationEstimate field to display from highest to lowest population.

- 1 mark: Region criteria is exactly "Savannah" (accept Savannah without quotes as database software automatically adds them).
- 1 mark: PopulationEstimate criteria is exactly < 5000.
- 1 mark: CommonName and PopulationEstimate fields have the 'Show' property checked.
- 1 mark: SpeciesID, ConservationStatus, and Region fields have the 'Show' property unchecked.
- 1 mark: Sort field set to 'Descending' on the PopulationEstimate column.

To design a professional and error-minimizing form:
1. Form Header: Add a prominent title (e.g., 'Client Registration Form') with contrasting font and background colors.
2. Drop-down Menu: Change the control style of SubscriptionType to a combo box restricted to the list values 'Basic', 'Premium', 'VIP' to prevent typographical errors.
3. Date Picker: Enable a graphical calendar pop-up control on the DateJoined field to guarantee standard date formats.
4. Design Layout: Align all data entry boxes consistently to the right and their corresponding labels to the left, resizing them so text is not truncated.
5. Tab Order: Modify the form's tab order index so that pressing the Tab key guides the user logically from top-to-bottom and left-to-right (ClientID -> Title -> LastName -> Email -> DateJoined -> SubscriptionType).

Award 1 mark for each valid practical layout/functional modification explained up to a maximum of 5 marks:
- 1 mark: Appropriate, clear header/title added to the form.
- 1 mark: Use of a combo box/drop-down list for SubscriptionType to restrict entries.
- 1 mark: Use of a calendar/date picker control for DateJoined to ensure proper formatting.
- 1 mark: Consistent alignment and size adjustments for labels and input boxes.
- 1 mark: Adjustment of tab order to ensure logical navigation sequence.

To construct the query criteria:
1. The Title criteria must match 'Adventure' anywhere in the field. This is done using the Like operator with wildcard characters: Like "*Adventure*" (or LIKE '%Adventure%' in standard SQL).
2. The Genre field must match exactly: "Fiction".
3. The Price field requires a comparison operator: < 15.00.
4. Combined in an SQL query statement, the WHERE clause uses logical AND operators because all conditions must be true: WHERE Title Like "*Adventure*" AND Genre = "Fiction" AND Price < 15.00

- 1 mark: Correct use of the 'Like' operator.
- 1 mark: Correct wildcard character configuration on both sides of the search word (*Adventure* or %Adventure%).
- 1 mark: Correct exact match criteria for Genre ("Fiction").
- 1 mark: Correct comparison criteria for Price (< 15 or < 15.00).
- 1 mark: Correctly formed WHERE clause joining all three criteria with logical 'AND'.

To configure the report sections correctly:
1. Open the 'Group, Sort, and Total' pane in Design view, click 'Add a group', and select the Region field.
2. Within that group settings block, click 'Add a sort', select the Amount field, and configure the sort order to 'Largest to Smallest' (descending).
3. To show the average for each individual region, you must insert an unbound text box control in the Region Footer (Group Footer) section of the report. Placing it in the Detail section would display it on every record, and placing it in the Report Footer would display the overall total rather than regional averages.
4. Set the Control Source of the text box to the formula: =Avg([Amount]) (or =AVERAGE([Amount]) depending on DBMS syntax).

- 1 mark: Explaining the addition of a Group based on the Region field.
- 1 mark: Explaining the addition of a Sort based on the Amount field set to descending/largest-to-smallest.
- 1 mark: Correctly identifying the 'Region Footer' (or 'Group Footer') as the section to position the regional average calculation.
- 1 mark: Explicitly noting that the calculation should not go in the Detail or Report Footer section.
- 1 mark: Stating the correct formula syntax with an equals sign and square brackets: =Avg([Amount])

1. In the COURSES table, CourseID acts as the Primary Key because it uniquely identifies each course. In the ENROLMENTS table, CourseID acts as the Foreign Key because it refers back to the primary key in COURSES to link the tables.
2. The relationship is a 'one-to-many' relationship because one course can have many student enrolments, but each individual enrolment belongs to only one course.
3. The database designer should enforce Referential Integrity. This feature ensures data consistency by preventing users from adding an enrolment record with a non-existent CourseID (orphan records) or deleting a course that has existing active enrolments associated with it.

- 1 mark: Identifies Primary Key as CourseID in COURSES.
- 1 mark: Identifies Foreign Key as CourseID in ENROLMENTS.
- 1 mark: Identifies the relationship type as 'one-to-many' (or 1:M).
- 1 mark: Names the feature as 'Referential Integrity'.
- 1 mark: Explains that it prevents orphan records (e.g., adding an enrolment for a course that does not exist, or deleting a course that has linked enrolments).

The complete HTML5 structure must include a block containing the specified element. The <body> tag must feature the style attribute setting the background color. Elements in the body include an <h1> tag styled with the 'Times New Roman' font, an <img> tag with correct src, alt, and width attributes, and two <a> tags: one for an absolute external URL opening in a new tab via target='_blank', and another using the 'mailto:' scheme with a subject parameter query string.

- 1 mark: Correct use of Stonehaven Museum - Medieval Exhibit nested within the section.
- 1 mark: Correct inline CSS style setting the body background color: (Accept alternate equivalents, e.g., background: #E0E0E0).
- 1.5 marks: Correct heading with the specified text (1 mark) and inline font-family styling specifying a serif font like Times New Roman (0.5 marks).
- 1.5 marks: Correct tag with src="shield.png" (0.5 marks), alt="Knight Shield" (0.5 marks), and width set to 300 pixels (0.5 marks).
- 1.5 marks: Correct absolute external hyperlink with href="https://www.stonehavenmuseum.org/tickets" (0.5 marks), target="_blank" (0.5 marks), and anchor text "Book Tickets Now" (0.5 marks).
- 1 mark: Correct email link structure with mailto:curator@stonehavenmuseum.org (0.5 marks) and subject parameter ?subject=Exhibit%20Query or ?subject=Exhibit Query (0.5 marks).

The CSS file 'styles.css' must be structured with tag selectors for body, h1, h2, and class selectors .highlight and .banner-img. Properties must be defined inside standard curly braces. The HTML file must include a tag with the relation 'stylesheet' pointing to the correct relative path of 'styles.css' to successfully establish the link between the documents.

- 1.5 marks: Body style rule containing body { background-color: #F0F8FF; color: #333333; } (0.5 marks for body selector, 0.5 marks for background-color, 0.5 marks for text color).
- 1 mark: Grouped h1, h2 style rule setting font-family: Arial, sans-serif; (0.5 marks for selector grouping, 0.5 marks for correct property and fallback value).
- 1 mark: Heading 1 style rule setting text-align: center; (0.5 marks for selector/property, 0.5 marks for value).
- 1.5 marks: Class selector .highlight rule with color: #FF0000; and font-weight: bold; (0.5 marks for class syntax, 0.5 marks for color, 0.5 marks for font-weight).
- 1.5 marks: Class selector .banner-img rule setting border: 2px solid #000000; (0.5 marks for class syntax, 1 mark for correct border shorthand or individual border properties).
- 1 mark: Correct element in tours.html to link the stylesheet: or with type="text/css".

To retrieve the exact discount rate, the VLOOKUP function should be used. The syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). Here, the lookup_value is C4. The table_array is $G$2:$H$4 (absolute references are preferred so the formula can be copied down). The col_index_num is 2 because the discount percentage is in the second column of the table. The range_lookup must be FALSE or 0 to ensure an exact match is returned. Thus, the formula is =VLOOKUP(C4, $G$2:$H$4, 2, FALSE).

1.6 marks for using VLOOKUP with correct arguments. 2 marks for using absolute cell reference $G$2:$H$4 for the lookup array. 2 marks for setting the exact match parameter to FALSE or 0.

The nested IF formula checks the first condition (E12>25000) and returns 'Overweight' if true. If false, it evaluates the nested IF checking (E12<5000) and returns 'Underweight'. If both are false, it returns 'Standard'. Formula: =IF(E12>25000, "Overweight", IF(E12<5000, "Underweight", "Standard"))

1.6 marks for outer IF checking E12>25000. 2 marks for inner IF checking E12<5000. 2 marks for returning the correct string outputs and nesting structures.

To apply these layout settings: 1. Go to Page Layout -> Orientation -> Landscape. 2. Under Scaling, set width to 'Fit to 1 page wide'. 3. Under Sheet Options -> Gridlines, check 'Print'. 4. Under Sheet Options -> Headings, check 'Print'.

1.6 marks for setting Landscape orientation. 2 marks for setting scaling to fit 1 page wide. 2 marks for enabling print gridlines and print headings.

The AVERAGE function calculates the mean of range B8:D8. To round to 2 decimal places, wrap the average inside ROUND with parameter 2: =ROUND(AVERAGE(B8:D8), 2).

1.6 marks for correct AVERAGE calculation. 2 marks for correct ROUND syntax. 2 marks for using 2 decimal places.

The multiplication uses relative cells E5 and F5. The surcharge addition uses absolute reference $B$2 to stay constant. The combined formula is =E5*F5+$B$2.

1.6 marks for multiplying E5 and F5. 2 marks for absolute reference $B$2. 2 marks for adding the two components correctly.

The AND function is embedded inside the logical test of the IF function. It evaluates whether both F10<15 and G10='Active' are true. If so, it outputs 'Reorder'; otherwise, 'No Action'. Formula: =IF(AND(F10<15, G10="Active"), "Reorder", "No Action").

1.6 marks for AND function structure and logical checks. 2 marks for wrapping in IF function. 2 marks for returning correct text strings 'Reorder' and 'No Action'.

Step 1: Open 'COSTA_RICA_RAW.TXT' in your word processor. Choose 'Save As' and name the file 'GP_Factsheet' in your local directory. Step 2: Go to Layout > Orientation > Landscape. In Layout > Margins > Custom Margins, enter 2.0 cm for Top, Bottom, Left, and Right margins. Step 3: Double-click the header area, right-align the cursor, and type your Name, Candidate Number, and Center Number. Go to the footer area, select left-alignment, and use Insert > Page Number > Page X of Y format. Step 4: Type 'Eco-Tourism in Costa Rica' on the first line. Format it with Arial, 24pt size, Bold, Centered. Open Paragraph Settings and set Spacing After to 12pt. Step 5: Highlight all text below the main title. Go to Layout > Columns > More Columns. Choose 'Two' columns, set the Spacing to 1.0 cm, ensure 'Equal column width' is selected, and check the 'Line between' box. Click OK. Step 6: Position the cursor at the start of the second column. Go to Insert > Pictures and insert 'toucan.png'. Right-click the image, select Wrap Text > Tight. Set its width to 4.0 cm under Picture Format (ensuring aspect ratio lock is on). Add a caption text 'Fig 1: Keel-billed Toucan' directly beneath, selecting it and setting format to 9pt Italic. Step 7: Find the four rules under 'Eco-rules for Travelers'. Select them, click the drop-down next to the Bullets icon on the Home tab, and select square bullets. Open Paragraph Settings, set Special to Hanging, and value to 0.5 cm.

Award 16 marks total: [1 Mark] Document saved with the correct name 'GP_Factsheet'. [2 Marks] Page set to Landscape orientation (1 mark) and all margins configured to 2.0 cm (1 mark). [2 Marks] Candidate details in header are right-aligned (1 mark) and automated page number format 'Page X of Y' is left-aligned in footer (1 mark). [3 Marks] Correct title text entered (1 mark), formatted as Arial, 24pt, Bold, Centered (1 mark), and 12pt paragraph space after applied (1 mark). [3 Marks] Selected body text split into two columns of equal width (1 mark), column gap is exactly 1.0 cm (1 mark), and a vertical separator line is present (1 mark). [3 Marks] 'toucan.png' inserted at the top of column 2 with Tight text wrap (1 mark), image width is exactly 4.0 cm with aspect ratio intact (1 mark), and correct caption 'Fig 1: Keel-billed Toucan' in 9pt Italic is present below (1 mark). [2 Marks] Bulleted list uses square bullets (1 mark) with a 0.5 cm hanging indent applied (1 mark).