Here is my persuasive video for class. The video is longer than the 3 minute requirement, because I will be using it to present some information to my administration. I may tweak the video before I present in January, but this is a good start.
Saturday, December 18, 2010
Thursday, December 16, 2010
PE8_More Google (quiz and Calendar)
I have not quite figured out the color coding from the article. I'm still working on that.
But a fellow Full Sail month 6 or 7 student shared a formula with me for an Excel spreadsheet. So I tried it in Google Docs...and IT WORKED!
Here is the formula. Basically you are taking the "english word" column and checking to see if "your answer" column matches. If it does then the "check spanish" column will state "TRUE". If it does not match, the column will state "FALSE".
This picture shows me "hide column". The reason I wanted to Hide Column B & D was to prevent student cheating (column B was answer key), and column D was their results. Now, you can leave column D shown to allow students to have immediate feedback and the ability to try again.
This pictures shows the step of "freeze column". I chose to freeze column 2 to prevent students from "unhiding" the column to see the answers.
Sharing the spreadsheet with a "student' this happens to be with me as I set up a teacher/classroom email and iGoogle page.
Here is the "quiz" that the "student" took. as you can see the student got a 7 out of 10 on the quiz. Now my initial thought was "Oh my gosh, now the next student is going to see the answers the first student put in." But then I thought back to the ability to review the history of the changes. So if I could train my students to take the quiz. Save it. Clear the quiz answers. Save it again. Then the next student can take the quiz without the answers.
This next screenshot is of a quiz on a Google Form. I reviewed forms from a previous section, but had forgotten about this screen. So when the article said that you can use this screen from the form to grade, I thought I'd check it out. I think this is also where you can color code the columns, but again I haven't figured that part out yet.
Now moving on to Google Calendar. I am interested in this function because students like to know when assignments are. My current set up is very cumbersome and they often have two places to look for calendars. They are quite frustrated. So to lighten the load...I thought I'd give this a try. I like how I can have multiple calendars for myself, but then have one class calendar for Spanish 1 and another for Spanish 2. My only concern is I have three different classes with three different schedules (Block schedule, 4-day schedule (M-Th), and a Hybrid 4-day/block schedule (M,T,Th,F). So to have all the assignments on one calendar might make it cumbersome. But I'll just have to work that out.
But a fellow Full Sail month 6 or 7 student shared a formula with me for an Excel spreadsheet. So I tried it in Google Docs...and IT WORKED!
This picture shows me "hide column". The reason I wanted to Hide Column B & D was to prevent student cheating (column B was answer key), and column D was their results. Now, you can leave column D shown to allow students to have immediate feedback and the ability to try again.
This pictures shows the step of "freeze column". I chose to freeze column 2 to prevent students from "unhiding" the column to see the answers.
Sharing the spreadsheet with a "student' this happens to be with me as I set up a teacher/classroom email and iGoogle page. 
This next screenshot is of a quiz on a Google Form. I reviewed forms from a previous section, but had forgotten about this screen. So when the article said that you can use this screen from the form to grade, I thought I'd check it out. I think this is also where you can color code the columns, but again I haven't figured that part out yet.
Now moving on to Google Calendar. I am interested in this function because students like to know when assignments are. My current set up is very cumbersome and they often have two places to look for calendars. They are quite frustrated. So to lighten the load...I thought I'd give this a try. I like how I can have multiple calendars for myself, but then have one class calendar for Spanish 1 and another for Spanish 2. My only concern is I have three different classes with three different schedules (Block schedule, 4-day schedule (M-Th), and a Hybrid 4-day/block schedule (M,T,Th,F). So to have all the assignments on one calendar might make it cumbersome. But I'll just have to work that out.
 |
| Showing both calendars |
 |
| One calendar alone |
 |
