Google Sheets Horizontal Merge

Did you know it is really easy to do a horizontal merge for multiple columns in a Google Sheet? All you have to do is highlight the columns then click the merge tool and pick horizontal merge.  This merges the cells together from row 1 to 1000 at one time! I just love timesaving tips!

Merge Horizontal  Columns.gif

 

Advertisements

Protecting Google Sheet Range

This week we rolled out the book sign out Google Sheet to the students. One big “Opps” I made is forgetting to protect the range in the cells which contained the functions. When the Google Sheet owner protects the range it prevents others from accidentally deleting or corrupting cell functions.

Here is an example

  • Type  Function into column E Cell 2:
    • = Sum (Col letter:Row number, Col letter)
      • into Cell
  • This will total numbers in column C

sum (1)

Example of =sum function in action

Sum.gif

How to PROTECT RANGE

  • Right Click Cell
  • Click Protect Range

sum 2.png

  • Click SET PERMISSIONS

sum 3.png

  • Click Restrict who can edit this
  • Choose Only You
  • Finish by Clicking Done!

sum 4

Now the Cell Is Protected and It Is Impossible for Students to Make Changes

 

 

 

 

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

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

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