Showing posts with label google docs. Show all posts
Showing posts with label google docs. Show all posts

ClassConnect makes sharing resources and collaborating easy

By some estimates there are approximately 4 million teachers in the US. On any given night, weekend, holiday, teachers are thinking about what to do in their classrooms. Some are developing worksheets, others are designing projects, maybe they are searching around for something previously made. The problem is that millions of hours a week are wasted recreating these materials. Educators are professionals and they are also human beings. I believe we have better things to do with our work and personal time than start from scratch every day and with every new teacher.

Now many of us share resources already, whether it is with your colleagues at work or online but how easy is that and what happens over time? This process doesn't scale, it only helps some. There are repositories of lesson plans all over the web. But how do you separate the good from the...um not so good?

ClassConnect is driven by a passion to solve this problem. The developer behind this has put every resource he has into making this awesome, and it is awesome. My colleague Audrey at Hack Education has already done a great job of giving an overview and showing how ClassConnect is the Git Hub for Education (a code sharing platform for programmers). What I want to focus on is how easy it is to get started right away. Did I mention it's free!

We were each taught how to create lessons in our credential programs. We take pride in creating them and making them great. However, each time we create a new lesson we are running an experiment and the results of that experiment (good or not so good) cannot be refined and reapplied for an entire year until you use that lesson/project again. What makes matters worse, is we are independently running that experiment thousands of times each year! The boon of the web is to allow researchers to share their findings and to crowd source experiments to solve problems more quickly. There is no reason why we can't do the same, in fact we must.

ClassConnect makes it easy for you to find and vote up the best stuff so it rises to the top. You can also search by topic, subject, standard, file type, and even type of lesson.


However, this platform is only as good as the resources we share. For every colleague you add, you get additional storage for your files. But get this, for every file you share publicly, it doesn't count against your quota! A great way to store your files in the cloud and an even better incentive to share. I shared this resource on Google+ and within a day I had more storage than my Dropbox. Plus I was now able to share it with you and have you benefit as well! You can even add a class online so you can share the entire curriculum or resources (I used it with my robotics team to maintain shared resources).

You can add anything: a link to your favorite YouTube video, a file, Google Doc, or an entire folder.  Click the share button to the right of the file and check the box that says Public, you just saved another educator valuable time!


Don't forget to add tags and a description to make sure we can easily find it.


Now you have access to some of the best projects and assignments I have found or made over time. Some of it was mentioned on this blog, but having it all in one place and searchable makes it much more convenient. Did I mention that you can claim a url? http://www.classconnect.com/brokenairplane/shared, head on over and claim yours to easily share. I'll add more as time goes on them, but the important thing is to share the best so over time we can refine and remix it for our own needs and continue to iterate.

By doing this, over time we can develop a large community developed collection of best resources. Imagine back to when you started teaching, wouldn't it have been wonderful to be able to use others resources (perhaps you were lucky enough to have a great mentor) and focus on your pedagogy and finding your feet? Then as time goes on you make the curriculum your own, refine and share like others shared with you. I would imagine we could crowdsource a lot of our resources and have great lessons, projects, puzzles/problems, etc. ClassConnect is inspiring a movement called United We Teach, I've joined the movement to help my fellow educators and our students, will you?

Stay connected with BrokenAirplane.

Android + Science with Physics Gizmo

Science equipment can be expensive and yet many of your students have Android phones. Why not put this incredible technology to use for learning. Physics Gizmo allows you to collect scientific data in your classroom, at home, or even in space using only the phone.

Download Physics Gizmo from Google Play

Physics Gizmo is Open Source
I've put the source to Physics Gizmo on GitHub. If you are interested in helping me develop a tool for students to collect and analyze scientific data in an affordable way I encourage you to join the project.


Physics Gizmo on GitHub
Discussion Group Forum

For inspiration, here's an experiment using Physics Gizmo - via +Roberto Catanuto (@RobertoCatanuto)


Version 2.3
This version no longer requires you to turn on Bluetooth when the app starts. The only time you need to turn it on is if you wish to use two phones as a photogate (see below).


Version 2.2
Physics Gizmo is updated to version 2.2 for phones running Gingerbread, Honeycomb, or Ice Cream Sandwich.

If you are running Ice Cream Sandwich (Android version 4.0), this update brings with it a visual refresh in alignment with the new look and feel.

