#FallCUE Day 1 Report

On the first day of #FallCUE this is what we learned:
American Canyon had insufficient bandwidth for the number of educators and their devices on campus this morning.  By the afternoon, most problems were corrected--either people had logged off or connected to their phone's hot spot. (note: this was fixed by Saturday, I never found out what the issue was)
Past that glitch in the beginning, there was much to learn.  We went to 5 sessions and burned our brains out on google forms, scripts like form Ranger, green screen videos in the classroom, using add-ons to give students feedback on their writing, building my class website and embedding videos in google forms.

I loaded up on plenty of apps, twitter people to follow, and the real winner of the day was the number of new methods for giving feedback on student writing.
I found out that google classroom is only for schools with GAFE so it's not even worth looking at until I convince someone at my school to advocate the powers that be for that situation.

Session 1 was a run down on automating your work flow with formRanger and formMule scripts (scripts by Andrew Stillman) presented by @John_Eick. Here's a link to his resources which included a step-by-step screen shot of how to set up your documents and sheets.  Very useful for a teacher who is new to this type of thing.  This was the session where the wifi was the worst and got better at every session following this.  John was a really energetic presenter and even I, a relative expert on Stillman's old scripts, learned a few tricks to use in practice.

For session 2 and following, +Peter Hyland  and I split up to hit more sessions and because he had different goals for the PD since his classroom situation with technology is vastly different than mine.  I went to John Eick's next session on embedding videos in google forms and Peter went to the Hour of Awesome.
Embedding videos looks like a sweet way to have students take notes while watching a short video, then the teacher is able to quickly look at the notes and give some feedback on the quality of notes, etc. etc.  There are about 3 uses I thought of in my classroom and the only limitation would be technology access.  Could address that by "flipping" the model" and having those that are able do the video notes at home and others do it in class.  That method would require some planning for the kids not actively taking notes in the classroom.
Peter said the Hour of Awesome was awesome and his notes make it sound exciting. Ask me for the link and I'll share the notes with you.  It covered multiple Google products and a few of the case uses for each that could speed up repetitive teacher tasks and improve the speed of student feedback.

The theme of Day 1 was faster feedback to students.  The teacher has to do a little more time consuming prep and setup on the front end, however it's worth it so kids get a faster and better idea of how they're doing with anything from writing to math to biology notes.  Session 3 with +Kristina Mattis (@KristinaMattis)for me covered some add-ons in google docs that allowed collaboration, composition, editing, and publishing of student work with more modes than just text.  Session 4 with +Cate Tolnai (@CateTolnai) showed me some template examples of how to organize my course content around my class website.  This will be most useful to me this year and next.  Finally, I visited the green screen session and got another round of figuring out how to make some videos and--even more importantly--how to use this type of project in my classes to meet standards.

Overall, an awesome day for information.  The spotty wifi and long lunch line were not enough to dampen the good things soaking in to my brain.
More reports later.

Case Management Documentation and GAS Part 4

I'm writing this down so I can remember why I did things the way I did when I have to go back and either fix it or make a new one somewhere else:

"The less change the better" is a simple motto for some folks. I wanted to keep the new method (my form) of getting Gen Ed feedback as similar as possible to the old method, so I kept the same wording and the same order of questions.  I simply lifted them on to a google form which will plop the answers down in a sheet that autocrat turns into a nice PDF that looks identical to the version we use now.  The output keeping the same look is only important to me so that the admin and district people who are used to seeing our forms can feel comfortable.  More important is that the "front end"--where the Gen Ed teachers look at it--looks as similar as possible.

Here's where my problem arises: I have to add some pre-filled, superfluous "questions" to the form so that autocrat will spit out the the PDFs exactly how I want them while keeping the formatting customized to each student.  Information such as student initials and case manager emails are easy for a spreadsheet to look up and calculate, however, this behind the scenes look up has to happen before the form submits to autocrat (without reworking my entire concept and workflow here).  So I will make it part of my case-manager-side script, but that means that I have about 4 extra questions hanging off the end of my Gen Ed form.

Perhaps I can find a way to make them invisible in the future, or end up reworking the entire work flow.  For now, better to make a working product before getting ahead of myself.

That's all for now.
Links:
Link to part 1
Link to previous part
Link to next part

Case Management Documentation and GAS Part 3.5

Part of being a Special Education Teacher is giving  parents progress updates on goals at least as often as their non-disabled peers.  At high school, that means once per quarter.  So doing goal updates this week and next has put my side project on break for a minute.  In spite of that, I was able to solve one small problem with my script.  I was able to get the script to take the IEP date information (from whatever the case manager puts in) and have it spit out a pretty and formatted text string (instead of a weird date code that computers read!). This solves a little problem I was having at the tail end where the printout would show a long date string including time--which I didn't want on that piece of text.

As an aside, goal updates are another beast that might benefit from some automation during certain parts of that process.  That's a long term thought I'm letting simmer and cook on the back burner.

Case Management Documentation and GAS Part 3

