This month we’ve reviewed the most common museum data messes and the strategies most used for data remediation. Today’s post will conclude our data cleanup series with guidance on how to create a plan for your museum data cleanup project.
What are Your Resources?
Before embarking on a data cleanup project, it’s important to consider the resources available in order to help scope the cleanup work appropriately. A data cleanup project too large to undertake can easily burn out staff and volunteers, and can also lead to even more messy data. Review how many people are available for the data cleanup project, how much of their time will be allocated on average per week, and for how many weeks.
Support Cleanup Efficacy with Bite-Sized Work Plans
Data cleanup is the most effective when it’s performed with laser focus. For example, focusing on a subset of the collections, and even just one field commonly used in every record will help to scope the cleanup work into easily completable sections. This approach helps to keep the data cleanup team focused and allows for the inevitable breaks in cleanup to perform other activities.
Select the Standard to Follow
If the museum hasn’t already identified the data schema and data content standards it intends to follow, or that are available in the CMS, then it’s time to select the standards that make the most sense for the museum. Please see Common Museum Data Messes to Look For published on Lucidea’s Think Clearly Blog for more discussion on data schema and content standards.
What is the Knowledge and Technical Skill Level?
Next, there needs to be an evaluation of the people tasked to work on data cleanup. Are they knowledgeable in data content standards? Do they know how to use the CMS? Consider the knowledge and skills needed in order to accurately perform data cleanup. What are reasonable expectations? What documentation or instructions are needed? Or, does expertise need to be brough in from an external source?
Strategies for Data Cleanup
Finally, determine which of the strategies listed below (and covered by Lucidea’s Think Clearly Blog) are to be used, and craft your instructions accordingly:
How to Create a Set of Easy-to-Follow Data Cleanup Instructions
The following steps should be taken to develop a sustainable set of easy-to-follow instructions:
- Select the content standard(s) that make the most sense for your collection type and capture in the instructions which catalog standards are to be followed.
- From the standard(s) you’ve selected, identify the fields with indications of “required” and “recommended” and capture these fields for your instructions.
- Include the data standards for how data should be entered into each field, including standardized language, avoidance of abbreviations and acronyms, and appropriate writing style.
- Using the content standard guidelines, create specific examples of data from your collection.
- With the data cleanup strategies you’ve selected, identify which steps your team should take for their data cleanup process.
With a game plan in place, you and your team can now confidently embark on your data remediation journey. By following standards, leveraging CMS tools, and creating strong processes you can help ensure future data cleanup is unnecessary.
Rachael Cristine Woody
If you’d like to learn more, please join us for “Strategies for Museum Data Remediation”, presented by Rachael Woody May 3, 2023 at 11 a.m. Pacific, 2 p.m. Eastern. (Can’t make it? Register anyway and we will send you a link to the recording and slides afterwards). Register now or call 604-278-6717.
Never miss another post. Subscribe today!
Museum expert gives details, dos and don’ts of how to navigate tough but important discussions about salaries with the decision-makers at your museum.
Museum expert gives details of how to put compensation data together to pinpoint accurate salary ranges for specific museum jobs and geographies.
Tips from a museum expert on how to calculate museum job salaries accurately, with detailed steps and information resources.
Argus is used by the BC Sports Hall of Fame and Museum to increase accessibility and intellectual control over their museum collections; success story