For everyone else, Physics Gizmo will no longer close if you choose not to turn on Bluetooth. This is a bug I have wanted to resolve for a while, and I appreciate your patience.

Bluetooth is necessary to connect two phones as a photogate (video), but if you don't turn on Bluetooth the other sensors work just fine.



Version 2.0
Now there are more opportunities to conduct scientific experiments with your phone.

New Sensors
Using the phone's proximity sensor (usually in the upper left of the phone), Physics Gizmo has three new options for collecting data:  
  1. Photogate Pulse - Triggered each time the proximity sensor is covered. Use it to count events. 
  2. Photogate Pulse with 2 Phones (Beta, only for Android 2.0+) - Connect two phones for accurate event timing. Similar to the 1 phone photogate but one phone starts the timer and the other one stops it. If you are tired of inaccurate experiments from human error with a stopwatch this is for you. See how long it takes for an object to fall or roll down a ramp like Galileo's and more! With Bluetooth's range ~30 ft/10 m there are many possibilities for learning. Watch a video of the 2 Phone Photogate in action.
    1. Click yes to turn on Bluetooth Discovery mode.
    2. Select another phone running Physics Gizmo from the list.
    3. The timer starts when the first phone's proximity sensor is triggered.
    4. The timer will stop when the second phone's proximity sensor is triggered.
  3.  Pendulum - Notoriously difficult to time accurately, an event is recorded for each completed full swing/period (two triggers) of a pendulum passing by the proximity sensor. Watch a video of the pendulum sensor in action.
Note:
  • If you don't see the new sensors your device does not have a proximity sensor (some tablets). 
  • If you don't enable Bluetooth in the beginning, you will not see the 2 phone photogate.


Updated Accelerometer Sensing
  • Continues to sense from the accelerometer even if the screen is turned off (note: be sure to try this with your phone as results may vary). Useful when the phone is in your pocket on a roller coaster.
User Interface 
  • New layout with higher resolution.
  • When finished sensing, press the "plus" button to add more time and sense again.
  • Pressing the question mark button in the upper right opens contextual help for you to successfully use Physics Gizmo and upload your data.

Using Physics Gizmo
  1. Turn on Bluetooth to access all sensors.
  2. Select your sensor
  3. Give your data a name or leave it with the time and date.
  4. Set the timer.
  5. Click start to collect data.
  6. Upload your data to analyze later using Google Docs, Fusion Tables, Geogebra etc. It is also saved in the ScienceData folder on the SD card as a csv.
Think of all of the experiments you can do, considering how much more likely you are to have enough phones in the classroom to do the experiment

I am really excited to see it used by students. I was originally inspired to create the app for my colleague who takes his students to Magic Mountain for Physics Day. Now they can collect accelerometer data on all of the rides and analyze the data back at class! That data will help them build their own roller coasters. The photogate sensors were inspired by my other colleague who creates pinewood derby cars but was always looking to improve the accuracy of the racing data.

The point is, now students can learn science with a phone they already use everyday. Please share in the comments how you used the app!


How Did I Get Here 
A while ago I created an app using Python and Android so everyone could collect data for science experiments. That post became one of my top all time read posts. But, I worried that all you did was read it. You see, I made a couple of mistakes that I wouldn't let students get away with:
  1. I made it relatively difficult to access. The instructions are there, and it would probably take about 20 minutes to get the app on your phones, but 20 minutes is a huge chunk of time in the Internet world and we have so much to do. I have seen people pass up learning Geogebra because they thought it would take too much time to learn!
  2. My second mistake was I didn't push myself to learn. Instead of learning Android programming, I asked all of you to do the work of getting it working so I could play it safe with Python. 
I decided to fix that right away. Now I love Python for its syntax, therefore Android (which is built upon Java) seemed more complex than I would have liked. But, if I wouldn't allow a student to get away with that, then I certainly couldn't.

So I did what I always do when trying to learn something new: I read, and read, and read until I stored up all of the confusing syntax and methods in my head. Keep in mind that this didn't make any sense to me whatsoever. 

Then I came across this excellent tutorial by Chris Blunt. It takes you through the setup, installation, and programming of an android timer app. The clear instructions, pictures, and hints made it really simple to see how an Android app comes together. Eureka! Everything clicked together and suddenly, I was writing all kinds of additions to the app. 

