In Organise Group Projects in Google Sheets, students collaborate to learn how to use digital tools to organize a group project in a spreadsheet. Duration: 45-90 minutes Organise Group Projects in Google Sheets is suitable for: Key Stage 3 Key Stage 4 Post-16 Students use Search and Sheets. By the end of this lesson, students should be able to: Manage a long-term group project in Google Sheets by setting deadlines, tracking progress, assigning responsibilities, and keeping notes. The resource is video-based and features FREE, ready-to-use lesson plans, rubrics to enable teachers to evaluate a student’s work across a variety of skills and levels of proficiency (i.e. beginner, developing, accomplished, and exemplary) and a dashboard to show how each student is progressing. How to get started? Sign in as an Instructor with a Google account here. If you don’t have a Google account, click “more options” and then “create an account”. If you are a teacher in England, you can register here for our free teacher workshops. . If you would like to bring the applied digital skills training event to your school, college or centre near you and can guarantee 20 educators, we can host the event at your school or college.

In Create Quizzes in Google Forms, students use Google Forms to create quizzes to test themselves and others on a topic. Duration: 45-90 minutes Create Quizzes in Google Forms is suitable for: Key Stage 3 Key Stage 4 Post-16 Students use Forms and Search. By the end of this lesson, students should be able to: Create a quiz in Google Forms that contains multiple choice, checkbox, and true-false questions. The resource is video-based and features FREE, ready-to-use lesson plans, rubrics to enable teachers to evaluate a student’s work across a variety of skills and levels of proficiency (i.e. beginner, developing, accomplished, and exemplary) and a dashboard to show how each student is progressing. How to get started? Sign in as an Instructor with a Google account here. If you don’t have a Google account, click “more options” and then “create an account”. If you are a teacher in England, you can register here for our free teacher workshops. . If you would like to bring the applied digital skills training event to your school, college or centre near you and can guarantee 20 educators, we can host the event at your school or college.

In Organise Files in Drive, students use Google Drive to store, access, and share files in one central place. Duration: 45-90 minutes Organise Files in Drive is suitable for: Key Stage 3 Key Stage 4 Post-16 Students use Docs and Drive. By the end of this lesson, students should be able to: Create and color-code folders in Google Drive to save class materials and assignments. Create a file naming convention to easily find assignments and keep track of due dates. Move related files into the appropriate class folder or sub-folder. Share files and folders with a classmate and add to their own Drive. The resource is video-based and features FREE, ready-to-use lesson plans, rubrics to enable teachers to evaluate a student’s work across a variety of skills and levels of proficiency (i.e. beginner, developing, accomplished, and exemplary) and a dashboard to show how each student is progressing. How to get started? Sign in as an Instructor with a Google account here. If you don’t have a Google account, click “more options” and then “create an account”. If you are a teacher in England, you can register here for our free teacher workshops. . If you would like to bring the applied digital skills training event to your school, college or centre near you and can guarantee 20 educators, we can host the event at your school or college.

In Guide to an Area, students research and organise information about a location to create an interactive guide. Duration: 4-6 hours Guide to an Area is suitable for: Key Stage 3 Key Stage 4 Post-16 Students use Maps, Search and Sheets. By the end of these lessons, students should be able to: Identify and explain common terms and concepts related to spreadsheets Organise and manipulate data in a spreadsheet Break down data, processes, or problems into smaller, manageable parts Write a program to automate a task The resource is video-based and features FREE, ready-to-use lesson plans, rubrics to enable teachers to evaluate a student’s work across a variety of skills and levels of proficiency (i.e. beginner, developing, accomplished, and exemplary) and a dashboard to show how each student is progressing. How to get started? Sign in as an Instructor with a Google account here. If you don’t have a Google account, click “more options” and then “create an account”. If you are a teacher in England, you can register here for our free teacher workshops. . If you would like to bring the applied digital skills training event to your school, college or centre near you and can guarantee 20 educators, we can host the event at your school or college.

In Technology, Ethics, and Security, students will research technology risks and dangers, explore solutions, and create a report to communicate their findings. Duration: 2-5 hours Technology, Ethics, and Security is suitable for: Key Stage 3 Key Stage 4 Post-16 Students use Docs, Search, Sheets, Slides, Sites. By the end of these lessons, students will be able to: Explore all sides of the topic they choose related to technology, ethics, and security Explain technology’s risks and dangers, and consider solutions to keep users safe Plan and employ effective research strategies to locate information and other resources for their intellectual or creative pursuits Publish or present content that customizes the message and medium for their intended audiences The resource is video-based and features FREE, ready-to-use lesson plans, rubrics to enable teachers to evaluate a student’s work across a variety of skills and levels of proficiency (i.e. beginner, developing, accomplished, and exemplary) and a dashboard to show how each student is progressing. How to get started? Sign in as an Instructor with a Google account here. If you don’t have a Google account, click “more options” and then “create an account”. If you are a teacher in England, you can register here for our free teacher workshops. If you would like to bring the applied digital skills training event to your school, college or centre near you and can guarantee 20 educators, we can host the event at your school or college.

