Software Skills: Edexcel IGCSE Information and Communication Technology Complete Notes

Software Skills is Topic 6 in the Edexcel IGCSE (4IT1) Information and Communication Technology specification. It is the largest practical topic and is examined entirely on Paper 2, the three-hour practical paper. These notes cover all seven sub-topics.

Topic 6 is where the exam tests what you can actually do with software, not what you know about it. The software skills edexcel igcse content spans word processing, database management, spreadsheets, web authoring, presentations, graphics and file management. Each area has specific techniques that the specification lists and the exam can test. These edexcel igcse information and communication technology revision notes work through every area analytically, with worked examples and the kind of problem-solving approach that transfers directly to the practical paper.

Word processing

Word processing is one of the most consistently examined areas on Paper 2. The specification expects you to produce professional documents to a given brief, which means mastering both content entry and layout control.

Text entry and formatting:

• Enter text with accurate spelling, punctuation and grammar
• Apply formatting: bullets, numbering, sub-numbering, alignment (left, centre, right, justified), tabs, line spacing, colour, font size and style
• Use text wrap (flowing text around an image) and text boxes (independent text containers that can be positioned anywhere on the page)

Tables and columns:

• Create tables with horizontal and vertical text alignment within cells
• Merge and split cells (combining cells for headings, splitting for sub-categories)
• Apply gridlines, borders and shading to improve readability
• Use columns for newsletter-style layouts

Page layout features:

• Headings and sub-headings for document structure
• Headers and footers (content that repeats on every page)
• Portrait and landscape orientation
• Page breaks (forcing content onto a new page)
• Page numbering
• Templates (pre-designed layouts for consistent formatting)

Integration: Bringing together content from different sources into a single document: charts from a spreadsheet, tables, images, callouts/autoshapes, text from different files, text boxes, grouped and layered objects, and values linked from spreadsheets.

Document types and conventions: The exam may ask you to produce a letter (with salutation, complimentary close, date, subject line), a report, a newsletter, a poster, a leaflet, an information sheet (fact sheet) or a memo. Each has standard conventions you must follow.

Mail merge: Creating personalised documents by combining a template with a data source (from a word-processed table, spreadsheet or database). You need to understand how to set up the main document with merge fields, connect it to the data source, and produce individual documents for each record.

Database management

Database skills are heavily examined. The specification covers both understanding database structure and performing practical tasks.

Data types:

Database structure: A record is one complete entry (one row). A field is one category of data (one column). A table is a collection of related records. A primary key is a field that uniquely identifies each record (no duplicates allowed). A foreign key links a record in one table to a record in another, creating relationships between tables.

Validation: Checking that data entered meets certain rules before it is accepted:

• Range check - value must fall within a specified range (age between 0 and 120)
• Presence check - the field must not be left empty
• Type check - the data must be the correct type (number, not text)
• Length check - the data must have a specific number of characters (a postcode with 6-8 characters)

Sorting: Organising records by one or more fields, in ascending (A-Z, 0-9) or descending (Z-A, 9-0) order.

Queries/searches: Finding specific records using criteria. Queries can use a single criterion (Country = "UK"), multiple criteria (Country = "UK" AND Age > 18), relational operators (=, <, >, <=, >=, <>) and logical operators (AND, OR, NOT).

Outputs: Reports, mail merge documents, views showing specified fields, design view (table structure, queries, forms, relationships) and data view (tables, query results, forms).

Spreadsheet

Spreadsheet skills receive very heavy exam attention. The igcse 4it1 software skills specification lists a detailed set of techniques.

Formatting: Currency, percentage, decimal places, date, time, text wrap, row height, column width, gridlines, merge/split cells, cell borders, cell shading, hiding rows and columns.

Formulae: Using arithmetic operators (+, -, *, /), calculating percentages, combining multiple operators in a single formula, and understanding the difference between absolute ($A$1 - stays fixed when copied) and relative (A1 - adjusts when copied) cell referencing. Named cells and ranges can also be used in formulae.

