Year 11 · ICT · Autumn 2

Paper 2 practice: documents, databases, presentations · Lesson 5 of 5

A full Paper 2

Exam practice17.1 Page setup: size, orientation, margins and gutter18.2 Manipulate data: calculations, sorting and queries19c Transitions, animations and outputs

Year 11 · ICT · Paper 2 practice: documents, databases, presentations · Lesson 5 of 5

You will learn to

  • Complete a full Paper 2 in 2 hours 15 minutes.
  • Use a timing plan with clock times for each task and 15 minutes to check.
  • Use the mark scheme to mark the paper and sort each lost mark by its cause.
  • Update your tracker from the result.

Year 11 · ICT · Paper 2 practice: documents, databases, presentations · Lesson 5 of 5

Success criteria

You have got it when you can say:

  • I can write my clock times on the paper before I start.
  • I can attempt every task, even if some steps are not finished.
  • I can say which skills went red, amber or green on my tracker.

Year 11 · ICT · Paper 2 practice: documents, databases, presentations · Lesson 5 of 5

Retrieval starter

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

  1. Last lesson

    A pie chart is for…

    A Parts of a wholeB Comparing 30 categoriesC Change over time

    A. Parts of a whole

  2. Last unit

    Bcc is used so that…

    A The email is biggerB It arrives fasterC Recipients cannot see each other's addresses

    C. Recipients cannot see each other's addresses

  3. Earlier this unit

    Presenter notes are seen by…

    A NobodyB The audienceC The speaker only

    C. The speaker only

Year 11 · ICT · Paper 2 practice: documents, databases, presentations · Lesson 5 of 5

Key words (1 of 8)

Page orientation
Whether the page is portrait (tall) or landscape (wide).
Margin
The blank border between the edge of the paper and the text.
Gutter
Extra margin on the edge that will be bound, so text is not lost in the binding.
Column
A vertical strip of text; text flows from one column to the next.

Year 11 · ICT · Paper 2 practice: documents, databases, presentations · Lesson 5 of 5

Key words (2 of 8)

Column spacing
The gap between two columns.
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.

Year 11 · ICT · Paper 2 practice: documents, databases, presentations · Lesson 5 of 5

Key words (3 of 8)

Tab stop
A set position on a line that the cursor jumps to when the tab key is pressed.
Hanging indent
All lines of a paragraph except the first are moved in from the margin.
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.

Year 11 · ICT · Paper 2 practice: documents, databases, presentations · Lesson 5 of 5

Key words (4 of 8)

Database
An organised store of data that can be searched, sorted and reported on.
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.

Year 11 · ICT · Paper 2 practice: documents, databases, presentations · Lesson 5 of 5

Key words (5 of 8)

Field type
The kind of data a field holds: text, numeric, date/time or Boolean.
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.

Year 11 · ICT · Paper 2 practice: documents, databases, presentations · Lesson 5 of 5

Key words (6 of 8)

Wildcard
A symbol in a search pattern: * means any number of characters, ? means exactly one.
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.
Slide layout
A pattern of placeholders, such as title and content or two content.

Year 11 · ICT · Paper 2 practice: documents, databases, presentations · Lesson 5 of 5

Key words (7 of 8)

Transition
The visual effect when one slide changes to the next.
Animation
A visual effect that makes an object on a slide appear, move or disappear.
Presenter notes
Notes for the speaker under each slide, not shown to the audience on screen.
Hidden slide
A slide kept in the file but skipped when the show runs.

Year 11 · ICT · Paper 2 practice: documents, databases, presentations · Lesson 5 of 5

Key words (8 of 8)

Looped presentation
A show that advances on timings and restarts by itself after the last slide.
Presenter-controlled
A show that moves to the next slide only when the speaker clicks or presses a key.
Handout
A printout with several slides on each page for the audience.
Slide sorter
A view showing small copies of every slide, used to reorder, hide or check slides.

The explanation · step 1 of 18 · part 1 of 2

Timing a practical paper

Paper 2 is 70 marks in 2 hours 15 minutes. That is 135 minutes: just under 2 minutes a mark.

  1. Spend the first few minutes reading the whole paper.
  2. Write a clock time on the paper for moving on from each task.
  3. Keep the last 15 minutes for the final check and the last save.

The explanation · step 1 of 18 · part 2 of 2

Timing a practical paper (continued)

e.g.Example

Start at 09:00. The paper ends at 11:15. Start the final check at 11:00.

!Watch out

Do not spend ten minutes on one step. Note it, move on and come back. Many later steps do not depend on it.

The explanation · step 2 of 18 · part 1 of 2

Reviewing the paper

Mark the paper with the scheme. Then sort every lost mark by its cause.

CauseExampleFix
Did not know howCould not make a calculated field in a reportPractise that skill on its own, then in a timed task
Did not follow the specUsed 12 point when the paper said 11 pointRead each step twice. Tick it only when it matches
No evidenceThe query was right, but there was no screenshotTake the screenshot as soon as the paper asks
Ran out of timeThe presentation was never startedUse the clock times in every practice paper

The explanation · step 2 of 18 · part 2 of 2

