google sheets assignment middle school

• Health Science
• Business Education
• Computer Applications
• Career Readiness
• Teaching Strategies

«  View All Posts

Computer Applications | Google Apps | Middle School | Google Sheets

3 Places to Find Google Sheets Activities for Middle School Students

• Share This Article

September 8th, 2021 | 6 min. read

Print/Save as PDF

As a computer applications teacher, you need activities and lessons that are engaging, easy to teach, and that meet your standards. Unfortunately, when it comes to Google Sheets, finding relevant and appropriate activities for middle school students isn’t easy. Y ou could create your own, but that takes a lot of extra time (especially if you aren’t a spreadsheet whiz), and you never know how the activity will go in your classroom.

Because of our expertise in developing dedicated computer curriculum, frustrated teachers often approach iCEV asking about Google Sheets activities to help them in the classroom.

And w hile our Business&ITCenter21 does a good job of helping teach Google Docs, Sheets, Slides, and Forms, it may not be the best fit for everyone. Some middle school teachers are simply looking for supplemental Google Sheets lessons and activities for their classes, after all. 

In this article, you'll discover  the three best places to find Google Sheets activities for middle school computer classes:

• Practice Activity from Alice Keeler
• Lesson & Activities from Gavin Middleton
• Google Sheets Bundle from Cluney’s Classroom

By the end of this article, you'll have an overview of each resource that will help you decide which one(s) will work best in your classroom!

1. Google Sheets Practice Activity from Alice Keeler

Alice Keeler is a teacher and author who dedicates her spare time to helping other educators successfully use technology in the classroom.

In this activity, students practice a variety of skills, including:

• Adjusting rows and columns
• Merging cells
• Entering data
• Using basic formulas
• Using cell references

The activity is broken into two self-guided sections: steps and practice .

The steps portion teaches students the basics of Excel and lists instructions for students to follow. The practice section, on the other hand, is task-based and requires more in-depth knowledge of Google Sheets.

Because the entire activity is self-guided, you can use it however best suits your syllabus.

For example, some teachers instruct students to work through it during class as the teacher observes and answers questions. Others assign the activity as overnight homework and review it the next day.

A great aspect of this activity is that it’s easy to modify the original template. You can quickly review and revise it to ensure students are practicing skills you’ve already covered!

Overall, this activity is a perfect hands-on way for you to reinforce your students’ Google Sheets skills.

But if you’re looking for more of a combination between classroom lessons and reinforcement activities, the next option could be just what you need!

2. Google Sheets Lesson & Activities from Gavin Middleton

Gavin Middleton is a well-known publisher on Teachers Pay Teachers (TpT) -- an online marketplace where educators can share, sell, and buy resources like lesson plans and activities.

This download costs $5 and includes a lesson plan, lesson materials, and student activities, all with screenshots and clear instructions.

The lesson begins by introducing Google Drive and then segues into Google Sheets. The included PowerPoint has great screenshots with labels and tips to ensure your students get the basics down pat.

It’s a great idea to use the PowerPoint presentation with your class before letting students jump into working individually. Once you’ve gone over the basics, have your students work through the activity on their own!

What’s great about Middleton is that he takes the time to update his work with the latest lessons and activities. The original Google Sheets lesson is a few years old, but Middleton revised it in 2018 to align with the current version of Sheets and add more content!

If you’re looking for a great introduction to Google Sheets for your students, this is it.

If you want something more in-depth, check out the next resource!

3. Google Sheets Lesson Bundle from Cluney’s Classroom

“Cluney’s Classroom” is another publisher on TpT heavily focused on helping other educators include projects and collaborative learning in their classrooms.

The bundle costs $55, and with it you get lessons on many topics, including:

• Formatting data, cells, and columns
• Using basic functions
• Sorting data
• Using conditional formatting
• Applying filters

Each of the lessons includes a “teacher’s manual” with setup information, teacher tips, instructions, and sample answers.

In addition, the last “lesson” is a larger project that involves students using multiple applications collaboratively -- a great ending to your whole Google Apps unit!

Overall this bundle is packed with a ton of resources to help you teach Google Sheets with activities every step of the way.

The only thing to keep in mind is the cost for what you get! After all, i f you’re like most computer applications teachers looking for Google Sheets activities, that price tag might not be justifiable for one topic.

Which Middle School Google Sheets Activities Are Right for You?

Because of how specific a subject it is, finding activities to help you teach Google Sheets to middle schoolers can be a pain. And at the end of the day, there is no single "best" resource for doing so. It all depends on the needs of you, your course, and your students!

In this article, you've discovered some of the best places to go to find activities to help you teach Google Sheets. Each of these resources can be a great supplement to your existing curriculum, to help hammer home important concepts to your students. 

However, Google Sheets isn't the only Google Application out there. If you're teaching a unit on Google in your computer class and need some advice on doing it right, check out this guide to overcoming your biggest challenges . 

This handy guide will help you navigate some of the most common issues teachers face in their classrooms, including keeping students engaged, satisfying course standards, and dealing with technology in a changing world:

Best Google Sheets activities for students to enhance digital learning

Educators are often intimidated by Google Sheets and stick to assigning Google Docs or Google Slides assignments. But Google Sheets activities for students are easier to put together than you think! They’re also engaging, create opportunities for critical thinking and allow learners to be creative. Check out these learning activities and tips, and you might just turn out to be a Google Sheets fan.

What can learners do with Google Sheets?

Meaningful reading log.

If you’re an English language arts educator, you’ve probably assigned a reading log at some point. It’s wonderful to encourage the joy of reading, but oftentimes kids will fill out reading logs with basic information. When they have to keep track of the number of pages they read and the number of minutes, reading may start to feel like a chore.

Instead, a reading log should help learners more deeply engage with the text. To do this, create a three-column chart in Google Sheets for learners. From there, they’ll keep track of surprising moments, how they connected to characters or real people, questions they have, choices they disagree with or predictions they’ve formulated. Learners will make note of the event, question or prediction in one column. Then in the third column, they’ll write a quick thought. 

You can set up the reading log by adding in a drop-down menu in the first column. You can also ask learners for ideas on how they want to engage with the text so it becomes a personalized process.

Physical activity log

If you teach health or physical education, healthy routines are most likely part of your curriculum. Ask learners to keep track of their physical activities outside of school by inputting them into a Google Sheet. 

Rather than just tracking the type of activity and number of minutes, ask them to record how they felt before and after running, doing soccer drills, shooting hoops, swimming, playing hockey, hiking or taking a walk. Then, over time, ask them if they see a pattern in their emotions tied to physical activities.   

Vocabulary journal

An ongoing Google Sheets assignment for learners is a vocabulary journal. You can use this across subjects since reading and vocabulary are part of any course. In each row, learners will add a vocabulary word they come across when reading their textbook, online articles or literature. In the next columns, they’ll add a definition, any Greek or Latin roots and a picture that represents the word. 

Something to keep in mind is that when learners look up definitions in dictionaries, they often don’t understand the definitions. In this case, they still don’t understand the meaning of the word and you’ve just created busy work for them by copying down a definition. It’s best to point them to a kid-friendly dictionary and have them make a note in their journal if they need more clarification.

Fill-in story

Technology Integration Specialist Joli Boucher created a super fun Google Sheets fill-in story activity. In Mad Libs style, learners type in their own adjectives, proper nouns, numbers and more to build a story. Joli’s example is a Halloween activity, but she details the steps for creating your own fill-in story. After learners complete the activity, ask them to share with a partner or the class. Design one for any holiday or event to engage learners and hear some giggles around the classroom. 

Doctors as detectives

The “Doctors as Detectives” activity is actually a full lesson plan The New York Times Learning Network featured. Each learner is assigned a disease to research. Then they create a spreadsheet with symptoms and historical facts. Afterward, their partner uses their Google Sheet to do some detective work and figure out the disease, using complex thinking to determine the answer. 

Math mystery puzzles

An elementary educator in Texas created interactive math activities for learners. In these Google Sheets practice exercises, learners select a question from a drop-down menu and then type their answer into a box. The activity will let them know right away whether their answer is correct or not. 

A “mystery puzzle” with a picture also reveals itself piece by piece as learners correctly answer questions. This is a great way for learners to practice foundational math skills or to review at the beginning of the year. You can also share puzzles based on learners’ abilities. On the educator’s website , you can download the free Google Sheets activities for students. 

Weather observations

Matt Miller from Ditch That Textbook came up with an idea for science classes to collaborate with classes from other parts of the city, state or country. In Google Sheets, the classes collect data about the weather where they live. This gives them a global learning experience and a chance to compare and contrast data.  

Pixelated art

Educator Brittany Washburn created a Google Sheets activity for learners to collaborate on pixelated art. Learners change the sizes of columns and rows and add colors to cells to create images. Group members can create images of historical architecture, a diagram of the parts of a plant, a fictional character, a map, the Earth’s layers and more. 

Games can be a way for learners to practice critical thinking skills and problem-solving skills. You can set up a Battleship game for learners (or they can set it up themselves!) in Google Sheets. Just like the classic game, learners will use strategy to determine where their opponent’s ships are on the Google Sheet. This could be used as enrichment or as an activity for learners who finish an assessment early. 

Interactive templates

Flippity offers templates and step-by-step instructions for transforming Google Sheets into flashcards and instructional games. Some examples include:

• Quiz show setup
• Spelling word manager
• Self-assessment
• Word scrambler
• Click and drag objects

How do you share Google Sheets activities with learners?

Once you have a Google Sheets activity ready for learners, what’s the best way to share it with them? You can add each student to the Share settings, but that takes a lot of time (that you don’t have as an educator). Hāpara makes it very easy to share Google Sheets activities with your learners. In Hāpara Teacher Dashboard , there is a “Share files” feature. It allows you to quickly share any Google file or create a new one. You can also share it with a single learner, a group or the entire class for differentiated instruction. 

Hāpara Workspace is a tool that allows you to place all of your learning content for a lesson, unit or project into one spot. Students can explore the Workspace at their own pace, and you can add Google Sheets activities for groups or individual learners for differentiated instruction.  

How do you learn how to use Google Sheets?

If you need some help understanding how to use Google Sheets features, there are free training options available online. Here are a couple to get you started:

• Google Sheets for educators video — This video is a great way to learn how to sort and filter data, add formulas, create charts and graphs and add conditional formatting.
• Google for Education training — This online hub for educators has a series of videos and interactive lessons to help you dive into Google Sheets

How do you teach learners how to use Google Sheets?

Some learners have technical skills, but they don’t all understand how to use Google Workspace for Education apps. While the activities above can help them gain some Google Sheets skills, you may want to set aside some time for them to take a deeper dive. 

Google’s Applied Digital Skills training offers a lesson with teaching materials, so you or your students can learn the basics of Google Sheets.

It also includes games to make learning these skills more fun. For example, share the Make a Word Game with students to play with a partner. As they play, they’ll learn how to use Google Sheets formulas and functions.

Google education expert Alice Keeler also has a guide for students all about Google Sheets. She covers the four basic skills they should gain so they can use spreadsheets in any class.

Key takeaways

✔️  Get creative with Google Sheets to boost class engagement.

✔️  Use Google Sheets for collaborative activities.

✔️  Share Google Sheets activities to develop critical thinking skills.

✔️  Use tools that make it easy to share Google files.

✔️  Set aside some time to learn about the features of Google Sheets if you need support.

Learn what to focus on when building a culture of digital citizenship, including conversation starters for learners and educators!

