Curriculum: Business

Advanced Word Processing

2006-2007 School Year

August 02, 2006

Advanced Computer Applications

Mrs. Sue Sydow, Instructor
ssydow@esu2.org
Full Year Course
Required Course—Prerequisite Word Processing/Computer Applications
Grade Level 9, 10, 11, 12

Course Description
This course is designed to include intermediate to advanced skills in the areas of word processing, database management, spreadsheet, electronic presentation, Internet, electronic communication, graphics, desktop publishing and basic web design. Emerging input technologies will be used to develop handwriting recognition and speech recognition skills. Students are offered opportunities to identify ethical issues pertaining to information systems and to gather information about careers in technology.

Upon completion of this course, students will possess the skills necessary to successfully pass the MOS certification Core Exams in Word and Excel and University of Nebraska pretests. Students will use Microsoft Office 2003 professional and Windows XP, along with Internet software.

*Students are responsible for expenses associated with MOS exams.

Course Objectives
1. Utilize a variety of application software including word processing, spreadsheet, database, communications, multimedia, and desktop publishing and the intermediate and advanced application features of this software.
2. Use emerging application software (scanners, digital cameras, voice-activated applications, wireless devices).
3. Demonstrate skills for communicating in an international, pluralistic business environment.
4. Understand the content of technical reading material by following directions or accurately interpreting data.
5. Use application reference materials (online help, vendor sites, tutorials, manuals) to complete tasks or solve problems.
6. Use problem-solving techniques to diagnose, evaluate and identify the use of software to solve specific problems.
7.  Follow safety and security policies (acceptable use policy, web page policy, student information policy).
8.  Understand federal and state laws pertaining to computer use (computer crime and abuse, copyright infringement, plagiarism).
9.  Discuss common tasks, career paths and educational requirements in the areas of word processing, spreadsheet, database, desktop publishing, presentation and electronic communication.

Units of Study

*Essential Digital Pen Handwriting Recognition Skills

*Speech Recognition Skills

