WeLearn

Grade 10 Information Technology · Unit 3

Application Software

Unit 3 of the Grade 10 Information Technology textbook has 3 lessons: Word Processing, Spreadsheets and PowerPoint Presentations.

Lesson 3.1

Word Processing

In Grade 9 you learned to type, edit and format text. Grade 10 word processing focuses on producing long, professional documents efficiently.

StyleTable of contentsSection breakFootnoteMail mergeMerge fieldTrack Changes

Lesson 3.2

Spreadsheets

Grade 10 spreadsheet work builds on cells, formulas and basic functions. An important new idea is cell referencing.

Relative referenceAbsolute referenceIF functionCOUNTIF/SUMIFConditional formattingData validationFilter

Lesson 3.3

PowerPoint Presentations

Microsoft PowerPoint is the most widely used presentation program, and LibreOffice Impress and Google Slides work in similar ways. A presentation file (.pptx) contains slides, each built from placeholders for titles, text, pictures, charts and media.

Slide MasterLayoutSmartArtHyperlinkAnimation PanePresenter ViewRehearse Timings

Practice questions

3 of the 6 questions in the Unit 3 quiz. Try each one, then reveal the answer.

  1. 1. Which word-processing feature produces many personalised letters from one template and a list of names?

    • A. Mail merge
    • B. Word count
    • C. Track changes
    • D. Page break
    Show answer

    Answer: Mail merge

    Mail merge joins a main document with a data source, inserting each record's name and details into its own copy.

  2. 2. In a spreadsheet, which reference stays fixed when the formula is copied to other cells?

    • A. A1
    • B. $A$1
    • C. A$
    • D. 1A
    Show answer

    Answer: $A$1

    Dollar signs lock the column and row, making an absolute reference. A1 is relative and changes as it is copied.

  3. 3. In PowerPoint, which view is best for rearranging the order of many slides?

    • A. Normal view
    • B. Slide Sorter view
    • C. Reading view
    • D. Notes Page view
    Show answer

    Answer: Slide Sorter view

    Slide Sorter shows thumbnails of all slides so you can drag them into a new order quickly.

Teach Information Technology Unit 3 with WeLearn

We will bring a demo to your school: a lesson on your interactive TV, a virtual lab and a classroom game, with your own teachers.