Google Summer Collaboration Challenge Week 6

Google Forms

Google Forms is a useful feature that allows you to manage event registrations, create a quick opinion poll, and much more. With Google Forms, you can create and analyze surveys right in your mobile or web browser—no special software required. You get instant results as they come in. And, you can summarize survey results at a glance with charts and graphs.

Getting Started with Google Forms
To get started, head to forms.google.com and select Blank. This will provide you with an empty canvas that you can begin to fill with questions. Note that you have many templates that you can choose from. For further instructions, please complete this tutorial for creating a Google Form.

When responses are submitted, you will be sent an email notifying you that someone has completed your Form. You also have the ability with Google Forms to organize responses into a Google Sheets. This is especially useful when analyzing responses.

Assignment: Following the instructions in the tutorial, create a Google Form survey asking for a name and five multiple choice questions and have a friend take the survey.

Extra Credit: Have their name and responses sent to a Google Sheets.

Once you complete reviewing the materials from the seventh week of the Google Collaboration Challenge take a few minutes to answer these questions: Week 6 Google Drive Questionnaire

Google Collaboration Challenge Week 3

Utilize Action Items to Work More Productively with Google Docs

One of the core promises of Google Docs is to help you and your team go from collecting ideas to achieving your goals as quickly and easily as possible. That’s why Google Docs recently launched Explore in Docs, Sheets and Slides — with machine intelligence built right in — to help your team create amazing presentations, spreadsheets and documents in a fraction of the time it used to take.

Try out two new time-saving features designed to speed up and simplify the way you work, so you can focus on bringing your team’s ideas to life.

1. Spend less time figuring out who owns what with Action Items

According to research by the McKinsey Global Institute, employees spend about 20 percent of their work week — nearly an entire day — searching for details internally and tracking down colleagues for answers. This can be especially true when a document is full of ideas, requests and comments, making it difficult to get a clear sense of who’s responsible for what.

To help keep your projects moving, when you type phrases like “Ryan to follow up on the keynote script,” or “Andrea to schedule a weekly check in” on desktop, Docs will intelligently suggest an Action Item to assign to the right person, thanks to Natural Language Processing (NLP).




Assignment:
Manually assign an Action Item to someone in the Docs, Sheets and Slides desktop and mobile apps by mentioning their name in a comment and checking the new Action Item box. The assignee will get an email notification and see the Action Item(s) clearly highlighted with a blue bar when they open the file.

2. Spend less time searching for the files that need attention

Once Action Items have been assigned, it’s easy for team members to identify documents, spreadsheets and presentations that need their attention. The next time they visit Docs, Sheets, Slides (or Drive) from their laptops or mobile apps, they’ll see a badge on any files with Action Items assigned to them, plus any unresolved suggestions that others have made to their files.

Assignment: Ask someone to assign an Action Item to you and complete that action item by navigating My Drive to find that Action Item.

Once you complete reviewing the materials from the third week of the Google Collaboration Challenge take a few minutes to answer these questions: Week 3 Google Questionnaire

Google Summer Collaboration Challenge Week 2

Getting started with Docs

Let's start by getting introduced to Docs - an online replacement for Microsoft Word. The following tutorial will walk you through a number of steps to become more familiar with Docs. The same can be repeated for Sheets (replaces Excel) and Slides (replaces PowerPoint).

Track changes, make progress 

It can take dozens of edits to make a document just right—especially a legal agreement, project proposal or research paper. These new updates in Docs let you more easily track your team’s changes. Now, your team can:

1. Name versions of a Doc, Sheet or Slide on the web.
2. Preview “clean versions” of Docs on the web to see what your Doc looks like without comments or suggested edits.
3. Accept or reject all edit suggestions at once in your Doc so your team doesn’t have to review every single punctuation mark or formatting update.
4. Suggest changes in a Doc from an Android, iPhone or iPad device.
5. Compare documents and review redlines instantly with Litera Change-Pro or Workshare Add-ons in Docs. 

