Most people are not too familiar with Google Tables. It is a database that lets you keep records on tables and then lets you make associations from data on one table to another table. Here are some real world examples of what Google Tables can do for you or your school.
Keep inventory of all your devices
Create a ticketing system so people at your school could request IT (or any) help
Organize a convention – You could organize all the speakers and who will be attending their workshops and also organize all the attendees and have all their schedules at the tips of your fingers
In fact Google has a number of templates that you can use right away. They have those mentioned above but also booking rooms/shared spaces, project management, creating a directory, new employee onboarding and more.
How did I not know about this?! If you’re like me, then you rarely have more than 10 tabs open at a time. However, not everyone is as . . . considerate to their computer as I am. I have seen colleagues of mine have anywhere from 30-50 tabs open and not feel shame!
I know each browser has there own way of managing lots of tabs and there are more than a few extensions out there that can help people as well. Since my school uses Google, it only makes sense for me to use Google Chrome, plus I like all the extensions they have to offer, but this feature is built right into the browser itself. No need to install anything else or create an account with a third party. Just open tabs up and group them!
There are a lot of people out there using the Google Classroom app. We have encouraged our parents to log into the app as their child. That way they can see what their kid sees and have a real understanding of what is happening in the classroom.
A question we have received is “What do I do if I have more than one child?” or “How can I view all of my children’s Google Classroom assignments and materials? These are good questions and while it is pretty easy, it may not be the most obvious thing. Continue reading “Google Classroom and Multiple Accounts”→
I’ve developed a very flexible solution with iPads and some ergonomic tools/devices.
The main goal was to have tech that was useful all the time, not just during quarantine, and tech that didn’t strain the network with video standards that can’t be handled by personal home networks. The investment would be useful for 3-7 years, or the duration of the equipment lifecycle. The tablet form factor I chose was the iPad, but this could be done with Android or Chromebook tablets.
This model eliminates document cameras, allows for hand writing on paper or real whiteboards, allows for digital whiteboards, and you can ergonomically adjust things so people feel like they are sitting next to someone.
Teachers can freely move around the room to demonstrate labs and other experiences that are eliminated in most virtual scenarios.
You can even do choir, band, and art.
If teachers/hosts have laptops, this allows for two cameras in every space. Students can flip between the iPad and the host device.
The conferencing software doesn’t matter. You can use anything for your video conferencing.
If people need to work from home they just take the iPad, and literally replicate their teaching environment.
This idea can be summed up in a single simple statement: The iPad is a Person in your Classroom.
If you would like to know more, please complete the form below.
The Pear Deck add-on is very popular amongst teachers. It allows them to bring interactive elements into their Google Slides presentation. Check out the video above to get a better sense of what Pear Deck offers and whether or not it is right for you.
Not too long ago, Google announced a bunch of really handy short URL’s that will let you create new types of files. I wrote about it here. For a quick refresher, here they are:
docs.new = New Google Doc
sheets.new = New Google Sheets
slides.new = New Google Slides
Now there is one more to add and if you read the title, this will be no surprise. If you type cal.new, it will create a new calendar event. It is super handy.
Of course you must be logged into a Google account for this to work. So, if you don’t use Google or your school uses Office 365 or some other system then you can forget you ever read this post.
For me this is a big convenience. Most of my calendar events are appointments or meetings with other people. When you create a new event the old fashioned way of actually going to the calendar and clicking on the day you want an event. Here is what you get.
I want more options than what is there. I just do. I like to add notes, link to other Google Docs that are necessary for the meeting or maybe just a joke to lighten the mood (my meetings can be unnecessarily serious).
OK – to be fair, you need Google Sheets and the Flippity add on, but still, this is pretty handy, easy to do and works really – really well. I’ve seen a couple of articles about this on the web but I’m going to go a little deeper and walk you through from start to finish.
In this example, we will be doing some language learning though I can think of this being used for math problems and vocabulary as well and much, much more. So let’s get started.
Google Translate in Sheets
The first thing we need to do is open Google Sheets and get ready for some magic! We will be translating words from English to Spanish. I will be using specific words and not phrases. As we all know translating longer pieces of text can sometimes lead to unexpected results 🙂
As you can see, I have 10 English words about the Spring season. I could look these up, but I will let Google Translate do it for me.
In cell B2 I will type this formula which will translate it from English to Spanish automatically.
=googletranslate(A2, “en”, “es”)
So let’s break this down. =googletranslate will let Google Sheets know that it needs to use Google Translate – pretty straight forward. Don’t forget the comma!
A2 tells Google Sheet where the word is that needs to translated.
“en” (yes you need the quotations) lets it know what language the original language is.
“es” (again don’t forget those quotes) let’s it know what it needs to translate it to. (ES = Spanish by the way)
So this is what it will look like.
Now all we need to is move your mouse to the bottom right hand corner of cell B2 (it should turn into a + sign) then click and drag down like in the GIF below.
Google Sheets (any spreadsheet program really) understands the pattern and automatically replicates the googletranslate formula all the way down properly changing the cells as needed.
Now we are ready to turn this into interactive flashcards
The next thing we need to do is get the Flippity add-on. To do this open a blank Google Sheet and then click on Add-ons from the menu bar. Then select Get Add-ons.
A new window will pop up and from here search for and add Flippity to Google Sheets. You only need to do this once. After you’ve added it, every new Google Sheet you open will have the ability to utilize the Flippity add-on if you want it to.
To activate the Flippity add-on, click on Add-ons and select Flippity and select Pick a Template.
The template you will want to chose is, surprise – surprise, Flashcards. Go ahead and click Use.
Flippity will do some magic and then create a new worksheet with whole bunch of info that you do NOT want.
Do not be alarmed. This is merely an example of how and where to put your data. So go ahead delete all of their information and copy and paste your data. Your data will be on another sheet (probably called Sheet 1 like mine). You can find this at the bottom of the page.
You may also notice that you can customize the flashcard color and the text color. This is not necessary but a nice touch. Here is my finished flashcard spreadsheet.
To get to the flashcards, click on Add-ons, select Flippity and then select Flippity.net URL.
A pop up will appear with a web address. You can click that and it will take you to your very own custom made flashcards!
You can also check out my flashcards and get your Spanish learning on!
You can do this on Quizlet, but I find the translation part much faster with Google Sheets and with the URL you can easily share out your flashcards with multiple people and there is no need for an additional account (though you can sign into Quizlet with your Google ID) tp sign into.
All in all – this took me around 5 minutes to make and I think you can make this as large or as small as you would like – have fun with it! It could be a good activity for a class or a group of students to help study and quiz one another.
Flippity can also make some other cool things like a Jeopardy so be sure to explore and see what else you can do with Google Sheets and Flippity.
When it comes to Google Sheets, small mistakes in the formula can lead to big errors so it is always good to double check the translation and make sure that it is indeed correct.
I had teacher walk into the IT office with a good question. She wanted to make a slideshow about a topic and have each student in her room create one slide to add to the slideshow. Here is what you need to know.
She is using Google Slides
This is 4th Grade
She didn’t want students modifying or messing around with other slides
4th grades don’t always make “wise” choices
OK – now you are caught up and messing around here is what we stumbled upon. I don’t think this is a new feature but it was one that I was not aware of. Before we get to the solution here is what first sprung into our minds.
She would have one slideshow on her Google account and she would share it with one or two at a time and then once their slide was done, she would take away their permissions and assign new students. Or she could just let them work on a computer that is signed into her account under her supervision as they directly added it with no sharing at all.
Obviously this is extremely cumbersome and not very manageable unless you were dealing with 4–6 students, so this would not work
Loads of slideshows and some manual labor
Each student would make their own and then they would share it with her. She would then cue up a bunch of different slide shows to show or she would re-create the slides on her own slideshow.
Again, lots of work and not very practical. I can hear you, the good reader, screaming at the screen now about copy and pasting.
The best solution
So the teacher make one slideshow to rule them all. Then each student makes their own and shares it with her. She will then copy and paste the slide(s) necessary from the student slideshow to the teacher slideshow. So check out the overly simplistic screenshots below.
So, what our teacher needs to do is copy the slide from the thumbnail view. Click the thumbnail and then copy it (ctrl+c or cmd+c or right click and select copy). Then once it is copied go to the teacher slideshow and paste it in the thumbnail area. When you do this, you will see an option to link the slide or not to link the slide.
I went ahead and chose to link the slides. When I do this this little icon shows up on that particular slide on the teacher slideshow.
Now here is why this is cool. Let’s say Student #1 decides to add a little more info. Maybe a picture in this case.
Now let’s check back with the teacher’s slideshow and see what has changed.
As you can see – very little has changed, but when you look at Student #1’s slide you will see that it says UPDATE near the top right hand corner.
So when the teacher clicks it the slide will update with the latest changes. Very, very cool.
Now, let’s say a fourth grader shares this with their “best” friend who decides it would be hilarious to replace the computer picture with a funny picture and then the teacher hits update. All the teacher needs to do is hit Undo (ctrl+z or cmd+z or hit the Undo button) and the latest changes will be undone. Simple as that.
So, if you’re ever in this situation of making a single slideshow based and want the class to contribute then give this a go. It seems to work very well.