Strength of Weak Ties and your PLN

Intuitively, the benefits of connecting with educators with similar goals and interests makes sense. I don't have the solution to every problem I might encounter as a teacher, but I probably know people who, collectively, do. If I want to try a new kind of student project or learning activity, I can probably find someone who has already done it and learn from their experience. According to Bandura, Vygotsky, and Dewey, the social element of learning is an integral part of the process. As humans who are perpetually learning, growing, and becoming, our social networks are invaluable.

Despite their value, not all social connections are the same, nor are they all capable of performing the same role in our lives. According to Mark Granovetter, a sociologist at Stanford University, social connections (or as he calls them, ties) vary in strength and utility in our lives. He proposes that the more time, proximity, intimacy, emotional intensity, and reciprocal services people share, the stronger their ties to each other. Conversely, acquaintances with whom we share few of those resources would be considered weak ties.

Granovetter's argument is that the strong ties in our lives provide us with few innovative and creative ideas because there is more likelihood those people in our close-knit networks think and act like we do. The worse case scenario is groupthink, but more often the result of strong networks is maintenance of the status quo. I have personally seen this in schools, where teachers seem to be locked into their way of doing things. New teachers are quickly assimilated into their school's way of thinking and doing things, despite what they learned in their teacher preparation program. Schools all have their strengths and  unique culture, but they do not always embrace innovative ideas.

This is especially true when you consider the typical model for professional development. I remember these experiences as a teacher, when we would all gather for a day of "learning." Someone who knew nothing about my school, my students, or my professional goals, would come in and try to change my teaching practice in 8 hours. While the ideas we were hearing may have been new, the support system for implementing and reflecting on these ideas consisted of a strong network characterized by a well established culture, expectations, and norms. In essence, any innovation that may have occured as a result of the professional development left when the speaker exited the building, and we quickly defaulted back to our usual way of doing things. Typically, the best part of the day was lunch.

According to Granovetter, strong ties are not the best source of new ideas and opportunities. We know our own ideas pretty well, but we may be oblivious to what is going on around us. Just as my strong network has strengths and solutions to certain issues, other strong networks have different strengths and solutions to other issues. Unless the two strong networks create channels to bridge their ideas through acquintances, they will spin in isolation without ever getting anywhere. Granovetter calls these acquaintances weak ties, and his hypothesis is that they are an essential piece in diffusing innovative ideas and new opportunities across organizations.

This is where a PLN comes in. Teachers who are connected use social media tools, conferences, and other social opportunities as a way to connect to the ideas and opportunities they might not otherwise learn about if they only associate with their strong ties. In turn, I share my ideas and opportunities with those whom I am only loosely connected through my PLN. The result is, as Granovetter explains, a crucial bridge to other densely knit social groups. In this regard, a PLN is like connecting galaxies or remote islands that otherwise might not even know of each other's existence.

My main point is this: developing and maintaining a PLN goes beyond getting teachers to embrace digital social tools like blogs and Twitter. The tools in this case are mere conduits for something much deeper, bigger, and more important. The digital social tools are that crucial bridge to ideas being considered and implemented in other galaxies, ideas and opportunities you may never otherwise consider or find out about. This is something sociologists have been pondering for decades, and the underlying principles are as relevant now as they were when Granovetter began writing about this in 1973. The more time and space people share, the more they think alike and adopt similar behavioral patterns. While this may provide a certain level of security and comfort for some people, it is not ideal for growing and learning. We need weak ties to other strong networks if we wish to stay fresh and creative. This is why teachers should build, engage, and share within a PLN. This is why weak ties area actually quite strong.

If you would like to read Granovetter's article on this, you can access it here. He has written extensively on this topic, but this particular article is my favorite.

Thoughts on Social Networking

This semester I created a project in which my students built and participated in a personal learning network (PLN). This is something I have done in the past several years, and I have learned a lot about particular digital tools, teaching strategies, and overall wisdom from other people in the same profession.

