{"id":517,"date":"2012-05-18T22:47:08","date_gmt":"2012-05-18T14:47:08","guid":{"rendered":"http:\/\/www.ssedro.com\/blog\/?p=517"},"modified":"2012-05-18T23:14:46","modified_gmt":"2012-05-18T15:14:46","slug":"how-a-google-spreadsheet-tamed-an-end-of-year-process","status":"publish","type":"post","link":"https:\/\/www.ssedro.com\/blog\/2012\/05\/18\/how-a-google-spreadsheet-tamed-an-end-of-year-process\/","title":{"rendered":"How A Google Spreadsheet Tamed an End of Year Process"},"content":{"rendered":"

My department tracks the peripherals checked out to the teachers in my division. Each teacher is issued certain items, such as laptop, camera, vizualizer, etc. \u00a0When teachers leave or when items are at end of life, we collect them back at the end of the school year.<\/p>\n

In the past, notifying staff has been time-consuming and wasteful of paper. \u00a0We would call up each faculty member in Asset Manager<\/a>, take a screen capture of what was checked out, and then use SnagIt<\/a> to highlight the items which needed to be returned. \u00a0Next we would print two copies – one for the teacher and one for us to use during check in so the teacher did not need to wait while we scanned each item back into the system.<\/p>\n

In addition to being wasteful of paper, this process had other flaws. The biggest problem was that the official name of an item in the inventory might be rather cryptic, such as Sony BNZ-MW35<\/em>. \u00a0We ended up making picture explanations of the different items to clarify it for teachers.<\/p>\n

This year, inspired by Steven Katz<\/a>, I am going paperless. To get started, I created a Google spreadsheet<\/a>. \u00a0Across the top I listed the different items that needed to be returned. I was able to use clear terms rather than confusing model numbers. In each teacher’s row, either I ticket the first column to indicate that all items were returned, or I ticked other columns to indicate which items needed to be returned.<\/p>\n

I set the share settings on the spreadsheet so that anyone with the link could view the document, but not edit it. \u00a0I put that link in our End-of-Year checklist<\/em> that teachers use as part of the check out process. \u00a0On Monday I will further explain it by posting this blurb in our daily newsletter.<\/p>\n

 <\/p>\n

Tech Items to Be Returned
\n<\/strong><\/strong>This year, we are not giving each faculty member a print out of the tech items they need to return. Instead, we have created this Google spreadsheet<\/span><\/a>. There is a link to it on your End-of-Year Checklist<\/em>.<\/span><\/p>\n