Organising, Managing and Presenting… · SHS2 Ict

Lesson notes

Learning Objectives

Indicator: 2.1.1.LI.3 - Generate and interpret graphs and charts to visualise data.

By the end of the lesson, learners can:

Identify at least three types of charts (bar chart, pie chart, line graph) and state the kind of data each is best used to represent.
Generate a bar chart, a pie chart and a line graph from a given data set using spreadsheet software.
Interpret data presented in graphical formats by reading values, comparing categories and describing trends.
Explain the strengths and limitations of each chart type when presenting numerical information.
Select an appropriate chart type for a given data set and justify that choice.

Sign in with your phone number to read the full note and download the GES plan - free.

Sign in with phone number

Curriculum details

Strand: ICTs IN THE SOCIETY (Strand 1)
Sub-strand: Organising, Managing and Presenting Information Using Essential Productivity (1.1)
Content standard: 2.1.1.CS.1 - Demonstrate knowledge and understanding of Analysing numerical data using Spreadsheet software 2.1.1.LO.1 Utilise knowledge of Spreadsheet software to create functions for data analysis, interpret graphs and manipulate tables.
Indicator: 2.1.1.LI.3 - Generate and interpret graphs and charts to visualise data.
Suggested placement: Semester 1, Week 3 (Week 3 of the year)
Our suggestion, laid out in curriculum order across three terms of twelve weeks. NaCCA does not fix the week, so follow your school's scheme of learning.
Source document note: The official curriculum document has a fault in this entry, so the curriculum text above is transcribed exactly as printed:

content standard text - p.48: the content-standard token is visibly printed `2.1.1.CS1`, which omits the separator before the final sequence; `2.1.1.CS.1` is used as the import code only to preserve the document's year/strand/sub-strand association
Curriculum reference: NaCCA curriculum document, p. 48

Exemplars (from the NaCCA curriculum)

Project-Based learning
- Engage in project-based learning activities to generate different types of graphs and charts, such as bar charts/graphs, pie charts, and line graphs, using spreadsheet software.
- Demonstrate the ability to interpret and analyse data presented in graphical formats.
- Utilise interactive multimedia presentations and video analysis to explore concepts and techniques related to creating graphs and charts.
Teaching and Learning Materials:
- Notepad or exercise book
- Pen
- Smartphones
- Laptops
- Desktop computers
- Tablets
- TV
- Radio
- Open Educational
- Resources (Including
- YouTube, MOOCs -
- Udemy/Coursera, Khan
- Academy, TESSA)
- The iBox (CENDLOS)
- Productivity tools
- Subject-based application software
- Instructional
- Laboratories (with multimedia equipment and smartboards)
- Maintenance and repair workshops
Assessment (2.1.1.AS.3). The document marks these depth-of-knowledge levels for this indicator: Level 3 Strategic reasoning; Level 4 Extended critical thinking and reasoning.