When something is rewarding, it's easy to assume others will immediately see the same value in an activity as I do. I mean, they signed up for my class, so they must have some interest in using digital tools to communicate and collaborate, right? Well, not exactly. The aspect of a PLN that I neglected to consider is that many of the connections I have made took years to become meaningful. That is, my personal cycle of reading/seeing ideas, trying them, reflecting, trying them again, more reflection, etc., has been a process that started a long time ago, even before I had what I would call a PLN. I became aware of two very important facts regarding a PLN:

  1. Most of the "treasures" I found from sources in my PLN were solutions, or even just tweaks, to instructional problems I had been slowly addressing over a long period of time. Many times, the stuff I discovered and found helpful was just a minor point in a blog post or forum that uniquely addressed one little thing I had been wrestling with. What I considered a major discovery amounted to little more than "what's the big deal" to other people.
  2. This was going to be a very difficult thing to sell within the course of one semester. 16 weeks. 15 class meetings. Less than 45 hours. I have easily spent hundreds, if not thousands, of hours skimming, sometimes perusing, resources from people all over the world. It may be wishful thinking to expect that 45 hours spent doing something that is meant to take much longer will actually make a difference in a student's professional thinking.

Being the adventurous type, I forged ahead knowing the results may be less than convincing. My first step was to make some suggestions for the students about which sources they include in their PLN. Building the network is the hardest part, and I knew most of them did not know how to get started. Based on my own experience, I suggested the following sources, along with their possible affordances and drawbacks.

Facebook

A hodge-podge of life events, shared videos and articles, and pictures from people who I may or may not have known in person at some point. The things they post sometimes make me want to respond, then I'm like "I haven't seen that person in 20 years! And even then I hardly knew him." There are professional groups and pages on Facebook, but I find they get buried by all of the random things people share. The few professional pages I have "liked" do not seem to be updated very often, and I end up just being distracted by cat videos.

Twitter

Twitter is like candy. It seems fulfilling at first. I read quotes and re-tweets and people's random (very concise) thoughts, and it almost seems like I am learning something for a second. And then it's gone, but I still want more. So I keep scrolling. I have found some excellent resources that consistently link to good articles and posts, which has caused my attitude about Twitter to improve in the last couple of years. Some people who I follow tend to share too much, and there does not seem to be a good way to filter. The stuff I am looking for gets buried by the people who share too much.

LinkedIn

This social network tool has always been a mystery to me. I would say about three-fourths of my LinkedIn contacts are people I know, with the remaining quarter being people I have never seen in my life. Occasionally I will get a notification that one of my "contacts" recently joined LinkedIn, yet I have no idea who this person is. Other times, I get contact requests from people in my geographic area who are clearly just trying to, well, network. I usually add the person if there seems to be some common interest, whether it is our city or field of expertise. Then there is this strange thing called Skills and Endorsements. I understand the premise behind this feature (people are willing to vouch for my skill set), but I always chuckle when I get an e-mail telling that so-and-so has endorsed me for a skill in which so-and-so knows absolutely nothing about. You mean this guy I have never met just endorsed my skills in curriculum development? He must know something I don't!

In terms of using LinkedIn as part of your PLN, they do have many Groups you can join. Some of them are centered around an organization (alumni of a particular college or another professional organization), while others are based on interests (e.g., designing innovative higher ed. learning spaces). If you want to stay caught up with the discussions, you can opt to receive updates and digests via e-mail. If you want to participate, you have to go to the website. The groups have a discussion board/forum look and feel, which is not my preference. Of all the social networks in my PLN, this is the one I refer to the least.

Google+

My first thought was, Why do I need another place to waste my time. How in the world is this going to be different from Facebook? Well, Google+ has surprised me. I have found some very active and interesting communities, and I honestly say I find something of interest every time I scroll through my feed. I have also become pretty active in my sharing within these communities. I have made some good connections, gotten good feedback, and found the experience to be enriching. (Not all of my students felt this way about Google+, but I did not consider that when giving them a grade ... ha ha.)

Blogs

I still like to follow several blogs, but I have found that sound bytes from Twitter, Google+, and Facebook have squeezed them out a little. I used to follow blogs through Google Reader, which disappeared, and now I use Feedly. I do not really make time to check in that often, but I still log in about once a month. I end up marking whole sections "as read" because I know I will never read most of the stuff. I will skim the headlines and make sure I am not missing something really good.

