Starpoint School Coffee Hour: Technology Boundaries during COVID-19

I had the opportunity to speak to the parents and teachers at Starpoint School at TCU about strategies for creating boundaries around technology while kids are doing school from home during COVID-19. Every parent I know has expressed frustration with the drastic increase in screen time their kids are getting due to online school and more free time than usual. I talked to them about establishing rules, putting filters on the home network, and putting restrictions on individual devices.

Update on embedding Google Drive folders

As I have written about before, embedding Google Drive folders is a great way to manage content on your LMS. Rather than logging in, uploading, and waiting, you simply copy files into a folder on your computer, and they magically show up in your LMS for students to view.The only drawback was that last year Google blocked iFrame embedding on all Google Drive folders and Google Sites pages.

 

Thankfully, Wes Fryer posted about this same thing and I was able to get back on track using the following code.

List view <iframe src="https://drive.google.com/embeddedfolderview?id=FOLDER-ID#list" width="800" height="600" frameborder="0"></iframe> Grid view <iframe src="https://drive.google.com/embeddedfolderview?id=FOLDER-ID#grid" width="800" height="600" frameborder="0"></iframe>

Finding the Folder ID can be a pain, especially if you are trying to embed a folder within a folder within a folder. I tend to create folders for everything, so I have to make sure I use the correct Folder ID. For example, here is the URL for one of my folders that is nested 4 folders deep. I have color-coded each level of the URL (which has been slightly altered to keep the folder private).

https://drive.google.com/drive/u/0/#folders/0B5YVN51uO5e_ZHZlc3Zxd09pU3M/0B5YVN51uO5e_VlhYN1Q3MVoydjA/0B5YVN51uO5e_ei1aYmdFcW9EUWc/0B5YVN51uO5e_TFJkYzFhZ0ltbWs

The last sting of characters is for the folder I actually want to embed. I just need to copy that code and paste into the URL above where it says FOLDER-ID, like I did below:

<iframe src="https://drive.google.com/embeddedfolderview?id=0B5YVN51uO5e_TFJkYzFhZ0ltbWs#grid" width="800" height="600" frameborder="0"></iframe>

You can always change the width and height to make the folder fit the space on your page. The process is pretty simple, and once you have done it a few times, it's actually quite easy. Good luck!

Give students timely feedback with a leaderboard

Turning something into a game does not necessarily mean people will suddenly like it. Atari learned this the hard way with their E.T. video game. It turns out that betting the farm on a mediocre video game based on a blockbuster movie is bad business.

The same is true with gamification, a term being thrown around a lot these days in education circles. The general idea behind gamification is that game mechanics can be used in non-game environments in order to get some of the same outcomes typically associated with games, such as engagement, problem-solving, cooperation, and motivation. Many teachers are applying the principles of game mechanics to course design in order to motivate their students in ways traditional instruction does not.

If a teacher wants to be successful at implementing gamification mechanics in the classroom, there are a few principles that must be addressed. Foremost, the game must be well designed with clear goals, rules, and roles. Kind of like teaching. In my own experience, another aspect of a successful game (and teaching) is timely feedback. In order to make good decisions that help the player keep moving forward, they need to know where they stand. There are many popular activities that rely on the concept of leaderboards, which have the dual role of informing players where they stand and creating drama for both players and observers. Figure skating, gymnastics, X Games, freestyle skiing, golf, and diving are just a few of the sports that use leaderboards.

Leaderboards can be applied to educational settings as well, but there are very few tools available that teachers can use to create and use them efficiently. One such tool is Leaderboarded, but it is not free and seems be designed more for business than education. After looking around and not seeing many options for my own leaderboard, I decided to do what I do best: build one using Google tools. Below are the steps to help you get started on your own leaderboard. You can also view an example of my leaderboard spreadsheet, and feel free to copy it into your Google Drive if you want to see my formulas for each column and worksheet.

Step 1: Create your point structure

Before you can have a leaderboard, you have to decide where the points are going to come from. You have lots of options for students to earn experience points, quest points, or any other kind of value that can be added to the total. I kept it simple and based my point total on attendance and modules completed. Every time a student is on time to class, they get 100 points. They get 50 if they are late, and zero points for missing class. Even if the student is sick. I'm playing for keeps here, folks.

Step 2: Set up your spreadsheet

I have found that I am more likely to keep my leaderboard updated if I have very few values to keep up with. The more complicated the "game" becomes, the more there is to enter. Personally, once I start feeling overwhelmed I am likely to get behind on entering values. The more behind I get, the more irrelevant the leaderboard becomes. So, keep it simple.

