Year 11 · ICT · Summer 1

Final revision and the exams · Lesson 3 of 5

Last Paper 2 practice

Exam practice17.3 Paragraph spacing, tabs and indents18.2 Manipulate data: calculations, sorting and queries19b Add and edit objects

Year 11 · ICT · Final revision and the exams · Lesson 3 of 5

What you will learn

You will learn to

  • Complete a Paper 2 practice under time, using your timing plan.
  • Use the final check routine before the last save.
  • Correct every lost mark using the mark scheme.

Success criteria

  • I can finish each task by its planned clock time.
  • I can show evidence for every step that asks for it.
  • I can fix every lost mark in the corrections time.

Year 11 · ICT · Final revision and the exams · Lesson 3 of 5

Retrieval starter

Questions from before. Write your answers, then show them.

  1. Last lesson

    Presenter notes are seen by…

    A The audienceB The speaker onlyC Nobody

    B. The speaker only

  2. Last unit

    A digital certificate…

    A Proves a website is who it says it isB Blocks pop-upsC Encrypts your hard disk

    A. Proves a website is who it says it is

  3. Earlier this year

    Cropping…

    A Flips itB Cuts away part of the imageC Makes it brighter

    B. Cuts away part of the image

Year 11 · ICT · Final revision and the exams · Lesson 3 of 5

Key words (1 of 9)

Page orientation
Whether the page is portrait (tall) or landscape (wide).
Margin
The blank border between the edge of the paper and the text.
Column
A vertical strip of text; text flows from one column to the next.
Column spacing
The gap between two columns.

Year 11 · ICT · Final revision and the exams · Lesson 3 of 5

Key words (2 of 9)

Page break
A marker that forces the text after it onto a new page.
Column break
A marker that forces the text after it into the next column.
Line spacing
The space between lines inside one paragraph.
Spacing before/after
Extra space above or below a paragraph, measured in points.

Year 11 · ICT · Final revision and the exams · Lesson 3 of 5

Key words (3 of 9)

Tab stop
A set position on a line that the cursor jumps to when the tab key is pressed.
Decimal tab
A tab stop that lines up numbers on their decimal points.
Hanging indent
All lines of a paragraph except the first are moved in from the margin.
First-line indent
Only the first line of a paragraph is moved in from the margin.

Year 11 · ICT · Final revision and the exams · Lesson 3 of 5

Key words (4 of 9)

Find and replace
A tool that finds text and swaps it for other text.
Match case
A find option that only finds text with the same capital and small letters.
Hyperlink
Text or an object that jumps to a slide, file, email address or web page when clicked.
Database
An organised store of data that can be searched, sorted and reported on.

Year 11 · ICT · Final revision and the exams · Lesson 3 of 5

Key words (5 of 9)

Table
A set of records about one kind of thing, such as members or bookings.
Record
One row of a table: all the data about one item.
Field
One column of a table: one piece of data stored for every record.
Field type
The kind of data a field holds: text, numeric, date/time or Boolean.

Year 11 · ICT · Final revision and the exams · Lesson 3 of 5

Key words (6 of 9)

Display format
How a value looks on screen or paper, without changing the stored value.
Query
A search that shows only the records that meet given criteria.
Criteria
The conditions a record must meet to appear in a query result.
Wildcard
A symbol in a search pattern: * means any number of characters, ? means exactly one.

Year 11 · ICT · Final revision and the exams · Lesson 3 of 5

Key words (7 of 9)

Calculated field
A field in a query that is worked out from other fields, not typed in.
Calculated control
A box on a report or form that shows a calculation, such as a total.
Master slide
A template slide whose layout, styles and objects appear on every slide.
Slide layout
A pattern of placeholders, such as title and content or two content.

Year 11 · ICT · Final revision and the exams · Lesson 3 of 5

Key words (8 of 9)

Action button
A ready-made shape, such as a Home arrow, that runs a link or action when clicked.
Presenter notes
Notes for the speaker under each slide, not shown to the audience on screen.
Alternative text
A short description of an image or object, read aloud by screen readers.
Looped presentation
A show that advances on timings and restarts by itself after the last slide.

Year 11 · ICT · Final revision and the exams · Lesson 3 of 5

Key words (9 of 9)

Slide sorter
A view showing small copies of every slide, used to reorder, hide or check slides.

17.3 Paragraph spacing, tabs and indents · The explanation · step 1 of 17 · part 1 of 2

Line spacing and paragraph spacing

Line spacing is the space between lines inside one paragraph. Common values: single, 1.15, 1.5, double.

Spacing before and after is the extra space above or below a whole paragraph, measured in points (pt). For example, 0 pt before and 6 pt after.

A typical task: "Set all body text to single line spacing with 6 pt spacing after each paragraph."

17.3 Paragraph spacing, tabs and indents · The explanation · step 1 of 17 · part 2 of 2

Line spacing and paragraph spacing (continued)

?Why?

Paragraph spacing separates ideas without blank lines. Blank lines give uneven gaps, especially at the top of columns and pages.

!Watch out

"All body text" includes the last paragraph and any list. Check that every paragraph has the same spacing after, including those you imported or moved.

17.3 Paragraph spacing, tabs and indents · The explanation · step 2 of 17 · part 1 of 3

Tab stops: four kinds

A tab stop is a fixed position on the line. Pressing the tab key jumps the cursor to it. Tabs line up text in neat columns without a table.

Left tab: text starts at the tab. Right tab: text ends at the tab. Centre tab: text is centred on the tab. Decimal tab: decimal points line up on the tab.

Set tabs at exact positions from the ruler or the tab settings, such as "a decimal tab at 12 cm".

17.3 Paragraph spacing, tabs and indents · The explanation · step 2 of 17 · part 2 of 3