Reviewing the paper (continued)

★Remember

Count your lost marks by cause. Fix the biggest group first.

17.1 Page setup: size, orientation, margins and gutter · The explanation · step 3 of 18 · part 1 of 2

How a Paper 2 document task starts

Paper 2 usually begins: "Open the file J2611news.rtf. Save it in your work area as a document with the file name NEWS." Then come the page setup instructions.

A typical set: "Set the page size to A4. Set the page orientation to landscape. Set all margins to 2 cm."

Do the page setup first. Everything else, such as columns and image sizes, depends on it.

17.1 Page setup: size, orientation, margins and gutter · The explanation · step 3 of 18 · part 2 of 2

How a Paper 2 document task starts (continued)

?Why?

Changing margins later moves all the text, so tables, images and page breaks you placed earlier end up in the wrong place.

!Watch out

Save in the application's own format, as the task asks, not as .rtf again. Use the exact file name given, with the same capitals.

17.1 Page setup: size, orientation, margins and gutter · The explanation · step 4 of 18 · part 1 of 2

Page size and orientation

Page size is the paper size. In Spain and the UK the standard is A4 (21 cm × 29.7 cm). Letter size (21.6 cm × 27.9 cm) is used in the USA.

Orientation is the way the page is turned. Portrait is taller than it is wide. Landscape is wider than it is tall.

Use landscape for wide content, such as a table with many columns or a poster.

17.1 Page setup: size, orientation, margins and gutter · The explanation · step 4 of 18 · part 2 of 2

Page size and orientation (continued)

!Watch out

Source files from Cambridge are sometimes set to Letter. If the task says A4, change it. The examiner can see the difference in the printout's margins.

17.1 Page setup: size, orientation, margins and gutter · The explanation · step 5 of 18 · part 1 of 3

Margins and gutter

Margins are the blank borders between the edge of the paper and the text. You set four: top, bottom, left and right.

A gutter is extra margin added to the edge that will be bound, such as stapled or ring-bound. It stops text disappearing into the binding.

A typical task: "Set the top and bottom margins to 2.5 cm, the left and right margins to 2 cm, and a gutter of 1 cm on the left."

17.1 Page setup: size, orientation, margins and gutter · The explanation · step 5 of 18 · part 2 of 3

Margins and gutter (continued)

e.g.Example
A4 portrait is 21 cm wide. Left margin 2 cm + gutter 1 cm + right margin 2 cm = 5 cm. Width left for text = 21 − 5 = 16 cm.
?Why?

Knowing the text width helps you check later tasks. An image that should fill the width must be 16 cm here, not 21 cm.

17.1 Page setup: size, orientation, margins and gutter · The explanation · step 5 of 18 · part 3 of 3

Margins and gutter (continued)

!Watch out

After changing margins, check the header and footer. Right-aligned items must still sit on the new right margin. Moving the right tab stop is often needed.

The explanation · 13 more steps

More on the lesson page

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

  • Calculated fields and calculated controls
  • Sum, average, maximum, minimum, count
  • Sort on one or more fields
  • Read a query grid: a simple search
  • Comparison operators
  • AND: every condition must be true
  • OR: any condition can be true
  • NOT, LIKE and wildcards
  • Queries across two tables, and evidence
  • Transitions and animations, used consistently
  • Hidden slides
  • Looped or presenter-controlled
  • Print slides, notes and handouts

Open the lesson page

Year 11 · ICT · Paper 2 practice: documents, databases, presentations · Lesson 5 of 5

Quick quiz · 1 of 3

A house style…

  1. A Is only for websites
  2. B Keeps every document consistent
  3. C Is a type of font

B. Keeps every document consistent

Same fonts, colours and layout everywhere.

Year 11 · ICT · Paper 2 practice: documents, databases, presentations · Lesson 5 of 5

Quick quiz · 2 of 3

A style can set…

  1. A The file name
  2. B Only the colour
  3. C Font, size, colour, alignment and spacing

C. Font, size, colour, alignment and spacing

And bullets, line spacing, bold and italic.

Year 11 · ICT · Paper 2 practice: documents, databases, presentations · Lesson 5 of 5

Quick quiz · 3 of 3

Spacing 'after' a paragraph is…

  1. A The line spacing
  2. B The margin
  3. C The space below it before the next paragraph

C. The space below it before the next paragraph

Spacing before and after are separate settings.

Year 11 · ICT · Paper 2 practice: documents, databases, presentations · Lesson 5 of 5

Exit ticket

Answer on paper before you go. Then check.

  1. Applying a style instead of formatting by hand means…

    A It is slowerB Changing the style changes every heading at onceC It only works in Word

    B. Changing the style changes every heading at once Consistency and speed.

  2. Validation checks that…

    A The data is sensible: the right type and in rangeB The data is what the person meantC The spelling is right

    A. The data is sensible: the right type and in range It cannot know the truth, only the shape.

Year 11 · ICT · Paper 2 practice: documents, databases, presentations · Lesson 5 of 5

Homework and the challenge

Homework

The ICT 17, ICT 18 and ICT 19 quizzes.

End-of-unit challenge

A full Paper 2 under time.