As you can see from my example, I created a separate sheet for each set of points. One for attendance and one for modules. I used the SUM and COUNTIF functions to tally the values for each sheet. I chose to use the digit 1 instead of 100 or 50 because it is easier to enter. I can have the spreadsheet multiply by 100 on the Participation worksheet so I don't have to.

You will use the Participation sheet to add up all of your totals from attendance and modules. This worksheet is important to include because you will use a pivot table to create the actual leaderboard, and you must have all of your points on one sheet to do that.

Step 3: Create a pivot table

What is a pivot table, you might ask? Well, it is a data analysis tool built into most spreadsheets that lets you sort, add, average, or do other functions with the data in your spreadsheet. For this example, we are going to use the pivot table to display each student's total points and rank them from highest to lowest. Here is a screenshot of what this pivot table will look like when it is all set up.

Screen Shot 2014-06-20 at 10.05.54 PM

Leaderboard_Example_-_Google_Sheets_and_Pictures

Make sure every student in your leaderboard has a unique name, otherwise the pivot table will combine the totals for both students with the same name. I used numbers to keep the first initial separate. You will notice I have a battery icon for each student. I did this by creating a Rank worksheet and using the VLOOKUP function to apply the correct icon based on the student's total points. I did this more as an experiment. If you embed this spreadsheet using HTML, the images will not show up, so don't get your hopes up.

Step 4: Share the sheet with students

At this point, you have several options for how to share your leaderboard.

Option 1: The Whole Spreadsheet

The simplest option is to share the link with the class or embed using the iFrame code Google gives you. If you share the entire sheet with the class, which I DO NOT recommend, you will want to protect your functions and make sure it is only viewable to those with the URL. If you choose to embed the entire spreadsheet, go to File --> Publish to Web. This will share your entire spreadsheet, so you need to make sure there isn't any sensitive information that you don't want the whole class to see. If you use icons for levels like I have done, they will not show up when you embed.

Option 2: One Worksheet from the Spreadsheet

If you only want to embed the leaderboard, you can use a special URL to show only the page you want. It looks like this, and I will show you how to plug in the appropriate values.

<iframe src="https://docs.google.com/spreadsheets/d/[Spreadsheet ID]/htmlembed?gid=[worksheet ID]&amp;single=true" height="1000" width="100%"></iframe>

Here is where you find those values in RED:

Google_Drive_--_Page_Not_Found

 

This will embed only the sheet you want to share, but it will not show any images you have in the cells.

Option 3: Interactive graph from Spreadsheet

A final option for sharing the leaderboard is to create an interactive chart from the leaderboard and embed that wherever students will be looking for updated results. Here is how you do this:

Leaderboard_Example_-_Google_Sheets 2

 

Leaderboard_Example_-_Google_Sheets 3

 

Leaderboard_Example_-_Google_Sheets 4

 

Screen_Shot_2014-06-22_at_11_07_11_PM

 

Leaderboard_Example_-_Google_Sheets 5

 

And that is how you do it. This will take some tinkering, especially if you are not familiar with spreadsheet functions or pivot tables. I spent quite a bit of time messing around with this until I got it to work just how I wanted. I need to give credit where it's due for giving me this idea. I got the original idea from the EIPS Technology Blog, and I modified my leaderboard based on this design.

 

 

Are You a Technology Ninja or Samurai?


ninja-samurai

I will start by stating the obvious: There is a HUGE difference between learning to use technology for yourself and using it effectively in the student learning process. Both applications of technology have specific skill sets, they inform each other, and they are both important. In the educational technology world, you might see this dichotomy through various lenses: digital media literacy, TPACK, SAMR, or some other framework you're fond of presenting at conferences.

My awareness of the massive difference between these technology applications came when I began encouraging the students in my large, 100-person education course to bring their laptops, tablets, and phones. OK, I don't have to actually encourage college students to bring their phones to class. Pry them out of their hands? That's more like it. Anyway, once I began infusing my class with activities that require technology, I realized I am not as good as teaching with it as I thought I was. Yes, I knew how to do some cool things to present information to my class, but when it came to using technology in real time with 100 students in a way that kept them active and engaged, I had a lot to learn. This is when I decided I was a pretty good Technology Ninja, but I had a long way to go until I was a Technology Samurai.

What do these two terms mean? Let me explain.

Technology Ninja

