You are here: 

Dr. Christie's Workshops: Google Tools for Schools Part

Google Tools
Dr. Christie's Powerpoint Presentation (PDF Format)

Link

The Four C's of Technology Integration: Pillars of Digital-Age Learning

4 Cs

 

 

 

Create and Communicate with Blogger

 

Blogger

Link to Blogger

 

Class Assignments, Documents, Study Guides

Create and Communicate with Gmail

 

gmail



Link to Gmail

 

Contextualize with iGoogle

 

iGoogle

 

 

 

 

 

 

 

Link to iGoogle

Collaborate with Google Docs

 

gdocs

Link to Google Docs

 

 

 

Presentation Examples:

Working with Google Calendar

Moving from Good to Great

Word Processing Examples:

Planning a Conference

Assignment: Instructional Technology Inventory

Spreadsheet Examples:

Brainstorming

Planning an Un-Conference

Mapping Gadget

Categorizing Exercise

 

Create and Contextualize with Picasa

picasa

Link to Picasa

 

 

Examples:

Class Trip

Virtual Trip to Woodland Park Zoo

Cassie Herd’s Classroom

Student Work Showcase

Students at Work

Science Lab Showcase

Musical Instruments (Independent Learning)

Visual Concept: Yellow roads to SLO

Extending Learning with Graphics: Physics

 

Google Lookup in Google Spreadsheets

 

lookup

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Google LookUp can do quick serarches for straightforward facts about specific things.
Some examples include:

Countries and U.S. States

Rivers

Cities and Towns

Musicians and Actors

Politicians

U.S. Presidents

Baseball Players

Chemical Elements

Chemical Compounds

Stars and Planets

Dinosaurs

Ships

Companies

Examples from the ISTE Webinar:

Books Illustrated by Eric Carle

US Presidents

Country Populations, Language, and Area

Syntax for Searching with Entity and Attribute
Already Entered into Spreadsheet

=GoogleLookup(entity, attribute)

"entity" is specified in Column A (books)

"attribute" is specified in rows (publication date)

=GoogleLookup(A3,$B$1)

 

Syntax for Searching for an UnknownEntity and Attribute

GoogleLookup("entity”; "attribute")

"entity" is the name of the entity that you want to access (Oxygen)

"attribute" is the type of information that you want to retrieve (Atomic Weight) =GoogleLookup(“oxygen”; “atomic weight”)

Google Search

search

Link to Google Search

 

Features Discussed in ISTE Webinar

Safe Search

Advanced Search

Advanced Search: Reading Level

Wonder Wheel Search

Related Searches

Google Search Timeline

Recent Searches

Google News

Google Alerts

Google Images – Advanced Search

search

Similar Images

Google News Timeline

Google Books

Google Translate

Google Trends

Google Supports Education

Google for Educators

Google Apps for Education

Google Apps Education Community

 

Google Teacher Academy

Google Certified Teachers

Other Google Resources

Google Toys for Your Classroom

Amazing Things You Can Do with Google Docs

Pima County, AZ Google Tools Ideas

E-Learning for Educators Online Course

BGHS Professional Development Wiki

Top 10 Reasons to use Google Apps Education

Google for Educators: Google Docs

Google for Educators Discussion Group

20 Google Doc Templates for use in Science/Math Classrooms

Google Apps Education Community