Now, that makes it sound pretty simple huh? Well there were still plenty of bumps in the road, but I did learn than programming for Android is a lot easier than I thought and it makes sense once you get the hang of it. Not to mention I had two powerful tools that kept me going. 
  1. Eclipse - It's free, it's open source and it's incredible! It will generate templates, spell check, find errors, suggest fixes. I can't imagine how I would have come this far without it. 
  2. The Web - Yes, I know it sounds obvious, but books take too long to root through and sometimes your question doesn't fit the examples in the book. I must give special appreciation to Stack Overflow which always seemed to have the right answer. Although, when it had a similar answer, but not the exact one I needed, it pushed me to understand the concepts even more.
The Apress are my favorite Android books so far. I used, Android Apps for Absolute Beginners, Beginning Android 3, and I just ordered Learn Java for Android Development so I can gain an even deeper understanding of how this works. I intend to fully immerse myself in Android programming this year so I can make some apps that can support learning.

Connect with BrokenAirplane and stay up to date with the best resources in education.

Follow my microblogging on Google+

I'm Not Texting I'm Programming!

Update: This app is available now as Physics Gizmo on Google Play.

No less than a century ago, it was possible to learn everything we knew about science. The only requirements were an ability to read, an extensive library, and perhaps the equipment to carry out your own experiments. Now we have entered a new era of science where literacy is more widespread and between the Internet and Libraries we have every resource imaginable at our fingertips.

Two big problems remain, science has diversified and grown so much that it is difficult for scientists to know everything about their own field let alone another. The other issue is how science equipment remains financially out of reach of amateurs and explorers. The major scientific research is driven by that which will have a financial return and so science for its own sake is limited. This is even more evident in schools who are cutting science to save the rest of their budgets and focus on less expensive (and more tested) subjects This must change if a steady stream of innovation is to continue.

The hacker spirit is a deeply embedded part of science. Now out of necessity and pure enjoyment, many are directing their attention away from software development but to hardware. In the August issue of Wired, the BioHacker movement features those who wish to reduce the cost of doing Genetic analysis.

Do you know where these DIY Biologists expect to see the most impact? Schools! For students to do science instead of just reading about it. Arduinos, Makerbots, Robotics, and more are forever changing the opportunities students have to create.

At my school we spent a lot of time in labs and projects. What was lacking was quality data. Unfortunately the tools and sensors available to students are expensive and limited. So I did what I always do, I sat down and wrote some code :)

I love my Android phone and each day I hear about the insane number of new activations everyday. The smart phone is getting smarter and cheaper just as technology always does. Just as we saw an explosion of Desktops and later Laptops in the 1990-2000s, we are seeing an even speedier rate of adoption of smart phones. While looking at my phone one day, I realized how many sensors/tools it has built in seamlessly to its interface (Internet, Accelerometer (motion sensor), Gyroscope, Light, Sound) which if purchased separately would be thousands of dollars and would not play well with each other.

So I wrote a program which logs motion and then uploads it to your Google Docs account. You can see some screenshots below of the results.

Jumping up and down

Dropping my phone (onto a pillow)

