Author: Mark Salzer

Typing Using Your Voice

Working on the go, or need to document something quickly? Use Google Docs Voice feature to do the work for you. Type using your voice in Google Docs!

Google voice features are everywhere. We use them every day across a range of our devices whether it be Google voice on our phones, Google Homes or even asking Google questions such as directions hands-free. But did you know, you can even use the voice feature in Google Docs too? Whether you’re working on the go, or just need to jot something down quickly whilst it’s fresh in your mind, Docs has got you covered.

Note: This feature only works on a Chrome browser. Make sure before you begin that your device has a built-microphone to be able to use this feature.

In Docs:

• Click > Tools > Voice Typing  (Ctrl+Shift+S)
• You’ll be asked to Allow or Block this feature > click > Allow
• You’ll see a grey microphone appear on the left hand-side of your Google Doc
• Select your chosen language from the drop-down
• Once you click the icon > it will change to an orange microphone icon
• Click > then start talking as normal, making sure to speak at a good volume and as clearly as possible
• Google Docs should then begin to type your spoken words

---

SYNC DATA FROM ONE SPREADSHEET TO ANOTHER

Save time by importing existing data into a new spreadsheet without having to copy it all again.

We often find we need to copy important data into more than one spreadsheet, but it can be tricky if the data is large and complex. Use this handy formula to important your data in minutes.

• To start, open up the spreadsheet or tab you want to copy to the new Sheet > copy the sheet’s URL
• Make a note of the cells you want to import
• Open the new sheet where you want the data to appear
• In the cell begin to type > =IMPORTRANGE (you’ll see the code as you begin to type)
• Type > quotation “ (very important) then paste the URL from the sheet and add another quotation mark at the end of the URL
• Then add a comma , > quotation mark again “ > then type the exact name of the specific tab you want to copy followed by an exclamation mark !
• Finally, type the range of cells you want to import eg: A1:A19 followed by “ quotation marks
• Press > Enter and your data will now appear in your new Sheet
  

Check out REMC’s winter learning opportunities and free virtual courses in this month’s REMC Connect.

Or simply click on either image below for more information and to register.

Check out EduPaths which now has 300+ FREE Professional Development courses (& FREE SCECHs) for educators.

EduPaths is a FREE professional development portal for ALL Michigan Educators. EduPaths courses are designed to expand understanding on a wide variety of topics and help educators share best practices. Courses are available online and are completely self-paced and intended to help educators personalize their own learning plan anytime and anywhere.

It is FREE to register for an account, and once registered you will be able to access an ever expanding set of FREE courses. Click the link to their November newsletter.

  Here’s a snapshot of the courses now available for SCECHs.

[This posting from Dearborn Public is worthwhile and applicable in our district too.] With the holidays fast approaching, a rise in phishing attacks is traditionally seen as well. Phishing attacks can be frustrating to deal with. The best defense is to not fall for them in the first place. Unfortunately, we are seeing phishing attacks become “better” (i.e. harder to detect) and more polished.

What Phishing Does

Phishing is an attempt to do one of two things

1. Tricking users into revealing their credentials.
2. Getting users to install malware.

Credentials

Quite frankly, your credentials are very valuable. For many of our users, district credentials lead to student information, lots of valuable district information and more. Plus, many users “reuse” passwords. So, learning a user name and password on one site can lead to the ability to log into other sites.

Protecting Against Phishing

We employ several strategies to prevent phishing attempts from ever reaching our users. However, even the best of all of these combined will not be perfect. Occasionally, phishing attempts will land in your inbox.

Tips to Identify Phishing Attempts

• Be suspicious of “odd” grammar and punctuation
• Be suspicious of “odd” wording
• You probably didn’t “win” a gift card (especially if you never entered a contest)
• Be wary and wise about contests
• Be aware of “urgent” deadlines
• Watch out for shortened URLs
• Look at where the link is actually taking you
• Carefully review the actual URL of the site that you are on

Spear Phishing