Assignment:  Complete the "Introduction to Docs" tutorial by creating, editing, and sharing a new Doc.

Extra Credit:  Try the same tutorial for Sheets and Slides.

Working OFFLINE

 A useful feature for Google Apps (Docs, Slides, and Sheets) is the ability to work offline without an Internet connection.  By enabling "Offline Mode" within Google Drive, you'll have access to edit all of your files from a Chrome browser wherever you are - even when WIFI is spotty or unavailable.
View this video to find out how to enable offline mode for Google Drive.

Assignment:  Enable OFFLINE MODE for Google Drive.

Note:  it may take a while to make all files and folders accessible offline.  After enabling "offline mode", disconnect from WIFI and try creating and editing a new Doc or Sheet.

Once you complete reviewing the materials from the second week of the Google Collaboration Challenge take a few minutes to answer these questions: Week 2 Google Drive Questionnaire

Partially reposted from: What Can You Do With Docs?

Directly Edit Microsoft Office Files with Google Docs, Sheets & Slides

What’s changing 

With Office editing, you can now edit, comment, and collaborate on Microsoft Office files using Google Docs, Sheets, and Slides. This feature brings the collaboration benefits of G Suite to Office files while streamlining workflows by eliminating the need to convert file types.

Why you’d use it 

Office editing will make it easy for G Suite users to open and edit Microsoft Office files that have been shared by partners, vendors or other teams. In cases where some members of your organization use Office while others use G Suite, this ensures seamless collaboration and eliminates the need to consider or convert file types.

Office editing brings everyone the benefits of G Suite’s real time collaboration tools and intelligence features to Office files.


End users:

• In Google Drive, double-click your Office file. This will open a preview of the file. 
• At the top, click Open in Google Docs, Sheets, or Slides. 
• From here, you can edit, share, view version history, collaborate in real-time with others, and more. 
• All changes you make will be saved to the original Office file. 

Additional details 

The following Office file types are supported: 

• Word files: .doc, .docx, .dot 
• Excel files: .xls, .xlsx, .xlsm (macro enabled Excel files), .xlt 
• Powerpoint files: .ppt, .pptx, .pps, .pot 

Note: If you edit Word, Excel, or PowerPoint documents older than Office 2007, files will be saved to a newer format when editing using Office editing. 

Note: 

If you have the Office Editing for Docs, Sheets & Slides Extension already installed it must be removed before this new feature will work:

Sign into Google Chrome Browser with your Managed Google Account

Navigate to the upper right of your screen to the Settings area

Select More Tools

Select Extensions

Locate the Office Editing for Docs, Sheets & Slides from your options of extensions and select Remove

Helpful links 

To learn more about working with Office files using Office editing, see here. 

To learn more about removing the Office compatibility app, see here. 

Partially reposted from :  Office editing makes it easier to work with Office files in Docs, Sheets, and Slides

Sheets is Updated with 3 New Features

What’s changing 

Google is introducing three new features that will help you clean up and work with your data in Sheets. These features are: 

• Remove duplicates 
• Trim whitespace 
• Compatible spreadsheet shortcuts 

Why you’d use them 

Remove duplicates: 
A highly requested feature, you can use this tool to easily remove duplicate values from your sheet, saving you time by eliminating the need to write an app script or manually remove duplicate data.

Trim whitespace: 
Sometimes when you add data to a sheet, it may not be the format you need. Now, you can easily keep your sheet standardized by using the trim whitespace feature to remove any leading, trailing, or excessive whitespace from a cell or array of data.

Compatible keyboard shortcuts: 
You can now use popular keyboard shortcuts from other spreadsheets in Sheets. These familiar shortcuts will make navigating and working with data in Sheets quicker for users.

How to get started 

