So a full year is in the books for using a Chrome OS device and I have to say, I didn't miss Windows at all, I did load Windows 10 & Remix OS on my old laptop though. My postings have been far and few between because I have been super busy. I had a student teacher 2nd semester. He did a good job and didn't require too much over seeing, but when I get a student teacher I find myself helping out around the campus with technology issues.
So what did I get done this year? Well first up was AP Qualifications. I have a colleague who has to pour through about 200 applications and see if they qualify. I asked him what he was looking for and he said just grades. So I took his application and turned it into a Google Form. I found a way for the Custom Formatting to search for the unqualified grades and highlight them in red and then highlight their names so they would be flagged out. Then to top it off I had a second tab for his acceptance list. I had to run an add-on to sort by color and then pull that data to another sheet. Well once I showed his dean, she asked me to do it for the rest of her department. So I did and I think that will streamline the AP applications next year.
His dean is in charge of AP testing so she had to put together the master AP list. It was easy once I got everything into a Sheet it was easy to manipulate the data. So what I have planned for next year is for the AP qualification lists to be automatically pulled from the AP applications qualifying tab. So in theory, once they close the application everything will be done, acceptance & master list.
Big shout out to Alice Keeler who is 100% right when she says "The Answer is Always a Spreadsheet".
After she saw this she asked me to help with an AP/IB registration form. Students will complete a form where they input their AP schedule. It will identify any types of conflicts (by flagging them in the Sheet) and using FormMule email the students their AP schedules...if our district would open up student email access. It will also have necessary papers to qualify for fee reduction & help identify students that might be in CIF playoffs when testing rolls around.
I also work on a Staff Resource Doc that I saw from CUE. Basically, on one Doc it has everything ever needed for a staff member. I set it up so that certain things will require staff to make a copy first, like our warehouse order form. And of course it is set up to automatically add up the total cost for the teacher.
Also made another Form for requesting set up in the auditorium. Staff fills it out and once again thanks to FormMule a nice email is sent to the custodians as to what needs to be set up.
And finally, I have been trying to convince our admin to seriously look at buying Chrome OS devices for our next upgrade.
And as I look back I realize that most of this, if not all of it, would not have happened if I didn't have a Chromebox. It pushed me into a direction to use GAFE more. And when you start using it you realize just how useful & powerful it is. And I think that is the big picture of using a Chrome OS device.