To do this, I used sl4a (Scripting Language for Android). With this you can code in Python, Ruby, Javascript (and more) and do almost anything with your Android phone. It has a built in editor so you can quickly type code into the phone (hence this post's name) or you can code it in your favorite editor and then transfer it to the SD card on your phone.

Why did I use sl4a instead of making a nice pretty app using Android's SDK? This application uses the Google Doc APIs (basically commands to communicate between an app and and a program like Twitter or Facebook) and Python. If you look at the code it could be done by any of our students with a free weekend. It may look a little complicated at first but there are just a lot of function calls to save code. Just like most other Python code, it reads like a story (login, get the parameters, sense, upload).

I believe sl4a could take students who may or may not have used App Inventor or Scratch to the next level and open up a world of possibilities to them. sl4a has been used to send collect data on a phone being launched into space and many other exciting projects involving Twitter, Robots, Arduino and more!


I wanted to use sl4a so everyone who knows Python could see the code and hopefully improve on it. I don't have the time right now, but I would love to see other sensors added, the ability to review and display the data/graph on the phone, interface with Arduino, and store data on the phone if it logs data longer than 1 minute, and perhaps even add a pretty GUI. I'm hoping that by open sourcing this, others will want to jump on board and help out. Cellbots have set the bar really high and have their own incredible data logging app and if they integrated Google Docs uploading I would say their app is perfection.

My hope is as more educators/students realize their ability to create, scientific tools will become available to all. People like Steve Dickie, the Arduino team, Geogebra, and many others are working really hard to ensure that the cost to do STEM is reduced dramatically.

You could walk into your class on Monday and ask your students how many of them have an Android phone, you may be surprised that there are enough for one per group. Think of all of the experiments you could do with nothing else but your phone. I can't wait for this year's Magic Mountain Physics Day and see how many students could get data from a roller coaster and directly upload it to their Google Docs (and check it while still at the park from the GDocs Android app).

Look how easy it is to make a little popup on your screen!
import android
droid=android.Android()
droid.makeToast("Hello Android")


If you want to give this a shot, go to the sl4a website and download the apk (the installer). Your other options are to click this link, or scan the barcode on the right with your Android phone. Follow the User Guide to get Python (or the other languages) installed on your phone.

Now, you are ready to start coding on/for your phone. There are some great tutorials on the sl4a website, I also recommend the book Pro Android Python with SL4A. In my code below I list a few other resources that were helpful to the doScience project.

If your code is relatively small you can share it via barcode but this app falls just above that threshold. So you can copy and paste it from below (just please respect the Creative Commons licence) into your Python Editor or download the doScience file directly. Save it to your SD card in the sl4a/scripts folder. This code must be run on a phone or a computer connected to a phone running an sl4a server (much simpler than it sounds).

Note: It will ask you to login to your Google account. As you can see from the code below, no one is able to access that information since it is kept hidden from even the developer by the dialogGetPassword method in line 41.

I hope this app inspires you to do something great. If you know how to program, build, create will you please lend your talents to this projects or the many others out there. If you don't know how to create, then learn as it is the most incredible thing to be a Maker and you will inspire others. Before you know it, the revolution will be underway (oh wait it already is, come join us)!

Subscribe and Connect to BrokenAirplane and stay up to date with the best resources for your classroom.

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
'''This code is licenced under a Creative Commons
Attribution-NonCommercial-ShareAlike 3.0 Unported Licence.
Created by Phil Wagner 2011 www.brokenairplane.com. This code allows data logging and uploading to Google Spreadsheets.
It exists so students can to do Science when 
the cost of Science Equipment is too expensive. Additional features can be added
but this paragraph should always remain in the code.'''

#Future features - Additional Sensors, Review, Display Data/Graph on Phone
#interface with Arduino/ADK

#Helpful Resources:
#http://code.google.com/p/android-scripting/ (sl4a)
#http://code.google.com/ (Google APIs and resources)
#http://www.adaptcode.com/using-google-spreadsheets-as-a-database-in-the-cloud/
#http://gdata-python-client.googlecode.com/svn/trunk/pydocs/gdata.spreadsheet.text_db.html

import android
import time
import gdata.spreadsheet.service
import gdata.spreadsheet.text_db
import string

droid = android.Android()

dt=100 #Time between sensing

def countdown():
    #3 Second Countdown and Vibrate
    droid.vibrate(100)
    time.sleep(1)
    droid.vibrate(100)
    time.sleep(1)
    droid.vibrate(100)#3 second countdown
    time.sleep(1)
    droid.vibrate(300)
    return

def login(myEmail='example@gmail.com', password=''):    #Get Email and Password and login
    while password == '':
        email = droid.dialogGetInput("Email", "Enter the email account where the Data will be uploaded to:",myEmail).result
        password=droid.dialogGetPassword("Password", "Enter the account password where the Data will be uploaded to:").result
        try:
            client = gdata.spreadsheet.text_db.DatabaseClient()
            client.SetCredentials(username=email, password=password)
        except gdata.spreadsheet.text_db.BadCredentials:
            droid.dialogCreateAlert("Username or password incorrect.")
            droid.dialogSetPositiveButtonText("OK")
            droid.dialogShow()
            redo = droid.dialogGetResponse()
            password =''
            continue
        else:
            return client

def spreadSheetSetup(client, defaultTitle = 'Science Data'):
    versionNumber = client.GetDatabases(name=defaultTitle)
    if len(versionNumber) > 0:
        droid.dialogCreateAlert('Science Data %d' % len(versionNumber))
        droid.dialogSetPositiveButtonText("OK") #Yes option box
        droid.dialogShow()
        understood = droid.dialogGetResponse()
        spreadsheetTitle = defaultTitle+' '+str(len(versionNumber))
    else:
        spreadsheetTitle = defaultTitle
    return client.CreateDatabase(spreadsheetTitle)

def time2Sense(defaultTime=5000):
    maxTime =0
    #Enter time for sensing
    while maxTime == 0: ##How long to sense?
        try:
            maxTime=int(droid.dialogGetInput("Time", "How long to collect data (in milliseconds):",str(defaultTime)).result)
        except TypeError:
            droid.dialogCreateAlert("Please enter a numeric time")
            droid.dialogSetPositiveButtonText("OK")
            droid.dialogShow()
            droid.dialogGetResponse()
            continue
        if maxTime > 30000: #30 seconds max for optimal upload
            droid.dialogCreateAlert("Warning this could take a long time to upload.")
            droid.dialogSetPositiveButtonText("I accept the risks")
            droid.dialogSetNegativeButtonText('New time')
            droid.dialogShow()
            check = droid.dialogGetResponse().result
            if check['which'] == 'positive':
                return maxTime
            else:
                maxTime = 0
                continue
        return maxTime

def doScience():
    droid.dialogCreateAlert('Are you ready', 'Click yes to begin sensing, or no to cancel')
    droid.dialogSetPositiveButtonText("Let's do science!") #Yes option box
    droid.dialogSetNegativeButtonText("Nah let's cancel") #No option box
    droid.dialogShow()
    return droid.dialogGetResponse().result

def senseAccel(endTime,dt=100):    #Sense and store accel data
    timeSensed=0
    tempScience = []
    droid.startSensingTimed(2,dt) #dt = time between sensings
    while timeSensed <= endTime:
        tempScience.append(droid.sensorsReadAccelerometer().result) #add new accel data to list
        time.sleep(dt/1000.0)
        timeSensed+=dt
    #Stop Sensing
    droid.makeToast("Done")
    droid.vibrate(300)
    droid.stopSensing()
    return tempScience

def main():
    db =spreadSheetSetup(login())
    endTime = time2Sense()
    ready = doScience()
    if ready['which'] == 'positive':
        countdown()
        science = senseAccel(endTime,dt)
        table=db.CreateTable('Accelerometer',['t','x','y','z']) #Beware spreadsheet column names cannot be uppercase if you are going to add to them later http://code.google.com/p/gdata-python-client/issues/detail?id=363
        droid.dialogCreateHorizontalProgress('Progress','Uploading to Docs',len(science)*3 )
        droid.dialogShow()
        progress = 0
        time = 0
        for data in science:
            table.AddRecord({'t':str(time),'x':str(data[0]),'y':str(data[1]),'z':str(data[2])}) #AddRecord requires strings as arguements str()
            progress+=3
            time+=dt
            droid.dialogSetCurrentProgress(progress)
        droid.dialogCreateAlert('Done', 'Go check your data on Docs')
        droid.dialogSetPositiveButtonText("OK") #Yes option box
        droid.dialogShow()
        droid.dialogGetResponse()

if __name__ == "__main__":
        main()

Google Doc Discussions for Hybrid Learning

Subscribe to BrokenAirplane

Google Documents rock! Where else can you get a free document editor that you can share and collaborate with others? Recently, Google released Discussions which were an improvement on the comments you could embed within a document. With discussions, you could leave a comment and have it be sent to a recipient, who could in turn reply in conversational form. Now students could work together to refine their work and teachers could give feedback all leading toward beautiful work.

With recent improvements, you can track when the last time a page was accessed and what they said. This was rolled out without much fanfare, but for educators, it makes a big difference! Typically to get this kind of data you would need to use a classroom management software like Moodle or Edmodo, both fine tools but they require you to leave what you are doing and go somewhere else on the web. All of this is within the Google Apps that you are already using.

This summer, Patrick and I are working on a hybrid multimedia/graphic design summer school class. We wanted students to be able to work from all over the city without having to come into town. Plus Patrick wanted to be able work with students while he and his Graphic Novel project students are exhibiting at Comic Con (congratulations to them by the way). A concern with the hybrid class was "seat time", how would the school be able to certify that the students had worked long enough to qualify for the Carnegie Credit Hours? 

With Discussions, that problem was resolved. With the class a mixture of synchronous face-to-face video conferences, and asynchronous independent work students could demonstrate their mastery as well as seat time with time logs in their Google Doc. We are really excited about the prospect of conducting a full class without a classroom. More on our successes and struggles will appear in the next few weeks I am sure but I figured that many could benefit from this and I wanted to get the tip out as soon as possible. Enjoy!


Subscribe to BrokenAirplane for all of the relevant technology and education news/information. 

Google Docs Discussions Lead to Stronger Collaboration and Refinement

If you have grown accustomed to writing in the cloud using Google Docs, you are collaborating with others in writing your documents. I use them for grant proposals, feedback from fellow bloggers, and documents within my district. This is wonderful as long as you and your collaborators are all online at the same time or you remind them to check the document. With the new feature "discussions", you can have a more focused and efficient collaboration.

Note: This will only work on newly created documents (but you can always cut and paste into a new one). 

You are already able to insert "comments" into a document from the Insert menu (or by selecting Ctrl + Alt + M), now just add the person or person's you wish to notify that something has changed or needs changing. The way to do that is by typing the person's email address with an @ symbol in front of it. I have placed an example of how this might look on the right.

This will send an email to the person notifying them that changes have been/need to be made.

This will be tremendously helpful in moving classrooms away from needless paper waste while refining or groups creating a document collaboratively. Now you can leave comments on your student's work and they will be notified what they need to change in order to create beautiful work. 


Subscribe to BrokenAirplane for great tutorials and educational news.

Google Forms for Online, Easy, and Free Data Collection

In this world, data is king. Being able to gather and manipulate data is incredibly important. Keeping track of student information, conducting experiments in science class, administrative tasks, and all of the other instances where data streams through our lives.

The problem has been that data collection and analyzing has previously been expensive or tedious to do. Once again, Google has brought equity to the situation with Google Forms. Built into Google Docs, this form allows you to gather and understand data easily and from any computer with Internet.

How to use Google Forms:
1) Open Google Docs, click Create New, and select Form.
2) Title your Form and enter in any additional instructions you would like (e.g. make sure to answer in inches or all answers must be in complete sentences).
3) Now it is time to create questions for those who you send out the form to. Add a name and question text (e.g. true or false, coordinate points should be written as (x,y). You have 7 choices for question types:
  • Text: Short, one sentence responses
  • Paragraph Text: Longer responses
  • Multiple Choice
  • Checkboxes: Like multiple choice with options but more than one option can be selected.
  • Choose from a List: Like multiple choice but with a dropdown menu.
  • Scale: Set an upper bound and lower bound and submitters can provide a response in that range (e.g. describe your happiness on a scale from 1-5).
  • Grid: Like scale but with the ability to have more than one row or column.
4) Before clicking done, check the box if you would like to make sure that the question is answered before it can be submitted. 

