Edexcel iGCSE ICT 2021 Paper 2 Whole Paper

Mark Harrison・2 minutes read

Candidates must follow specific instructions to complete tasks involving tasks such as creating a logo, working with databases, and designing web pages for a skiing holiday scenario. The completion of the tasks requires attention to detail, adherence to design guidelines, and accurate data entry to showcase competency in ICT skills.

Insights

Task A1 involves creating a specific logo for a skiing company using PowerPoint, focusing on skiing-related elements and the company initials "TSR" in a serif font.
Task A2 requires database management, including creating forms, adding new entries, and generating queries based on specific criteria like hotel details and guest information.
Task A3 focuses on web page creation using HTML elements, emphasizing the design of a home page and a ski lesson page with specific layout instructions and linking images to external URLs.

Get key ideas from YouTube videos. It’s free

Recent questions

How do I create a logo in PowerPoint?
By using lines and shapes to represent skiing.
How can I add a logo to an existing image?
By saving the image with the company name.
What is the process of creating a database form?
By inputting hotel details and following house style guidelines.
How do I design a web page using HTML elements?
By creating pages based on wireframe designs.
How can I create a table in a spreadsheet?
By organizing content and formatting values.

Related videos

Summary

00:00

Edexcel IGCSE ICT Practical Paper Skiing

This is an Edexcel IGCSE ICT practical paper with a link provided for the paper, mark scheme, and necessary data files.
The required data files for this task are a skiing fact sheet, holiday website, and images.
Instructions on the first page must be carefully read, with a total of 100 marks to be attempted and printed out for submission.
Candidates must ensure their name, center number, etc., are on all printed documents.
The paper consists of two sections, A and B, focusing on graphics, database, web authoring, spreadsheet, and word processing.
The scenario involves a skiing holiday company with specific house style requirements like serif font for the company name and logo positioned at the top right.
Task A1 involves creating a logo with lines and shapes representing skiing, including the company initials "TSR" in serif font.
The logo is created using PowerPoint, saved as an image named "TSR logo," and inserted into the document without copying it.
Task A1B requires adding the logo to an existing image, "Mountain Skier," with the company name, saving it as "Mountain Skier 2," and inserting it into the document.
Task A2 involves saving guest and accommodation information in a database with tables for hotel, guest, and booking, and creating a form for additional hotels following house style guidelines.

16:13

Database Management Tasks and Web Page Creation

Properties changed: Width set to 2 centimeters, print screen and paste for examiner review.
Task A2: Add a new hotel using the hotel form created earlier, input details like Hotel ID, Hotel Name, Location, Price Range.
Screenshot: Capture completed form for Task A2, paste but do not print for two marks.
Task A2C: Query creation for hotels booked in Obergergle for 14 nights with ski pass, run query to check each step.
Save Query: Save query as Obergergle 14 Y, screenshot query design, paste into A2.
Field Selection: Display only Hotel ID, Price Range, Hotel Name in ascending order of Hotel ID, paste into A2.
Task A2D: Open guest table, list guests born in 1990, create query, save as 1990_query, screenshot design, paste into A2.
Field Selection: Show only Email, First Name, Date of Birth in ascending order of Date of Birth, save query as 1990_query.
Task A2E: Create a database report based on 1990_query, include suitable title, logo, footer with details, save as 1990_report, print.
Relationship Issue: Relationship broken in holiday database, enforce referential integrity, answer questions in Task A2.
Task A3: Open a new Word document, enter details, move to website creation task, create two web pages based on wireframe design using HTML elements.
Software Choice: Use Composer for web page creation, avoid Publisher to demonstrate HTML elements effectively.
Home Page Creation: Design home page with company name, page title, logo in top right corner, save as home.html.
Ski Lesson Page: Develop second page based on wireframe design, include all required elements, save as ski_lesson.html.

32:49

"Customize Table, Links, and Colors in Website"

To remove the border of a table, access Composer and edit the table cell properties by right-clicking on it.
Change the border pixels to 0 in the table cell properties to eliminate the border.
Adjust the page title to "Ski Run" by typing it in as an h2 header and underlining it.
Create a three by three table using tables to organize content, ensuring the border is set to zero pixels.
Insert links for "Home" and "Ski Lessons" on the left side and add introductory text in the middle of the table.
Insert two images, one below the other, with dimensions set to 200 by 200 pixels.
Include a "Contact Us" section with an email address, ensuring it is a mailto link.
Change the background color to #98AFC7 and the text color for introductory text to white.
Link one of the images to www.theskirun.net and save the home page as "index."
Create the Ski Lessons page by resaving the home page as "Ski Lessons" and make necessary adjustments to the content and links.

48:43

"Efficient Ski Resort Cost Calculation Worksheet"

Use Times New Roman font for consistency
Insert "completed" and current date in the header
Insert a blank row between heading and first row, adjust height
Use VLOOKUP function to display equipment cost based on level
Calculate ski pass cost with 20% discount for equipment over 300 euros
Enter formula to calculate total equipment hire and ski pass cost
Format currency values to show euros with no decimal places
Wrap text for headings to utilize space efficiently
Ensure all data is visible and row/column headings are displayed when printed
Save and print worksheet in landscape on one side of A4, showing values
Create a chart displaying ski run length percentages
Filter members worksheet to show only level three members
Save and print members worksheet
Create a fact sheet showing ski lesson prices adhering to provided instructions
Format headings and text according to the fact sheet document
Use appropriate font sizes and bullet points as instructed

01:05:12

Creating Ski School Table with Euro Pricing

The table creation process involves merging cells, changing font styles, sizes, and colors, and aligning text both vertically and horizontally.
The table includes sections for Sam's Ski School, private ski lessons, hours, prices in euros, and additional rows for group ski lessons.
Specific instructions detail font styles, sizes, and colors for each section of the table, ensuring a consistent and visually appealing design.
The table is organized with specific details for each category, such as ski lesson types, years, times, and corresponding prices in euros.
The use of symbols like the euro sign is incorporated into the table for accurate representation of pricing.
The table design requires attention to detail, including shading, font styles, and alignment to match the provided specifications.
The completion of the table involves meticulous adjustments to font sizes, styles, and colors to meet the required standards.
The final task involves saving and printing the completed table on one side of A4 paper, ensuring the inclusion of a header with the creator's name.

Try it yourself — It’s free.