Module Overview

Information Technology Practice-2

Building on the learning from Information Technology 1, this module will provide students with a deeper understanding of the capabilities and functionalities of spreadsheets for data analysis.


Module Code

MGMT 5006

ECTS Credits


*Curricular information is subject to change

Visual analysis without calculations

Conditional formatting Charts Pivot Tables

Calculations with Formulas and Functions

Use Basic Formulas and FunctionsUse Basic FormulasUse Absolute and Mixed ReferencesUsing Formulas Across WorksheetsCalculate with the SUM FunctionUse the MIN and MAX FunctionsUse the COUNT FunctionsUse the AVERAGE Functions

Use Conditional Functions

Use the IF FunctionUse the SUMIF Function Use the AVERAGEIF Function Use the COUNTIF Function

What IF analysis

Scenario managerGoal SeekSolver

Module Content & Assessment
Assessment Breakdown %
Formal Examination100