5) After completing a question and clicking done, you have three options. 
  • Pencil: Edit the question again.
  • Boxes: Duplicate this question (so you can have it asked again or modify slightly.
  • Trash: Delete the question.


6) From there you can click the Add This button and add more questions or page breaks.
7) Change the theme if you would like.
8) If you are using Google Apps you can have the Form automatically collect the submitters' name (by clicking the checkbox near the top of the form), and if you are using a personal Gmail account I would recommend adding a question which asks their name. This will prevent duplicate submissions and assist with accountability.
8) Now to send out the form to those who need it:
  • Click Email this Form to send the form out via email. You have the option to embed the form into the email.
  • Click More Actions to embed the form in your website or blog.
9) All of your data will be collected in a Google Spreadsheet. To see the data, you can either go to the main Google Docs or click on See Responses and then Spreadsheet.
10) From the spreadsheet you can click Insert and Chart if you would like to see it graphed. Or click Tools and Sort to order it in a particular way.

Suggestions for using Google Forms:
  • Collecting Data: 
    • I have seen teachers use a Google Form to collect data from a project. For example, students could use phones to submit their information for class averages and analysis.
    • Our school has a policy against MP3 players in the class, I collect data from the students about a Google Form about a band that relaxes them and one that energizes them and input this information into Pandora. I then have music to play in the class when students are working.
  • Polling: 
    • Last year our ASB made the switch from collecting and tabulating results from their elections from paper to Google Forms. The difference was that results were released in hours as opposed to a day and much less headache.
  • More great examples can be found here.
