Specialized Google Research Tools That Are Powerful, Easy, and Free

Using Google Docs to Support Your PLC

Effective Professional Development (for Educational Technology)

Social, Global, and Green: Education in A Changing World

Formulas for Forms: Easy and Powerful Functions in Google Spreadsheets

Personal Learning Networks (PLNs) for Professional Learning Communities PLCs

Google Certified Teachers Share: What’s new from Google for Educators?

Knowledge is Freedom: CIPA, COPPA, and FERPA Explained Succinctly

NOTE: All but social global and green also submitted for CUE2011. Some slightly edited. Nothing new submitted...

Specialized Google Research Tools That Are Powerful, Easy, and Free

Discover tools that help educators and students access relevant information, locate timely research, and share meaningful resources. Learn powerful easy-to-use features of Google Books, Scholar, News, Blogsearch, Alerts and more.

Google Books makes the full text of the worlds greatest libraries searchable from any computer - and makes it possible to share relevant books with colleagues or students. Google Scholar provides meaningful access to scholarly research over time. Google News aggregates and filters thousands of news sources so the important information rises to the top, and Google Blogsearch helps make sense of the social web as it happens. This session focuses on the best strategies to put these tools (and others) to use in support of educators and students, including stragies for Professional Learning Communities (PLCs), Inquiry-Driven Learning, and Project Based Learning... as well as other more traditional applications, such as research papers. Online resources for the session include links to each tool, real-world examples, and screencasts illustrating key elements of the session for later reference.


Web Search

Search Features

Web Search Support

Search Options

Don't miss Latest, Wonderwheel, and Timeline!

Advanced Search

Don't miss File Type and Usage Rights.

Don't forget to learn the Google Operators like Define: and others.

Don't miss the Seach Features.

Complementary Tools

Creative Commons & Search

Book Search

Support including the History of Google Books and much more!

Search My Library

How to Access Full-Text Books (See also the new "Full View" option in the new left-side options!)

Download PDFs and Now Clips! Example: The Tragedie of Hamlet

Check out the 3D viewing option! (But, um, you need 3D glasses.)

Google has reached a groundbreaking agreement with authors and publishers.

My Library has custom bookshelves with public and private options. Learn more.

Even More...

Scholar Search


Don't miss the "cited by" feature!

New: Scholar Alerts!

News Search


About The Updates to Google News

Don't miss the Google News Archives! (Demo Video)

See also News Timeline and InQuotes from Google Labs.

Blog Search


Google Alerts

Multimedia Search (Time Permitting)

Image Search Support (See also Image Swirl, the new image search feature similar to Wonderwheel.)

Video Search Support (See also Audio Indexing from Google Labs)

More Search Tools for Educators

Google Squared: A new way to display search results

Language Search Tools (Time Permitting)

Tip: Enter your school's website to translate the site into Spanish... and then post a link to the translation on your site!

Custom Search Engine (Time Permitting)


Mrs. Gray's Research for Kids

Directing Learning with Google Custom Search by November Learning (PDF)

Screencast for Creating a Custom Search Engine

Even More...

Using Google Docs to Support Your PLC

Google Docs revolutionizes the way PLCs collaborate. Learn strategies for creating common assessments, sharing best practices, and capturing the conversation. Easily collect, analyze, and share school data. All for free.

Take your professional learning community to the next level by using Google Docs to collaborate with colleagues. Google Docs is an online office suite that allows you to create, edit, share, and publish documents, including spreadsheets and presentations. Because everything is stored and even modified on the web, Google Docs makes it easy to collaborate with colleagues - and even to edit the same document from multiple computers simultaneously. This session will focus on the use of Google Docs to promote and support collaboration within a PLC, including strategies for creating common assessments, sharing best practices, and capturing the conversation - even between meetings. Google Docs can even be used for data collection and analysis. This one tool can revolutionize the way your PLC collaborates. And it’s free.

Online resources for the session include links to each tool, real-world examples, and screencasts illustrating key elements of the session for later reference.


What is Google Docs?

Your best answer?

Google Docs Homepage

Google Docs for Educators

Overview for Educators (presentation)

Google Docs: The Basics

Google Docs: Tips and Tricks

Google Docs in Plain English (video)

Interactive Overview (with Links to Help Pages):

Documents (A few volunteers can join me in a new document.)

Presentations (A few volunteers can join me in a new presentation.)

Spreadsheets (A few volunteers can join me in a new spreadsheet.)

Forms (Everyone can complete a demo form - see below...)

