Page 59 - Penta Book's ICT Catalogue

5. Analyzing
5 . Analy zing

data

It’s time to master your math. In
this module, you are going to use
Microsoft Excel to make complex
calculations without mistakes. Learning objectives
You will learn to present your
Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5 charts and to format the data so that > how to make complex
In this module you will learn:

information with different types of
it is easier to understand. You will
calculations.
also learn how to transfer your data
> how to use Excel’s functions for
and use it in any other program.
faster calculations.
> how to work with logical
functions.
> how to avoid mistakes in
8 calculations.
GRADE
Skills > how to present information with
charts.
After this module you will be able to:
> how to emphasize information
> work with powers and
using formatting.
percentages.
> how to exchange data with other
> use advanced functions.
programs.
> create conditions using multiple IF
functions.

> use relative and absolute
references.

> understand and correct error
messages.
> format different types of charts.

Tools
> create mini charts.
> apply conditional formatting to > Microsoft Excel
cells. > Apple Numbers
> import and export data as a CSV > Sheet To Go
file. > LibreOffice Calc

Penta Books