Tab stops: four kinds (continued)

e.g.Example
Price list with a left tab at 1 cm and a decimal tab at 12 cm: →Road bike, 2 hours→12.50 →Electric bike, 2 hours→24.00 →Child seat→3.5 The decimal points line up under each other at 12 cm.
?Why?

Decimal tabs make prices easy to compare. Spaces never line up exactly, because letters have different widths.

17.3 Paragraph spacing, tabs and indents · The explanation · step 2 of 17 · part 3 of 3

Tab stops: four kinds (continued)

!Watch out

Using the space bar to line up columns always looks slightly wrong when printed. The examiner checks alignment, so use tab stops.

17.3 Paragraph spacing, tabs and indents · The explanation · step 3 of 17 · part 1 of 2

Indents: first line and hanging

An indent moves text in from the margin.

A first-line indent moves only the first line of a paragraph in. It is common in books.

A hanging indent keeps the first line at the margin and moves all the other lines in. It is used for lists and references, so the start of each item stands out.

17.3 Paragraph spacing, tabs and indents · The explanation · step 3 of 17 · part 2 of 2

Indents: first line and hanging (continued)

e.g.Example
Hanging indent of 1 cm: Terms: All bikes must be returned by 20:00 on the day of hire. The first line starts at the margin. The second line starts 1 cm in.
!Watch out

Do not make indents with spaces or tabs at the start of each line. If the text reflows, the lines go out of place. Use the indent settings.

18.2 Manipulate data: calculations, sorting and queries · The explanation · step 4 of 17 · part 1 of 3

Calculated fields and calculated controls

A calculated field is a new field in a query, worked out from other fields. It is not typed in and not stored in the table.

A calculated control is a box on a report or form that shows a calculation, such as a total.

In most database software you give the new field a name, a colon, then the formula. Field names go in square brackets.

18.2 Manipulate data: calculations, sorting and queries · The explanation · step 4 of 17 · part 2 of 3

Calculated fields and calculated controls (continued)

e.g.Example
Booking 101: Hours 1.5, Rate €12.00 Cost = 1.5 × 12.00 = €18.00 Booking 103: Hours 2, Rate €11.00 Cost = 2 × 11.00 = €22.00 All eight costs: 18.00, 4.50, 22.00, 4.50, 8.00, 12.00, 24.00, 11.00
Calculated field in a query:
Cost: [Hours]*[Rate]

Calculated control in a report footer:
=Sum([Cost])

18.2 Manipulate data: calculations, sorting and queries · The explanation · step 4 of 17 · part 3 of 3

Calculated fields and calculated controls (continued)

?Why?

Calculating, not storing, keeps the answer right. If someone corrects the hours, the cost updates by itself.

!Watch out

Spell the field names exactly as in the table. [Hour] instead of [Hours] makes the software ask for a value, and the answer is wrong.

18.2 Manipulate data: calculations, sorting and queries · The explanation · step 7 of 17 · part 1 of 2

Read a query grid: a simple search

A query asks the database a question and shows only the matching records. Most software gives you a design grid.

Each column is one field. The rows are: Field, Table, Sort, Show, Criteria and Or.

Criteria is the condition a record must meet. Show decides if the field appears in the result.

Task: find all Padel bookings, by date. The software adds quote marks around text, so "Padel" is fine.

18.2 Manipulate data: calculations, sorting and queries · The explanation · step 7 of 17 · part 2 of 2

Read a query grid: a simple search (continued)

FieldBookingIDActivityBookDateCost: [Hours]*[Rate]
TableBookingsBookingsBookings
SortAscending
Show✓✓✓✓
Criteria"Padel"
Or
e.g.Example
Result (3 records): 101 Padel 06/10/2026 €18.00 106 Padel 09/10/2026 €12.00 107 Padel 10/10/2026 €24.00

The explanation · 12 more steps

More on the lesson page

The lesson page has the rest of the explanation, step by step:

  • Sum, average, maximum, minimum, count
  • Sort on one or more fields
  • Comparison operators
  • AND: every condition must be true
  • OR: any condition can be true
  • NOT, LIKE and wildcards
  • Queries across two tables, and evidence
  • Text, images, charts and tables
  • Shapes, lines, audio and video
  • Alternative text
  • Action buttons and hyperlinks
  • Presenter notes

Open the lesson page

Year 11 · ICT · Final revision and the exams · Lesson 3 of 5

Quick quiz · 1 of 3

An advantage of an SSD over a hard disk is…

  1. A No moving parts, so it is faster and tougher
  2. B It is cheaper per GB
  3. C It has a bigger capacity

A. No moving parts, so it is faster and tougher

Hard disks still win on cost per GB.

Year 11 · ICT · Final revision and the exams · Lesson 3 of 5

Quick quiz · 2 of 3

A memory card in a camera is…

  1. A Optical
  2. B Magnetic
  3. C Solid state

C. Solid state

Flash memory, no moving parts.

Year 11 · ICT · Final revision and the exams · Lesson 3 of 5

Quick quiz · 3 of 3

A switch…

  1. A Connects to the ISP's line
  2. B Sends everything to every device
  3. C Sends data only to the device it is for

C. Sends data only to the device it is for

A hub sends to everyone. A modem talks to the ISP.

Year 11 · ICT · Final revision and the exams · Lesson 3 of 5

Exit ticket

Answer on paper before you go. Then check.

  1. A WLAN is…

    A A web linkB A wide area networkC A wireless local area network

    C. A wireless local area network A LAN over Wi-Fi.

  2. An intranet is…

    A The public internetB A type of cableC A private network inside an organisation

    C. A private network inside an organisation Same technology as the web, but only for the organisation's users.