Probably all of us have to use spreadsheets. Most of us have to enter or clean data. Many of us don’t have special data cleaning tools. Few of us know any data cleaning programming languages. This workshop will:
• Focus on using Microsoft Excel as the sole tool for data cleaning (much of this can be applied to Google Sheets, Open Office, etc)
• Start simply and build to more complex formulas and methods
• Have theory sessions, followed by practical application and practice
• Have pre-set sample datasets, but will also have time to apply learned techniques to delegates’ actual data cleaning projects
The sample datasets and presentations will be provided, but you will need to bring your own laptop loaded with Excel.
Half day workshop: $65
Content creators innovate. They know what they want to say and they find the best ways available to them to say it. Are we keeping up? Are we looking after “future us” well enough? This panel will bring together three creators from different walks of digital creation to talk to them about their practice, offering insights for those who collect, preserve, exhibit and enjoy their work. The panellists are comics artist and illustrator, Jem Yoshioka, computer musician Luke Rowell and author and investigative journalist Nicky Hager.
Discussion will centre on three questions:
Te Papa has been steadily digitising it's collections for many years but recently embarked on an Accelerated Collections Digitisation Programme (ACDP) to rapidly increase the numbers of our collections that were accessible via our Collections Online platform. The focus of the programme in the first year was on objects from our Works on Paper and Photography collections, the presentation is on 2d digitisation which offers unique opportunities for extremely accurate and calibrated image capture.
This presentation will offer an overview of the programme and follow the digitisation process from an imaging perspective. It will cover the workflow from object selection and capture as well as equipment used and the technical aspects and the international best practice standards of capture followed. And from a collections perspective it will touch on the discoveries and success stories of the programme.
The Discovery Wall is an interactive exhibition that showcases some of Christchurch City Libraries digitised collection. Composed into a digital psychogeographic map of Christchurch, this unique experience is on a massive touch screen wall located on the ground floor of Tūranga. Multiple users can explore the past and present of our city on this digital interface and can comment on and share images with others. It is created from over 1000 cut-out ‘Hero’ images of buildings, streets, landscapes, events and people to generate a collage that users can explore at the touch of a finger. Several thousand more images are available to explore through the curated albums attached to the Hero images, tags and search functionality.
The Discovery Wall is accompanied by a website at discoverywall.nz where the images can be explored and searched, commented on and shared. This is where the public can contribute their own images and stories to the collection. The Libraries will also add more content over time so the number of images accessed through the Discovery Wall will continue to increase.
In addition to the Discovery Wall in Tūranga and the website, there is also a mobile version that will tour around to other libraries in the network and go out for Outreach programs and events.
