Google Tools offer a perfect solution for supporting PBL and CBL in the classroom.  These teaching and learning frameworks focus on a student-driven experience where collaboration is a key component.

As more Oregon schools roll out Google's free suite of productivity software this fall, they're also trying to educate parents and ease concerns about privacy. Oregon was the first state to sign up for Google Apps for Education in 2010 and make it available to K-12 school districts. The free software allows students to access their class work from home, the library, or anywhere they have internet access. But the very thing that makes Google Apps so accessible and appealing worries some parents: They don't want Google or anyone outside the district to have access to their children's private information.

This Google Apps Script code will copy the data on Google Spreadsheet from Sheet1 to Sheet2 ( If Sheet2 is not existed, it will automatically create one). The good thing is, basically, you don't need to change anything to make it work.

This site contains tools and guidelines to use as a starting point to getting your students, faculty, and alumni ready and excited about what's coming.

In your document list, you'll notice various icons and descriptions listed next to the title of each doc. Here's a general overview: A lock icon means "Private" A lock icon in front of a globe means "Anyone with the link" A globe means "Public on the web"

Google Apps is also governed by a detailed Privacy Policy, which ensures we will not inappropriately share or use personal information placed in our systems. The Google Apps Terms of Service contractually ensures that your institution (or students, faculty, and staff) are the sole owners of their data. Because customers own the data they put into Google Apps, we believe it should be easy for your users to move their data in and out of our systems. The controls, processes and policies that protect user data in our systems have obtained a SAS 70 Type II attestation and will continue to seek similar attestation. Google complies with applicable US privacy law, and the Google Apps Terms of Service can specifically detail our obligations and compliance with FERPA (Family Educational Rights and Privacy Act) regulations. Google is registered with the US-EU Safe Harbor agreement, which helps ensure that our data protection compliance meets European Union standards for educational institutions.

To use the GoogleLookup function, enter the following formula in the desired spreadsheet cell:=GoogleLookup("entity" ; "attribute") where "entity" represents the name of the entity you want to access and "attribute" is the type of information that you want to retrieve.