Category: Google Sheets

Chromebook Challenge #hyperdoc

Inspiration
Inspiration #1
Over the summer, I was introduced to a new term/concept known as a #hyperdoc. You might say well isn’t a hyperdoc just a Google Document that has hyperdocs in it? Well, the answer is no. A hyperdoc is a document that has links to other artifacts, videos, articles, games, reviews, etc. Through these links students learn about a concept as well as share their own learning and thoughts with others. To learn more about #hyperdocs, and the work that Lisa Highfill, Kelly Hilton, and Sarah Landis have done, click HERE. I decided to make an attempt with creating a Chromebook challenge hyperdoc (even though it leans more on the side of students mostly learning information and not sharing as much information).

Inspiration #2
I was inspired to produce a Chromebook challenge after hearing about how Lee’s Summit R-7 School District created a Chromebook challenge for their students. Their great resource can be found on their technology website HERE. What I like about what they accomplished is that depending on the grade level, different tasks/reminders were given to the students.

Designing the Challenge
Seeing as though this is our second year as a 1:1 Chromebook school, I thought it made sense to do something similar at the high school level however I tried to gamify it a bit. I tried to keep the design of the challenge in mind when creating it as I did not want students to just watch a video explaining everything. I also knew I wanted to make it interactive and include some teachers in the challenge to put a smile on students faces. I also wanted to make it as easy as possible to follow along.

BHS Chromebook challenge was created using a Google Drawing. You can find the actual file HERE. You will notice that there are 8 different tasks for students in advisory to complete.

  • Chromebook Reminders
  • Chromebook Printing
  • Organizing Digital Life
  • Self Management
  • Chromebook Shortcuts
  • Planning Your Days
  • Google Classroom
  • Chrome Settings

The advisor decides the order of the tasks that they complete as a whole group. Whatever the task, the advisor follows along with the bulleted list. Tasks could involve students:

  • watching a video or two
  • looking over instructions in a Google Slide
  • playing a game
  • providing feedback in a padlet wall
  • organizing their own Google Drive
  • personalizing their own Chrome preferences
Documenting Tasks
Once an advisory completes a task, the advisor clicks on the master Google Spreadsheet link in the middle of the Google Drawing. This is where all advisors keep track of what has and has not been accomplished. The advisor finds their name and the turns the ‘red x’ to a ‘green check mark’. 
 
When all 8 tasks have been completed, the advisory earns a Chromebook challenge badge. Gamifying things makes learning that much more fun. 
As a side note, for every task an advisory completes, their name gets entered in for a free breakfast. There will be a winner for each grade level. Oh and the advisory has the entire month of September to complete the challenge.

Here is to learning while having fun at the same time…

Gamifying Professional Development – #GoogleSheets

This past semester Jess Gilcreast, our librarian, and I worked together in creating ways our staff could earn professional development hours besides sitting in a formal training. Our goal was to help create flexibility and adhere to different learning styles. One such way that we accomplished this was through offering professional development training through Gamification, using Google Sheets.

The Inspiration
This inspiration came from Bob Petitto. Not only was I impressed with the work that he had published on his blog, but I was also inspired by his Chrome in 30 Day activity that he put together. I appreciated the fact that he provided a way for his staff to learn about the Chrome browser on their own time by completing 30 different tasks. His original blog post on his 30 day challenge can be found HERE.

I also was inspired by the work that our Freshmen humanities teachers put together, Heath Ahnert, Steph Burnham, Krystin Cooney, Jess Hatzidakis, Steward Pepper, and Meg Uliasz. Their ultimate goal was to help students truly understand the process of researching and citing acquired information for a research paper. Thus, they gamified the task. Based on student decision on which specific tasks they completed, different items would appear with their explorer. The more challenges the students completed, the more elaborate items would appear, truly creating a ‘game’ out of learning. Such an awesome way for staff to connect with students. These teachers did great work and they came back stating that the students loved the activity.

