Mr. Dietrick's Website
Microsoft Office
Microsoft Office
Course Description
Using TestOut online videos, fact sheets, and simulations, this course will provide students with the knowledge required to create documents using Microsoft Word 2016, spreadsheets and databases using Microsoft Excel 2016 and Microsoft Access 2016, and multimedia presentations using Microsoft PowerPoint 2016. Students will also develop fundamental computer operation skills.
Course Syllabus Packet
The course syllabus and classroom rules & procedures can be viewed online or downloaded below using Adobe Acrobat:
- Syllabus (.pdf)
- Classroom Rules & Procedures (.pdf)
Course Layout
Students are set up to learn Microsoft Word and Microsoft PowerPoint during the 1st quarter of the course and Microsoft Excel and Microsoft Access in the 2nd quarter of the course using TestOut online lessons and simulations. Once a TestOut account is provided, students can access their course content on any COMPUTER attached to the internet. System requirements for using TestOut software on computers outside of classroom can be found here. At the end of the semester there will be a comprehensive exam that covers all 4 pieces of Microsoft Office covered.
Common Office Features
- Getting Started with Office
- Customizing Views and Options
- Printing Files
- Navigating Files
- Working with Objects
Microsoft Word
- Introduction to Word
- Creating Documents and Using the Clipboard
- Modifying Fonts
- Formatting Paragraphs
- Formatting Pages
- Editing Documents
- Inserting Illustrations and Other Elements
- Creating and Formatting Tables
- Using Themes Styles and Templates
- Managing References
- Managing Headers, Footers, and Sections
- Using Office Collaboration Features
Microsoft PowerPoint
- Introduction to PowerPoint
- Creating and Managing Presentations
- Formatting Textual Content
- Designing Slides
- Using the Slide Master
- Formatting SmartArt and Shapes
- Formatting Tables and Charts
- Formatting Pictures and Other Media
- Applying Animations and Transitions
- Delivering Presentations
Microsoft Excel
- Introduction to Excel
- Creating and Managing Workbooks
- Organizing and Entering Data
- Changing Properties and Printing Worksheets
- Formatting Cells
- Entering Simple Formulas
- Using Advanced Functions
- Displaying Data in Charts
- Organizing Data in Tables
Microsoft Access
Mr. John Dietrick | Emmaus High School | 500 Macungie Ave. | Emmaus, PA 18049 |
(610) 965-1650 ext. 21375 | jdietrick@eastpennsd.org| https://sites.google.com/eastpennsd.org/mrdietrick