About the author, nicole bixler, you might also enjoy.

FREE E-BOOK FOR EDUCATORS

Must-have digital citizenship checklist for K-12 schools

Download our checklist to guide how you incorporate digital citizenship into your school district’s curriculum at every opportunity.

Pin It on Pinterest

5 Free Assignment Tracking Templates for Google Sheets

Posted on Last updated: November 18, 2023

It’s that time of year again—assignments are piling up and it feels impossible to stay on top of everything. As a student, keeping track of all your assignments, due dates, and grades can be overwhelmingly stressful. That’s why using a Google Sheet as an assignment tracker can be a total game-changer.

With customizable assignment tracking templates for Google Sheets, you can easily create a centralized place to organize all your academic responsibilities. The best part? These templates are completely free. 

In this article, we’ll explore the benefits of using assignment tracking templates for Google Sheets and provide links to some excellent templates that any student can use to get organized and take control of their workload.

The Benefits of Using Assignment Tracking Templates for Google Sheets

Assignment tracking templates for Google Sheets offer several advantages that can help students stay on top of their work. Here are some of the key benefits:

• Centralized tracking: Rather than having assignments scattered across syllabi, emails, and other documents, an assignment tracking spreadsheet consolidates everything in one place. By leveraging assignment tracking templates for Google Sheets, you can kiss goodbye to hunting for due dates or double-checking requirements.
• Customizable organization: Students can add or remove columns in the template to fit their needs. Thanks to this, they can effectively track due dates, point values, grades, and other helpful details. They can also color code by class or status for visual organization.
• Easy access: Google Sheets are accessible from any device with an internet connection. With this, you can easily view, update, or add assignments whether you are on your laptop, phone, or tablet.
• Shareable with others: For group assignments or projects, assignment tracking templates for Google Sheets make collaboration seamless as you can share the sheet with a study group or entire class to coordinate.
• Helps prioritization: Sort assignments by due date or point value to always know what needs your attention first. With prioritization added to assignment tracking templates for Google Sheets, you can stay on top of bigger projects and assignments.
• Reduces stress: There’s no better feeling than looking at your assignment tracker and knowing everything is organized and under control. Saves time spent scrambling, too.

Picking the Perfect Assignment Tracking Templates Google Sheets

When choosing assignment tracking templates for Google Sheets, you’ll want one with specific fields and features that make it easy to stay on top of your work. Here’s what to look for in a homework organizer template:

• Assignment Details: A column for writing down each assignment’s name, instructions, and notes will help you remember exactly what you need to do.
• Due Dates: Columns for listing the due dates of assignments, tests, and projects allow you to see what’s coming up and schedule your time wisely.
• Status Tracker: A place to mark assignments as “Not Started,” “In Progress,” or “Completed” lets you check on what still needs your attention.
• Subject and Type: Categories or labels for sorting assignments by subject or type (essay, presentation, etc) keep your spreadsheet tidy.
• Big Picture View: Some templates include a calendar view or semester schedule to help you plan assignments week-by-week or month-by-month.

The right spreadsheet has the fields you need to fully describe your homework and organize it in a way that works for you. With the perfect template, staying on top of assignments is easy

Top Assignment Tracking Templates

Now that you know the benefits and what to look for in an assignment spreadsheet, we have compiled a list of top assignment tracking templates for Google Sheets that will help you seamlessly track your assignments. 

And guess what? You don’t need robust experience with Google Sheets to maximize these templates, as they are easy to use.

Convenient Homework Planner Template

The Convenient Homework Planner Template is one of the most comprehensive and user-friendly assignment tracking templates for Google Sheets. It’s an excellent fit for students seeking an all-in-one solution to organize their work.

This template includes separate tabs for an overview calendar, assignment list, and weekly schedule. The calendar view lets you see all assignments, tests, and projects for the month at a glance. You can quickly identify busy weeks and plan accordingly.

On the assignment list tab, you can enter details like the assignment name, class, due date, and status.

The weekly schedule tab provides a simple agenda-style layout to record daily assignments, activities, and reminders. This helps you allocate time and schedule focused work sessions for tasks.

Key Features

• Monthly calendar view for big-picture planning
• Assignment list with details like class, due date, and status
• Weekly schedule with time slots to map out days
• Due date alerts to never miss a deadline

With its intuitive layout, useful visual features, and thorough assignment tracking, the Convenient Homework Planner has all you need to master organization and time management as a student. By leveraging this template, you’ll spend less time shuffling papers and focusing more on your academics. 

Ready to explore this assignment tracking template? Click the link below to get started. 

The Homework Hero Template

The Homework Hero is an excellent assignment-tracking template tailored to help students conquer their academic workload. This easy-to-use Google Sheet template has dedicated sections to log critical details for each class.

The Subject Overview area allows you to record the teacher’s name, subject, department, and timeline for each course. This provides helpful context and reminds you of important class details.

The main homework tracking area includes columns for each day of the week. Here, you can enter the specific assignments, readings, and tasks to be completed for every class on a given day. No more guessing what work needs to get done.

At the extreme end of this sheet is a section for additional notes. Use this to jot down reminders about upcoming projects, tests, or other priorities.

Key features

• Subject Overview section for every class
• Columns to record daily homework tasks
• Extra space for notes and reminders
• An intuitive layout to map out the weekly workload
• Easy to customize with additional subjects

The Homework Hero assignment tracking template empowers students to feel in control of their assignments. No more frantic scrambling each day to figure out what’s due. With this template, you can approach schoolwork with confidence.

Click the link below to get started with this template. 

The A+ Student Planner Template

The A+ Student Planner is the perfect template for students seeking an organized system to manage assignments across all their courses. This Google Sheet template has useful sections to input key details for flawless homework tracking.

The Weekly Overview calendar makes it easy to see your full workload at a glance from Sunday to Saturday. You can note assignments, projects, tests, and other school events in the daily boxes.

The Class Information section contains columns to list your class, teacher, room number, and times. This ensures you have all the essential details in one place for each course.

The main Assignment Tracking area provides space to log the name, description, due date, and status of each homework task, project, exam, or paper. No more scrambling to remember what needs to get done.

• Weekly calendar view to map out school events and tasks
• Class information organizer for easy reference
• Robust assignment tracking with all critical details
• An intuitive layout to input assignments across courses
• Great for visual learners

With a structured format and helpful organization tools, The A+ Student Planner provides next-level assignment tracking to ensure academic success. Staying on top of homework has never been easier.

Ready to get started with this assignment tracking template? Access it for free via this link below. 

The Complete Student Organizer Template

The Complete Student Organizer is an excellent minimalist assignment tracking template for focused homework management.

This straightforward Google Sheets assignment template includes columns for the date, total time needed, assignment details, and status. By paring down to just the essentials, it provides a simple system to stay on top of homework.

To use this template, just fill in the date and time required as you get assigned new homework. In the assignment details column, outline what needs to be done. Finally, mark the status as you work through tasks.

• Streamlined columns for date, time, assignment, and status
• Minimalist layout focused only on crucial details
• Easy input to quickly log assignments
• Track time estimates required for assignments
• Update status as you progress through homework

The Complete Student Organizer is the perfect template for students who want a fuss-free way to track their homework. The simplicity of the grid-style layout makes it easy to use without extra complexity. Stay focused and organized with this efficient assignment tracking sheet.

You can get access to this template by visiting the link below. 

Assignment Slayer: The Ultimate Planner Template

Assignment Slayer is the supreme template for tackling schoolwork with military-level organizations. This comprehensive planner is ideal for students taking multiple classes and juggling a heavy workload.

The template includes separate tabs for each academic subject. Within each tab, you can log critical details, including the assignment name, description, status, due date, and associated readings or tasks. With this assignment tracking template, no assignment will fall through the cracks again.

Plus, it has additional columns that allow you to record scores and grades as they are received throughout the semester. This level of detail helps you better understand your standing in each class.

The Ultimate Planner also contains an overview dashboard with calendars for the month, week, and each day. With this, you can visually map out all upcoming assignments, tests, and projects in one view.

• Individual subject tabs for detailed tracking
• Robust assignment logging with name, description, status, due date, and more
• Columns to record scores and grades when received
• Monthly, weekly, and daily calendar dashboard
• Visual layout ideal for visual learners

Assignment Slayer equips students with military-level organization. Its comprehensive features give you command over academic responsibilities, resulting in stress-free homework mastery.

Want to explore how this template can make your job easy? Click the link below to access this free assignment tracking template now. 

Why You Should Take Advantage of These Assignment Tracking Templates For Google Sheets

The assignment tracking templates for Google Sheets we reviewed in today’s guide offer significant advantages that can make managing homework easier. Here are some of the top reasons students love using these digital planners:

Get Organized

The templates allow you to sort all your assignments neatly by subject, type, due date, and status. No more fumbling through papers to find the next thing you need to work on. Plus, the level of organization you get with these templates helps reduce stress.

Manage Time Better

Knowing exactly when assignments are due helps with planning out your week. You can see what needs to get done first and schedule time accordingly. No more last-minute assignment crunches.

Access Anywhere

You can view and update your homework template from any device as long as you have an internet connection. The templates are ready to go as soon as you make a copy – no setup is needed. Easy access keeps you on track.

With useful tools for organization, planning, and accessibility, these assignment tracking templates for Google Sheets make managing homework a total breeze. Boost your productivity and reduce academic stress today by using these templates for your assignment. 

Final Thoughts

Today’s guide explored some of the most accessible and useful assignment tracking templates for Google Sheets. These handy templates make it easy for students to stay organized and on top of their workload.

As a busy student, keeping track of your homework, projects, tests, and other responsibilities across all your courses can be daunting. This is where leveraging a spreadsheet template can make a huge difference in simplifying academic organization.

The assignment tracking templates for Google Sheets reviewed today offer intuitive layouts and customizable features to create a centralized homework hub tailored to your needs. 

Key benefits include:

• Inputting all assignments in one place for easy reference
• Tracking due dates, status, grades, and other key details
• Customizable columns, colors, and more to fit your study style
• Easy access to update assignments from any device
• Helps prioritize your time and tasks needing attention
• Reduces stress by helping you feel in control

By taking advantage of these assignment tracking templates for Google Sheets, you can reduce time spent shuffling papers and focus your energy where it matters – knocking out quality academic work. Make your life easier and get a digital organizational system in place. 

404 Not found

Tech ed from Teacher-authors

How to Use Google Sheets in the K-12 Classroom

Most spreadsheet programs have similar options, so what characteristics make Google Sheets stand out? Read on.

The most common positives mentioned by users are:

• You can collaborate with friends and colleagues.
• You can share the spreadsheet as an embed, either with viewing privileges or editing ones.
• It can be synced across all devices, whether at home or school.
• It works on all digital devices whether it’s a Mac, Windows, Chromebook, or iPad.
• It provides a revision history, allowing you to scroll back to a better version of your work and/or track the contributions of collaborators.
• It includes a chat window where collaborators can discuss their work before changing the spreadsheet.
• Because Sheets is part of Google, it easily imports data from other Google Apps. It also exports nicely to the increasingly broad group of partners who work with Google Apps.

One more that I list as a Pro, but could be a Con: Sheets is easier to learn (that’s the Pro). The reason is there’s less to learn (that’s the Con). It focuses on the most popular functions, not the depth of need. If you’re a lite user of spreadsheets, this will serve you well, but if you are moderate to advanced, you may struggle to find the tool you were used to in Excel — if you can find it at all. For example, pivot tables are strictly an Excel tool.

