filtering map data with excel
Download
Skip this Video
Download Presentation
Filtering MAP Data With Excel

Loading in 2 Seconds...

play fullscreen
1 / 9

Filtering MAP Data With Excel - PowerPoint PPT Presentation


  • 70 Views
  • Uploaded 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

Filtering MAP Data With Excel

MAP Data

Amy Gordon,

Karen Ammann, Judith Conway, Vicki Green, Doreen Palucci

Excel

Disaggregated Data

objectives
Objectives
  • Participants will:
    • Review how to order and retrieve reports
    • Unzip downloaded files
    • Format an Excel spreadsheet
    • Disaggregate data by filtering
essential question
Essential Question

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

warm up do now
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
Text to Excel
  • Open with Excel
  • Format / Freeze / Filter
guided practice
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
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
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
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?
ad