Friday, June 29, 2012

Friday's Blog

Words cannot describe how fortunate I feel that I can sit hear and blog to you all. My morning was spent on workingn with Erin trying to share my form. When I had to run to do csrpool at 1:30 my system crashed. After the carpool, I tried to get onto google drive from a 2nd computer, and I believe the filter didn't let it thru, but I was still suspicious that I did something to the drive. While I was working to restore the computer, I went onto computer 3 and was able to install Chrome and access google. Wheww! At least I knew that I didn't damage my files. I uploaded the form with my non-preferred method, but at least it worked. Now that computer couldn't access my wireless network and I had to check on the restore. It is almost ready now 6:12 pm!!!!! I am trying to post and blog at every chance I have but am really being blocked today. The good news is that the presentation is almost finished, the form is finished, the blogs are almost finished and I'm really learning to type quickly on the iPad because I only have 9% charge left and I have no time to look for the charger. At a minimum, I hope my blog has provided some entertatinment for you readers! I have burnt 2 chickens and I smell like a barbeque today but my blog is here for you to enjoy. I'll try to post more updates as they ocxcur - I'm expecting lots of good things to happen soon!!!!

Thursday, June 28, 2012

Thursday's Post

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.

Wednesday, June 27, 2012

Another Interesting Tidbit about Google Forms

DATA ANALYSIS:
Forgot to tell you all - when you look at your form in spreadsheet format, you can get an analysis of the spreadsheet in graph format. It is really cool. For example, I have a list of people on the sheet who can initiate the process. Based on the amount of data in the spreadsheet, since I have the "initiator" as a required field,  it indicates the percentage of data initiated by each person. This can be of interesting use, no? This data is obviously bogus, but you get the idea....



CURRENT PROBLEM:
Embedded on Website
Same for accessed from email link
The problem I'm having with my form is that when it's embedded on my website (top picture), the colors are reversed from what they are as-is or in an email or live form (bottom picture). Any ideas, anyone? I'm still researching but if any of you have insight, I'd be happy to go down that route...
Today I've been working on integrating Google Forms and Google Spreadsheets. I've been playing with the form to make it a data entry process resulting in a spreadsheet that can be further refined to complete the OSSS Evaluation Process.

I changed the column order that the form generated on the spreadsheet. I made data validation on the spreadsheet to see if it will kick back to the form with invalid data but it DOES NOT interact with the form and therefore can generate invalid dates and data.

It is important to me to generate a unique combination of Last Name-First Name-Date of birth, so they are required on my form. However, this is NOT a great database platform and it will not be foolproof. (Maybe I shouldn't sign my name to it!). At a minimum, I guess it will give the OSSS staff a taste of what they could have to streamline their process.

One thing I did last night was to embed the form into my website in School Center. Be advised that I don't like the look of the theme on the form when it's embedded because you can't read it. The actual format you may see now is subject to change. 


I'm creating a link to my site to the form. CLICK HERE to see my home page (this is the better way) or click on the NEW OSSS PROCESS to go directly to the form. If you select the form from the website, you will get the real feel of how it may be used from a website (rather than being emailed a copy of a form to fill out. Ultimately, I might have this on a password-protected page that can only be used by authorized users. 


** IMPORTANT INFORMATION ABOUT FORMS:
The Google blogger site as well as Google forms are dynamic (I think this applies to all google products, but I can't vouch for that yet) . That means that when you change it and save the changes, it has changed how it looks to EVERYBODY from now on (until your next update). So if you sent a link with a typo, for example (like I did yesterday), once you catch it and fix it on your blog or form, there is no need to worry further because it is fixed forever more. Even when your form is embedded somewhere, it is using the current version of the form (even when it's on YOUR google "drive"). It is not accessing your computer; rather, it takes it from the "drive" up there in Google-land. 

Tuesday, June 26, 2012

Just a follow up to my previous post, I plan to use Google Docs - forms and spreadsheets, to start out with. 
I'm interested in so many of the tools that I don't know where to start. I'd love to integrate everything! 
Oh my goodness, I just saw Google Code. That's right up my alley... will keep you posted.

Prototype for OSSS Process Flow

Summary:
I have chosen to do a prototype of a bigger project that can't be completed during this week. I would like to  integrate various Google Tools in a process work flow environment. 


Business Need:
In OSSS -Office of Special Student Services, there is room for a streamlined process, by which students get into the "system" to be evaluated. As that process moves along, various evaluations may need to be done. The system currently uses email to track who is doing what and whether or not evals are completed. Only the emailer and recipients of the email are kept in the loop. I'd like to centralize the information and provide a way for everyone involved to take ownership of their piece to provide a resultant database/spreadsheet with status. (This may be unrealistic but it's certainly a potential project).


Process Workflow:
Currently, we have several sources which directly feed specific people withing the OSSS. They would provide the student name and date of birth, school, information as to whether or not there is a Prior Written Notice, etc. Those individuals have to reach out to other departments to find out more of the parent/teacher concerns about this child to determine what kind of evaluations need to be done. Further down the road, a CSE meeting is setup. The evaluators need to know the CSE date to ensure that their evaluations are done in a timely manner. 


Potential Development:
I'm hoping to create a form/forms that can be submitted by the initiators of the process (perhaps a list of individuals) to create new student names (and accompanying info) to be merged into the centralized spreadsheet. As I go along, I may want to use other Google Tools to embellish this process, but this is my starting point. 


What do you think?