More Google products for educational uses.

I enjoy the ability of Google+ to send me posts that I can really engage with.  Of course, I have connected with some fun things and games for enjoyment on Google+.  So I get a lot of that in my feed which is nice so that I can decompress from work.  I have also added a good number of education related groups and ed-tech groups.  Sometimes I flip past those posts if I want to avoid melting my brain from too much work-thought.

Today, a post grabbed my attention because it was asking for a solution that I know how to provide.  I left a short comment, knowing that I also wanted to post here on the topic.  The poster, +Jennifer Fox, asked for some follow up so here's what I put together--I hope it was what she was looking for:

Original problem:  "Is there a way to sort responses from a Google Form as they are being gathered on the response sheet?"
My response: Use either VLOOKUP or IMPORTRANGE functions to copy the data to a second sheet and filter/sort that sheet.  Then the original collection sheet continues to get live responses and you can still organize your data.
My example:  I created a sample google form to collect fake data with numbers and letters, i.e. something to sort multiple ways.  Then I went to the spreadsheet where all the responses were collected and created a second sheet (named "The Magic").  On the second sheet, I used the importrange function to copy the data and then I selected all three columns of data (this makes sure that when you filter, the rows of data stay together) and applied a filter.  Now I can sort and filter the data and new data from the form automatically comes in whenever the users complete the form.
I also got to learn a little from the other comments in the thread--specifically, that there is an SQL-style query function in google sheets.
So, that was a win all around!

Hero's Journey Lessons Reflection Pt. 2

To wrap up my reflection, I'm going to share about the final two days of my Hero' Journey lessons.

Due to my lack of timing and many other excuses, I only had two days to cover about 60% of the Hero's Journey. The parts following the first threshold all the way to mastering both worlds. This proved to e difficult and since I had each student pick a different story plot line to outline, it became a challenge to keep everyone on pace while still covering each step adequately.

Next time I do this (and I will), I believe I will incorporate pairs and have some of the steps of the journey be presented by flash card or short video or something independent (flipped classroom?) so my lesson time can focus on the main points without getting bogged down or having 2/3 of the class zoned out while I help one group with their plot outline. 

The lessons as I planned them this year were too much but kids also seemed to loose interest by the end, another reason to streamline the key points and delivery by working up a video for students to watch for homework. Possibly, I could have students create a good one for me and use it in the next class. Then class times could focus on students working in pairs or groups analyzing their particular plots. 

At this late point in the year, I always really excited about possibilities for next year. 

I've found a link to a neat podcast that discusses Star Wars and it's uses in the classroom, so that's really exciting. 

Hero's Journey Lessons Reflection, Pt. 1

It's no secret to my students that I enjoy Star Wars in almost every way.  I'm surprised these last few years at how many students have not seen the original episodes.  This year, the majority of my 3rd period English 11 P class had not seen any versions of Star Wars--which surprises me since Episode III came out in 2005 (and the Clone Wars cartoon just barely ended!)

My third period co-teacher (@jenilola)originally came up with the idea to do a Star Wars week of mini-lessons to cover the Hero's Journey--mostly since so many had not seen the movies.  She had some Hero's Journey lessons archived and we pulled those out to dust off for the end of May.  I immediately decided to steal the lessons we crafted for my other 10th grade classes.

Long story short, we ended up not having the time in the year to do Star Wars or Hero's Journey in 3rd period, and lucky for me, I've squeezed it in for my other classes.  Due to some last minute training days that will keep me out of the classroom for three straight days, I had to split up the Hero's Journey mini-lessons and it only seemed natural to split them into Act I, Act II, and Act III of the quest.

On day 1, I showed a very brief power point slide show (thanks to mythologyteacher.com [I only showed Act I up to the threshold, so as to not get ahead of myself!]) of the different scenes in Lion King that correspond to the "Departure" portion of the Hero's Journey up to the first threshold.  I then passed out index cards with stories and movies where I knew the plots (and hoped the students would know at least one! -- turns out none of the 10th graders have seen Planes. ..).  I randomly passed out cards, but let them swap until they had one they knew well.  For three absent students, I later gave them the entire stack and let them pick the one they knew best, so we had some duplicates but that's ok.  The students spent about 10 minutes filling out a chart with the generic steps of Act I "Departure" with the corresponding parts of their selected plot line.

