Updates and Announcements


Check Out the New Look for the U-M Weblogin Page

posted Jul 22, 2016, 1:28 PM by Amanda Hudeck

Hello,


The weblogin page we all use to log in to many U-M websites, including Box and Google, has a new look. This updated page is designed to work consistently across all electronic devices. The new look accompanied the implementation of two-factor authentication.  



The Collaboration Services Team


Tip: Did you know? Google has a Google+ Cheat Sheet!

Learn more about Google at the Google Apps Learning Center


June Monthly Updates

posted Jul 1, 2016, 1:38 PM by Amanda Hudeck   [ updated Jul 1, 2016, 1:38 PM ]

The monthly M+Google Digest informs users about what is happening with Google releases for both Core Apps (Google applications that fall under the Google Apps for Education agreement and do NOT require separate terms of service or privacy policy), as well as the Non-Core Apps (those that are not part of the Google Apps for Education agreement). We will continue to communicate important information on Core Apps throughout the month as well. For a list of Core and Non-Core Apps, see the M+Google List of Services page.


Core Apps:

  • New and improved! You can now use document outlines in your Google Docs app on your iOS devices.

  • There are new editing features for Google Docs and Sheets apps for Android and iOS. The new features are:

    • Editing content in Print layout view. Simply tap the edit pencil icon when you are viewing a document in Print layout mode and you’ll be able to edit the document immediately.

    • Editing existing conditional formatting rules in the Sheets app for Android. You can also add new conditional formatting. Format cells, rows, and columns to change the formatting if they meet certain conditions, like containing a particular word or number.

  • Is your data in Google Sheets? Soon you will be able to connect directly to that data in the new Tableau 10, which will be rolling out in the UMICH domain in the next couple of weeks. To connect to your sheet, select the option under “More Servers” in the connect menu. Select your sheet from the list of available sheets that will display. After you have chosen the applicable sheet, click Connect.

  • Respond quickly with new and improved Google Docs, Sheets, and Slides comment notifications on Android and on the web. This update will allow you to receive comment notifications on your Android device as well as the web. No need to update your settings, notifications will follow the same rules as the settings you have already set up. Web browser notifications are controlled by Drive settings and are set to “off” by default. You will only receive Android notifications if you have the latest Google Drive for Android app.

  • See event locations at a glance with Calendar on the web! Tired of having to open up a calendar event to see where it is taking place? Event locations will now appear in the day and week views in Google Calendar on the web. This will eliminate the need to navigate to the event details to see the location. Please note that the details will only appear when there is enough space available to show it. The image below shows several events with locations visible.

  • Embed and update charts from Sheets in Docs and Slides. Many times, a chart is used across multiple documents and presentations. If there is a change to that chart, it can be very time-consuming to replace it in every file that uses it. To save time, you can now update your chart with a click—no need to leave your document or presentation. To enable this feature, go to Insert > Chart in Google Docs or Slides on the web. Insert a new chart or select From Sheets to add an existing chart from your spreadsheet. Check the Link to spreadsheet box and you’ll be given the option to update the chart with one click—as long as the underlying data in Google Sheets changes. If you no longer want to be notified of updates to a chart, you can unlink it. This is also available if you copy and paste a chart into a document or presentation.

Please note: The ability to import or update linked charts will only be available to collaborators with edit access to the document, presentation, or underlying spreadsheet.


Note: Keep in mind that even when non-core apps are found in a core app (like Google Drive), they are not covered by the Google Apps for Education agreement.


M+Google Team


Tip: Did you know? You can highlight changes to your data with formatting rules.

Learn more about Google at the Google Apps Learning Center


Embed and update charts from Sheets in Docs and Slides

posted Jun 3, 2016, 5:29 AM by Amanda Hudeck

Many times, a chart is used across multiple documents and presentations. If there is a change to that chart, it can be very time-consuming to replace it in every file that uses it. To save time, you can now update your chart with a click—no need to leave your document or presentation. To enable this feature, go to Insert > Chart in Google Docs or Slides on the web. Insert a new chart or select From Sheets to add an existing chart from your spreadsheet. Check the Link to spreadsheet box and you’ll be given the option to update the chart with one click—as long as the underlying data in Google Sheets changes. If you no longer want to be notified of updates to a chart, you can unlink it. This is also available if you copy and paste a chart into a document or presentation.




