I recently had the privilege to present a session for Google's series of "Did You Know?" webinars. These are a collection of 8 sessions covering a wide range of Google tools for schools.
You can learn more about the entire "Did You Know?" series in my earlier blog post here: Free Google Webinars - "Did You Know" Series
For my first session I presented the following webinar:
You can do that with Docs, Slides, and Sheets?!
Description: We use Docs, Slides, and Sheets everyday, but may not be taking advantage of all the impactful features available. In this session we will explore many of their lesser-known features such as default font, video previews, embedded Drawings, maximizing space, live captions, publishing to the web, splitting text, pivot tables, conditional formatting, and more!
▶️ Recorded Webinar (34 minutes)
Or watch on YouTube at: https://www.youtube.com/watch?v=agfT754Q4XQ
📄 Topic #1 - Google Docs Tips
Setting Your Default Font
You can set the default font style for any new document you create.
- Format text the way you want it.
- Select text.
- Click "Normal text" and "Update normal text to match".
- Click "Normal text" again, then "Options" then "Save as my default styles".
You can watch YouTube videos in a pop-up window inside Google Docs.
- Add a YouTube link to your Google Doc (as hyperlink or "chip").
- Click on or hover over the link to see a video thumbnail.
- Click on "Open preview" to watch the video in a pop-up window.
- The video can be resized as needed.
You can embed interactive Google Drawings in a Doc, such as a graphic organizer.
- Click "Insert" then "Drawing" then "New".
- Create your Drawing or copy and paste from an existing Drawing.
- Click "Save and Close".
- You can now double-click on the embedded Drawing to open and edit as needed.
🖼️ Topic #2 - Google Slides Tips
You can maximize the space in Google Slides for interactive activities.
- Hide the speaker notes.
- Hide the filmstrip.
- Hide the menu.
- Go fullscreen.
You can have your spoken words displayed live as subtitles during a presentation.
- Start the presentation as normal.
- Click the 3-dots button in the bottom left.
- Click "Captions preferences" then "Toggle captions".
- You can also adjust "Text position" and "Text size".
Publishing to the Web
You can share a link for your presentation that opens it in full-screen presentation mode.
- Click "File" then "Publish to the web".
- Click "Publish" in the pop-up window, and click "OK".
- Copy the link that is created.
- Share this link with others so they can view the slideshow in full-screen presentation mode.
📊 Topic #3 - Google Sheets Tips
Splitting Text to Columns
You can easily split text into multiple columns such as separating a full name.
- Insert extra blank columns as needed to hold the data.
- Select the column to split.
- Click "Data" then "Split text to columns".
- Select your separator.
- Your data will be split!
You can automatically color data based upon conditions such as grade values.
- Select the data you want to format.
- Click "Format" then "Conditional Formatting".
- Create your format rule.
- Select your formatting style.
- Click "Done".
You can use pivot tables to summarize complex data.
- Select the data you want to summarize.
- Click "Insert" then "Pivot Table" then "Create".
- In the pivot table editor add your "Rows", "Columns", "Values", and "Filters" as needed.
Post by Eric Curts
📮 Join the "Control Alt achieve" email discussion group
📰 Sign up for my email newsletter
🐦 Connect with me on Twitter
▶️ Subscribe to my YouTube channel
📧 Reach out through email - email@example.com
📗 Check out my "Control Alt Achieve" book
🏫 Bring me to your school, organization, or conference with over 60 PD sessions to choose from