I hope you benefit as greatly as I have from this technology. If you have any questions or suggestions leave it in the comments.


Links:
GSites - Websites
GForms - Data Collection and Surveys

Google Apps Tutorial Part 3 Google Docs for Document Collaboration

In previous years, I would create a document on one computer, email it to my department for refinement, someone would change something, email it back and forth and we could never remember which file was the newest.

I also had the unique situation of replacing the Biology teacher who taught me in high school. This led to my inheritance of 30 years of incredibly useful lessons, worksheets, project forms, assessments, etc. Over the course of that summer I laboriously scanned the documents into my computer generating thousands of megabytes worth of gold. Now the problem was getting it to my school computer and editing them so I could use them in my class.

Neither of these problems had simple solutions until Google Docs emerged. Through this Google App all of us can create, share, collaborate, and store anything that we use in our classes. Also highly important in this day and age, it allows us to generate less wasted paper.

Here are some benefits or suggestions regarding Google Documents:

Edit Anywhere: This is my favorite part because I know that whether I or a group of people are working on a document, it is always there anywhere I want.

Upload and Share: Whether you have a document, picture, video, or anything else it can all be stored in GDocs which provides all of the flexibility you need. With highly customizable sharing settings, you can share the files with your department, students, teaching partner, or no one. It is all up to you on how and who you collaborate with.