Please note: The ability to import or update linked charts will only be available to collaborators with edit access to the document, presentation, or underlying spreadsheet.


M+Google Team


Tip: Did you know? You can split text separated by a comma (also known as delimited data) into several columns with Google Sheets.

Learn more about Google at the Google Apps Learning Center


See event locations at a glance with Calendar on the web

posted Jun 3, 2016, 5:21 AM by Amanda Hudeck

Tired of having to open up a calendar event to see where it is taking place? Event locations will now appear in the day and week views in Google Calendar on the web. This will eliminate the need to navigate to the event details to see the location. Please note that the details will only appear when there is enough space available to show it. The image below shows several events with locations visible.



M+Google Team


Tip: Did you know? You can view your schedule from your Gmail inbox.

Learn more about Google at the Google Apps Learning Center

May Monthly Updates

posted May 31, 2016, 7:14 AM by Amanda Hudeck   [ updated May 31, 2016, 7:19 AM ]

The monthly M+Google Digest informs users about what is happening with Google releases for both Core Apps (Google applications that fall under the Google Apps for Education agreement and do NOT require separate terms of service or privacy policy), as well as the Non-Core Apps (those that are not part of the Google Apps for Education agreement). We will continue to communicate important information on Core Apps throughout the month as well. For a list of Core and Non-Core Apps, see the M+Google List of Services page.


Core Apps:

  • Dial in with ease! The latest Google Calendar app for Android gives you the ability to add the passcode automatically. Tap the call-in number from the calendar event and you will be prompted to select the passcode for either host or participant.

  • You can now view images and drawings (even in “frozen sections”) in the Sheets app on your iPhone or iPad.

  • Google BigQuery is integrating with Google Drive. Google BigQuery is a serverless analytics data warehouse that lets you analyze large amounts of data to find meaningful insights, using familiar SQL. BigQuery is fully managed, which means it frequently delivers features and upgrades without any downtime or burden on the user. You can now:

    • Save query results directly to Google Sheets from the BigQuery UI.

    • Query files directly from Google Drive, without loading them into BigQuery first.

    • Query Google Sheets spreadsheets from BigQuery as you edit them in Sheets.

Check out the post on the Google Cloud Big Data and Machine Learning blog for more details.

  • New! More ways to keep data flowing between your apps and ours::

    • Build seamless integrations with the new Sheets and Slides APIs. An example: developers can use Sheets as part of a workflow and allows users to collaborate on data before the updated data is pulled back into the original app. No need to copy and paste!

    • Keep data synced with the new Classroom API. Developers can access assignments, grades, and workflow. Gradebooks and reporting systems can be synced with Classroom, which eliminates the need to manually transfer grades.

    • No more stale data with linked charts! You can keep data flowing seamlessly by linking charts from Sheets into Docs or Slides.

  • Opening Google Docs, Sheets, and Slides files on mobile is now easier when you’re offline. Any Docs, Sheets, or Slides files you have worked on recently will be automatically synced to your mobile device. You can open them even if you don’t have an internet connection.


Note: Keep in mind that even when non-core apps are found in a core app (like Google Drive), they are not covered by the Google Apps for Education agreement.


M+Google Team


Tip: Did you know? You can search for image files by describing them instead of using their file names in Drive.

Learn more about Google at the Google Apps Learning Center

You can now accept questions from the audience when presenting in Google Slides

posted May 19, 2016, 6:08 AM by Amanda Hudeck   [ updated May 19, 2016, 6:48 AM by Rita Girardi ]

Skilled presenters know an interactive presentation can be an effective one. Google Slides has added a new feature allowing your audience to submit questions and vote on them, all while you are presenting! Want to see the feature in action? Check out this video of Google Science Fair winner Shree Bose taking questions from a group of 200 middle school students.


Some things to be aware of:


  • The Slides Q&A feature works on desktop computers, Android mobile devices, and iOS mobile devices.

  • You can only use Slides Q&A if you have edit or comment access to that Slides presentation.

  • Any user in your domain can submit a question. External users can submit questions too, if allowed by your organization.

  • You can use your mouse as a laser pointer in Slides on the web. Choose the laser pointer option in the toolbar and move your mouse. A red laser-like dot will appear on screen!

  • In the iOS app, you can present in a new Hangout or go to a Hangout selected from a meeting on your Calendar.


More information can be found at the Help Center.


M+Google Team