Gamifying Professional Development
So, with the two above incidences, Jess Gilcreast and I put together our own activity that related to tech training we wanted our staff to know. The link to our Gamification PD Google Sheet can be found HERE. Feel free to use, we just ask that you please give credit.

Instructions Tab:
Instructions for the user explaining how to use the sheet. A video is even included for the user to help them with navigating through the Google Sheet.

My Badges Tab:
As the user completes tasks a certain badge will show up on their ‘certificate’. If a user completes all four tasks, all of them show up on their certificate, one in each corner of the certificate.

These were the four badges that Gilcreast created for the certificate. All done by using Google Drawings.

PD Tabs:
We offered four different opportunities for the staff: Chrome Browser, Researching w/ Google, Chrome Extensions, and Google Updates. In order for a staff member to receive a badge, they had to complete all tasks under that topic. You will also notice that a reflection section was added at the bottom of each tab. We wanted to know what their biggest take away from the activity was as well as any questions they still had that we could help answer.


NOTE: Some things might be outdated at this time as this was something we put together for Spring semester of 2016.

Benefits to this Type of Learning?

  • Staff learn at their own pace
  • Staff learn when they want to learn (learning should happen beyond the walls of the school – we hear this all the time with student learning so why shouldn’t it apply to our staff as well)
  • Staff are competitive

This was the very first time that I had done anything in terms of Gamifying. Not only did I have fun deciding what to include, I also gained a great appreciation for what Google Sheets can do for you. I also enjoyed collaborating with my librarian. I know that I have already said this but thanks for the inspiration Bob Petitto and Freshmen Humanities team. My hope is that in the future more staff in our school will take advantage learning in this format.

Flippity: Random Name Picker

There are lots of random name generators out there. They all have their advantages and disadvantages. However, in my mind, there is one that surpasses the others. Flippity.net has created their own random name generator. In four easy steps, you can have a great random generator at your finger tips. I will not replicate the process of how to use the tool as they are provided in clear step by step instructions on the Flippity website. Click HERE to follow the instructions.

I absolutely love this tool. With a click of a mouse or a tap on a track pad, you can immediately change a grouping or ordering of your students. This is a great tool for on the fly decisions as well as planned out activities. Below is a demonstration of my own roster of students and how quickly I can have Flippity change my preferences of groups or ordering my students.

Basically, you make a copy of a Google Sheet template that is provided on the Flippity website. You add the names of your students in class, then you publish the sheet to the web to get the link to your random generator. Then the magic happens and you have a useful tool at your finger tips. You will never have to recreate the process explained above as you just keep using the same Google Sheet for your class all year. (You can change the roster in the Google Sheet if need be – as we all know that your initial roster of students changes over the course of the year)

You will want a different Google Sheet for each of your classes. I would even recommend that you create a folder in your Drive, called Name Generator (or something similar), to place all of the Google Sheets that are connected to the Flippity random name picker. You can also bookmark the link to the random name generator for each of your classes as suggested on the website.

Flippity has some great resources. I have written a previous post on using their template to create a Jeopardy Game using Google Sheets. Click HERE to view that post.

If you have any questions on how to use this tool, you know where to find me. Guaranteed you will fall in love with this tool the moment you first use it.

Creating ‘Jeopardy’ Game in Google Sheets – Say What?

That is right. I just learned last week that flippity.net has a template for teachers and students so that they can easily make a Jeopardy Game. This is all done in a Google Sheet. Interested?

Check out the quiz that I made on random Google and Google Apps facts. I am sure that are some questions you might struggle with (no Google Searches folks!). CLICK HERE

Click HERE if you would like to see what the Google Sheet looks like for the game that I made. Feel free to make a copy for yourself to challenge others.

Why is it Great?

  • I love the fact that it will keep track of points for you, as well as hide questions that have already been answered. 
  • You can also open the quiz as many times as you want and don’t have to worry about clearing anything out from the time it was used before.
  • Teams can range from 2 to 6 

On the website flippity.net, it actually gives you detailed instructions on how to publish your quiz when you are done as well as get the right link that you need in order to create the quiz.

Check it out some time!