1 / 9

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. Participants will: Review how to order and retrieve reports Unzip downloaded files Format an Excel spreadsheet

nicki
Download Presentation

Filtering MAP Data With Excel

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Filtering MAP Data With Excel MAP Data Amy Gordon, Karen Ammann, Judith Conway, Vicki Green, Doreen Palucci Excel Disaggregated Data

  2. Objectives • Participants will: • Review how to order and retrieve reports • Unzip downloaded files • Format an Excel spreadsheet • Disaggregate data by filtering

  3. Essential Question How would using Excel to disaggregate data be beneficial in making data-driven decisions?

  4. 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

  5. Text to Excel • Open with Excel • Format / Freeze / Filter

  6. 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

  7. Guided Practice • UNZIP: • Right click on the zipped folder • Select EXTRACT ALL • Continue clicking NEXT and then FINISH • The new unzipped folder automatically opens

  8. 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

  9. 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?

More Related