Tip: Did you know? You don’t have to switch to a different application or software to create images for your documents and presentations. You can crop, recolor, and more right in Google Docs and Sheets!

Learn more about Google at the Google Apps Learning Center

Google Calendar Reminders are coming to the web

posted May 11, 2016, 1:54 PM by Amanda Hudeck

Last year, Google launched Reminders in the Google Calendar app for iOS and Android systems. Now, Reminders for Google Calendar on the web are here. With Reminders, you can set a reminder for a specific time and date. To create a reminder, tap or click on a time in the calendar grid, then select “Reminder.”



Reminders carry forward until you mark them as “done” by clicking on the reminder and selecting “Mark as done.”



Please note:

  • Reminders created in the Google app and Keep will show in Google Calendar.

  • Reminders will sync to your Google Calendar Android and iOS apps.

  • Reminders are private and are not viewable, even if your calendar is shared with others.

  • Google Tasks users won’t be prompted to use Reminders. You can enable the feature from the drop-down menu on the Tasks calendar.



M+Google Team


Tip: Did you know? You can set up appointment slots in your calendar that people can book.

Learn more about Google at the Google Apps Learning Center


Google Drive is now supporting web notifications in Chrome

posted May 11, 2016, 5:42 AM by Amanda Hudeck

Want to respond quicker in Google Drive? Drive now supports web notifications in Chrome when files are shared with you, or access to your files is requested. This will help you keep up with what is happening in your Drive. There are a few things you need to be aware of with this new feature:


  • You have to opt-in to turn on notifications.

  • Notifications will only be visible while using Chrome.

  • You can control which notifications you want to receive on a per-device basis.


Watch for a message in the bottom left of your document list with a link to enable the feature.



You can also turn notifications on/off by going to your Drive settings and selecting Notifications. You’ll be given three options to choose from. Pick the types of notifications you want to receive and click Done.


M+Google Team


Tip: Did you know? You can keep all of your team’s information, collateral, and updates in one place with a team site.

Learn more about Google at the Google Apps Learning Center


April Monthly Update

posted May 3, 2016, 6:58 AM by Amanda Hudeck

The monthly M+Google Digest informs users about what is happening with Google releases for both Core Apps (Google applications that fall under the Google Apps for Education agreement and do NOT require separate terms of service or privacy policy), as well as the Non-Core Apps (those that are not part of the Google Apps for Education agreement). We will continue to communicate important information on Core Apps throughout the month as well. For a list of Core and Non-Core Apps, see the M+Google List of Services page.


Core Apps:

  • The Google Drive Sync app for Mac/PC just got better! Now you can sync only the subfolders you need.

  • Coming soon! You’ll be able to keep your information safe with expiration dates for specific users in Google Drive.

  • Slow scrolling on your Apple device won’t be a problem anymore. Now you can scroll quickly through Google Docs on your iPhone or iPad.

  • Quickly activate link sharing with the “Get sharable link” icon in Drive.

  • New: upload directly to a destination folder with Inline Uploads in Drive for Android.

  • Soon you’ll be able to do more with charts in Google Sheets for Android. New features will allow you to:

    • Add or change a chart’s title.

    • Add or change the titles of a chart’s X and Y axes.

    • Change the color of a series in a chart.

    • Specify where the chart’s legend should be located.

  • Do you have trouble finding time for meetings in Google Calendar on Android? Google will be adding a new feature, called “Find a Time” that will make scheduling meetings much easier and more convenient.

  • Templates and custom Docs will no longer be stored in the Templates gallery. You’ll be able to create a template directly in Google Docs, Sheets, Slides, and Forms. More information about this change will be coming soon!


M+Google Team


Tip: Did you know? You can keep all your drafts in one Drive file - you can revert to earlier versions any time.

Learn more about Google at the Google Apps Learning Center


Want an easier way to read in Google Sheets? Resize the formula bar!

posted Apr 28, 2016, 5:36 AM by Eric Fruth   [ updated Apr 28, 2016, 5:37 AM ]

Coming soon: Working with a spreadsheet can be challenging and you shouldn’t have to struggle to view the cell contents. Google Sheets is introducing a feature that will allow you to resize the formula bar so you can read the entire cell, even if you only have view or comment access.



M+Google Team


Tip: Did you know? With Google Docs, you can see at a glance what’s changed in a document since the last time you opened it.

Learn more about Google at the Google Apps Learning Center

1-10 of 370