NEW: Drawings are also included in Google Docs (but we won't cover these).

Google Docs Help Center (For getting started on your own...)

Here's the Core "Magic" (or what makes Google Docs better than a desktop office suite):

Web-Based (In The Cloud)

Sharing (and Sharing Folders)

Revision History


See Also: Getting to know Google Docs: The new version of Google documents

Demonstration Activity 1: How can Google Docs be used at your site or in your program?*

In a small group, create a document, presentation, or spreadsheet to illustrate your answer. Example answers include:

Using a document for shared notes, meeting minutes, resources, or lesson plans.

Using a presentation for shared materials - or presenting data.

Using a spreadsheet for sharing and analyzing data.

One group member should create the file and add the others as collaborators.

Publish the file and add the lead learner as a collaborator. Links to the files will be added below. One member of each small group will present the file to the large group.

Demonstration Activity 2: Who are we?*

Complete this demo survey.

View the results.

Demonstration: Create and publish a chart.

Demonstration: Self Grading Quiz (Your answer to the last question on the survey will be graded!)

Demonstration Activity 3: Forms for Teacher Observation or Data Collection*

Create a form for collecting data. Examples include:

A Teacher (or Student) Observation Form

A WASC Data Collection Form

An Awards Nomination Form

A Professional Development Evaluation

A Staff or Community Survey

A PLC Team Meeting Form


Team Smart Goal

Strategies and Action Steps



Evidence of Effectiveness

Advanced: A Self-Grading Quiz

Mock up a "proof-of-concept" to illustrate something you might actually implement.

Send the "live form" link to colleagues so they can fill out your form.

Share the results with colleagues or publish them as a web page.

Optional: Create (and publish) charts of the results.

Add the lead learner as a collaborator.

One member of each small group will present the form to the large group.

Demonstration Activity 4: Create a self-grading quiz! (Time permitting)*

In a small group, create a three question quiz using a Google Form.

Solicit sample answers from other participants.

Create an IF formula for each question to "grade" the question. (Each IF formula needs to be in a new column.)

Fill Down so that the IF formulas you've written can "grade" all the responses at once!

Advanced: Create a SUM formula to total up the total score for each person that took the quiz. Then create another formula to calculate the percentage. Finally, create a nested IF formula to convert the percentages to letter grades!

Time Permitting: Share your quiz with the lead learner. Links to the quizes will be added below.

BONUS: Using Google Docs and Forms on a Mobile Device

Accessing your Google Docs on a Mobile Device

Completing a Google Form on a Mobile Device


NEW: Quick and Easy Mail Merge Using Google Docs

*Note: All activities will be completed as time permits, using volunteers from the among the session participants.

Effective Professional Development (for Educational Technology)

Avoid leading poor quality professional development. Learn how to engage participants, connect with their passions, and extend their learning well beyond each session. Leave with five philosophies for “lead learners.”

Drawing on the success of the CUEtoYOU Professional Development program (including the Google Teacher Academy), this session includes specific strategies and examples for: leading welcome activities, engaging participants passions, being a “lead learner”, making a face-to-face workshop “better than the podcast”, ensuring participants have more positive than negative experiences in a workshop, helping participants to be the best teachers (and people) they can be, connecting PD to life, and providing effective reflection activities. The session also includes anecdotes and metaphors for inspiring professional developers (and participants).


Welcome Activities

Passion and Professional Development

The Lead Learner Philosophy

The Face-to-Face Philosophy

The Kindergarten Philosophy

The “And Life” Philosophy

A Message From The Future

Driving a Race Car

Reflection Activities

Go Forth and Do Great Things!

Detailed Agenda from CUE 2011: https://sites.google.com/a/edtechteam.com/www/cue2011/pd 

Social, Global, and Green: Education in A Changing World

Explore how social media is used to effect positive social change. Collaborate with colleagues, connect with classrooms around the globe, and help bring green initiatives to your school and community.

Societies around the globe are experiencing a time of rapid change. Educators, parents, and politicians are realizing that a new sort of tools - and a new sort of ethics - will be required for the next generation of students to succeed in the face of new challenges.  The presenter will explore how social media can be used by educators to effect positive social change. Participants will:

- Discover how students too can use powerful (and often free) tools to make a real difference in their world.

- See examples of how educators have collaborated with colleagues, connected their classrooms to others around the globe, and helped to bring green initiatives to their schools and communities.

- Learn to engage all students (including English learners, special education students, and GATE students), by tapping into their passions and bringing new relevance to the work (and play) they do in class.   The presenter will also share how these same technologies can be used in rigorous academic ways. In addition, participants will see innovative new forms of assessment and data collection - which can help schools meet the expectations of a society demanding greater accountability and greater transparency from public servants.


Welcome Activity

What impact does your school have on the world?

How can you and your students make a difference?

Anecdotes and Analogies

A Message From The Future

Driving a Race Car

Web 1.0

Powerful resource for educators and students, but…

Information moves from publishers to consumers

Information cannot be edited

Read-Only Web

One-Way Web

Web 2.0

It is now as easy to create as it is to consume.

Anyone can publish, share, and change information

Read/Write Web

Two-Way Web

This is changing our world!

A Time of Rapid Change








Organizing For America


Social Media and Social Change

Iran - The Revolution Will Be Televised... Tweeted... Streamed...

Neda Agha-Sultan






But signing an online petition is not social change. (Hat tip to @courosa.)

PBL with Meaning

Problem Based Learning - http://en.wikipedia.org/wiki/Problem-based_learning

Learning is driven by challenging, open-ended problems.

Students work in small collaborative groups.

Teachers take on the role as "facilitators" of learning.

Project Based Learning - http://www.edutopia.org/project-learning

Project learning is a dynamic approach to teaching in which students explore real-world problems and challenges.

PBL with a goal of effecting positive social change focuses on challenging, open-ended, real-world problems.


Blogs for Social Change: George Mayo and Wendy Drexler started this project in February of 2008 with their third and eighth grade students to spread awareness about the genocide in Darfur. - http://manyvoicesdarfur.blogspot.com/

Wikis for Social Change:

Primary Students Learn About The Impact of Climate Chage - http://primaryextension.wikispaces.com/

Classes in Canada & The UK Learn About Environmental Issues - http://flatplanet.wikispaces.com/About

Social Networks for Social Change:

Kay McNulty created a network for students... and Holocaust Survivors - http://remembrancejourneys.ning.com/

Wiki: http://njplp.wikispaces.com/Perth+Amboy+%28Middle+Schools%29 (wiki)

Article: http://plpnetwork.com/2009/05/04/new-jersey-team-finds-inspiration/

Vicki Davis and Julie Lindsay started the Flat Classroom Project - http://flatclassroomconference.ning.com/

Networking for Change - http://www.globalchallengeaward.org/display/public/Home

Video Games for Change: http://www.gamesforchange.org/play

Even with a Cell Phone: http://peace.tmpp.org/tv/x/home.jsp

More Resources and Examples

Alec Couros' Ideas for Technology and Social Justice in The Classroom - http://couros.wikispaces.com/socialjustice

Lovett Middle School Global Issues Wiki and Voicethreads (via Laura Deisley) - http://lovettmsglobalissues.wikispaces.com/

Gail Dressler's Voicethread for Social Change - http://voicethread.com/blog/#20090707

Gail Dressler's Change Writers Vimeo Project - http://vimeo.com/5733228

Good Guide: Find Safe, Healthy, & Green Products - http://www.goodguide.com/

Environmental Health News - http://environmentalhealthnews.org/

More Resources (via Tom Barrett... for a sealife project) - http://www.takepart.com/ & http://www.tourdeturtles.org/

Older (but cool) Projects (via Jen Wagner) - Caring for Katrina Victims & Dear Soldier

And a California League of Schools example (via John Curry) - High School Students Give To Hungry


http://thelifeyoucansave.com/ - Learn about eradicating global poverty, and discover the best organizations for your donations.

http://hopephones.org/ - Learn how you and your students can donate old cell phones to medical professionals in developing countries.

http://www.unixl.com/blog/2008/top-100-networks-for-people-who-want-to-change-the-world - Discover 100 networks for people who want to change the world.

Green Curriculum

http://www.thinkgreen.com/classroom - Classroom Resources from WM

http://greenopolis.com/ - A social network (from WM) with Green education resources... and games.

http://www.seventhgeneration.com/give/lesson-plans-fall-2009 - Lesson Plans from Seventh Generation.

http://greenliving.suite101.com/article.cfm/a_free_green_education - More resources teachers can use.

Green Schools



Reflection Activity

How can you and your students effective positive social change using social media?

What are your next steps?

Join the League Learning Network and share your answers in the discussion forum for this session .

Formulas for Forms: Easy and Powerful Functions in Google Spreadsheets

Combine powerful spreadsheet functions with Google Forms: Self-grading quizzes using Scripts, individual walk-through reports using TRANSPOSE, multiple data sources combined with VLOOKUP, mail merge with Gmail, and much more!

Many educators have recently discovered how easy it is to use Google Docs Forms for collecting, analyzing, and sharing data. This session makes it just as easy to use powerful spreadsheet formulas to extend the function of a Google Form.

For example, time-saving self-grading online quizzes can be made using the IF, SUM, and AVERAGE formulas (or with easy to use scripts). Rules can even be used to color code right and wrong answers for easy intervention. In addition, TRANSPOSE can be used to provide individualized feedback to students. (Similarly, the same formula can be used to provide individual reports to teachers after an administrator uses Google Forms during a walkthrough.) Then, VLOOKUP can be used to pull together data from multiple forms into one meaningful spreadsheet.

Best of all, unlike function help files, this session includes clear and concise explanations and examples for each of these formulas.

Time permitting, additional “web-only” functions of Google Docs Spreadsheets will be covered, including GoogleLookup, GoogleTranslate, ImportFeed, and more.

Online resources for the session include links to each tool, real-world examples, and screencasts illustrating key elements of each formula for later reference.

Personal Learning Networks (PLNs) for Professional Learning Communities PLCs

Personal learning is a foundation of any successful PLC. Learn to build your own Personal Learning Network (PLN) to support your own professional development and diffuse innovation within your PLC.

Personal learning is one of the foundations of a successful PLC - and an element of any successful organizational change effort. This session focuses on tools that can be used by any member of a PLC to build their own Personal Learning Network (PLN), which can not only support their own professional development but can also be an efficient means of diffusing innovation within the PLC. Learn to connect with a community of like minded professionals, make contributions, have conversations, and make requests in your times of need. Powerful free tools and social media such as Twitter and Ning make this possible for your PLC.


Welcome Question

Who makes up your learning network?

Learning to Network & Networking to Learn

Make Connections

Make Contributions

Make Conversation

Make Requests

David Jakes' Post on The Strength of Weak Ties: http://jakespeak.blogspot.com/2007/11/strength-of-weak-ties.html

Two-Way Web Stories

Introduction to the Two-Way Web


Example: http://edtechlife.com - And a Story: David Warlick commented on my blog! (In 2005)

More: http://supportblogging.com

Workshop Wiki: http://blogifyoulovelearning.wikispaces.com

Get Started: http://www.blogger.com

Jeff Utecht's Original Post about 25% Time and Professional Development: http://www.thethinkingstick.com/?p=96


OLD Example (Bloglines - Shared): http://www.bloglines.com/public/markdouglaswagner

NEW Example (Google Reader - Shared): http://www.google.com/reader/shared/user/10649784667868956453/state/com.google/broadcast

Workshop Wiki: http://reallysimple.wikispaces.com

Get Started: http://reader.google.com

And More...


Example: http://hmtech.wikispaces.com

More: http://educationalwikis.wikispaces.com

Wikis for PD: http://edtechlife.com/workshops/

See Also: http://www.wikipedia.org and http://en.wikipedia.org/wiki/Podcasting

Workshop Wiki: http://wikiwhileyouwork.wikispaces.com

Get Started: http://wikispaces.com/site/for/teachers


Example: http://k12onlineconference.org/

More: http://www.epnweb.org

Workshop Wiki: http://podcastined.wikispaces.com

Get started: http://podomatic.com

Google Docs

Example: See the presentation slides

Workshop Wiki: http://googled.wikispaces.com/docs2

CUE GWE Resources: http://sites.google.com/site/cuegli

GTA Resources: http://sites.google.com/site/gtaresources

Get Started: http://docs.google.com

Social Networking

Example: http://classroom20.ning.com

Get Started: http://www.ning.com

IM and Video Chat

Get Started: http://www.google.com/talk/ http://www.skype.com http://www.aim.com

See also iChat for Mac to Mac videoconferencing.

Streaming Media

Example: http://www.practicaltheory.org/serendipity/index.php?/archives/896-Learning-From-the-Kids.html

Example: http://www.ustream.tv/channel/weblogg-ed-tv

More: http://edtv.wikispaces.com

Get Started: http://www.ustream.tv

Social Microblogging

Example: http://twitter.com/markwagner

Workshop WIki: http://twittermethis.wikispaces.com

Get Started: http://twitter.com

Or Create Your Own Social Microblogging Community: http://shoutem.com/ (Example: http://teach42.shoutem.com/ )

Or Use A Social Microblogging Service Meant For Education: http://www.edmodo.com

Learning to Network & Networking to Learn

Make Connections

Make Contributions

Make Conversation

Make Requests

Getting Started

Pick Three Blogs to Read.

Try These Three: http://weblogg-ed.com http://www.davidwarlick.com/2cents/ http://coolcatteacher.blogspot.com/

Create and write a blog when you're ready. Get Started: http://www.blogger.com

Use RSS to read more when you're ready. Get Started: http://reader.google.com

Join Classroom 2.0. Get Started: http://www.classroom20.com

Join Twitter and Follow Others. Get Started: http://twitter.com

Find Others to Follow Using Twellow.com.

Find Others to Follow Using Google's Follow Finder.

Find Others to Follow Via Dr. Wagner's Twitter Account.

See also:

Liz Davis' post with "Ten Tips for Growing Your Learning Network": http://edtechpower.blogspot.com/2008/10/ten-tips-for-growing-your-learning.html

Jen Jones' post on "Getting Personal and Staying Professional.": http://injenuity.com/?p=40

Dr. Wagner's article on "Learning to Network and Networking to Learn": http://edtechlife.com/?p=2067

More Resources about why you might want a PLN: http://lwictpln2009.wikispaces.com/The+5Ws+of+PLNs

NEW: Read Jeff Utecht's Book, Reach .

Reflection Question

How do you plan to expand your learning network?

Google Certified Teachers Share: What’s new from Google for Educators?

A panel of Google Certified Teachers shares the latest features and tips, including search, collaboration, publishing, and... even more. Everything in this session is new since the session submission deadline!

I think the description says it all. And there’s no sense in this one being anonymous. I’ll hand-pick all of the GCTs from among CUE’s Lead Learners and Google Apps EDU Certified Trainers. Ideally, I’d like to have 12 GCTs (including myself) each sharing a 5 minute (or less) tip, but of course I’ll put together the best team possible given the tips to share and time available. :)


