Year 6 · Autumn 2 · Week 8 of 30

Combining apps

Objective I can put an Excel chart into a document or slide.I can put a Google Sheets chart into a document or slide.I can put a Numbers chart into a document or slide.

Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration Advanced productivity ⏱ 30 minutes

Suggested 30-minute plan

A shape to adapt — not a script. Reorder, extend or trim to suit your class.

  1. Connect5 min

    Recap last week and share today’s goal: I can put an Excel chart into a document or slide.I can put a Google Sheets chart into a document or slide.I can put a Numbers chart into a document or slide.. Show a quick example of combining apps to hook interest and check what pupils already know.

  2. Teach & model8 min

    Model the key steps on the board using Word, Excel and PowerPointGoogle Docs, Google Sheets and Google SlidesPages, Numbers and Keynote. Think aloud, name the buttons and menus, and show one common mistake and how to fix it.

  3. Practise13 min

    Pupils work on today’s task — combining apps — using Word, Excel and PowerPointGoogle Docs, Google Sheets and Google SlidesPages, Numbers and Keynote. Use the prepared materials: An Excel chart ready to copy into a document or slideA Google Sheets chart ready to copy into a document or slideA Numbers chart ready to copy into a document or slide. Circulate, prompt against the success criteria, and pair finishers with pupils who need support.

  4. Review & reflect4 min

    Pupils check their work against the “I can…” objective, save and tidy up, then share one thing that went well and one to improve. Preview next week.

Adapting for your class

Support

Pre-open the app and any files, give a printed step-by-step, and pair with a confident partner. Keep the focus on the core “I can…”.

Challenge

Ask pupils to add an extra feature, explain the steps back to the class, or help a partner who is stuck.