Tabulation.pdf

2.3 Tabulation To be able to order data in table format. Construct and use Two-way tables. Find and analyse information from a database or two-way table. Colour Key: Worked Examples in Green. Write these down. Key Points in Purple. Write these down. Exam Question in Blue. Discussion based....

2.3 Tabulation To be able to order data in table format. Construct and use Two-way tables. Find and analyse information from a database or two-way table. Colour Key: Worked Examples in Green. Write these down. Key Points in Purple. Write these down. Exam Question in Blue. Discussion based. Questions in Bold and Black. Discussion based. Textbook Questions in Gold. Page number and which questions will be provided. To be done in your exercise book. Databases A database is a collection of information. Data can be extracted from a database(s) and summarised in a spreadsheet or table. Some examples of databases are the UK Census, birth-death rates within Europe and even the register taken at the beginning of this lesson. Can you think of any other examples? Databases Country Capital City Pop. at risk of Life expectancy Marriage rate Divorce rate poverty (%) (years) (per 1000) (per 1000) Denmark Copenhagen 17.9 80.7 5.0 3.4 Italy Rome 28.3 83.2 3.1 0.9 Belgium Brussels 21.2 81.4 3.7 2.5 Greece Athens 36.0 81.5 4.9 1.1 Ireland Dublin 27.4 81.4 4.3 0.6 Austria Vienna 19.2 81.7 4.3 2.1 Spain Madrid 29.2 83.3 3.4 2.2 Norway Oslo 13.5 82.2 4.6 1.9 France Paris 18.5 82.8 3.6 2.0 Switzerland Bern 16.3 83.3 5.1 2.0 Databases That table contains information from the EU, gathered between 2013 and 2014. Answer the following questions by using the information in the table: a) What is the capital of Austria? b) Which country had the highest proportion of its population at risk of poverty? c) Which countries had a life expectancy of above 83? d) Which country had the lowest divorce rate per 1000 people? e) Work out which country has the greatest difference between its marriage rate and divorce rate. What other comments could you make based on the table? Databases Pages 58 and 59. Questions 3, 4, 5 and 7. Answers on page 389 and 390. Two-way Tables Two-way tables show information from two categories. Totals from both categories are also included in a two-way table as well as the total number of data values. Remember, data that has two variables is called bivariate data. Two-way Tables-Example This table shows the results of a survey of houses on an estate. Complete the table. Type of House Accommodation Detached Semi-Detached Terraced Total 2 Bedrooms 1 3 10 - (1 + 3) = 6 10 3 Bedrooms 4 24 - (4 + 12) = 8 12 24 4 Bedrooms 11 - (1 + 4) = 6 4 2 6 + 4 + 2 = 12 Total 11 3 + 8 + 4 = 15 20 10 + 24 + 12 = 46 Two-way Tables Pages 63 and 64. Questions 3 to 7. Answers on page 390. Two-way Tables Exam Question The table below shows the number of road accident casualties in thousands. The accidents were in Northern Ireland in the years 1986 to 2000 and all involved illegal levels of alcohol. Two-way Tables Exam Question a) Write the number of total casualties in 1989, in thousands. (1 mark) b) The total number of casualties in 1996, found by adding together the Fatal, Serious and Slight injuries columns comes to 17.66 thousand. The number of casualties in the total casualties column is 17.67 thousand. Given a reason for this difference. (1 mark) c) Describe the trend in the total number of fatal casualties in the years: i) 1986 to 1991. (1 mark) ii) 1993 to 2000. (1 mark) Two-way Tables Exam Question a) 22.81 thousand or 22,810 (1 mark). b) There may have been rounding errors when collecting the data (1 mark). c) i) Total numbers are dropping/decreasing/going down (1 mark). ii) Total numbers are similar/staying level/not changing drastically (1 mark). End of Topic Process Work through Check-Up Questions and update your Pathway as appropriate. Any questions incorrect or any 3/4’s on your Pathway for this topic? Move onto Strengthen Questions, there is a strengthen question for each Check-Up Question, with hints too. Are all questions correct or is your Pathway all 2/1’s for this topic? Attempt the Extend Questions. Check your notes against the Summary Section, updating as appropriate. Finally, you will be given an IS Task of exam style questions. Followed by a Topic Test 2 weeks later.