ExcelAgenda

(with morning and lunch break) || **Using Excel to Analyze and Display Data - Exploring a Variety of Excel Features and Functions ** For help, go to: http://windhamhigh.wikispaces.com/excel · Action Plan · Give feedback ||   Create a personal action plan of your next steps. Give feedback on today’s session. || ** Objectives: ** As a result of participating in this workshop, participants will be able to: 1. Create mathematical formulas in Excel spreadsheets 2. Use a variety of Excel's features and functions 3. Use Excel to analyze and display data 4. Develop an Action Plan of next steps **Resources:** Find resources to support your work at Windham High Wikispace: http://windhamhigh.wikispaces.com/excel
 * Analyzing Data Using Excel for WHS Program Leaders & Teachers **  February 9 & 10, 2011     7:30 AM to 2:00 PM      ** Agenda **
 * ** Ti me ** || ** Topic ** || ** Outcome ** ||
 * 7:30-8:00 AM || ** Welcome! **
 * Post on LinoIt []
 * Take an Excel Quiz at []
 * Windham High Wiki Resources - To get help, go to: http://windhamhigh.wikispaces.com/excel
 * Creating a network drive mapped to the data || Provide overview of agenda. Do a pre-assessment. Learn where to find other resources to help you continue learning. ||
 * 8:00-1:30 PM
 * Spreadsheet vs. worksheet
 * Insert a new worksheet
 * Copy and paste data from one worksheet to another
 * Move through multiple worksheets
 * Rename worksheets
 * Entering/Editing Data in Worksheet Cells – text (labels) vs. numbers
 * Entering/Editing formulas
 * Simple formulas, e.g., adding, subtracting, multiplying, dividing, etc.
 * Special formulas, e.g.:
 * CountA
 * Countif
 * Mean, Median, Mode
 * Copying and filling data
 * Filtering and sorting data
 * Select All
 * Sort
 * Filter
 * Printing
 * Set print area
 * Set/adjust margins
 * Add header/footer
 * Set orientation, scaling and paper size
 * Asking questions of your data - Make your data do the talking
 * Conditional formatting
 * Charts and graphs
 * Pivot Tables || Learn and practice using many features in Excel that assist in data analysis. ||
 * 1:30 – 2:00 PM  || ** Closure and Next Steps **