A wiki spreadsheet.

I have to say that up until recently I didn’t see what was so great about spreadsheets. I have been using them for years to analyze student achievement data and present findings to others, but the didn’t seem like the “killer-app” that so many others seem to be thinking about.
 
On the other hand, my wife speaks in spreadsheets and she can really make them sing. She can have fields reference across fifteen different sheets and set up a budget in a matter of moments.
 
This is extremely cool if all you want to do is present information or figure out what makes sense in terms of data, but as a collaborative process, I just didn’t see it.
 
That was until Google Spreadsheets started opening up anonymous access to spreadsheet using forms and protected links. I started using google forms in order to record interest in our district’s online school (http://edcsd.org). This proved an effective way of collecting specific information and storing it in a place that could be accessed from everywhere. So, in this sense, it was a mass collaboration that was added to with every entry. No one really is able to see the scale of the collaboration, that is, except for me.
 
Well that was a neat trick, but it is nothing compared to the idea of a spreadsheet wiki. One feature that was just added to google spreadsheets is the ability to share a link with others that will let others edit it without having to sign up for a google account.
 
This means that students could record data on the same spreadsheet without having to sign in. It means that achievement data (not on specific students, though) could be aggregated in one place, all without having to teach an entire staff about a new service. It means that you could keep track of all of your school’s goals with everyone adding their notes, never having to go through the extra hoop of remembering a password.
 
Perhaps best of all, it would allow all of those who do not yet see the value of massively-collaborative projects to participate in one without ever knowing about it and by using a tool they already recognize as important: spreadsheets.
 
Perhaps I am making too much out of this. Perhaps there are other tools that do this already, but as I am on a search for ways to eliminate as many logins as possible, this is one great step in the right direction.
 
Do you see any new ways of using this? Are spreadsheets more valuable now?
Sent from my Verizon Wireless BlackBerry

Posted via email from olco5′s posterous

Helping myself out… by asking for help.

So I haven’t blogged for a little while because of all of the work I have been doing for our district’s online school, eDCSD. I intend to blog that out more fully in a separate post, but now I am at the TIE 2008 conference and I have some time to think about how everything (seriously everything) is fitting together.

Teachers are sitting around me trying to figure out Photo Story. They are listening to a man who knows something about building learning communities through new media and web 2.0 resources. This is right up my alley. Or, at least it used to be. I used to love listening to hear people talk about what to use in the classroom in order to create a more collaborative environment. I talk about it when I present. I demo visual tools (although mostly of them are web-based) for creating environments. Why doesn’t this mean something to me?

I feel different than I did last year when I talked to Bud Hunt, Will Richardson, and Karl Fisch. I don’t feel like I am a part of this conversation right now. I feel a part of a different conversation, but I don’t know exactly where it is happening.

I want to be a part of the conversation that is about massive creation. I want to be a part of creating something that lasts, not a singular experience. I want to feel connected to all of the people I talk to, forever. I don’t want to meet anyone new who doesn’t want to share and create with me. Why can’t it be easy enough to simply add people and create with them. Why is it not possible to look across the edubloggosphere and say, “you and me, let’s go.”

I want to be a part of that conversation. I want a creation station for all of us. Where is it, though? Where is the learning playground? I want to play.

So, I guess I will throw it out to you. Where is your playground right now? Where are you going to simply create learning with others (please don’t tell me that the most learning is happening simply through twitter… I don’t think I am alone in my for need something more robust to actually create conversations that last and that I can keep coming back to). Anyway, any suggestions for where my learning community is?

What we need from “the district.”

The Principal of the Online School in my School District asked me a really interesting question regarding the growth of our vision within the district and the region. She asked, “What are the 2 or 3 big pieces that we need from the system/district?”

I was taken aback by this question. Is it possible that my district really wants that kind of input? Can I really influence the future just by asking for it?

This question begs us to examine what we want to ask of our institutions. Many times we just assume that our institutions are not interested in what we have to say or what we would like to create, but perhaps they just need to know what it is that we need. So, this is what I have been thinking about:

What are the 2 or 3 big pieces that I need from “the system” in order to create the Authentic Learning Environments I have been writing about, podcasting about, trying to create, and aching to find?

• 
• We need teachers who do not have to pile technology-rich learning experiences on top of their every day classrooms. We need teachers who are hired to simply do the work of creating a ripe environment for students online (or are at least shared with a brick and mortar in some kind of ratio that makes sense).
• 
• We need to be able to rewrite the rule book a little on what tools are okay to use in classes. It should not be a don’t ask, don’t tell policy. It should be a conversation about which technologies really do produce the most authentic learning for the most students.
• 
• Ideally, I want access to a learning spa, where teachers can come in and learn all that they can about teaching online without the fear of being rushed or having to regurgitate the information for students. I want a place that will create culture among students, a place to do projects with kids that will get them comfortable with the tools they will need in order to take courses online. I want a place where teachers are encouraged to create a community, to have a shared vision, to stay informed, and to create something new. It would be nice if that place existed as a brick-and-mortar entity and not just as a consistent webinar meeting.

What would you ask for if you knew your district was listening?

Powered by ScribeFire.

Digital Ex-Patriots and The Formula for Transparency

Well, I may be going out on a limb with this one, but I have described in the podcast a level of discomfort with technology that goes beyond the simple immigrant/native debate. The fear and panic that is associated with technology in the classroom comes from Digital Ex-Patriots. These people (parents, teachers, administrators, etc.) are so sure of their anti-technology stance that they are actively pursuing a life (of education) away from technology integration. These are the people that we must win over if we are going to continue our collaborative efforts and truly create change. Please let me know what you think about this concept in the comments or in an e-mail (benjamin.wilkoff@dcsdk12.org)




Show Notes:

• 00:00:00: Intro to Online and Offline Life
  Internation Community of Minds

• 00:03:17: Safety Vs. Panic
  The Most Discussed Post I’ve Ever Written

• 00:05:07: Creating Discussion
  Bud Hunt’s Blog

• 00:06:07: Twitter as Tool

  My Twitter

• 00:07:28: Formula for Transparency
  Discovery Online Code

• 00:08:16: Twitter as Classroom Communication
  Remote Access Twitter

• 00:09:40: Digital Ex-Patriots
• 00:11:37: Google Paper: Good or Bad Idea?

  Google Paper

• 00:13:14: Mass Phone Call Newsletter
  Pheeder

• 00:13:53: Paths to Transparency
• 00:18:03: The Role of Students in Classroom 2.0
• 00:19:20: Transparency as Conversation
• 00:21:35: Conclusion with Challenge
  Podcast Blog

The Perfect Online Professional Development Community

I have really been thinking a lot about how to create an online community for all of the teachers in my school district who are as passionate about technology integration, reflection and collaboration as I am. The way that it stands, I feel so isolated in my quest for new and more effective ways of teaching. I know this is not the case, that there are probably hundreds of teachers who feel the same way, but that isn’t really much comfort when I don’t know who they are and I have no way of contacting them. I almost feel like I need to send out a classified ad: Young passionate teacher seeks the same in order to learn and collaborate about technology and pedagogy.

I can’t think of a better way to ask for a community than to create one and hope that other people join up. I have already run this idea by a few, more experienced, Edubloggers, Bud Hunt and Karl Fisch. They have both responded pretty well to the idea and are willing to help me get it off of the ground.

After my initial e-mails to my administration and these two great teachers/resources, I thought that there would be no way of stopping such a mammoth idea. My principal loved it, and the feeder area coordinator thought it would work well with some of our other goals. But last night, I received an e-mail from the Web Services manager of my district. In it he said that I should consider using two semi-crippled technologies (Firstclass and SchoolCenter) that teachers in my district are already fairly comfortable with (and the district has already paid for). I say that these are crippled technologies because they have real holes in their capabilities. They just can’t do everything that I want to do with this community.

Even with this minor setback, I have decided that I will not compromise (at least initially) my vision of the “Perfect Online Professional Development Community.” I would like to see just how collaborative, easy to use, scalable, social, and reflective I can make this experience for other teachers. So, without any further explanation, I would like to unveil what I think are the essential pieces of a new generation professional learning community.

A central portal will give you access to the following (I am thinking about using protopage):

1. A master blog that would guide discussion.
2. Blogroll
3. Recent Blog Articles (a la SuprGlu)
4. Archived Blog Articles (in a newsletter type format)
5. A Google Earth Mash-Up of all of the school represented in the community
6. Bios of the teacher bloggers (if they wish to include them) done in a social way so that collaboration is easier (an Elgg.org-type personal page)
7. A calendar for event planning (Skypecasts, Classroom Demonstration Webcasts, Classroom Picture Flickr Stream)

The other aspects of the community that will not be directly shown on the portal’s front page except for simply linking to them:

1. A Q+A section for both teaching questions and technical help questions (Ning.com has a great set-up for something like this).
2. A Digg-Style Article/Website recommender.
3. A Wiki for success stories of technology integration or improved practice (a little like David Warlick‘s Telling the New Story Wiki)
4. Walk-Throughs (screencasts) for how to create blogs, collaborate, etc.
5. A way of dealing with comments both attached to and unattached to their original posts. (co.mments.com has a pretty great strategy)
6. A professional development bookshelf (akin to either this one or this one)
7. A way of signing up for an e-mail RSS system for new posts (most teachers check their e-mail religiously)
8. A belief statements wiki about technology or teaching in general for certain collaborating members or individuals (this could be a running list of belief statements and/or a running list of questions that these belief statements beg to be answered. I also like the idea of using standpoint.com somehow).
9. A system for sharing lesson plans and ideas (both formatted and unformatted) including a collaborative document center.
10. A cross-school project starter (partnering up similar teaching styles)

Questions I still have about how to get this done:

1. How do we get as many different positions represented in this community (principals, core teachers, librarians, elective teachers, etc.)
2. Should we try to protect anonymity on the blogs?
3. Just how much do most people know about these technologies? Will it be like starting from scratch for most people? And if so, should I send out a formal (or informal) survey about these ideas (What have you done in your classrooms with technology? Do you like to create you own lessons? How much do you enjoy reflection? Do you want feedback on your classroom ideas from other teachers? How worried are you that this is going to take too much of your free time? How many of you already blog?)?

Well, that is pretty much it. I would like to make this project as appealing and voluntary as possible, so that everyone who is in the community has a lot of buy-in. Let me know what you think of this grand scheme. What is possible and what is not possible?