At Eisenhower we have our FirstClass email accounts and we also have our EisenhowerMS Google Apps accounts. This means that you may have to check email in two places. There is a way to forward all of the email sent to your Google Apps Gmail account to your FirstClass account.
The video below shows you how to forward the email from your Gmail account to your FirstClass account. Note that while our Google Apps domain is closed to outside email I did allow the sending and receiving of email from our FirstClass accounts.
At the end of the video I did not show the final step - in order to confirm the forwarding address you will have to go to your FirstClass email account and get the confirmation email from Google. In this email is a Confirmation Code Number. Be sure to copy this number and paste it into the box that asks for your confirmation code.
Thursday, November 18, 2010
Monday, November 15, 2010
What do we really know about 6th grade peer pressures as teachers
https://spreadsheets.google.com/a/eisenhowerms.org/viewform?hl=en&formkey=dDFIanJwMmNlaWlWNjlUX3RDXzhMLUE6MA#gid=0
This was a tobacco survey I used last year posted on my website, answers were anonymous and I asked students to take it, I told them it wasn't mandatory because I couldn't track who took it but that I wanted them to take it and give honest feedback so as the Health teacher I could have a better pulse on issues concerning middle school students and more specifically 6th graders. I was pleased with the amount of students that took it although according to the data I collected we teach in a relatively peer pressure and smoke free town. It was just an experiment to see if kids would take such a survey letting us into "their" issues and they did, now the challenge will be finding out what tools and support kids in our school really need to learn and grow in the context of social/emotional health during adolescence.
Best,
Adam
This was a tobacco survey I used last year posted on my website, answers were anonymous and I asked students to take it, I told them it wasn't mandatory because I couldn't track who took it but that I wanted them to take it and give honest feedback so as the Health teacher I could have a better pulse on issues concerning middle school students and more specifically 6th graders. I was pleased with the amount of students that took it although according to the data I collected we teach in a relatively peer pressure and smoke free town. It was just an experiment to see if kids would take such a survey letting us into "their" issues and they did, now the challenge will be finding out what tools and support kids in our school really need to learn and grow in the context of social/emotional health during adolescence.
Best,
Adam
My Survey
Here is the link to the survey I created for my students to take as part of tomorrow's homework. I can use the data collected to better plan and incorporate activities that students enjoy and reflect on the amount of time students are using to study and complete daily homework.
http://spreadsheets.google.com/a/eisenhowerms.org/viewform?formkey=dDcxQVZjZzhXRHJrT3JlVW5hM1I5VWc6MQ
http://spreadsheets.google.com/a/eisenhowerms.org/viewform?formkey=dDcxQVZjZzhXRHJrT3JlVW5hM1I5VWc6MQ
Sample Student Created Surveys
Google Forms has several applications (pun intended) in our classrooms. One is for us to survey our students, but we can also create projects in which students use Google Forms to survey their peers about various topics. The cool thing about this is that the kids find a direct connection to the data that results from the survey because they supplied that data. It's not data from somewhere "out on the Internet", it's data from them and their friends.
In the 7th Grade tech classes, we have the students create surveys that explore how they and their peers use technology. Then we analyze the results of their surveys and generate class discussion about the impact of technology on our lives.
Here is the link to the directions for this project. The top part of the page is directions for creating a survey, which you might find useful. Near the middle of the page is where the students share their survey by posting a link into a teacher created form. Then all of their survey links end up in a spreadsheet, where they can go to take each other's surveys.
See Some Examples
You can check out these examples of student surveys.
In the 7th Grade tech classes, we have the students create surveys that explore how they and their peers use technology. Then we analyze the results of their surveys and generate class discussion about the impact of technology on our lives.
Here is the link to the directions for this project. The top part of the page is directions for creating a survey, which you might find useful. Near the middle of the page is where the students share their survey by posting a link into a teacher created form. Then all of their survey links end up in a spreadsheet, where they can go to take each other's surveys.
See Some Examples
You can check out these examples of student surveys.
Friday, November 12, 2010
Another number question
I made those changes to the column and did a test and it worked. But I have one question still. I gave a multiple choice question that the answer was 2:1. They did not have to write this in since it was an option to click on. Some of them came up 2:1 in the spreadsheet but some came up as a time. Shouldn't they have all come up the same? Most came up as a time, but some were a ratio as I typed. Doesn't seem to make sense to me.
Jen,
What happened was I checked your spreadsheet out and noticed the problem you mentioned. Then I changed the column to text only. It did not affect the information already in the spreadsheet but all of the answers that came in after I changed the format of the column changed. I found this out by sorting the entries by time.
Harold
Jen,
What happened was I checked your spreadsheet out and noticed the problem you mentioned. Then I changed the column to text only. It did not affect the information already in the spreadsheet but all of the answers that came in after I changed the format of the column changed. I found this out by sorting the entries by time.
Harold
Thursday, November 11, 2010
Format for Numbers
I had my students take the survey and as I was looking through their responses I realized that some of the numbers automatically formatted in certain ways. One question was on ratios and it was multiple choice. The answer was 2:1 and in the spreadsheet it turned them into times. I also realized that when students tried to type fractions they came out as dates. I guess I could have said in the question to express them as decimals. I am wondering if there is a way to change these default formatting issues? My surveys would involve numbers most of the time, so that would be important for me.
Jen,
Spreadsheets are set to look for certain kinds of symbols like / which means divide if you put an = sign in front of it - so 3/4 becomes 3 divided by 4. If you do not put an = sign in front of it the the spreadsheet treats the number like a date. Once the data is in the cell it cannot be changed. The next time you do a survey like this select the column by clicking on the letter title of the column and then use the format button which has the numbers 123. This is just below the Format and Form menus. Select plain text, the choice at the bottom. Be sure to do this BEFORE the students respond to the form. See image below.
Another thing you can do is use the help text just under the question. You can put an example of the format you would like the students to use.
Harold
Jen,
Spreadsheets are set to look for certain kinds of symbols like / which means divide if you put an = sign in front of it - so 3/4 becomes 3 divided by 4. If you do not put an = sign in front of it the the spreadsheet treats the number like a date. Once the data is in the cell it cannot be changed. The next time you do a survey like this select the column by clicking on the letter title of the column and then use the format button which has the numbers 123. This is just below the Format and Form menus. Select plain text, the choice at the bottom. Be sure to do this BEFORE the students respond to the form. See image below.
Another thing you can do is use the help text just under the question. You can put an example of the format you would like the students to use.
Harold
Wednesday, November 10, 2010
What do we want to learn?
In the comments section please list what you would like to learn about in coming lessons?
Ideas for Using Google Apps
Here are some online resources for ideas on using Google Apps in the classroom:
Tuesday, November 9, 2010
Ways to get people to respond to your form.
Harold,
I read what Annie wrote re: her form appearing as a spreadsheet. Mine does as well. I did go to forms, as you suggest, but then what? How do I keep it as a form for viewing by others who wish to respond to it?
Grace,
When you are looking at the form's spreadsheet you go to the Form menu, select see live form. Then copy the url of the form. You can paste that link onto a web page but it is rather long, https://spreadsheets.google.com/a/eisenhowerms.org/viewform?hl=en&formkey=dEpvMjV1cjFvTnFFb0pSVTBrZTdpNlE6MQ#gid=0
You can also create a link so that you don't have to paste in a lengthy url - Click here to see my form. Or you can embed the form on a web page by getting the embed code and pasting it into the html of a web page, see below.
Harold
Grace,
When you are looking at the form's spreadsheet you go to the Form menu, select see live form. Then copy the url of the form. You can paste that link onto a web page but it is rather long, https://spreadsheets.google.com/a/eisenhowerms.org/viewform?hl=en&formkey=dEpvMjV1cjFvTnFFb0pSVTBrZTdpNlE6MQ#gid=0
You can also create a link so that you don't have to paste in a lengthy url - Click here to see my form. Or you can embed the form on a web page by getting the embed code and pasting it into the html of a web page, see below.
Harold
Subscribe to:
Posts (Atom)