COMPUTER APPLICATIONS 2

 

Course Length:  Trimester

Credits:  0.5

Grade Level(s):  9-12

Prerequisite:  Computer Applications 1

Text:  None

LCC College Now Credit:  4 credits for BT 114, MS Excel for Windows and 3 credits for BT 118, MS PowerPoint for Windows

 

Course Description:  Students will gain introductory and intermediate skills in the use of Microsoft Office applications including:  Excel, PowerPoint, Access, and Outlook.  Students must be able to work well on an independent, self-directed basis.

 

 

Outcome

Introduced

Applied

Tested

Create Spreadsheets

 

 

 

Identify Excel window features

x

x

x

Cells/columns

x

x

x

Labels/values

x

x

x

Formatting cell contents

x

x

x

Borders/Fill color/Font color

x

x

x

Entering and editing functions

·         Mathematical operators

·         Autosum

·         Paste function

·         Count/Max/Min/Average

·         Cell references:  absolute, relative, mixed

·         If fuction

·         PMT, FV, PV

·         Lookup:  horizontal/vertical

x

x

x

Moving and copying data within worksheet

x

x

x

Moving and copying data between Excel and Word

x

x

x

Hiding/unhiding rows/columns

x

x

x

Inserting/deleting rows/columns

x

x

x

WordArt

x

x

x

      Autofilter

x

x

x

Autoform

x

x

x

Naming cells and ranges

x

x

x

Linking and embedding

x

x

x

Creating templates

x

x

x

Charts

·         Pie/bar/column/line

x

x

x

Create Electronic Presentations

 

 

 

Identify PowerPoint window features

x

x

x

Create new presentation

x

x

x

Autocontent wizard

x

x

x

Autolayout

x

x

x

Views:  Slide/outline/slide sorter/slide show/master/notes pages

x

x

x

Apply design     

x

x

x

Slide transitions

x

x

x

Custom animation

x

x

x

Inserting clipart, images, sound, movies

x

x

x

Inserting Autoshapes

x

x

x

WordArt

x

x

x

Organizational charts and diagrams

x

x

x

Printing options

x

x

x

Save options

x

x

x

Creating hyperlinks

x

x

x

Copying between PowerPoint, Word, and Excel

x

x

x

Format slide layout/design/background

x

x

x

Create and present original presentations

x

x

x

Create and Manage Databases

 

 

 

Identifying Access window features

x

x

x

Create a database table

x

x

x

Maintain a database table

x

x

x

Modify a database table

x

x

x

Create relationships between tables

x

x

x

Create forms, reports, mailing labels, and charts

x

x

x

Use database wizards

x

x

x

Perform queries and filter records

x

x

x

Maintain a Personal Computerized Calendar

 

 

 

Create a calendar, tasks, contacts, and inbox persona subfolder

x

x

x

Schedule, edit, move, delete, and print appointments and events in Calendar

x

x

x

Set appointments using natural language phrases

x

x

x

Create and print a task list

x

x

x

Create and print a contact list

x

x

x

Create an email message

x

x

x

 

Evaluation:

            40% Daily work                                                                               

            40% Tests                                                                                         

            20% Employability (attendance, work habits, participation, etc.)