Same-Day Repairs, 1,000 Devices, One Spreadsheet

Running IT asset management and staff tech training on a three-person team

Role: IT Intern, later Technology Assistant on a three-person IT team | Timeline: IT internship 2017–2018, Technology Assistant 2020–2021 (same school and team) | Tools: Google Admin console, Active Directory, Excel, Windows 10, Chromebooks, Dell laptops, Google Classroom, Google Meet | Scope: ~1,000 devices, 50+ staff

Overview

As a Technology Assistant at a regional public high school in New Jersey, I was one of three people supporting every device in the building. I tracked about 1,000 devices, prepared around 500 Chromebooks a year, handled 3–5 support requests a day and trained more than 50 staff one-on-one. I also introduced an in-house repair procedure that cut repair time from weeks to the same day.

About 1,000 devices tracked; about 500 Chromebooks prepared each year; same-day repairs, down from 1–3 weeks; 50+ staff trained one-on-one

The challenge

In the 2020–21 school year, every student needed a working device for remote and hybrid classes. Our team was three people, and we were responsible for about 1,000 devices. When a Chromebook stopped powering on, the standard fix was to send it to Dell under warranty, and students could wait one to three weeks to get it back. Teachers were also adapting to Google Classroom and Meet almost overnight, and many needed hands-on help.

Cracked screens and damaged hinges were common too. Broken hinges didn't stop a Chromebook from working, but they exposed internal parts, so the school gave every student a protective case.

Chromebook with a cracked screen
Chromebook with a broken hinge

Building a device-tracking system

I kept an Excel inventory of about 1,000 devices, with every serial number assigned to exactly one student. Each device name showed its type, purchase year and number. For example, STD-CBK-16008 meant a student Chromebook bought in 2016, device 008, so anyone could match a physical Chromebook to its record in seconds. Every Chromebook also had its own labeled charger, so students returned both at collection time. When a device came in for repair or went missing, the sheet showed who had it, what model it was and its history. One serial number, one person: that rule made the rest of the work possible.

Preparing ~500 Chromebooks a year

Each year I prepared around 500 Chromebooks before they reached students. Every device went through the same five steps, so nothing was handed out half-ready

Stacks of new Chromebook boxes before setup

Cutting repair time from weeks to the same day

Most "dead" Chromebooks were not actually broken beyond repair. I introduced a short in-house procedure: test the charger, reseat the battery cable, and swap in a spare battery if needed. Afterward I confirmed the battery charged and the device ran unplugged, then logged the replacement. Repairs that used to take one to three weeks through Dell were now finished the same day, and students stayed in class.

I did these power repairs two to three times a week, about 30 minutes each. Less often, I also replaced cracked LCD screens in-house, which took about an hour and was still done the same day.

Battery and cable inside a Dell laptop

Battery and cable inside a Dell laptop

Replacing an LCD panel

Replacing an LCD panel

Training 50+ staff one-on-one

I trained more than 50 teachers and staff one-on-one on Chromebooks, Google Classroom and Google Meet. The same questions came up again and again: how to share a screen, turn on the microphone, connect the camera and find files in Google Drive. I learned to start with what each person needed for their next class, show it once, then have them do it themselves while I watched.

Beyond Chromebooks

The job also covered the rest of the school's technology. I set up teacher Windows laptops using a 10-step checklist: Office activation, browser start pages, four network printers with authentication, a network home folder and default apps. I created accounts, reset passwords and unlocked accounts in Active Directory. I ran system image backups before major repairs, installed Windows 10 updates on staff PCs, and supported printers and Macs.

System image backup
Windows 10 update

System image backup

Inside a Dell laptop

Windows 10 update

Inside a Dell laptop

Applying it in a corporate setting

Sample files for a fictional company.

To show how this work carries over to an office, I rebuilt it for a fictional 150-person company, Northbridge Advisory Group, with Windows laptops, MacBooks, shared Chromebooks and Google Workspace. All names and data in these files are made up.

Preview of the IT asset tracker dashboard

IT asset inventory and repair tracker (Excel)

One row per device with status, warranty and owner; a repair log; and a dashboard comparing in-house and vendor repair times. Duplicate serial numbers and unassigned devices are flagged automatically.

Preview of the device troubleshooting guide

Device troubleshooting guide

Steps by problem and device type, including my in-house power repair procedure.

Preview of the new-staff quick-start guide

New-staff quick-start guide

First-day setup for Google Workspace, plus answers to the questions I heard most when training teachers.

Results

  • Tracked about 1,000 devices, each serial number assigned to one student

  • Prepared around 500 Chromebooks a year through a consistent five-step process

  • Cut power-failure repairs from 1–3 weeks with Dell to the same day, two to three times a week

  • Resolved 3–5 support requests a day as one of a three-person team, including Active Directory accounts and teacher laptop setups

  • Trained 50+ staff one-on-one on Chromebooks, Google Classroom and Google Meet

What I’d do differently

I'd track repair tickets from the start, so I could show exactly how many devices the in-house procedure saved. I'd turn the questions I answered most into short written guides earlier, instead of repeating them one-on-one. And I'd add warranty end dates to the inventory, so we could plan replacements before devices failed.

Next
Next

From Idea to 500 Orders