In Research and Develop a Topic learn to identify credible online sources and make an interactive research document with basic coding. Duration: 3-4 hours. Students use Apps Script, Docs and Search. Research and Develop a topic is suitable for: Key Stage 3 Key Stage 4 Post-16 The resource is video-based and features Free, ready-to-use lesson plans, rubrics to enable teachers to evaluate a student’s work across a variety of skills and levels of proficiency (i.e. beginner, developing, accomplished, and exemplary) and a dashboard to show how each student is progressing. By the end of these lessons, students should be able to: Define a problem, research question, or goal Collaborate with others to conduct research and develop digital artifacts Discuss and perform basic and advanced internet search strategies Evaluate the bias of digital information sources and select sources of information for credibility, accuracy, and relevance How to get started? Sign in as an Instructor with a Google account here. If you don’t have a Google account, click “more options” and then “create an account”. If you are a teacher in England, you can register here for our free teacher workshops. If you would like to bring the applied digital skills training event to your school, college or centre near you and can guarantee 20 educators, we can host the event at your school or college.

In Pick the Next Box Office Hit, students act as a movie producer to analyse movie data trends to pick the next box office hit. Duration: 6-9 hours Pick the Next Box Office Hit is suitable for: Key Stage 3 Key Stage 4 Post-16 Students use Apps Scripts, Docs, Drawing and Sheets. By the end of these lessons, students should be able to: Make a decision and justify it based on intuition and data Visualise data using graphs Analyse data using formulas The resource is video-based and features FREE, ready-to-use lesson plans, rubrics to enable teachers to evaluate a student’s work across a variety of skills and levels of proficiency (i.e. beginner, developing, accomplished, and exemplary) and a dashboard to show how each student is progressing. How to get started? Sign in as an Instructor with a Google account here. If you don’t have a Google account, click “more options” and then “create an account”. If you are a teacher in England, you can register here for our free teacher workshops. If you would like to bring the applied digital skills training event to your school, college or centre near you and can guarantee 20 educators, we can host the event at your school or college.

In Plan and Budget learn to make good financial decisions by analysing long-term spending, researching and comparing costs, and planning for major purchases. Duration: 7-9 hours Plan and Budget is suitable for: Key Stage 3 Key Stage 4 Post-16 Students use Maps, Search, Sheets. By the end of these lessons, students should be able to: Identify and analyse real world issues and problems, develop ideas and theories, and pursue answers and solutions Utilise a database, such as a spreadsheet, to collect, organise, graph, and analyse data to facilitate problem-solving and decision-making Curate information from digital sources using a variety of tools and methods to create collections of artifacts that demonstrate meaningful connections or conclusions Apply basic formulas (add, subtract) and advanced formulas (example: using =SUMIF to calculate costs) to spreadsheets The resource is video-based and features FREE, ready-to-use lesson plans, rubrics to enable teachers to evaluate a student’s work across a variety of skills and levels of proficiency (i.e. beginner, developing, accomplished, and exemplary) and a dashboard to show how each student is progressing. How to get started? Sign in as an Instructor with a Google account here. If you don’t have a Google account, click “more options” and then “create an account”. If you are a teacher in England, you can register here for our free teacher workshops. If you would like to bring the applied digital skills training event to your school, college or centre near you and can guarantee 20 educators, we can host the event at your school or college.

In Plan an Event, students use the G Suite to choose and organise an event (create to-do lists, assign tasks, and promote an event). Duration: 6-9 hours. Plan an Event is suitable for: Key Stage 3 Key Stage 4 Post-16 Students use Calendar, Docs, Drawings, Gmail, Sheets and Sites. By the end of these lessons, students should be able to: Collaborate digitally in a shared document Apply basic and advanced formatting options to a document, spreadsheet, and drawing application Organise and sort data in a spreadsheet Create a digitally shared calendar Compose and reply to emails, format email messages, and share attachments Create and publish a website The resource is video-based and features FREE, ready-to-use lesson plans, rubrics to enable teachers to evaluate a student’s work across a variety of skills and levels of proficiency (i.e. beginner, developing, accomplished, and exemplary) and a dashboard to show how each student is progressing. How to get started? Sign in as an Instructor with a Google account here. If you don’t have a Google account, click “more options” and then “create an account”. If you are a teacher in England, you can register here for our free teacher workshops. If you would like to bring the applied digital skills training event to your school, college or centre near you and can guarantee 20 educators, we can host the event at your school or college.

If-Then Adventure Stories allows students to collaborate together to create an interactive story using Google Slides. Duration: 2-3 hours If-Then Adventure Stories is suitable for: Key Stage 3 Key Stage 4 Post-16 Students use Docs and Slides. By the end of these lessons, students should be able to: Collaborate in a document Create a slide presentation with a group and digitally share it with others Make decisions in groups effectively Create an engaging, visually exciting interactive story The resource is video-based and features FREE, ready-to-use lesson plans, rubrics to enable teachers to evaluate a student’s work across a variety of skills and levels of proficiency (i.e. beginner, developing, accomplished, and exemplary) and a dashboard to show how each student is progressing. How to get started? Sign in as an Instructor with a Google account here. If you don’t have a Google account, click “more options” and then “create an account”. If you are a teacher in England, you can register here for our free teacher workshops. If you would like to bring the applied digital skills training event to your school, college or centre near you and can guarantee 20 educators, we can host the event at your school or college.