Unit 1—Word 2003: Advanced Business Communication
--Lesson 1—Formatting Content
-----Create and Apply Custom Styles for Texts and Lists
-----Create Custom Styles for Tables
-----Insert Line Breaks
-----Resize and Scale Graphics
-----Wrap Text with Graphics
-----Rotate and Crop Graphics
-----Control Image Contrast and Brightness
-----Insert and Modify New Objects
-----Create and Revise Charts Using Data From Other Sources
-----Insert Objects from Files
--Lesson 2—Organizing Content
-----Sort Information in Lists
-----Sort Information in Tables
-----Use Formulas in Tables
-----Split and Merge Cells
-----Modify Text Position and Direction in a Cell
-----Modify Table Properties
-----Insert and Modify Fields
-----Use Thumbnails and Document Map
-----Use Thumbnails and Document Map for Document Navigation
-----Insert Bookmarks
-----Use Readability Statistics
-----Use AutoSummarize
-----Complete a Mail Merge for Letters
-----Complete a Mail Merge for Labels
-----Add XML Schemas to a Word Document
-----Create an XML File from a Word Document
-----Modify Elements and Set XML Options
-----Create a Template Using XML
--Lesson 3—Formatting Documents
-----Create and Modify Forms
-----Change Text and Check Box Form Fields Options
-----Add and Modify Background Colors and Fill Effects
-----Apply Themes
-----Add Watermarks
-----Insert Captions and Format Caption Numbering
-----Insert and Modify Cross-References
-----Create and Modify a Table of Contents
-----Create and Modify a Table of Figures
-----Create and Modify a Table of Authorities
-----Create and Modify an Index
-----Insert and Format Footnotes
-----Insert and Format Endnotes
--Lesson 4—Collaborating with Others
-----Change Reviewer’s Ink Colors
-----Change Balloon Options
-----Show and Hide Reviewers
-----Save Versions of a Document
-----Open and Delete versions of a Document
-----Set Formatting and Editing Restrictions
-----Apply a Password to a Document
-----Apply a Password to a Form
-----Insert and Edit Summary Information and Custom File Properties
-----Use a Digital Signature to Authenticate a Document
-----Change Web Options and Save as a Web Page
-----Insert and Modify Frame
-----Create a Master Document with Subdocuments
--Lesson 5—Customizing Word
-----Create and Run a Macro
-----Edit a Macro Using the Visual Basic Editor
-----Create a Custom Menu
-----Add and Remove Buttons from a Toolbar
-----Change the default File Location for Templates
-----Set the Default Dictionary
-----Modify the Default Font Settings
Unit 2—Excel 2003: Advanced Business Finances
--Lesson 1—Organizing and Analyzing Data
-----Create a List and List Range
-----Use Advanced Filters
-----Create PivotTable and PivotChart Reports
-----Create Subtotals
-----Group and Outline Data
-----Use Cell Watch
-----Apply Data Validation Criteria
-----Circle Invalid Data
-----Trace Formula Precedents
-----Trace Formula Dependents
-----Trace Formula Errors
-----Use Error Checking
-----Use Evaluate Formula
-----Name a Cell Range
-----Use a Name in a Formula
-----Use a Name in a Formula
-----Use scenarios
-----Perform a What-If Analysis
-----Edit and Summarize Scenarios
-----Use the Solver Add-in
-----Use Database functions
-----Use the Analysis ToolPak
-----Use Lookup and Reference Functions
---Lesson 2—Formatting Data and Content
-----Create a Custom Number Format
-----Apply a Custom Number Format
-----Use Conditional Formatting
-----Control Brightness of a Graphic
-----Control Contrast of a Graphic
-----Resize a Graphic
-----Scale a Graphic
-----Crop a Picture
-----Rotate a Graphic
-----Apply Formats to Charts and Diagrams
--Lesson 3—Collaborating
-----Add Protection to Cells, Worksheets, and Workbooks
-----Set a Password to Open a Workbook
-----Set a Password to Modify a Workbook
-----Create a Shared Workbook
-----Use Track Changes
-----Accept and Reject Changes
-----Merge Workbooks
-----Change Macro Setting
-----Use Digital Signatures to Authenticate Workbooks
--Lesson 4—Managing Data and Workbooks
-----Import Data to Excel
-----Link to Web Page Data
-----Export Data from excel
-----Publish Web-Based Worksheets
-----Create a Workbook Template
-----Edit a Workbook Template
-----Create a Workbook Based on a Template
-----Consolidate Data from Two or More worksheets
-----Modify Workbook Properties
-----Add, Modify, and Delete Maps
-----Manage Elements and Attributes in XML Workbooks
-----Refresh XML Data and Define XML Options
--Lesson 5—Customizing Excel
-----Create a Macro
-----Edit a Macro Using the Visual Basic Editor
-----Run a Macro
-----Add and Remove Buttons from Toolbars
-----Add a Custom Menu
-----Modify Default Font Settings
-----Set the Default Number of Worksheets
-----Change the Default Location
Unit 3—Outlook 2003: Time and Resource Management
--Lesson 1—Communicating with Others
-----The Outlook Screen
-----Compose a New Message
-----Save an E-mail
-----Insert an Attachment
-----Set Message Options
-----Preview, Print, and Send a Message
-----Create and Modify a Signature
-----Create Multiple Signatures
-----Reply to a Message
-----Forward a Message
-----Use the Message Flag
-----Create a Contact
-----Update Contact Information
-----Send Messages Using Contacts
-----Choose Message Format
-----Review Instant Messenger
--Lesson 2—Scheduling
-----Explore Calendar Views
-----Add an Appointment to the Calendar
-----Schedule an Event
-----Schedule Meetings and Invite Attendees
-----Schedule Resources for Meetings
-----Update and Cancel Meeting Requests
-----Accept and Decline a Meeting Request
-----Propose a New Meeting Time
-----Set Calendar Options
-----Set Work Days and Times
-----Create and Modify Tasks
-----Assign Tasks
-----Accept, Decline, and Delegate Tasks
--Lesson 3—Organizing
-----Create and Modify a Distribution List
-----Track Activities for a Contact
-----Create and Modify Notes
-----Add and Remove Fields
-----Sort Items
-----Organize Items Using Colors and Views
-----Filter Messages
-----Use Rules
-----Create and Delete Folders
-----Move Items Between Folders
-----Archive Items
-----Find Items
-----Assign Items to Categories
-----Use Search Folders
-----Save Items in Different File Formats
Unit 4—Integrating Applications
--Lesson 1—Word and Excel Integration
-----Link Data
-----Update Linked Data
-----Link an Excel Chart to a Word Document
-----Embed an Object
-----Edit an Embedded Worksheet
-----Change a Linked Object’s Source
-----Import an Access table into Word
-----Import an Access Query into Word
--Lesson 2—Access Integration
-----Insert Hyperlinks
-----Link Data to a New Table
-----Edit Linked Data
-----Export XML Data
-----Import XML Data
--Lesson 3 PowerPoint Integration
-----Link an Excel Chart with a PowerPoint Presentation and a Word Document
-----Edit a Linked Object
-----Embed and Edit a Word Table in a Slide
-----Copy and Paste an Access Query into a Presentation
Unit 5—Access: Database Management

Textbook—Publisher
Microsoft Office 2003, Real World Applications, C. Jacqueline Schultz and Linda Wooldridge, Glencoe/McGraw-Hill, Woodland Hills, CA, Copyright 2006.

Dragon Naturally Speaking for the Office Professional, Continuous Speech Recognition Applications, Karl Barksdale and Michael Rutter, South-Western Educational Publishing Company, Copyright 2003. ISBN 0-759-33115-4, Version 7.

The Nifty Fifty Basic Training Manual for Dragon NaturallySpeaking 7.0, Speaking Solutions, Inc., Copyright 2003, www.speakingsolutions.com.

Resources
Textbooks, computer software (Windows XP Professional, Office 2003 Professional, DragonNaturally Speaking 7.3), Internet software, browsers, and various software guidebooks.

Instructional Strategies
Lecture, demonstration, cooperative learning, keyboarding “hands-on” skill development, computer application practice, skill-building emphasis, communication emphasis, web based assignments, Internet utilization, review and assessment.

Multi-Cultural Concepts or Activities

• Key materials relating to the diversity of the American workplace.

• Key and search the Internet for topics on workplace diversity.

Standards for Assessment
Students’ daily work will be graded on accuracy and productivity standards—both quality (errors) and quantity (amount of work completed). Points will be assigned and averaged.

Objective tests and quizzes will be graded as a percentage grade of the total points on the test.

Production tests will be graded on mailability and productivity standards, and points will be assigned and averaged.

Student Assessment Plan
Subject to change, depending upon units covered:

Daily work—40%
Includes chapter questions, daily computer printouts of
activities, terms, discussions, etc.
Tests 40%
Quizzes 20%