A Hectic Day:
Today's blog is as long as a book, but please read it.... you may find helpful information here. (You can omit the first paragraph, where I am just complaining about being overwhelmed).
I don't know about you all but I'm pretty overwhelmed. Maybe it's the outside obligations (car pools, other drivers in the family "borrowing" my car to get to college, etc.), that are stressing me out - Miriam, I think I need to check in with you! Now that I am relieved of my obligation to take my 11 year old swimming and one of the twins is in college (tonight is easy - instead of 3:00 PM - 9:30 PM, she only has 6:30-9:30 PM), I can get back to work! I think I "bit off more than I can chew" for this class - coming up with a project design and trying to implement it along with all of the other requirements of the class is more than I can multi-task.
Google Tools: I'm definitely getting more used to how to find things in Google, between Drive (to find the documents), Gmail, iGoogle Home page, and our Google Circle, I felt like I was going in circles, trying to click on the correct tabs. It requires full-attention multi-tasking. In the old days, I would program applications with 4 split screens on a very large screen. Even though you can size each screen nowadays, using the tabs is not as easy!
Lesson Plans: I avoided this once again, today, as I find this section the most intimidating. I have not written a lesson plan in so long that I just can't get started. HELP! We need 3 of them. This, for me, is the hardest part of the course.
Google DRIVE:
I put my documents into different folders so as no to confuse everything. Am finding it simple to differentiate between docs from the icons.
Google Presentation (Power Point equivalent):
I also started to update the class Presentation, but need to do much more with it. Played a little with animation.
Google Forms/Spreadsheet Interactions:
1 - I was troubleshooting as to why my form's colors differed when activated by email versus being embedded on my website. Changing the theme fixed the problem. I guess the other theme had some bugs.
2- I added fields to my Google Form, to be able to capture the actual process I'm trying to build with these tools. Did a lot of testing of data input and ramifications to the resulting spreadsheet. Tried to change column names in spreadsheet and test from the form. If you delete a required column and the form has it, it will add the column to the end of your form.
Interesting: If you modify the header title on spreadsheet, it actually changes your text on the form and keeps the spreadsheet column in the same place.
4) As far as the spreadsheet goes, you can alter columns locations, moving the entire column (including Header names) and the data will continue to be populated correctly in subsequent forms.
5) You can filter and put data validation on the spreadsheet but it is NOT enforced in the form.
Wish List for Google Forms:
I have done application development, so I am trying to use this tool in a much more complicated way than it was probably designed. I would like to design a form that has data entry fields (areas that you enter data into) that are grouped together, side by side, in a square, or some other grouping. As you all know, Google Forms only allows you to ask your questions in a linear way, one question listed after another, going straight down your form.
I would also love if it had the capability of cross-edit validation. For example, if you answer "yes" to a question, you could set a second field to be required.
I would also want data validation - i.e. to make sure that numbers are entered, to help the user with the formatting to ensure that the data produces formatting that is consistent between form submissions.
Google versus Microsoft:
There is complex programming that can be done within Microsoft Word and Excel, but most versions of those products cannot be shared in the same way as these Google Docs. Microsoft Office 365 ( which replaces the Business Productivity Online Suite may do this, but it is probably very costly for businesses. Google, as you have all noted, is FREE. If you're interested in looking into Microsoft Skydrive, click on this link: http://office.microsoft.com/en-us/web-apps. There actually is file-sharing capability and much more. Actually, it is something for a business to investigate. They do not have non-profit pricing, though.
For academic institutions that are ready to take advantage of the cloud, Office 365 offers free email, instant messaging, group video and voice chat, and online document viewing and editing.
Questions You ALWAYS Wanted To Know About Google Forms (but never asked):
1) Ramifications of deleting a field from your form or column from the spreadsheet: When you delete a field from your form, and re-add it, the data will only get populated to the newly added field, in a new column. Now for the opposite, if you delete a column from the spreadsheet, it will still be on the form. When someone submits the form, the column will be re-added in the last column of the spreadsheet.
2) Shared document and spreadsheet: Because of the fact that Google docs are shared, you can have the spreadsheet open and even be editing the form and someone else can update the spreadsheet by filling out their form.
Hint: When testing out a new form and you want to compare the different field-types, put your field-type name in the Help text.
3) You can move a column within the spreadsheet version of your form(don't change column title/header name) and it will populate correctly.
I think that's enough for today. I will really have to face the Lesson Plans tomorrow, though.
Wow Karen, you were busy! I too had an issue with the lesson plan as I had not written one in at least 10 years, but once I started it wasn't that bad. I just kind of thought out what I do everyday in therapy, picked and activity and described what I do with the kids. I did the best I could with interpreting the lingo on the form as much of it was foreign to me. I just wrote what I thought made sense as related to speech/language therapy. I wish I could show you the first one I just finished but I can't seem to figure out how to post it. I tried a bunch of things but nothing is working. Anyway, good luck, don't stress and have a good night.
ReplyDeleteI agree that the Lesson plan is most difficult for me also...maybe because we are not used to that in speech language world...I like your wish idea for google forms, it would be nice to be able to have that feature. Maybe email Google and have them add that feature...it could even already be in the process for all we know!
ReplyDeleteI hear everyone about the lesson plans. But to the credit of Erin it is very basic. The ones that I make my Dominican College students do is like an encyclopedia. Karen you put a tremendous amount of work into this blog! Amazing.
ReplyDeleteAs for the limitations of Forms- I agree with you on most things. We have to keep in mind these tools are free and meant to be used by a basic user. If you are looking for more advanced tools then you would have to probably pay. This goes for documents, spreadsheets, website building, drawing, etc...
Karen,
ReplyDeleteI am totally intimidated by all your comments here! From what you wrote I can tell you have a very technical background (and a busy life). For you, the lesson plans should not be a problem, just keep them simple. I found all your observations, the ones I understood, interesting and informative.
Mary - I'd be happy to explain anything you didn't understand. Let me know which parts are of interest to you.
ReplyDelete