Here is the list of my PLN that I share with students to get them started. I have also started to dabble with Reddit and Scoop.it, but I have not used them enough to speak to their suitability to this project.

    • G+:
      • Appademics
      • Open Source in Education
      • Google Docs and Drive
      • Best Educational Apps for Kids
      • Higher Education & Technology
      • Technology in Education
      • Technology & Innovation in Education
      • EdTech and Professional Development
      • Educational Apps for Kids
      • ISTE Teacher Education Network
      • Educational Technology
      • Gamification in Education
      • EdTech
      • Connected Learning
      • School Technology Leadership
      • Google Apps in Education
      • Google Hangouts in Education
    • Twitter:
      • Edutopia (@edutopia)
      • EDpuzzle (@EDpuzzle)
      • Socrative (@Socrative)
      • Wesley Fryer, PhD (@wfryer)
      • WeAreTeachers (@WeAreTeachers)
      • TechSmith (@TechSmith)
    • Blogs:
      • Alice Keeler
      • Tony Vincent
      • Two Guys and Some iPads
      • Moving at the Speed of Creativity
      • Daniel Willingham

So, what are your thoughts on different social networks when building a PLN?

Managing Learners: Tools for organizing your class

Of the many ways ITC has changed (and is changing) education, none seem more obvious than e-mail and learning management systems. It seems students these days expect ubiquitous, continuous access to course content and their teachers. How do I know this? Well, for one, I commonly get e-mails from students in the middle of the night. I am no longer surprised when I wake up in the morning to e-mails from students, most of them sent well past midnight. I do not think they expect an immediate response, but it reveals a student's mindset when you see he has sent a message in the middle of the night the instant he had a question about an assignment or grade. Second, my students are quick to let me know if they cannot access a course document or cannot see their grade. If the gradebook in my LMS were a section of the Oregon Trail, it would look like this.

The course syllabus? It probably looks more like this.

I am digressing. Anyway, teachers these days must anticipate the "right here, right now," mindset of many students and parents. Over time, report cards were augmented by weekly take-home folders, then daily homework planners, and now the LMS has crept into K-12 schools. Some schools have adopted an LMS that every teacher is expected to use. This was the case at the private school where I worked a few years back. Teachers at this school were expected to post grades, assignment details, worksheets, and other announcements each week. In other cases, a teacher may choose, independent of the rest of the school, to use an LMS in this way with students and parents.

This past week in my class, we explored various options available to teachers who want to use an LMS for managing learners and organizing content for their class. Before we looked at any platforms, we discussed the features one would expect to see in a LMS, and we listed them on a shared Google Doc, which the students filled out as they explored. Here are the results of our exploration.

Features Edmodo Chalkup Homeroom
Upload course materials
Upload materials in a variety of media (e.g., post a video for students to watch)
Discussion tool
Message tool
Announcement tool
Dashboard with upcoming assignments
Submit assignments
Submit using a variety of tools
Quiz tool It may be there, but we couldn't find it
Embed content from other sources Only from pre-selected sources
Features of this tool that may be particularly appealing. Links to Google Drive, Archives class data, calendar linked to assignments for multiple classes. Teacher can annotate papers, messaging feature, flashcards Interfaces with Apollo (the BYOD presentation tool). Quizzes can be tracked in realtime using a simple dashboard.

There are some obvious omissions on this list: Schoology and Google Classroom. This is mainly because we only had 2 hours and 40 minutes, so I had to make some choices about what to analyze. We already had someone demonstrating Edmodo, and I felt like Schoology was similar enough to skip past it. Some of the students actually mentioned it as we discussed Edmodo, and they were able to identify the similarities and differences themselves. I would have LOVED to show the class Google Classroom. I would love to see Classroom for myself, for crying out loud! Yes, most of their tools and features are available and free to everyone, but there are some that are not. This is especially true of GAFE, where if you are not in the club, you are WAY out of the club. So, this class exercise was not exhaustive, but I believe it gave the students an in-depth look at different ways to design an interface, features to include and leave out, and how easy different tools are to use.

