1 / 16

Data Analytics

Data Analytics. Norms. Cell Phones on Vibrate Respect all opinions. Agenda. Identifying data for review Prepping data for Excel Printing prep Sorting / Filtering data Conditional Formatting Pivot Tables. Objectives. To take external data and be able to highlight data for action.

zafirah-eman
Download Presentation

Data Analytics

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. Data Analytics

  2. Norms • Cell Phones on Vibrate • Respect all opinions

  3. Agenda • Identifying data for review • Prepping data for Excel • Printing prep • Sorting / Filtering data • Conditional Formatting • Pivot Tables

  4. Objectives • To take external data and be able to highlight data for action

  5. Identifying Data Sources • Teacher anecdotal records • School anecdotal records • State reports • Data provided by vendor products

  6. Locating EWI (Administrator) 1 2 3 4

  7. Exporting EWI • Click the “Export to Excel” link • Wait, then • Click on “Go to Excel” • Locate downloaded file • Downloads folder • Desktop

  8. Data Prep • Data in the cells need to be numbers and not formatted as text or formulas • One method of changing data properties is described below. • Open the downloaded file • Using “Save as” option from “File” menu • Choose from “Format” drop down menu, Comma Separated Value (.csv) • Save file • Close Excel window • File > open recent > select recent csv file

  9. Printing Data • Printing considerations • What should be printed • Certain Columns / Rows • Sheets • How it should be displayed • Alignment • Headers • Multiple sheets

  10. Printing Data-Hiding Columns • Highlight Rows from Header • Right (Control) Click selection > Select option • Blue header indicates hidden rows

  11. Print Data - Headers • Priniting Headers • Helps when data spans pages • Data is organized with headers on every page • File > Page Setup > Sheet • Click on the Icon • Select row / column to repeat on the printed page

  12. Conditional Formatting • Using Criteria to highlight data • Highlight column/row • Select conditional formatting icon • Select formatting type • Editing rule • Select Conditional formatting icon > select edit rule > select rule to edit

  13. Pivot tables • Data summarization tool • Automatically sorts, counts, totals or give the averages of the data stored

  14. Pivot Tables • Select data • Click on the Data Tab • Click on the Pivot table icon • Using the pivot table browser, select criteria for display

  15. Action Questions • With the data available, • What is the data telling you? • What are your next steps? • What is actionable?

  16. Contact • Jan Tong, • Program Specialist • Educational Technology • jtong@philasd.org

More Related