Course Overview

Course Overview

Software Applications III

Unit 1 Word Processor (Advanced Features) 12 hours

Goal 3: The student will demonstrate the ability to use the computer as a problem-solving tool in all appropriate subject areas.

Goal 5: The student will demonstrate the ability to use application programs.

Goal 6: The student will demonstrate the ability to access and store information.

Goal 7: The student will demonstrate the ability to apply computer science concepts.

Objective A. The student will perform formatting with Special Features including:

1.1 Using AutoText

1.2 Inserting a Nonbreaking Space

1.3 Affecting Text Flow

1.4 Adding Borders and Shading

1.5 Finding and Replacing Special Formatting and Characters

1.6 Creating Footnotes and Endnotes

1.7 Using Bookmarks

1.8 Creating a Cross-Reference

1.9 Formatting Pages in a Document

1.10 Creating and Balancing Columns.

Objective B. The student will merge documents, sort and select data by:

1.11 Creating a Data Source with Mail Merge Helper

1.12 Creating a Main Document

1.13 Merging Files

1.14 Viewing Merged Records in a Main Document

1.15 Editing the Data Source

1.16 Merging Envelopes

1.17 Merging Mailing Labels

1.18 Inputting Text During a Merge

1.19 Sorting Text

1.20 Sorting Records in a Data Source

1.21 Selecting Records.

Objective C. The student will work with shared documents by:

1.22 Tracking Changes to a Document

1.23 Inserting Comments

1.24 Sending and Routing Documents

1.25 Protecting Documents

1.26 Creating a Template

1.27 Creating Multiple versions of a document

1.28 Creating a Master Document and Subdocuments.

Objective D. The student will create specialized tables and indexes, such as:

1.29 A Table of Contents

1.30 An Index

1.31 A Table of Figures

1.32 A Table of Authorities.

Objective E. The student will perform formatting with macros and styles by:

1.33 Creating Macros

1.34 Running a Macro

1.35 Recording a Macro with fill-in Fields

1.36 Editing a Macro

1.37 Formatting with Styles.

Objective F. The student will create fill-in forms by:

1.38 Creating a Form

1.39 Filling in a Form Document

1.40 Printing a Form

1.41 Editing a Form Template

1.42 Customizing Form Field Options

1.43 Creating Tables in a Form Template.

Objective G. The student will integrate topic: add visual appeal to documents by:

1.44 Inserting and Customizing Clip Art Images

1.45 Aligning Graphic Elements

1.46 Adding Bitmapped Graphics

1.47 Performing Calculations in a Table

1.48 Importing, Modifying, and Creating Worksheets in a Table

1.49 Creating a Chart with Data in a Word Table

1.50 Importing Data Into a Chart.

Unit 2 Excel (Advanced Features) 14 hours

Goal 3: The student will demonstrate the ability to use the computer as a problem-solving tool in all appropriate subject areas.

Goal 5: The student will demonstrate the ability to use application programs.

Goal 6: The student will demonstrate the ability to access and store information.

Goal 7: The student will demonstrate the ability to apply computer science concepts. .

Objective A. The student will format Excel Worksheets using the following advanced formatting techniques:

2.1 Applying Number Formats

2.2 Creating Custom Formats

2.3 Formatting Large Labels

2.4 Automatically Adjusting Column Width and Row Heights

2.5 Creating, Applying, and Editing Styles

2.6 Using the Format Painter Button

2.7 Applying Borders and Shading

2.8 Turning Off Zeros

2.9 Using Off Zeros

2.10 Using AutoFormat

2.11 Using Conditional Formatting

2.12 Adjusting the Layout of a Worksheet

2.13 Using the Paste Special Command

2.14 Hiding and Unhiding Rows, Columns, and Sheets

2.15 Using the Page Break Preview Command

2.16 Changing Page Order

2.17 Renaming Sheets.

Objective B. The student will work with templates and workbooks by:

2.18 Using Excel Templates

2.19 Creating a New Template

2.20 Editing a Template

2.21 Automating Data Collection with a Built-In Template

2.22 Using Multiple Workbooks

2.23 Consolidating Data from Several Worksheets into a List

2.24 Linking Workbooks

2.25 Sharing Workbooks.

Objective C. The student will perform calculations using the following advanced functions:

2.26 Entering a Function