This is where the magic happened; since, when the students could not remember a part of their plot, they had some serious questions for their classmates.  "What was the 'talisman' for Po in Kung Fu Panda?" "It was the Dragon Scroll, duh!" "Wait, why?"  This followed by an explanation (with no help from me in most cases) as to why the object in question fit the archetype it was supposed to fill.

We also heard some discussion as to why Twilight did not fit so easily into this structure.  For a few extra credit points, I assigned the kids who wanted a challenge to complete Finding Nemo with the dad as the hero and one to work with Nemo as the hero.  Another student chose to do Star Wars Episode IV with C3PO as the hero (real fun and much challenge since his quest has a short cycle within Luke's hour-long departure sequence).

Despite me delivering a canned power point lecture for the first 7 minutes of class and then immediately passing out a fill-in-the-box worksheet, students had some higher level thinking and two-way conversations about their hero characters.  Of course, because we had to split the days of May up between other curriculum, we only talked about Act I and the departure of the hero, so there was not much discussion about how characters changed and why they had to take certain actions or make certain choices.

If these weren't mini lessons, I would next want to have them produce one high-quality poster (gotta love posters, plus I need something on my walls for back to school night next Fall!) for 2 or 3 of the key steps--perhaps one showing all the "guardians of the thresholds" from all the 12 different films and stories they broke apart.

Did I mention that I moved all the desks around in my room? Mostly to get them off the walls so that students could then post their Hero Journey plot points around the room.  Sadly, we ran out of time (mini lessons, a blessing and curse!) before I could have students present their Act I lists or gallery walk the room and discuss.  Never fear, however, since the desks ended up in a large circle and we had plenty of top-quality discussion before the sticky notes finally went up.

CCSS and the Special Educator

I attended a training geared toward Special Educators that informed us all of the practical ways to implement the Common Core State Standards in Special Education.

I got some great links, such as a book I might check out that has sample goals for every standard (similar to the CARS+ goal banks)

http://www.amazon.com/Aligning-IEPs-Common-Core-Standards/dp/1578615488

The presenter, Dr. Donavan, pointed us to a few links with multiple resources for differentiating our instruction and for writing compliant IEP goals (and lessons that address those goals!) that align to the new grade level standards.

Here are two:

http://www.scoe.net/castandards/ -- line up of CST standards and CCSS

https://wiki.ncscpartners.org/mediawiki/index.php/Main_Page -- lessons and resources from other states

We also got the good news that the CCSS goal banks will be ready in SEIS very soon! Also, an updated version of the CAPA test will be rolled out shortly for students that need alternate testing. (This can be found by going to the CDE website and looking for "alternate testing", however, I don't serve any students taking CAPA, so I didn't look for this)

Once again, at this training, I heard about Depth of Knowledge. I like it and need to apply the concept more deeply to my lessons. It is the third time I've heard of it at a training and seen the same graphic organizer:

Obligatory Depth of Knowledge Worksheet:

(This page is always followed by an activity where we examine all four levels more deeply by creating a differentiated lesson etc. etc. and share with the whole group)

There was quite a bit to digest and overall it was a good training.  This presentation eased my anxiety over implementing the CCSS in IEPs and (to a certain extent) implementing the CCSS in my classroom practice.  

I will link to his slide show when he posts it later this week.  I wish they would start posting those resources at the same time as the presentation so I could link to it right now.

I believe I have a much better understanding of how to use these in real life.

More thoughts on automation

As I sat in the allergy office and watched the nurse enter data into my record, I immediately realized another use for autocrat in my daily work. Any time a task is repeated in the same way, I should be able to get a machine to do it. The trick is getting the information into a format the machine can use and then into a format the humans can make sense of. I might have solved half of those problems while waiting for the doctor to come.

In my job we give formal academic testing to each student every third year. There are a number of different sub-tests and even different main tests that the district likes to use. All of the tests and scoring programs I've used will spit out an electronic report in either (or both) a Word document or a rich text file (that's the .rtf extension).  I need to learn how to get a machine to parse through the text file, convert the standard scores from tab delimited text into spreadsheet data, and then run an autocrat-style mail-merge into the generic report template.  The spreadsheet could also talk to a student data information system (info dumped from SEIS?) and use the student's unique ID number to look up gender and then put in the correct gender pronoun in the tedious parts of the report--replacing the "his" for "her" is always difficult or at least time consuming.

I would leave the summary and recommendations up to the report writer, so the final document that the computer spits out cannot yet be a pdf.  Autocrat can handle that, however.