Functions:

Charts: Pie chart (proportions of a whole), line chart (trends over time), bar/column chart (comparing categories), scattergram (relationship between two variables). Each chart should have a title, axis labels, a legend and appropriate scale. Trend lines can be added to show the direction of data.

Printing: You may need to print selected rows/columns, in formula view or data view, in landscape or portrait, with headers and footers, and with row and column headings visible.

Web authoring

The specification covers basic web page creation:

• Using templates with tables/frames, standard page features, banners and navigation menus
• Inserting text, images, buttons and animation
• Formatting: headings, subheadings, body text, alignment
• Using HTML code to insert hyperlinks, insert images and apply font enhancements

The exam does not expect you to be a professional web developer. It expects you to be able to create a functional, well-structured web page that includes navigation, content and appropriate formatting.

Presentation

Presentation skills appear on Paper 2 regularly. The key areas are:

• Master slide / template: Setting up a consistent look across all slides using placeholders, footer, slide number, background and font choices
• Slide creation: Inserting text, images, action buttons and hyperlinks; adding animation effects (making elements appear, move or disappear) and transition effects (how one slide changes to the next)
• Printing: Handouts (multiple slides per page), notes pages (slides with presenter notes), full-page slides, with headers and footers

Graphics

Graphics receives substantial attention on Paper 2. The specification distinguishes between two image types:

• Bitmap images are made up of pixels. They lose quality when enlarged (pixelation). Common formats: JPEG, PNG, BMP, GIF.
• Vector images are made up of mathematical shapes and lines. They can be resized without losing quality. Common formats: SVG, AI.

You need to be able to create images by combining basic shapes (rectangles, circles, lines, triangles, arrows) and text, and edit images by cropping, adding captions, and removing unwanted elements.

File management

The final sub-topic is straightforward but essential:

• Save work regularly to avoid losing progress
• Use sensible filenames that describe the content ("Budget_2025.xlsx" rather than "Sheet1.xlsx")
• Use appropriate file formats for the task (PDF for sharing documents that should not be edited, DOCX for documents that will be edited further)
• Create and manage folder structures that organise files logically (by project, by date, by type)
• Keep information secure by using passwords, access controls and regular backups

Common mistakes

• Using relative references when absolute ones are needed. If you copy a formula down a column and the result changes unexpectedly, check whether you need a $ sign to lock a cell reference.
• Choosing the wrong chart type. Pie charts show proportions. Line charts show trends over time. Bar charts compare categories. A pie chart for trend data will not communicate the pattern.
• Not applying validation in databases. If the task asks you to add validation, you must specify the type (range, presence, type, length) and the rule. Simply naming the validation type without defining the rule earns no marks.
• Forgetting to format printouts correctly. If the task asks for formula view with gridlines in landscape, make sure all three requirements are met. Missing one loses marks.
• Weak mail merge setup. The merge fields in the document must match the column headers in the data source exactly. A field called "First Name" will not merge if the column header says "FirstName."

Self-check questions

1. Write a formula using the IF function that displays "Over budget" if cell B5 is greater than cell B6, and "Within budget" otherwise.
2. Explain the difference between a primary key and a foreign key in a database.
3. A task requires you to print a spreadsheet showing all formulae, with row and column headings, in landscape orientation. List the three settings you would change.
4. Describe two differences between bitmap and vector images.
5. A company wants to send a personalised invoice to each customer using mail merge. Describe the two components needed (main document and data source) and explain how they work together.
6. State two validation checks you could apply to a "Date of Birth" field in a database, and explain what each one does.

These edexcel igcse information and communication technology practice questions test the specific techniques Paper 2 demands. The edexcel igcse information and communication technology notes for Software Skills are practical by nature: the best revision is doing, not reading. Open the software, build a spreadsheet with nested functions, create a database with queries, produce a mail-merged letter, and evaluate the result. That hands-on practice is what the edexcel igcse information and communication technology explained answers on Paper 2 are built from.