2.27 Financial Functions

NPER

PMT

2.28 Math and Trig Functions

ROUND

RAND

SUMIF

2.29 Statistical Function

COUNTIF

2.30 Naming and using a Named Range in an Excel Formula

2.31 Lookup and Reference Function

VLOOKUP

2.32 Logical Function

2.33 Using Array Formulas.

Objective D. The student will create lists by:

2.34 Creating a List

2.35 Entering Data using the Data Form

2.36 Using Data Validation

2.37 Sorting a List

2.38 Modifying Records

2.39 Outlining a Worksheet

2.40 Subtotaling a List

2.41 Filtering a List using advanced filters.

Objective E. The student will analyze data using the following Excel analysis tools:

2.42 Introduction to PivotTables

2.43 Creating PivotChart Reports

2.44 Creating Interactive PivotTables for the Web

2.45 Analyzing data using Goal Seek

2.46 Analyzing data using Solver

2.47 Creating Scenarios.

Objective F. The student will manage and audit worksheets by:

2.48 Introducing Macros

2.49 Working with Toolbars

2.50 Auditing Workbooks.

Objective G. The student will collaborate with workgroups:

2.51 Understanding the Benefits and Limitations of sharing Workbooks

2.52 Changing Workbook Properties

2.53 Protecting Workbooks

2.54 Tracking Changes

2.55 Working with Multiple Worksheets

2.56 Using the Report Manager.

Objective H. The student will import and export data by:

2.57 Importing from and Exporting to Text Files

2.58 Accessing and Placing Data on the Web

2.59 Importing Data from a Web Page into Excel

2.60 Round-Tripping an Excel Workbook

2.61 Using Microsoft Query

2.62 Linking and Embedding Objects.

Unit 3 Desktop Presentations (Advanced Features) 10 hours

Goal 3: The student will demonstrate the ability to use the computer as a problem-solving tool in all appropriate subject areas.

Goal 5: The student will demonstrate the ability to use application programs.

Goal 6: The student will demonstrate the ability to access and store information.

Goal 7: The student will demonstrate the ability to apply computer science concepts.

Objective A. The student will add visual elements to a PowerPoint presentation by:

3.1. Adding a Chart

3.2. Adding an Object

3.3. Adding a Table

3.4. Adding an Organizational Chart

3.5. Adding Clip Art.

Objective B. The student will modify a presentation by importing and exporting data by:

3.6. Modifying the Slide Sequence

3.7. Finding and Replacing Text

3.8. Spell Checking a Presentation

3.9. Formatting Slides

3.10. Creating a Summary Slide

3.11. Inserting Data from Other Sources

3.12. Exporting an Outline to Word.

Objective C. The student will customize and create a slide show presentation by:

3.13 Changing the Background

3.14 Changing Color Schemes

3.15 Changing the Design Template

3.16 Adding Transitions and Effects

3.17 Adding Action Buttons

3.18 Hiding Slides

3.19 Automatic Slide Timing

3.20 Recording and Playing Macros.

Objective D. The student will create output and deliver slide presentations by:

3.21 Printing a Slide Presentation

3.22 Saving a Slide Presentation Using Pack and Go

3.23 Saving a Slide Presentation for the Internet

3.24 Saving Slides as Graphic Files

3.25 Adding and View Speaker Notes

3.26 Generating Meeting Notes

3.27 Delivering Slide Presentation Using Slide Show.

Objective E. The student will link and embed objects and files by:

3.28 Embedding versus Linking

3.29 Embedding Objects

3.30 Linking Objects

3.31 Linking to Other Applications

3.32 Adding a Presentation within a Presentation.

Unit 4 Databases 12 hours

Goal 3: The student will demonstrate the ability to use the computer as a problem-solving tool in all appropriate subject areas.

Goal 5: The student will demonstrate the ability to use application programs.

Goal 6: The student will demonstrate the ability to access and store information.

Goal 7: The student will demonstrate the ability to apply computer science concepts.

Objective A. The student will build and modify database tables by:

4.1 Using Data Types

4.2 Creating a Table Using the Table Wizard

4.3 Creating a Table Using Design View

4.4 Modifying a Table’s Design

4.5 Controlling Data Entry in Tables

4.6 Creating and Modifying an Input Mask

4.7 Formatting Field Values.