What am I missing (and don't say Google Classroom!)? Are there features or whole platforms I didn't address?

Learning How to Learn: Growing a PLN

As a teacher, professor, or instructor at any level, one of the keys to survival is knowing how to continually learn and grow. Personal learning is one of the characteristics of teaching effectiveness. It is easy to get stuck in a rut in any profession, but teaching is especially vulnerable to this tendency because teachers are continually having to adapt to new students, new materials, new mandates, and new approaches to learning. It's surprisingly easy to just find a comfortable middle ground and float along, usually at the students' expense.

One of the most rewarding endeavors I have ever pursued as an instructor is connecting with other educators in my PLN (personal learning network). Learning from other instructors, most of whom I will never meet in person, has expanded my knowledge, skills, and understanding of the teaching and learning process in amazing ways.

What do you mean by "connect"?

Over the past several years, I have participated in communities of practice with other educators around the world. Some of them live in my city, others live on the other side of the planet. I have used a variety of digital tools to create my PLN, all of which have contributed to my professional growth in some way.

Blogs

Over time I have created a list of blogs by like-minded educators who have a similar goal: design and implement innovative teaching strategies to increase student learning, engagement, and motivation. I use tools such as Feedly and Flipboard to aggregate blogs so I only have to look in one place to see updates and new content. Most of these blogs are focused on educational technology and classroom teaching, but just because I use technology to stay up to date does not mean I am only learning about technology. I have learned strategies for facilitating discussion, embracing diversity, addressing cheating, and many other teaching topics.

Communities

In addition to following a collection of blogs, I also participate in different communities. These communities are hosted on social networking sites, and they are pretty easy to follow. For example, I am currently in about 15 Google+ communities, and I can get updates on new posts by scrolling through my news feed. I also follow about 30 different educators and innovators through Twitter, and it is pretty easy to scroll through updates to see their latest ideas and discoveries. Finally, I have joined a few different LinkedIn groups, and I get a weekly digest of anything that has been happening there. The point is, I do not have to spend a lot of effort staying updated on what is going on in these different communities, and when I do get updates I almost always learn something new.

Participation

The final way that I have gotten involved in my PLN is to actually participate and be a contributor. This blog has become my channel for processing, sharing, and reflecting on my own teaching ideas. Most of my posts would just sit isolated in cyberspace if I did not share them with my communities. By not only learning from others in my PLN, but also sharing my own experiences, I have become an active participant in this global experiment known as the World Wide Web. It's one thing to try other people's ideas, but it is downright exciting to find out other people are learning from me and trying MY ideas with their students.

Casting the Vision

This semester in my graduate-level technology class, I decided to do something new. I created a semester-long project where my students would build, engage, and participate in their own PLN. The first phase required them to join various communities of interest and follow different folks on blogs and Twitter. I gave them some suggestions, but I know some of the students have already branched off into their own interests. The second phase was for them to share what they were learning within a private Google+ community that we all joined. This way we could share what we were learning in a safe, secure place. The last phase, which is still underway, will be for the students to share what they are learning within the communities they have joined. This may mean sharing items they find, writing and sharing their own blog posts, or participating in discussions online. Since this project is currently underway, I can't really measure whether or not it is going well. It's going better than I anticipated, but I will not know the extent of everyone's participation until a few more weeks have passed. It took me a few years to become fully immersed in my PLN, so I can't expect a full conversion from my students before we've even reached midterm. But I'm committed to see this through. I cannot understate the value of my experience learning from and engaging with other innovative teachers. It has been transformative and deeply rewarding, even though some of those other educators have no idea I am learning from them. I would be remiss not to provide the same opportunity to my students.

So, what strategies or projects do you use to get teachers immersed in their own PLN?

Gamification: A semester in the trenches

My reasons for wanting to use gamification strategies in my large Intro to Education course were obvious: student accountability, timely and continuous feedback, and better motivation to do otherwise rudimentary activities. I learned pretty quickly that implementing gamification strategies was more difficult than I initially thought. First, I had to figure out the instructional design aspects of gamification. How many points are different experiences worth? What do I count and what do I leave out? Second, I had to figure out how to keep track of all of this and communicate it back to the students. As I have written about before, I used Google Sheets to do this.

Overall, I would say I am pleased with how my first attempt at gamification turned out. Was it perfect? No way. Did the students like it? Mostly, but I'm sure I will hear from those who didn't on my course evaluations. Did these strategies help me reach my course goals? Absolutely! Class attendance was the best it has ever been in the 3 years I've taught the course. I regularly had over 90% of the students completing the weekly readings every week. That is unbelievable! I actually had students competing to complete extra credit so they could move to the top of the leaderboard. I did not see that one coming. Even though the course outcomes associated with these gamification strategies were successful, I learned a lot about how to do it better next semester. I will discuss these lessons in more detail.

More Competition

One of my goals in using gamification strategies in my class was to increase engagement and not give students a laundry list of things to do every week. Well, the way I structured the points, it turned out to be just what I was trying to avoid. Every week the students had to complete a module (video and/or reading + short quiz) before class on Monday. Then they went to schools on Wednesday, and there were points associated with that. On Friday, they participated in small group discussion, which had even more points. Everything was recorded on a big spreadsheet, and students were ranked on a leaderboard. What I discovered was that most of the students completed all of the requirements each week. Basically, there was no way to really move UP the leaderboard. Students could only move DOWN if they failed to complete a requirement. Believe it or not, that is not very competitive, and therefore, isn't all that much fun.

There were minimal opportunities for students to do extra and move up the leaderboard, but they were in fact so minimal that it hardly made a difference. This didn't keep the students from trying to get more points here and there, which was my first clue that there needs to be more competition. Some ideas I am playing with include:

  • Using Kahoot for discussion questions
  • Students voting for "best" responses to questions
  • Competitions between discussion groups (attendance, challenges, completion rate, etc.)
  • Challenges during class

I do not want to overdo this, but I think a little more competition would make this aspect of the class a lot more fun.

Reboot

Another flaw in my approach this semester was that the "game" lasted all semester. I gave the students monthly feedback in the form of a points sheet, which led many of them to just see it as a big assignment. I would venture to guess that they viewed this experiment as a big ole' laundry list because I treated it like one. In the end, there was no way for students who had gotten behind early in the semester to make corrections and do better the next time around. Students could recognize the impact of their choices on their point total and start to do better, but it did not erase early mistakes. This goes against the nature of most competitive endeavors, where players can overcome early mistakes later in the competition and keep themselves in the game.

I am thinking about splitting the game up into three smaller games this spring, and starting the points and leaderboard over each time. This will allow students who get off to a bad start to do better the next time. I can still keep track of completed assignments and attendance for the purposes of grading, but I will link other incentives to the leaderboard. What are the incentives? I have no idea, but I have a few weeks to think about it.

Better Feedback

Another issue I ran into this semester was getting feedback to the students on a weekly basis. I did pretty well at first, then some of my TAs got behind on entering scores and I went a few weeks without sending updates to the class. Once everything was updated and I got around to sending the updates, some of the students were like, "Whoa! How did I lose all these points?! I thought I was doing OK!" And I was like, "How can you not know if you missed class or an assignment?!" And they were like, "Hey man, we're too busy to remember all that!" And I was like ... OK, you get the point.

This observation has less to do with the game itself and more to do with giving more timely, detailed feedback. Some of the students felt like they were in the dark all semester and did not know they had missed 6, 7, or 8 classes until the end of the semester. I was never the kind of student to miss class, but I can see how it might be easy to lose track over such a long period of time.

I have a plan for keeping the spreadsheet updated better, but it is not really worth writing about here. Needless to say, I think weekly updates will help quell some of the panicky e-mails at the end of the semester.

What am I missing?

I am pretty sure my second attempt at gamification will go much better than the first, and I'm looking forward to putting some of these ideas into practice. For those of you who have been doing this for awhile, what are your suggestions? Am I missing something obvious? Am I making assumptions with potentially disastrous consequences? I would love to hear from the true game masters!

Using Google Drive as a file server

Have you ever been in a situation where you need to host several files on the Web? Did you need for those files to have a dedicated URL? Personally, I have had few situations where this was the case, but today I encountered a learning activity that required students to quickly upload images they just captured so they could add them to a Google Map. After some searching around, I found that the Google Drive hosting API is perfect for this sort of thing. Here is what I did ...

Create Drive Folders

The first thing I had to do was create a set of Google Drive folders for students to put the images they just captured. For this activity, students were running around our university taking pictures of some of the landmarks. They were then going to use these images to create an interactive map of the campus with the My Places tool in Google Maps. I created several folders in a Google account I use only for this class. My TA's and I connected a class set of iPads to this account so the students could load their images directly into Drive, which is what they did as soon as they got back to the classroom.

An important step in this process is to set the permissions for the folders to Public. You can do this directly through Drive. You will find the folder, right-click and choose Get Link.

 

Screen Shot 2014-11-11 at 10.56.52 PM

 

You will then need to change the permissions. Google has a great explanation for how to do that right here.

Set Up the Hosted Site

This part is actually much easier than you might think. The first thing you need to do is grab this little URL:

http://googledrive.com/host/<folderID>/

Not sure where to find the folderID? I discuss it in this post. The URL will end up looking something like this:

http://googledrive.com/host/0B5YVN51uO5e_WGtSc2tBDB2bUk/ (don't worry, it doesn't work)

Google will add some characters to this URL as soon as you hit enter, but don't worry. It will work just fine. Here is an example of the files my students uploaded today. Screen Shot 2014-11-11 at 11.04.13 PM Once students have found the image they need for their project, they will need to copy the URL so they can paste it (above).

Note: The only files that will show up in the hosted folder are image, video, document (Word, PDF, etc.), and HTML (and other web-authoring files). Google Docs, Slides, Sheets and Drawing files will NOT show up in the hosted folder.

In my case, the students were pasting these URLs into a Google Map placemark so their images would show up when the placemark was clicked. Several of them held the iPad the wrong way, so their images are sideways. (Sigh.) Here is the map we created in class.

So, that's it. Students can take images, quickly upload them to a Google Drive folder, and they are instantly hosted on the Web with a dedicated URL. No logging in, no FTP, clunky photo albums. Just my files and their URLs. I don't think I will need this functionality all that often, but it sure will be handy when I do.

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.

 

 

The Teaching Professor Conference 2014

Alexander, Curby TPC poster  

Believe it or not, many of my musings on this blog end up in academic papers and conference presentations. For example, this blog post turned into this conference paper, which I am currently reworking into a journal manuscript. I took some of same ideas, and organized them into a poster that I will be presenting tomorrow at The Teaching Professor Conference in Boston. This is the first time I have attended this conference, and I am quite excited to see how it goes. My "home" conference is SITE (Society of Information Technology in Teacher Education), and I have gotten quite comfortable with it. I am on several committees, and I know so many people there that I end up spending most of my time talking in the hallway.

The program for this conference looks very interesting and covers a lot of topics I am currently interested in. I may or may not give updates from the conference itself, but you can rest assured that many of the things I hear and discuss will morph into posts on this blog.

Here is a link to the brochure I will be handing out at my poster session, which is displayed above.

5 Ways to Find Out What Students are Thinking

Bored Students Student participation typically falls into two extreme ends of the class discussion continuum. Some students raise their hand every time I ask a question. These students have an opinion on just about everything, and if I'm not careful they will dominate class discussion. I have had experiences where the same 2-3 students will talk so much during discussions that the other students will stop raising their hands. As a teacher, this is definitely a scenario you want to avoid. The end of the spectrum is characterized by a roomful of students who are so disengaged they will barely make eye contact. Maybe they didn't do the class reading, or perhaps they think that avoiding discussion will shorten class time and end in an early dismissal. Perhaps the class is large and students are intimidated speaking in front of the group. Either way, it makes for a very awkward and aggravating situation.

The longer I have taught, the more strategies I have discovered for getting the entire class involved in discussion. Early in my career I would just pose questions to the entire class. I eventually learned simple strategies like using cards or popsicle sticks for calling on students who don't raise their hands. This helped me get more students involved. Still, getting called on was a game of chance and some students would tune out in hopes that their number wouldn't get called. I eventually started using some different pedagogical strategies such as Think, Pair, Share, Numbered Heads Together, Jigsaw, Jeopardy, or Fishbowl for engaging students in discussion prompts. Each of these techniques for facilitating discussion got everyone involved and had more accountability than sitting in class hoping not to get called on.

Even with great discussion strategies, there are times when I want to know what the students are thinking. This isn't always possible when the majority of the discussion is a verbal exchange. I have used chart paper or construction paper to have students summarize their thoughts, but this is not always easy to present and when it's all over I'm stuck with a bunch of chart paper.

With the emergence of free (or kind of cheap) web-based and mobile apps, teachers can find out what students are thinking in a variety of ways, and all without using up all the consumables. I will describe five tools I have used in my classes to put student thinking at the forefront of the discussion.

Socrative

This is a free app that has iOS, Android, and web-based options. Students enter in the class code then wait for a prompt from the teacher. Results are instantly aggregated on the screen, giving everyone real-time results from the prompt. There are several options for prompts teachers can send the class, including T/F, Multiple Choice, and Short Answer. Prompts can be generic (i.e., A, B, C ...) or prepared in advance with specific answer choices. Results from saved quizzes can be downloaded as a spreadsheet for further analysis or grading.

Socrative is a great tool for quick discussion questions where you A) want students to talk about a prompt and B) get fast statistics on what everyone is thinking. I have had students use the mobile app on their phones many times, and it almost always works like a champ. I just post the question, students grab their phones, and within minutes you have a bar graph populated with student responses. This can actually prompt further discussion.

