microsoft office

Microsoft Office

Microsoft Office semester-long Class using these posts, links, and documents.

COURSE DESCRIPTION:

Let’s learn about Microsoft Office Suite (Primarily Excel, Word, and PowerPoint). Students will need a laptop with Excel, Word, and PowerPoint, ALREADY installed. MS Suite 2016 or Office 365. They will also need a thumb drive so files can be transferred to and from the teacher.

The goal of this class will be to learn how to learn the major functions in MS Office while creating fun projects. This class is appropriate for Middle and High School Students.

SUGGESTED MATERIALS:

  • PC with MS Suite 2016 or Office 365
  • Thumb drive
  • Notebook paper
  • Pencils
  • 1” binder

MICROSOFT OFFICE CLASS – Table of Contents

  1. WEEK 1 EXCEL  —  Financial Spreadsheet – Savings Account
    1. Microsoft Office Objectives for class.
    2. Video on the History of Excel.                  li>
    3. Show or Pass out
      1. Excel Vocab Quizlet,
      2. Complete Functions List,
      3. and a super beginner’s handbook to Excel, 
      4. Intro to toolbar/keyboard shortcuts.
    4. Typing Speed Game.
    5. First Excel project: this site.  Product students will create: Excel Savings Activities.
  2. WEEK 2 EXCEL  —  Financial Spreadsheet – Savings Account
    1. Typing Speed Game
    2. Continue with Savings Activity in Excel.
    3. If finish Savings, begin Checking Activity in Excel from this site. Product students will create:
  3. WEEK 3 EXCEL  —  Financial Spreadsheet – Checking Account
    1. Typing Speed Game
    2. Continue with Savings or Checking Activity in Excel.
    3. Why do I care about “credit”?
  4. WEEK 4 EXCEL  
    1. Typing Speed Game
    2. Continue with Checking Activity in Excel.
    3. As we are finishing the Checking Activity, hand out two new activities the students can begin working on.
      1. Christmas Budget Template Chart
      2. My  Dream Car Excel Assignment
  5. WEEK 5 EXCEL – FUNCTIONS
    1. Share diagram of vocabulary 
    2. Typing Speed Game
    3. Finish up at home:
      1. Excel Savings Activities
      2. Checking Activity
      3. Christmas Budget Template Chart
      4. My Dream Car
    4. This week we’ll create our very own Dice Rolling Program Working!
  6. WEEK 6 EXCEL — MACROS (Excel Macro)
    1. Typing Speed Game
    2. Let’s play Kahoot!
      1. Microsoft Excel
      2. Microsoft Excel
      3. Microsoft Excel
    3. Work on Dice Rolling Program.
      1. Add button, record macro, and insert macro into button that will roll the dice.
      2. Protect workbook from accidentally erasing functions.
      3. View Caleb’s 15 sided dice.
      4. Keep working on functions.
  7. WEEK 7 WORD —  MACROS (Word Macro)
    1. Typing Speed Game
    2. Check assignments for Grades.
    3. Let’s play Kahoot!
      1. Microsoft Excel
      2. Microsoft Word
    4. Download the first two files here:
      1. Chef Daniels Cookbook
  8. WEEK 8 WORD —  Macros, Word
    1. Typing Speed Game
    2. Check assignments for Grades.
    3. Work on anything you need to complete.
    4. After completing the last file, download and create your Newsletter.
      1. Microsoft Word – Holiday Newsletter
  9. WEEK 9 WORD —  Word 
    1. Typing Speed Game
    2. Check assignments for Grades.
    3. Work on anything you need to complete:
      1. See above links.
      2. Next week we start PowerPoint.
  10. WEEK 10 POWERPOINT —  Jeopardy Game
    1. Typing Speed Game
    2. Check assignments for Grades.
    3. Let’s start making Jeopardy!!!
  11. WEEK 11 POWERPOINT —  Jeopardy Game
    1. Typing Speed Game
    2. Check assignments for Grades.
    3. Let’s continue making Jeopardy!!!
  12. WEEK 12 POWERPOINT —  Jeopardy Game
    1. Typing Speed Game
    2. Check assignments for Grades.
    3. Let’s share and play Jeopardy!!! See links below.
    4. Finish working on your Jeopardy games!
  13. WEEK 13 OUTLOOK    —  Email Etiquette
    1. Open Outlook and talk about Email Etiquette
      1. https://www.lifewire.com/fundamental-email-etiquette-1171187 
      2. https://www.businessinsider.com/email-etiquette-rules-every-professional-needs-to-know-2016-1#5-use-professional-salutations-5
      3. https://www.thebalancecareers.com/email-etiquette-525535
    2. Some tips for using MS Outlook
      1.  
      2. 12 Tips to working faster with Outlook. 
  14. WEEK 14 CLOSING
    1. Play Caleb M’s Jeopardy
    2. Interview two professionals who work in the field of computer programming.