Friday, March 26, 2010

Making Your Data Come Alive:


iLead: Making Your Data Come Alive: Using Excel to Analyze, Process, and Present Your School's Performance Data





Overview
Title of Service / Program:iLead: Making Your Data Come Alive: Using Excel to Analyze, Process, and Present Your School's Performance Data
Service Description: The age of information is at the doorsteps of your school giving you unprecendented 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.
Goals: Participants will learn how to use Microsoft Excel to analyze, process, and create visual representations of data for use in presentations, planning meetings, and decision making.
Objectives: To provide participants with the ability to create spreadsheets and charts from the ATS school performance data for use in visual presentations and printed documents. Participants will learn how to customize their spreadsheets to display the pertinent information needed for decision making and planning.
Outcomes / Deliverables:Participants will be able to :
-- add and remove rows/columns, move data by cut/copy/paste, work with tabs, create rows and column headers, 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
Level:Beginner
Follow-Up / Expectations:Participants can use the workshop blog for follow up interaction, updates, and to contact an iLead support person.






Training Flow

Welcome & Introductions
Getting data emailed from ATS
What is excel?
What are the advantages?
Let's get started.
Using ATS data.
Using ARIS Connect.


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**

Using Google Spreadsheets to Share Data (30 minutes)
http://docs.google.com/a/school.nyc.gov

Using ARIS Connect to Find and Create Resources (30 minutes)
Overview of Getting Reports

Wrap up and Practice (30 mins)

Evaluation



Monday, December 10, 2007

Making Your Data Come Alive

iLead: Making Your Data Come Alive: Using Excel to Analyze, Process, and Present Your School's Performance Data

Overview
Title of Service / Program: iLead: Making Your Data Come Alive: Using Excel to Analyze, Process, and Present Your School's Performance Data and ARIS Connect
Service Description: 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.
Goals: Participants will learn how to use Microsoft Excel to analyze, process, and create visual representations of data for use in presentations, planning meetings, and decision making.
Objectives: To provide participants with the ability to create spreadsheets and charts from the ARIS school performance data for use in visual presentations and printed documents. Participants will learn how to customize their spreadsheets to display the pertinent information needed for decision making and planning.
Outcomes / Deliverables: Participants will be able to
-- import data into ARIS
-- add and remove rows/columns, move data by cut/copy/paste, work with tabs, create rows and column headers, 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
Level: Beginner
Program Resources and Materials:
Workshop Blog with Agenda and Resources

Excel Resources


ileadworkspace
Follow-Up / Expectations: Participants can use the workshop blog for follow up interaction, updates, and to contact an iLead support person.