Level Up: Museum Database(s) Management, Updates, and Review

Closed
Royal Alberta Museum
Edmonton, Alberta, Canada
Assistant Curator of Quaternary Environments
(1)
3
Project
Academic experience
80 hours of work total
Learner
Canada
Intermediate level

Project scope

Categories
No categories selected
Skills
web browsers data manipulation firefox microsoft excel management collections zoom (video conferencing tool) spreadsheets
Details
  1. Student will spend 80 hours reviewing and completing database fields (using Excel Spreadsheets), mainly pertaining to entity descriptions (morphology, measurements, etc), storage update, site and sample details, plant species distributions and other plant/specimen related data. The student will identify any missing field cells, errors and/or duplications. The student will check between multiple spreadsheets, to fill missing field information, as well as to confirm correct data is in the appropriate fields.
  2. Outcome will include updated spreadsheets including flagged fields (for future updates), and a summary report of all work completed on the database(s).
  3. This project will provide the student experience working with museum databases and data related to collections. They will obtain skills navigating various types of literature to obtain data, and understand how to write succinct descriptions.
  4. Meticulous, redundant work is required for completion of this project. Student should be very comfortable using Excel and extremely diligent with data manipulation and entry. Access to a computer, web browser (Google Chrome, Firefox, etc.), and Excel software are required. All work will be completed remotely, with Supervisor-Student meetings via online conferencing (e.g., Zoom).
  5. Deliverables will include updated spreadsheets and a short summary report of completed tasks, notes and/or other elements related to updating the data.
  6. Deliverables will be used to update current databases, associated with accessioned specimens and unprocessed sediment samples, at the Royal Alberta Museum.
Deliverables
No deliverables exist for this project.
Mentorship

Direct supervision will be by Diana Tirlea (QE, RAM). Supervision will include introduction to project, detailed instructions, check-in meetings throughout project, quality control of data output by student, and project completion review and comments.

About the company

Company
Edmonton, Alberta, Canada
51 - 200 employees
Science, Education, Government

This project is affiliated with the Quaternary Environments program at the museum. See https://royalalbertamuseum.ca/collections/earth-sciences/quaternary-environments to learn more about this program.