Objective B. The student will build and modify database forms by:

4.8 Creating Controls

4.9 Creating a Form Using the Form Wizard

4.10 Building a From Using Design View

4.11 Adding Titles and Graphics to a Form

4.12 Customizing the Form Header, Detail, and Form Footer Section

4.13 Resizing, Moving, and Editing Control Objects

4.14 Modifying Control Properties

4.15 Creating a Calculated Control

4.16 Form Properties

4.17 Creating a Form with Two Tables

4.18 Creating a Switchboard.

Objective C. The student will refine queries by:

4.19 Applying Filters to a Query

4.20 Joining Two Tables in a Query

4.21 Performing Calculations in a Query

4.22 Creating a Cross Tab Query

4.23 Creating a Parameter Query

4.24 Creating an Action Query

4.25 Specifying Multiple Criteria for a Query in Design View

4.26 Modifying Field Properties.

Objective D. The student will create reports in a database by:

4.27 Understanding the Parts of a Report

4.28 Creating a Report in Design View

4.29 Modifying a Report in Design View

4.30 Printing a Report

4.31 Sorting Records in a Report

4.32 Grouping Records in a Report

4.33 Adding Graphics to a Report

4.34 Modifying Properties for a Report, Section, or Control

4.35 Calculating a Total or an Average

4.36 Embedding a Subreport.

Objective E. The student will define relationships in a database by:

4.37 Understanding Relationships in a Database

4.38 Defining Relationships Between Tables

4.39 Viewing Existing Relationships Between Tables

4.40 Printing the Relationships Window

4.41 Understanding Referential Integrity

4.42 Editing an Existing Relationship

4.43 Using Cascading Updates and Cascading Deletes

4.44 Understanding Join Types

4.45 Using Indexes.

Unit 5 Telecommunications and the Internet 10 hours

Goal 2: The student will demonstrate the ability to appreciate technology.

Goal 3: The student will demonstrate the ability to use the computer as a problem-solving tool in all appropriate subject areas.

Goal 4: The student will demonstrate the ability to understand the impact of technology.

Goal 5: The student will demonstrate the ability to use application programs.

Goal 6: The student will demonstrate the ability to access and store information.

Goal 7: The student will demonstrate the ability to apply computer science concepts.

Objective A. The student will describe the components of various telecommunications networks by:

5.1 Comparing the major types of telecommunications networks including:

Computer to computer

Host-based

Distributed

5.2 Comparing direct and remote Internet access

5.3 Comparing the features of the major telecommunications services provided over the Internet including:

FTP

Gopher

Newsgroups

Telnet

World Wide Web (WWW).

Objective B. The student will view the World Wide Web and use techniques to manipulate a browser by:

5.4 Navigating the Internet using WWW browser features including:

Hypertext textual and graphic links

Direct entry by Uniform Resource Locator (URL)

Forward and Backward access to a series of previously visited pages

Multiple windows.

5.5 Viewing web pages saved on a local computer

5.6 Accessing images saved on a local computer

5.7 Viewing web pages printed on paper

5.8 Downloading images, files, and programs using a telnet helper application program

5.9 Adjusting font size

5.10 Finding specific text within a web page

5.11 Reloading a web page

5.12 Using on-line help menus to master new program functions and capabilities.

Objective C. The student will use search techniques to find information on the Internet by:

5.13 Using electronic methods for locating information on the Internet including:

Directories

Individual

Meta search engines.

5.14 Using the Internet and appropriate search techniques to complete assigned tasks and projects.

5.15 Relating Internet and other technological events to cultural and social milestones by creating a timeline based on information obtained from the Internet.

Unit 6 Advanced Graphics and Sound 6 hours

Goal 3: The student will demonstrate the ability to use the computer as a problem solving tool in all appropriate subject areas.

Goal 4: The student will demonstrate the ability to understand the impact of technology.

Goal 5: The student will demonstrate the ability to use application programs.

Goal 6: The student will demonstrate the ability to access and store information.

Goal 7: The student will demonstrate the ability to apply computer science concepts.

Objective A. The student will describe the components of computer graphics by:

6.1 Defining the following computer graphics terminology:

Digital

Pixel

Resolution

Capture device

Editor applications

Conversion/Viewer utilities

File formats.

6.2 Describing the uses of computer graphics in the classroom and in society

