Google+Documents+-+Spreadsheets

Google Docs Spreadsheets



 CATEGORY/GRADE LEVEL:

 * Math, Science
 * Middle and high school students
 * K-12 teachers of any curricular area for collaboration

 BRIEF DESCRIPTION

 * Google docs spreadsheet is a free, online spreadsheet by Google. It allows users to create and edit documents online while collaborating in real-time with other users.

 STRENGTHS

 * Free
 * Easy to use as it is very similar to Microsoft Excel
 * Access anywhere: edit and view your docs from any computer or smart phone.
 * Google docs spreadsheet is an online spreadsheet that allows you to access your spreadsheets from any computer via a web browser.
 * It facilitates collaboration and sharing
 * <span style="font-family: Arial,Helvetica,sans-serif;">Upload Excel files from your computer to share or edit online
 * <span style="font-family: Arial,Helvetica,sans-serif;">Export Google docs spreadsheet to a .xls (Microsoft Excel), .html, .csv, Open Office, or .pdf file.
 * <span style="font-family: Arial,Helvetica,sans-serif;">Share Google docs spreadsheets.
 * <span style="font-family: Arial,Helvetica,sans-serif;">Sheet protection: spreadsheet owners can use the sheet protection feature to lock sheets so they can only be edited by collaborators the owner chooses
 * <span style="font-family: Arial,Helvetica,sans-serif;">Print spreadsheet
 * <span style="font-family: Arial,Helvetica,sans-serif;">Create charts
 * <span style="font-family: Arial,Helvetica,sans-serif;">Formatting is similar to Microsoft Excel
 * <span style="font-family: Arial,Helvetica,sans-serif;">Google Tournament function: The GoogleTournament function allows users to query NCAA data (including team names, records, scores, seedings, game times, etc) in a Google spreadsheet (ideal for creating automatic brackets)
 * <span style="font-family: Arial,Helvetica,sans-serif;">Copy sheet: You can copy sheets from one spreadsheet to another; separate spreadsheet

<span style="font-family: Arial,Helvetica,sans-serif;"> <span style="color: #ffae00; font-family: Arial,Helvetica,sans-serif;">WEAKNESSES

 * <span style="font-family: Arial,Helvetica,sans-serif;">Required e-mail account to create a spreadsheet
 * <span style="font-family: Arial,Helvetica,sans-serif;">When sharing a spreadsheet with others it allows them to edit the document

===<span style="font-family: Arial,Helvetica,sans-serif;"> <span style="color: #ffae00; font-family: Arial,Helvetica,sans-serif;">SUGGESTIONS FOR CLASSROOM APPLICATIONS ===
 * <span style="font-family: Arial,Helvetica,sans-serif;">Have your students record their group project data in a single doc.
 * <span style="font-family: Arial,Helvetica,sans-serif;">Create quizzes and tests using spreadsheets forms. Your students answer the questions in the doc. Answers will arrive neatly ordered in a spreadsheet.
 * <span style="font-family: Arial,Helvetica,sans-serif;">Encourage collaborative presentation skills by asking your students to work together on a shared presentation and then present it to the class.
 * <span style="font-family: Arial,Helvetica,sans-serif;">Students track and organize project data in a single spreadsheet, accessible to any group collaborator at any time.
 * <span style="font-family: Arial,Helvetica,sans-serif;">TIPS:
 * <span style="font-family: Arial,Helvetica,sans-serif;">Create a folder for each class, group of students, project, etc. Since you can add one doc to multiple folders, you can cross-categorize as much and as often as you’d like.
 * <span style="font-family: Arial,Helvetica,sans-serif;">If you’re working with a lot of documents on one project, make sure you give each document a clear and easily recognizable name, connected with the project at hand

<span style="color: #ffae00; font-family: Arial,Helvetica,sans-serif;">LINKS TO RESOURCES

 * <span style="font-family: Arial,Helvetica,sans-serif;">[|Wikipedia article on Google docs/spreadsheets]
 * <span style="font-family: Arial,Helvetica,sans-serif;">[|Google spreadsheet for education]
 * <span style="font-family: Arial,Helvetica,sans-serif;">[|Google spreadsheet templates]
 * <span style="font-family: Arial,Helvetica,sans-serif;">[|Google docs blog]

YouTube video teaching the basics of Googledocs. "In Plain English" media type="youtube" key="eRqUE6IHTEA?fs=1" height="385" width="480"