Well, moving forward on this project.  I now have the script getting all the values from the case manager submitted form and then looking up successfully the course schedule for the student from a second spreadsheet of schedule data that I pulled from the Aeries student database.  At some point that could be a live lookup, but for now it's dependent on a human to keep it accurate and up-to-date.

Next, it pre-fills the course info and IEP meeting information on a form for the General Education teacher to fill out and emails the teacher with a link.  When they click the link, it brings them to the feedback form already in progress with almost half the information already filled in.  No longer do they have to fill in their own class and double check the IEP date and time. (of course, at this point the IEP could get rescheduled, but that should be a separate thing on their calendar for another project at a later time!)

One item on my list is to make this Gen Ed version of the google form look slick and professional by using the school colors and logos now that Google allows us to customize their forms in that way. I'll get this pretty good looking before I show it to my Admin., but all that is cosmetic and the guts of the program currently work how their supposed to.

The next step is an Autocrat PDF creation off of my template feedback form that I created about a year ago for VHS.  I have 3 or 4 tweaks left on it at this point, until the Admin. sees it and offers changes.

At this point I want to record for posterity the methods I used to dump my spreadsheet data.  I had to go into MS Outlook and find my campus's "All Staff" email list.  Then I added all the names on that list to my contacts in Outlook.  This was in the Outlook program, not webmail like a lot of people like to use for outlook.  When all the names are in your contacts, you can export your contacts as a .csv file that will convert nicely into google sheets or excel, etc.  It has loads of empty columns that I don't use, but it has about 3 that I needed to get.  These were the account names of all the teachers and staff on campus.

All our district has the domain @vacavilleusd.org but their account names are different.  Usually it's the first name and the last initial (which I could make up with a spreadsheet function if it worked all the time).  However, sometimes there is already an "AndrewH" account and they do "AHyland" as the account.  So now I have that list from which to pull email addresses whenever I need.  I made a named range to look up in and concatenated the account name with the vacavilleusd.org domain.

I did some similar data pulls for schedule from Aeries (teacher, course, period) and special ed info (like testing accommodations and behavior plan status, dates for next IEP, etc.) from SEIS--our Special Ed Information System.  I can detail how I pulled those later so that I can replicate them next time and for any other campus and/or district that might use this idea.
Links:
Link to Part 1
Link to Previous Part
Link to Next Part

Case Management Documentation and Google Apps Scripts Part 2

I believe I have the script completed for the first half of my project. At least, I can make the computer fetch and use all the data in question. One bump at this stage is turning out to be triggering the script in such a way that it will run completely and automatically when a form is submitted. That might be a huge task if I end up having to make half of the data lookups happen inside the script instead of inside the  spreadsheet.

In any case, the next step will be the easy part--automating the general education feedback PDF production using the autocrat add-on. 

I think a more expert programmer would spot some areas where I have clunky code in my script, but I'm making progress each day. This will be my first real work project in programming and when it works I will have something to brag about. 

Link back to Part 1 and Link to Next Part

Case Management Documentation and Google Apps Scripts (Add-ons)

Well I've begun the project for this year and I expect to be done around January 2015, although tht may be wishful thinking. If I keep the current pace for progressing through each problem, I'll be done by thanksgiving, so January seems more realistic.

I have previously built each of the pieces I'm going to need for this project, now I have to connect them all and make them talk with each other. I've been able to find some great examples of code, but for all of them I've needed to tweak to make it fit my data. 

My concept is for a special education case manager to input only four pieces of info for an IEP and have my program do the rest of the job looking up things and inviting teachers. This means making at least two databases talk to each other and probably three. For right now I'm pulling the data once a semester and using that to work with. So if something changes for a student then I have to update manually on my sheet. 

The old method is for case managers to look up a students schedule and then manually input each of six teachers names and classes twice--once for the meeting invite and once for the feedback form.  This method was varying degrees of technology away from a typing pool secretary with 5-sheet NCR paper and a highlighter. Currently we've moved up to around 1998 using a word document with fillable boxes. 

So far I've figured out how to make the computer read the form input from the case manager and pull up the next form and pre-fill the answers. Next is to make it email the URL of the prefilled form to the six correct teachers. 

This will certainly be part one of my posts on this topic.  Next Post Here
Link to part 3 -- and Link to part 3.5

Donor's Choose Project for Mr. Hyland's Class -- Update!

Exciting Opportunity! 

My Donor's Choose project, Classroom Computers for Common Core Language Arts, is eligible for a three-day-only offer from the Bill & Melinda Gates Foundation. To celebrate teachers and the amazing work we do, nearly all projects will be half-off through August 24.


Please donate if you are able, or share with people you know who might be interested in supporting my class and our students:

• The half-off match will last for three days, starting August 22 and ending August 24 at 11:59 PM Eastern Time. To receive funding from the Bill & Melinda Gates Foundation, other donors must complete 50% of your project funding during that time.
  
• Funding from the Bill & Melinda Gates Foundation isn't guaranteed.Funds will only be applied to your project if other donors complete the rest before the offer ends on August 24.

Here is a short link (also above) to my project page http://goo.gl/2hfQWo