I think this would be a highly useful tool for case managers who are interested.  One benefit is that not everyone has to use this system if they don't want to.  Also, it should be quick and easy (relatively) to set up and get working now that I know a little of what I'm doing with the scripts.  The first step might be the hardest for me--making the computer parse a text document and convert.

This little project will be on the back burner until around March 2014, I think, due to some meetings coming up . . .

Streamline the Paperwork to Save the Sanity of the Case Manager

My department chair asked a while ago for info on data collection using google forms.  I presume she has gotten pretty far in the process and that the data has started pouring in since the question today was how to display the results.  I have put up some screen shots below of how and where to click to get the automatic version of data summary that google provides for free.  Anything much beyond that will require a little more spreadsheet wizardry.  I'm getting out my robe and wizard hat now.

First, I'll show you how to create a form and then it will make more sense how to get information out of the response spreadsheet.

First, in your Drive account, click on "Create" and then "Form":

Simple enough.  Google will ask you to title the form and then you can create some questions.  There are some awesome tutorial videos on how best to use each type of google form question. +Melissa Hero has some good ideas if none spring to mind. (But then, if you had no ideas for how to apply these tools, you wouldn't be looking around for tutorials.)

Next, put in your questions.  You can also add in data validation, and many other neat tricks, no computer programming class required.

You can make questions that work from check boxes or drop down menus or radio buttons or large text boxes and many other types (e.g. date and/or time; although, the date and time questions display all funky when you pull them out of spreadsheets since it's stored as a time code of some sort so computers will read all the way down to the millisecond).

Google will automatically create a spreadsheet to collect all the responses.  Each column header is named for a question you created.  The far left column will always be a timestamp when the "submit" button was clicked.  This is useful as a paper trail.  I also learned a little trick to add a unique ID down one column.
The formula is this:
=arrayformula(Row(B:B))

I use the B column since Google steals the A column for the timestamp and the left hand column is the normal spot for a Key ID in (for example) a database.  With the arrayformula down the whole column, I can later look up any row of response data I want.  It's very neat.

Back to the summary of data!
You can get to the summary from the responses spreadsheet by clicking on Form menu and then Show Summary of Responses.

Alternatively, you can get to the summaries from the form itself (in edit mode, not the live form that users see) by clicking on Responses, then Summary of responses.








I put in some fake sample data:

Here is what the responses look like for my fake data:

That was cool.  I hope that helped and was actually what I was asked for.

Now for some real wizardry.  We have the technology, we can rebuild him, stronger, faster than before!
Using two google forms (one for Special Ed case managers and one for Gen Ed teachers to post feedback), we can replace the current paper system of giving and receiving IEP feedback.  That's not accurate, all mine are electronic right now.  I'm just using MS Office docs with forms to fill out which is only cumbersome when new versions of the software comes out and half the staff can not upgrade (public school budgets, etc.).

With a different revision of the current feedback system, I would insert a link into my MS Outlook calendar invites that go out to Gen Ed teachers. Here is the link to the sample email headed to Gen Ed teachers to invite them to the meeting.  Please make comments on it. Remember, this email is automatically generated and filled with the correct meeting info etc., so I don't have to write 26 individual invites for my individual students times 6 teachers each.  Microsoft allows you to do the same thing.  There are a number of advantages to google so the department could debate which they'd like to use.  I'm honestly ok with either as long as the whole department is doing the same thing.  I love uniformity, I think it makes us look professional to parents and teachers and I think the Gen Ed staff appreciates when we have our systems in place smoothly.  (Our current system is really good at VHS, I want to shed as much paper as possible and the little timestamp feature when Gen Ed teachers click submit is a nice perk!)

After teachers get that email, they click the link to the feedback form that would create the final pdf attached to the IEP in the computer.  Here's a sample feedback form.

There are many other uses for this type of functionality in a school system.

Thankful for a Great Day

I had a great day teaching last week and I have to share it.  This was one of those days when the students start off not getting it and each attempt you make falls flat on the floor two feet in front of you.

This is not the whole context, though.  I did have a pretty successful day for my first two classes with few interruptions, some learning, but little to write home about either.  My co-teach class is always more lively and fun--I'm trying to steal some ideas, I swear! But what made it a great teaching day was my 6th period Algebra 1 class.  Usually a challenging time for students to learn Algebra.
This day last week, my lesson presentation was falling pretty flat.  At one point, I reversed direction and taught a completely opposite method to solve the same type of problems and two of my students light bulbs went on.  They got excited and rushed through the rest of the classwork I had posted on the board.
It was a good feeling and one of the main reasons I love teaching.