Overview
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.
About this paper
| Paper title | Fundamentals and practice of spreadsheets |
|---|---|
| Subject | Information Science |
| EFTS | 0.15 |
| Points | 18 points |
| Teaching period(s) | Semester 1
(On campus)
1st Non standard period (11 November 2024 - 13 December 2024) (On campus) |
| Domestic Tuition Fees ( NZD ) | $1,173.30 |
| International Tuition Fees | Tuition Fees for international students are elsewhere on this website. |
- 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:
- Basics: Ranges, Tables & Views
- Data: Management & Analysis
- Calculations: Formulas & Functions
- Visuals: Charts & Graphics
- Automation: Macros and Programs
- Teaching Arrangements
2 x 1-hour lectures per week
1 x 2-hour lab per week
- Textbooks
To be advised. For further information contact Claudia Ott, Department of Information Science.
- Course outline
- 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:
- work with spreadsheets to organise, analyse and visualise data
- use functions and complex formulae to execute calculations and build basic data models
- automate tasks by using macros and user defined functions
- integrate error checking and data protection into spreadsheets.