It’s not the most robust spreadsheet available. Other programs handle vast amounts of data better (such as in excess of 1,000 rows) or provide more advanced formulas. It also isn’t the most user-friendly. If you’re used to the ease of creating and formatting in Excel, Sheets may disappoint you (as Google Docs will if you’re used to Word). Depending upon your needs, you’ll want to decide between paying to use Excel or go with the Google Sheets in the Google Apps package.

Also, Sheets is not as customizable as other spreadsheet programs. There are a lot of shortkeys, but not much flexibility in the toolbar setup.

Finally, if you need fancy charts, Sheets may not be your program. Excel has more types of charts, more options for formatting those charts, and more flexibility to quickly change their layouts and styles.

Education applications

Here are nine ways to incorporate Google Sheets into a K-12 class:

Back-end of Google Forms

Google Forms data is collected in Google Sheets. From there, you can analyze, sort, manipulate, format, or share with stakeholders. This is a great two-step process for collecting and using data.

Tables are great for collecting and presenting data, but not always clear. Sheets can fix that. Once the table is created, students can quickly turn it into a chart for a visual display of the data by selecting Insert>chart. Charts can be edited, formatted, inserted into reports, and shared.

This is well-suited for visual learners.

Students as young as third grade can check their answers to math problems using Sheet’s formulas. They first solve the math problem using steps recommended by the school’s native math curriculum and then check their work using Sheet’s built-in formulas.

Starting with adding, subtracting, multiplying, and dividing is a good way to introduce spreadsheet formulas and unpack what the algorithm means. See that algorithmic string turn into a math solution gets students excited about using what is often considered a geeky math tool.

Collecting group information

There is no better tool for sharing group information than a spreadsheet. This might be useful for class party duties, student reading logs, or classmate contact information. Simply add a column of names on the left side and categories of information to the right. This can be completed by students, populated with data imported from an online source, or created automatically from a Google Form. With very little effort, all required information is collected in one place where it can be edited, formatted, and shared.

Thanks to the fill tool, spreadsheets have become a popular medium for certain artists. Here’s an amazing example of the Mona Lisa, drawn in a spreadsheet , and here’s “Cherry Blossoms of the Historical Castle Site ” by Tatsuo Horiuchi, famed Excel spreadsheet artist. Spreadsheets offer an important option most art programs skip: the grid. Thanks to cells, a drawing can be placed and sized in perfect alignment with other parts of the drawing. Sometimes called Pixel Art , it can easily create the boxy Minecraft artwork or Pokemon by simply filling in cells with varied colors. Students can also add shapes, lines, and text to better communicate ideas.

Three options are available: 1) students fill in the cells with different colors to create a picture that can be tied into class inquiry. This is great for Kindergarten-2nd grade. 2) You provide the cell addresses and instructions for what color to add to each cell.  Students treat this option like a scavenger hunt and fill in the cell, add text, or even link it to another location. 3) Students create a drawing and then list the instructions for each cell so classmates can reproduce the drawing.

Evaluating options

Sheets are a great tool to teach problem-solving or critical thinking. Using the native formulas, students can statistically evaluate most number-intensive options. This is popular for high school students who must build a budget for after graduation.

This is best-suited to students who have a strong introduction to the basics Google Sheets.

Google Sheets will complete all the functions found in a paper gradebook without the worry of unclear erasures, losing the book, or running out of room. Sheets provides enough columns to track student activities for a year (such as grades and project submittal) and the flexibility to hide columns no longer relevant (such as Q1 when you’ve moved on to Q2). The built-in formula tools allow teachers to quickly add scores, find class averages, and even weight a grade as needed.

How many of the formulas teachers use is completely up to them. They can simply add all grades for the grading period. Or, they may choose to use Sheets to calculate which students improved from one test to the next, class averages, and trend lines.

Spreadsheet games

These are games played using spreadsheets with the goal of painlessly teaching students the intricacies of spreadsheets. The most popular is Battleship (click for directions), but also consider Battlesheets  from Eric Curts . Both of these support not only Sheets how-to knowledge, but critical thinking and problem-solving skills.

Spreadsheets make it easy to collect data and evaluate it. Because it’s done in a spreadsheet (and not with tabs in a word processing program), it’s easy to create, quick to fill in, and flexibly edited.

Spreadsheets are an agile tool, scalable to varied student needs and at their core, both granular and rigorous. Those who use them find they’re a gateway technology in terms of flexibility, creativity, and optimizing learning.

Jacqui Murray  has been teaching K-18 technology for 30 years. She is the editor/author of over a hundred tech ed resources including a  K-12 technology curriculum ,  K-8 keyboard curriculum,   K-8 Digital Citizenship curriculum . She is an adjunct professor in tech ed, Master Teacher, webmaster for four blogs, an  Amazon Vine Voice , CSTA presentation reviewer, freelance journalist on tech ed topics, contributor to  NEA Today , and author of the tech thrillers,  To Hunt a Sub  and  Twenty-four Days . You can find her resources at  Structured Learning.

Share this:

• Click to share on Facebook (Opens in new window)
• Click to share on Twitter (Opens in new window)
• Click to share on LinkedIn (Opens in new window)
• Click to share on Pinterest (Opens in new window)
• Click to share on Telegram (Opens in new window)
• Click to email a link to a friend (Opens in new window)
• Click to print (Opens in new window)
• Click to share on Pocket (Opens in new window)
• Click to share on Tumblr (Opens in new window)
• Click to share on Reddit (Opens in new window)
• Click to share on WhatsApp (Opens in new window)

Related Articles

1 thought on “ How to Use Google Sheets in the K-12 Classroom ”

• Pingback: OTR Links 08/26/2017 – doug — off the record

Comments are closed.

We are a group of dedicated technology teachers with tons of experience in teaching K-18 t ech, unraveling its problems, and making it exciting for kids (and adults). We blog here, teach online grad school classes, provide curricula (like K-12 Technology curriculum ,  K-8 keyboard curriculum,   K-8 Digital Citizenship curriculum ). Jacqui Murray (the face of AATT) also authors tech thrillers,  To Hunt a Sub  and  Twenty-four Days . You can find our resources at  Structured Learning.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Email Address

Find Us, Follow Us

Top Posts & Pages

Fun Typing Games

Emails/Newsletters

One-time donation, monthly donation, aatt resources.

This slideshow requires JavaScript.

Find books here…

Student Workbooks

Homeschoolers

Teaching Strategies

• Digital Literacy 0
• Flipped Class 0
• Frayer Model 0
• Habits of Mind 0
• Mindfulness 0
• Orton-Gillingham 0
• 7 Assessment Tools
• Benchmark assessments
• CC Assessments
• Common Core and Assessment
• Report Cards and Tech
• 13 Skills that Blogs Teach
• 3 Issues before schools blog
• Blogging and CC

Book Reviews

• CC Literacy
• CC Meets GA
• Endangered Minds

Chromebooks

• Chromebooks in Class
• Chromebooks–Pros/Cons

Common Core

• Adapt to CC
• Align Tech with CC
• CC and Blogs
• CC and keyboarding
• CC and publishing
• CC Classroom

Digital Citizenship

• 17 DigCit Topics
• 1st Grade DigCit
• 2nd Grade DigCit
• 3rd Grade DigCit
• 4th Grade DigCit
• 5th Grade DigCit
• 6th Grade DigCit
• Kindergarten DigCit
• Charts in Excel
• Excel and Arrays
• Shapes in Excel
• Tessellations in Excel

Featured Articles

• Are you a new tech teacher?
• Computers and Tech Teachers
• Create an inquiry-based class
• Twitter in Education
• You're a Geek now
• Create wallpaper
• 5 Favorite Apps
• IPads vs. laptops

Keyboarding

• 6 Ways to Make KB Fun
• Adults and keyboarding
• Do we need KBing?
• Handwriting vs. KB
• Is KB Cool?
• KB class in 25 minutes
• KB with ASCII art

Online classes

• Work remotely

Presentations

• 15-second presentation
• PowerPoint or Publisher

Problem solving

• 3-click rule
• Computer quits
• I Can Solve That
• Most common problems
• What if Computers Fail
• What if Tech Fails

Miscellaneous

• Structured Learning 0

Special Needs

• Special Needs–Reading
• Tech and Special Needs
• Entries feed
• Comments feed
• WordPress.org

Question? Click…

Any cookies on my website are used to ensure normal website functions (for instance, Youtube videos won’t work without their own identifiers). These cookies cannot be switched off because the website wouldn’t work properly anymore. However, these identifiers do not store any personal data.

Legal stuff

When you leave a comment, WordPress stores your gravatar name, IP Address, comment, and email address. Therefore, leaving a comment is considered a clear affirmative, specific, and unambiguous action as defined by the GDPR giving me consent to store this information, and permission to contact you in the future by email.

Your personal information will not be sold or shared with any third parties under any circumstances. Your information shall be retained until you unsubscribe or ask me to remove your data. If you feel your data has been misused, you have a right to complain to the  Hellenic Data Protection Authority  (HDPA). If you do not consent to the above, please don’t leave a comment.

AI Legal Notices

The content presented in this blog is the result of my creative imagination and not intended for use, reproduction, or incorporation into any artificial intelligence training or machine learning systems without prior written consent from the author.”

Copyright © 2024

U.S/Canada 1.800.393.4636 | International 1.407.796.5200 | [email protected]

Live Courses

Google sheets: project ideas and implementation across curriculum, are you using google sheets in your classroom yet these project ideas will help you get started, no matter what subject you're looking to implement in..

The idea of “using spreadsheets” usually doesn't elicit much excitement or anticipation, yet spreadsheets can be extremely versatile tools in your instructional toolbox. From math to science, and everywhere in between, spreadsheets can provide autonomy and engagement for your students — and when you add the convenience, ease-of-use, and collaborative aspect of Google Sheets, you have a true powerhouse.

This article includes a variety of projects for a wide range of grade levels and subject areas. I learned about these ideas in SimpleK12's online webinar, Google Sheets: Project Ideas and Implementation Across Curriculum , presented by Lauren Boucher . I encourage you to check out the recording of the training session, which has even more ideas!

Whether you use these Google Spreadsheet resources for organization, or classroom activities, I hope they turn out to be huge time savers for you, and your students.

• A Student's Guide to Using Google Sheets
• Student Class Notebook Template
• Tree Map – Graphic Organizer Template
• Lesson Plan Template
• Timeline Template
• Budgeting Template
• Exploring Weight and Age on other Planets
• Doctors as Detectives – Science Lesson Plan
• Global Grocery List – Collaborative classroom project
• Useful Google Spreadsheet Add-Ons

Another thank you to Lauren for these great ideas. Make sure to check out all of her training sessions inside the Teacher Learning Community.

Which project caught your eye first? Let me know your favorite in a comment on this article.

About the Author Kimber Thompson is a Lead Moderator for SimpleK12 webinars and a Contributing Editor for SimpleK12.com. She writes frequently about education topics and is passionate about tools and techniques that inspire young learners. You may reach her with ideas and comments at [email protected] .

Professional Development made simple

We offer flexible classes that address the needs of teachers and schools to support today’s classrooms and increase student success

Latest posts

Best teacher certification programs in nevada in 2024, best 7 teacher certification programs in alabama 2024, how long does it take to get a teaching certificate in 2024, sign up for our newsletter.