• To remove duplicates from a range of data: 
• Select range of data in your sheet 
• From the toolbar, select Data > Remove duplicates. In the dialogue box, you’ll see your selected range of data. 
• Select Remove duplicates. You’ll see an additional dialogue box that details how many duplicates were removed from your dataset.
• To trim whitespaces: 
• Select a cell or range of data that contains whitespace on your sheet 
• From the toolbar, select Data > Trim whitespace 
• You’ll then see a dialogue box that details how many cells whitespace was removed from. 

• To enable compatible keyboard shortcuts: 
• Users can access keyboard shortcuts by going to Help > Keyboard shortcuts. 
• From here, you can see a list of keyboard shortcuts and their corresponding commands. Note that compatible shortcuts will be denoted with an info icon. 
• At the bottom, you can enable compatible spreadsheet shortcuts. 
• You can click “View compatible shortcuts” at the bottom right to see a complete list of all newly available shortcuts. 

Helpful links 

Keyboard shortcuts for Google Docs. 
Split text, remove duplicates, or trim whitespace in Sheets.
Separate cell text into columns. 

Availability 

Rollout details 

• These new features will be available soon.

Partially reposted from:  Three new features to format and work with data in Sheets

Week 8 Tech Showcase - G Suite Productivity Apps

G Suite

G Suite is Google's full range of productivity apps based in the cloud that allow you to connect, access, and create. Clicking on each app name will direct you to the G Suite Learning Center for that product.

With G Suite, you can connect by utilizing Gmail, Google Calendar, and Hangouts Chat, and Hangouts Meet.

• Gmail

Gmail allows you to be updated with secure, private, and ad-free email. In addition, Gmail keeps you updated with real-time message notifications, and safely stores your important emails and data.

• Google Calendar

Google Calendar allows you to set up events on a cloud based calendar, and it is integrated seamlessly with Gmail, Drive, Contacts, Sites and Hangouts. You can also schedule events quickly by checking coworkers' availability or layering their calendars in a single view. You can share calendars so people see full event details or just if you are free.

• Hangouts Chat

 

Hangouts Chat is an instant messaging solution that allows for communication either with one person or an entire group. It also features bots that can integrate other Google features such as Google Calendar and Google Drive as shown in the following image.

• Hangouts Meet

Hangouts Meet is a video conferencing solution that will be covered in next week's Tech Showcase.

• Google Drive

G Suite also allows you to utilize cloud storage using Google Drive. G Suite allows you to have unlimited Google Drive cloud storage. This means you can store, access, and share your files in one secure place. You have the ability to access files anytime, anywhere from your desktop and mobile devices. Google Drive is especially useful for using less space on your device.

Additionally, you can create Team Drives which foster collaboration by allowing a shared drive where multiple people can upload files.

With G Suite, you can also create Google Docs, Slides, Sheets, and Forms. These programs are Google's word processor, presentation, and spreadsheet programs.

• Google Docs

Google Docs allows you to create and edit text documents right in your browser with no dedicated software required. Multiple people can work at the same time, and every change/revision is saved automatically. It also allows you export to other file types such MS Word, PDF, etc. It can also convert Word files to Docs.

• Google Slides

Google Slides allows you to create and edit presentations in your browser with no software required. Multiple people can work at the same time, and every change/revision is saved automatically. It also allows you export to other file types such PPT, PDF, etc. It can also convert PPT files to Slides.

• Google Sheets

Google Sheets allows you to create and edit spreadsheets in your browser with no software required.
Multiple people can work at the same time, and every change/revision is saved automatically. It also allows you export to other file types such Excel, PDF, etc. It can also convert Excel files to Sheets.

• Google Forms

Google Forms allows you to easily create forms for surveys and questionnaires. Responses can be tracked from Google Forms as well as Google Sheets where it is integrated seamlessly.

We are interested in your feedback, please take a few moments to complete the following G Suite Productivity Apps Survey

Google Summer Collaboration Challenge Week 7

Google Forms

