Using Google Sheets to Create Vocabulary Activity

I developed an idea using spreadsheets in conjunction with the Flippity Flashcards mentioned in my prior post. Students will start the lesson by using the Flippity Flashcards to practice the vocabulary words. Afterwards students will have the opportunity to practice the vocabulary words using an interactive spreadsheet question & answer bank. When the answer is correct the thinking smiley face will change to a smiley face.

SAMPLE of GOOGLE SHEETS VOCABULARY ACTIVITY

Use this link to copy as a template

Vocabulary Google sheet activity

Why Use A Vocabulary Activity Made with Google Sheets

  1. Provides students with multiple ways to learn the vocabulary
  2. Can be used as an assessment
    1. Student will logon with their own Gmail name
    2. Teacher can assess student’s activity by using the revision history
  3. Provides multiple opportunities for student to achieve 100% Success
    1. Student can refer back to Flipplity Flashcards to find the answer
    2. Student keeps trying different answers from the word bank until smiley face appears
  4. Students can use independently to learn vocabulary
  5. Teacher can use the activity with the classroom
    1. Get students out of their seats to flip and read the vocabulary flashcards out loud
    2. Have students to come up to an interactive whiteboard to type the answers

Post will follow soon with instruction on how to create your own Google Spreadsheet Vocabulary Activity

Teachers Why Not Automate Classroom Book Sign Out?

This week I was amazed to see how long it took the students to sign out books using index cards. The students filled out cards with a book title and the date then filed them alphabetically into a file box. The process seemed to take forever. Immediately I thought why not use Google Sheets on more than one computer to speed up the task?

The classroom book sign out sheet saves time for the teacher as well! It is easier to click through the sheets versus thumbing through a stack of index cards. This is an easier process to help keep the teacher updated with what the students are reading. It also makes keeping track of classroom books a little bit easier due to the information being right at the “Tip of one’s fingers!”

The below video shows how the Google Sheets Classroom Book Sign Out works.

Click Here for A COPY OF THE TEMPLATE

OR

CLICK HERE TO TRY THE TEMPLATE

This is what the template looks like

Hyperdoc Story Creator Using Google Docs!

Can you believe I never knew digital education interactives were called Hyperdocs? Apparently a Hyperdoc is the official name of a digital interactive created by using Google APPS for Education. So what is a Hyperdoc? A Hyperdoc is a Google Doc which contains information and directions delivered by using data objects. The data objects are presented by hyperlinks to context outside of the Google Doc. This provides the student with independent time to explore a new topic. Here is an example of a “Story Creator” Hyperdoc.

CLICK HERE TO COPY TEMPLATE

Why use a Hyperdoc in the classroom?

  1. Supports the students with independently following directions.
  2. Saves time by limiting the amount of times a teacher as to repeat questions.
  3. Can provide opportunities of exploration as students learn a topic.
  4. Provides the quiet student with a voice.
  5. Differentiates activity so all students can participate.
  6. Teachers have the opportunity to synchronously check student’s work and make sure they’re following guidelines.
  7. Teachers can access the revision history to help evaluate the content.
  8. Provides extra opportunities for supporting the struggling student.
  9. Creates opportunities  for guiding the excelled student towards more challenging material.
  10. Collects assessment data instantly.

How do you check the revision history?

  • Click Revision History

Revision history 1

  • A window pane opens with the revision History on the righthand side of document

Revision History 2-2

  • Click on more detailed revisions

Revision History 3

  • A more detailed list of revisions will open

Screen Shot 2015-08-10 at 7.18.07 PM

UPCOMING POSTS: 

  • Using Google Drawing to Create an Interactive Graphic Organizer
  • Tutorial for Creating the Story Creator Hyperdoc

Google sheets can be a valuable tool for Maintaining Student’s Agendas

Here is a list of some reasons why I feel a Google Sheet Agenda is Practical for Students and Teachers to use.
  1. Sheets can be embed into a webpage (it automatically updates with every change)
  2. It can be published as a webpage (w/Auto Updates)
  3. Double click the date column and a calendar pops up. Then double click the date to see what happens (TIMESAVER for Some Students). Just might be a motivator for the young person who likes using gadgets.
  4. Positive reinforcement for maintaining schedules. Due to my K-12 Experience I noticed many students are challenged with using hardcopy agendas to maintain their schedules. This is an important organizational skill for the child’s future.
  5. Add a speech to text APP and the student may accomplish a task they avoided in the past.
  6. The agenda can be modified for the younger student.
  7. Graphics can be added to support the visual learner.

Creating Games Using Google Drawing

Google APPS for Education (GAFE) offers several APPS which can be used to create interactive activities.  One of the APPS I like is Google Drawing.  It is easy to create and once you have a finished activity the pieces can be moved! This is a valuable Ed Tech tool for the teacher and student alike.

  • Teacher creates interactive lesson plans
  • Students interact with lesson plan
  • Student creates an interactive activity
  • Student works in pairs using the activity

This is the steps I use to create a Game using Google Drawing:

  • Open Google Drawing in My Drive

Open Google Drawing

  • Give the drawing a name
  • Select a page size

Select Page Size

  • Create the background
  • Make the game pieces

Creating Game Pieces

  • Click Link Sharing for On-Public on the Web and Check Can Edit

Screen Shot 2015-07-12 at 6.21.51 PM

  • Have fun playing the game!

CLICK HERE TO DOWNLOAD THE GAME You will need a GOOGLE Account to Download.