7.++Using+Excel+Effectively


 * //[[image:famous_spreadsheets.jpg width="574" height="432"]]

Focus: There are four steps to working with Excel: data entry, applying formulas, graphing & formatting.//**

//**Time:**// Approx. Cycle To Cycle

//**Content: Concept: Excel sheets can be used effectively to organize, present and analyze quantitative information.**//
 * 1) Information can be inserted & organized in Excel to be quickly and effectively analyzed
 * 2) Basic (+, -, *, /) should be used whenever possible
 * 3) The auto sum button has 5 most commonly used formulas
 * 4) Information is organized in tables with columns and rows in order to effectively manipulated
 * 5) Objects such as text boxes, graphics, etc. can be inserted to support and enhance information in the spreadsheet
 * 6) It is important to ensure information is on the proper number of printable pages
 * 7) Information in the spreadsheet can be converted to charts and graphs that display the information in an informative visual manner

//**Skills:**//
 * 1) Identifying Excel terms (cell, row, column, formula bar, function)
 * 2) Using short cuts (i.e. date & time)
 * 3) Adjusting rows/columns sizes
 * 4) Copying/moving info
 * 5) Clearing contents of a cell
 * 6) Using Fill functions
 * 7) Formatting cells
 * 8) Using the Auto Sum: Sum, Max, Min, Average, Count
 * 9) Using the chart wizard
 * 10) Creating Personal budgets
 * 11) Adjusting Page Setup (Portrait & Landscape)/ Page Margins
 * 12) Inserting/Deleting worksheets
 * 13) Formatting Worksheets (rename, tab colour, etc.)


 * 1) Students and teacher go through a review example together to review previously learned skills
 * 2) Students then do individual examples to solidify and add on to their knowledge
 * 3) During this process the teacher helps the students and gives short "mini lessons" to teach new ideas
 * 4) Students do four assessed tasks:

//**Rubric: **//