How to: Email your Teachers from a Form Submit

I lost about an hours worth of typing and pictures in this post, so I'm going to type up another quick version that won't be as cool.  Trust me, it was awesome.

+Ken Daniels asked me about making autoCrat (Thanks for this awesome tool, +Andrew Stillman and the New Visions School team), the awesome sheets add-on, email his teachers at his school.  I don't know his particular situation--when I set my version of this up, it was to invite teachers to a meeting based on a student's schedule.  So there was a lot of tables and looking up going on.

The easiest way is to have the user enter the email addresses into the form you are using to collect data, but I hate having users make mistakes and also having them manually look up and retype stuff that the computer should do for us.

Here's my solution:

AutoCrat will run off of a form submit now, so that's cool and that's how I'll use it here.  I like to make the form as simple as possible.  I've made a sample one that collects the teacher's name.  

You'll need a spreadsheet list of teacher email addresses to look up from and the names you get from the form submit should be exactly the same (that's another problem altogether).  Again, when I used this type of thing, there was a step in between where my form collected student data and then looked up teacher names and teacher emails based on that (student names are much less prone to errors in my experience since teachers are used to entering them exactly--or you could easily use the student id number which reduces potential for error a bunch).  Here's a sample.

In my email sheet, I've exported the complete addressbook from Outlook for my school site.  To help the look up, I've made the leftmost column into a list of the teacher names in the same format as the teacher names appear in our student database.  There's a couple ways to do that, I currently prefer the =JOIN() command until I learn a better method.

Then I made a named range from the columns.  Technically for this lookup, you only need two columns--however, you could also do this lookup from a much bigger table if you needed. The named range makes it easier to write the formula for looking up emails, and allows you to add or subtract staff members each year as people retire/get hired without having to go back and manually change every single formula.

When you connect a form to the sheet, it will create a new sheet.  As each response is listed, it will erase all data in the newest row.  This means that any neat formulas you have in the response collection tab will be deleted every single time someone submits a response.  The way to deal with this that I've found has been to make another sheet and use the =IMPORTRANGE() command.  Images below.  

Once the range is imported, it will auto-update with new submissions and it will allow you to make formulas in the columns to the right of your imported data.  Now we can lookup effectively.  

After importing the range, I make a column that includes teacher name data exactly as it appears in the email lookup sheet. See the =JOIN command below.  In the next colunn, I've used a =VLOOKUP command to lookup the perfectly formatted teacher name in our named range at column 6 (where the emails are sitting).

You can look up any of these commands with the google help file and it explains pretty clearly all the options and parameters for each.

I like to wrap my formulas with =IF(ISTEXT(), my current formula, "") so that I can copy down the formula to all cells in the column and it won't display errors and #N/A and be ugly.

Getting autoCrat to email is now simple, you can have it send an email to multiple recipients or whatever you want using the dollar tags (for example: $emailAddress ) as one of the options in that add on.  each time a response is submitted, autoCrat will run and fill in the email with whatever you tell it and send to all the dynamically changing emails that pertain to your current submission.  I find this to be a little bit of extra work, but it avoids the problem of hard-coding a bunch of emails that will eventually change.

I hope this is helpful to Ken and anyone else who might need it.  I know it's a down and dirty version, and it will help if you've got a mid-level familiarity with excel/spreadsheet functions. i.e., this "guide" is not very newbie friendly, but here it is.

I know if Ken needs anymore support on it, we'll end up with a GHO and I'll attempt to record that and link it here as well if we get there.

VPEF Grant Thank Yous from My Class

Typing our essays on student desktop,
Chromebook, and hand written.

Earlier this school year, I applied for and was granted some generous funds for my classroom.  We were able to acquire two more Chromebook laptops to bring my class's grand total of available student computers up to seven (or sometimes eight or nine depending on the old ones working properly that day!).  In all, we have five Chromebooks now and those are nice for the students to use due to their speed and since my district set me up with google Classroom this semester.  So overall, this grant has had a large impact on my classes.

Working on a Slide Presentation for
Speaking and Listening Standards

I asked my students to write thank you notes to the Vacaville Public Education Foundation which granted the funds.  It was not lost on them what kind of impact these added computers had for our class and I'm sharing a

Part of our class writing essays.

handful of their notes here. Here's one below, and links to some more from the class.


Here are some of the projects we worked on using these computers this year:

• A class Padlet page "Where I'm From" poem.
• A Slide  presentation for Speaking and Listening skills.
• Some shared brainstorming ideas, in preparation for our essays--here's one:

Starting my first google Classrooms.

For the writing assignments, I was able to use google Classroom thanks to +Dawn Marsh at the district office who set up my classes as part of the pilot this semester!

Batting Order Rotation

