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

“Hope Online” Professional Development 11.14.08

Do Not turn off your cell phones and laptops.
If you have them, use them.

(Throughout this workshop, you can ask questions via text message by texting hopeonline and your question to 41411. You can also add to our questions without a cell phone by going to http://www.textmarks.com/HOPEONLINE)

I am not here today in order to introduce to you a brand new initiative that will require extensive amounts of training and make your life busier before you see any real benefit. I am also not here today to say that there is any one tool or strategy for making the ways in which you work actually work.

Rather, I am here to ask you a lot of questions, mostly about what you are spending the most time with in your job. What are those things that take away from what you would rather be doing, the rewarding experiences of working with kids and other adults who are working with kids.

In order to do this, let’s get one thing straight. Information is infinite. Attention is finite.

You gather a seemingly insurmountable amount of information every single day from e-mails, voicemails, web sites, student data paperwork and many other sources. It can be even more daunting to think that there is more information out there about how to organize that information. With your attention stretched so thin, it is hard to think that there are ways of getting any of it back. We are still going to try, and for the most part, we are going to look at solutions that are already in your workflow.

Well, I would like to present you with a few possibilities for a different way of organizing information.

The first is I would like to use my voice to listen to my e-mail, create e-mail, put an event on my calendar, send myself a reminder, create a text, and post to my blog. While this service has a name, I would much rather you think about the strategies that I am using in order to create more time for other things. Because I am able to use my voice to do these things, I can make efficient use of my drive time (of which, there is a lot).

Dial2Do – A way to use your voice to get things done on your cell phone.

An example of using this strategy to create something.

I would like to next highlight the use of short messages to capture information. Many times, I need to be able to capture information from myself and others, but there is no time in order to send out an e-mail. I need to be able to capture it now. So I send a text message to a service that aggregates the information for me and for everyone else who I invite:

TextMarks – A way to both capture information and share information through SMS.

An example of using this strategy to create something.

I use e-mail a lot. Well, perhaps that is an understatement. I am available by e-mail about 20 hours of any given day. With that in mind, I would like to be able to use e-mail in order aggregate archive the most important things that I am sending out. I want to be able to attach anything I want and have the archive understand it.

Posterous – The e-mail blog that don’t even have to sign up for.

An example of using this strategy to create something.

Now, if I am on my computer and I want to capture information on a topic. I want to capture it as I am doing my research, not go back afterwards and document what is going on. I want to be able to simply highlight text and pictures and have them all simply show up in a webpage that I can e-mail to someone or share with somone for them to add to.

Google Notebook – Collect text, pictures, and movies from webpages in order to be shared later with others.

An example of using this strategy to create something.

Well, what if I want to show others exactly where to go on a webpage using my voice. I would like to guide people through a series of webpages that I think are important. I want to do this in less than 5 mintues too.

FlowGram - Create a screencast of webpages and archive it to send to others.

An example of using this trategy to create something.

Now I would like you to figure out what you would like to be able to do in terms of aggregating and storing information. Brainstorm things that you don’t know are possible. Think about how you gather information now and how you would like to change that to be less attention heavy and more information heavy.

Now that we have all of our information gathered and stored, we will want to collaborate and talk about that information. The easiest way to do that is to meet face-to-face, but for much of the time, that requires significant driving and serious scheduling.

So, I want to come together with a few others to talk something out. I want to be able to see, hear, and write with them. I don’t want to have to set up log in to anything. I just want to hit a power button.

Tokbox – Always on Video Conferencing.

An example of using this strategy to create something.

I would like to work on the same spreadsheet with someone else so that I don’t have to send e-mails of the same document back and forth and get lost in the versioning. I would also like to be able to have information be entered into the spreadsheet via a form that others can fill out so that I don’t have to do as much data processing tasks.

Google Docs – A truly collaborative version of office

An example of using this strategy to create something.

NaNoWriMo(2)

Finally, I really want all of this stuff to be accessible in one place. I would really like to not have to remember exactly what all of these sites are. I just want one place to go to where it makes sense to find all of these things. Almost like a well-maintained professional development environment for hope.

Our IQity classroom - A one stop shop for learning tools, collaboration, and further professional development.

Now I would like you to figure out what YOU want collaboration to look like at Hope. Brainstorm
things that you don’t know are possible. Think about how you collaborate now and how you would like to change that to be less
attention heavy and more information heavy.

The Ripe Environment for Authentic Learning: TIE 2008

The process of creating a Ripe Environment for Authentic Learning is one that must be experienced rather than explained, so it is my most sincere hope that you experience The Ripe Environment today and that you take ownership enough of it to take it with you when you leave today.

Let’s start with the basics, though: defining our terms.

Authentic Learning: Learning for a Real Purpose and with a Real Audience.

| View | Upload your own

6. It’s the Content, Stupid.

• That is why we use blogs to communicate, not because they are easy, not
  because they are more collaborative, it is simply because they let the
  content speak for itself. Without content you are nothing. Without
  great ideas there is no hope for the future. It is the content that
  matters, not the format. That is why we do blogs, to pull content up
  through the rss straw, roll it around in our mouth-like readers,
  tasting each smooth milkshake post and swallow it down, totally
  satisfying our desire to fill our bellies with content.

7. The Marks of Collaboration

• The Digital Literacy Toolbox (521 revisions at last count)

8. Independent and Interdependent Questioners

• Ask a question here.
• Create something new here:

9. Change Cannot be Institutionalized

• Edupunk heroes

10. The Most Powerful Learning

• The typewriter vs. the fully connected blog post.

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?

Mini Del.icio.us PD

Although this is not my regular mode of blog posts, I have found that it provides an outlet for the PD that would normally just be within a given context, but that other people might find useful. I created these images for eDCSD, the Online School for Douglas County. Feel free to peruse it and use the information, but do not use the login information if you are not a part of eDCSD.

Powered by ScribeFire.

A New Possibliity

This new possibility (which is now kind of old) is a total reversal of some of the things that I have consistently talked about and advocated for. This only comes about because of a great contact I have made with the principal of our online school (eDCSD). The possibility is this: Starting from a place of amazing technology and bringing in education rather than starting from a traditional school and trying to shove technology into it. What do you think about it