To view changes in one chart, city by city, select 2D pie, and this will appear… To be comfortable with the different options available, try selecting various charts. Excel is a very user friendly format, and it will take no time at all to become familiar with the various chart options available. Example #2: Examining student enrollment in 12 by county in the state of Massachusetts for the years 2007 through 2011. Several of the websites provided allow building a table from within the website. The Common Core Data Set is one such site and is a very efficient and user friendly site. Go to the following link to access this website (it will go directly to the build a table window): Once there, instructions are provided in the yellow sidebar to the right, but practice makes perfect, so select from the drop down box that asks “each row of the table should be:” select then select the years, “County”, 2008-2009; 2009-2010”. Click and the terms” in the pop up window. Make sure “Next” “Accept state and county are checked and re-select the years 2007-2008; 2009-2010”. Click “next”. Select only the state of Massachusetts in the next box and click View Table in the upper right hand corner. This is what will appear… Table by County County County County County County County County Name- Name- Name- Number- Number- Number- Name- by by by by by by State most survey survey survey survey survey survey Abbr recent year year year year year year year (District) (District) (District) (District) (District) (District) (District) [2007-08] [2008-09] [2009-10] [2007-08] [2008-09] [2009-10] MA BARNSTABLE Barnstable BARNSTABLE BARNSTABLE 25001 COUNTY COUNTY COUNTY MA BERKSHIRE Berkshire BERKSHIRE BERKSHIRE 25003 25003 COUNTY COUNTY COUNTY MA BRISTOL Bristol BRISTOL COUNTY BRISTOL COUNTY 25005 25005 COUNTY
To view changes in one chart, city by city, select 2D pie, and this will appear… To be comfortable with the different options available, try selecting various charts. Excel is a very user friendly format, and it will take no time at all to become familiar with the various chart options available. Example #2: Examining student enrollment in 12 by county in the state of Massachusetts for the years 2007 through 2011. Several of the websites provided allow building a table from within the website. The Common Core Data Set is one such site and is a very efficient and user friendly site. Go to the following link to access this website (it will go directly to the build a table window): Once there, instructions are provided in the yellow sidebar to the right, but practice makes perfect, so select from the drop down box that asks “each row of the table should be:” select “County”, then select the years, 2008-2009; 2009-2010”. Click “Next” and “Accept the terms” in the pop up window. Make sure state and county are checked and re-select the years 2007-2008; 2009-2010”. Click “next”. Select only the state of Massachusetts in the next box and click View Table in the upper right hand corner. This is what will appear… Table by County State Abbr County Name- most recent year (District) County Name- by survey year (District) [2007-08] County Name- by survey year (District) [2008-09] County Name- by survey year (District) [2009-10] County Number- by survey year (District) [2007-08] County Number- by survey year (District) [2008-09] County Number- by survey year (District) [2009-10] MA BARNSTABLE COUNTY Barnstable BARNSTABLE COUNTY BARNSTABLE COUNTY 25001 MA BERKSHIRE COUNTY Berkshire BERKSHIRE COUNTY BERKSHIRE COUNTY 25003 25003 MA BRISTOL COUNTY Bristol BRISTOL COUNTY BRISTOL COUNTY 25005 25005
ToolsTipsTechniques.docx