Mastering the Google Apps Made Easy

Do you need your students to master Google Slides, Google Docs, Google Sheets, and Google Classroom so that they can complete assignments efficiently? Here are lessons and projects that have everything your upper elementary students need to become pros at Google Apps.

Why Should My Students Master Google Apps?

Whether you are a Google school or simply have certain teachers who use Google for Education, countless assignments require Google apps to complete. Fluency in these basic computer skills are also likely to be useful in almost any workplace your student may eventually find themselves in. If you’re a classroom teacher just starting your journey with having 1:1 devices (or something similar) or if this is the first time your group of students will be using Google Apps, these are a great way to get started for your students.

What Standards and Tech Skills are Supported?

Standards Addressed:

  • Strand: Empowered Learner
    • Standard: 1.c. Students use technology to demonstrate their learning in a variety of ways.


Master Google Apps Bundle

Products Included:

Introductory Lessons To Try Out

Not sure you need all that? The following items are designed to give your students a crash course.

Google Classroom Procedures Lesson

Are your students really struggling with how to get through a lesson in Google Classroom? This interactive lesson was designed for upper elementary students as a concrete way to learn the steps and procedures for completing their Google Classroom work.

Skills included:

  • Getting to Google Classroom
  • Logging in
  • Access lessons
  • Mark complete
  • Leave and find comments

Google Sheets Lessons for Beginners

5 lessons for any beginner Google Sheets user. By the end of the 5 lessons students should be able to open a blank Sheets template and create charts, graphs, and use formulas as well as manipulate the column and row sizes.

Skills included:

  • Fill in a chart
  • Make a graph
  • Make your own chart and graph
  • Color and highlight cells
  • Formulas

How to Use Google Slides

A crash course in how to use Google Slides. 9 Google Slides features and functions presented in an “All About Me EBook” perfect for upper elementary and middle school students. 

Skills included:

  • Insert text
  • Photos
  • Shapes & Lines
  • Comments
  • Word Art
  • Arrange order
  • Research tools
  • Dictionary
  • Tables
  • All About Me Prompts to practice

Word Processing Modules 1-5

Most appropriate for students in grades 3-5 or students who have had an introduction to Word Processing. For each skill, there are 2 templates. 1 will open in MS Word, and 1 will open in Google Docs. These projects were made out of a desire to guide students to eventually work independently in software programs. They are design to build technology literacy through repetition and engaging project prompts.

Skills included:

  • Working with Fonts
  • Working with Text
  • Working with Lines (indents)
  • Working with Spacing
  • Working with Lists

Advanced Lesson Resources

Do your students have the basics down? Here are advanced lessons to take your students to the next level.

Google Slides Complete Unit

In this 11 lesson complete unit, your students will learn all of the major components of using Google Slides for education. The best part is that these lessons are click and go! The instructional videos are done for you so your students will be able to work independently.

Skills included:

  • Font
  • Photos
  • WordArt
  • Tables
  • Numbering slides
  • Design
  • Editing
  • Transitions and Animations
  • Video
  • Citing Sources
  • Printing

Google Sheets Skills Project – Candy Store

An engaging project for students in which they act as Candy Store owners. They have to work with the candy bars sold data to find out which candy bars make the store the most money.

Skills included:

  • Functions and Formulas
  • Conditional Formatting
  • Sorting
  • Charts and Graphs

Word Processing Modules 6-10

Skills included:

  • Working with Links
  • Working with Layout and Margins
  • Working with Columns
  • Working with Headers and Footers
  • Working with Layers (and text wrapping)

Word Processing Modules 11-15

Skills included:

  • Working with Shapes
  • Working with Tables
  • Working with Editing (spell check)
  • Working with Styles
  • Working with Find and Replace

Tips for Teachers

  • Each file comes as a PDF with a link to a Google apps file with interactive activities.
  • Make sure to click on the link(s) while logged in to the Google Account you wish to make the copy into.

Google Apps Tips

  • Anxious about Google Slides or Google Classroom? Give it a chance! It provides digital ways to incorporate common core skills and make your students more adept at utilizing technology in their daily learning. Google Classroom is paperless, integrates technology into the classroom, improves student computer skills, increases engagement, and lets you access materials anywhere.
  • This free Google Slides Vocabulary Poster that makes a great mini lesson if you are introducing your students to Google Slides for the first time.
  • Don’t have Google accounts at your school? No problem! Students can still access a presentation if you set it to “Anyone with the link can edit”. They can add text, just not images. You would have to create a separate presentation for each student and supply them with the url. First, make sure you are signed into your Google account. Double click the link and you will be prompted to “Make a Copy”. Rename the file whatever you would like. It will be sent directly to your drive! Disperse to your students via Google Classroom, Google Drive Shared folder, your Learning Platform, etc.

Leave a Reply