Computer Applications I & II

Grant County High School

Mr. Michael Mayer, Instructor

michael.mayer@k12.nd.us

Smoother Computer

Computer Applications

The textbook we will be using is Microsoft Office 2010 and Advanced.

The objectives will be:

1. To offer and introduction to Microsoft Windows 7, Microsoft Word 2010, Microsoft Excel 2010, Microsoft Access 2010, Microsoft PowerPoint 2010, and Microsoft Outlook 2010.
2. To go beyond the fundaments and offer an in-depth presentation to Microsoft Word 2010, Microsoft PowerPoint 2010, Microsoft Excel 2010, Microsoft Access 2010, and Microsoft Outlook 2010.
3. To expose students to practical examples of the computer as a useful tool.
4. To acquaint students with the proper procedures to create documents, worksheets, databases, and presentations suitable for coursework, professional purposes, and personal use.
5. To help students discover the underlying functionality of Office 2010 so they can become more productive.
6. To develop an exercise-oriented approach that allows learning by doing.

Class Expectations

A business atmosphere will provide the work environment for this class. Following lecture and guided demonstrations, students will work independently in class to complete work. Students will abide by the rules in the student handbook along with the class rules.

Grading

Grading will be based off total points.

Course Topics

Word 2010

Chapters:

1. Creating, Formatting, and Editing a Word Document with Pictures
2. Creating a Research Paper with Citations and References
3. Creating a Business Letter with a Letterhead and Table
4. Creating a Document with a Title Page, Lists, Tables, and Watermark
5. Using a Template to Create a Resume and Sharing a Finished Document
6. Generating Form Letters, Mailing Labels, and a Directory
7. Creating a Newsletter with a Pull-Quote and Graphics

PowerPoint 2010

Chapters:

1. Creating and Editing a Presentation with Clip Art
2. Enhancing a Presentation with Pictures, Shapes, and WordArt
3. Reusing a Presentation and Adding Media
4. Working with information Graphics
5. Collaborating on and Delivering a Presentation
6. Navigating Presentations Using Hyperlinks and Action Buttons
7. Creating a Self-Running Presentation Containing Animation

Excel 2010

Chapters:

1. Creating a Worksheet and an Embedded Chart
2. Formulas, Functions, and Formatting
3. What-If Analysis, Charting, and Working with Large Worksheets
4. Financial Functions, Data Tables, and Amortization Schedules
5. Creating, Sorting, and Querying a Table
6. Working with Multiple Worksheets and Workbooks
7. Creating Templates, Importing Data, and Working with SmartArt, Images, and Screen Shots

Access 2010

Chapters:

1. Databases and Database Objects: An Introduction
2. Querying a Database
3. Maintaining a Database
4. Creating Reports and Forms
5. Multitable Forms
6. Advanced Report Techniques
7. Using SQL

Outlook 2010

Chapters:

1. Managing E-Mail Messages with Outlook
2. Managing Calenders
3. Managing Contacts and Personal Contact Information with Outlook