Digital Literacy & Applied ICT

Logging in & getting started

I can log in with my own username and password and open and close a program.

Also covers: Checking the sound works, setting a sensible volume, and plugging in and testing headphones.

Mouse, keyboard & touch

I can type, edit and correct text and use touch gestures on an iPad.I can type, edit and correct text and use touch gestures on a tablet.I can type, edit and correct text and use touch gestures on an iPad.

Creating and saving work

I can create a document, save it with a sensible name and find it again.

Introducing OneDriveIntroducing Google DriveIntroducing iCloud Drive

I can save my work to OneDrive and open it again on a different device.I can save my work to Google Drive and open it again on a different device.I can save my work to iCloud Drive and open it again on a different device.

Formatting text

I can change font, size, colour and alignment to make my writing clear.

Adding pictures

I can insert a picture and resize and move it on the page.

Editing and improving

I can use spellcheck, undo/redo and selecting to improve my work.

Also covers: Having the work read aloud before deciding what to improve, and changing the text size or spacing to make it easier to check.

Mini-project: fact poster

I can combine text and images to make a clear poster.

Also covers: Print preview before printing: does the poster fit on one page, and does it need printing at all?

What is email?

I can open my email and send a simple message to someone in school.

Reading and replying

I can read an email and reply, using a clear subject line.

Email etiquette

I can start and end an email politely and write for my reader.

Review and catch-up

I can show the email and saving skills I have learned.

Introducing PowerPointIntroducing Google SlidesIntroducing Keynote

I can add slides and put a title and text on them.

Images and layout

I can add images and arrange a slide so it is easy to read.

Presenting to others

I can add simple transitions and present my slides to the class.

Mini-project: 3-slide talk

I can plan and make a short presentation.

Folders and file names

I can create a folder and give files sensible names.

Finding and moving files

I can move files into the right folder and find work quickly.

Lists and tables in WordLists and tables in Google DocsLists and tables in Pages

I can use a simple list or table to organise information.

Consolidation

I can organise and tidy my OneDrive.I can organise and tidy my Google Drive.I can organise and tidy my iCloud Drive.

End-of-year project (1): plan

I can plan a small information pack.

End-of-year project (2): make

I can create my pack using text and images.

End-of-year project (3): organise

I can save, name and organise my finished work.

Showcase and reflection

I can share my work and say what I can now do.

Confident across devices

I can switch between an iPad and a laptop and find my work on OneDrive.I can switch between a tablet and a laptop and find my work on Google Drive.I can switch between an iPad and a laptop and find my work on iCloud Drive.

Folder structures

I can build a tidy folder structure for my subjects.

Managing files

I can move, copy, rename and safely delete files.

Also covers: Getting work back: the recycle bin, restoring a deleted file, and finding an earlier version of something overwritten.

Recap task

I can organise a set of files into the right folders.

Working with tables

I can insert and fill in a table to present information.

Headings and lists

I can use headings and lists to structure a document.

Layout and images

I can lay out a page and wrap text around an image.

Also covers: Copying and pasting between documents and apps, the keyboard shortcuts for it, and searching for an image you are allowed to use.

Mini-project: a report

I can produce a clear, structured report.

Outlook basicsGmail basicsMail basics

I can organise my inbox and write a well-structured email.

Tone and audience

I can change my tone depending on who I am emailing.

Attachments

I can attach a file and open an attachment safely.

Review

I can send a clear email with an attachment.

Sharing a document

I can open a document that has been shared with me.

Editing together

I can edit a shared document and add a comment.

Collaboration etiquette

I can work in a shared file without deleting others’ work.

Paired task

I can complete a small task with a partner in one document.

PowerPoint with notesGoogle Slides with notesKeynote with notes

I can use speaker notes to help me present.

Collecting simple data

I can enter data into a table or a form.

Reading a chart

I can read and explain a simple chart.

Consolidation

I can present some information I have collected.

Project (1): plan

I can plan a paired project.

Project (2): build

I can co-author a document with my partner.

Project (3): present

I can present our shared work.

Showcase and reflection

I can reflect on how well we worked together.

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.

Sharing files

I can share a file using a link or by inviting someone.

Permissions

I can choose whether someone can view or edit my work.

Recap

I can share work with the right people and permissions.

Real-time co-authoring

I can work in the same document as others at the same time.

Comments and @mentions

I can use comments and @mentions to communicate in a file.

Suggesting changes

I can suggest edits without changing the original straight away.

Collaborative document

I can co-write a document with a group.

Spreadsheet basics

I can enter data into cells, rows and columns.

Simple formulas

I can use SUM and AVERAGE to calculate.

Making a chart

I can turn data into a suitable chart.

Review

I can build a small spreadsheet with a chart.

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.

Collecting responses

I can share a form and collect responses.

Analysing responses

I can turn responses into a chart and explain them.

Mini data project

I can plan, collect and present data.

Email threads

I can manage an email thread and use reply-all sensibly.

Organising with calendar

I can use a calendar to organise tasks (where available).

Presenting data

I can present data clearly using slides and a chart.

Consolidation

I can communicate and present information well.

Project (1): set up

I can set up a shared folder for my group.

Project (2): create

I can co-author and add data to our project.

Project (3): present

I can present our group project.

Showcase and reflection

I can reflect on our collaboration and results.

Working in TeamsWorking in Google ClassroomWorking in Schoolwork

I can find channels, posts and files in our class Team.

Managing shared folders

I can organise and manage a shared folder for a group.

Version history

I can use version history to compare or recover work.

Recap

I can navigate our shared workspace confidently.

Longer documents

I can use headings and a contents page in a long document.

Combining apps

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.

Designing for an audience

I can design my work to suit its purpose and audience.

Project chunk

I can produce a polished, multi-part document.

Email vs chat

I can choose the right tool for a message.

Etiquette in group chats

I can post appropriately in a class chat or Team.

Managing shared resources

I can share links and attachments responsibly.

Review

I can communicate clearly and appropriately online.

Advanced searching

I can search efficiently and judge reliability.

Referencing

I can reference sources and avoid plagiarism.

Fact-checking

I can check a claim against more than one source.

Mini research project

I can research a topic and present trustworthy findings.

Project (1): plan & set up

I can plan a group project and set up our shared space.

Project (2): build

I can co-author and manage our shared files.

Project (3): data & media

I can add data and media to our project.

Project (4): refine

I can use feedback and version history to improve our work.

Project (5): finish

I can complete our group project.

Project (6): present

I can present our project confidently.

Digital skills audit

I can check my skills against a “ready for secondary” checklist.

Showcase and reflection

I can celebrate and reflect on what I can now do.