Use Google Sheets Protect Range to Guide Students

I’m developing a new Google Sheets interactive lesson to use with my students. One of the potential issues I for-see  is students typing on another student’s sheet. This got my brain rolling and the solution I came up with was to use the Protect Range tool. When you protect a cell or column ranges only the user selected can edit the area. The Google Spreadsheet is shared at once to a group with each sheet having different editing rights. Individual student’s names will appear on the tab for each sheet. One sheet per student. This will help guide the students to the sheet where they have editing rights.

HOW TO PROTECT RANGE

  • Click column letters
    • Column becomes highlighted
    • Drop down list occurs
    • Click protect range

Untitled drawing-11

  • Click set permissions

Untitled drawing-12

  • Range editing permission window opens
    • Click who can edit this range
    • Click only you to access the editing dropdown list
    • Click Done

Untitled drawing-13

  • Add E-mail Addresses

Untitled drawing-14

  • Click done and a save window opens ending the process
Advertisements

Creating Interactive Vocabulary Activity Using Google Sheets

Today I’m going to share how the word bank activity was created in the “Using Google Sheets to Create Vocabulary Activity Post” .  This activity can be taken one step further by adding  the badge component for “Gamification” into the classroom. Badges can be a motivator for middle school students who are into playing virtual on-line games where they earn visual trinkets to advance. However the concept for earning badges and gamification will have to wait for another blogging moment! In the meantime read this post by Alice Keeler about “Badges and Intrinsic Motivation” to learn more!
Vocabulary Google sheet activity

STEPS FOR CHANGING the THINKING SMILEY EMOTICON TO A HAPPY FACEScreen Shot 2015-10-25 at 11.09.58 AM

  • STEP ONE:
    • Create the question and answer layout with a word bank on a Google Sheet
  • Screen Shot 2015-10-25 at 11.09.35 AM
  • STEP TWO:
    • Insert code “If Logical Expression function”
    • This changes the Thinker emoticon to a Happy Face
      • when the correct answer is typed into yellow cell

Screen Shot 2015-10-25 at 11.11.04 AMScreen Shot 2015-10-25 at 11.10.37 AM

  • STEP THREE:
    • Protect the columns range which displays the function
      • This will allow only you and editor collaborators to make changes
      • Protecting a range prevents students from accidentally change the function

Group Work is Easy with Google Slides!

Slides Import

IMPORT SLIDES INTO GOOGLE SLIDE PRESENTATION

It was interesting to watch 6th grade students collaborate on a group project. Even after being told the rules about working on their own slide they couldn’t help but mess around with a classmates slide. This is when I realized the practicality of Google slides Import slide feature.

Ones immediate reaction may be, “But Oh! This will take time!” Really it doesn’t when you think about the time saved with correcting slides because a friend moved things around without permission. Another plus is creating a less stressing project environment for everyone involved. Teacher doesn’t become tense over student not adhering to the rules. No need for students getting upset by classmates messing around with their slides.

STEPS TO IMPORT GOOGLE SLIDE INTO A PRESENTATION

  • In Google Slide Click on File
    • Click on import slides in the drop down list

Untitled drawing-6

  • Pick the file and click
    • Then Click Select

Untitled drawing-7

  • Choose the presentation slide
    • Click import slide

Untitled drawing-9

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

Creating Flashcards Using Flippity.net Google Sheet Template

Today during an Ed Tech Professional Development workshop I created a Flippity.net flashcard. You wouldn’t believe how simple this was to do using a Google Sheet Template supplied by the Flippity Website. This is what the flashcards looked like once published to the internet.

Screen Shot 2015-10-20 at 5.48.39 PM

I like how Flippity.net provides several different tools once the vocabulary list is published to the internet.

LIST SETTING

This view provides a listing of the vocabulary words along with the definition

Screen Shot 2015-10-20 at 5.48.57 PM

PRINT QUIZ

Print quiz option creates assessments from the vocabulary information entered into a Google Spreadsheet

Screen Shot 2015-10-20 at 5.49.12 PM

HOW TO CREATE FLIPPITY FLASHCARDS

flippy copy template

  • Edit the Flippity Google Spreadsheet

flippy edit

  • Publish Spreadsheet to the web ~ copy the link
  • Paste the link into the second sheet of the spreadsheet

Flippity step 1 2

  • A link for the Flippity Flashcards will be generated for sharing

Flippity link

Transform Google Notes Into Interactive

I’m a K-12 Teaching Assistant assigned to Middle School. My position pushes me into several content areas to support students. One of the expectations of my position is to supply supplemental notes for the students. I use Google Drive to share my notes via content area folders with my Special Education Teacher Partners. This delivers the notes synchronously to my partner.

This year I discovered it is easiest to use a Google Slide to share notes. I use one presentation for each new month. If my notes contain 8.5″ x 11″ worksheets then I link out to another Google slide presentation with a page setup for this dimension. My main Google Note sharing presentation uses the custom page setup of 11″ by 8.5″ This makes it possible for my Teacher Partners to print a page if needed. Sometimes the landscape style notes can be easily converted into a study interactive the teachers can use with students during resource room, study hall or etc…

HERE IS AN EXAMPLE OF NOTES TURNED INTO AN INTERACTIVE

Easy Manipulative

Please click here if you would like the template

 It is easy as pie to convert your notes into a manipulative by pulling the answers off to the side of the layout area.