Excel

**CLASS INFORMATION**:

 * ===**Class Name:**=== || ===Making Your Data Come Alive - Using Excel to Analyze, Process, and Present Your School's Performance Data  === ||
 * ===**Class Coordinator:**=== || ===Valrie Edwards=== ||
 * ===**Class Developer/Creator:**=== || ===Jacquii Leveine=== ||
 * ===**Class Facilitator(s):**=== || === ===

||
 * ===**Class Days/Dates:**=== || ===February 11, 2009===

||
 * ===**Class Time:**=== || ===8:30 AM - 1:30 PM=== ||
 * ===**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. ||
 * ===**Class 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. ||
 * ===**Class 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. ||
 * ===**Class Outcomes/Deliverables:**=== || Participants will leave this workshop with the ability to:
 * download exam history reports from ATS
 * freezing panes
 * add and remove rows/columns, move data by cut/copy/paste, work with tabs, create rows and column headers, sort data
 * create and utilize formulas (database and logical functions)
 * organize data through the use of tabs
 * sort and filter information
 * use the advanced filter feature
 * create pivot tables and charts ||

**__CLASS__ __OUTLINE__**:
**8:30 AM - 10:45 AM**


 * ATS Data - Pulling Your School's Data
 * [|Downloading Exam History Reports from ATS Jing Tutorial]
 * [|Opening Downloaded ATS Reports via Email]
 * Sorting Information with Single and Multiple Criteria
 * Filtering Data
 * Advanced Filtering Techniques
 * Using the Database Function to Analyze Data

**10:45 AM - Break**
 * 11:00 AM - 1:15 PM**
 * Using the Logical "IF" Function to Analyze Data
 * Creating Comments
 * Using Pivot Tables to Analyze Data
 * Using Charts from Pivot Tables to Analyze Data

**1:15 PM - 1:30 PM**

 * Evaluation Survey

**DIGITAL RESOURCES**:

 * [|Downloading Exam History Reports from ATS Jing Tutorial]  , Courtesy of Robert Agoglia of iLead
 * [|Opening Downloaded ATS Reports via Email]  , Courtesy of Robert Agoglia of iLead
 * [[image:http://oitxinstitutes.wikispaces.com/i/mime/32/application/pdf.png width="32" height="32" caption="external image pdf.png" link="http://oitxinstitutes.wikispaces.com/file/view/MicrosoftExcelData_Tutorial.pdf"]]   - Analyzing Data with Microsoft Excel 2003 Tutorial
 * [|JLEVEINE.REXH_Worksheet.XLS]   - Use this spreadsheet to complete the tutorial if you do not have access to ATS
 * [|JLEVEINE.REXH_12_8_08.XLS]   - Completed ATS Data Report