Spear phishing is targeted at specific individuals. Unlike phishing (which usually blankets a wide variety of users), spear phishing aims to trick high profile targets into giving up their credentials.

Preventing Becoming a Victim

It is important to prevent becoming a victim.

• Use the Tips to Identify above.
• Turn on 2-Step or 2-Factor Authentication (here’s how for your Google account)
• Use a Password Manager.
• Be suspicious (especially when on a mobile device).
• Instead of clicking on a link, enter the URL of a website that you want to visit (or use a known bookmark)

[Please note, the P-CCS Tech department will periodically send out training exercises or notes to help staff hone and heighten their skills to avoid falling victim to a phishing campaign.]

You can quickly create new files directly from your browser with “.new” domains for several Google products. For example, you can type “Cal.new” into your browser to create a new Google Calendar event.

The current “.new” domains are:

• Docs.new
• Sheets.new
• Slides.new
• Forms.new
• Cal.new
• Keep.new 
• Sites.new

Note, the above are not case-sensitive (Docs, dOcS and docs will all work) and you can type either the singular (doc, sheet, slide, form, site) or their plural (docs, sheets, slides, forms, sites) before the “dot” new.

Educator and author Larry Ferlazzo shared his 2019 picks of potentially useful Web 2.0 websites that are accessible, free, classroom appropriate and browser-based at his blog.  Interested educators may want to consider skimming his posting to learn a bit more about sites such as EduCandy (https://educandy.com/),  Fluent Key (https://fluentkey.com/), and FlexClip (https://www.flexclip.com/) as well as consider checking out his 2018 picks and bookmarking his site for revisit.

On October 8th Google announced that their app Grasshopper, created for students to use to learn to code, now can run in a web browser. The app/site has several courses designed to intuitively help someone build coding skills. Each lesson starts with an introduction to some vocabulary before moving into the coding lessons. Each lesson has a tutorial, a practice activity, and a quiz. You have to successfully complete each lesson before progressing to the next one. Grasshopper will save your work in progress.

For more information visit https://grasshopper.app/ and to start coding today on a Chromebook, Mac or Windows PC, browse to https://learn.grasshopper.app/

Last May (2019), all Google EDU account holders around the world that had YouTube Brand accounts were notified by Google that their YouTube Brand accounts would be deleted a couple of months later, in July 2019. While worldwide millions received that notice, in our district it was ~60 staffers and ~2400 students. Google later decided to instead suspend EDU Brand accounts in July and only outright delete them this coming November (2019). For the ~60 P-CCS staff, the Technology department submitted online forms necessary to obtain a temporary one year extension (until July 15, 2020) from suspension / deletion of their Brand accounts. Student brand accounts were not eligible for any extension and were suspended this past July.

One major result of the account suspensions that were not foreseen by Administrators or Google, is that if a user had configured their Brand account to be the default account to use when signing into YouTube, they could not view YouTube videos at all until they changed the default channel by selecting the box under “Settings > Advanced Settings” within YouTube.

If you encounter any students unable to view YouTube, please let them know the following:

Affected student users need to sign-out of Google (or delete their cookies) then navigate to youtube.com/channel_switcher and sign in again, remembering to change the default channel once they sign-in. Once this has been done on one device, it will fix the issue on any of their other devices.

Some students might find it easier/possible, to simply delete their Brand account by browsing to  https://myaccount.google.com/brandaccounts and deleting the Brand account. Once deleted, they should be able to again log into YouTube.

For those interested, especially those staffers with Brand accounts and a one year extension, guidance on content retention as well as more background on the situation can be found here.

 

 

 

If you think you might have missed an email sent to a group that you’re a member of, head to groups.google.com, click on My Groups, then find and click on the name of the group and in most instances a page will open listing past email messages to that group.

At Groups, you can also adjust how emails are sent to you for each group for whom you are a member by clicking the down arrow to the right of “Every new message” found on the right hand side of the landing page: 

Note, some groups are set to show who are their members; others are not. If set to show, click on “Members” to see a list along with the date they were added/joined the group.

This and more can be explored by visiting groups.google.com.