1 / 9

Filtering MAP Data With Excel

Join us in this interactive session to learn how to effectively filter and disaggregate data using Excel. Participants will explore the process of ordering and retrieving reports, unzipping files, and formatting Excel spreadsheets. Our hands-on practice will focus on filtering specific datasets, such as 6th-grade male students who scored above the 50th percentile in mathematics. By the end of the session, participants will understand the benefits of using Excel for data-driven decision-making and how to apply these skills in their own contexts.

tasmine
Télécharger la présentation

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