Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Excel spreadsheet - PUPILVISION SPLASH PAGE

VIEWS: 14 PAGES: 3

									Country/Region Life Expectancy - YEARS      Life Expectancy %
KERALA, INDIA                                           -75.56
INDIA                                                   -75.56
UK                                                      -75.56
CHINA                                                   -75.56
CANADA                                                  -75.56
CHAD                                                    -75.56
SWEDEN                                                  -75.56



34 years = 0
79 years = 100   Any value above 79 must be entered as 79 years
Country/Region       Infant Mortality PER 1,000   Infant Mortality %
KERALA, INDIA                                                103.18
INDIA                                                        103.18
UK                                                           103.18
CHINA                                                        103.18
CANADA                                                       103.18
CHAD                                                         103.18
SWEDEN                                                       103.18




162 per 1,000 = 0,
5 PER 1,000 = 100


Any value less than 5 must be entered as 5
Any value abve 162 must be entered as 162
Country/Region      Literacy Rate %     Life Expectancy % Infant Mortality % PQLI
KERALA, INDIA                                        -75.56           103.18    13.81
INDIA                                                -75.56           103.18    13.81
UK                                                   -75.56           103.18    13.81
CHINA                                                -75.56           103.18    13.81
CANADA                                               -75.56           103.18    13.81
CHAD                                                 -75.56           103.18    13.81
SWEDEN                                               -75.56           103.18    13.81




INSTRUCTIONS
Use The Factbook to gather 'Life expectancy' and 'Infant Mortality' values for the countries listed above
Type the values on the relevant sheets of 'Life Expectancy' and 'Infant Mortality'
Each sheet will automatically calculate the relevant index and import it to the 'PQLI' sheet
Calculate the final PQLI by inserting Literacy rate into this sheet and averaging the 3 scores.
PQLI Average scores ARE AUTOMATICALLY CALCULATED

								
To top