I was finally able to finish the last of the digital media inventory during my last couple of weeks at the internship, as I was also starting to work on the grant narrative. At this stage in the inventory, I was merging Excel spreadsheets from multiple files where we had organized information about digital objects in the collections, tallying the final counts of each object type in the collection, and organizing the final tallies into a color-coded chart. This last task was primarily done as a result of the research I had done for the grant application – I assigned a color to each risk-level category of media obsolescence and created a chart so that we could look back at the Excel file and clearly see which items were most at-risk. It was really helpful at this stage to go to the documents Denise and I had created at the beginning of the internship and cross-check them with the new inventory files to verify that all of the information had been incorporated.
All in all, I might have liked a few more hours to continue polishing up the inventory, but I felt good about the progress I had made throughout the course of the semester. Hopefully, this inventory will prove useful when justifying funds needed for the mass-digitization project, as the inventory provided specific numbers of at-risk items and prioritized them further. It was nice to be able to work on this project throughout the semester and “cap it off” with the research and writing done for the grant application and to feel like I had contributed to the long-term end goals.