Being an Asssitive Technology Specialist comes with a wide variety of devices and tools and no easy way to keep track of all of them. Most systems commercially available for Inventory are expensive and not set up specifically for the varying devices used by an Assistive Technology Team.
That is where this system steps in. Using the easily accessibly Google Sheets format, this series of sheets will allow you to keep track of your items/devices in one location.
This System comes as a PDF file, with links to 5 Files:
Instruction Document- 5 pages of instructions on how to modify each sheet to work with your system and within your own Google Drive. Includes pictures and step by step instructions to make these sheets work for you!
Master Sheet- One central place that houses all of your Inventory Data: Device name, inventory number (complete with a naming system), link to image file, link to more data, availability, manufacturer, who the item is checked out to, what the location of the item is, and notes. Once created, this is the only sheet you will ever need to change or modify.
Data Sheet- This sheet automatically populates and changes based on the data in the Master Sheet. Sorts items by Item Type, so you can easily open each tab and see exactly how many of each item you have available.
QR Sheet- This sheet automatically populates a QR code that links scanners directly to the link provided in the Master Sheet. It also populates the Inventory number, so you can easily cut out the QR with Inventory Number to attach to your devices. This is a great way to provide instructions or more information to the users of your devices.
Awesome Table Sheet- This sheet is automatically populated and once linked to Awesome Table's website (directions included), creates a visual table that is able to be linked or embedded into a website. Users can then see all inventory or can choose to sort by availability, item type, or keyword.
Follow my Teachers Pay Teachers Store for additions to this system and additional Inventory Systems coming out soon!