High School Course Outline

 

COURSE OUTLINE Computer Applications II
DEPARTMENT Business
LENGTH OF COURSE Semester
CREDITS 5
MAXIMUM CREDITS ALLOWED 5
AVAILABLE TO STUDENTS AT GRADE 9,10, 11, 12
REQUIRED OR ELECTIVE Elective
PREREQUISITES Computer Applications I or teacher approval

BRIEF OVERVIEW OF COURSE

This course continues to develop the basic computer competencies that include, but are not limited to, word processing, database, spreadsheet, Internet/email, desktop publishing and presentation skills. There is an emphasis on advanced concepts and integration between word processing, spreadsheets, and database applications and presentations.

GOALS

The National Information Technology Standards for Business Education will be taught in this course. The standards are listed below:

Achievement Standard: Gather, evaluate, use, and cite information from information technology sources.
Achievement Standard: Use input technologies appropriately to enter and manipulate text and data.
Achievement Standard: Design and implement risk management policies and procedures for information technology.
Achievement Standard: Use, plan, develop, and maintain database management systems.
Achievement Standard: Use, evaluate, and deploy communications and networking applications.

METHOD OF INSTRUCTION

METHODS OF EVALUATION

TEXTBOOK

Microsoft Access - 1st Quarter

Access Basics Manipulating Data Creating and Modifying Forms
  • Data Base Basics
  • Starting Access
  • Opening an Existing Database
  • Creating a Database
  • Editing Records
  • Changing Datasheet Layout (raw height, column, width, freezing columns, changing field)
  • Creating forms (e.g. columnar, tabular)
  • Modifying Forms (adding color, moving fields)
  • Compacting and Repairing a Database
Finding and Ordering Data Reports and Macros Integrating Access
  • Find
  • Queries
  • Indexing
  • Sorting
  • Creating Multi-Table Query
  • Setting a Primary Key
  • Setting Up Basic Relationships
  • Creating Reports and Modifying Reports
  • Grouping and Sorting the Report
  • Layout and Orientation
  • Macros
  • Integrate Access w/other Office Applications
  • Create a Form Letter
  • Use the Query options to Print Selected
  • Form Letters
  • Create and Print Mailing Labels
Modifying Table Design Relationship in Tables and Queries Advanced  Features
  • Input Masks
  • Validation Rules
  • Request Properties
  • Creating Lookup Fields
  • Defining
  • Understanding Table Relationships
  • Setting/Removing Tables Queries
  • Create a Subform
  • Adding a Record in the Subform
  • Modifying a Subform
  • Modifying a form in Design View
Analyzing Data Importing/Exporting Data  
  • Using Queries to Calculate Data
  • Building Summary Queries
  • Creating an AND Query
  • Creating an OR Query
  • Applying Filters to a Query
  • Importing/Exporting Data to/from Other Applications
 

Microsoft PowerPoint- 2nd Quarter

Office 2000 Basics and the Internet Enhancing a PowerPoint Presentation Working with Visual Elements
  • Intro to Office 2000
  • Office 2000 Help
  • Accessing the Internet
  • Starting, Opening, Saving, Printing & Navigation Through a Presentation
  • Applying Design Templates, Clip Art, Adding Slides
  • Presenting, Changing Views & Layout of a Presentation
  • Creating a Presentation
  • Using Slide Master, Slide Transitions
  • Inserting Animation, Utilizing slide Layouts, Working in Outline View
  • Organization Charts
  • Working with Charts, Tables, and Creating Shapes & Objects
  • Manipulating Objects and Creating Text Boxes

Expanding on the Basics of PowerPoint

Using Advanced Text Features

Working with Visual & Sound Objects

  • Formatting Text and Objects and Delivering a Presentation
  • Sending Presentations via Email
  • Creating Output & Inserting a Hyperlink
  • Integrating PowerPoint and Word
  • Publishing a Presentation to the Web
  • Creating and Modifying a Macro
  • Creating Summary
  • Creating Tables & Charts
  • Integration-Inserting Worksheet Data on a Slide
  • Working with Data and Organization Charts
  • Inserting Pictures & Scanned Images
  • Inserting Sound Objects & Inserting Movie Clips

Customizing Options

Importing & Exporting Information

Using Advanced Presentation Features

  • Customizing Color Schemes & Slide
  • Backgrounds
  • Creating Custom Shows, Custom Web Pages
  • Customizing Toolbars
  • Importing Slides From Another Presentation
  • Integration: Sharing Data Among Office2000
  • Applications
  • Changing Output Options
  • Before & During the Presentation

Final Project-

  • Students Create a PowerPoint Presentation Using all Elements Learned: Videos, Music, Slide Transition, Custom Animation and Automatic Timing