Click Here
Friday, October 12, 2007
Thursday, October 11, 2007
Help with Google Lookup
Here are a couple examples using the formula:
To insert the number of Internet users in Paraguay:=GoogleLookup("Paraguay"; "internet users")
To insert the Earned Run Average of Roger Clemens:=GoogleLookup("Roger Clemens";"earned run average")
Note: In order for the formula to compute properly, quotation marks must be used around both the "entity" and the "attribute."
Some of the entities and attributes you can use
Here are some of the types of entities you can access using GoogleLookup, and a few popular attribute names (some entities won't have all these attributes, and some will have more, so feel free to experiment):
Countries and Territories (like "Burkina Faso"): population, capital, largest city, gdp
U.S. States (like "Tennessee"): area, governor, nickname, flower
Rivers (like "Amazon River"): origin, length
Cities and Towns (like "Chicago"): state, mayor, elevation
Musicians (like "John Lennon"): date of birth, place of birth, nationality
Actors (like "Audrey Hepburn"): date of birth, place of birth, nationality
Politicians (like "Anwar Al-Sadat"): date of birth, place of birth, nationality
U.S. Presidents (like "Zachary Taylor"): date of birth, place of birth, political party
Baseball Players (like "Wade Boggs"): games, at bats, earned run average, position
Chemical Elements (like "Helium"): atomic number, discovered by, atomic weight
Chemical Compounds (like "Isopropyl Alcohol"): chemical formula, melting point, boiling point, density
Stars (like "Betelgeuse"): constellation, distance, mass, temperature
Planets (like "Saturn"): number of moons, length of day, distance from sun, atmosphere
Dinosaurs (like "Velociraptor"): height, weight, when it lived
Ships (like "USS Chesapeake"): length, displacement, complement, commissioned
Companies (like "Hewlett-Packard"): employees, ceo, ticker
The information listed above was taken from:
http://docs.google.com/support/spreadsheets/bin/answer.py?answer=54199
To insert the number of Internet users in Paraguay:=GoogleLookup("Paraguay"; "internet users")
To insert the Earned Run Average of Roger Clemens:=GoogleLookup("Roger Clemens";"earned run average")
Note: In order for the formula to compute properly, quotation marks must be used around both the "entity" and the "attribute."
Some of the entities and attributes you can use
Here are some of the types of entities you can access using GoogleLookup, and a few popular attribute names (some entities won't have all these attributes, and some will have more, so feel free to experiment):
Countries and Territories (like "Burkina Faso"): population, capital, largest city, gdp
U.S. States (like "Tennessee"): area, governor, nickname, flower
Rivers (like "Amazon River"): origin, length
Cities and Towns (like "Chicago"): state, mayor, elevation
Musicians (like "John Lennon"): date of birth, place of birth, nationality
Actors (like "Audrey Hepburn"): date of birth, place of birth, nationality
Politicians (like "Anwar Al-Sadat"): date of birth, place of birth, nationality
U.S. Presidents (like "Zachary Taylor"): date of birth, place of birth, political party
Baseball Players (like "Wade Boggs"): games, at bats, earned run average, position
Chemical Elements (like "Helium"): atomic number, discovered by, atomic weight
Chemical Compounds (like "Isopropyl Alcohol"): chemical formula, melting point, boiling point, density
Stars (like "Betelgeuse"): constellation, distance, mass, temperature
Planets (like "Saturn"): number of moons, length of day, distance from sun, atmosphere
Dinosaurs (like "Velociraptor"): height, weight, when it lived
Ships (like "USS Chesapeake"): length, displacement, complement, commissioned
Companies (like "Hewlett-Packard"): employees, ceo, ticker
The information listed above was taken from:
http://docs.google.com/support/spreadsheets/bin/answer.py?answer=54199
Thursday, October 4, 2007
Google for Educators Agenda
-Agenda-
Introductions
Icebreaker - Introduction to Google Earth
Signing up for a Google Account
Introduction to Google Docs
Creating a file with Google Docs
BREAK
Google Search
Using Google Docs to save, share, and publish documents
Share out
LUNCH (11:45-12:45)
Continuation of Google Docs
Using Google Spreadsheets to create a grade book
Using Google Spreadsheets with the GoogleLookup function
Share out
Survey/Evaluation
Thanks for participating!
Resources for Google for Educators
We have begun compiling resources for Google Apps that would apply to educators. If you find other resources, please feel free to add them in a comment.
The home page for Google is
http://www.google.com/
To sign up for a Google Account
http://www.google.com/a/help/intl/en/users/dands.html
To visit the Google Earth website and download the Google Earth Program.
http://earth.google.com/
* This is one of the only Apps that need to be downloaded. The rest are online tools.
Google Earth Help
http://earth.google.com/support/
Here are some resources to get you started using Google Earth.
Google Earth Home Page Google Earth combines the power of Google Search with satellite imagery, maps, terrain and 3D buildings to put the world's geographic information at your fingertips.
Juicy Geography’s Google Earth blog The aim of the blog is to publish lesson ideas, together with User Guides, and other materials for educators.
Juicy Geography was the first web site to publish original lesson materials incorporating Google Earth.
GE-Graph: Graph for GoogleEarth Make graph into GE to illustrate your presentations, papers, etc. GE-Graph was developed to generate graphs from files saved by Google Earth. The data can also be typed into the application or pasted from other applications. The file generated by GE-Graph can be exported to Google Earth
.Google Earth User's Guide With Google Earth, your computer becomes a window to anywhere on the planet, allowing you to view high-resolution aerial and satellite imagery, elevation terrain, road and street labels, business listings, and more. Learn about it in this user's guide.
Google Earth Blog Google Earth Blog is dedicated to sharing the best news, interesting sights, technology, and happenings for Google Earth. You will find the most amazing and interesting Google Earth files and network links you can download right off the site.
Weather and Storm Tracking Tools for Google Earth Google Earth Blog maintains a network link with some of the best weather tracking tools available.
Google Earth - More than a Toy We all know how to use Google Earth as a toy, but how do we use it as tool? We'll go through some of the most powerful, yet overlooked, features of this program, how people are using it, and hopefully, take you way out of this world.
Google Earth Education Community This community exists to offer a place where teachers and students can share and find information about educational topics organized using Google Earth software.
Staggeringly Great Things Mixing Media and Google Earth with Hall Davidson A lot of tools to explore integrating media into education--from iPod or Planet Earth!
Storybook Settings by Satellite: Google Earth for Language Arts & Reading Class By Mechelle M. De Craene
Google Lit Trips This site is an experiment in teaching great literature in a very different way. Using Google Earth, students discover where in the world the greatest road trip stories of all time took place... and so much more!
Google Earth Cathedral Lesson A lesson plan about cathedrals. The Keynote presentations the students produced were phenomenal and (of course) the students loved flying around to the different sacred sites on Google Earth.
----
Google Docs and Spreadsheets
1. Sign in to your Google Account
Go to http://www.google.com/ . Click on the sign-in button.
Under the try something new button click >>More
Click on Docs
This will add Docs to your log in screen.
or...
http://docs.google.com/
Google Spreadsheet Help
http://docs.google.com/support/spreadsheets/?hl=en
Google Lookup
http://documents.google.com/support/spreadsheets/bin/answer.py?answer=54199.
Google Docs Help
http://documents.google.com/support/
Google Search Help
http://www.google.com/educators/activities.html
Create a customized search engine
http://googlecustomsearch.blogspot.com/2007/09/better-search-results.html
Google Presentation Help
http://documents.google.com/support/presentations/
Google for Educators Newsgroup
http://www.google.com/educators/index.html
Google for Educators Discussion Group
http://groups.google.com/group/google-for-educators?lnk=gschg
Link to Lesson plans, Tutorials, Printables, and NECC Google Presentations
http://www.google.com/educators/activities.html
The home page for Google is
http://www.google.com/
To sign up for a Google Account
http://www.google.com/a/help/intl/en/users/dands.html
To visit the Google Earth website and download the Google Earth Program.
http://earth.google.com/
* This is one of the only Apps that need to be downloaded. The rest are online tools.
Google Earth Help
http://earth.google.com/support/
Here are some resources to get you started using Google Earth.
Google Earth Home Page Google Earth combines the power of Google Search with satellite imagery, maps, terrain and 3D buildings to put the world's geographic information at your fingertips.
Juicy Geography’s Google Earth blog The aim of the blog is to publish lesson ideas, together with User Guides, and other materials for educators.
Juicy Geography was the first web site to publish original lesson materials incorporating Google Earth.
GE-Graph: Graph for GoogleEarth Make graph into GE to illustrate your presentations, papers, etc. GE-Graph was developed to generate graphs from files saved by Google Earth. The data can also be typed into the application or pasted from other applications. The file generated by GE-Graph can be exported to Google Earth
.Google Earth User's Guide With Google Earth, your computer becomes a window to anywhere on the planet, allowing you to view high-resolution aerial and satellite imagery, elevation terrain, road and street labels, business listings, and more. Learn about it in this user's guide.
Google Earth Blog Google Earth Blog is dedicated to sharing the best news, interesting sights, technology, and happenings for Google Earth. You will find the most amazing and interesting Google Earth files and network links you can download right off the site.
Weather and Storm Tracking Tools for Google Earth Google Earth Blog maintains a network link with some of the best weather tracking tools available.
Google Earth - More than a Toy We all know how to use Google Earth as a toy, but how do we use it as tool? We'll go through some of the most powerful, yet overlooked, features of this program, how people are using it, and hopefully, take you way out of this world.
Google Earth Education Community This community exists to offer a place where teachers and students can share and find information about educational topics organized using Google Earth software.
Staggeringly Great Things Mixing Media and Google Earth with Hall Davidson A lot of tools to explore integrating media into education--from iPod or Planet Earth!
Storybook Settings by Satellite: Google Earth for Language Arts & Reading Class By Mechelle M. De Craene
Google Lit Trips This site is an experiment in teaching great literature in a very different way. Using Google Earth, students discover where in the world the greatest road trip stories of all time took place... and so much more!
Google Earth Cathedral Lesson A lesson plan about cathedrals. The Keynote presentations the students produced were phenomenal and (of course) the students loved flying around to the different sacred sites on Google Earth.
----
Google Docs and Spreadsheets
1. Sign in to your Google Account
Go to http://www.google.com/ . Click on the sign-in button.
Under the try something new button click >>More
Click on Docs
This will add Docs to your log in screen.
or...
http://docs.google.com/
Google Spreadsheet Help
http://docs.google.com/support/spreadsheets/?hl=en
Google Lookup
http://documents.google.com/support/spreadsheets/bin/answer.py?answer=54199.
Google Docs Help
http://documents.google.com/support/
Google Search Help
http://www.google.com/educators/activities.html
Create a customized search engine
http://googlecustomsearch.blogspot.com/2007/09/better-search-results.html
Google Presentation Help
http://documents.google.com/support/presentations/
Google for Educators Newsgroup
http://www.google.com/educators/index.html
Google for Educators Discussion Group
http://groups.google.com/group/google-for-educators?lnk=gschg
Link to Lesson plans, Tutorials, Printables, and NECC Google Presentations
http://www.google.com/educators/activities.html
Welcome to Google for Educators - Discussion
How have you been using Google Apps as an educator? What other Apps do you feel that would be useful, and you'd like to learn? For example, there is a Calendar that can be shared, there is Pages (free web page creator and web space), Presentation (A PowerPoint like program), Notes, and Google Earth.
Subscribe to:
Comments (Atom)