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

Due to COVID-19 restrictions, a selection of on-campus papers will be made available via distance and online learning for eligible students.
Find out which papers are available and how to apply on our COVID-19 website

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 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.1500
Points 18 points
Teaching period Second Semester
Domestic Tuition Fees (NZD) $1,080.30
International Tuition Fees (NZD) $4,858.95

^ Top of page

Schedule C
Commerce
Contact

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: Data, Tables & Views
  2. Calculations: Formulas & Functions
  3. Visuals: Charts & Graphics
  4. Data: Management & Analysis Automation: Macros and Programs
Teaching Arrangements

2 x 1-hour lectures per week

1 x 2-hour lab per week

Textbooks

To Be Advised

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:

  1. work with spreadsheets to organise, analyse and visualise data

  2. use functions and complex formulae to automate calculations and build basic models

  3. automate simple tasks using macros and integrate error checking and data protection into spreadsheets using best practices.

^ Top of page

Timetable

Second Semester

Location
Dunedin
Teaching method
This paper is taught On Campus
Learning management system
Blackboard

Computer Lab

Stream Days Times Weeks
Attend one stream from
A1 Thursday 09:00-10:50 28-34, 36-41
A2 Thursday 12:00-13:50 28-34, 36-41

Lecture

Stream Days Times Weeks
Attend
A1 Tuesday 14:00-14:50 28-34, 36-41
Thursday 14:00-14:50 28-34, 36-41

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 Second Semester
Domestic Tuition Fees Tuition Fees for 2021 have not yet been set
International Tuition Fees Tuition Fees for international students are elsewhere on this website.

^ Top of page

Schedule C
Commerce
Contact

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

Textbooks

To Be Advised

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

Timetable

Second Semester

Location
Dunedin
Teaching method
This paper is taught On Campus
Learning management system
Blackboard

Computer Lab

Stream Days Times Weeks
Attend
A1 Wednesday 14:00-15:50 28-34, 36-41

Lecture

Stream Days Times Weeks
Attend
A1 Tuesday 14:00-14:50 28-34, 36-41
Thursday 09:00-09:50 28-34, 36-41