| the other calendar alone |
I'm looking forward to the next month when I delve further into this cloud!
Tuesday, December 14, 2010
PE7_Google Quiz
Thanks to a dear librarian friend...I have found my answer. It was right under my nose the whole time.
One of the comments in the article was to color code the columns. The other is to have a 2nd sheet with codes. I'll be trying those tomorrow. Will repost my results.
I have also completed the training at Lynda.
One of the comments in the article was to color code the columns. The other is to have a 2nd sheet with codes. I'll be trying those tomorrow. Will repost my results.
I have also completed the training at Lynda.
Sunday, December 12, 2010
PE6_Google Forms
Finally, I have gotten to the videos on how to create a form.
If you would like to view the form created click here.
Here is the form below if the link did not work:
If you would like to view the form created click here.
Here is the form below if the link did not work:
PE5_Google Spreedsheet
Part 2 of the Google doc experiment.
I wanted to accomplish the certification for Google Docs through Lynda.com. However, I am half way through and BORED out of my mind. I have made it through the documents videos. I am now starting the spreadsheets videos.
Through my previous jobs and education, I have become pretty proficient in the Microsoft Office products. So these basic videos on Google Docs and Google Spreadsheets are pretty dang repetitive. At first, I was REALLY disappointed in the fact that these videos didn't teach me a whole lot of new information. BUT then I realized that my learning curve will be substantially small due to my previous knowledge of similar software.
Therefore, I have a new thought...I'll keep watching the videos and keep gleaming nuggets of information from these videos. Because I KNOW that I will be learning a lot when the videos start talking about forms. These are one area that I never worked with (outside of class) so therefore I did not retain the information.
My classroom will be able to benefit from these docs online. It'll save time from emailing assignments.
Here is a sample grade sheet.
So stay tuned for more blog posts on my Google Docs Experiment.
I wanted to accomplish the certification for Google Docs through Lynda.com. However, I am half way through and BORED out of my mind. I have made it through the documents videos. I am now starting the spreadsheets videos.
Through my previous jobs and education, I have become pretty proficient in the Microsoft Office products. So these basic videos on Google Docs and Google Spreadsheets are pretty dang repetitive. At first, I was REALLY disappointed in the fact that these videos didn't teach me a whole lot of new information. BUT then I realized that my learning curve will be substantially small due to my previous knowledge of similar software.
Therefore, I have a new thought...I'll keep watching the videos and keep gleaming nuggets of information from these videos. Because I KNOW that I will be learning a lot when the videos start talking about forms. These are one area that I never worked with (outside of class) so therefore I did not retain the information.
My classroom will be able to benefit from these docs online. It'll save time from emailing assignments.
Here is a sample grade sheet.
So stay tuned for more blog posts on my Google Docs Experiment.
PE4_Google Documents
This week's Practical Experience was tied between Google Docs and Flash. I have networked with some students a few months ahead of me in the EDMT program at Full Sail. I have seen some work they have done using Flash and am excited to learn more about that...in time.
This week I chose Google Docs because of the ability to use it right away in class. I have started using the documents to create vocabulary worksheets for my Spanish students. I divided the class into groups. Each group was responsible for a certain section of the vocabulary list. They found the definitions for the words and were then able to type them into the Google Doc. One class was creative and changed formatting. The other class wasn't so creative and left the format at the default.
Learning #1: When doing a vocabulary list, I should type the words and format as needed prior to assigning students to the section. This will allow me to control tabs or tables to separate the word from the definition. This is also helpful when dealing with verb conjugations.
I am using Lynda.com Google tutorials. So far it is pretty similar to Microsoft Word. Being that I am pretty proficient in MW, I'm excited to know that I can go ahead and upload my current documents. The sharing aspect of these documents and folders are going to be really useful.
Learning #2: Sharing documents and folders, students can turn in their assignments to me by sharing the document with me or by having an assignment folder that they share with me.
Learning #3: I can change the language to Spanish for spell check!
See sample.
Learning #4: The ability to bookmark within a document will be helpful when I start adding class notes. I can have a content list or chapter title at the top of the document with bookmark links to the actual notes within the document. No more scrolling!
Learning #5: you can revert back to previously saved versions. This will HELP me because I have a weekly calendar that I use for both classes. If I forget to SAVE AS and change the document title, I lose the previously saved classes' calendar. YES this has happened many times. SO this will save me!
Stay tuned for more learning!
This week I chose Google Docs because of the ability to use it right away in class. I have started using the documents to create vocabulary worksheets for my Spanish students. I divided the class into groups. Each group was responsible for a certain section of the vocabulary list. They found the definitions for the words and were then able to type them into the Google Doc. One class was creative and changed formatting. The other class wasn't so creative and left the format at the default.
Learning #1: When doing a vocabulary list, I should type the words and format as needed prior to assigning students to the section. This will allow me to control tabs or tables to separate the word from the definition. This is also helpful when dealing with verb conjugations.
I am using Lynda.com Google tutorials. So far it is pretty similar to Microsoft Word. Being that I am pretty proficient in MW, I'm excited to know that I can go ahead and upload my current documents. The sharing aspect of these documents and folders are going to be really useful.
Learning #2: Sharing documents and folders, students can turn in their assignments to me by sharing the document with me or by having an assignment folder that they share with me.
Learning #3: I can change the language to Spanish for spell check!
See sample.
Learning #4: The ability to bookmark within a document will be helpful when I start adding class notes. I can have a content list or chapter title at the top of the document with bookmark links to the actual notes within the document. No more scrolling!
Learning #5: you can revert back to previously saved versions. This will HELP me because I have a weekly calendar that I use for both classes. If I forget to SAVE AS and change the document title, I lose the previously saved classes' calendar. YES this has happened many times. SO this will save me!
Stay tuned for more learning!
Saturday, December 11, 2010
Subscribe to:
Posts (Atom)