Professional Development

Useful links.

© 2024 • Simple K12 – A Teachers of Tomorrow Company • All rights reserved.

• Grades 6-12
• School Leaders

FREE Poetry Worksheet Bundle! Perfect for National Poetry Month.

This Easy Google Sheets Hack Will Have Math Teachers Celebrating

Checking work just got way easier 🙌

What were your math classes like? Mine were like this: Picture 12-year-old me sitting in class listening to a lecture by Mr. Smith. Like any good student, I completed my homework that evening and turned it in the next day (hoping it was correct). In a few days, I would receive my paper back with some red “x” marks showing what I hadn’t mastered. But by that time, we had moved on to a new mathematical concept, so it was too late to revisit what I didn’t understand. And so on went the math lessons, until it was time to take a test.

Sadly, this is still the case in many math classes today at the secondary level. But it doesn’t have to be this way. During my training as a Google Certified Educator, I discovered that Google Sheets can provide quick and easy feedback to students and teachers. This has been especially helpful to me when I have limited prep time and a myriad of other school-related responsibilities. Such is the life of a busy teacher! 

Here’s how my Google Sheets hack works. Recently, I introduced a new concept to my seventh grade math students: solving one-step equations. During independent practice, I provide them with a piece of paper, and then I ask them to open the digital assignment from the digital math classroom. Students write down the equations on the paper and solve them. Finally, they “check” each solution using a Google Sheet. (See the graphic below.) As students enter a solution, the cell will reveal the color green if it is correct. If the solution is incorrect, the box will remain yellow. My students are directed to give the problem a second try. If students are still struggling, they may request help from their math partner or me.

Instead of spending your precious time grading or checking work, do less work ahead of time. Create a self-checking Google Sheet using conditional formatting and let an algorithm do the grading for you.

Want to try it for yourself? Here’s how:

1. Find math problems that you want your students to solve.

Be sure to have the solutions as well. On the first day of the lesson, I like to use basic math problems, such as those shown in figure A. 

2. Open a new Google Sheet.

Use column A to indicate the problem number, column B to type the math problem, and column C for the solutions/answers. 

3. Format your Solutions column.

Once you’ve entered the problem and problem number, highlight the solution cells, go to Format in your toolbar, and select the conditional formatting feature. Here, you can provide the correct answer for the Solution column and color-code responses as needed.

Are you more of a visual learner? Here’s a step-by-step video along with an example: 

Video Self-Check 4.2

Self Check 4.2

For the past two school years, this hack has helped my students accelerate through the math curriculum quicker and more thoroughly. I have found that by using these self-checking assessments, my students are performing better on standards. Even more important, they’ve adopted a “try this again” attitude instead of waiting days for feedback that’s already too late.

And this hack is not just for math class. This formative strategy can be used in other content areas as well, such as vocabulary practice, checking spelling words, or identifying regions on a map for social studies. The possibilities are endless!

What do you think of this hack? Let us know in the comments.

Looking for more articles like this be sure to subscribe to  our newsletters .

You Might Also Like

58 Heartwarming Winter Quotes for Chilly Days

Baby, it's cold outside. Continue Reading

Copyright © 2023. All rights reserved. 5335 Gate Parkway, Jacksonville, FL 32256

404 Not found

• Get started with computers
• Learn Microsoft Office
• Apply for a job
• Improve my work skills
• Design nice-looking docs
• Getting Started
• Smartphones & Tablets
• Typing Tutorial
• Online Learning
• Basic Internet Skills
• Online Safety
• Social Media
• Zoom Basics
• Google Docs
• Google Sheets
• Career Planning
• Resume Writing
• Cover Letters
• Job Search and Networking
• Business Communication
• Entrepreneurship 101
• Careers without College
• Job Hunt for Today
• 3D Printing
• Freelancing 101
• Personal Finance
• Sharing Economy
• Decision-Making
• Graphic Design
• Photography
• Image Editing
• Learning WordPress
• Language Learning
• Critical Thinking
• For Educators
• Translations
• Staff Picks
• English expand_more expand_less

Google Sheets  - Getting Started with Google Sheets

Google sheets  -, getting started with google sheets, google sheets getting started with google sheets.

Google Sheets: Getting Started with Google Sheets

Lesson 8: getting started with google sheets.

/en/googlespreadsheets/converting-and-printing-docs/content/

Introduction

Google Sheets allows you to organize , edit , and analyze different types of information using spreadsheets. In this lesson, you'll learn about the different ways you might use spreadsheets and how to navigate the Google Sheets interface. You'll also learn the basic ways to work with cells and cell content , including how to select cells, insert content, and copy and paste cells.

Watch the video below to see an overview of Google Sheets.

All about Google Sheets

Google Sheets is a web-based spreadsheet application that allows you to store and organize different types of information, much like Microsoft Excel . While Google Sheets does not offer all of Excel's advanced features, it's easy to create and edit spreadsheets ranging from the simple to the complex.

While you might think spreadsheets are only used by certain people to process complicated numbers and data, they can actually be used for a variety of everyday tasks . Whether you're starting a budget, planning a garden, or creating an invoice or just about anything else you can think of, spreadsheets are a great way to organize information.

Review the slideshow below to learn some of the other ways you might use spreadsheets.

To create a new Google spreadsheet:

You may notice that there is no save button. This is because Google Drive uses autosave , which automatically and immediately saves your files as you edit them.

The Google Sheets interface

In order to use and edit spreadsheets, you will need to become familiar with the Google Sheets interface .

Click the buttons in the interactive below to learn more about the Google Sheets interface.

Toolbar Menu

You can use the toolbar menu options to edit and modify your spreadsheet in various ways. Click a menu and select the desired action from the drop-down list.

Spreadsheet Title

By default, any new spreadsheet is named Untitled Spreadsheet. Click the title to rename the spreadsheet.

Collaboration Options

Collaboration options allow you to share your spreadsheet with others and make comments as you work.

Shortcut Toolbar

This toolbar provides convenient shortcut buttons for formatting the data in your spreadsheet, like font size, text alignment, and text color.

A column is a group of cells that runs vertically from top to bottom. Columns are identified by letters. Column C is selected in this example.

A row is a group of cells that runs horizontally from side to side. Rows are identified by numbers. Row 9 is selected in this example.

Each rectangle in a spreadsheet is called a cell. A cell is the intersection of a row and a column. Click to select a cell. Cell A1 is selected in this example.

Sheets Toolbar

Every spreadsheet can have multiple sheets . Select the sheet tabs to navigate among sheets, and click the plus sign (+) to add a new sheet.

Formula Bar

You can use the formula bar to enter and edit data, functions, and formulas for a specific cell.

Navigate to Google Sheets Home Screen

Click this icon to navigate back to your Google Sheets homepage .

Saved Changes Notification

Google Sheets automatically saves your changes as you work. The saved changes notification lets you know your spreadsheet has been saved.

Cell basics

Every spreadsheet is made up of thousands of rectangles, which are called cells . A cell is the intersection of a row and a column . Columns are identified by letters (A, B, C) , while rows are identified by numbers (1, 2, 3) .

Each cell has its own name —or cell address —based on its column and row. In this example, the selected cell intersects column C and row 10 , so the cell address is C10 . Note that a cell's column and row headings become darker when the cell is selected.

You can also select multiple cells at the same time. A group of cells is known as a cell range . Rather than a single cell address, you'll refer to a cell range using the cell address of the first and last cells in the cell range, separated by a colon . For example, a cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5 .

In the images below, two different cell ranges are selected:

Understanding cell content

Any information you enter into a spreadsheet will be stored in a cell. Each cell can contain several different types of content, including text , formatting , formulas , and functions .

To select cells:

To input or edit cell content, you'll first need to select the cell.

• Click a cell to select it.

You can also select cells using the arrow keys on your keyboard.

To select a cell range:

Sometimes you may want to select a larger group of cells, or cell range .

• Click and drag the mouse until all of the cells you want to select are highlighted .

To insert cell content:

To delete cell content:

• Select the cell you want to delete .

To copy and paste cells:

It's easy to copy content that is already entered into your spreadsheet and paste this content to other cells.

• Select the cells you want to copy.

To cut and paste cells:

Unlike copying and pasting—which duplicates cell content—cutting and pasting moves content between cells.

• Press Ctrl+X (Windows) or Command+X (Mac) on your keyboard to cut the cells. The cell content will remain in its original location until the cells are pasted.

There may be times when you want to copy and paste only certain parts of a cell's content. In these cases, you can use the Paste Special option. Click Edit in the toolbar menu, hover the mouse over Paste Special , and select your desired paste option from the drop-down menu.

To drag and drop cells:

Rather than cutting and pasting, you can drag and drop cells to move their contents.

To use the fill handle:

There may be times when you want to copy the content of one cell to several other cells in your spreadsheet. You could copy and paste the content into each cell, but this method would be time consuming. Instead, you can use the fill handle to quickly copy and paste content from one cell to any other cells in the same row or column.

• Select the cell you want to use. A small square—known as the fill handle —will appear in the bottom-right corner of the cell.

Using the fill handle to continue a series

The fill handle can also be used to continue a series . Whenever the content of a row or column follows a sequential order—like numbers (1, 2, 3) or days (Monday, Tuesday, Wednesday) —the fill handle will guess what should come next in the series. In our example below, the fill handle is used to extend a series of dates in a column.

• Open Google Sheets and create a new blank spreadsheet .
• Change the spreadsheet title from Untitled Spreadsheet to Practice Spreadsheet .
• In cell A1 , type the date using the format M/D/YY (for example, 5/30/17).
• Use the fill handle to place dates in cells A1:A10.
• Use drag and drop to move the dates to cells B1:B10.
• Delete the content in cell B5 .

/en/googlespreadsheets/modifying-columns-rows-and-cells/content/

Instructions

• Sign into your Google account.
• Welcome to Google Workspace for Beginners
• Lesson Guide

• Skip to primary navigation
• Skip to main content
• Skip to primary sidebar

Peter Larson

Teacher, Coach, Dad

Google Sheets Rubric Template for Google Classroom Assignments

March 31, 2020 by oblinkin74 3,627 Comments

Google Classroom is a platform that I use as an online hub for all of my classes. I noticed recently that there was an option to create a rubric to assist in grading of assignments, but after playing with it a bit I found the process of creating one in Classroom a bit cumbersome and time consuming. I also noticed that a rubric could be imported from Google Sheets . I use Sheets all the time, and it seemed like it might be a better tool than the native rubric creator on Classroom. The problem was that I didn’t know what format the Sheets file needed to be in to get it to import (my first few tries failed). To figure it out, I created a 1-item rubric in Classroom, then exported it to Sheets. I then opened the file in sheets, which provided a template for a single question that could be copied and pasted to add multiple criteria for an assignment.

In an effort to help others who might be trying to do the same, here is a link to a Google Sheets Rubric Template that I made for Google Classroom (to make a copy for yourself, click the “File” dropdown, then “Make a Copy”). It is formatted only for five criteria/items, with each one having 6 levels. Any cell on here can be modified easily, and you can cut and paste the set of rows for any given criterion to add more below on the spreadsheet. You can also add columns to the right side on each scale if you want to do a 10 point scale and so on.

Hope this helps, let me know if you have questions and I can try to help!

Related posts:

• Classroom Activity: Experimental Design in Google Slides
• Teaching Tool: Digital Lesson Planner in Google Sheets
• Attendance Roster and Grading Spreadsheets in Google Sheets
• How to post Google Classroom announcements to multiple class sections

