Managing Sign Off Documents Using Google Forms and Spreadsheets

One of my tasks each year is to track who has signed off on our acceptable use agreements across the district. To do this for over 1000 people I use a google form and spreadsheet. Employees sign off on a form that automatically collects their username:


That data is cross referenced in a spreadsheet using a couple of formulas against a pre-populated list of users to "cross them off the list". A couple of pivot tables keeps everything straight. You can see it in this spreadsheet. For those wanting more features I have combined it with formMule to kick out emails as well to those that have or have not completed their requirement - which can be seen in this spreadsheet. The video below outlines the whole process.

Comments

Post a Comment

Popular posts from this blog

Understanding the Superintendency - The Role of the School Board: A Basic Overview

Image
In recognition of School Board Member Appreciation Day last week, here is a primer on what it means to be a school board member. As a superintendent I have a single supervisor that consists of 7 people. These 7 volunteers are elected to serve as representatives of the community. As community members indicate they are interested in serving as Board members, before they run for a 4-year term, I share this document with them: “ What it Means to Serve on the Board ” that serves as an introduction to the role. I also meet with them and share my experiences as a superintendent, but also as a former board member. Most of this information I provide is from the Illinois Association of School Boards , the professional organization that supports school board members in Illinois. The IASB outlines 6 main responsibilities of a school board: Clarifies the district's purpose Connects with the community Employs a superintendent Delegates authority Monitors performance Takes respons...
Read more

Embedding Google Calendar in Another Language

This question came up today in the Google Apps Certified Trainer Group.  It is actually pretty easy to do.  To make the change you add &hl=XX where XX is the   language code   to the embed code . So - this calendar With this embed code:  <iframe src=" http://www.google.com/ calendar/embed?src= jkloc408t9h5rdv686c8d567hs% 40group.calendar.google.com& ctz=America/Chicago " style="border: 0" width="400" height="200" frameborder="0" scrolling="no"></iframe> Requires  a simple change to display in Spanish (&hl=es)   <iframe src=" http://www.google.com/ calendar/embed?src= jkloc408t9h5rdv686c8d567hs% 40group.calendar.google.com& ctz=America/Chicago &hl=es " style="border: 0" width="400" height="200" frameborder="0" scrolling="no"></iframe> Pretty simple! Some of our ESL teachers are displaying their h...
Read more

Brain Research and Visual Learning

I had the opportunity to hear Wes Fryer keynote today at the 1-1 Laptop Conference in Chicago. He used a stat that I have heard before and have debated a little. The idea is: "What we see travels to the brain 60X faster than what we hear" We discussed it afterward because I have recently looked at that information for another presentation that I was working on. I think it should actually be: "At any one time 60X more information can travel to the brain from the eyes than from the ears" Did some research tonight to confirm my off the head numbers today and here is what I found... Optical nerve fibers = 1,200,000 Several spots on the web - here it is from Wikipedia: http://en.wikipedia.org/wiki/Optical_nerve Auditory nerve fibers - 20,000 - 30,000 depending on the source wikipedia has it at 30K At 20K you get the 60X number 1,200,000/20,000 = 60 That would just impact the amount of information that could be carried at any one time. It is all electrical impulses trave...
Read more