Edexcel iGCSE ICT 2021 Paper 2 Whole Paper
Mark Harrison・6 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.