16 Ideas for Student Projects Using Google Docs, Slides, and Forms

July 31, 2016

Can't find what you are looking for? Contact Us

As you probably know, Google Drive is far more than a place to store files online. It also includes a suite of versatile creation tools, many of which perform the same functions as the ones we use in other spaces. These include  Google Docs,  a word processing program that behaves similarly to Microsoft Word,  Google Slides,  a presentation program similar to PowerPoint, and  Google Forms,  a survey-creation tool similar to Survey Monkey.  Although Drive also includes other tools, these three are particularly useful for creating rigorous, academically robust projects. If your school uses Google Classroom or at least gives students access to Google Drive, your students are probably already using these tools to write papers or create slideshow presentations, but there are other projects they could be doing that you may not have thought of.

Below I have listed 16 great ideas for projects using Google Docs, Slides, and Forms.

Annotated Bibliography By the time a student reaches the later years of high school, and certainly by the time she’s gotten to college, it’s likely that she’ll be required to write an annotated bibliography, a list of resources that not only includes the bibliographical information of each source, but also a short paragraph summarizing the resource and reflecting on its usefulness for a given project. Usually an annotated bibliography is required as a part of a larger research paper, but it could stand alone as an assignment that tasks students with seeking out and evaluating sources just for the practice of doing so. And the research tools in Google Docs allow students to locate, read, and cite their sources all in one place. To learn more, see this guide from Cornell University Library on How to Prepare an Annotated Bibliography .

Book Review Instead of a book report, have students write a book review instead. This is certainly not a new idea, but publishing the work electronically allows students to enhance the final product with the book’s cover image, a link to the book’s page on Amazon, and even links to other titles the author has written or articles on related topics. For models and inspiration, elementary and middle school students can read student-written reviews on sites like Spaghetti Book Club . Older or advanced students might work toward more sophisticated, nuanced review styles like book reviews written on Oprah.com .

Collaborative Story Because Google Docs is cloud-based, multiple people can work on a Doc at the same time. So students can work together on a story, a script for a play, or any other kind of group writing project. They can use the comments feature to give each other feedback and make decisions together. And because students can work from any location with an Internet connection, collaboration isn’t restricted to school hours; each group member can work on the project from any location whenever they have time.

Media-Rich Research Paper Any kind of research paper can be given a big boost when done in a Google Doc, because students can insert images, drawings, and links to other relevant resources, like articles and videos. Using the research tools built into Docs, students can research their topics and include in-text citations with footnotes.

Super Simple Blog If you don’t want to mess with actual blogging platforms, but want students to be able to experience writing blog posts that contain images and hyperlinks to other websites, this could be accomplished easily in a single running Google Doc.

Table Being able to organize information visually is an important skill, and students who understand how to build a table in Google Docs will have a skill for presenting all kinds of information in the future. They can be used as a compare and contrast exercise, to display data from an experiment, or even put together a schedule. Yes, you could do these things yourself, print them, and have students fill them out, but why not have students practice creating the tables themselves? 

Choose-Your-Own-Adventure Story Because slides can contain hyperlinks to other slides, students could build a whole story where the reader chooses different options at key points in the story, leading them down completely different paths. The reader would consume the content as a slideshow, clicking on the links themselves as they go through. This could be a pretty massive undertaking, but we all know students who would be totally up for the challenge.

E-book These could take a variety of forms: mini-textbooks, children’s books, cookbooks or how-to manuals, personal art or writing portfolios, even yearbook-style memory books. To learn more about the possibilities, see my post from earlier this year on  Student E-Books .

Magazine Along the same lines as an e-book, students could use a similar template to create a PDF magazine or newsletter that is shared online on a regular schedule. The possibilities here are endless, useful for student clubs or sports teams, classroom or grade-level newsletters, or magazines put out by groups of students who share a common interest, like gaming systems, soccer, or books.

Museum Kiosk Imagine if we could enhance science fair projects with a looping video display that provides the audience with vivid visuals and text about our topic. Or imagine an art show, where a self-running informational slideshow could be placed beside an art display to share the story behind the piece and photos of the work in progress? This is possible and EASY in Google Slides: Simply create a slideshow, then use the “Publish to the Web” feature to create a slideshow that auto-advances and has no need for a presenter. Pop that up on an iPad or laptop and you’re all set. This mock-up of a slideshow on Coral Reefs shows you what it could look like (click the image to open in a new window).

Short Film Students can upload their own images and add text boxes to a slideshow to create an animated story, then record the slideshow with a Google extension called Screencastify . They can either record their own voice as narration, add background music, or both. There are so many different kinds of films students could produce: illustrated stories or poems, final reflections for a 20 Time or Genius Hour project, video textbooks on content-related topics, or news-like feature stories of school or community events. In this quick sample, I added music from YouTube’s library of royalty-free music that anyone can use to enhance their recordings:

Video Tutorial Using the same screencasting software mentioned above, students could also create their own video tutorials by creating a Slides presentation on their topic (such as “How to Open a Combination Lock”), then recording the slideshow with narration. This would make a nice final product for a unit on informational writing or a way for students to demonstrate their learning at the end of a unit in science (“How to Take Care of Lab Equipment”), social studies (“How to Measure Distance on a Map”), or math (“How to Multiply Fractions”). Student-made tutorials could even be created to teach classroom procedures. And any tutorials students make could be stored for later, so other students can also benefit from them.  Learn more about how Screencastify works right inside Chrome .

Peer Survey Whenever students need to gather data to support an argumentative essay or speech, let them gather data quickly and easily by creating a survey with Google Forms. Links to the survey can be sent out via email, QR codes , or through a post in a learning management system like Edmodo or Google Classroom. When results come in, students can use them to support whatever claim they are trying to make in their argument, or make adjustments based on what they discover in their research.

Feedback Form Have students provide feedback to each other’s presentations, speeches, even videos using Google Forms. Here’s how it would work: Each student creates her own form, asking for the kind of feedback she wants on the project. As other students view or the project, they can be sent to a form to offer praise or constructive criticism, which the creator would then be able to view privately and use to improve the project. Students could even use their feedback to write a reflection on their process after the project is done.

Quiz One great way to learn material is to create a test or quiz over the content. Have students use Google Forms to create their own multiple-choice, True/False, fill-in-the-blank, or open-ended quizzes on the content they are learning.

Visual Representation of Data Sets Whenever people enter responses to a Form, Google allows the form creator to view responses in charts and graphs. Have students gain a better understanding of how data can be represented visually by accepting responses (or entering their own fake ones) into a Form, then looking at how the numbers are represented in graphs. This could work well as a series of math lessons.

Way Beyond Worksheets

Just this morning on Twitter, someone posted a comment along these lines: “A worksheet on a Google Doc is STILL a worksheet. Students should be using tech to create!” I’ve heard this sentiment over and over, and it’s exactly why I’ve put this list together. Google offers some incredibly powerful tools if we know how to use them. I hope this list has given you a few new ideas to put into your students’ hands. ♦

What to Read Next

Categories: Instruction , Technology

Tags: assessment , content area literacy , English language arts , Grades 3-5 , Grades 6-8 , Grades 9-12 , project-based learning , teaching with tech , tech tools

51 Comments

This is wonderful.

This is my first year teaching in an alternative high school. All students have IEP’s as well as social and emotional disabilities. I really want to focus on literacy as many are well below grade-level, ability wise. Writing of course is a big part of literacy. I’m looking for ideas that they can collaborate on, via Google Docs, Slides, etc. Any thoughts would be appreciated.

Check out Boomwriter: A Fun Twist on Collaborative Writing . Lots of good resources there that you might like. Also take a look at Student-Made E-Books: A Beautiful Way to Demonstrate Learning .

I am an RSP teacher in Anaheim. For summer school I am going to have them build a “Bucket List” in Google slides.

Thanks for compiling these resources. I use many already but haven’t tried Screencastify yet. My district uses Google Classroom, but the forms app is blocked on student accounts- I think because it’s a perfect medium for under-the-radar cyberbullying (“How much do you hate Linda?…A little, a lot, a ton…”). Before teachers plan a lesson using forms, they should make sure the feature is enabled for students in their district. In my district, students can access forms and create them but they cannot send them to other students.

Thanks, Robyn. Good to know!

I love these ideas! You are so creative and now I have GREAT ideas for my SS project! Thanks! XD

this is all true

Our district is allowing extra credit this year and I have always been totally opposed to offering extra credit. These ideas are worth extra credit, and my focus this year is on what the students can teach me and the rest of their peers.

This gave me some good ideas for culminating activities. Thanks!

Thank you so much for sharing these ideas about creating projects by using the Google Drive! The middle school I teach at implemented a 1:1 program last year with Chromebooks, so the students have easy access to all of the Google apps. I had always grown up using Word docs and I was a little hesitant to start using Google docs at first. After just a few weeks, I absolutely fell in love with it! It is amazing how you can access all of your docs, forms, slides that you create from any device you’re using and the fact that everything automatically saves is just the cherry on top. I am grateful for this feature, especially working in a middle school where it is easy for students to forget to save something before exiting out. Although I teach Math, I found a lot of your project ideas to be utilized cross-curriculum and I truly appreciate it. I got my feet wet last year and had my students create google slides presentations in groups. At the beginning of this year, I started with a google form I created where students answered review questions from 6th grade Math. I love that when you get the results from all of the forms, you can easily see which areas students are struggling in and which areas they are proficient in because it is presented the results in graphs and charts. I just learned recently that you can create quizzes now, which is awesome because all of the testing in my district is done on the computers, so this will help prepare my students. I want to borrow your idea of having students create peer surveys that they can post on Google classroom in order to gather information and analyze results. This is a great skill for students to have. Thanks again, I truly enjoy reading your blogs!

Be positive at all time

Great collection of resources! Easy to read and very helpful for teachers who often do not get the tutorials they need to instruct with GAFE. I particular like the Museum Kiosk idea. It will work great will my history classes.

– Kevin

Hi everyone! I also would like to suggest my own (free) templates site. Im designing these presentations using “free” resources from other sites such as FreePik, FlatIcon,… and I think the result is pretty good. I invite you to have a look. The site is https://slidesppt.com

In the section of student blog posts, can you clarify how all the students in one class could be writing and posting a running blog which everyone in the class can read and respond to ?

This is Holly Burcham, a Customer Experience Manager. The idea Jenn laid out here is to simply create a shared Google Doc where each student would basically be responsible for his/her own page (literally page 1, page 2, etc.). Within a shared Doc, everyone with permission can be in and typing at the same time. Once “posts” are written, students can go in and add comments to others’ work. The comments would show up in the margins and would be arranged by corresponding content, not time like a typical blog post.

But, as you can imagine, this could quickly become very convoluted and a bit messy. The thought behind using Docs as a student blog is more for writing practice, getting the feel for writing a blog post without doing the real thing…

So, if you’re interested in your students truly creating a blog, we highly recommend checking out Edublogs and Kidblog . Hope this helps!

How are these good for projects? you said that these are for kid presentations, all I see are essay templates and idea’s for teachers to map out their classroom jobs(other then the coral)

Hi, Isaac! I’m not sure what could be used to map out classroom jobs specifically from this post, and I think the ideas here go way beyond essay outlines–please get back to me to clarify exactly what you’re referring to, because we believe all the ideas here are good for student use. Thanks!