Google Forms is a useful feature that allows you to manage event registrations, create a quick opinion poll, and much more. With Google Forms, you can create and analyze surveys right in your mobile or web browser—no special software required. You get instant results as they come in. And, you can summarize survey results at a glance with charts and graphs.

Getting Started with Google Forms

To get started, head to forms.google.com and select Blank. This will provide you with an empty canvas that you can begin to fill with questions. Note that you have many templates that you can choose from. For further instructions, please complete this tutorial for creating a Google Form.

When responses are submitted, you will be sent an email notifying you that someone has completed your Form. You also have the ability with Google Forms to organize responses into a Google Sheets. This is especially useful when analyzing responses.

Assignment: Following the instructions in the tutorial, create a Google Form survey asking for a name and five multiple choice questions and have a friend take the survey.

Extra Credit: Have their name and responses sent to a Google Sheets.

Once you complete reviewing the materials from the seventh week of the Google Collaboration Challenge take a few minutes to answer these questions: Week 7 Google Drive Questionnaire

Google Summer Collaboration Challenge Week 3

Utilize Action Items to Work More Productively with Google Docs

One of the core promises of Google Docs is to help you and your team go from collecting ideas to achieving your goals as quickly and easily as possible. That’s why Google Docs recently launched Explore in Docs, Sheets and Slides — with machine intelligence built right in — to help your team create amazing presentations, spreadsheets and documents in a fraction of the time it used to take.

Try out two new time-saving features designed to speed up and simplify the way you work, so you can focus on bringing your team’s ideas to life.

1. Spend less time figuring out who owns what with Action Items

According to research by the McKinsey Global Institute, employees spend about 20 percent of their work week — nearly an entire day — searching for details internally and tracking down colleagues for answers. This can be especially true when a document is full of ideas, requests and comments, making it difficult to get a clear sense of who’s responsible for what.

To help keep your projects moving, when you type phrases like “Ryan to follow up on the keynote script,” or “Andrea to schedule a weekly check in” on desktop, Docs will intelligently suggest an Action Item to assign to the right person, thanks to Natural Language Processing (NLP).




Assignment:
Manually assign an Action Item to someone in the Docs, Sheets and Slides desktop and mobile apps by mentioning their name in a comment and checking the new Action Item box. The assignee will get an email notification and see the Action Item(s) clearly highlighted with a blue bar when they open the file.

2. Spend less time searching for the files that need attention

Once Action Items have been assigned, it’s easy for team members to identify documents, spreadsheets and presentations that need their attention. The next time they visit Docs, Sheets, Slides (or Drive) from their laptops or mobile apps, they’ll see a badge on any files with Action Items assigned to them, plus any unresolved suggestions that others have made to their files.

Assignment: Ask someone to assign an Action Item to you and complete that action item by navigating My Drive to find that Action Item.

Once you complete reviewing the materials from the third week of the Google Collaboration Challenge take a few minutes to answer these questions: Week 3 Google Questionnaire

Google Summer Collaboration Challenge Week 2

Getting started with Docs

Let's start by getting introduced to Docs - an online replacement for Microsoft Word. The following tutorial will walk you through a number of steps to become more familiar with Docs. The same can be repeated for Sheets (replaces Excel) and Slides (replaces PowerPoint).

Track changes, make progress 

It can take dozens of edits to make a document just right—especially a legal agreement, project proposal or research paper. These new updates in Docs let you more easily track your team’s changes. Now, your team can:

1. Name versions of a Doc, Sheet or Slide on the web.
2. Preview “clean versions” of Docs on the web to see what your Doc looks like without comments or suggested edits.
3. Accept or reject all edit suggestions at once in your Doc so your team doesn’t have to review every single punctuation mark or formatting update.
4. Suggest changes in a Doc from an Android, iPhone or iPad device.
5. Compare documents and review redlines instantly with Litera Change-Pro or Workshare Add-ons in Docs. 

