Educational units

DOWNLOAD THE TASK:

Document containing the worksheet   | Complete worksheet   ID: 220101

Description:

This task involves a careful and critical reading of the information contained

in a table, information that has to consider the number of families that have a computer, Internet access and mobile telephones. Apart from carefully reading the information, the students have to perform some calculations relating to the percentage of use and those calculations always have to lead to better understanding of the available information.

The second part of this task involves information being set out using bar diagrams and sector diagrams, in addition to the contents in the table. The students should learn to relate these different ways to represent information and to move between them. In any event, the focus of this task is reading to understand statistical information.

Competences:

Reading, carefully, and interpreting, critically, the statistical information contained in tables, graphs, diagrams or texts, and distinguishing between relative and absolute data (percentages, rates).
Solving, in a reasoned and critical manners, problems that require the use and interpretation of absolute and relative statistical data and/or statistical parameters.

Difficulty (1: low - 3: high):

2   Task type: Experience   Estimated time: 30 min.

DOWNLOAD THE TASK:

Document containing the worksheet   | Complete worksheet   ID: 220102

Description:

The first thing you need to build a diagram is data. In this case, the data

is taken from a table. The first of these figures indicates the total population using Internet and the other three values their distribution by provinces.

The task describes how to use this data to build a bar diagram using a spreadsheet (it can also be carried out in a similar way using a text processor). Once this task has been carried out, the students are shown how to improve the graph and information that it provides.

The second part of this task involves repeating the process using other data. It is a simple activity where the most important thing is to understand the method and to learn to follow the steps to be taken between the different programs patiently and meticulously. Activities of this type show how the interest in learning goes from calculating using pencil and paper to using computer tools and to interpreting the meaning of the results obtained.

Competences:

Building diagrams using the data in a table or another graph by relating both types of information.

Difficulty (1: low - 3: high):

2   Task type: Experience   Estimated time: 20 min.

DOWNLOAD THE TASK:

Document containing the worksheet   | Complete worksheet   ID: 220103

Description:

The students work on constructing sector diagrams in this task. The data to

be represented is as always the starting point to make a diagram. In this case, the data are in the table with which the students start this task. In any event, it has to be taken into account that the selected data must be the set of the parts of a whole that we want to represent, while, of course, excluding the whole. Therefore, the value of the total is excluded in the example given and the values for the three parts (provinces) is used.

Once this comment has been made, the task involves taking data (by one means or another), copying them onto the spreadsheet and following a series of instructions until the desired result is obtained.

A couple of cases where the explanation has been put into practice in the second part of this task. The best option is for the students to use the computer to copy the diagrams on to the spreadsheet and then print them.

In any case, they should look at the graphs and check that they reflect, approximately, the data collected.

Competences:

Building diagrams using the data in a table or another graph by relating both types of information.

Difficulty (1: low - 3: high):

1   Task type: Experience   Estimated time: 20 min.

DOWNLOAD THE TASK:

Document containing the worksheet   | Complete worksheet   ID: 220104

Description:

It is a similar task to the previous ones where the students build diagrams,

with the difference that in this case the necessary data to build the relevant diagrams has to be extract to an initial and rather more complex table. Therefore, two steps have to be performed in this task: a) preparing that table with the data to be represented and b) building the diagram using that data.

Competences:

Building diagrams using the data in a table or another graph by relating both types of information.
Reading, carefully, and interpreting, critically, the statistical information contained in tables, graphs, diagrams or texts, and distinguishing between relative and absolute data (percentages, rates).

Difficulty (1: low - 3: high):

2   Task type: Experience   Estimated time: 30 min.

DOWNLOAD THE TASK:

Document containing the worksheet   | Complete worksheet   ID: 220105

Description:

This task involves several steps that are carried out in the following order.

First of all, the students are asked to read and interpret the data contained in a table; then the table with the selected data is prepared and then used to draw the relevant diagram. In this case, a bar or line diagram seems to be most appropriate. The students are then asked to write a commentary about the graph, which logically must compare the different evolution of the countries selected for the diagram.

The second part of this task involves a series of problems where the students have to apply what they have learnt: calculating relative values, calculating variation percentages, etc. This is, therefore, a very comprehensive task as it requires the use of different types of statistical skills.

Competences:

Building diagrams using the data in a table or another graph by relating both types of information.
Solving, in a reasoned and critical manners, problems that require the use and interpretation of absolute and relative statistical data and/or statistical parameters.

Difficulty (1: low - 3: high):

2   Task type: Experience   Estimated time: 50 min.

DOWNLOAD THE TASK:

Document containing the worksheet   | Complete worksheet   ID: 220106

Description:

This task contains 4 problems, the information required to solve them (the data)

are contained in a text that is usually known as mixed, because it combines written texts with the diagrams (a line diagram in this case). As far as the problems are concerned, they are situations where knowledge relating to percentages and percentage variations is applied. The greatest difficulty may come from the difficulty of finding the necessary data to solve the problems.

Competences:

Solving, in a reasoned and critical manners, problems that require the use and interpretation of absolute and relative statistical data and/or statistical parameters.

Difficulty (1: low - 3: high):

2   Task type: Problems   Estimated time: 30 min.

DOWNLOAD THE TASK:

Document containing the worksheet   | Complete worksheet   ID: 220107

Description:

This task requires the students to draw the sector diagram from a table which,

in turn, has to be prepared using the data from a previous table. Therefore, the task consists of applying a procedure that is already known (building the diagram) by preparing the table required to do so. Once the table is completed, it is easy to build the diagrams if the spreadsheets or the text processors are used correctly.

Competences:

Building diagrams using the data in a table or another graph by relating both types of information.

Difficulty (1: low - 3: high):

2   Task type: Experience   Estimated time: 20 min.

DOWNLOAD THE TASK:

Document containing the worksheet   | Complete worksheet   ID: 220108

Description:

In this task, the students learn to pass the information from a bar or line

diagram to a sector diagram, and/or vice versa. In both cases, the information first has to be put into a table, as in both cases, it is relatively simple to build the diagram once they have the table.

Competences:

Building diagrams using the data in a table or another graph by relating both types of information.

Difficulty (1: low - 3: high):

2   Task type: Experience   Estimated time: 30 min.

DOWNLOAD THE TASK:

Document containing the worksheet   | Complete worksheet   ID: 220109

Description:

This task requires the students to draw the relevant diagrams, but the starting

point in this case is a text. Obviously, the students first have to have a table with the data to be represented before they can build, draw, a graph. In this case, the difficulty is building the table from the text that is provided. The students should, wherever possible, use a spreadsheet for the subsequent steps.

Competences:

Building diagrams using the data in a table or another graph by relating both types of information.

Difficulty (1: low - 3: high):

2   Task type: Experience   Estimated time: 30 min.

DOWNLOAD THE TASK:

Document containing the worksheet   | Complete worksheet   ID: 220110

Description:

This task is used to collect and summarise the mathematical information (concepts

and procedures) used in this Educational Unit.

In this case, the information refers to constructing diagrams and the steps to be taken for that to be done correctly. During the task, the students differentiate between the diagrams to represent the absolute data and those to represent relative data or percentages.

Competences:

Interpreting, summarising and memorising statistical data.

Difficulty (1: low - 3: high):

2   Task type: Synthesis   Estimated time: 50 min.

DOWNLOAD THE TASK:

Document containing the worksheet   | Complete worksheet   ID: 220111

Description:

A series of exercises are provided in this task to check to which point the

information supplied in the educational unit has been understood.

Competences:

Identifying, analysing and solving problems.

Difficulty (1: low - 3: high):

2   Task type: Test   Estimated time: 40 min.