This entertaining two-hour seminar will show you some of the tricks and tips you need to that make MS Excel an effective tool for processing research data. Whether data is numeric, textual, alphanumeric or spatial, you will learn ways to manage data in as simple and efficient a way as possible.
Research students often gather data from unusual sources, but come to the analysis stage of their thesis without knowing how to use advanced statistical tools. They don't realise that tools such as SPSS are not always necessary to quickly create powerful reports and visualisations of the data they have collected. There are simple and straightforward ways of meaningfully processing data by using Excel, a tool that is readily available in the kit bag of any student.
Who is this for?
This session is perfect for students in areas such as humanities and social science who want to learn data analysis methods while bypassing advanced software packages or elaborate coding.
Do I need to bring anything?
As this is a presentation of methods, there’s no need to bring a laptop or any of your own data along. You won't be working on a computer. You’ll be given a seminar material to work through.
On completion of the seminar participants should be able to easily and efficiently do the following:
- Sort data and records using excel
- Join columns and fields of data
- Split texts into columns
- Filter and isolating columns
- Convert text to table, and table to text
- Convert tables to maps
- Create quick reports or overviews
Michael McBain originally worked in scientific publishing, but subsequently went on to a career as a faculty and research manager in several Victorian universities, including the University of Melbourne. He maintains his interest in publishing, and has taught Taming Your Thesis With Technology for over twenty years, during which he has revamped and tamed over fifty doctoral theses. He has been loosely involved with public 'big data' projects like GovHack, Melbourne Open Data, and 'Shut Up and Hack'. He holds degrees in science, arts, information management, and spatial science.