Ninja were covert agents who specialized in espionage, assassination, sabotage, and infiltration. They were skilled at disguising themselves as servants, camouflaging themselves with trees and other objects, and scaling the walls of buildings like Spider-Man. Their objective was to infiltrate enemy dwellings without being seen. In fact, there is probably a ninja in your pantry right now, scooping out your peanut butter with a Chinese Throwing Star.

As a Technology Ninja, I have gotten really good at using technology in ways that my students hardly know it's there. My most recent set of posts about Outsmarting the LMS is a good illustration of ways to be a Technology Ninja. You can embed documents and web pages, install scripts, and set up forms to make your job easier, and the people actually using these tools have no idea about the magic you have worked on the back end. They just know it works.

While these ninjutsu techniques save me a lot of time and energy in the long run, they do very little to influence the lived experience of my class meetings. Most of the work is done in the background, usually in the form of tinkering, testing, and modifying. It wasn't until I told my entire class of 100+ students that I wanted them to bring their devices to class that I realized these skills were not sufficient for me to reach the level of technology greatness I have always aspired to achieve.

Technology Samurai

When I first began thinking through these ideas, I wrote this out as SAMRi. Get it? SAMR with a lower-case i, like Apple does, only at the end of the word instead of the beginning. Because I am aiming for the R (redefinition) in SAMRand after I achieve the R in my technology integration skills/knowledge, then I will be a technology SAMRi! Uh ... yeah. Anything that needs that much explanation is not as clever as I initially thought it was. Also, SAMRi would direct a lot of traffic to my blog by people looking for Saudi Arabian folk music.

So, what is a Technology Samurai? The traditional samurai were an elite class of noble Japanese warriors, dedicated to protecting their culture, leaders, and territory. Unlike those stealth and sneaky ninjas, they were skilled at hand-to-hand combat and infantry tactics. Their weapons of choice were swords, kama, longbows, daggers, and armor. They were skilled horsemen, and they were also known to use rifles and cannons in the latter years of their existence. Samurai were also governed by a strict honor code, characterized by discipline and loyalty. In a word, they were fearless.

You know what else is fearless? Telling your class to BYOD. Unless you have thought through the details of your activity, you will have students knee deep in Pinterest or Facebook before you can say, "OK, let me just try one more thing to get this to work." Students love technology, but not in the way nerds like me think they love it. They love that technology connects them to the things they love.

So, after having done this for a semester, I have started coming up with a few essential skills that every Technology Samurai must master. These skills/tools are focused primarily on teaching in a BYOD or 1:1 environment. I will address being a Technology Samurai in the areas of digital media projects, collaboration, research, etc. in the coming weeks.

Sync your class

You must have a way to get every student in the same place and keep them there. Your class LMS page won't work. Neither will a Facebook group or Schoology or Edmodo. Why? There are too many other features to look at. Grades, assignments, forums, friends. Too many distractors. You need to keep them all in the same place at once. I recommend a tool like Apollo or Top Hat. If all of your students are on iPads, you may consider NearPod. Each of these tools has something in common: they put your content on every screen in the room at the same time. Yes, students can stray away, but not as much as you might think.

Reduce Friction

This is something that took me awhile to figure out. Personally, I do not like logging in to things. I would much rather log in once and then have the tool remember me. Google, Facebook, Pinterest, Twitter .... they are great at this. My school's LMS? It's like Guy Pearce in Memento every time I close the browser window. Whenever possible, I try to minimize the number of times students have to log in to do class activities. Once is ideal, twice is acceptable, three times is just getting to be plain annoying.

Collect student responses

In addition to getting all of the students in one place, virtually speaking, you want to keep them engaged. A good way to do this is to involve them in activities that make them think then require a response. There are several tools that will let you do this. Apollo and Top Hat have built-in student response features. Socrative and Infuselearning provide another way for students to respond, and they do not have to set up an account to do it. They just enter the class code, and they automatically receive a prompt every time the teacher posts a question.

Deploy links

Another important tool to have in your arsenal if you are going to teach like a samurai is to be able to deploy links to the class. By deploy links, I mean send the student out from your synced content to other content (videos, web pages, forms, etc.). Apps like Apollo and Infuselearning have a built-in link tool that will send a URL to every student logged into your class page or presentation. This is really handy if you want students to spend a few minutes reading and discussing an article, blog post, video, or image. You can also send the students to an editable Google Doc, Sheet, or Presentation if you want to give them a place to discuss or share ideas.

An acceptable alternative to sending links to students is using a URL shortening tool, like bit.ly or goo.gl. Just remember to use a serif font so the students can tell the different between capital I and lower-case L. You may also want to consider if this is appropriate based on the size of the room and projection system, the age of the students, and number of times you are having them key in shortened URLs. If you have a bunch of these on the board, it may get confusing to the students.

