Workshops‎ > ‎Workshop Archive‎ > ‎

MS Office 2010 Summer

Click HERE for the MAC (Office 2011) Version of this workshop


Agenda

1.  Engage Prior Knowledge / Goal Setting

  • Work on the Anticipation Guide
  • Begin installing Office 2010 on SWSD laptop



  • Layout of this site - Table of contents -------->
  • Resources Section below is where to go for help
  • Bookmark this page!
  • Use Breadcrumbs on top of this site to jump around between pages.

    easy   med    hard

  • Complete the sign in sheet!

2.  Introduction to Office 2010 - Discussion and Demos


  • Must be installed by Fall 2010 school Year
    • Yourself: SWSD Computers - Software Installers Page found in the App Launcher
    • Work Order:  Techs will make arrangements to install for you 
    • Home - $9.95 Directions attached below.
    • Tech Dept installing on all labs, netbooks, laptop carts, etc. over summer

  • New file extensions: Added an "x"        What is a File Extension?
    • .docx  - Word
    • .pptx - PowerPoint
    • .xlsx - Excel

      TIP:  When searching for or opening files from within software:  Notice the File Type at bottom - its acting like a filter!      or use My Computer to find files, not from within program.

  • Ribbon interface
    • Tabs
    • Groups
    • Commands
    • Dialog Box Launchers

    • Quick Launch Toolbar - add "New", "Close", "Open" and "Print Preview"

  • New Features
Break & Work Time

  • Word

    • Formatting Effects
    • Smart Art Graphics
    • Screen shot tool
    • Reference & Citations Section
    • Customize the ribbon

    • TASK:  Word 1:  Find and View Resources for Word 2010.    Observe Ribbons, Groups, Commands and Dialog Box Launchers.  Highlight and use the in text menus.  Live Previews.  Worksheet that runs to two pages - Adjust Margins so it fits on one page.  See how to print two sided - if supported by printer. Customize a Ribbon.

    • TASK:  Word 2:  Mail Merges

    • TASK:  Word 3:  Microsoft "5-Minute Make Overs" where they show you how to use features of Office 2010 to improve some existing docs.  I have provided the templates for you - can you make them look "better" the way Microsoft does?

    • TASK:  Word 4:  Reference Ribbon - add citations, table of contents, etc. to a sample research paper.

    • TASK:  Word 5:  Track Changes       TIP:  Google Docs a better way of doing this now?  Maybe great for feedback to students on an assignment doc!

    • OPTIONAL:  Microsoft Math add on
    • OPTIONAL:  Chemistry Add on
    • OPTIONAL:  Math Worksheet Generator
    • OPTIONAL:  Moodle Add in

Break & Work Time

  • PowerPoint

    • Slide Designs, Animations, 3D Transitions
    • Organize slides into sections
    • Access your past Autosave Revisions:  File | Info    Settings for this are in File | Options
    • Save as a movie:  File | Save As | Create a Video
    • Videos are now EMBEDDED by default when you insert them into your PowerPoint, not linked (works).  Linking is still an option (smaller file size).
    • Add Video Bookmarks
    • Multiple-mouse:  Learn More Here
    • Laser Pointer Mouse:  Control + left click  (During presentation)

    • TASK:  PowerPoint 1:  Microsoft "5-Minute Make Overs" where they show you how to use features of Office 2010 to improve some existing docs.  I have provided the templates for you - can you make them look "better" the way Microsoft does? 

    • TASK:  Complete some online PowerPoint training:  http://www.gcflearnfree.org/powerpoint2010  Look for challenges at end of each section!
    • TASK:  Learn the Do's and Don't of Great PowerPoints - funny.   Visit SlideFest website and watch a few Apple Keynotes - notice how effect Steve Jobs is as conveying information during his presentations using very clean, simple slides and simple messages:  iPhone Release  |  iPod Release 

Break & Work Time

  • Excel

    • More prebuilt, live chart themes and table styles
    • Improved Auto-Filtering Features - Search box 
    • Custom Sorts - Months for example
    • Headers stay on top of data as you scroll down in table
    • Awesome Conditional formatting!
    • View | Zoom to Selection   View | 100%
    • Printing Options
    • Trendlines & Sparklines
    • Graphs - much easier formatting with live previews
    • Easier to use Pivot Tables and new Slicers

    • TASK:  Complete some online Excel training.   Look for challenges at end of each section!
    • TASK:  Excel 1:  Microsoft "5-Minute Make Overs" where they show you how to use features of Office 2010 to improve some existing docs.  I have provided the templates for you - can you make them look "better" the way Microsoft does?  

Break & Work Time


3.  Resources  

Help
  • Press "F1" inside any Office product to get helpful directions

SWSD Web Sites

Step by Step Tutorials


Where to Find Sample Work Files
  • Many have been added to bottom of these Office Workshop Web pages 
  • Use a file in your G Drive

Where to find Student Data
  • Student Contact Info can be downloaded from Sapphire Gradebook
    • In Main Sapphire Gradebook --> Reports | Contact List Export

  • Item Analysis of Assessment can be downloaded in CSV or Excel format from Performance Tracker.
    • Reports tab |  Item Analysis - Assessment Scores report

  • School/Team/Grade Level student information can be exported to CSV or Excel by Guidance/Secretaries/Tech Coaches
    • Just send an email - very helpful for grade level leaders planning a field trip, or team captians


4. Play Time!

Play Ribbon Hero 1 and 2  - Learn!   OR view Demo videos
http://www.ribbonhero.com/









Ĉ
Bryan Tayman,
Jun 22, 2011, 10:08 AM
Ĉ
Bryan Tayman,
Jun 22, 2011, 10:08 AM
Ċ
Bryan Tayman,
Jun 21, 2011, 7:00 PM
ĉ
Bryan Tayman,
Jun 21, 2011, 9:47 PM
Ĉ
Bryan Tayman,
Jun 22, 2011, 10:08 AM
ĉ
Bryan Tayman,
Aug 24, 2011, 4:04 PM
ć
Bryan Tayman,
Jun 5, 2011, 3:01 PM
Comments