Assignment:  Complete the "Introduction to Docs" tutorial by creating, editing, and sharing a new Doc.

Extra Credit:  Try the same tutorial for Sheets and Slides.

Working OFFLINE

 A useful feature for Google Apps (Docs, Slides, and Sheets) is the ability to work offline without an Internet connection.  By enabling "Offline Mode" within Google Drive, you'll have access to edit all of your files from a Chrome browser wherever you are - even when WIFI is spotty or unavailable.
View this video to find out how to enable offline mode for Google Drive.

Assignment:  Enable OFFLINE MODE for Google Drive.

note:  it may take a while to make all files and folders accessible offline.  After enabling "offline mode", disconnect from WIFI and try creating and editing a new Doc or Sheet.

Once you complete reviewing the materials from the second week of the Google Collaboration Challenge take a few minutes to answer these questions: Week 2 Google Drive Questionnaire

Set Sharing Expiration Dates: Google Drive, Docs Sheets and Slides

Granting access to your online files is an important part of collaboration. Sometimes temporary access is beneficial. However, file owners often forget to remove access privileges of particular collaborators. Google has now added the ability to automatically expire access on a chosen date in Google Drive, Docs, Sheets and Slides.

To set an access expiration date, go to the file’s Share Settings panel. Next to the access level of an individual user (or group), a stopwatch icon appears as you hover over that individual (or group). Clicking on it will reveal an expiration date pull-down menu. You can choose to have the access expire in 7 days, 30 days, or a date that you choose (“custom date”).

Please note:

• Expiration dates are only an option for users with comment or view access. This setting does not apply to file owners or users with edit access, as these users have the ability to modify access rights and could simply override the settiing

More Information
Help Center: Change your sharing settings in Google Drive
Help Center: Share Google Drive files and folders

partially reposted from the https://gsuiteupdates.googleblog.com/2016/03/set-expiration-dates-for-access-to.html

Head Back to School with Drive: Teacher Edition

Here are 3 tips to help teachers prepare for going back to school with Docs, Sheets, Slides, and Forms.

1. Use Slides to get to know your students

A great introductory activity is to create a single slide deck, and then invite each of your students to share a bit about themselves on their own personal slide. It’s a fantastic get-to-know-you activity for the beginning of school and you’ll be amazed by the creativity that comes out of your students!

The screenshot below shows how Google Student Ambassadors from 9 different countries used Slides to introduce themselves before gathering to meet each other at an event in Indonesia this summer.

Want to get this going with your students? Easy—create a new Slides deck on the first week of school, click the blue Share button to invite your students, and give them a little direction for their individual slide by adding comments.

2. Use Docs to create a classroom “Bill of Rights”

The first few weeks of class is that precious transition from the “honeymoon” period of well behaved students to learning the norms of your classroom culture. Help start the year off right by inviting students to co-create their ideas of citizenship and a happy learning environment, Docs style.

Start by creating a copy of this template and then invite students to join in with you to add their ideas, ratify by adding a comment, and use their editing prowess to come up with a final copy to live by for the coming year.

3. Use Forms to get to know your students (and their prior knowledge!)

Get to know your classroom as soon as possible, using Forms to gather information about their needs, interests, and abilities beforehand. Consider creating a simple Form for a survey for your students and have fun showing the data on your projector and learning about your class as a whole.

Forms can be used as a very quick getting started activity before any lesson as well—take this example from a social studies classroom before talking about population. By placing a quick Form on your classroom site or emailing your students the Form, you can quickly grasp your students' prior knowledge—before you start teaching.

In this case, our team was a bit off, but helped us not only talk about population but estimation and numbers in general (answer? 7.1 billion and counting. )

Partially reposted from the Google Drive Blog: http://googledrive.blogspot.com
Originally posted by  Wendy Gorton, an educational consultant- https://drive.googleblog.com/2013/08/drivebts-teachers.html