Accessibility Skip to Global Navigation Skip to Local Navigation Skip to Content Skip to Search Skip to Site Map Menu

INFO130 Fundamentals and practice of spreadsheets

Introduces the core concepts and tools used to organise and manipulate tabular data. Covers basic spreadsheet calculation, modelling, visualisation and analysis skills for business and research.

The ability to competently handle spreadsheets with tools like Microsoft Excel is probably the most versatile skill a business student can acquire. Organising, analysing, and interpreting data are techniques found in virtually every organisational environment one can think of: small and medium enterprises, corporate environments, accounting, legal, and consulting firms, governmental agencies, academic institutions, not-for-profit organisations, etc.,—all base their decision making processes on data. Spreadsheets are the single most used tool to achieve this. INFO130 will teach the fundamentals and practice for the effective and productive use of spreadsheets and will prepare you for more advanced data handling methods taught in other papers.

Paper title Fundamentals and practice of spreadsheets
Paper code INFO130
Subject Information Science
EFTS 0.15
Points 18 points
Teaching period Semester 1 (On campus)
Domestic Tuition Fees (NZD) $1,141.35
International Tuition Fees Tuition Fees for international students are elsewhere on this website.

^ Top of page

Schedule C

Claudia Ott, Department of Information Science

Teaching staff

Claudia Ott, Department of Information Science

Paper Structure

This paper covers the following key themes:

  1. Basics: Ranges, Tables & Views
  2. Data: Management & Analysis
  3. Calculations: Formulas & Functions
  4. Visuals: Charts & Graphics
  5. Automation: Macros and Programs
Teaching Arrangements

2 x 1-hour lectures per week

1 x 2-hour lab per week


To be advised. For further information contact Claudia Ott, Department of Information Science.

Course outline

View the most recent course outline here

Graduate Attributes Emphasised
Communication, Information literacy, Research.
View more information about Otago's graduate attributes.
Learning Outcomes

Upon completion of INFO130 students should be able to apply best practice to:

  1. work with spreadsheets to organise, analyse and visualise data
  2. use functions and complex formulae to execute calculations and build basic data models
  3. automate tasks by using macros and user defined functions
  4. integrate error checking and data protection into spreadsheets.

^ Top of page


Semester 1

Teaching method
This paper is taught On Campus
Learning management system

Computer Lab

Stream Days Times Weeks
Attend one stream from
A1 Wednesday 09:00-10:50 9-14, 16-22
A2 Wednesday 14:00-15:50 9-14, 16-22
A3 Wednesday 11:00-12:50 9-14, 16-22


Stream Days Times Weeks
A1 Monday 12:00-13:50 9-14, 16-22