Thanks to this code that I borrowed, I was able to create a batting order rotator for my son's Tee Ball team.

You can see it in action here.

I can see how this might be useful for elementary classes that want to rotate line leader and class jobs frequently through the day etc. etc. and also possibly in high school for seating charts (although there's other programs for that--usually attached to your grade book program) or for lab work in science class and things of that nature.

It surely would have taken me 1000 years of study to get to those few lines of code in JavaScript to rotate an array (the ones in there with the % sign I think are the trick, if I understand what I'm looking at!).  I was doing it just fine in a spread sheet thanks to this video, however, pulling from a live spreadsheet and displaying on a web page was beyond my skills at the moment and seemed like too many steps.  Then I thought I could create an array pretty easily in JavaScript and it should be a sinch to essentially follow the same neat procedures from that youTube video to lookup the correct index for each new batter.

Making Technology Run Smoothly

I'm pleased that my question via Twitter made it in to @TechsavvyEd 's #TechDirectorChat podcast segment last week!

Ben had asked for any questions from the gallery for a tech director. Being a lowly teacher and having had to deal with tech and tech departments, I know what I really wanted to ask and the way I might typically ask would not be productive for his venue.   When I find myself complaining about my classroom situations specifically, especially when I'm in professional development (or on a twitter chat), I then try to flip my negativity around and ask a question from the opposite direction.

So for my question for Ben's Director, Pete, I tweeted this:

@techsavvyed hey tech dir., if you could tell us teachers one important thing to make tech run smooth, what would it be?
— Andrew Hyland (@AndrewHyland) March 4, 2015

Pretty vague and open.  Ben and Pete both took a turn giving me an answer in his podcast.  Skip ahead to 13:00 and listen to how well Pete and Ben interpret my vague wording and both give useful answers to help make working with tech in education a little less of the nightmare it can be on the worst days.

Here's the Link.

Thanks +Ben Rimes  for the shout out and the thoughtful response.

For the record, my original intent on the question was the way Pete interpreted it--making sure stuff just works correctly between version numbers, power, internet, all those moving parts.  Ben's interpretation (tech integration into lessons) and answer were what I should have been asking!

#FallCUE Day2 Report

Well, the wifi seemed to be fixed for good and the lunch line was practically zero on Day 2, so I can give CUE and ACHS some props for at least fixing some problems quickly. Peter and I had selected our sessions late last night--we were ready to rock and our shared GDoc filled up fast with notes through the day. Next time I think I'll pick a time to have an empty session to run by all the vendors and see what's up quickly. This time we needed to maximize the info-grab. But a person can only process so much and implement so much each school year. 

Also for next time: sitting through keynotes and going to the meet ups before and after the con. 

In any case, here's what we saw and as always, notes are available upon request:

Session 6: CCSS Techie Tools
Padlet - digital posters for assessment. Don't need 1:1. I think I can use this one next semester for presentations and formative assessment. If you include an oral presentation piece it's even better. This could also be a strong tool in combination with QR codes at back to school night.
Audioboom - pod casting as class newsletter. Students write a script and record a podcast of what they've learned this week/unit. I think this was a public tool so train for your privacy needs. (No names on air, etc. )
Infuse Learning -- assessment tool much like socrative. Quite a bit of prep up front so I don't see this one on my radar until next year.

Session 7: Formative Assessment with mobile devices

Plickers and Edulastic-something as the two most reachable for me this year in public school with non 1:1

He covered a lot and they are linked in the resources. Plickers is a tool where only the teacher needs a device to use--each student (or each table group) has a paper card (which you could laminate for repeated use).  The cards are used for simple multiple choice selections, so there's a little bit of prep involved, and essentially what is happening is that your regular exit ticket or warm-up is now able to collect and display live data on who and how many in class are understanding the concept.  The teacher has a digital record immediately of each formative assessment, so that's appealing to me.  I could really use this in Special Education for IEP goal progress--the only down side is having to work around the multiple choice-style limitations.  So I wouldn't use this for every single problem each day.

Session 8: Special Education
This session was aimed at General Education teachers and getting them to use tech as a way to integrate Special Education students into the mainstream with tech as a facilitator.

An 8th grade teacher presented on student Blogging in lieu of written journaling--he said the majority of his students with special needs selected the online version and suspected it was due to not liking hand writing. Audio story problems were covered by an elementary teacher and I can see how I could use that in high school. Right now that would be a lot of extra prep for my class situation for a small number of applications. They presented a video produced by a student with autism to explain his condition. 

A nice thing about this session was that it was not focused on 1:1 and was presented by practical individuals in a situation that was closer to mine. So often I've been the only special educator in the room and even the only public school teacher in the room, or the only teacher at a school that's not going 1:1 iPads this year.

(Session 9 -- I skipped and dealt with some housekeeping issues)
Session 10: Science mobile
Since I'm co-teaching a Biology class this year, and I met Melissa Hero back at CUE Rockstar Tahoe, I had to go to this session and see what was up.  The link to her resources is where all the action is at.  By this point in the conference my entire brain was shot.  Melissa covered several websites to use for data sets in life science classes since most of the well known resources are for earth science (I didn't know this, but now I do!).  She covered several tools for elementary and for high school.  I can definitely see how to integrate the iNaturalist website/app into my class later this year. I'm definitely going to look at for next semester. 

iNaturalist.  Melissa Hero link.

#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.

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

Donor's Choose Project -- 3 new chromebooks

Well, in all my free time I've created a Donor's Choose project to augment the technology in my classroom.  My students really need to be able to create, compose, and publish on the internet.  I would like to have a class blog for some of our literature responses and argumentative assignments next year and my students this year (2013-2014) wanted to as well.

Our hold up was, well it was mostly due to planning time on my part since it was my first year at this school.  I'd like to blame the equipment, but that's not the full picture.  We could have done most of what I want to do--writing, drafting, collaborative revision, commenting, etc.--with my current technology setup; however, it would have been slow to say the least.

We currently have 3 classroom computers to use, a fourth one if I can free up a shared laptop for the day.  Even with my reduced class sizes I had 12 students in my largest classes and that would still take 4 rotations to get all the students on to computers for typing.  While that's ok for shorter writing assignments or surveys (see my previous post, the data for which I gathered using two of our computers hot-seat style after exams), it is tedious for research papers or longer assignments when the needs of my students require that some of them are typing for two or three times as long as other students.

Donor's Choose only lets you start out with a small project at first until you get enough "points" to allow a larger dollar amount for your projects.  This, I assume, weeds out the weaker hearts, and indeed kept me out last year when I created the account and drafted half a similar project for my last classroom. Even with this small number of points--and therefore a small "budget"--I am able to fund a huge boost in capacity for my classroom:  Three Chrome book laptops for my room will double the available number of screens for students to use and cut in half the time it takes for computer projects in the room.  Not to mention the classroom management impact!  Easier planning for me, I hope.

Upon the successful funding of this project, I believe I will be able easily to plan and implement some engaging and fun lessons with our new English curriculum which will cover Antigone and Things Fall Apart next year.  Look for a class blog on here and, at the very least, some published student examples of peer edited and revised, polished, college prep writing.

Here's the link to my teacher page on Donor's Choose:  Link
Yes, it's the same as above--I'm trying the best I can since the project expires in 4 months.

Raspberry Pi

Quote:

Will it fit in an Altoids tin?

What is Raspberry Pi?

I had to look it up since I had only heard the name in passing and didn't quite remember the context.

Raspberry Pi is a computer the size of a credit card (and almost as cheap!).  It's made to use in education and will do most basic tasks like word processing and spreadsheets and some graphics. It runs at 300MHz (Pentium 2) but can be overclocked to 800.  For $40, were you expecting alienware?

It's made to run Linux booting off of an SD card, but once it's booted you can run off of an external USB drive. So the possibility is to get a huge solid state drive (large capacity, not large size) and put whatever OS and software you need.  I wonder if I could just get Chrome on there for the google apps?

Here's the link to the FAQ page I read.  All those extra possibilities are what would kick the price up, but still not a huge price tag, especially if you hook it to the TV through the onboard HDMI port.

Thanks to @alicekeeler for the tweet on the sweet deal.  I think I might pick one up just to see how it works and how well it works.  I kind of wish +Ken Daniels and I had seen this a year ago when we were budgeting for computers.

This reminds me of building Heath kit radios on the porch with my dad.  This also reminds me of building my own computers in college.  I managed to build one for $400 and it lasted all the way to 2004!  I bet I could beat that price (and probably the age) with the Raspberry Pi.

It seems like there's an endless variety of ways to customize this computer.  There are different cases, you can add stuff using a USB port, people are adding mini keyboards, etc.

In my classroom, I could hook it up to the unused TV (I use the projector) and connect it to the wifi.  Although, I'm not sure if the IT people at school will let me hook it up to the network.

Finally, no, it does not appear to fit in the Altoids tin. :(  At least, not without specialized modification.

Update:
I just put together an amazon wish list of some items to build a neat little one, and it totaled well under $300, closer to 250, so possibly competitive with chromebook on price depending on how hard you shop for components.  I'm sure there are better deals out there on specific parts than Amazon offers.  I bet if I spent some time on it, I could squeak under 200 and still have some good functionality.  Now just to learn how to program it and what it could be used for beyond word processing.