You might update this post. Google Forms now supports branching which would be much easier to create a “choose your own” adventure type experience.

Thanks for the suggestion. I can picture how that would work, yes, but I guess the aesthetic experience might be lacking in a Google Form. With Slides you have complete creative freedom to design the slides like a real book. I guess it would be a matter of personal preference?

Where do I go to find accessibility features of Google docs, slides, and forms? I am a teacher of the blind and visually impaired. This technology is wonderful but without the ability to navigate the site independently, my students are at a lost. Can you direct me?

Hi! A couple of things that may be of help: Go to “Tools” in the menu bar and select Voice Typing (use Google Chrome). You can also click on Add-Ons in the menu bar and add the Speech Recognition Soundwriter extension for free. Here’s a link to find more Google Accessibility features — you just have to spend a bit of time looking through the list to see what may be relevant to your needs. I hope this helps!

You can also combine Google forms and docs to simplify book reports for elementary students: https://electriceducator.blogspot.com/2016/03/elementary-book-report-machine.html?m=1

Is there an available rubric or assessment piece for the museum kiosk activity?

Hi Colleen! No, sorry, I don’t have anything on that!

Hi I am a teacher at a elementary school and I was wondering if you had any ideas for what I could do for an autobiography book report.

Hi Madison,

There really are so many things you can have the kids do — I would first think about what you’re expecting the kids to be able to do in the end. What will actually be assessed and what will they be accountable for? (I suggest checking out Understanding Backward Design if you haven’t already.) From there, they can choose how to present what they learned, meeting the assessment criteria. I think using some of the ideas in the Slides section of the post could work really well, especially Student Made E-Books , or making a short film.

Madison, I love the idea of using Google Slides for autobiography book report. I’m thinking about Jennifer’s Slides suggestions and just tailoring it to your book report criteria/rubric. Thoughts?

thank you very much!!

Thank you! I can’t wait to explore some of these options more. This list is very much appreciated! 🙂

I really appreciate your kindness and your efforts and I’m going to try everything you have mentioned in this wonderful article

Thanks. Higher Ed ESOL Prof -no lesson prep for me… but I DO have my reading list for the next several (10-12) hours! All suggestions added to the original post are appreciated.

I am a huge fan of Google resources, but you have showed me some new ways I can use these. Thank you for sharing!

Thanks for some great ideas! I have another suggestion that I have used before- my students really liked it- a collaborative Google Slides presentation. I did this for types of organic molecules as an intro to organic chemistry. Each pair of students in the class was assigned a specific molecule to research. They had to create 1 slide with some specific information and add to a collaborative google slides presentation that I shared on Google Classroom. When the slideshow was complete, they could all access it, and they used it to take notes.

Great suggestion Susan! Thanks so much for sharing this idea.

I am wondering if I can find similar google instructions to send to my students now that we are teaching remotely and 90% of them probably don’t know how to use Google. This would be a fantastic use of their time. Thank you

Take a look at Jenn’s Google Drive Basics video course ! I think it’s got what you’re looking for – it’s for teachers and students!

I am thinking about doing a Rap Challenge in which they (as teams based on which class period they are in) create lyrics using WWII vocabulary we have used.

I create raps for my students and my though was that I would take parts of ALL of their submissions and create a WWII rap to add to the collection they have heard already.

Which of the Google Drive features would be my best bet for collaboration like that while the students are all working from home?

Hi Jim! I think this could be done in Google Docs pretty easily, as they are just writing a script, correct? If you want to share video or audio, you can just put these files into a shared folder in Drive and give all students access to those files. I hope this helps!

Amazing ideas

An innovative way to eliminate paper.

Hi! I love this site. I am beginning to use technology in my higehr education classroom. Could you help me to suggest some kind of game to use in Communication Skilss? Thanks a lot

Hi! Check out our Gamification Pinterest board and see what might be relevant. Hope this helps!

I’m a college student (who is now a nanny which brought me to this page) and for the screen recording, I highly reccomend Loom over Screencastify. In my experience using both during the remote learning period, the video quality is much higher on Loom, the user interface is easier, and you can’t edit Screencastify videos in an external editor like iMovie. (I had to do a group presentation and since partner lived in Kuwait we used this vs Zoom, etc. to record the presentation since we weren’t recording at the same time. It was very difficult to figure out how to merge our parts of the presentation into a single file.)

Also with screencastify the time limit per video on the free version (5 min I think) was frustrating as my work was longer. May not be a problem for students but for educators using the tool who don’t have the premium, this could be highly inconvenient. With Loom there isn’t a time limit.

What an adventure for me, who’s relatively new to this google drive thing. Mind blowing resources. It’s amazing. I’m excited as to what I can do with and in google drive. I’m definitely taking it one day at a time, will surely enjoy this ‘CRUISE’. Thank you Jennifer.

What does it mean to type I am from Germany?

Hi Flannery! It can mean a few different things depending on the context–either typing on a keyboard or the “kind” of something (“What type of ice cream do you like?”). We’d love to give a specific answer, so please let us know which part of the post or which comment you saw that you’d like more clarification on. Thanks!

Thanks for sharing these ideas. July 2021

I love all the awesome ways to incorporate technology in the classroom. This post had so many options to choose from and some that I personally loved when I was in school. There are so many different ways to make learning fun with technology!

So glad you enjoyed the post!

Leave a Reply

Your email address will not be published.

• Skip to primary navigation
• Skip to main content
• Skip to primary sidebar

Teaching Expertise

• Classroom Ideas
• Teacher’s Life
• Deals & Shopping
• Privacy Policy

52 Google Classroom Activities For Middle Schoolers

November 24, 2023 //  by  Ashley Charles

Since virtual learning took off during COVID-19, Google Classroom has proven to be a practical platform for managing classrooms and captivating students. With technology advancing globally, adopting up-to-date digital tools is imperative for your students’ success. With the 22 Google Classroom activities below, you can use your middle schoolers’ technological talents to enhance learning, foster tech skills, and organize your classes! Whether you use a single activity or incorporate them all to run your classroom, these activities, add-ons, and apps are sure to please!

1. American Museum of Natural History

Bring your teaching to life using the resources that are available from the American Museum of Natural History. With a simple click of the “Share to Classroom” button, your classes will be instantly connected to a variety of articles and other resources like online tours, and stimulating visual aides.

Learn More: American Museum Of Natural History

2. Classcraft

Classcraft approaches motivation creatively by gamifying behavior management to promote positive habits for your middle schoolers! The program integrates seamlessly with rosters in Google Classroom to help you manage your students’ behavior.

Learn More: Classcraft

Introducing computer science and coding to your middle school students has never been easier! CodeHS merges seamlessly with Google Classroom to provide a variety of age-appropriate, rigorous, and fun programming activities for your kiddos.

Learn More: CodeHS

4. Data Classroom

Have a unit on data coming up soon? Data Classroom can link up with your Google Classroom to make plotting and analyzing data digestible and engaging for your students who are new to statistics! They’ll love all of the fun ways that they can display and interpret their data sets.

Learn More: Data Classroom

5. Duolingo

Are your students learning a second language? Using Duolingo in combination with Google Classroom is an organized and easy-to-track way of bringing a digital element to language learning. The simple and entertaining structure of lessons makes it perfect for your polyglots!

Learn More: Duolingo

6. Google Forms

Google Forms is great whether you’re a teacher or a student! You can use these as a fun way to deliver a class quiz or gather information from your kiddos for a lesson or at the end of a lesson. Your learners can also use them in a project or just for fun! Either way, they’ll be having fun and growing their digital skills

Learn More: Google Forms

7. Google Slides

Google Slides is another versatile tool from the Google Suite. Perfect for completing homework assignments, reviewing notes, and doing collaborative activities, your students can access Slides through their Google Classroom profile. What’s even better is that you can review and keep track of their work remotely! 

Learn More: Google Slides

8. Jamboard

If your board space is taken up by lists, calendars, and anchor charts or you’re responsible for a program of remote learning then Jamboard is the perfect collaboration tool! It will help get your learners engaged and working together to create a display of ideas and thoughts.

Learn More: Jamboard

9. Flipgrid

Flipgrid is another amazing digital collaboration resource that connects with Google Classroom for interactive lessons. Your middle school kiddos will absolutely adore creating unique Flipgrid videos and sharing them with their peers!

Learn More: Flipgrid

10. Fluency Tutor

While most of your middle school students should be able to read fluently on grade level, the reality is that this is not always the case. When your kiddos need remediation, Fluency Tutor is incredibly helpful because it allows them to record their practice and hear themselves reading.

Learn More: Fluency Tutor

This app works with Google Classroom to help your students collaborate and learn interactively through beautifully designed lessons! You or your kiddos can create Padlets to provoke discussions, introduce new content, or make presentations!

Learn More: Padlet

12. Take Attendance

Make attendance a breeze by creating a morning quiz in Google Classroom to get your middle schoolers thinking and responding while attendance takes itself! These questions could be personal to help you bond with your kiddos or academic to help them recall past material. 

Learn More: Attendme Attendance Quiz

13. Google Classroom App for Evidence

Google works well within schools and is also incredibly accessible to students and their families outside of the classroom. Using the classroom app to submit homework and to take photos as evidence of work or understanding is another exceptional way to utilize Google Classroom’s many resources in a practical way.

Learn More: Google Classroom App

14. Communication

Above all else, Google Classroom is a fantastic tool for communicating with your middle school students and their parents. This platform offers the perfect way to get the word out about important information like schedules and forms by sending announcements to your class.

Learn More: Alice Keeler

15. Celebrate Great Digital Work

Putting stickers on kids’ work seems to always excite them. Whether they are in 2nd grade or 7th grade, stickering work is definitely still a thing! They LOVE it and they will love it even more after they’ve submitted a digital assignment in Google Classroom and you slap a digital sticker on that too!

Learn More: A Love of Teaching

16. Google Slides Turned Interactive Notebooks

Spiral notebooks are becoming a thing of the past now that the digital age is steadily taking over. Whether students have blended learning, in-person learning, or completely virtual, this idea helps keep kids organized! Plus, it helps save trees!

Learn More: Student Savvy

17. Flash Cards

Google Classroom is the perfect place for flashcards created in Slides! You can make test reviews and vocabulary flashcards and upload them to your Google Classroom to give your students access to resources in and out of school! There’s no excuse for them not to know their times tables now!

Learn More: The Techie Teacher

18. Google Draw

Instead of your kiddos relying on uninspired images from the internet, have them use Google Draw within Google Classroom! Whether they are making a slideshow or adding to a report, Google Draw will help them solidify their knowledge with a visual representation of their very own, all whilst learning a whole new skill too!

Learn More: Two Boys And A Dad

19. Kahoot!

Ask any kid about Kahoot and they’ll rave for hours. Teens and tweens love a good challenge, and adding Kahoot to your Google Classroom will offer that perfect amount of competition to keep them engaged in whatever topic you’re teaching. You can even use it outside of the classroom, maybe over a break as a check-in or relationship-building activity!

Learn More: Ditch That Textbook

20. Digital Escape Rooms

Another game-style activity is an escape room. Your middle school students will enjoy working through digital escape rooms that you can assign to them in Google Classroom. These would work well to turn the focus of learning from a “lesson” to more of a “game,” or for a class party!

Learn More: Karly’s PD Resources

21. Roll Some Dice

