Data+Driven+Decision+Making


 * __iLead Session 4:__** **__Making Your Data Come Alive: Analyze, Process, and Share in a 21st Century School__**


 * Facilitators**: Robert Agoglia and Joe Iacono

-- add and remove rows/columns, move data by cut/copy/paste, work with tabs, create rows and columns, & sort data -- format cells for different alignments, characters, and data type -- create simple formulas -- organize data through the use of tabs -- make your spreadsheet print-ready -- create charts: bar, graph, pie, etc: making titles, labels, legends, and footnotes -- import charts into PowerPoint
 * **Session Overview** || The age of information is at the doorsteps of your school giving you unprecedented access to data that can guide your decision making and steer your school towards success. This workshop will give principals the tools to analyze, process, and create visuals for planning, decision making, and presentations. ||
 * **Date & Time:** || March 30, 2011 ||
 * **Location:** || Bay Ridge LSC, 415-89th Street, Room 508 ||
 * **Goals:** || Analyze, process, and create visual representations of data for use in presentations, planning, meetings, and decision making. Participants will learn how to sustain school improvements by using data effectively in their 21st century school. ||
 * **Course Objectives:** || To provide participants with the ability to create spreadsheets and charts from the ATS school performance data and ARIS for use in visual presentations and printed documents. Participants will learn how to customize their data to display the pertinent information needed for decision making and planning. Administrators will learn the tools necessary to evaluate data, implement change strategies, and analyze sustainability. ||
 * **Practical Applications:** || Using Excel, participants will be able to :

Using ARIS, participants will be able to: --learn what charts are available --manipulate and filter student data --export desired data to excel, PDF for presentation purposes. --Build collaboration platforms to evaluate data and reflect on change strategies. ||


 * **Follow-Up / Expectations:** || Participants will join our educational network on Grouply to collaborate with other administrators on the topic of Data Decision Driven Making. ||


 * __Course Flow:__**

Welcome & Introductions Bridging the Gap between 21st century schools and data Using ATS data The power of Excel: 2007 What are the advantages of filtering and sorting data? Let's get started. Using Google Docs Using ARIS Connect data Evaluation


 * __Course Outline:__**

8:30-8:40 Welcome and Introductions 8:40-8:50 Getting Online 8:50-9:50 Bridging the Gap between 21st century schools and data Before we learn how to get data, it is important to understand how we should use data in a 21st century school

School Leadership Competencies
 * 1) Personal Leadership
 * 2) Data
 * 3) ====//**Demonstrates ability to understand and analyze data from multiple sources**//====
 * 4) ====//**Uses data to identify student learning trends, set goals, monitor and modify instruction, and increase student achievement**//====
 * 5) ====//**Develops school culture and practices that rely on data to inform adult learning professional development, and decion making**//====
 * 6) Curriculum and Instruction
 * 7) Staff and Community
 * 8) Resources and Operations

Let us look at Data Criteria: //No Evidence, Emerging, Developing, Proficient, Mastery//
 * ACTIVITY:** Review the following rubrics (ARIS Learn) and determine where you are for each sub domain of Data. How do we get to where you want to be?

ARIS Learn: Self Paced Courses: //Opportunity Number 259 - Introduction to Data// //Opportunity Number 149 - Excel for School Leaders// //Opportunity Number 227 - Leveraging Data//
 * ACTIVITY:** Access ARIS Learn and watch the following short Videos on Data. Group Reflections

9:50-10:25 **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.

10:25-10:35 BREAK

10:35-12:00 **ACTIVITY: Getting Started** -- Lessons Using Excel to share data: Excel 2007 Training Filtering, sorting, and conditionally formatting data in Excel 2007 Summarizing, consolidating, and outlining data
 * Going Mobile with Excel- iPad apps
 * Docs2go
 * Mobile Office

12:00-1:00 LUNCH

1:00-2:00 Using Google Spreadsheets to Share Data: []
 * Google Mobile-Using your iPad as a data center with Google docs
 * Access your school data from anywhere

2:00-2:55 Using [|ARIS] Connect to Find and Create Resources (30 minutes): Overview of Getting Reports
 * Ready Made reports-Step by Step guide
 * Customizing your reports for beginners
 * Customizing your reports for beginners

Wrap up and Practice (30 mins)
 * ACTIVITY**: Pulling reports and exporting

[|Evaluation]
 * Program Resources and Materials: || Workshop Blog with Agenda and Resources

[|Excel Resources]

ileadworkspace

[|Sustaining a Schools Improvement]

Excel 2010 Training

The Importance of good Data ||

Click here to take the survey
 * Survey link**