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 Support
Don't miss Latest, Wonderwheel, and Timeline!
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.
Creative Commons & 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.
Don't miss the "cited by" feature!
New: Scholar Alerts!
About The Updates to Google News
Don't miss the Google News Archives! (Demo Video)
See also News Timeline and InQuotes from Google Labs.
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
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)
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).
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
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.
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
Powerful resource for educators and students, but…
Information moves from publishers to consumers
Information cannot be edited
It is now as easy to create as it is to consume.
Anyone can publish, share, and change information
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...
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)
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.
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.
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.
Who makes up your learning network?
Learning to Network & Networking to Learn
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)
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
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
Workshop Wiki: http://podcastined.wikispaces.com
Get started: http://podomatic.com
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
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.
Get Started: http://www.ustream.tv
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
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.
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 .
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)
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)
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)
§ 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).