Have you ever found yourself, five minutes before class starts, searching high and low for that tub of dice that you swear was there yesterday!? You’ll be wishing that you had downloaded this Google Slides template for your Google Classroom! It’s perfect to use with your students for silent, focused dice-rolling during math games or other activities, and you’ll never lose them! 

22. Virtual Guest Speakers

Infuse your Google Classroom with the expertise of guest speakers! Combine Q&A discussions with the speaker and pertinent assignments for your students on Google Classroom to help them get the most out of the experience. Google Meet is fully integrated with Google Classroom for seamless interviews!

Learn More: Emerging EdTech

23. Ed Puzzle Integration

Putting together interactive video lessons doesn’t have to be complicated! Ed Puzzle lets you embed questions for your students into videos and share them seamlessly through Google Classroom. Your kiddos will love this fun, interactive way of learning!

Learn More: Ed Puzzle

24. Newsela For Current Events

Keep your pupils informed using Newsela. The platform provides perfectly pitched articles at varied reading levels, making it accessible to everyone in your classroom. You can share these directly through Google Classroom, picking topics that align with your current topics or class interests.

Learn More: Newsela

25. Screencastify For Demonstrations

Screencastify records your screen to make instructional videos for Google Classroom. Showing your work with Screencastify can help your kiddies learn by example to navigate new technological tools or other concepts that are difficult to grasp with a verbal explanation alone. This is a great idea if you’re setting some tricky homework that your learners might need some additional instruction on.

Learn More: Screencastify

26. Discovery Education Streaming

Discovery Education Streaming brings enthralling videos, virtual tours, and other educational resources appropriate for your middle schoolers directly to your Google Classroom! With resources across thirteen different topics, there’s sure to be something for everyone in your class.

Learn More: Discovery Education

27. Interactive Google Maps

Add an unexpectedly exciting element to geography lessons using Google Maps! Google Maps integrates with Google Classroom to allow your students to explore new locations independently without even leaving their seats! Using street or overhead view allows them to have an almost first-hand experience of what life looks like in other parts of the world!

Learn More: YouTube

28. Mathletics For Mathematics

Are you struggling to get your kiddos to engage with your current math activities? Mathletics is a brilliant digital resource on which you can create individualized math exercises and challenges to engage each of your learners at their level. It also syncs with Google Classroom which makes tracking learning progress super efficient for teachers!

Learn More: Mathletics

29. Google Arts & Culture

Google Arts & Culture gives your students the ability to virtually tour a whole bunch of global museums, art galleries, and landmarks on their own through Google Classroom. From the Musèe d’Orsay in Paris to the Nagoya City Art Museum of Japan, they really can explore culture from all corners of the globe!

Learn More: Google Arts & Culture

30. Nearpod For Interactive Lessons

Nearpod facilitates interactive lessons and allows your kids to answer questions privately from their own phones or laptops. You can select answers anonymously that you’d like the entire class to look at, allowing your learners to participate in this group learning activity free of the usual anxieties that come with sharing their answers with the class! Share these lessons on Google Classroom to promote active learning!

Learn More: Nearpod

31. Time Management Tools

Help your learners develop vital life skills using time management tools with Google Classroom. Assigning tasks and deadlines encourages them to practice their organizational skills. This tutorial shows you how to smoothly integrate some simple time management tools with your Google Classroom for effective teaching.

32. Virtual Science Labs

Scientific curiosity can be difficult to ignite in middle schoolers without hands-on activities! With virtual science labs through Google Classroom, you can challenge them to perform safe, interactive experiments and learn how to record their observations.

Learn More: Praxi Labs

33. Bitmoji Classroom

Kids love to personalize their online presence so why not join in on the fun and create a virtual classroom using Bitmoji? Build your own cartoon classroom and fill this digital landscape with resource links, making it interactive for your class. All that’s left is to create your own Bitmoji avatar!

34. Storybird For Creative Writing

Get your kiddies excited to weave narratives, illustrate pictures, and publish their unique stories through Storybird! Their finished stories can be shared in your Google Classroom for analytical literary discussions with classmates. What a perfect way to combine a writing lesson with a task to improve your learners’ digital literacy!

Learn More: Storybird

35. Quizziz for Fun Assessments

Revamp the mundane with Quizziz, turning evaluations into exciting quests! Turn your Google Classroom into a fun, game-filled arena by sharing timed quizzes with your kiddies; it could be anything from a revision session to gauging their knowledge on a brand-new topic! This is a surefire way to park their competitive spirit all while enriching their learning. 

Learn More: Quizziz

36. Zearn Math

Target your middle schoolers’ learning with Zearn Math’s personalized mathematical sessions. This fantastic online tool allows you to cater to each learner’s pace by assigning lessons via Google Classroom in a way that accommodates different learning curves and promotes effective mathematical understanding.

Learn More: Zearn

37. Collaborative Writing with Google Docs

Google Docs is a classic and super simple tool for creating collaborative narratives and nurturing teamwork in your students! Co-authorship can also help your kiddos bond and hone their communication skills–plus, Google Docs works seamlessly with Google Classroom! You can even hop on from your own device and give them feedback in real-time as they work.

38. Desmos For Interactive Graphing

Simplify mathematics with Desmos’s interactive graphing tool. Instruct students via Google Classroom to explore complex concepts through hands-on activities. Visual learning sparks curiosity, making math more relatable.

Desmos is an interactive graphing tool that allows your learners to explore complex mathematical concepts with superb visuals. Each of your kids can input their own data and see it made into a graph. You can give your middle schoolers instructions to use Desmos and share their graphs through Google Classroom!

Learn More: Desmos

39. Google Earth Geography Exploration

Google Earth promises a tangible geography experience for your learners. Link your Google Classroom up to this amazing resource and watch as world terrains are revealed to your kiddos through virtual tours. You can assign specific tours that fit with your learning or just let them explore! A comprehensive geographical understanding of the world awaits!

40. Creating Podcasts

For a creative challenge, why not ask your middle schoolers to produce a podcast? They’ll need to write scripts, record, edit, and share their final podcasts on Google Classroom! This is an excellent project on so many fronts, building their skills in teamwork, research, writing, and evaluating their work, as well as teaching them a whole host of digital skills in recording and editing audio!

Learn More: Class Tech Tips

41. IXL Learning Integration

Bring IXL Learning to your Google Classroom to develop your learners’ skills and confidence across a whole range of subjects! You can assign skills and personalized practice to each of your kiddos via Google Classroom and keep track of their progress over time.

Learn More: IXL

42. Google Calendar For Planning

Introduce your kiddos to the concept of effective scheduling with Google Calendar. Show them how to devise their study plans and keep track of their assignments and deadlines all of which will enhance their time management skills. Google Classroom becomes a planner that helps them to organize their academic life.

Learn More: Chemistry Is My Jam

43. Virtual Book Clubs

Cultivate a love for literature by creating a virtual book club for your school or class! You can use Google Classroom to announce the assigned book and to facilitate discussions! Making this an online or digital task, can encourage your kiddos to make great contributions to the discussion in ways they may not have felt completely confident to do in person!

44. GeoGebra For Math Visualization

Illuminate mathematical concepts for your learners with GeoGebra’s unique visual tools! You can integrate your Google Classroom with apps from GeoGebra to assign interactive, intuitive activities to your students! Geometry has never been so fun!

Learn More: Geo Gebra

45. Digital Portfolios

Portfolios give your kiddies a chance to see snapshots of their learning over time! Introduce digital portfolios to your students through a variety of attachments and templates for Google Classroom that can automatically collect their work throughout the year into one manageable place! There’s even space for them to reflect on their learning and write their own thoughts!

Learn More: Teach Create Motivate

46. Glogster For Multimedia Projects

With Glogster’s digital studio, your students can create Glogs that include text, video, and clickable interactives to share with the class in Google Classroom! Let their creativity run wild and let them design it however they want.

47. Pear Deck for Engaging Presentations

Pear Deck is a platform that helps you enhance your virtual presentations to keep your students invested in your lessons! You can give these interactive presentations through Google Classroom to foster active participation in the learning. 

Learn More: Pear Deck

48. Tinkercad For 3D Design

Inspire some craftsmanship in your students with Tinkercad for 3D Design! Tinkercad turns Google Classroom into a digital workshop, hosting and sharing the design projects of your middle schoolers. This activity is the perfect blend of digital learning and creativity!

Learn More: Tinkercad

49. Epic For Reading

Foster your kiddos’ passion for reading with Epic!’s vast digital library. You can assign reading tasks via Google Classroom to keep them in the habit of reading, then set a follow-up task to check up on your learners’ comprehension. 

Learn More: Epic!

50. Canva for Design Projects

With Canva, your tweens will be able to indulge their imaginations and design polished posters, infographics, and presentations! You won’t believe how professional their creations will look! Plus, Canva lets you and your students publish straight to Google Classroom, making these two a match made in digital learning heaven!

Learn More: Canva

51. Quizlet for Study Tools

Supercharge your study sessions with Quizlet! Turn rote learning into fun with flashcards, entertaining mini-games, and personalized study based on each student’s individual challenges. With Google Classroom, you can quickly add your students to a Quizlet class to receive all the content and keep track of their scores!

52. Edublogs For Student Blogging

Writing blog posts is an amazing way for your middle school students to harness their unique voices and practice articulation! Assigning Edublogs to your kiddos in Google Classroom keeps writing blogs organized and effective! 

• Link to facebook
• Link to linkedin
• Link to twitter
• Link to youtube
• Writing Tips

Assignment Tracker Template For Students (Google Sheets)

• 6-minute read
• 18th May 2023

If you’re a student searching for a way to keep your assignments organized, congratulate yourself for taking the time to set yourself up for success. Tracking your assignments is one of the most important steps you can take to help you stay on top of your schoolwork .

In this Writing Tips blog post, we’ll discuss why keeping an inventory of your assignments is important, go over a few popular ways to do so, and introduce you to our student assignment tracker, which is free for you to use.

Why Tracking Is Important

Keeping your assignments organized is essential for many reasons. First off, tracking your assignments enables you to keep abreast of deadlines. In addition to risking late submission penalties that may result in low grades, meeting deadlines can help develop your work ethic and increase productivity. Staying ahead of your deadlines also helps lower stress levels and promote a healthy study-life balance.

Second, keeping track of your assignments assists with time management by helping prioritize the order you complete your projects.

Third, keeping a list of your completed projects can help you stay motivated by recording your progress and seeing how far you’ve come.

Different Ways to Organize Your Assignments

There are many ways to organize your assignment, each with its pros and cons. Here are a few tried and true methods:

• Sticky notes

Whether they are online or in real life , sticky notes are one of the most popular ways to bring attention to an important reminder. Sticky notes are a quick, easy, and effective tool to highlight time-sensitive reminders. However, they work best when used temporarily and sparingly and, therefore, are likely better used for the occasional can’t-miss deadline rather than for comprehensive assignment organization.

• Phone calendar reminders  

The use of cell phone calendar reminders is also a useful approach to alert you to an upcoming deadline. An advantage to this method is that reminders on your mobile device have a good chance of grabbing your attention no matter what activity you’re involved with.

On the downside, depending on how many assignments you’re juggling, too many notifications might be overwhelming and there won’t be as much space to log the details of the assignment (e.g., related textbook pages, length requirements) as you would have in a dedicated assignment tracking system.

• Planners/apps

There are a multitude of physical planners and organization apps for students to help manage assignments and deadlines. Although some vow that physical planners reign superior and even increase focus and concentration , there is almost always a financial cost involved and the added necessity to carry around a sometimes weighty object (as well as remembering to bring it along with you).

