HOVER FOR DETAIL ON SAVING DATA [1] GEO_NAME
United States Arizona
1998 505 525
1999 505 524
2000 505 521
SAT SCALE SCORE IN CRITICAL READING 2001 2002 2003 2004 2005 2006 2007 506 504 507 508 508 503 501 523 520 524 523 526 521 519
2008 500 516
2009 499 516
2010 500 519
2011 497 517
2012 496 517
HOVER FOR DETAIL ON SAVING DATA [2] GEO_NAME
United States Arizona
1998 512 528
1999 511 525
2000 514 523
2001 514 525
SAT SCALE SCORE IN MATHEMATICS 2002 2003 2004 2005 2006 516 519 518 520 518 523 525 524 530 528
2007 514 525
2008 514 522
2009 514 521
2010 515 525
2011 514 523
2012 514 525
HOVER FOR DETAIL ON SAVING DATA [3] GEO_NAME
United States Arizona
2006 497 507
SAT SCALE SCORE IN WRITING 2007 2008 2009 493 493 492 502 500 497
2010 491 500
2011 489 499
2012 488 499
HOVER FOR DETAIL ON SAVING DATA [4] GEO_NAME
United States Arizona
1998 1017 1053
1999 1016 1049
2000 1019 1044
2001 1020 1048
SAT COMPOSITE SCALE SCORE 2002 2003 2004 2005 2006 1020 1026 1026 1028 1518 1043 1049 1047 1056 1556
2007 1511 1546
2008 1511 1538
2009 1509 1534
2010
ACT Composite English Reading
Arizona United States Arizona United States Arizona United States
Mathematics Arizona United States Science Arizona United States
1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 21.4 21.4 21.5 21.5 21.3 21.4 21.5 21.5 21.6 21.8 21.9 21.9 20 21 21 21 21 20.8 20.8 20.9 20.9 21.1 21.2 21.1 21.1 21 NA NA NA 20.7 20.5 20.6 20.9 20.9 20.9 21.1 21.3 21.3 18.9 20.4 20.5 20.5 20.5 20.2 20.3 20.4 20.4 20.6 20.7 20.6 20.6 20.5 NA NA NA 21.9 21.8 21.8 22 21.9 22 22.2 22.3 22.4 20.2 21.4 21.4 21.4 21.3 21.1 21.2 21.3 21.3 21.4 21.5 21.4 21.4 21.3
NA 20.8 NA 21.1
NA 20.7 NA 21
NA 20.7 NA 21
21.5 20.7 21.3 21
21.4 20.6 21.1 20.8
21.4 20.6 21.2 20.8
21.6 20.7 21.2 20.9
21.7 20.7 21.2 20.9
21.9 20.8 21.3 20.9
21.9 21 21.4 21
22.1 21 21.3 20.8
22.1 21 21.3 20.9
20.4 21 19.9 20.9
HOVER FOR DETAIL ON SAVING DATA [5] GEO_NAME
United States Arizona
1998 20.8 NA
1999 20.7 NA
2000 20.7 NA
2001 20.7 21.5
ACT SCALE SCORE IN MATHEMATICS 2002 2003 2004 2005 2006 2007 20.6 20.6 20.7 20.7 20.8 21 21.4 21.4 21.6 21.7 21.9 21.9
2008 21 22.1
2009 21 22.1
2010 21 20.4
2011 21.1 20.3
HOVER FOR DETAIL ON SAVING DATA [6] GEO_NAME
United States Arizona
1998 21.1 NA
1999 21 NA
2000 21 NA
2001 21 21.3
2002 20.8 21.1
ACT SCALE SCORE IN SCIENCE 2003 2004 2005 2006 2007 20.8 20.9 20.9 20.9 21 21.2 21.2 21.2 21.3 21.4
2008 20.8 21.3
2009 20.9 21.3
2010 20.9 19.9
2011 20.9 19.6
HOVER FOR DETAIL ON SAVING DATA [7] GEO_NAME
United States Arizona
1998 21.4 NA
1999 21.4 NA
2000 21.4 NA
2001 21.3 21.9
2002 21.1 21.8
ACT SCALE SCORE IN READING 2003 2004 2005 2006 2007 21.2 21.3 21.3 21.4 21.5 21.8 22 21.9 22 22.2
2008 21.4 22.3
2009 21.4 22.4
2010 21.3 20.2
2011 21.3 19.9
HOVER FOR DETAIL ON SAVING DATA [8] GEO_NAME
United States Arizona
1998 20.4 NA
1999 20.5 NA
2000 20.5 NA
2001 20.5 20.7
2002 20.2 20.5
ACT SCALE SCORE IN ENGLISH 2003 2004 2005 2006 2007 20.3 20.4 20.4 20.6 20.7 20.6 20.9 20.9 20.9 21.1
2008 20.6 21.3
2009 20.6 21.3
2010 20.5 18.9
2011 20.6 18.6
HOVER FOR DETAIL ON SAVING DATA [9] GEO_NAME
United States Arizona
1998 21 21.4
1999 21 21.4
2000 21 21.5
2001 21 21.5
2002 20.8 21.3
ACT SCALE COMPOSIT SCORE 2003 2004 2005 2006 20.8 20.9 20.9 21.1 21.4 21.5 21.5 21.6
2007 21.2 21.8
2008 21.1 21.9
2009 21.1 21.9
2010 21 20
2011 21.1 19.7
HOVER FOR DETAIL ON SAVING DATA [10] Name of Geography Geo Name geo_name GEO_NAME
United States Arizona
TOTAL 12TH GRADE STUDENT ENROLLMENT Total 12th Grade Total Student 12th Grade Enrollment Total Student 12th 1998 Grade Enrollment Total Student 12th 1999 Grade Enrollment Total Student 12th 2000 Grade Enrollment Total Student 12th 2001 Grade Enrollment Total Student 12th 2002 Grade Enrollment Total Student 12th 2003 Grade Enrollment Total Student 12th 2004 Grade Enrollment Total Student 12th 2005 Grade Enrollment Total Student 12th 2006 Grade Enrollment Total Student 12th 2007 Grade Enrollment Total Student 12th 2008 Grade Enrollment Student 2009 Enrollment 2010 Tot 12th GradeTot Enroll 12th1998 GradeTot Enroll 12th1999 GradeTot Enroll 12th2000 GradeTot Enroll 12th2001 GradeTot Enroll 12th2002 GradeTot Enroll 12th2003 GradeTot Enroll 12th2004 GradeTot Enroll 12th2005 GradeTot Enroll 12th2006 GradeTot Enroll 12th2007 GradeTot Enroll 12th2008 GradeTot Enroll 12th2009 Grade Enroll 2010 tot_12th-gr-enroll_1998 tot_12th-gr-enroll_1999 tot_12th-gr-enroll_2000 tot_12th-gr-enroll_2001 tot_12th-gr-enroll_2002 tot_12th-gr-enroll_2003 tot_12th-gr-enroll_2004 tot_12th-gr-enroll_2005 tot_12th-gr-enroll_2006 tot_12th-gr-enroll_2007 tot_12th-gr-enroll_2008 tot_12th-gr-enroll_2009 tot_12th-gr-enroll_2010
1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2,673,067 2,723,707 2,781,701 2,799,484 2,863,083 2,989,514 3,046,516 3,094,349 3,180,343 3,276,402 3,306,840 3,289,931 44,259 45,813 47,907 49,501 52,162 60,820 68,815 71,035 79,180 82,491 75,739 83,667
2010 NA 79,363
2011 81,174
HOVER FOR DETAIL ON SAVING DATA [11] Name of Geography Geo Name geo_name GEO_NAME
United States Arizona
TOTAL NUMBER OF STUDENTS TAKING THE SAT Total Number of Total Students Number Taking of Total Students the Number SATTaking 1998 of Total Students the Number SATTaking 1999 of Total Students the Number SATTaking 2000 of Total Students the Number SATTaking 2001 of Total Students the Number SATTaking 2002 of Total Students the Number SATTaking 2003 of Total Students the Number SATTaking 2004 of Total Students the Number SATTaking 2005 of Total Students the Number SATTaking 2006 of Total Students the Number SATTaking 2007 of Total Students the Number SATTaking 2008 of Students the SATTaking 2009 the SAT 2010 Tot Students Take Tot Students SAT 1998Take Tot Students SAT 1999Take Tot Students SAT 2000Take Tot Students SAT 2001Take Tot Students SAT 2002Take Tot Students SAT 2003Take Tot Students SAT 2004Take Tot Students SAT 2005Take Tot Students SAT 2006Take Tot Students SAT 2007Take Tot Students SAT 2008Take Tot Students SAT 2009Take SAT 2010 tot_student-take-sat_1998 tot_student-take-sat_1999 tot_student-take-sat_2000 tot_student-take-sat_2001 tot_student-take-sat_2002 tot_student-take-sat_2003 tot_student-take-sat_2004 tot_student-take-sat_2005 tot_student-take-sat_2006 tot_student-take-sat_2007 tot_student-take-sat_2008 tot_student-take-sat_2009 tot_student-take-sat_2010
1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 1,172,779 1,220,130 1,260,278 1,276,320 1,327,831 1,406,324 1,419,007 1,475,623 1,465,744 1,494,531 1,518,859 1,530,128 1,547,990 1,647,123 1,664,479 11,925 13,144 13,932 14,257 15,321 16,819 18,825 19,448 18,615 19,201 20,040 21,007 20,690 22,845 23,052
HOVER FOR DETAIL ON SAVING DATA [12] Name of Geography Geo Name geo_name GEO_NAME
United States Arizona
TOTAL NUMBER OF STUDENTS TAKING THE ACT
Total Number of Total Students Number Taking of Total Students the Number ACTTaking 1998 of Total Students the Number ACTTaking 1999 of Total Students the Number ACTTaking 2000 of Total Students the Number ACTTaking 2001 of Total Students the Number ACTTaking 2002 of Total Students the Number ACTTaking 2003 of Total Students the Number ACTTaking 2004 of Total Students the Number ACTTaking 2005 of Total Students the Number ACTTaking 2006 of Total Students the Number ACTTaking 2007 of Total Students the Number ACTTaking 2008 of Students the ACTTaking 2009 the A Tot Students Take Tot Students ACT 1998Take Tot Students ACT 1999Take Tot Students ACT 2000Take Tot Students ACT 2001Take Tot Students ACT 2002Take Tot Students ACT 2003Take Tot Students ACT 2004Take Tot Students ACT 2005Take Tot Students ACT 2006Take Tot Students ACT 2007Take Tot Students ACT 2008Take Tot Students ACT 2009Take ACT 2010 tot_student-take-act_1998 tot_student-take-act_1999 tot_student-take-act_2000 tot_student-take-act_2001 tot_student-take-act_2002 tot_student-take-act_2003 tot_student-take-act_2004 tot_student-take-act_2005 tot_student-take-act_2006 tot_student-take-act_2007 tot_student-take-act_2008 tot_student-take-act_2009 tot_student-take-act_2010
1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 995,039 1,019,053 1,065,138 1,068,772 1,116,082 1,175,059 1,171,460 1,186,251 1,206,455 1,300,599 1,421,941 1,480,469 1,569,000 NA NA NA 11,730 10,956 11,903 11,378 10,470 10,740 11,084 11,602 12,550 NA
chart-main-title SAT Mean Score in Critical Reading | Critical Reading chart-axis-header 1998 1999 2000 2001 2002 2003 United States 505 505 505 506 504 507 Arizona 525 524 521 523 520 524 chart-title SAT Mean Score in Mathematics | Mathematics United States 512 511 514 514 516 519 Arizona 528 525 523 525 523 525
2004 508 523
2005 508 526
2006 503 521
2007 501 519
2008 500 516
2009 499 516
2010 500 519
518 524
520 530
518 528
514 525
514 522
514 521
515 525
2011 497 517
2012 496 517
514 523
514 525
chart-main-title ACT Composite Score chart-axis-header 1998 1999 2000 United States 21 21 21 Arizona 21.4 21.4 21.5
2001 21 21.5
2002 20.8 21.3
2003 20.8 21.4
2004 20.9 21.5
2005 20.9 21.5
2006 21.1 21.6
2007 21.2 21.8
2008 21.1 21.9
2009 21.1 21.9
2010 21 20
2011 21.1 19.7
chart-main-title ACT Scores in Math | Math chart-axis-header 1998 1999 2000 2001 2002 United States 20.8 20.7 20.7 20.7 20.6 Arizona NA NA NA 21.5 21.4 chart-title ACT Scores in Science | Science United States 21.1 21 21 21 20.8 Arizona NA NA NA 21.3 21.1 chart-title ACT Scores in Reading | Reading United States 21.4 21.4 21.4 21.3 21.1 Arizona NA NA NA 21.9 21.8 chart-title ACT Scores in English | English United States 20.4 20.5 20.5 20.5 20.2 Arizona NA NA NA 20.7 20.5
2003 20.6 21.4
2004 20.7 21.6
2005 20.7 21.7
2006 20.8 21.9
2007 21 21.9
2008 21 22.1
2009 21 22.1
2010 21 20.4
2011 21.1 20.3
20.8 21.2
20.9 21.2
20.9 21.2
20.9 21.3
21 21.4
20.8 21.3
20.9 21.3
20.9 19.9
20.9 19.6
21.2 21.8
21.3 22
21.3 21.9
21.4 22
21.5 22.2
21.4 22.3
21.4 22.4
21.3 20.2
21.3 19.9
20.3 20.6
20.4 20.9
20.4 20.9
20.6 20.9
20.7 21.1
20.6 21.3
20.6 21.3
20.5 18.9
20.6 18.6
SAT Test-Taking as a Percent of 12th Grade Enrollment chart-main-title chart-axis-header 1998 1999 2000 2001 2002 2003 United States 43.9% 44.8% 45.3% 45.6% 46.4% 47.0% Arizona 26.9% 28.7% 29.1% 28.8% 29.4% 27.7%
2004 46.6% 27.4%
2005 47.7% 27.4%
2006 46.1% 23.5%
2007 45.6% 23.3%
2008 45.9% 26.5%
2009 46.5% 25.1%
2010 26.1%
2011 28.1%
chart-main-title ACT Test-Taking as a Percent of 12th Grade Enrollment chart-axis-header 1998 1999 2000 2001 2002 2003 United States 37.2% 37.4% 38.3% 38.2% 39.0% 39.3% Arizona NA NA NA 23.7% 21.0% 19.6%
2004 38.5% 16.5%
2005 38.3% 14.7%
2006 37.9% 13.6%
2007 39.7% 13.4%
2008 43.0% 15.3%
2009 2010 45.0% NA 15.0% NA
LastUpdate Source Line1 Source URL1 (SAT) Source Line2 Source URL1 (ACT) Dataset Description
12/06/11 The College Board (SAT) http://professionals.collegeboard.com/data-reports-research/sat/archived ACT http://www.act.org/news/data.html Innovation requires the steady input of human capital into the workforce and into institutions of higher learning. The performance on university entrance exams of Arizona high school students is a measure of the quality of those Arizona students entering universities. This indicator measures the SAT and ACT university entrance exam scores of Arizona high school students. The SAT test historically consisted of two parts — critical reading and mathematics — but a third section, writing, was added in 2006. Each subject of the test is scored on a 200 to 800 scale. The ACT test is scored on a 1 to 36 scale. A composite score and scores for each of the four subjects — English, mathematics, reading, and science — are available. (However, subject scores in Arizona are not available from the ACT website prior to 2001.) The SAT and ACT scores for Arizona and the United States are presented on the website from 1998 through 2010. In addition, the percentage of students taking each test is calculated from enrollment figures of 12th grade students on October 1. Since some students take SAT and ACT exams prior to the 12th grade, and since the exams are given on various dates, October 1 enrollment serves as a proxy for the potential number of students who could take a university entrance exam.
Technical Notes As noted above, the percentage of students taking an entrance exam is based on enrollment figures that are a proxy for the potential number of students who could take an exam. In Arizona, the population of test takers is self selected: only those students considering applying to universities typically take these entrance exams and these generally are students with higher achievement levels. In some states, however, these tests are either mandated of all students or are taken by a very high proportion of students. As a result, the percentage of students taking the SAT test in Arizona in 2006 was barely more than half the national average; the proportion taking the ACT was considerably less than half. Two-thirds of the test takers in Arizona ranked in the top 20 percent of their class, versus only 56 percent nationally. Thus, Arizona’s higher scores relative to the national average in part reflect the more selective nature of Arizona test takers in comparison to the national norm. Note: In 2006, the SAT format was changed to include an 800 point writing section. The point total is now out of 2400.
[1] Guidelines for Reusing Data: Arizona Indicators uses Google Spreadsheets to store raw data in a consistently structured manner that makes it easy to use in a variety of applications. For the greatest user control we recommend that you save the entire workbook in Excel format before importing them into other applications. After a file or worksheet is saved locally --in any format-- you will notice three rows and one column that were hidden from view in Google Spreadsheets. These header rows and key field column provide options for user customization. Header rows of varying lengths are valuable as descriptive text for most database; geographic information system (GIS); and charting & graphing software. The key field --held in the first column-- is useful in most database & GIS software (the Federal Information Processing Standard code for locations is used where applicable). If you do not wish to use the header rows or key column simply remove them before importing into an application or presentation. [2] Guidelines for Reusing Data: Arizona Indicators uses Google Spreadsheets to store raw data in a consistently structured manner that makes it easy to use in a variety of applications. For the greatest user control we recommend that you save the entire workbook in Excel format before importing them into other applications. After a file or worksheet is saved locally --in any format-- you will notice three rows and one column that were hidden from view in Google Spreadsheets. These header rows and key field column provide options for user customization. Header rows of varying lengths are valuable as descriptive text for most database; geographic information system (GIS); and charting & graphing software. The key field --held in the first column-- is useful in most database & GIS software (the Federal Information Processing Standard code for locations is used where applicable). If you do not wish to use the header rows or key column simply remove them before importing into an application or presentation. [3] Guidelines for Reusing Data: Arizona Indicators uses Google Spreadsheets to store raw data in a consistently structured manner that makes it easy to use in a variety of applications. For the greatest user control we recommend that you save the entire workbook in Excel format before importing them into other applications. After a file or worksheet is saved locally --in any format-- you will notice three rows and one column that were hidden from view in Google Spreadsheets. These header rows and key field column provide options for user customization. Header rows of varying lengths are valuable as descriptive text for most database; geographic information system (GIS); and charting & graphing software. The key field --held in the first column-- is useful in most database & GIS software (the Federal Information Processing Standard code for locations is used where applicable). If you do not wish to use the header rows or key column simply remove them before importing into an application or presentation. [4] Guidelines for Reusing Data: Arizona Indicators uses Google Spreadsheets to store raw data in a consistently structured manner that makes it easy to use in a variety of applications. For the greatest user control we recommend that you save the entire workbook in Excel format before importing them into other applications. After a file or worksheet is saved locally --in any format-- you will notice three rows and one column that were hidden from view in Google Spreadsheets. These header rows and key field column provide options for user customization.
[4] Guidelines for Reusing Data: Arizona Indicators uses Google Spreadsheets to store raw data in a consistently structured manner that makes it easy to use in a variety of applications. For the greatest user control we recommend that you save the entire workbook in Excel format before importing them into other applications. After a file or worksheet is saved locally --in any format-- you will notice three rows and one column that were hidden from view in Google Spreadsheets. These header rows and key field column provide options for user customization. Header rows of varying lengths are valuable as descriptive text for most database; geographic information system (GIS); and charting & graphing software. The key field --held in the first column-- is useful in most database & GIS software (the Federal Information Processing Standard code for locations is used where applicable). If you do not wish to use the header rows or key column simply remove them before importing into an application or presentation. [5] Guidelines for Reusing Data: Arizona Indicators uses Google Spreadsheets to store raw data in a consistently structured manner that makes it easy to use in a variety of applications. For the greatest user control we recommend that you save the entire workbook in Excel format before importing them into other applications. After a file or worksheet is saved locally --in any format-- you will notice three rows and one column that were hidden from view in Google Spreadsheets. These header rows and key field column provide options for user customization. Header rows of varying lengths are valuable as descriptive text for most database; geographic information system (GIS); and charting & graphing software. The key field --held in the first column-- is useful in most database & GIS software (the Federal Information Processing Standard code for locations is used where applicable). If you do not wish to use the header rows or key column simply remove them before importing into an application or presentation. [6] Guidelines for Reusing Data: Arizona Indicators uses Google Spreadsheets to store raw data in a consistently structured manner that makes it easy to use in a variety of applications. For the greatest user control we recommend that you save the entire workbook in Excel format before importing them into other applications. After a file or worksheet is saved locally --in any format-- you will notice three rows and one column that were hidden from view in Google Spreadsheets. These header rows and key field column provide options for user customization. Header rows of varying lengths are valuable as descriptive text for most database; geographic information system (GIS); and charting & graphing software. The key field --held in the first column-- is useful in most database & GIS software (the Federal Information Processing Standard code for locations is used where applicable). If you do not wish to use the header rows or key column simply remove them before importing into an application or presentation. [7] Guidelines for Reusing Data: Arizona Indicators uses Google Spreadsheets to store raw data in a consistently structured manner that makes it easy to use in a variety of applications. For the greatest user control we recommend that you save the entire workbook in Excel format before importing them into other applications. After a file or worksheet is saved locally --in any format-- you will notice three rows and one column that were hidden from view in Google Spreadsheets. These header rows and key field column provide options for user customization. Header rows of varying lengths are valuable as descriptive text for most database; geographic information system (GIS); and charting & graphing software. The key field --held in the first column-- is useful in most database & GIS software (the Federal Information Processing Standard code for locations is used where applicable).
the entire workbook in Excel format before importing them into other applications. After a file or worksheet is saved locally --in any format-- you will notice three rows and one column that were hidden from view in Google Spreadsheets. These header rows and key field column provide options for user customization. Header rows of varying lengths are valuable as descriptive text for most database; geographic information system (GIS); and charting & graphing software. The key field --held in the first column-- is useful in most database & GIS software (the Federal Information Processing Standard code for locations is used where applicable). If you do not wish to use the header rows or key column simply remove them before importing into an application or presentation. [8] Guidelines for Reusing Data: Arizona Indicators uses Google Spreadsheets to store raw data in a consistently structured manner that makes it easy to use in a variety of applications. For the greatest user control we recommend that you save the entire workbook in Excel format before importing them into other applications. After a file or worksheet is saved locally --in any format-- you will notice three rows and one column that were hidden from view in Google Spreadsheets. These header rows and key field column provide options for user customization. Header rows of varying lengths are valuable as descriptive text for most database; geographic information system (GIS); and charting & graphing software. The key field --held in the first column-- is useful in most database & GIS software (the Federal Information Processing Standard code for locations is used where applicable). If you do not wish to use the header rows or key column simply remove them before importing into an application or presentation. [9] Guidelines for Reusing Data: Arizona Indicators uses Google Spreadsheets to store raw data in a consistently structured manner that makes it easy to use in a variety of applications. For the greatest user control we recommend that you save the entire workbook in Excel format before importing them into other applications. After a file or worksheet is saved locally --in any format-- you will notice three rows and one column that were hidden from view in Google Spreadsheets. These header rows and key field column provide options for user customization. Header rows of varying lengths are valuable as descriptive text for most database; geographic information system (GIS); and charting & graphing software. The key field --held in the first column-- is useful in most database & GIS software (the Federal Information Processing Standard code for locations is used where applicable). If you do not wish to use the header rows or key column simply remove them before importing into an application or presentation. [10] Guidelines for Reusing Data: Arizona Indicators uses Google Spreadsheets to store raw data in a consistently structured manner that makes it easy to use in a variety of applications. For the greatest user control we recommend that you save the entire workbook in Excel format before importing them into other applications. After a file or worksheet is saved locally --in any format-- you will notice three rows and one column that were hidden from view in Google Spreadsheets. These header rows and key field column provide options for user customization. Header rows of varying lengths are valuable as descriptive text for most database; geographic information system (GIS); and charting & graphing software. The key field --held in the first column-- is useful in most database & GIS software (the Federal Information Processing Standard code for locations is used where applicable). If you do not wish to use the header rows or key column simply remove them before importing into an application or presentation.
for user customization. Header rows of varying lengths are valuable as descriptive text for most database; geographic information system (GIS); and charting & graphing software. The key field --held in the first column-- is useful in most database & GIS software (the Federal Information Processing Standard code for locations is used where applicable). If you do not wish to use the header rows or key column simply remove them before importing into an application or presentation. [11] Guidelines for Reusing Data: Arizona Indicators uses Google Spreadsheets to store raw data in a consistently structured manner that makes it easy to use in a variety of applications. For the greatest user control we recommend that you save the entire workbook in Excel format before importing them into other applications. After a file or worksheet is saved locally --in any format-- you will notice three rows and one column that were hidden from view in Google Spreadsheets. These header rows and key field column provide options for user customization. Header rows of varying lengths are valuable as descriptive text for most database; geographic information system (GIS); and charting & graphing software. The key field --held in the first column-- is useful in most database & GIS software (the Federal Information Processing Standard code for locations is used where applicable). If you do not wish to use the header rows or key column simply remove them before importing into an application or presentation. [12] Guidelines for Reusing Data: Arizona Indicators uses Google Spreadsheets to store raw data in a consistently structured manner that makes it easy to use in a variety of applications. For the greatest user control we recommend that you save the entire workbook in Excel format before importing them into other applications. After a file or worksheet is saved locally --in any format-- you will notice three rows and one column that were hidden from view in Google Spreadsheets. These header rows and key field column provide options for user customization. Header rows of varying lengths are valuable as descriptive text for most database; geographic information system (GIS); and charting & graphing software. The key field --held in the first column-- is useful in most database & GIS software (the Federal Information Processing Standard code for locations is used where applicable). If you do not wish to use the header rows or key column simply remove them before importing into an application or presentation.