Stream

Join this community to post or comment
Pinned by moderator

Bill “Lewis” Pier
owner

Introductions  - 
 
PLEASE NOTE: This Community is NOT a Support Forum.
This Community is about SHARING features, uses, capabilities, etc., using G Suite for Education services.

There are many Google and Community Support Forums available for problem resolution and diagnostic help on Google products and services.

G Suite Help Forum https://goo.gl/mK9Om6
Google Product Forums https://goo.gl/U7rQi3

While many participants in this Community will gladly help, it isn't anyone's "job" here to resolve G Suite service problems.

There is also a nifty Search feature on the sidebar to search the content of all of the posts in this Community -- please use it before posting a question.


Thanks.
30
1

Barrie Roberts

Drive, Docs, Sheets, Forms, Slides, Keep  - 
 
Google Sheet Functions-QUERY
The last in my series on GSheet functions, the wonderful extremely powerful QUERY function. Filter, sort, and analyse your data with ease, all with just one function.
https://bazroberts.wordpress.com/2017/01/11/google-sheets-functions-query/

The QUERY function is in a category all on its own. It’s an extremely powerful function that will let you filter, sort, group, pivot, basically extract data from a table and present it in num…
2
Add a comment...

Charly Choi

Devices: Chromebooks, Tablets, etc.  - 
 
How to manage Chromebooks in School Companies have not had a positive view of Chromebook. In recent years, however, businesses have changed the perception of Chromebook. According to the IDC report, there are predictions th...
1
Add a comment...

Kathi Smith

Calendar, Tasks  - 
 
Was just reading at this site about how flights, concerts, restaurant reservations can be automatically added to a Google calendar. Can others tap into that functionality - or is it a special script/API, etc. provided by those businesses? Would love to automatically throw some events on staff member's calendars.
Thanks - Kathi
3
1
David Bayne's profile photoKathi Smith's profile photo
2 comments
 
thanks for the info. I have used Event-o-Matic to send calendar dates from a form. That seems to work very well.
Add a comment...

Nathan Gildart

Search, Maps  - 
 
Maximizing Google Search Part 4 - Find Information Faster. More ideas from Google's self-paced Powersearching course. Teachers and students can learn to refine their search to get more focused information. (https://goo.gl/aV2WGq) This is by no means comprehensive, but a good starting point. Copy the linked Google slides deck and share with students and colleagues. It includes Google News, Newspapers Archive, Google Scholar. Docs Research Tool & Translate, Google Books, Google Trends and more!
4
Nathan Gildart's profile photoRoper Ropes's profile photo
3 comments
 
Yes it's very useful 
Add a comment...

Stephen Long

Admin Console, Accounts, Analytics  - 
 
Don't forget to check out our latest video for Admins, this edition covers iOS MDM, Gmail Bounce Messages and a 2016 Year In Review. #GSuite #Admin https://goo.gl/yMsOaY
1
Add a comment...

Michael Poke

Going Google (Edu)  - 
 
Due to so much highly positive feedback, I've compiled my three guides to the absolute basics of G Suite for Education, Google Drive and Google Classroom into one simple website.
https://sites.google.com/view/theabsolutebasics/
28
6
Michael Poke's profile photoRoland Rios's profile photo
6 comments
 
Thanks +Michael Poke. Changes will be slight (adding student presenter names, our contact info, etc.) Most of the session will be hands-on for the attendees. 
Add a comment...

Kasey Bell

Sites, Blogger  - 
 
The New Google Sites: The Good, The Bad, and Nothing Ugly!

Here’s the lowdown on the New Google Sites: The Good, The Bad, and Nothing Ugly! As I mentioned in an earlier post, There’s a New Google Sites Coming, what is now being referred to as the “classic” Google Sites was long overdue for an update. I usually referred to Google Sites as an acquired taste because it was so antiquated and most users are turned off within the first few minutes of trying it. However, “classic,” sites was and is still a powerful tool for teachers and students. The new Sites is slick and beautiful, and very easy to use, BUT it is still missing some of the features that make the “classic” sites so powerful.

Both classic sites and the new Google Sites are available now, so to help you decide whether you are ready to make the leap to the new Sites. And given that the new Google Sites biggest strength is the beautiful design, I am breaking this down into The New Google Sites: The Good, The Bad, and Nothing Ugly.
Pinterest The Lowdown on the New Google Sites Here’s the lowdown on the New Google Sites: The Good, The Bad, and Nothing Ugly! As I mentioned in an earlier post, There’s a New Google Sites Coming, what is now being referred to as the “classic” Google Sites was long overdue for an update. I usually …
6
3
Add a comment...

Evan Walter

Pedagogy & Research (GAFE context)  - 
 
