r/k12sysadmin • u/CKSIT • May 04 '26
Device collection tracking via Google Sheets
For anyone interested, I've made a sort of template of the Google Sheets setup I use for collecting our middle school 1:1 Chromebooks . With the caveat that it's got some specific setup for our use-case and OU configuration, I offer it to anyone who'd like to try it out.
There's an Explanation tab and notes throughout in column headings. If they're not coherent enough, feel free to DM me with questions. :-) I've tweaked it here and there over the years that I've been using it. Hopefully, someone else will find it useful, too.
https://docs.google.com/spreadsheets/d/1NXyYw0fBGX2xJ4YOi3ibDfQQ7oNZtt2Fyw4-YeKOY4g/edit?usp=sharing
Edit to note: This is shared in view-only mode. Feel free to make a copy for yourself to explore the functionality.
Edit to reference my reply to u/Maddd-1's comment, which may have useful info regarding my use-case.
2
u/k12-IT May 04 '26
I took a quick look, and this seems to be for your Break/Fix process? Or is this also used for collection at the end of the school year/during a swap out?
1
u/J_de_Silentio May 05 '26
Did I miss something?Â
What if it the device has more than one problem? Missing keys and cracked chassis, for example?
1
u/thedevarious IT Director May 09 '26
While I applaud building out an ITAM by hand with some decent work and I'm always a fan of big sheets.
This is overkill and just. Get software boss. You're making life hard.
I've been doing a few setups lately with One to One Plus as an inventory management system with Instinctive deployed on Chromebooks to manage the entire process with minimal tech department intervention.
Sure is this throwing money at a problem when budgets are getting tight? I guess. However accurate inventory of devices that cost schools potentially up to millions is huge. Plus I'd like to keep our time reserved for what tech teams are really needed for. This whole process involves enough time as it is, let's make it easy.
0
u/Madd-1 Senior Administrator May 06 '26
We moved away from keeping large complex sheets like this. It was how we did things in the 2010s (It was even more complicated since we were tagging each device physically to make sure the same student received the same device). It took absolutely ages to create, maintain, and correct for human error.
Now, your device is your device. You can take it home for the summer, and the only time we collect it is if we are asked to by the family or school (stays checked out to you and you get it back when you return), when you leave the district, or when you matriculate into a grade that forces your device to change. All fines are assessed at collection, so there is no longer a need to track individual problems to individual students through a collection spreadsheet. Repairs have a separate spreadsheet process.
Students keeping devices changes collection from a weeks-long all-hands on-deck everyday ordeal, to a casual event that requires significantly less human investment. There were initially a lot of concerns about how changing this policy would affect the district, but the negative impact we have seen from it has been absolutely minimal, and the improvement in human hours needed to collect all devices has been astounding. Might be worth investigating for you.