ActivePrompt

Another way to find out what students are thinking is to have them place a dot on an image. When enough people do this on the same image you can start to see trends and hotspots. I have done this with continua (e.g., Place a dot on the continuum where you believe the responsibility lies for a positive classroom: Teachers or Students), maps, quadrants, or other diagrams.

When you upload an image to ActivePrompt, you are given two prompts: one for the students to place their dot, and one with all of the dots displayed. You can try this using the following URL:

http://activeprompt.herokuapp.com/SBGWN

You can see the results here:

http://activeprompt.herokuapp.com/TWBUN

I have used this tool in class several times, and it has always been reliable. Students will typically discuss a prompt in pairs, place their dot based on their discussion, then we will discuss patterns and themes as a class.

InfuseLearning

This tool has many of the same features as Socrative, but it has the extra benefit of the InfuseDraw tool. Teachers send students a prompt on which they can draw, annotate, or label an image. Results are saved in the teacher dashboard and can be downloaded as a PDF. Like Socrative, the students do not need an account to log in. They just enter the class code and they are ready for the teacher to send the prompt. The few times I have used this tool it has worked great. Since Apollo, my class-syncing tool of choice, has some of the same features I tend to use that tool instead. However, if you are looking for straight prompts without having students follow your presentation on their screens, InfuseLearning is the way to go.