6.3 Capturing images digitally using:

Digital cameras

Digital scanners

Digital camcorders

Objective B. The student will use digital sound by:

6.4 Describing the uses of digital sound in the classroom and in society

6.5 Capturing and play digital sound track using a microphone and a sound card

6.6 Describing the hardware requirements of digital sound:

Memory Requirements:

RAM

ROM

Sound card

CPU requirement.

6.7 Describing the uses of digital sound in computer applications software:

Multimedia presentation programs

Desktop presentation programs

File formats.

6.8 Playing capture sound tracks using:

Sound card

Headphones

PC speakers

Computer speakers.

Objective C. The student will demonstrate knowledge in the use of computer graphics by:

6.9 Describing the computer hardware options required for graphics including:

Memory Requirements:

ROM

RAM

Graphic

CPU requirement

6.10 Describing the use of computer graphics in applications software including:

Desktop publishing programs

Desktop presentation programs

Multimedia presentation programs

File compression programs

File conversion programs

6.11 Displaying computer graphics using:

Monitors

Digital to analog converters

LCD panels

Printers.

Objective D The student will use graphic editing software to edit digital pictures and video by:

6.12 Opening images

6.13 Editing images using cropping, sharpening and animation

6.14 Saving images

6.15 Opening video

6.16 Editing video using trimming, splicing, speed and special effects

6.17 Saving video

Unit 7 Desktop Publishing Software 6 hours

Goal 3: The student will demonstrate the ability to use the computer as a problem-solving tool in all appropriate subject areas.

Goal 5: The student will demonstrate the ability to use application programs.

Goal 6: The student will demonstrate the ability to access and store information.

Goal 7: The student will demonstrate the ability to apply computer science concepts.

Objective A. The student will use basic components of desktop publishing software by:

7.1 Describing the uses and characteristics of a desktop publishing program

7.2 Incorporating effective design elements in a desktop publishing document

7.3 Describing the advantages and disadvantages of creating a publication using:

Wizards

Templates

Cue cards

Start from scratch.

7.4 Using the following basic tools:

Pointer

Text frame

Table

Word Art

Picture

Wizard

Drawing

7.5 Importing clip art and pictures into publications.

7.6 Using the following editing features:

Cut

Copy

Paste

Delete (frames).

7.7 Using layout grid lines to aid design

7.8 Using the following formatting features:

Character

Indents and Lists

Line Spacing

Tabs

Border

Border Art

Shading

Shadow

7.9 Connecting and disconnect frames

7.10 Importing text into publications

7.11 Inserting graphics acquired from a capture device.

Unit 8 Creating Web Sites with the HyperText Markup Language (HTML) 10 hours

Goal 2: The student will demonstrate the ability to appreciate technology.

Goal 3: The student will demonstrate the ability to use the computer as a problem-solving tool in all appropriate subject areas.

Goal 4: The student will demonstrate the ability to understand the impact of technology.

Goal 5: The student will demonstrate the ability to use application programs.

Goal 6: The student will demonstrate the ability to access and store information.

Goal 7: The student will demonstrate the ability to apply computer science concepts.

Objective A. The student will identify and understand the basic HTML codes by:

8.1 Using a WWW browser and a text editor such as Notepad to display a web page’s HTML code.

8.2 Modifying an existing web page by exchanging its text and graphics

8.3 Identifying the major parts of a web page including the:

HTML identifiers

Head

Title

Body

Markup tags.

8.4 Comparing writing HTML code with a text editor and an HTML Editor.

Objective B. The student will create a web page using HTML code by:

8.5 Planning a web page using design criteria such as:

Keep pages simple and uncluttered

Use graphics, pictures, movies when appropriate

Limit the length of individual pages

Have each page contain a feedback address

Maintain a consistent format between pages

Have textual links flow naturally from the content.

8.6 Creating an web page containing examples of the following HTML elements:

Markup tags:

HTML

HEAD

TITLE

BODY

Headings

Paragraphs

Lists

Pre-formatted text (optional)

Extended quotations (optional)

Addresses

Forced line breaks

Postal addresses

Horizontal rules

Character formatting:

Logical

Physical.

8.7 Using an HTML authoring program to create a web page with the

following elements:

Fonts of varying sizes and colors

Centered text

Indented paragraphs

Bulleted items