Filtering map data with excel
Download
1 / 9

Filtering MAP Data With Excel - PowerPoint PPT Presentation


  • 70 Views
  • Updated On :

Filtering MAP Data With Excel . MAP Data. Amy Gordon, Karen Ammann, Judith Conway, Vicki Green, Doreen Palucci. Excel. Disaggregated Data. Objectives. Participants will: Review how to order and retrieve reports Unzip downloaded files Format an Excel spreadsheet

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Filtering MAP Data With Excel' - tasmine


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Filtering map data with excel l.jpg

Filtering MAP Data With Excel

MAP Data

Amy Gordon,

Karen Ammann, Judith Conway, Vicki Green, Doreen Palucci

Excel

Disaggregated Data


Objectives l.jpg
Objectives

  • Participants will:

    • Review how to order and retrieve reports

    • Unzip downloaded files

    • Format an Excel spreadsheet

    • Disaggregate data by filtering


Essential question l.jpg
Essential Question

How would using Excel to disaggregate data be beneficial in making data-driven decisions?


Warm up do now l.jpg
Warm Up – Do Now

First Things First: Review…

  • Reports need to be ordered and retrieved from the NWEA website

  • Reports need to be unzipped and saved in a folder


Text to excel l.jpg
Text to Excel

  • Open with Excel

  • Format / Freeze / Filter


Guided practice l.jpg
Guided Practice

  • Be sure you have logged in as yourself

  • Make a folder in your MY DOCUMENTS folder called NWEA Fall 2005

  • Insert and open CD

  • Drag the January 12 folder to the new NWEA Fall 2005 folder


Guided practice7 l.jpg
Guided Practice

  • UNZIP:

    • Right click on the zipped folder

    • Select EXTRACT ALL

    • Continue clicking NEXT and then FINISH

    • The new unzipped folder automatically opens


Independent practice l.jpg
Independent Practice

  • Format the spreadsheet:

    • Bold header row

    • Increase width of columns

    • Freeze pane

  • Filter for the following:

    • 6th grade male students

    • Hispanic

    • In mathematics

    • Who scored above the 50th percentile


Closure l.jpg
CLOSURE

  • Essential Question Discussed:

    • How would using Excel to disaggregate data be beneficial in making data-driven decisions?

  • Are there any questions that this filtering exercise did not answer?