Versatility and Forms: You can create Documents, Spreadsheets, Presentations, and Drawings in Google Docs, but the one I have found that saves the most time is the Form. The form allows you to create questions or surveys to collect data that is stored inside of a spreadsheet. This can then be turned into a chart or analyzed as needed.

In one example, I created a student survey form to gain feedback on learning styles and another to collect their answers on a take home test (which I was able to grade far quicker). I helped create one for our ASB to utilize for school elections (and the winners were known instantly after polls closed).

The ability to quickly collect data through Google Forms is so powerful that if you sign up for a Google account for no other reason than this you will find it pays off immeasurably.

Bookmarks: An added bonus of using Google Docs and the Chrome Browser, is that it will synchronize your Internet Bookmarks on any computer that you have set it up in your settings. As educators, we come across so many great sites, and the ability to access those no matter what computer you are on (or never worry about losing them if your computer breaks) is priceless.

Paperless: With Google Docs I went from having filing cabinets worth of worksheet masters and lots of my computer's memory being used up, to being able to go anywhere and have my entire curriculum at my fingertips. This is especially beneficial to teachers without a full time classroom, or anyone with an absent student.

However, it should be said that you should always have a backup of your files. You never know what could happen and so you should never put all of your eggs in one basket. I scanned all of my documents and uploaded them to GDocs but I also have them stored on CDs. These lessons and files represent years of blood, sweat, and tears and to lose them would be frustrating to say the least.

Beginning your journey: If you decide to use Google Docs and want to move all of your old documents to GDocs you can use the Batch Uploader to get them there quicker. An important thing to remember is that GDocs is constantly evolving and improving. If you have a document that has a lot of formatting (e.g. tables, outline bullets) then you would do best to create the document in Word and then upload it to share, or turn the file into a PDF and upload it to preserve formatting. There have been very few times that I was displeased with the outcome but it is worth mentioning.

I hope GDocs saves you as much time and heartache as it did for me. If you have any other ideas, suggestions, or questions leave them in the comments.

Stay tuned because the next post involves the Google Calendar (never leave home without it)!

Google Document Updates

Just a quick update, Google Documents received an update making it all the more useful in the classroom. Of most interest to Math and Science teachers is the ability to insert an equation.

Previously you could create an equation in Word or Open Office's Writer but when you uploaded the document to Google Docs the equation would turn into a blurry unreadable picture. That problem has been resolved.

Note: You will not notice these changes in your old documents, you must create a new one.

To use this feature:

  1. Open Google Documents
  2. Click on Create New
  3. Click on Document
  4. To add mathematical equations click on "Insert"
  5. Click on "Equation"
  6. You will then see new options for you to create fractions, mathematical/scientific symbols.

Enjoy!