Level Up: Museum Database(s) Management, Updates, and Review
Closed
Edmonton, Alberta, Canada
Project
Academic experience
80 hours of work total
Learner
Canada
Intermediate level
Project scope
Categories
No categories selectedSkills
web browsers data manipulation firefox microsoft excel management collections zoom (video conferencing tool) spreadsheets- 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.
- Outcome will include updated spreadsheets including flagged fields (for future updates), and a summary report of all work completed on the database(s).
- 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.
- 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).
- Deliverables will include updated spreadsheets and a short summary report of completed tasks, notes and/or other elements related to updating the data.
- Deliverables will be used to update current databases, associated with accessioned specimens and unprocessed sediment samples, at the Royal Alberta Museum.
No deliverables exist for this project.
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.
Portals
Edmonton, Alberta, Canada
Edmonton, Alberta, Canada