Reordering Sheets…

Today I was asked how to reorder sheets from within a Google Spreadsheet. Google Spreadsheets is one of my favorite collaboration tools. It provides the capabilities for assigning different sheets to individual students or a collaborative group. Sheets can become out of order when collaborators use one spreadsheet. No worries! It is easy to drag the sheet into an alpha or numerical order. Just click down on the sheets tab and drag to the right or left to reorder sheets.

Reorder Sheets in a Spreadsheet - drag to the left or right

Research Projects Made Easier…

When it comes to research projects why should students struggle due to reading levels of resources found on the internet? What would teachers say if a search engine could be focused upon research content appropriate for younger students and lower readers? It is my belief these tools benefit students with becoming independent learners. When children feel successful with completing tasks they start to internalize the value of “Research”. Once students understand the value of research it is easier to build and introduce more advanced search skills. Next time one plans a research project why not set the students up for success by sharing a search engine scaffold to their needs.

How to Create a Custom Google Search Engine

Screen Shot 2017-12-31 at 1.37.36 PM

Screen Shot 2017-12-31 at 1.43.48 PM.png

  • Click Create a custom search engine or New search engine

New search engine

  • In Sites to search box, type the sites you want to include for the search results
  • In Name Search Engine Box,  type the name for the new search engine
  • Finish by Clicking the Blue Create Button

Type Website URL

  • Copy embed code or public link for sharing

NOTE: Embed Code will allow you to place the search box on your website or in a blog.

 

Using Sites for More than a Classroom Newsletter

Screen Shot 2017-07-15 at 6.40.14 AM

Earlier this summer I started creating a workshop entitled “Using Sites for More than a Classroom Newsletter”.  While preparing for this workshop I realized the New Google Sites was more than the average website builder. When first starting to build with the New Google Sites I missed the flexibility of selecting my own fonts and embedding gadgets and etc… via html. Now I’m thankful for the new site builder! Once I started constructing the workshop prezo as a Google Site the potentials for using the new site builder dawned on me! I discovered the New Google Sites is more than the average website builder!

One of the first things I noticed was the share settings and the ability to add collaborators. Immediately I started exploring different projects based on collaboration. Using the new sites started to become a challenge for me to discover more exciting features and a variety of uses for the educational community. Yes! I did exactly this and discovered the New Google Sites was not only intuitive to use but a tool which offers a vast amount of usages. When one considers the integration of all the core Google for Education APPs along with the New Google Sites it delivers one powerful punch as an educational tool!

 Some Google Sites Ideas

  1. Share a Digital Break Out Edu Adventure with Students
    • Use critical thinking skills to solve the mystery
  2. Use to deliver daily objectives
    • Supports students with doing independent work
  3. Share a Community Ice Breaker
    • Strengthens communication
  4. Go Paperless Create an Anchor Chart Site
    • Provides students with 24/7 resources
  5. Student Created Collaborative Weekly or Monthly Newsletter
    • Supports collaboration, and communication
  6. Classroom Created Collaborative Notes
    • Created & Curated via Sites
    • Immediate scaffolding for students
      • Students understand other students explainations
    • Let students have fun with this!
      • Insert videos
      • Insert audio links
      • Share interactive websites
  7. Student Portfolios
    • Building Digital Resumes Practice
    • Reinforces Digital Citizenship Skills
  8. Share Infographic Projects
    • One page per student
      • Student builds info graphic by using sites
  9. Use as a Student built Wiki
    • Students share tech support
    • Share Math Problem Solving ideas
  10. Curate Student Artwork, Poetry and etc…
  11. and ?
    • Share your idea in the comment area
      • It just may be added to this list 😃

Teachers Helping Teachers

Students Build with Chrome~Oh! Yeah!!!

Looking for an easy way to engage students in math, social studies, science or perhaps ELA? Why not release the students creative and critical thinking skills juices with  “Build with Chrome” ?  This can start in the early years with something simple like asking the student to create a rectangle. Then discussing as a group what makes rectangles different from other shapes.

Screen Shot 2016-07-09 at 1.35.56 PM.png

A screen capture is taken of the creation and inserted into a Google Drawings, Slides or ? Once the image is inserted into a Google Doc the student can write a question along with the answer.

Screen Shot 2016-07-09 at 1.59.32 PM.png

Why not provide a challenge for the student and ask them if they can create a building seen in Egypt? Let them know a second screenshot will be taken. However this time they have to write sharing factual information about the building they created.

Screen Shot 2016-07-09 at 2.21.49 PM.png

The beauty of this idea is the teacher can take it to many different learning levels and use in a variety of content areas.

NOTE: Real life hand-on building items can be used in this project. It is absolutely fine to use a digital photo of classroom projects. Teacher doesn’t have to re-invent the wheel. Smartphones or Tablets are awesome “Tech Tools” for capturing images.

How would you use this to support learning in your classroom?

Please share your ideas in the comment area

THANKS!

Hidden Goodie: Google Doc Outline

Recently an outline appeared magically on the left hand side of a Google Doc I was creating. I’m finding this more useful then a table of contents especially while doing research. The outline allows the user to easily find topics within a Google Doc by simply clicking on the topic within the generated list.  When clicked the doc locates and jumps to the section. If a doc is created by using headings it generates a logical outline. This speeds up finding the information listed in one’s research project.

Creating Google Doc Outline

  1. Click on Help
  2. Type Outline
  3. Outline Window
    • Opens to the left side of Doc

Google Doc Open Outline.gif