Digital Literacy & Applied ICT · long-term overview
Year 5 — Sharing, permissions and working with data
Co-authoring, spreadsheets, Forms and surveys.Co-authoring, spreadsheets, Google Forms and surveys.Co-authoring, spreadsheets, Forms and surveys.
- Apps: Microsoft 365Google Workspace for EducationApple (iPad-led)
- Shape: 30 minutes per week · 30 weeks per year · iPad and Windows (Microsoft 365)30 minutes per week · 30 weeks per year · tablet and Chromebook (Google Workspace)30 minutes per week · 30 weeks per year · iPad-led (Pages, Keynote, Numbers)
- Lessons: 30 weekly + 1 optional extra
Before you start
Each year is 30 weeks across six half-terms of five weeks. This is a long-term map: it gives the weekly focus, an “I can…” objective, the apps and the safety link. Weeks are a guide; half-terms can be reordered to suit your calendar, though skills within a year build in sequence.
Almost everything runs in a browser or the Microsoft 365 web apps, so it works on both iPads and Windows laptops. Where a task is smoother on a laptop (for example Excel, file management in File Explorer, or Teams), that is noted in the “Tools / apps” column. “Word for the web” is used where real-time co-authoring is the point of the lesson.Almost everything runs in the browser, so it works on both tablets and Chromebooks. Where a task is smoother with a keyboard and trackpad (for example Google Sheets, file management in the Files app, or Google Classroom), that is noted in the “Tools / apps” column. Sharing a Google Doc with editing rights is used where real-time co-editing is the point of the lesson.Everything here runs on the iPad, in the built-in apps or in Safari. Where a task is smoother with a keyboard (for example Numbers, or longer writing in Pages), attach one if you have them. Pages with Collaborate turned on is used where real-time co-editing is the point of the lesson. Email, surveys and handing work out come from your school's Microsoft or Google accounts.
The online-safety strand opens each half-term — shaded on screen, marked ▪ in print — and maps to a ready-made ProjectEVOLVE activity, so staff export an age-appropriate lesson rather than plan from scratch. Rows marked “Optional” sit outside the 30 weeks — take them if there is room, skip them without breaking the sequence.
Apps used this year
| App | What it is used for | Lessons |
|---|---|---|
| ExcelGoogle SheetsNumbers | Data, simple formulas and charts. Smoother on a laptop than an iPad.Data, simple formulas and charts. Smoother on a Chromebook than a tablet.Data, simple formulas and charts. Numbers starts from a blank canvas — add a table first. | 8 |
| Web browser | Works on iPad and laptop. Used for searching and for ProjectEVOLVE lessons.Chrome on a Chromebook or tablet. Used for searching and for ProjectEVOLVE lessons.Safari on the iPad. Used for searching and for ProjectEVOLVE lessons. | 7 |
| OneDriveGoogle DriveiCloud Drive | Cloud storage. The home for everything — saving, organising, sharing, versions.Cloud storage. The home for everything — saving, organising, sharing, version history.Cloud storage in the Files app. The home for everything — saving, organising, sharing, versions. | 5 |
| Word for the webGoogle Docs (co-editing)Pages (co-editing) | The browser version — use it when real-time co-authoring is the point of the lesson.The same Google Doc, shared with editing rights — use it when real-time co-editing is the point of the lesson.Pages with Collaborate turned on — use it when real-time co-editing is the point of the lesson. | 5 |
| FormsGoogle FormsForms | Quick surveys and quizzes; responses flow straight into Excel for charts.Quick surveys and quizzes; responses flow straight into Google Sheets for charts.There is no built-in iPad survey app — use Microsoft or Google Forms in Safari, whichever your school has. | 4 |
| PowerPointGoogle SlidesKeynote | Slides and presenting. Keep templates simple so pupils focus on the content.Slides and presenting. Keep templates simple so pupils focus on the content.Slides and presenting. Keep templates simple so pupils focus on the content — Magic Move is a good reward, not the lesson. | 3 |
| OutlookGmailMail | School email. Set up a class distribution list before the first email lesson.School email. Set up a class Google Group before the first email lesson, and check pupil sending is allowed in the Admin console.The iPad Mail app, signed in to your school's Microsoft or Google email. Set up a class group before the first email lesson. | 2 |
| Outlook calendarGoogle CalendarCalendar | Organising events and tasks, where pupil calendars are available.Organising events and tasks, where pupil calendars are available.The iPad Calendar app, showing the school account's calendar where pupil calendars are available. | 1 |
| Snap layoutsSplit screenSplit View | Drag a window to the side of the screen, or use the Windows key with the arrows, to put two side by side.Drag a window to the side of the screen, or hold the maximise button, to put two side by side.Split View on the iPad: drag a second app from the Dock to work with two at once. | 1 |
| WordGoogle DocsPages | Writing and layout. Save to OneDrive so work follows pupils across devices.Writing and layout. Saves to Google Drive automatically, so work follows pupils across devices.Writing and layout. Save to iCloud Drive so work follows pupils across devices. | 1 |
Online safety this year
| Strand | What it covers | Taught in |
|---|---|---|
| Self-image & identity | How pupils present themselves online, and how online and offline identity connect. | wk 1 wk 21 |
| Privacy & security | Protecting personal information, passwords and accounts, and spotting scams. | wk 6 wk 11 |
| Managing online information | Searching well, and judging whether information online is reliable and true. | wk 16 |
| Copyright & ownership | Respecting others’ work, crediting sources and understanding ownership online. | wk 26 |
Week by week
Autumn 1
Sharing & permissions
| Wk | Focus and “I can…” objective | Tools / apps | Strand |
|---|---|---|---|
| 1 |
Our digital community I can help agree how our class behaves online. Materials: ProjectEVOLVE Self-image & identity (Y5) resources; class pledge template |
Web browser | Online safety — Self-image & identity |
| 2 |
Cloud vs device I can explain why saving to OneDrive is safer and find version history.I can explain why saving to Google Drive is safer and find version history.I can explain why saving to iCloud Drive is safer and find version history. Materials: A file with several saved versions to demonstrate version history |
OneDriveGoogle DriveiCloud Drive | Core ICT & file management |
| 3 |
Sharing files I can share a file using a link or by inviting someone. Materials: A file per pupil in OneDrive to share; a partner or teacher to share withA file per pupil in Google Drive to share; a partner or teacher to share withA file per pupil in iCloud Drive to share; a partner or teacher to share with |
OneDriveGoogle DriveiCloud Drive | Core ICT & file management |
| 4 |
Permissions I can choose whether someone can view or edit my work. Materials: A shared file on which to set view / edit permissions |
OneDriveGoogle DriveiCloud Drive | Core ICT & file management |
| 5 |
Recap I can share work with the right people and permissions. Materials: Task card: share a file with the right people and permissions |
OneDriveGoogle DriveiCloud Drive | Core ICT & file management |
Autumn 2
Co-authoring
| Wk | Focus and “I can…” objective | Tools / apps | Strand |
|---|---|---|---|
| 6 |
Strong passwords & security I can create strong passwords and keep my accounts secure. Materials: ProjectEVOLVE Privacy & security (Y5) resources and slides (exported) |
Web browser | Online safety — Privacy & security |
| 7 |
Real-time co-authoring I can work in the same document as others at the same time. Materials: One shared group document set up for simultaneous editing |
Word for the webGoogle Docs (co-editing)Pages (co-editing) | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
| 8 |
Comments and @mentions I can use comments and @mentions to communicate in a file. Materials: A shared document with prompts to comment on |
Word for the webGoogle Docs (co-editing)Pages (co-editing) | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
| 9 |
Suggesting changes I can suggest edits without changing the original straight away. Materials: A shared document in which to make suggested edits |
Word for the webGoogle Docs (co-editing)Pages (co-editing) | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
| 10 |
Collaborative document I can co-write a document with a group. Materials: A group shared document; collaborative task brief |
Word for the webGoogle Docs (co-editing)Pages (co-editing) | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
Spring 1
Working with data
| Wk | Focus and “I can…” objective | Tools / apps | Strand |
|---|---|---|---|
| 11 |
Spam and scams I can recognise spam and scams and know what to do. Materials: ProjectEVOLVE Privacy & security (Y5) resources; safe screenshots of example spam/scams |
Web browser | Online safety — Privacy & security |
| 12 |
Spreadsheet basics I can enter data into cells, rows and columns. Materials: Blank/part-filled Excel sheet shared via Teams; sample data to enterBlank/part-filled Google Sheets file shared via Google Classroom; sample data to enterBlank/part-filled Numbers spreadsheet shared via Schoolwork; sample data to enter |
ExcelGoogle SheetsNumbers | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
| 13 |
Simple formulas I can use SUM and AVERAGE to calculate. Materials: An Excel sheet with data ready for SUM and AVERAGEA Google Sheets file with data ready for SUM and AVERAGEA Numbers spreadsheet with data ready for SUM and AVERAGE |
ExcelGoogle SheetsNumbers | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
| 14 |
Making a chart I can turn data into a suitable chart. Materials: An Excel sheet with a data set ready to chartA Google Sheets file with a data set ready to chartA Numbers spreadsheet with a data set ready to chart |
ExcelGoogle SheetsNumbers | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
| 15 |
Review I can build a small spreadsheet with a chart. Materials: A task data set; success criteria for a spreadsheet and chart |
ExcelGoogle SheetsNumbers | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
Spring 2
Surveys & sources
| Wk | Focus and “I can…” objective | Tools / apps | Strand |
|---|---|---|---|
| 16 |
Evaluating and citing sources I can judge a source and record where information came from. Materials: ProjectEVOLVE Managing online information (Y5) resources; example sources; citation template |
Web browser | Online safety — Managing online information |
| 17 |
Creating a Form I can create a survey or quiz with Forms.I can create a survey or quiz with Google Forms.I can create a survey or quiz with Forms. Materials: Forms access enabled; an example survey/quiz on slidesGoogle Forms access enabled; an example survey/quiz on slidesForms access enabled; an example survey/quiz on slides |
FormsGoogle FormsForms | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
| 18 |
Collecting responses I can share a form and collect responses. Materials: A shared Form ready to distribute |
FormsGoogle FormsForms | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
| 19 |
Analysing responses I can turn responses into a chart and explain them. Materials: A Form with sample responses already collected |
Forms, ExcelGoogle Forms, Google SheetsForms, Numbers | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
| 20 |
Mini data project I can plan, collect and present data. Materials: Data project brief; Forms and Excel set upData project brief; Google Forms and Google Sheets set upData project brief; Forms and Numbers set up |
Forms, ExcelGoogle Forms, Google SheetsForms, Numbers | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
| Extra |
Two windows at once Optional I can put a source and my own work side by side, and move between open apps without losing my place. Materials: A short online source and a blank document; a task that needs three facts moved from one to the other |
Snap layouts, Web browser, WordSplit screen, Web browser, Google DocsSplit View, Web browser, Pages | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
Summer 1
Media & communication
| Wk | Focus and “I can…” objective | Tools / apps | Strand |
|---|---|---|---|
| 21 |
Picture perfect: edited images I can recognise that images can be altered and think about its effects. Materials: ProjectEVOLVE Self-image & identity (Y5) resources; before/after edited-image examples |
Web browser | Online safety — Self-image & identity |
| 22 |
Email threads I can manage an email thread and use reply-all sensibly. Materials: A multi-reply email thread pre-set in pupils’ inboxes |
OutlookGmailMail | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
| 23 |
Organising with calendar I can use a calendar to organise tasks (where available). Materials: Outlook calendar access; sample events to addGoogle Calendar access; sample events to addCalendar access; sample events to add |
Outlook calendarGoogle CalendarCalendar | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
| 24 |
Presenting data I can present data clearly using slides and a chart. Materials: A chart from an earlier week; a slide template |
PowerPoint, ExcelGoogle Slides, Google SheetsKeynote, Numbers | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
| 25 |
Consolidation I can communicate and present information well. Materials: Communication and presenting checklist |
Outlook, PowerPointGmail, Google SlidesMail, Keynote | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
Summer 2
Group project
| Wk | Focus and “I can…” objective | Tools / apps | Strand |
|---|---|---|---|
| 26 |
Using and crediting work I can use others’ work fairly and credit it. Materials: ProjectEVOLVE Copyright & ownership (Y5) resources; attribution/crediting examples |
Web browser | Online safety — Copyright & ownership |
| 27 |
Project (1): set up I can set up a shared folder for my group. Materials: A group shared folder created in advance, or a template to copy |
OneDriveGoogle DriveiCloud Drive | Core ICT & file management |
| 28 |
Project (2): create I can co-author and add data to our project. Materials: A shared document and Excel sheet; copyright-free imagesA shared document and Google Sheets file; copyright-free imagesA shared document and Numbers spreadsheet; copyright-free images |
Word for the web, ExcelGoogle Docs (co-editing), Google SheetsPages (co-editing), Numbers | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
| 29 |
Project (3): present I can present our group project. Materials: Presentation template; success criteria |
PowerPointGoogle SlidesKeynote | Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration |
| 30 |
Showcase and reflection I can reflect on our collaboration and results. Materials: Reflection sheet; a way to display group work |
Consolidation — no new app | Review & showcase |