Skip to content
Information and Communications Technology · 5th Year

Active learning ideas

Creating Charts and Graphs

Data is often easier to understand when presented visually. This topic teaches students how to convert spreadsheet data into charts and graphs, such as bar charts, pie charts, and line graphs. This aligns with the NCCA's emphasis on communicating information effectively to an audience.

NCCA Curriculum SpecificationsNCCA Leaving Certificate Applied ICT, Module 4: Spreadsheets, Unit 5: Creating Charts and GraphsNCCA Leaving Certificate Applied ICT, Module 4: Spreadsheets, Unit 6: Printing Spreadsheets and Charts
20–40 minPairs → Whole Class3 activities

Activity 01

Think-Pair-Share20 min · Pairs

Think-Pair-Share: Which Chart Wins?

Show three different data sets (e.g., population growth, budget breakdown, race times). Students decide which chart type fits each best and why.

Why do we use charts?
UnderstandApplyAnalyzeSelf-AwarenessRelationship Skills
Generate Complete Lesson

Activity 02

Inquiry Circle40 min · Small Groups

Inquiry Circle: The Survey Visualiser

Groups conduct a quick poll in class (e.g., favourite Irish snack). They enter the results into a spreadsheet and create a pie chart to show the proportions.

What is the difference between a pie chart and a bar chart?
AnalyzeEvaluateCreateSelf-ManagementSelf-Awareness
Generate Complete Lesson

Activity 03

Gallery Walk30 min · Whole Class

Gallery Walk: Graph Critique

Students print their charts and display them. Peers walk around and use a checklist to see if the chart has a title, clear labels, and an appropriate scale.

How do we label a graph correctly?
UnderstandApplyAnalyzeCreateRelationship SkillsSocial Awareness
Generate Complete Lesson

A few notes on teaching this unit


Watch Out for These Misconceptions

  • Using a pie chart for everything.

    Explain that pie charts are only for showing parts of a whole. Use a 'Chart Selection' guide to show when bar charts (comparisons) or line graphs (trends) are better.

  • Forgetting to label the X and Y axes.

    Show a graph without labels and ask students to interpret it. They will quickly realise that without labels, the data is meaningless. A 'Label the Graph' race can fix this.


Methods used in this brief