Outline
This workshop will last 50 minutes, organized as follows:– Introduction to the Development of Statistical Tasks onEnergy Resiliency and workshop data distribution (5 min.)– Participants’ development of graphs using Excel and sample
data from the APEC Energy Database (10 min.)– Participants’ presentations of their statistical analyses andobservations (30 min.)– Workshop summary (5 min.)

APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 20171

Introduction to the Development ofStatistical Tasks on Energy Resiliency• Take a look to the following satellite picture of the lightcities generate at night (NASA, 2012).

APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 20172

Introduction to the Development of
Statistical Tasks on Energy Resiliency(http://news.bbc.co.uk/2/hi/technology/6067900.stm)
APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 20173

Introduction to the Development of
Statistical Tasks on Energy Resiliency(http://www.blue-marble.de/nightlights/2012)
APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 20174

Introduction to the Development of
Statistical Tasks on Energy Resiliency• What kind of questions, involving data
representation and data analysis, would you
pose from this lighting scenario?

• Remember: When analyzing data, the role of astudent or a statistician is to be a “datadetective,” to uncover the stories that are
hidden in the data.

APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 20175

Introduction to the Development ofStatistical Tasks on Energy Resiliency• As “data detectives”, people are expected:
̶ to note important signals in the variability ofthe data,̶ to develop and share their reasoning aboutsources of variation in data over time, and̶ to engage in informal inferential reasoning byusing data as evidence of estimations,predictions and generalizations.
(English & Watson, 2015; Makar & Rubin, 2009; Shaughnessy, 2007).
APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 20176

Introduction to the Development of
Statistical Tasks on Energy Resiliency• By doing so, we will have opportunities to engage in the following
4 levels of reading graphs (Shaughnessy, 2007):

̶ Reading the graph/data̶ Reading within the graph/data̶ Reading beyond the graph/data̶ Reading behind the graph/data• When “reading behind the graph”, one might conjecture about
the possible causes that might affect the phenomenon
represented over time (i.e., historical,economic, ordemographic potential sources of variation in the data), and use
some “data detective” skills to analyze graphical information.
APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 20177

Introduction to the Development ofStatistical Tasks on Energy Resiliency• From a data-detective point of view, importantsignals in the data variability should be noticed.

• Such signals are particularly evident in data thatare collected over time.

• http://www.ieej.or.jp/egeda/ for APEC DATABASEAPEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 20178

Introduction to the Development ofStatistical Tasks on Energy Resiliency
Electricity Power Generation:
http://www.ieej.or.jp/egeda/database/electricity_select_form.html

Electricity Power Capacity:
http://www.ieej.or.jp/egeda/database/egcapacity_select_form.html
Final Energy Consumption:
http://www.ieej.or.jp/egeda/database/newfinal_select_form.html
Fuel Consumption for Electricity Power Generation:
http://www.ieej.or.jp/egeda/database/newfelectricity_select_form.html

Primary Energy Supply:
http://www.ieej.or.jp/egeda/database/newprimary_select_form.html
Fuel Demand and Supply by Energy Sources (Coal, Crude Oil, Gas):
http://www.ieej.or.jp/egeda/database/newdemand_select_form.html
CO2 Emission:
http://www.ieej.or.jp/egeda/database/co2_select_form.html
APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 20179

Introduction to the Development ofStatistical Tasks on Energy Resiliency

APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 201710

Workshop Summary• During our workshop in November 2016 at KKU, we discussed
the models for the Practice of Statistics at school level developed
by Wild and Pfannkuch (1999) and Watson (2009).

• Challenging students with problems and questions in which they
have to analyze data collected over time using graphicalrepresentations, provide students with opportunities toempower them as statistically literate citizens (e.g., English &Watson, 2015; Gal, 2004; Shaughnessy, 2007).
APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 201711

Workshop Summary• Shaughnessy (2007, p. 991) also listed the following
eight behaviors regarding understanding of graphs,
considered to be critical to develop students’ basicgraph sense, as well as critical, mathematical andstatistical literacy:

APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 201712

Workshop Summary• Using the graphical representation shown before, we
can ask students “critical questions” such as:- What was the overall pattern in the data?
- Why might be the data varying in the way it is?
- Why does this variable have a similar/different trendthat the one shown by SE Asia and North America?
- What might happened in a particular period of time(e.g., the early 90’s) in the regions under
examination, to explain the behavior of the variable
during that period?
- What might happen in the next five years, and why?
APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 201713

Workshop Summary• When analyzing data, one safe first approach is to startby asking what the overall pattern in the data was, andwhy the data might be varying.
• What could you say regarding the distribution of
economic activity and populations in both countries?
How about the impacts on our environment (e.g.,transformation the landscape and the soil, which alters
the surrounding ecosystem and the climate)?
• How about the electric bill in different APEC countries?
Do you remember the “Electric Bill Task” from the last
meeting? How would you connect that task to the citynight lights picture and your statistical analysis?
APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 201714

Workshop Summary• Starting with a counterintuitive idea (e.g., therefrigerator acting as a heater, or city lights aslight pollution) will motivate students to collectdata, and then engage in statistical investigations.
• Law of Conservation of Energy (on an intuitivelevel, before the formalization)• The heat doesn’t vanish, it’s transferred to theroom and after to the outside.

• “Country glow” as a informal (simple) indicator ofpollution, fuel demand, CO2 emissions, …
APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 201715

Workshop Summary• Estimate the energy spent by a washer machine bykilogram of laundry load.

• Water consumption, electric consumption, coalconsumption, oil consumption, ...
• Comparison between the energy consumption of
mercury-filament light bulbs, LED bulbs,fluorescent lamps．
• Make sure students take into account thedifference in climatic conditions (Thailand andCanada for example).
APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 201716

Workshop Summary• Students will have the opportunity to compare
their own empirical results with national andregional data, using the APEC Energy database.
• Data on energy sources, energy consumption,
CO2 emissions, etc., are available in the database,very useful for verifying students’ hypotheses.

APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 201717

Workshop Summary• Let us assume the role of “data detectives” in ourclassrooms! Let’s use real-life energy data from APEC!
APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 201718

Questions and Comments are Welcomed

APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 201719

Using the APEC Energy Database as a Resource forDeveloping Statistical Tasks on Energy Resiliency

APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 201720

Using the APEC Energy Database as a Resource forDeveloping Statistical Tasks on Energy Resiliency• We have access to the APEC Energy Database, compiledby the Asia Pacific Energy Research Centre (APERC).

• 100% real data, 100% free.
• http://www.ieej.or.jp/egeda/

APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 201721

Using the APEC Energy Database as a Resource forDeveloping Statistical Tasks on Energy Resiliency

APEC-Tsukuba and UNESCO(MGIEP)International Conference XIWorkshop: How to Develop Statistical Tasks on Energy
Resiliency Using Data from the APEC Energy DatabaseFeb. 11, 201722