Consolidate Assignments by Using Google Sheets

Are you creating beautiful daily lesson plans for students using Google Slides? Are your assignments posted into Google Classroom along with links, tasks, and templates and followed with a detailed checklist created in Docs? I’m sure you spent a lot of time creating these resources! But, are we creating too MANY resources and links for our students?

Last week, I watched my 10 year old son attempt to complete all his assignments in Google Classroom. My son is relatively tech-savvy and loves working digitally, but he was LOST. There were too many links, too many Classroom topics, and too many places to “go”. In fact, I had difficulty helping him locate some of the resources!

The Problem

Sometimes less is more. Creating multiple resources, Classroom topics, links, and Docs to help our students stay organized could possibly be counter-productive especially while helping our youngest learners. Could we be making it even more challenging for students to locate and access assignments by providing too many guiding Docs?

To streamline resources in Google Classroom many edtech gurus have recommended:

1. Classroom Topics named “Today’s Links”: If you name a Google Classroom topic “Today’s Links” students will know where to find all the materials for that day! Teachers may choose to move the links under the correct subject Topic headings later.

2. Numbering Assignments: Numbering assignments makes it easy to refer to an assignment later. Also, students may be able to recall which number assignment they should work on today.

But, once you add on all the amazing Google Slides daily/weekly learning plans and Google Docs checklists it may still get a little confusing.

How could we simplify our assignments and make it easier for students?

The first solution that came to me is Google Sheets!

Google Sheets allows you to create a “one-stop-shop” for objectives, tasks, checklists, links, and more!

This daily lesson template for students allows you to add all your assignments along with a checklist for each task. Template available TinyUrl.com/SheetsRemotePlans

Template available TinyUrl.com/SheetsRemotePlans

Also, you can link to the specific Google Classroom Assignment in the Sheet by clicking on the 3 dots in the right-hand corner of the assignment while in Google Classroom. Then, add that link to the template.

Click the 3 dots and select “Copy-Link”

Finally, you may add a checkbox for students to complete once they have “Turned-In” each assignment.

Duplicate the template by clicking on the TAB below and selecting “dupicate”. You may rename each TAB using dates.

Duplicate Tabs by right clicking and selecting “duplicate”.

How do you streamline your assignments?

Snap Camera! Engage Students During a Virtual Meet

What is Snap Camera?

Snap Camera is a FREE application that allows you to use different lenses on your computer while recording videos, taking photographs or participating in video chats using Google Meet, Zoom or Skype. There are thousands of lenses or filters to choose from including the traditional Snapchat filters as well as designs from Lens Creator.

Could SnapCamera be used for educational purposes? Absolutely! There are so many ways educators could use this app with students. However, this app may not be appropriate for younger students to use as it is intended for an older audience.

Here are some ideas:

  1. Reading– Locate a filter and appear as a character from a favorite book. Or, use a background that relates to the setting in the story you are reading.

2. Math– Appear as a chef using recipes for a lesson on fractions. Or, pick a fun math themed background!

3. Science– Use an animal filter during a discussion about animal adaptations or teach a lesson straight from a science lab!

4. Social Studies– It’s easy to travel around the world using Snap Camera! Teach a lesson in front of a pyramid or turn yourself into a pilgrim while discussing Plimoth Plantation!

How does Snap Camera work?

  • Install the app: Go to https://snapcamera.snapchat.com and download the FREE app.
  • Open the app: Open the app on the computer and search through all the different lenses.
  • Locate the lense you want to use: Play around with all the different filters until you find one you like.
  • Take a picture or video: You may record your videos or take photographs with Snap Camera and then download to your device. Then, simply upload the video or photographs to the platform you are using with students.
  • Open video conferencing platform: If you are using this filter during synchronous instruction you can open up Google Meet and the filter will now be on your camera!
  • Have fun! Once you see the possibilities of using Snap Camera in the classroom you will have a lot of fun.

Do you have any ideas how educators could use Snap Camera with their students? Feel free to comment below.

EdTech Companies Offering FREE Subscriptions During School Closures

Wakelet Collection

