Computer Applications
CC.HS.V1ComputerApps.Bnet4copy
In this course, students will develop and master the basics of the suite components--Word, Excel, Access, PowerPoint, Outlook, and Publisher using Microsoft Office 2003. The course guides learners through a developmental phase, where small learning blocks (called Step-by-Steps) will guide students through practice activities. At the end of each lesson, mini projects are used to demonstrate skills developed in each lesson. At the end of each unit, capstone simulations and/or comprehensive projects are used to demonstrate mastery of skills. Pretests, study guides, quizzes, and objective tests are periodically available for self-analysis, review, and reinforcement of terminologies and concepts.
Enduring Understanding
The student will understand:
- How to develop and master the basics of the suite components--Word, Excel, Access, PowerPoint, Outlook, and Publisher.
- How to apply skills in computer application tools to solve real life problems.
Essential Questions
- What is copyright and how does it affect me?
- Why am I learning Microsoft Office applications?
- What are some helpful features of Microsoft Word?
- How can you integrate spreadsheet skills to create a professional looking document?
- How can a database be integrated with Microsoft Word?
- What are some basic rules of design when using PowerPoint?
- How can you use Publisher to enhance documents?
Additional Resources Needed
Textbooks
Microsoft Office 2003 Introductory Course
By: Pasewark and Pasewark
Publisher: Thomson Course Technology
Student Edition – ISBN: 0619-18339X
Teacher Edition – ISBN: 0619-183411
Optional Resources:
Instructor Resources – ISBN: 0619-183438
Activity Workbook – ISBN: 0619-18342X
Technology Needs:
Microsoft Office 2003 Suite
Microsoft Word (word processing software)
Microsoft Excel (spreadsheet software)
Microsoft Access (database software)
Microsoft PowerPoint (automated presentation software)
Microsoft Publisher (desktop publishing software)
Content Topics
Unit 1
Introduction to Computer Legal / Ethical Issues and Microsoft Office Suite 2003
Unit 2
Word Processing and Microsoft Word
Unit 3
Introduction to Microsoft Excel
Unit 4
Introduction to Microsoft Access
Unit 5
Introduction to Microsoft PowerPoint
Unit 6
Microsoft Publisher
Key Skills
- Basic graphic design
- Creating objects
- Formating
- Keyboarding
- Layout skills
Assessments
- Chapter Review Questions
- Mini Projects
- Quizzes
- Pretests
- Chapter Tests
- Unit Tests
- Simulation Projects
Standards Alignment:
PA State Standards:
Academic Standards--PA and National Business Education
The following Pennsylvania State Standards are addressed in this Computer Applications course:
PA Academic Standards Science and Technology: 5-7
Students will be able to apply intermediate skills in utilizing word processing, database, and spreadsheet software. 3.7.7.D.5
Students will be able to demonstrate a basic knowledge of desktop publishing applications. 3.7.7.D.4
Students will be able to apply basic graphic manipulation techniques. 3.7.7.D.6
PA Academic Standards Science and Technology: 8-10
Students will be able to apply advanced word processing, database, and spreadsheet skills. 3.7.10.D.4
Students will be able to describe and demonstrate how two or more software applications can be used to produce an output. 3.7.10.D.5
Students will be able to apply advanced graphic manipulation and desktop publishing techniques. 3.7.10.D.2
National Standards:
The following National Business Education Standards for Information Technology are also addressed in this course:
I. Impact on Society
Achievement Standard: Assess the impact of information technology on society
IV. Information Technology and Major Business Functions
Achievement Standard: Describe the information technology components of major business functions and explain their interrelationships
VI. Input Technologies
Achievement Standard: Use input technologies appropriately to enter and manipulate text and data
VII. Information Retrieval
Achievement Standard: Gather, evaluate, use, and cite information from information technology sources
VIII. Database Management Systems
Achievement Standard: Use, plan, develop, and maintain database management systems
XVI. Privacy and Ethics
Achievement Standard: Describe, analyze, develop, and follow policies for managing privacy and ethical issues in organizations and in a technology-based society