| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | Mean years of Schooling Dataset - v1 via Gapminder | =gm_dataset_validation() | |||||||
2 | About this file | This file has multiple sheets with data for one or more indicators used by Gapminder. In this sheet below you'll first find an overview of the indicators (measures) and the list of underlying sources. The actual data we use, is found in the sheet(s) labeled "data-...". This file is also a documentation of the data process. To follow how the data was transformed from the original sources, start in the sheet to the far right, which holds the input data. You can then follow the process step by step, by looking at the formulas in the sheets from right to left, until you reach the output in the "data-..." sheets. | |||||||
3 | Version: | v1 | |||||||
4 | Updated: | April 8 2019 | |||||||
5 | Download latest version: | Excel file » | |||||||
6 | Latest version online: | http://gapm.io/dmean_years_of_schooling | |||||||
7 | Contributor(s) to this version: | ||||||||
8 | Feedback | Please give feedback here | |||||||
9 | |||||||||
10 | # | Indicator(s) | Description | Full name | Unit | ID | type | Usage | |
11 | 1 | mean years of schooling, women aged 25-34 years | Average number of years of education received by women aged 25-34 years. | measure | 2 | ||||
12 | 2 | mean years of schooling, men aged 25-34 years | Average number of years of education received by men aged 25-34 years. | measure | 2 | ||||
13 | |||||||||
14 | Sources | ||||||||
15 | Dataset description: | Gapminder has imported data on Global educational attainment from Institute of Health Metrics and Evaluation (IHME). IHME provides estimates of average years of educational attainment per capita for people over the age of 15 for the years 1970-2015 by year, sex, and age group for 188 countries, 21 GBD regions, 7 GBD super regions, and the global aggregate. We extract data on mean years of schooling, for both women and men aged 25-34 years for countries and territories and world. The data in this spreadsheet are used to respond to the question in the Global Misconception Survey 2017 which asked:" Worldwide, 30-year-old men have spent 10 years in school, on average. How many years have women of the same age spent in school? A: 9 years B: 6 years C: 3 years".According to IHME, women aged 25 to 34 have an average of 9.09 years of schooling, and men have 10.21 Worldwide. | |||||||
16 | Link to documentation: | ||||||||
17 | Short source summary: | IHME | |||||||
18 | |||||||||
19 | # | Source id | Name | Link | |||||
20 | 1 | IHME15 | IHME, Global Educational Attainment 1970-2015 | http://ghdx.healthdata.org/record/ihme-data/global-educational-attainment-1970-2015 | |||||
21 | 2 | ||||||||
22 | |||||||||
23 | License | ||||||||
24 | Attribution: | We believe in free knowledge and therefor we share free data. Most sheets in this file are provided under the open license, called Creative Commmon Attribution License CC BY 4.0., except those sheets mentioned in the exceptions section below. This means you can freely use, copy, and spread the data in those sheets, as long as you mention the following: 'Free data from Gapminder.org'. You should also mention the underlaying data sources listed above and include this link: | |||||||
25 | License link: | Creative Common License CC BY 4.0 | |||||||
26 | Exceptions: | The sheets starting with the word "data" are covered by this license. Other sheets are included for documentation purpose, and may include data that is governed by other licenses. Check the underlying sources for the specific licenses in these cases. | |||||||
27 | |||||||||
28 | Versions | Link | Changes compared to previous | Date | Contributors | ||||
29 | v1 | https://docs.google.com/spreadsheets/d/1sZaZJYCGjMqu8765t4JwOPkIcRo2ic4Z2CebnKX9xQo/edit#gid=501532268 | First version | 2019 April 8 | |||||
30 | v2 | ||||||||
31 | |||||||||
32 | Technical stuff | ||||||||
33 | Dataset name: | Mean years of Schooling | |||||||
34 | Dataset id: | mean_years_of_schooling | |||||||
35 | Doc url | https://docs.google.com/spreadsheets/d/1sZaZJYCGjMqu8765t4JwOPkIcRo2ic4Z2CebnKX9xQo/edit#gid=501532268 | |||||||
36 | Doc id of work doc spreadsheet | 1sZaZJYCGjMqu8765t4JwOPkIcRo2ic4Z2CebnKX9xQo | |||||||
37 | Formulas | The formulas in this workbook may be referring to other spreadsheets online, by their named ranges, and not by sheet names. Search for "named ranges" to see how to use those instead of cell ranges. | |||||||
38 | For developers | If you like the data we use into your own products, it's better if you fetch data from our standardized gitHub repo on https://open-numbers.github.io These spreadsheets are part of Gapminder's data compilation process and allow end users to track how we combine data. | |||||||
39 | Read more: | gapm.io/dataworks | |||||||
40 | CHART PREVIEWS | ||||||||
41 | [c] | data-for-countries-etc-by-year | bubble chart with countries etc | ||||||
42 | |||||||||
43 | DDF mapping: | schema for indicator table | |||||||
44 | concept_id | 6 | |||||||
45 | name_short | 2 | |||||||
46 | name | 4 | |||||||
47 | description | 3 | |||||||
48 | unit | 5 | |||||||
49 | type | 7 | |||||||
50 | usage | 8 | |||||||
51 | validation | ||||||||
52 | |||||||||
53 | |||||||||
54 | |||||||||
55 | |||||||||
56 | |||||||||
57 | |||||||||
58 | |||||||||
59 | |||||||||
60 | |||||||||
61 | |||||||||
62 | |||||||||
63 | |||||||||
64 | |||||||||
65 | |||||||||
66 | |||||||||
67 | |||||||||
68 | |||||||||
69 | |||||||||
70 | |||||||||
71 | |||||||||
72 | |||||||||
73 | |||||||||
74 | |||||||||
75 | |||||||||
76 | |||||||||
77 | |||||||||
78 | |||||||||
79 | |||||||||
80 | |||||||||
81 | |||||||||
82 | |||||||||
83 | |||||||||
84 | |||||||||
85 | |||||||||
86 | |||||||||
87 | |||||||||
88 | |||||||||
89 | |||||||||
90 | |||||||||
91 | |||||||||
92 | |||||||||
93 | |||||||||
94 | |||||||||
95 | |||||||||
96 | |||||||||
97 | |||||||||
98 | |||||||||
99 | |||||||||
100 |