30 October 2014

Celebrating Success Part 2

I'm working on some positive self-speak so that I continue the trend of feeling better about the things that I am able to accomplish. So here we go:

As I have mentioned before, I am working to integrate scripts into my use of Google Docs. Today, I am going to share my transportation form.

We created a transportation form which is used by instructors. The instructor fills out the form, which emails their supervisor as soon as they submit. The email contains a link for their supervisor which takes them to the spreadsheet containing the responses from the form.

That spreadsheet contains a custom menu for administrators. The admin clicks on the row containing the request and selects "approve" from the custom menu. That, in turn, emails the campus supervisor AND creates an event on the calendar. The coolest part is that if the instructor chooses a bus, it makes the event on the bus calendar. If they need a van, it creates it on the van calendar. Additionally, if they need a van, it emails the person who coordinates the vans. However, she only gets emails if a van is needed.

I am quite excited about the way I could customize this form to do some very specific things. It took me quite a few days to get it just the way I wanted, but now it works quite well.

29 October 2014

Qualitative Research is like...

Have you ever had been required to walk in an unknown area, over and over, and discern what is below the ground? Is there an underground river? Is there solid rock? Where is the water table? You can look under the surface, occasionally, but you can never truly see what is there. You can only use the evidence you have at hand and are able to gather to interpret the structure of what is below the surface.

That's what qualitative research feels like (to me).

28 October 2014


Today I spent all day in a training. I'm going to be a sysadmin on our new Student Information System. They were training Business and Industry people today from our district. That means that while the training wasn't specific to me, I got to hear a lot of how the campus is set up, the type of questions I will likely be getting, and think about tables, databases, and reports. Sounds like fun, right? I know, it isn't fun to everyone, but it sure is to me! 

I was multitasking, meaning listening and working on some other things at the same time. I got two proposals entered to present at the Google Apps for Education Summit, which is happening in Oklahoma City in February 2015. I'm pretty excited about it since these summits usually happen in much more exotic locations, like Singapore, South Korea, India, Thailand, & the UK, just to name a few.

As a part of that summit, I'll be attending a pre-conference workshop which will allow me to begin the journey of becoming a Google Apps for Education Trainer. At this moment, there are no Google Certified Trainers in Oklahoma. I expect that this will change after this summit, but right now if you wanted Google training, you'd have to know someone or call someone from Texas to come up. I've done a little Google Apps training when I was still a teacher, but I wasn't certified by Google. I've learned so much in the interim. 

More learning. More certifications. More ability to help and serve others. Those are my goals.

14 October 2014

Celebrating Success #1 - Progress Reports

I've not ever been very good at celebrating my successes. In fact, it has only been recently that I have allowed myself to acknowledge any sort of success in my professional or academic life. I've only ever considered my immediate family in terms of success and that has not been very long that I have done that either! 

I consider today a very successful day at work. Not that it was spectacular in terms of productivity (although I did get some things done), but today was the culmination of a couple of weeks of working on a project. The project was one in which I created a progress report workflow and tested it out on the automotive service program. 

When I say I created a progress report, I mean I took what my Student Services Director created and made it into something that would be automatically created from a spreadsheet in GoogleSheets. If you aren't familiar with GoogleSheets, you can check out Google's Getting Started with Sheets here. 

Anyway, over the last couple of weeks, I've been working on learning Javascript over at Codecademy so I can leverage Google Scripts (within Google Apps for Education, aka Google Drive, Calendar, etc.) 

When I say leverage, I mean automate. The project I've been working on is one in which faculty enter grades into a spreadsheet (among other things - employability ratings, attendance, etc.) and then the script populates a template document and creates a progress report for the student. Here's an example: 
Image credit: Jody Bowie
Identifying information removed
Bear in mind this was created automatically. I like to think of it as my internet minions doing my work. Granted, could have typed up these 53 progress reports, but this is just a test. We have far more than 53 students. Once the teachers learn to use the spreadsheet, progress reports then become easy. It's a matter of clicking on the administration menu (which is created by the script) and selecting the function you want to run. Or these could run on a specific date. The triggers for scripts are customizable. 

This is a brief overview, hopefully at some point I'll have the opportunity to present on this in the future. I've been working on this project, but also on a transportation form which auto-crates calendar events on specific calendars, a professional development form which creates a yearly transcript for instructors, and a daily work log in which student enter what they have done for the day and the teacher goes in and enters a rating on several factors - the script then moves that grade to the students' own spreadsheet. Imagine putting the daily grade form and this progress report together. Basically you have a gradebook which will can create documents for individual students. Scripts can also send email (like the results of a test or even send the progress report to a parent's email). The possibilities aren't endless, but I sure haven't plumbed their depths yet. 

Hopefully, I'll be posting more successes as I learn more, but I'm sure glad today for this one!

13 October 2014

More Google Scripts

I spent time today continuing to work on the Google Scripts that I worked on previously. I'm nearly done with a script which will aggregate information from a spreadsheet and create a document for each student from a template.

Basically, it's a progress report creator. This was built nearly from scratch. I will admit, I am pretty proud of it.

08 October 2014

Let's Talk about Pics, Baby.

I spent some time this week at the OTA/EM Conference. It was really really good. Our keynote yesterday was by a guy named George Couros. One of the things he said that stood out to me was, "We get what we model." Meaning, whatever we model to our students, that's what they are going to give us back.

So, when we give presentations, shouldn't we cite our images? If we don't, should we be allowed to deduct points when students don't cite their images? If students cite their images with the words, "Google Images1," should that be sufficient? I'm sorry if this sounds rude, but we've all had a course in which we have written. In which we have researched. In which we have used outside sources. In which we have been required to cite those sources.

So, should we (as professionals - who want to be TREATED like professionals) follow the rules of academia? If not, why not?

Image courtesy of quickmeme.com - used without permission

1Citing something with Google Images is kind of like citing the library. "Why yes Mr. Bowie, I did get this from an outside source. I got it from the public library!" WHERE DID YOU GET THE IMAGE?

06 October 2014

Starting a New Thing

I visited with my research instructor today and I feel so much better about my project in that class. I'm working on an auto-ethnography and this blog will be part of this. I will be using my blog as data to analyze. This will be quite interesting since I'll be working on thinking about what I used to think, what I thought in the middle of doing things, and what I think now. This will be a process. I've got lots to think about.

I will also be working on a private blog, as well. Some of the things I will be processing isn't going to be for public consumption.

I feel pretty good about my project. Or at least much better about it.

03 October 2014

Starting a New Job

It's been nearly a year since I've written and much has changed in the last year.

I left SNU in July of this year to take a job at Canadian Valley Technology Center. I'm still doing instructional design, but much of what I do revolves around face to face technology integration in the classroom. We don't offer any sort of online courses, so things are a bit different than they used to be.

I'm enjoying it here so far and I've gotten to learn many new things. One of those is coding. I've been working on Javascript for the last month or so, mostly so we can streamline our work flow through Google Drive. It's a lot of fun. It involves a lot of troubleshooting, especially when you are as new at it as I am. Basically, I'm learning a new language. At least it's written in English!

The only other thing I'll mention is something I just did today. I registered a domain (oklahomaspeedshop.com) and I hope to start designing a few tshirts and selling them there. I plan to design using cars and bikes from the 40s, 50s and 60s, done in the advertising style of those decades.

I've still got a lot to learn before I can create anything, but I do love to learn new things!