Data Handling and Spreadsheet Skills

Introduction

In this tutorial: Introduction > Getting Started > Your skills rating > Save the file > Formatting Tables > Column Charts > Auto-fill Tables > Graphs with Two Axes > Basic Statistical Analysis > Further Statistical Analysis > Drug Metabolism > Half Life > Half Life 2 > Drugs on airways > Skills list > Summary
All pages in this tutorial

New to Windows 7?

Is this the first time you have used Windows 7? If it is, please work through the Introduction to Windows 7 guide before starting this tutorial.

• This short introduction covers essential differences between previous operating systems and Windows 7.

New to Office 2010?

Is this the first time you have used Office 2010? If it is, please work through the Introduction to Office 2010 guide before starting this tutorial.

• This short introduction covers essential differences between previous versions of Office and Office 2010.

New to Excel?

Is this the first time that you have ever used Excel, or, are you unfamiliar with other Office software (such as Word and PowerPoint)? If so, please start with the Introduction to Excel tutorial before moving on.

• This short tutorial covers the basics of using Excel and manipulating data.

Course Outline

In this session, you will be manipulating data to produce tables and graphs, and you will analyse data using basic statistical formulae. Data will be provided and you should follow the instructions in this tutorial and complete the tasks to explore different aspects of Excel.

You will also complete specific exercises designed to support CMB1006 and CMB1008 coursework with Dr Ferrie.

Learning Outcomes

By the end of this session, you should be able to:

• Manipulate data on a spreadsheet, format it and analyse data statistically;
• Create graphs from the data and manipulate and format the graph;
• Create complex graphs with two y-axes and logarithmic scales;
• Complete statistical comparisons or data manipulation functions in line with coursework requirements;
• Trouble-shoot your way through problems as they arise in Excel;
• Apply these tools effectively for your academic work.

Next page.