Session 6 Processing numerical data (using Google Sheets) Part 2

5 PD Points

R125

By the end of this session, you will:

• know how to use formulae to perform calculations
• understand the order of preference
• understand the difference between and among cell names, ranges and
references
• know how to use basic functions to solve simple problems
• identify problems based on error indicators
• understand how to troubleshoot basic errors in formulae and functions
• know how to work with sheets in a spreadsheet
• know how to perform calculations using functions
• be able to present numerical data
• know how to create graphs/charts from given data and choose
appropriate graph types
• be able to edit graphs
• understand how to troubleshoot basic problems in graphs.

Document created: Mark sheet, graphs/charts.
Required prior knowledge: Content in Sessions 1 to 5 of this course would
be useful.

Required existing Tablet skills

Entry Level - Novice

R125