Mark Wagner, Ph.D.

Professional Development Coordinator

Computer Using Educators (CUE)



MarkWagnerIM (AIM)

markdwagner (Skype)

markwagner (Twitter)

949-259-4515 (Fax)

949-639-9743 (Phone)

Knowledge is Freedom: CIPA, COPPA, and FERPA Explained Succinctly

Learn important facts: CIPA requires schools have a procedure for disabling a filter, COPPA doesn't prevent students from using email, & FERPA allows web services to be considered school officials!

Children's Internet Protection Act (CIPA)

FCC Summary

Judicial Interpretation of CIPA's Unblocking Provision: According to the Supreme Court, a library that is required to filter can either disable the filter or unblock a site in response to an adult patron request to do so. Justice Rehnquist stated "[a]ssuming that such erroneous blocking presents constitutional difficulties, any such concerns are dispelled by the ease with which patrons may have the filtering software disabled. When a patron encounters a blocked site, he need only ask a librarian to unblock it or (at least in the case of adults) disable the filter." FCC Order 03-188 subsequently instructed libraries complying with CIPA to implement a procedure for unblocking the filter upon request by an adult.

FCC Order 03-188: In upholding CIPA, the Supreme Court emphasized “the ease with which patrons may have the filtering software disabled,” and that a patron who encounters a blocked site ... need only ask a librarian to unblock it (or at least in the case of adults) disable the filter.” The plurality also highlighted the government’s acknowledgment at oral argument that “a patron would not ‘have to explain ... why he was asking a site to be unblocked or the filtering to be disabled.’”

Children's Online Privacy Protection Act (COPPA)


Note: COPPA applies only to commercial entities, not non-profits or schools. The burden is on the commercial entity.

Note: Even so, schools excel at collecting "verifiable parent consent" - we call this permission slips.

Note: "COPPA allows... schools to act as agents for parents in providing consent for the online collection of students’ personal information within the school context."

Note: "COPPA does not apply to the website operator’s collection of personal information from participating children where a school has contracted with an operator to collect personal information from students for the use and benefit of the school."

Family Educational Rights and Privacy Act (FERPA)

ED Summary

§ 99.31 Under what conditions is prior consent not required to disclose information ? "A contractor, consultant, volunteer, or other party to whom an agency or institution has outsourced institutional services or functions may be considered a school official." (Certain conditions apply.)

Note: Parent consent is still sufficient to release "student records" to a third party (such as an online service provider).

Also: Schools are NOT required by Federal Rules of Civil Procedure (FRCP) to block all web 2.0 sites (or to archive all student email).

Note: The Freedom of Information Act (FOIA) applies only to Federal Agencies, but many states have similar Sunshine laws, including California's Public Records Act (PRA).