Mobile organization apps come with a variety of features, including notifications sent to your phone, but may also require a financial investment (at least for the premium features) and generally will not provide substantial space to add details about your assignments.

• Spreadsheets

With spreadsheets, what you lose in bells and whistles, you gain in straightforwardness and customizability – and they’re often free! Spreadsheets are easy to access from your laptop or phone and can provide you with enough space to include whatever information you need to complete your assignments.

There are templates available online for several different spreadsheet programs, or you can use our student assignment tracker for Google Sheets . We’ll show you how to use it in the next section.

How to Use Our Free Writing Tips Student Assignment Tracker

Follow this step-by-step guide to use our student assignment tracker for Google Sheets :

• Click on this link to the student assignment tracker . After the prompt “Would you like to make a copy of Assignment Tracker Template ?”, click Make a copy .

Screenshot of the “Copy document” screen

Find this useful?

Subscribe to our newsletter and get writing tips from our editors straight to your inbox.

2. The first tab in the spreadsheet will display several premade assignment trackers for individual subjects with the name of the subject in the header (e.g., Subject 1, Subject 2). In each header, fill in the title of the subjects you would like to track assignments for. Copy and paste additional assignment tracker boxes for any other subjects you’d like to track, and color code the labels.

Screenshot of the blank assignment template

3. Under each subject header, there are columns labeled for each assignment (e.g., Assignment A, Assignment B). Fill in the title of each of your assignments in one of these columns, and add additional columns if need be. Directly under the assignment title is a cell for you to fill in the due date for the assignment. Below the due date, fill in each task that needs to be accomplished to complete the assignment. In the final row of the tracker, you should select whether the status of your assignment is Not Started , In Progress , or Complete . Please see the example of a template that has been filled in (which is also available for viewing in the Example tab of the spreadsheet):

Example of completed assignment tracker

4. Finally, for an overview of all the assignments you have for each subject throughout the semester, fill out the assignment tracker in the Study Schedule tab. In this tracker, list the title of the assignment for each subject under the Assignment column, and then color code the weeks you plan to be working on each one. Add any additional columns or rows that you need. This overview is particularly helpful for time management throughout the semester.

There you have it.

To help you take full advantage of this student assignment tracker let’s recap the steps:

1. Make a copy of the student assignment tracker .

2. Fill in the title of the subjects you would like to track assignments for in each header row in the Assignments tab.

3. Fill in the title of each of your assignments and all the required tasks underneath each assignment. 

4. List the title of the assignment for each subject and color code the week that the assignment is due in the Study Schedule .

Now that your assignments are organized, you can rest easy . Happy studying! And remember, if you need help from a subject-matter expert to proofread your work before submission, we’ll happily proofread it for free .

Share this article:

Post A New Comment

Got content that needs a quick turnaround? Let us polish your work. Explore our editorial business services.

3-minute read

What Is a Content Editor?

Are you interested in learning more about the role of a content editor and the...

4-minute read

The Benefits of Using an Online Proofreading Service

Proofreading is important to ensure your writing is clear and concise for your readers. Whether...

2-minute read

6 Online AI Presentation Maker Tools

Creating presentations can be time-consuming and frustrating. Trying to construct a visually appealing and informative...

What Is Market Research?

No matter your industry, conducting market research helps you keep up to date with shifting...

8 Press Release Distribution Services for Your Business

In a world where you need to stand out, press releases are key to being...

How to Get a Patent

In the United States, the US Patent and Trademarks Office issues patents. In the United...

Make sure your writing is the best it can be with our expert English proofreading and editing.

for Education

• Google Classroom
• Google Workspace Admin
• Google Cloud

Easily distribute, analyze, and grade student work with Assignments for your LMS

Assignments is an application for your learning management system (LMS). It helps educators save time grading and guides students to turn in their best work with originality reports — all through the collaborative power of Google Workspace for Education.

• Get started
• Explore originality reports

Bring your favorite tools together within your LMS

Make Google Docs and Google Drive compatible with your LMS

Simplify assignment management with user-friendly Google Workspace productivity tools

Built with the latest Learning Tools Interoperability (LTI) standards for robust security and easy installation in your LMS

Save time distributing and grading classwork

Distribute personalized copies of Google Drive templates and worksheets to students

Grade consistently and transparently with rubrics integrated into student work

Add rich feedback faster using the customizable comment bank

Examine student work to ensure authenticity

Compare student work against hundreds of billions of web pages and over 40 million books with originality reports

Make student-to-student comparisons on your domain-owned repository of past submissions when you sign up for the Teaching and Learning Upgrade or Google Workspace for Education Plus

Allow students to scan their own work for recommended citations up to three times

Trust in high security standards

Protect student privacy — data is owned and managed solely by you and your students

Provide an ad-free experience for all your users

Compatible with LTI version 1.1 or higher and meets rigorous compliance standards

Product demos

Experience google workspace for education in action. explore premium features in detail via step-by-step demos to get a feel for how they work in the classroom..

“Assignments enable faculty to save time on the mundane parts of grading and...spend more time on providing more personalized and relevant feedback to students.” Benjamin Hommerding , Technology Innovationist, St. Norbert College

Classroom users get the best of Assignments built-in

Find all of the same features of Assignments in your existing Classroom environment

• Learn more about Classroom

Explore resources to get up and running

Discover helpful resources to get up to speed on using Assignments and find answers to commonly asked questions.

• Visit Help Center

Get a quick overview of Assignments to help Educators learn how they can use it in their classrooms.

• Download overview

Get started guide

Start using Assignments in your courses with this step-by-step guide for instructors.

• Download guide

Teacher Center Assignments resources

Find educator tools and resources to get started with Assignments.

• Visit Teacher Center

How to use Assignments within your LMS

Watch this brief video on how Educators can use Assignments.

• Watch video

Turn on Assignments in your LMS

Contact your institution’s administrator to turn on Assignments within your LMS.

• Admin setup

Explore a suite of tools for your classroom with Google Workspace for Education

You're now viewing content for a different region..

For content more relevant to your region, we suggest:

Sign up here for updates, insights, resources, and more.

Cloud Storage

Custom Business Email

Video and voice conferencing

Shared Calendars

Word Processing

Spreadsheets

Presentation Builder

Survey builder

Google Workspace

An integrated suit of secure, cloud-native collaboration and productivity apps powered by Google AI.

Make data-driven decisions, in Google Sheets

Create and collaborate on online spreadsheets in real-time and from any device.

• For my personal use
• For work or my business

T h e s e   n u m b e r s   l o o k   v e r y   s t r o n g !

Collaborate on data, from anywhere

Establish a ground truth for data in your online spreadsheet, with easy sharing and real-time editing. Use comments and assign action items to keep analysis flowing.

Get to insights faster with built-in intelligence

Assistive features like Smart Fill and formula suggestions help you analyze faster with fewer errors. And get insights quickly by asking questions about your data in simple language.

Seamlessly connect to other Google apps

Sheets is thoughtfully connected to other Google apps you love, saving you time. Easily analyze Google Forms data in Sheets, or embed Sheets charts in Google Slides and Docs. You can also reply to comments directly from Gmail and easily present your spreadsheets to Google Meet.

Extend collaboration and intelligence to Excel files

Easily edit Microsoft Excel spreadsheets online without converting them, and layer on Sheets’ enhanced collaborative and assistive features like comments, action items, and Smart Fill.

Build custom solutions

Speed up workflows by building business apps and automations. Use AppSheet to build custom applications on top of Sheets, without writing code. Or add custom functions, menu items, and macros with Apps Script.

Always work with fresh data

With Sheets, everyone’s always working on the latest version of a spreadsheet. And with edits automatically saved in version history, it’s easy to undo changes or even see edit history of an individual spreadsheet cell.

Seamlessly connect to critical data

Pull in and analyze data from the other tools you use, like customer data from Salesforce. Enterprise customers can also use Connected Sheets to analyze billions of rows of BigQuery data in Sheets – without writing any code.

Security, compliance, and privacy

Secure by default

We use industry-leading security measures to keep your data safe, including advanced malware protections. Sheets is also cloud-native, eliminating the need for local files and minimizing risk to your devices.

Encryption in transit and at rest

All files uploaded to Google Drive or created in Sheets are encrypted in transit and at rest.

Compliance to support regulatory requirements

Our products, including Sheets, regularly undergo independent verification of their security, privacy, and compliance controls .

Private by design

Sheets adheres to the same robust privacy commitments and data protections as the rest of Google Cloud’s enterprise services .

You control your data.

We never use your sheets content for ad purposes., we never sell your personal information to third parties., find the plan that’s right for you, google sheets is a part of google workspace.

Every plan includes

Collaborate from anywhere, on any device

Access, create, and edit your spreadsheets wherever you are — from any mobile device, tablet, or computer — even when offline.

Get a head start with templates

Choose from a variety of dashboards, project trackers, and other professionally-designed templates to kick things off quickly..

Visit the Sheets Template Gallery for more.

Ready to get started?

Teacher to reunite with over 100 students almost 50 years after making solar eclipse promise

A science teacher is set to come out of retirement today and deliver on a 46-year-old solar eclipse promise to his former students.

Patrick Moriarty, who taught Webster Central School District in New York, was handing out worksheets about solar eclipses to his Year 10 students in 1978 when he noticed one of them was due in their area. The teacher promised the 14-year-olds to mark the date as he would deliver a lesson to them when the time came around.

“So I had this sheet of about 50 eclipses that were coming up from like 1974 until 2030,” Mr Moriarty said. “And one of them was going to happen right here in this area on April 8, 2024. So I turned to the kids and I said, ‘All right, circle that eclipse on April 8th, 2024.’”

READ MORE: Solar eclipse 2024 LIVE: Time rare event visible to MILLIONS will happen across North America

For the next 16 years, he promised he would deliver on that promise despite the 14-year-olds not believing he would come through with his pledge. “We're going to meet on that day,” Moriarty told Spectrum News . “And they looked at me like I was crazy because they were only 14 years old.”

Former students including Andrea Rock, who was taught by Mr Moriarty in 1998, said he stayed in touch with students and promised he would deliver the lesson once the solar eclipse arrived. “Mr. Moriarity was my teacher in 1988,” a former student at Schroeder High School Ms Rock said.

“And I was like ‘Oh yeah okay.’ Years later he ended up being my 10th grade basketball coach. We were in similar professions. I'm an administrator. He was an administrator. And so our paths had crossed professionally, you know, here and there. So we've sort of stayed in touch then through Facebook .”

Nearly 50 years later, Mr Moriarty kept his promise and is preparing to welcome over 100 of his former students, colleagues, and family to the area. He shared: "It's not about the eclipse any more. It's about people and the sharing and the impact of teachers, the impact of teachers and what teachers can mean to students even when they're 60 years old and they can think back to when they were in junior high.”

The students are delighted to be able to reconnect with their former teacher, according to an ex-student at Spry Junior High Kevin Thompson. “He's keeping his word,” Mr Thompson said. “One of my buddies from class, we're still good friends and it's something I wondered if we're going to do that, that's getting closer, that type of thing.

“I am going to look so forward to hearing Mr. Moriarty teach the lesson that we've waited 40 years to get the experience of,” Thompson added. “Many teachers don't get to experience what he's been experiencing the last couple of years through Facebook and now in-person students sharing what he meant to them in their lives. And it's awesome because teachers don't get to hear that enough.”