Google Presentation

I have already written about how to use this tool before, so I won't spend a lot of time explaining how I have used this activity in class. You can do the same thing, or something similar, with Google Docs or Draw, but I like the features in Presentation and the fact that you can assign each group a different slide in the same file.

Google Forms

If you are wanting to get more extensive feedback from students, Forms is the way to go. Results from the forms are instantly sent to a spreadsheet. We all know that spreadsheets are like magic because of all you can do with them. With the emergence of Add-Ons, you can now do even more. Some examples of ways I have used Form data: display the automatically-generated pie graphs, randomly choose responses directly from the spreadsheet, cut and paste the responses into Wordle for an (almost) instant word cloud, or e-mail the students a badge once they complete a set of prompts or an activity (this is not done in real-time ... usually after class).

Since the types of items you can use in a Google form are so diverse, there are many opportunities to use this tool to facilitate discussion in class. Responses are anonymous by default unless  you include an item for names. This tool will require some preparation before class, but that is true of most that I have mentioned here. It's one thing to send out an impromptu poll using Socrative. It's something quite different to make my students sit and watch me create a Google Form. Overall, this is a great tool to keep in the box and use when it fits your instruction.

The importance of discussing and reflecting on learning experiences is pretty well documented. When we give students the opportunity to verbally process their thinking, we increase the chances that they will be able to retain and apply skills and knowledge after the fact. Discussion and reflection helps us give new information personal meaning. Good class discussion starts with good pedagogical practice, but with new tools there are even more opportunities to make it relevant, engaging, and active.

What tools or strategies do you use to facilitate class discussion and find out what students are thinking?