Lecture Notes: May 2024 Edexcel IGCSE ICT Paper 2 Practical

Introduction

• Overview of the paper structure:
  • Consists of two sections.
  • Includes software data files in an evidence folder.
  • Emphasizes both practical tasks and theory.

Section 1: Task A

Task A1: Logo Design

• Objective: Create a logo for 'Hire It' company.
  • Use shapes (rectangle, circle, line) to design the logo.
  • Include company name in bold serif font.
• Tools: Photoshop or alternative like Photopia.
• Steps:
  • Use shapes to create a car theme.
  • Incorporate suitable colors (e.g., blue for safety).
  • Add text 'Hire It' in white for visibility.
  • Save the logo as a transparent PNG format.

Task A1B: Image Editing

• Objective: Edit an image for presentation.
  • Dimensions: 450px width, 300px height.
  • Remove car from road, add logo.
• Steps:
  • Use lasso tool for editing.
  • Adjust image size and integrate logo.
  • Save as 'edit1.png'.

Task A1C: Documentation

• Objective: Answer questions in evidence document.
• Example Question: Explain why file names should differ from originals.
  • Original remains available for future use or editing.

Task A2: Database Management

Task A2A: Form Creation

• Objective: Create a form for the car table in the database.
  • Include heading, field adjustments.
• Steps:
  • Design form layout.
  • Adjust field widths, colors, and padding.
  • Save as 'Cars Form'.

Task A2B-D: Queries and Reports

• Objective: Create queries to filter data based on criteria.
  • Query for large SUVs, automatic, electric cars.
  • Client query for insurance and deposits.
• Steps:
  • Use database relations to filter data.
  • Generate reports and apply formatting.
  • Save and document results.

Task A3: Presentation Creation

• Objective: Create a 3-slide presentation.
  • Use light green background, dark green text on slides 1 and 2.
  • Include images, apply transitions, and set slide timings.
• Steps:
  • Use master slides for consistent design.
  • Integrate images and text with animations.
  • Save as 'Office Presentation'.

Section B: Task B

Task B1: Spreadsheet Analysis

• Objective: Perform data analysis using spreadsheet tools.
  • Formatting, VLOOKUP function, and cost calculations.
• Steps:
  • Format headers and date format.
  • Use VLOOKUP for cost and insurance data.
  • Calculate hire cost and apply discounts.
  • Generate summaries and totals.

Task B2: Filtering Data

• Objective: Filter data to display specific information.
• Steps:
  • Apply filters for large SUV and specific days.
  • Display relevant columns only.
  • Save filtered spreadsheet as 'Filter'.

Task B3-4: Document Editing

• Objective: Edit document for presentation and print.
  • Apply formatting, columns, and alt text.
• Steps:
  • Change page layout, add footers.
  • Ensure document fits one page, save as 'Information Sheet 2'.

Conclusion

• Tasks Covered: Logo design, image editing, database management, presentation creation, spreadsheet manipulation, and document editing.
• Key Learnings: Practical application of ICT tools for business scenarios.

Note: Remember to save all works in designated folders and formats as required by the paper guidelines. Always validate your work with the evidence folder.