browser icon
You are using an insecure version of your web browser. Please update your browser!
Using an outdated browser makes your computer unsafe. For a safer, faster, more enjoyable user experience, please update your browser today or try a newer browser.

Tagged With: google apps

169 Tech Tip #59: Alt Keys

tech tipsIn these 169 tech-centric situations, you get an overview of pedagogy—the tech topics most important to your teaching—as well as practical strategies to address most classroom tech situations, how to scaffold these to learning, and where they provide the subtext to daily tech-infused education.

Today’s tip: #59–Alt Keys Add Symbols

Category: Google Apps

Sub-category: MS Office, Webtools, Keyboarding, Problem-solving

Q: How do I create the copyright symbol (or another symbol) in Google Apps or Word?

A: It’s easier than you think. Hold down the Alt key and press 0169. ©. Use the keypad with the num lock on–don’t use the number row. I could not get this to work until someone pointed out that you must use the keypad. Duh.

Have students try out some others that would be useful for them. For example:

Alt+0191 = ¿

Alt+0128 = €

Alt+0169 = ©

Alt+137 = ë

Alt+0247 = ÷

Alt+155 = ¢

Alt+241 = ±

This is a fun activity for December’s Hour of Code. It works in Office and Google Apps, as well as lots of other places, like my WordPress blog. Cool, huh?

Here are Alt Key suggestions for:

Sign up for a new tip each week or buy the entire 169 Real-world Ways to Put Tech into Your Classroom.


Jacqui Murray has been teaching K-8 technology for 20 years. She is the editor/author of over a hundred tech ed resources including a K-8 technology curriculum, K-8 keyboard curriculum, K-8 Digital Citizenship curriculum. She is an adjunct professor in tech ed, webmaster for four blogs, an Amazon Vine Voice reviewer, CAEP reviewer, CSTA presentation reviewer, freelance journalist on tech ed topics, and a weekly contributor to TeachHUB. You can find her resources at Structured Learning. Read Jacqui’s tech thriller series, Rowe-Delamagente, and her upcoming historic fiction, Born in a Treacherous Time.

Categories: Keyboarding, Problem solving, Tech tips | Tags: | 1 Comment

169 Tech Tip #112: How to Open 2 Gmail Accounts at Once

tech tipsIn these 169 tech-centric situations, you get an overview of pedagogy—the tech topics most important to your teaching—as well as practical strategies to address most classroom tech situations, how to scaffold these to learning, and where they provide the subtext to daily tech-infused education.

Today’s tip: #112–How to Open 2 Gmail Accounts at Once

Category: Email

Sub-category: Google Apps, Classroom management

Q: I have a home Gmail account and a school one. How do I open both at once so I can keep track of what my kids/home business/etc. is doing while at my teaching job?

A: I got this quick answer from efriend and tech guru Chris Hoffman: Open each account in a separate browser.  It has to do with each browser keeping its own cookie.

Stepping back a moment, here’s why you might need this:

(more…)

Categories: Classroom management, Tech tips | Tags: , | 1 Comment

169 Tech Tip #69: Instead of Emailing, Share

tech tipsIn these 169 tech-centric situations, you get an overview of pedagogy—the tech topics most important to your teaching—as well as practical strategies to address most classroom tech situations, how to scaffold these to learning, and where they provide the subtext to daily tech-infused education.

Today’s tip: #69–Instead of Emailing, Share

Category: Email

Sub-category: Internet, MS Office, Google Apps, Parents

Q: I want to share a class video with parents, but the file’s too large and I don’t know how to embed it into the class blog. What can I do?

A: Share it with Google Drive or Microsoft’s OneDrive. In fact, you can share from any cloud-based file folder including Dropbox and Box.

(more…)

Categories: Google, Parents, Tech tips | Tags: , , | Leave a comment

How to Use Google Sheets in the K-12 Classroom

google sheetsNothing turns data into information like a spreadsheet. We as teachers understand that, which is why spreadsheets are a fundamental tool to critically analyze any data that includes numbers. There are many options (Numbers, Excel, and Open Office to name just a few), but arguably the most popular is Google Sheets. If you’re using Google Classroom or G Suite, you already have it. That means there’s no separate log-in required, no unique password for students to forget, and no special install required to push it out to students. It’s right there, as part of the education package.

Most spreadsheet programs have similar options, so what characteristics make Google Sheets stand out? Read on.

Pros

The most common positives mentioned by users are:

  • You can collaborate with friends and colleagues.
  • You can share the spreadsheet as an embed, either with viewing privileges or editing ones.
  • It can be synced across all devices, whether at home or school.
  • It works on all digital devices whether it’s a Mac, Windows, Chromebook, or iPad.
  • It provides a revision history, allowing you to scroll back to a better version of your work and/or track the contributions of collaborators.
  • It includes a chat window where collaborators can discuss their work before changing the spreadsheet.
  • Because Sheets is part of Google, it easily imports data from other Google Apps. It also exports nicely to the increasingly broad group of partners who work with Google Apps.

One more that I list as a Pro, but could be a Con: Sheets is easier to learn (that’s the Pro). The reason is there’s less to learn (that’s the Con). It focuses on the most popular functions, not the depth of need. If you’re a lite user of spreadsheets, this will serve you well, but if you are moderate to advanced, you may struggle to find the tool you were used to in Excel — if you can find it at all. For example, pivot tables are strictly an Excel tool.

(more…)

Categories: Reviews, Spreadsheets | Tags: , | 1 Comment

169 Tech Tip #20: How to Add a Link to MS Word

tech tipsIn these 169 tech-centric situations, you get an overview of pedagogy—the tech topics most important to your teaching—as well as practical strategies to address most classroom tech situations, how to scaffold these to learning, and where they provide the subtext to daily tech-infused education.