Educational technology companies from around the world are currently offering access to their premium subscriptions during the COVID-19 pandemic. Here is a Wakelet collection of offerings curated from Twitter. Please note: I have not spent time determining the quality of these resources. As always , remember to check the Terms of Service and Private Policies and review what is permitted for use within your district.

The Wakelet includes a growing list of edtech companies including:


Scholastic’s Learn at Home

StoryOnline

Prodigy- Math Games

DeckToys

Mystery Science

Zearn

BrainPOP

Buncee

Screencastify

SpellingCity

NewsELA

Seterra Geography

Zoom

Sibme

Pebble Go

Adventure 2 Learning

Slidio for Education

Go Guardian

Actively Learn

EverFi

Storyboard That:

NearPod

Minecraft EDU

Kami

Parlay Ideas

Sutori

Elementari

EdPuzzle

WeVideo

Discovery Education

Kahoot

Pronto

BookCreator

Tynker

Consider limited the number of tools you use with students to as few as possible. And, remember, protecting student data is also the priority so make sure to read the fine print and check with your educational leaders if unsure.

Go Digital with Morning Meeting Walls

Coaching Question: Is there a way to digitalize my Morning Meeting wall so I that I may save wall space?

Yes!

Many elementary school teachers are familiarizing themselves with the Responsive Classroom approach and using a Morning Meeting to start the day. The Morning Meeting is a great way to start the day, engage students and promote a sense of community within your classroom. However, the Morning Meeting bulletin board can take up a lot of space leaving little room for student work, instructional materials or anchor charts!

Example Morning Meeting Bulletin Board:

MM.png

The Solution: Go Digital

If you have a projector then definitely go digital! By having a digital Morning Meeting wall, you are not only saving space but you also allowing students to:

  1. Collaborate by adding questions
  2. Archive information to review as the year progresses
  3. Read teacher posts (and of course Bitmojis)
  4. Edit/Revise questions for the meeting
  5. Publish learning
  6. Share with parents, co-teachers, administrators, and collaborators

Plus, you don’t need to have the Morning Meeting wall projected on your whiteboard all day. Bookmark the digital Morning Meeting wall and pull it up on your whiteboard as needed throughout the day. And, share the wall with students via Google Classroom, Seesaw, e-mail etc. to have the reflect, comment, or collaborate on the digital bulletin board.

Example (Click to View)

Can you find the interactive links in this Morning Meeting Wall? (Click the image)

morning meeting wall

Need more ideas?

If you’d like more ideas for your Morning Meeting wall, check out this link with ideas for the K-2 and 3-6 classrooms.

Do you use a wall for your Morning Meeting?

 

 

 

 

Digital Morning Meeting Walls

Many elementary school teachers are familiarizing themselves with the Responsive Classroom approach and starting each day with a classroom “Morning Meeting”. The Morning Meeting is a great way to start the day, engage students and promote a sense of community within your classroom. However, a Morning Meeting wall can take up a lot of space leaving little room for student work, instructional materials or anchor charts.

Example Morning Meeting Bulletin Board:

MM.png

The Solution: Go Digital

If you have a projector then definitely go digital! By having a digital Morning Meeting wall, you are not only saving space but you also allowing students to:

  1. Collaborate by adding questions
  2. Archive information to review as the year progresses
  3. Read teacher posts (and of course Bitmojis)
  4. Edit/Revise questions for the meeting
  5. Publish learning
  6. Share with parents, co-teachers, administrators, and collaborators

Bookmark the digital Morning Meeting wall and pull it up on your whiteboard as needed throughout the day. And, share the wall with students via Google Classroom, Seesaw, e-mail etc. to have the reflect, comment, or collaborate on the digital bulletin board.

Example Google Slides Morning Meeting Wall

Many teachers feel Google Slides would be the best tool for creating a Morning Meeting Wall as you may copy and paste the wall onto a new slide, and share walls with teachers and parents in Google Classroom. And, you get your wall space back!

Template for Editing

https://docs.google.com/presentation/d/1yZAKKoQdbL2ohFMmz6zXYVBNhlrvDptgsh3fTkQKQsc/template/preview

Have you gone digital with your Morning Meeting wall?