1. Welcome students!
  2. Please read #s 3, 4, and 5 daily
  3. The following exercises/projects should be in your folder on the "Room 408 Student S" drive. These assignments will be graded as: "Master of Skill" or "Review Master of Skill." Proper spelling, grammar and punctuation are required for all assignments.
    1. TravelExpenses_YourInitials.xlsx (week 1)
    2. WishList_YourInitials.xlsx (week 1)
    3. ProductAnalysis_YourInitials.xlsx (week 2)
    4. Shopping_Start_YourInitials (week 2)
    5. Bank Statement_Your Initials (week 3)
    6. Fantasy Football_Your Initials (week 3)
  4. Online Expert Work
    1. The following should be completed for Session 1: pre-assessment, all of the training, all labs, post-assessment
    2. The following should be completed for Session 2: pre-assessment, all training for sessions, all labs
    3. The following should be completed for Session 3: pre-assessment, all training sessions, all labs

  5. Day 25 of 25 August 9, 2013
    1. PPT-How do we demonstrate our knowledge and skills in PPT?
      1. Objective: Review PPT topics on LearnKey; Showcase your work
      2. Agenda:
        1. 9-10: Review PPT on LearnKey
        2. 10-11: Student Presentations
        3. 11-11:20: Break
        4. 11:20-12:00: Personal Projects
    2. Excel-How do we demonstrate out knowledge and skills in Excel?
      1. Objective: Review Excel Topics in sessions 1-4
      2. Agenda:
        1. 9-10: Session 3 Training on LearnKey
        2. 10-11: Presentations/Work on Portfolio annotations
        3. 11-11:20: break
        4. 11:20-12:00; Personal Projects
  6. Day 24 of 25 :-) August 8, 2013
    1. PPT-How do we showcase our PPT work?
      1. Objective: present on a topic of interest using PPT knowledge and skills
        1. Objective:
          1. 9-10: Work on final presentation project/review session 1-2 packet; mini-lesson-->forms
          2. 10-11:Presentations
          3. 11-11:20: Break
          4. 11:20-12:20: Online Expert-Sessions 1-3 selected topics
          5. 12:20-1:00 Quotations project- Session 1-3 review
    2. Excel-How are the vlookup and ifs functions used?
      1. Objective: use conditional logic formulas (if, and, or, iferror, vlookup)
        1. Agenda
          1. 9-9:30: Personal Projects/Review yesterday (and, or, iferror, etc) on LearnKey; mini-lesson-->forms
          2. 9:30-10: Lesson: sumif, vlookup functions
          3. 10-11: Project Annotations for Portfolio
          4. 11:20-12:20: Session 3-LearnKey-pre-training-labs-
          5. 12:20-1:00: session 3 projects/portfolio annotations
  7. Day 23-August 7, 2013
    1. PPT-How do we customize slide shows?
      1. Objective: manipulate animations and effects
      2. Agenda:
        1. 9-10: work on final presentation project
        2. 10-11: review sessions 1 and sessions 2 selected topics-learnkey
        3. 11-11:15: lesson-customize slide shows
        4. 11:15-11:35: Break for Staff Meeting
        5. 11:35-12:35: Work on final presentation
        6. 12:35-1:00 Quotations project--
    2. Excel: How do we use conditional logic functions?
      1. Objective: Use nested if, and, or, not, iferror, vlookup functions
      2. Agenda:
        1. 9-9:30: Personal Projects/Review
        2. 9:30-10: Lesson: nested if, and, or, not, iferror, vlookup functions
        3. 10-11:15: Project Annotations for Portfolio
        4. 11:15-11:35: Break for Staff Meeting
        5. 11:35-12:35: Continue Lesson on conditional logic/annotations of projects
        6. 12:35-1:00: LearnKey review
  8. Day 22-August 6, 2013
    1. Excel: How do we use conditional logic?
      1. Objective: Use the if, or, and functions
      2. Agenda:
        1. 9-9:30: Review nested formulas, naming ranges and absolute values
        2. 9:30-10:00: Lesson - Conditional Logic
        3. 10-11: work on portfolios-annotations-model for students
        4. 11:20-12:20-Session 3 LearnKey
        5. 12:20-1:00: Portfolios
    2. PowerPoint: How do we use multimedia in PPT?
      1. Objective: manipulate audio, video and animation functions
      2. Agenda:
        1. 9-9:30: Review shapes, outlines, clipart,
        2. 9:30-10:00: work on presentation
        3. 10-10:30: lesson on multimedia
        4. 10:30-11: practice multimedia
        5. 11:20-12:20: work on presentations
        6. 12:20-1:00: Review on LearnKey

  9. Day 21-August 5, 2013
    1. PowerPoint-How do we work with outlines, tables, shapes and clip art?
      1. Objective: work with and manipulate outlines, images, tables and shapes
      2. Agenda:
        1. 9-10: sign up for presentation slots; review tables, images, shapes
        2. 10-11: lesson: inserting content and lesson in tables, images and shapes;
        3. 11:20-12:20: project practice
        4. 12:20-1:00: work on presentation
      3. Excel: How do we use nested and logic formulas in Excel?
        1. 9-10: complete session 3 training and labs
        2. 10-11: lesson on logic:
        3. 11:20: 12:20 session 3 projects
        4. 12:20-1:00: review
  10. Day 20-August 2, 2013
    1. Excel: How do we insert a secondary axis in charts and create data ranges?
      1. Objective: create secondary axis to show various data ranges; create data ranges to efficiently use formulas
      2. Agenda:
        1. 9-10: review Excel session 3; secondary axis
        2. 10-11: complete session 3 training and labs
        3. 1:20-12:20: session 3 projects
        4. 12:20-1:00: personal projects
    2. PowerPoint: How do use text from other documents in PPT?
      1. Agenda:
        1. 9-10: Complete session 1 training & labs in PPT
        2. 10-11: Review session 1 training and labs in PPT
        3. 11:20-12:20: post assessment session1
        4. 12:20-1: session 2-pre assessment; Body Language TED Talk: http://www.ted.com/talks/amy_cuddy_your_body_language_shapes_who_you_are.html

  11. Day 19-August 1, 2013
    1. Excel: How are data points organized in Excel charts?
      1. Objective: choose the appropriate chart tool to represent data
      2. Agenda:
        1. 9-10: continue to work on Chart Exercises
        2. 10-11: Q & A: reviewing charts
        3. 11-11:20: Break
        4. 11:20-12:20: LearnKey Session 4-Charts; Session 3: review
        5. 12:20-1:00: Personal Projects-resumes, etc. Amazon.com is hiring :-) http://www.amazon.com/gp/jobs
    2. PowerPoint: How are data points organized in Excel charts?
      1. Objective: choose the appropriate chart tool to represent data
        1. Agenda:
          1. 9-10: continue to work on Chart Exercises
          2. 10-11: Q & A: reviewing charts
          3. 11-11:20: Break
          4. 11:20-12:20: LearnKey session 1
          5. 12:20-1:00: Personal Projects-resumes, etc. Amazon.com is hiring :-) http://www.amazon.com/gp/jobs
  12. Day 18-July 31, 2013
    1. Excel: How do we create charts in Excel?
      1. Objective: Use chart tools to correctly represent data
      2. Agenda:
        1. 9-10 Session 4: Introduction to Charts/Formatting Charts
        2. 10-10: 30: Lesson on charts
        3. 10:30-11: Chart exercises
        4. 11-11:20: Break
        5. 11:20-12:20: Chart Exercises con't
        6. 12:20-1: Review/Personal Projects
    2. Word/PPT:
      1. How do we create charts in PPT?
        1. Objective: Use chart tools to correctly represent data
        2. Agenda:
          1. 9-10: Finish Bird Research exercise; finish session 1 training in ppt (answer key will be uploaded)
          2. 10-10: 30: Lesson on charts
          3. 10:30-11: Chart exercises
          4. 11-11:20: Break
          5. 11:20-12:20: Chart Exercises con't
          6. 12:20-1: Review/Personal Projects

    3. Excel: How are various charts used in Excel/
      1. Objective: Create and format 3 basic chart types
      2. Agenda:
        1. 9-10: Listen to and take notes on Session 4: Formatting Charts
        2. 10-11: Mini-Lesson on Charts and Practice Exercise
        3. 11-11:20---Break
        4. 11:20-12:20: Review Exercises-Excel
        5. 12:20-1:00: Personal Projects
    4. PowerPoint: How do we create simple research presentations with charts in PowerPoint?
      1. Objective: Research information on a bird and create a PowerPoint presentation with relevant charts and graphics
      2. Agenda:
        1. 9-10; finish "About Me" ppt exercise; listen to session 1 ppt training and take notes
        2. 10-11: lesson on charts and graphs in ppt
        3. 11:20-12:20: research exercise
        4. 12:20-1:00; review/personal projects
  13. Day 16-July 29, 2013
  14. Day 15-July 26, 2013
    1. Excel and PowerPoint Classes meet in the same classroom
  15. Day 14-July 25, 2013

  16. Day 13-July 24, 2013
    1. Aim: How are formulas referenced in Excel?
      1. Objectives; review big ideas from sessions 1 & 2 (knowledge, skills, projects): basic navigation of excel & formatting data and performing simple operations; evaluate knowledge and skills of sessions 1 & 2: basic navigation of excel & formatting data and performing simple operations; take session 3 pre-assessment; obtain an overview of referencing formulas;
      2. Agenda:
        1. 9:00 - 10:00~Do Now: 1) log on to http://oace.onlineexpert.com and review sessions 1 & 2 skills & projects; finish any outstanding assignments/tasks (see #s 3 & 4 above)
        2. 10:00 - 11:00~Midterm Quiz Practice on sessions 1 & 2 skills (closed book); Actual Midterm will be on Friday 7/26/2013 from 10:00-11:00
        3. 10:00-11:00~session 3 pre-assessment
        4. 11:00-12:00~Direct instruction and guided on referencing formulas
        5. 12:00-12:15~Break
        6. 12:15-1:00~LearnKey Session 3 - Training on "Referencing Formulas'
    2. Lesson:
  17. Day 12-July 23, 2013
    1. Aim: How do we format data and perform simple operations in Excel 2010?
    2. Reminder: no drinks or food near the computers
    3. Do Now: Work on "Bank Statement" project and save this file as 'Bank Statement_Your Initials' in your folder on the S drive
    4. Lesson: Review session 3 big ideas from the review packet
    5. Work on "Fantasy Football" project save this file as 'Bank Statement_Your Initials' in your folder on the S drive
    6. Review Session 2
    7. Complete the post-assessment on session 3
  18. Day 11-July 22, 2013
    1. Aim: How do we format data and perform simple operations in Excel?
    2. Do Now: Check your responses to session 2 note-taking/review handouts
    3. Objective: review formatting data and formulas
    4. Agenda:
      1. 9:30-10:30-review session 2-fill in the blanks and glossary
      2. 10:30-11:00-review session 2-short answers
      3. 11:00-11:15-B R E A K
      4. 11:15-12:15-project 1- review/finish project Shopping_start.xlsx; begin BankStatement project
      5. 12:15-1:00-review today's work
  19. Day 10-July 19, 2013
    1. Happy Friday to all. Sorry that I am not in class today. Please work on the following tasks at your own pace:
    2. Complete yesterday's project on the "Shopping_Start" file
    3. Log on to http://oace.onlineexpert.com. Take notes on the topics below as you watch the videos in session 2 (New Students -please watch and take notes on the session 1 videos) *Make sure you've done the pre-assessment for sessions 1 & 2. After you've taken notes on the videos complete the labs for the session. Have a pleasant weekend. See you all on Monday.
      1. Session 2 video topics:

        Section A: Formatting Data

        • Formatting Worksheets
        • Cell/Font Color
        • Background Images
        • Watermarks
        • Worksheet Tab Color

        Section B: Formatting Numbers

        • Modifying Cell Formats
        • Format Painter
        • Date Formatting
        • Formatting Multiple Cells
        • Numerical Cell Values
        • Special Formats

        Section C: Formatting Text and Tables

        • Formatting Fonts / Fills
        • Cell Height/Width
        • Noncompatible Commands
        • Cell Alignment
        • Inserting Comments
        • Merge and Center
        • Tables

        Section D: Understanding Formulas

        • Operations
        • Arithmetic Operations
        • Additional Operation Symbols
        • SUM Function
        • Ranges in Functions
        • AutoSum
        • Average
        • Min/Max Functions
        • Count Formula
        • AutoCalculate
        • Modifying AutoCalculate
        • Copying Formulas
        • Cell Multiplication
        • Relative Cell References
        • Absolute Cell References
      2. Session 1 topics (for New students and those who haven't yet watched all of session 1 videos)

        Section A: Introduction

        • Course Overview
        • Excel 2010 Introduction
        • Quick Access Toolbar
        • Toolbar Customization
        • Additional Customization Buttons

        Section B: Navigating Excel

        • Ribbon Organization
        • Function Grouping
        • Multiple Function Access
        • The Document Window
        • Basic Navigation
        • Workbook Options

        Section C: Excel 2010 Shortcuts

        • Best Practice Guidelines
        • Common Hot Keys
        • Speed Keys
        • Function Keys
        • CTRL Keys
        • ALT Keys
        • Visible Speed Keys

        Section D: Creating and Manipulating Data

        • Entering Data
        • Auto Fill a Series
        • Creating Custom Lists
        • Fill Adjacent Cells
        • Fill Non-Adjacent Cells
        • Auto Fill on Multiple Sheets
      3. Section E: Managing Worksheets

        • Copying/Moving Worksheets
        • Renaming Worksheets
        • Inserting/Deleting Worksheets
        • Hiding Worksheets

        Section F: Data Validation

        • Range Criteria
        • List Criteria
        • Extending the List
        • Input Message
        • Validation Error Alerts
        • Validation by Character

        Section G: Modifying Cell Content

        • Copy/Paste Options
        • Paste
        • Inserting Columns
        • Transporting Data
        • Copy Cell Formatting
        • Removing Duplicates

        Section H: Changing Views

        • Zoom
        • Workbook Views
        • Page Layout
        • Freeze Panes
        • Split Windows
        • Viewing Multiple Windows
  20. Day 9-July 18, 2013
    1. Aim: How do we perform simple calculations?
    2. Objectives: perform arithmetic operations and simple formulas in Excel
    3. Agenda:
      1. 9-10: common core state standards http://www.corestandards.org/the-standards review yesterday day 8; Understanding formulas lesson-guided instruction
      2. 10-11: Understanding formulas lesson-guided instruction con't
      3. 11-11:15-b-r-e-a-k
      4. 11:15-12:15: shopping project: copy the "Shopping_Start.xlsx" file fromS:\Excel Summer 2013 Michele Persaud\Data Files to your folder and then open up the file. Begin the project :-)

      5. 12:15-1:00: Review
      6. Check this website for tomorrow's work
    4. Lesson:
      1. Understanding Formulas

        • Operations: over four hundred formulas; operations vs formulas: zoom to 200; = sign creates dependency and relationships-all characters depend on each other

        • Arithmetic Operations: ; =2+4 hit enter; get 6; 6-3 get 3-jun so double click into cell to edit it and add the equal sign before the operation; or hit F2 key; f2-edit cell contents key; copy top format down; click in previous cell click on format painter; double click on new cell; = 2*5  10; =12/4  3 ; format painter practice

        • Additional Operation Symbols: & ampersand concatenation; ^shift + 6  ^exponent caret symbol : a number to its power; define operations with formulas??

        • SUM Function: go to bottom of number range; 1st formula-most common ; =sum(open parameter; excel prompts us with functions that begin with s then sum, etc; hit tab to select the function**; syntax=how the function is displayed = sign function name; a set of parens;

        • Ranges in Functions: =sum(; hit arrow key and shift and select adjacent cells; e2:e22 :=through; need final parentheses; hit enter and get the simple sum;

        • AutoSum: click on autosum buttom: greek letter sigma; speed key alt + = hit enter; can copy formula and place it elsewhere; change format of cell two ways in the home tab general click down arrow; or format paint the currency; = sum; hold ctrl key and randomly select cells to add hit enter;

        • Average: edit a cell that has a sum function; f2; replace sum with average;

        • Min/Max Functions: edit the average cell; = min=minimum; = min(e2:e22); shows the lowest number in the range; = max (e2:e22)

        • Count Formula: counts all the cells that contain values; numbers go into cells as values as default; =count (e2:e22); get 21; counts all the cells that contain values; delete a value from the range and the value should change; type text string; get 20 bc count formula only recognizes numerical values; =count a : f2-edit formula; *counta(e2:e22) counts all non-blank cells in a range; so count = 21; delete cells and count automatically updates; other paste options

        • AutoCalculate: select any two cells; two or more that contain numerical values; see status bar-average; count and sum; ctrl key hold and randomly select cells; ctrl + select cells with mouse; auto calculate; two or more cells with values

        • Modifying AutoCalculate: 3 best friends; right click on the status bar; can customize the status bar; check or uncheck the choices

        • Copying Formulas: f2 or double click; examine the range-e2-e22; copy formula to h; range changes o h2 to h22; cell address is copied relatively-built in default

        • Cell Multiplication: use for restaurant tip; tip 15%; amount column has meal prices; =left arrow*click on 15% hit enter—$4.50

        • Relative Cell References: copy that formula; double click; get zero values for other cells; when copy formula down; ctrl shift down arrow;

        • Absolute Cell References: tip example data sheet; =a4*$C$3; absolute the formula


  21. Day 8-July 17, 2013
    1. Aim: How do we format text, numbers and tables?
      1. Objective: use special formats to modify cells
      2. Agenda
        1. 9-10 am: TED talks and review yesterday
        2. 10 am - 11 am: format text, numbers, tables
        3. 11 am - 11:15: break :-)
        4. 11:15 - 12:15: Independent practice (complete session 1 work, do session 2 pre-assessment; begin session 2 training)
        5. 12:15 - 1:00: Review sessions 1 & 2 skills (handouts, etc)
      3. Do Now: Go to www.ted.com/talks --> on the left side of the page select "most viewed" --> do you see anything of interest? Let's watch a talk together.
      4. Lesson:
        1. Section A: Formatting Data

          • Formatting Worksheets-view-show: gridlines-turn on/off; formula bar; headings-row #s and column #s-can deselect-worksheet looks like word for windows;

          • Cell/Font Color-select cell or range or worksheet; select data range-ctrl a; home tab; paint bucket icon-pull-down-array of colors; roll over –live preview; no fill-default-white; more colors-color wheel; paint button pull-down; colors; custom; slider; density/intensity of color; rgb-red green blue; manually put in number 0-255; all 255 white; all 0-black; change font color to white; undo-; ctrl a a –select whole worksheet;

          • Background Images: background is bottom layer of worksheet; picture goes on top; insert picture-superficially on top of data cells; true background: page layout-background-vivid pic might obscure the data; busy compensation; get rid of grid lines; view-show-gridlines-; opposite of orange is blue-ctrl a-data-ctrl a a-all of worksheet; choose a darker blue

          • Watermarks-washout the background so it’s not intrusive; page layout-background-ok; delete background; insert; header; page layout view; cursor in header; in context tools; header footer tools added as sub tab-design; click on design; see groups in ribbon; picture-add picture-select-insert &[picture]; format picture-click on picture tab not size; image control section; right click on picture and format picture to get that dialog box in general; watermark=brightness up; contrast lessen; brightness 75; contrast 25; click ok; hit enter; click view or off to side; view-normal-no background; print preview under file;

          • Worksheet Tab Color: right click on sheet tab-tab color; tab color-choose color;

          Section B: Formatting Numbers

          • Modifying Cell Formats-to see cell format click on cell ex: under number group will see currency; what is the name of the format and how do we find out-home tab-number; can change format on down arrow; right click on dollar sign; dollar format with decimals-accounting format; increase-decrease decimal; number;

          • Format Painter-copy format of existing cell-representative cell-click on format painter; click into cell you want to format; want to keep that format; double click on format painter; esc will get out of format painter;

          • Date Formatting: 12/25/2010; December 25, 2010 25 dec-10-default; select column-click on I to select entire column; home; format; dialog box; date; type; choose format; ok; dates are numerical values-not text-but mathematical arithmetic bc can add subtract dates-can’t do that if dates are text; 10/25/2010; right click format cells-general 10/25-/2010 = 40476; Jan 1, 1900-reformat-format cells-general = 1; 1/1/1900=1; 40,476 days from Jan 1, 1900;

          • Formatting Multiple Cells

          • Numerical Cell Values: zip codes that begin with zero ex: 00907 enter - 907; cell format is general; zeros aren’t displayed-have to format cells; r click; format cell; special; ctrl down arrow bottom of data range; format cell-special-zip format-see sample-zip+4 will automatically throw in dash; phone # with dashes also SSN*

          • Special Formats-general cell; add code number with mix number digits; 1-9 ok; 1-9 with leading zeros 000000907;  907; need leading zeros; format cells; custom; default-general; zeros will serve as placeholders 000000000; 000000907 appearsp; custom place holders; zips r aligned; text-left aligned; can format zips as texts; format blank cell; r click; text; 00907 enter; *custom place holders; zip codes; zips with leading zeros don’t need numerical formats; can do text format as text; type 00907-left aligned as if text; green arrow-might be an error; move cursor over green-> smart tag pull down arrow; options; ignore error; green triangle gone; short way; type apostrophe with zip and will become text

          Section C: Formatting Text and Tables

          • Formatting Fonts / Fills-ctrl shift right arrow select row cells; home tab; bold is highlighted bc text in cell is highlighted; home tab-format cells-font-color; style font Arial; can change size of font; cell height will make accommodations for cell; can click and drag and manually adjust or double click to auto fit;

          • Cell Height/Width-can manually make row height bigger double click in cell to edit it; can insert a break between first and name; get rid of extra space; double click in the cell; first and name on two different levels; return will take you to cell below; put cursor near N-alt hit enter and enter; double click between columns to auto fit; place cursor between row names and double click

          • Noncompatible Commands: speed keys that DO NOT work in Excel; ctrl + l = left align; ctrl + e = center align; ctrl + r = right align ; ctrl + j = justified; ctrl r copy to right; ctrl d copy downpractice;

          • Cell Alignment-alignment group in the home tab; since alignment speed keys don’t work, format cells; highlight cells; r click; format cells ; alignment; pull down on horizontal click center; or use alignment buttons in the home tab

          • Inserting Comments: right click or insert tab; when some functions are not available it might be that there is a grouping setup; now r click; should see insert comment; user name appears; type in a comment….;

          • Merge and Center: putting a title in multiple columns; choose a blank row and select a few cells and click merge and center; or type into one cell and then hit merge center button; select all of data range to merge and center a title; undo 100x in Excel;

          • Tables: select worksheet; insert menu; click on table; default-my table has headers; click ok; get a look; a design; new context tab at the end of ribbon-design tab with various tools; quick styles can move over designs and get a preview; table style options; header row; banded rows; deselect header row; still have a table but no categories so reselect it; keep as a data table-two options: tools-convert to range-are you sure; OR data menu; deselect filter-will take pull downs off;


  22. Day 7-July 16, 2013
    1. Aim: How do we format data text, numbers and tables in Excel 2010?

      Objective: Student will be able to: modify cell formats; use format painter; format dates; formatting multiple cells; create numerical cell values; use special Formats

      9-10 am Hour 1: review "Product Analysis for the Pizzeria" and day 6

      10-11 am Hour 2: guided practice lesson-modify cell formats through use special formats

      11-12 noon Hour 3: Learn key notes and practice-Session 2

      12 noon- 1 pm Hour 4: review hours 1-3; be sure all of session 1 activities are complete; organize/reflect on our work

  23. Day 6-July 15, 2013
    1. How do we format data in Excel?
    2. Do Now: For interesting articles Browse the "Business Insider" website http://www.businessinsider.com/ and for "50 websites that make the web great" click on this link:
      http://www.time.com/time/specials/packages/completelist/0,29569,2087815,00.html. Are there interesting websites that you would like to share with others?
    3. Objectives: format data, text, numbers and tables
      9-10 am Hour 1: review-"Removing Duplicates" last week;
      10-11 am Hour 2: guided practice lesson-format data
      11-12 noon Hour 3: Learn key notes and practice-Session 2
      12 noon- 1 pm Hour 4: review hours 1-3; begin the "advanced pizzeria project" to review session 1
    4. My Notes: Review Session 1
      1. Removing Duplicates: ctrl z undo up to 100x; select row 13 by clicking row 13; copy ctrl c; insert cells; from tab or ctrl shift +sign; ctrl a highlight data range; data tab; remove duplicates; remove rows by columns; my data has headers should be checked; click ok; 1 duplicate and 21 unique values;
      2. Section H: Changing Views
      3. • Zoom: view tab; zoom button; dialog box; default 100%; fit the selection; select all; ctrl a; fit selection-see entire worksheet ex: 77%; click on slider and will see dialog box or use the slider; + or – sign incrementally increase/decrease; zoom to selection; fills entire window to see data range; default 100%
      4. • Workbook Views: view tab; workbook views; page layout; ruler; margin around as if on paper; if print what it would look like; page break preview; do not show dialog box; you can adjust page breaks by clicking and dragging with the mouse; dotted lines; page 1; page 2; fix column borders; click drag border manually; double click on border to auto fit nicely; click and drag the dotted line border; page layout; full screen; min, max. restore down; maximize; double click in the title area; click on normal view….play with views to print
      5. • Page Layout: under page setup; print area; set print area; will see border to delineate print area; how to get rid of page break; appears when page break preview or preview/print area/ or specify new page break; how to get rid of them; click on file; options; advanced; display; display option for workbook/worksheet; show page breaks is selected; deselect and click ok; margins- normal; customize; change orientation portrait-vertical; landscape horizontal; size-default is letter; legal abroad A4;
      6. • Freeze Panes: view tab; freeze panes; place cursor in cell A2; below top row; freeze top row; see margin line on top row; to add new entry; keep seeing title; unfreeze-click freeze panes; have titles in left column; place cursor in B2; titles in first column; b2; freeze panes; choose freeze panes; cursor down and to the right; unfreeze; click on freeze panes and unfreeze;
      7. • Split Windows; window split bar; click and drag; will split the screen; click and drag back to get rid; vertical scroll bar can split the screen; or double click and it disappears; can split for ways; if you have entries on one side and results on other side; if you know worksheet well splitting is recommended; large worksheet-freeze panes if unfamiliar
      8. • Viewing Multiple Windows: view tab; new window; click; colon #; :2. Created a mirror image; arrange all; vertical; can work with different sections of the worksheet simultaneously; same file same version; whatever changes make; all will be saved; two files; arrange all- vertical or horizontal; compare; copy and paste; minimize the ribbon; expand the ribbon; tent icon; right click on zoom and add to quick access toolbar; practice;
    5. My Notes: Session 2 Formatting Data
      • Formatting Worksheets-view-show: gridlines-turn on/off; formula bar; headings-row #s and column #s-can deselect-worksheet looks like word for windows;
      • Cell/Font Color-select cell or range or worksheet; select data range-ctrl a; home tab; paintbucket icon-pull-down-array of colors; roll over –live preview; no fill-default-white; more colors-color wheel; paint button pull-down; colors; custom; slider; density/intensity of color; rgb-red green blue; manually put in number 0-255; all 255 white; all 0-black; change font color to white; undo-; ctrl a a –select whole worksheet;
      • Background Images: background is bottom layer of worksheet; picture goes on top; insert picture-superficially on top of data cells; true background: page layout-background-vivid pic might obscure the data; busyà compensation; get rid of grid lines; view-show-gridlines-; opposite of orange is blue-ctrl a-data-ctrl a a-all of worksheet; choose a darker blue
      • Watermarks-washout the background so it’s not intrusive; page layout-background-ok; delete background; insert; header; page layout view; cursor in header; in context tools; header footer tools added as sub tab-design; click on design; see groups in ribbon; picture-add picture-select-insertà &[picture]; format picture-click on picture tab not size; image control section; right click on picture and format picture to get that dialog box in general; watermark=brightness up; contrast lessen; brightness 75; contrast 25; click ok; hit enter; click view or off to side; view-normal-no background; print preview under file;
      • Worksheet Tab Color: right click on sheet tab-tab color; tab color-choose color;

  24. Day 5-July 12, 2013
    1. Aim: How do we demonstrate our learning of basic navigation of the Excel 2010 interface?
    2. Objective: review session 1 knowledge and skills via short answer, fitb, matching questions, and projects
    3. Do Now: Review Session 1 vocabulary and major skills-f-i-t-b, short answer, glossary
    4. Lesson: Review session 1 key ideas--ANSWER KEYS are in my folder :-)
      1. Projects 1-3
      2. LearnKey Post Assessment
    5. Thank you for your work in week 1. Have a good weekend! :-)
  25. Day 4-July 11, 2013
    1. Aim: What have we learned in session 1?
    2. Objectives: perform drills and exercise to review the skills in Session 1
    3. Do Now:
      1. Download google chrome browser to your computer for easier web access
        1. search for google chrome in any search engine
        2. click on the google chrome link and select "download chrome" and follow the steps
      2. Read about the top job search sites here: http://www.realsimple.com/work-life/life-strategies/job-career/job-search-websites-00000000012217/index.html
      3. You can also search for jobs at these sites: NYS Dept of Labor http://www.labor.ny.gov/home/ and Idealist
        http://www.idealist.org/
    4. Lesson: Review data validation; modifying cell contents; changing views;
    5. Practice session 1 skills
    6. Independent Review on LearnKey

  26. Day 3- July 10, 2013
    1. Aim: How do we create, manipulate and validate data?
    2. Objectives: perform the following tasks in Excel: Entering Data, Auto Fill a Series, Creating Custom Lists, Fill Adjacent/l Non-Adjacent Cells, Auto Fill on Multiple Sheets
    3. Activities
      1. Review class website http://schooldays360.wikispaces.com/Excel and LearnKey site http://oace.onlineexpert.com
      2. Reading: Forget Business School: Why An Emotional Education Is Indispensible
        http://www.forbes.com/sites/avidlarizadeh/2013/07/08/forget-business-school-why-an-emotional-education-is-indispensible/
      3. Lesson on creating, manipulating, validating data
      4. Excel Drills
      5. Pre-assessment & Labs
      6. Exit Label parts of Excel workbook; Review Session 1 sections A-F
  27. Day 2-July 9, 2013
    1. Aim: How do we navigate Excel 2010:
    2. Objectives: become familiar with the Excel 2010 interface; create, edit and delete worksheets; explore and describe the Excel window; learn to edit a worksheet, save the workbook, and properly exit the program.
      1. Lesson on Excel Interface: see pages 2-15 in the document at http://www.ctcconnect.org/images/files/file/Microsoft%20Excel%202010%20-%20Complete.pdf
      2. Excel Exercises: pages 13-15 at http://www.ctcconnect.org/images/files/file/Microsoft%20Excel%202010%20-%20Complete.pdf
      3. Save all files in "your name" folder on the 408 S drive. Follow the filename directions listed in the exercise/task
      4. Quiz: True/False and MCQs pages 13-14 http://www.ctcconnect.org/images/files/file/Microsoft%20Excel%202010%20-%20Complete.pdf
  28. Day 1-July 8, 2013
    1. Aim: How is Excel 2010 utilized?
    2. Syllabus
    3. Introductions
    4. Create student data sheet in excel: student name; experience with Excel; goals for the course; something to share with the class
    5. Pre-assessment-Session 1
    6. Session 1: Introduction through Introduction to Shorcuts
    7. Q & A
    8. Exit-questions 1-6:
      1. Where is home in excel? How do I get home?
      2. True or false: There are over a million columns and over sixteen thousand rows in Excel 2010
      3. How many sheets can fit in a workbook?
      4. What is the speed key to get to the start menu? my computer? the desktop?
      5. What do the following function keys do: F1? F4*? F7?
      6. What are the speed keys to: copy? paste? print? select all? get a new worksheet?
        1. A1; Ctrl home
        2. False: over a million rows and over 16,000 columns
        3. 255 sheets
        4. windows key-(key after ctrl); windows key + e; windows + D
        5. help; repeat last simple command*; spell check
        6. ctrl c; ctrl p; ctrl a; ctrl n
  29. Cool Web Tools
    1. http://yourpersonaltechguide.com/

    2. http://screencast-o-matic.com/


  30. Excel Course Outline
    1. Office of Adult and Continuing Education Mid-Manhattan Adult Learning Center Excel 2010 Course Outline


      July 8, 2013-August 9, 2013
      Room 408
      Teacher: Michele Persaud
      Email: mpersau3@schools.nyc.gov
      Class website: http://schooldays360.wikispaces.com/Excel

      Using Excel 2010 via Online Expert LearnKey, you can:
      •Organize, sort, and record data.
      •Enter in text and mathematical equations.
      •Keep, track, chart, graph, and compare statistics.
      •Maintain records.
      •Create mathematical equations and functions to accurately keep records and statistics whenever data changes.
      You can also use Excel to manage finances, schedule calendar time, plan projects or events, create checklists, etc.

      Week of July 8, 2013 Session 1


      Section A: Introduction

      • Course Overview
      • Excel 2010 Introduction
      • Quick Access Toolbar
      • Toolbar Customization
      • Additional Customization Buttons

      Section B: Navigating Excel

      • Ribbon Organization
      • Function Grouping
      • Multiple Function Access
      • The Document Window
      • Basic Navigation
      • Workbook Options

      Section C: Excel 2010 Shortcuts

      • Best Practice Guidelines
      • Common Hot Keys
      • Speed Keys
      • Function Keys
      • CTRL Keys
      • ALT Keys
      • Visible Speed Keys

      Section D: Creating and Manipulating Data

      • Entering Data
      • Auto Fill a Series
      • Creating Custom Lists
      • Fill Adjacent Cells
      • Fill Non-Adjacent Cells
      • Auto Fill on Multiple Sheets

      Section E: Managing Worksheets

      • Copying/Moving Worksheets
      • Renaming Worksheets
      • Inserting/Deleting Worksheets
      • Hiding Worksheets

      Section F: Data Validation

      • Range Criteria
      • List Criteria
      • Extending the List
      • Input Message
      • Validation Error Alerts
      • Validation by Character

      Section G: Modifying Cell Content

      • Copy/Paste Options
      • Paste
      • Inserting Columns
      • Transporting Data
      • Copy Cell Formatting
      • Removing Duplicates

      Section H: Changing Views

      • Zoom
      • Workbook Views
      • Page Layout
      • Freeze Panes
      • Split Windows
      • Viewing Multiple Windows

      Week of July 15, 2013 Session 2


      Section A: Formatting Data

      • Formatting Worksheets
      • Cell/Font Color
      • Background Images
      • Watermarks
      • Worksheet Tab Color

      Section B: Formatting Numbers

      • Modifying Cell Formats
      • Format Painter
      • Date Formatting
      • Formatting Multiple Cells
      • Numerical Cell Values
      • Special Formats

      Section C: Formatting Text and Tables

      • Formatting Fonts / Fills
      • Cell Height/Width
      • Noncompatible Commands
      • Cell Alignment
      • Inserting Comments
      • Merge and Center
      • Tables

      Section D: Understanding Formulas

      • Operations
      • Arithmetic Operations
      • Additional Operation Symbols
      • SUM Function
      • Ranges in Functions
      • AutoSum
      • Average
      • Min/Max Functions
      • Count Formula
      • AutoCalculate
      • Modifying AutoCalculate
      • Copying Formulas
      • Cell Multiplication
      • Relative Cell References
      • Absolute Cell References

      Week of July 22, 2013 Session 3


      Section A: Referencing Formulas

      • Totaling Multiple Sheets
      • AutoFit Multiple Cells
      • Linked Formulas
      • Grand Totals
      • Sparkline Graphics
      • Sparkline Colors
      • Consolidation
      • Consolidating Data
      • Linking to Source Data
      • Hierarchical Outline
      • Consistency

      Section B: Ranges and Dates

      • Naming Ranges
      • Adding Named Ranges
      • Dates
      • Date Speed Keys
      • Formula Calculations
      • Formula Auditing
      • The Watch Window
      • Formula Evaluation

      Section C: Subtotals

      • Using Subtotals
      • Subtotal Options
      • Using Data Hierarchy
      • Selecting Visible Data

      Section D: Using VLOOKUP

      • VLOOKUP
      • VLOOKUP Type I
      • VLOOKUP's Three Arguments
      • VLOOKUP Type I Methodology
      • VLOOKUP Type II

      Section E: Using Nested Formulas

      • Nested Formulas
      • Absolute Numbers
      • Nested Absolutes
      • Nested Formula Logic
      • FIND
      • INDIRECT
      • ROW/COL

      Section F: Conditional Logic

      • The IF Formula
      • The IF Statement
      • Nested IF
      • Nested IF Syntax

      Section G: More Conditional Logic

      • Insert Wizard
      • AND
      • OR
      • NOT
      • IFERROR
      • SUMIF / AVERAGEIF / COUNTIF
      • SUMIFS
      • AVERAGEIFS
      • COUNTIFS

      Week of July 29, 2013 Session 4


      Section A: Financial Formulas

      • Working with Financial Formulas
      • Future Value Function
      • Function Categories
      • Calculating Interest Rate
      • Calculating Total Payment
      • Calculating Monthly Payment
      • Using Goal Seek

      Section B: What-If Functions

      • Solver Add-in
      • Using Solver
      • Constraints
      • Reports
      • Comparing Options
      • Scenario Manager
      • Scenario Report
      • Data Tables
      • Applying Data Tables
      • Comparing Data Tables

      Section C: Working with Text Formulas

      • Concatenate
      • Text to Columns
      • Extraction Formulas
      • Combining with Previous Formulas
      • UPPER/LOWER/PROPER
      • Converting Formulas with Function Keys

      Section D: Paste Special

      • Pasting Values
      • Pasting Formats
      • Quick Multiplication
      • Addition
      • TRIM
      • Substitute

      Section E: Introduction to Charts

      • Charts
      • Chart Types
      • Instant Chart
      • Updating Charts
      • Add Secondary Y/Value Axis
      • Adding Data Labels
      • Fill
      • Picture Fill
      • Line/Scatter Charts

      Section F: Formatting Charts

      • Chart Styles
      • 3-D Charts
      • Quick Layouts
      • Formatting Chart Labels
      • Layout
      • Chart Title
      • Legends

      Section G: Conditional Formatting

      • Conditional Formatting Options
      • Selecting Cells to Format
      • Top/Bottom Rules
      • Data Bars/Color Scales/Icon Sets
      • Managing Rules
      • Wildcards
      • Alternative Row Shading via Formulas

      Section H: Adding Graphics to Spreadsheets

      • Inserting Pictures
      • Modifying Pictures
      • Inserting Shapes
      • Inserting SmartArt
      • Modifying SmartArt
      • Themes

      Week of August 5, 2013 Session 5


      Section A: Outlining, Sorting, and Filtering

      • Grouping
      • Ungrouping
      • Sorting Data
      • Sorting Levels
      • Filtering Data
      • Selecting Filtered Rows
      • Advanced Filtering

      Section B: PivotTables and PivotCharts

      • PivotTables
      • Creating PivotTables
      • PivotTable Layout
      • Defaults
      • Updating/Modifying Data
      • Calculated Fields
      • Calculated Items
      • Filtering PivotTables
      • Slicer
      • PivotCharts

      Section C: Protecting Data

      • Locking Cells
      • Protect Workbook
      • Hiding Cells
      • Hiding Worksheets

      Section D: Introduction to Backstage

      • Document Properties
      • Titles/Tags/Categories
      • Related Dates / People
      • Formatting Comments
      • Document Inspector
      • Sparklines/Slicer
      • Compatibility Checker
      • Document Inspection

      Section E: Collaboration

      • Sharing Documents
      • Sharing Workbooks
      • Protecting Shared Workbooks
      • Tracking Changes
      • Accept/Reject Changes
      • Information Rights Management
      • Document Signature
      • Mark as Final

      Section F: Saving Workbooks

      • Save as Previous Version
      • File Sharing with Previous Excel Version
      • Customization/Compatibility
      • Excel Options
      • Templates
      • Opening/Deleting Templates
      • Save as a Web Page
      • Single File Web Page

      Section G: Printing Workbooks

      • Page Orientation
      • Margins
      • Print Area/Page Breaks
      • Page Sailing
      • Headers/Footers
      • Row/Column Headings
      • Other Print Options

      Section H: Macros with VB for Applications

      • Macros
      • Recordable Macros
      • Non-Recordable Macros
      • Creating a Macro
      • Naming Macros
      • Shortcut Keys
      • Storage Options
      • Recording a Macro
      • Testing Macros
      • Editing Macros with Visual Basic
      • Testing Edited Macros
      • Relative Reference Macros
      • Assigning Buttons to Macros
      • Modifying Button Icons
      • Macro-Enabled Workbooks
      • Save Workspace