Check out this weeks Tuesday Teacher Tips! https://goo.gl/f36Hjz
4
Add a comment...

Eric Curts

Drive, Docs, Sheets, Forms, Slides, Keep  - 
 
5 Emoji Learning Activities with Google Docs http://www.controlaltachieve.com/2017/01/docs-emoji-activities.html
See how to use emojis in Google Docs for fun student learning activities in all subjects including writing summaries, making a rebus story, exploring character emotions, using as variables in math, and creating pictographs. Includes detailed directions, examples, and templates.
Use emojis in Google Docs for five fun learning activities for students.
4
2
Judy Bowling's profile photo
 
Thank you for sharing!
Add a comment...

Jacob Bendixen

Drive, Docs, Sheets, Forms, Slides, Keep  - 
 
I'm setting up a Digital Hall Pass Log for my school. The basic function of the form is identifying the student, where they're going, and when they come back to class. It is filled out both when they are leaving and returning to class. Right now, I'm trying to simplify the responses page so that the Hall monitors have an easier time identifying students who are wandering the halls for a bit longer than they should. Since this will soon be implemented school wide, the responses are going to get a bit overwhelming to keep track of at certain times of the day. Are there any suggestions on how to create a separate sheet that filters the responses based who has filled out the form to leave class but hasn't yet filled it out to come back? Or any other suggestions to add to it?

Here's what I've done so far...
-Responses show up on a separate sheet that filters responses for the current day with the most recent appearing at the top.
-The room number that the student is departing from automatically displays based on which account was used to fill out the form (each room will have a unique account for the chromebook and the form will collect email addresses which are interpreted as the corresponding room number on the response sheet.
-Responses of Leaving or Returning have a unique color coding for easy identification.
4
Martin Molloy's profile photoJacob Bendixen's profile photo
17 comments
 
+Martin Molloy Thank you! I'll just need access to see it. I've sent a request for access.
Add a comment...

Patti Kitts

Sites, Blogger  - 
 
Getting ready to work with 8th grade Social Study Students using the New Google Sites and I would like to show our students some samples of websites created by other students. If you have one you would like to share with me, I would great appreciate it. Any content area would be great!
1
Dean Stokes's profile photo
 
This was made by me rather than a student but should give an idea of what's possible: sites.google.com - Dean Stokes

I was attempting to recreate my website built in HTML - www.deanjstokes.co.uk

Here's a video going through some of the process: https://youtu.be/rSvnWUiCiFc
Add a comment...

Eric Curts

Drive, Docs, Sheets, Forms, Slides, Keep  - 
 
Make Sequencing Questions with Google Forms http://www.controlaltachieve.com/2017/01/forms-sequencing.html
Use Google Forms to create randomized sequencing questions where students have to put the items in the correct order.
Use Google Forms to create randomized sequencing questions where students have to put the items in the correct order.
8
5
Add a comment...

Zacha Ortiz

Pedagogy & Research (GAFE context)  - 
 
I am a first grade teacher in Atlantic City, New Jersey. I am looking for a first grade teacher in California that wants to pen-pal with my student. We can scan our letters and share them on google drive. We can also collaborate on a google slides presentation!

My class chose California as their state to represent and learn about for our annual Multicultural Day this year. 
1
Add a comment...

Paul Gaffney
moderator

Google Classroom ( the service)  - 
 
4 Hidden Features of Google Classroom !!
In this post EdTechTeacher Instructor Ben Sondergroth demonstrates some organizational hidden features of Google Classroom like Calendars and Chrome hacks.
7
3
Add a comment...

Charly Choi

Admin Console, Accounts, Analytics  - 
 
Key policy settings for Chrome Device Management If you're using a Chromebook in a company or school that uses G Suite / G Suite for Education, you may be confused by the difference between user settings and Chromebook de...
2
1
Add a comment...

Nathan Gildart

Search, Maps  - 
 
Working on a 5-part post on Google Search, highlighting useful tools. Feel free to copy and modify. I encourage taking the course. Based on Powersearching with Google (https://goo.gl/ueEQ8) free, self-paced course. First few are here:

Maximizing Google Search Part 1 - The Basics
https://goo.gl/SgxhKz

Maximizing Google Search Part 2 - Understanding What You Read
https://goo.gl/w8GrjM

Maximizing Google Search Part 3 - Using Advanced Search Techniques
https://goo.gl/T1L9W4
5
2
Add a comment...
 
updates coming:

+Hiding low-quality comments
+less white space and more posts
+Bringing back Events

From better commenting, to showing you more of what matters, to bringing back Events, we’re making a bunch of improvements to Google+ based on your feedback.
4
1
Michael O'Shaughnessy's profile photo
 
All good things!
Add a comment...