Facilitate group work

Another skill to master as a Technology Samurai is to keep students engaged in group activities with their computers. I mean, the students have lugged their computers to class and followed along up to this point, so why not do some things with computers that computers are uniquely good at doing. Maybe that involves editing the same document at the same time, or adding slides to a common presentation. You can have them pin and explain places on a map.  Annotate or draw images using the drawing quiz tool in Apollo or Infuselearning. Create a 5-picture story, or capture a 30-second explanation on Educreations. I'm not trying to exhaust the possibilities here. If you went to the trouble to have the students bring their computers to class (or went to the extreme trouble of providing a device for every student in the school), then leverage the capabilities of a computer. Don't use it like a pencil then complain that students just want to look at Pinterest.

Showcase the students

Now that you have had the students doing some activities on the computer during class, showcase their work. Display their annotations and diagrams. Flip through the presentation and let each group present their page. Show the 5-pic stories and see if the students can guess the topic. Watch the 30-second explanations. This part of the BYOD learning environment is more than the payoff. It's the point in the lesson in which you communicate to your students whether you, as the chief learner in the room, value this activity as a real learning endeavor or just a hi-tech time filler. If you truly value the work they are doing, then devote time to acknowledging, praising, critiquing, and sharing the fruits of their labor. If you blow past the showcase, don't be surprised if the students show less enthusiasm and engagement the next time around.

You should strive to be both a ninja and a samurai. A samja. A ninjurai. A SAMuRinja. Both skill sets are important for teachers these days, for different reasons. One will keep you learning, the other will help you focus on student learning. The way of the ninja and samurai is not easy. They involve risk, uncertainty, failures, faith, persistence, patience, creativity, and problem solving. There is great cost in becoming a lifelong learner, but it's not nearly as costly as settling in and ceasing to grow and develop as a teacher.

So, what are your examples of being a Technology Ninja or Samurai? I will follow up on this, and I would love to hear your ideas.

Some Bullet Points and a Picture

As a teacher, I am always making instructional decisions. More often than not, these decision manifest themselves as questions. What do I want the students to know, understand, or be able to do at the end of my lesson? Who will do most of the talking, me or the students? Where does this lesson fit in the big picture of the class? Will I use technology? Will the students use technology? In addition to asking myself these questions, I am also continually looking for ways to teach better. That includes instructional strategies and technology. In some cases, the stars align and I discover strategies in which technology allows me to teach a lesson in a completely new way. For those SAMR enthusiasts out there, this would be R, or redefinition.

One such idea I recently came up with is an activity I call Some Bullet Points and a Picture (SBPAP). Yes, I have a dry sense of humor. This activity builds on the time-tested teaching strategy of having students work in groups and put their ideas down on chart paper. I love this activity, especially for class reading activities. I will assign an article, divide the class into groups, have them read a specific section of the article, then summarize and share their section with the rest of the class. This is a great way for the students to take ownership of the article and teach it to each other. It also gives them an advance organizer for when they go back and read it again for the exam.

SBPAP is the same idea as using chart paper, but the students summarize their group discussions on separate slides in a Google Presentation. I did some minimal setting up before class by creating the presentation, making it editable for anyone with the link, and creating a separate slide for each section of the article. The students then went to the Google Presentation, found their slide, and began summarizing their section of the article. The only two rules were 1) they had to paraphrase every main point in their own words, and 2) they had to find a picture that characterized their main points. The students used the research tool to find their images so they did not have to leave Google Presentation. Overall, the students loved the activity and we had a lot of fun seeing everyone's slides get edited at once.

There are some obvious advantages to doing this activity with a Google Presentation instead of chart paper:

  • The summaries are all in one place, so I can see which groups are making progress and who is not
  • Since the students are all working on the same presentation, I can project it and have each group present their ideas
  • The research tool allows the students to search for images, videos, quotes, charts, facts without leaving the presentation
  • After the activity is over, I can export the presentation as a PDF and post it to my LMS
  • The slides give me a record of what we covered in class, especially for students who missed and want to know if we "talked about anything important"
  • I don't have to figure out what to do with the chart paper after the activity is over

SBPAP was a great way to engage the students and have them actively learn the content. I will definitely do this again, and I may even think of some other ways to modify this activity and leverage more features of Google Presentation.

What are some innovative ways you have used Google Presentation in your classes to facilitate group work or engage the students?