Today’s tip: #20–How to add a link to MS Word

Category: EDIT/FORMAT

Sub-category: MS Office, Google Apps, Keyboarding

Q:  I want to link a resource in Word/Google Docs to a website. How do I do that?

A:  Follow these easy steps:

  • Go to the website you want to link to.
  • Copy the address from the address bar (Ctrl+C or Edit>copy from the menus).
  • Return to your doc (it’s waiting on the taskbar at the bottom of the screen or simply click Alt+Tab).
  • Highlight the words you want to link to the website.
  • Press Ctrl+K; press Ctrl+V; push enter.
  • The words turns blue with a line under them, showing it’s a link.
  • To use the link, Ctrl+click on the words.

There are sophisticated options that go along with adding links, but this is quick and easy.

(more…)

Categories: Tech tips, Word processing | Tags: , , | Leave a comment

How to Use Google Apps

Here’s a collection of Ask a Tech Teacher articles addressing individual Google Apps:

Google Docs

Google Drawings

Google Forms

Google Hangouts

Google Keep

Google Voice

This isn’t meant to be comprehensive. Yet. If your favorite Google App isn’t listed and you’d like me to review it, fill out the form below:

(more…)

Categories: Web Tools | Tags: | 2 Comments

How to Use Google Drawings

google appsGoogle Drawings is a free, web-based drawing tool that allows users to collaborate and work together in real time to create flowcharts, organizational charts, website wireframes, mind maps, concept maps, drawings, and more. It is included in GAFE, Google Classroom, G Suite, and Google Drive (this may vary in managed domains, depending upon whether the administrator turns on access to this tool).

To use Google Drawing, here’s what you do:

  • Open your Google Drive account; go to New and select Google Drawings. 
  • Insert shapes, lines, an image, or text with the editing tools.
  • When finished, add this drawing to another Google Doc, slideshow, or spreadsheet, save it as a stand-alone file, and/or share it with others in a wide variety of methods. 

There are a lot of drawing programs available — SumoPaint, KidPix, and TuxPaint to name a few. All wonderful in their own right. So why use Google Drawings instead of a tool you are already familiar with? Here are seven reasons:

  • it’s collaborative
  • projects are easily shared with teacher 
  • it can be used at home and school — and synced between the two locations
  • it is minimalist — the project is easy to find in the student’s Google Drive (if they attend a Google school). No tracking it down and wondering, “What tool did I use to create this project?”
  • changes or edits are easy to add — just open the project in Google Drive and edit
  • project can be embedded into student digital portfolio or class gallery
  • project can be downloaded as an image file, a vector graphic, or a PDF

Be aware: Each drawing program mentioned above may have some of these, but few have all. Except, of course, Google Drawings.

Here are eight projects that are perfect for Google Drawings:

(more…)

Categories: Reviews | Tags: | 1 Comment

How Google Docs Improves Writing

google docsGoogle Docs is a free word processing program that does 99% of everything a student will ever need to do when writing. What isn’t included as part of the Google Docs program tool can be augmented with mostly free third-party add-ons, extensions, and apps. It operates in the cloud so there’re no download foibles, pesky maintenance, or expensive yearly upgrades. The end result is a learning tool that is powerful, robust, scalable, and because it’s free, is the equitable solution to so many concerns over education’s digital divide.

It’s no surprise that Google Docs and its sister programs — Google Spreadsheets, Google Slideshows, Google Draw, and Google Forms — have taken education by storm, usually in a package like Google Apps for Education (GAFE) or Google Classroom. While it does have a moderate learning curve (no worse than MS Word), once traveled, teachers quickly adopt it as their own and find many reasons why this has become their favorite tool. Here are the top eleven reasons from the educators I talk to:

Always up

I’ve never had the experience of logging into Google Drive (where Google Docs live) and having it not open. On the other hand, I have often experienced that heart-stopping occurrence with MS Word when it suddenly won’t work or a Word file has become corrupted for no reason I can tell. Using Google Docs has probably added years to my life just in the lowered stress levels.

(more…)

Categories: Writing | Tags: | 2 Comments

How to Use Google Forms in the Classroom

google formsThere are lots of free survey and polling sites (two popular options are PollDaddy and Survey Monkey), but often they limit the number of surveys you can create or how many questions you can include without ‘leveling up’ to a premium version. Among the teachers I know who are always looking for ways to save their limited pennies, Google Forms is a run-away favorite. It is intuitive, flexible, professional, can be adapted to school colors and images, and can be shared as a link or an embed. You can work alone or with colleagues and there are a wide variety of options that tweak the form to your needs.

Using available templates, a customized form can be completed in under five minutes. Responses are collected to a Google Spreadsheet that can be private or shared with participants and can be sorted and analyzed like any other spreadsheet.

Google Forms integrates well with Google Apps for Education, Google Classroom and many LMSs such as Blackboard.

How to use it

Google Forms is simple to use. Just follow these steps:

(more…)

Categories: Teacher resources, Tech tips | Tags: | 14 Comments

9 Google Apps Tips You Don’t Want to Miss

gafeHere are the top 9 nine Google Apps tips according to Ask a Tech Teacher readers:

  1. Embed a File from Google Drive
  2. Google Apps lesson plan
  3. 8 Google Apps Tricks Every Teacher Should Know
  4. Google Hangouts–Are You Using Them Yet?
  5. How to Embed Student Work into Digital Portfolios
  6. Book Review: Google Apps Meets Common Core
  7. Dear Otto: How do I teach Google Drive to K/1?
  8. Google Gravity
  9. Google Apps Support Bloom’s Taxonomy–Take a Look

(more…)

Categories: Google, Teacher resources, Web Tools | Tags: , | Leave a comment