Making+Data+Come+Alive+with+Excel

[|Making Your Data Come Alive Using Excel] Petrides Building Room 118 715 Ocean Terrace Brooklyn, New York 9:00-3:00 Facilitated by: Robert Agoglia, Susan Scott & Lia Lambrides
 * OITR-Pearls

__Agenda__**

Welcome and Introductions -10 Minutes Getting Online- 5 Minutes Learning and Leading with Excel

Overview: 15 mins


 * What is excel?** Excel is a spreadsheet program that can be used to record data, to manipulate data (by calculating totals and averages, for example), and to display data (in the form of graphs,charts, tables, timelines…). Administrators can easily manage data to make informative decisions about their school, staff, and students. Educators can easily use spreadsheets to average grades, to track projects with multiple parts or deadlines, and to gather data from classroom.


 * How do I find it?** Excel comes standard on a DOE computers. It is part of the MS Office package, and can be found under the program files ( start menu- programs.)


 * ATS Data** - 20 minutes


 * How do we get our schools data from ATS?** We will take some time to access our school data from ATS. The data is emailed directly to your email account in a zipped file format. When you receive your school's data, you will also receive a password that enables you to open the link to the excel file.


 * Getting Started** -- Lessons (20 Mins each lesson) 6 lessons at 30 mins each= 180 mins=3hrs.

Lesson 1: [|**Meet the workbook**] Lesson 2: [|**Enter data**] Lesson 3: [|**Edit data and revise worksheets**] Lesson 4: [|**The ins and outs of AutoFilter**] Lesson 5: [|**Make your data work for you**] Lesson 6: [|**Create a basic chart**]

Wrap up and Practice (30 mins)

[|Evaluation]