Technical Computer Applications

WORD
CSO Standard

1709.1.1    Create a document with proper formatting.
1709.1.2    Modify a document, then print copies.
1709.3.1    Define computer graphics and list three uses of
graphics software.

Lesson 1
Word
Basics

pages 3 - 22
Lesson 2
Basic
Editing
pages 23 - 40
Lesson 3
Helpful
Word
Features

pages 41 - 60
Lesson 4
Formatting
Text

pages 61 - 76
Lesson 5
Formatting
Paragraphs
and
Documents

pages 77 - 101
Lesson 6
Working
with
Graphics

pages 103 - 129
Lesson 7
Working
with
Documents

pages 131 - 152
Lesson 8
Increasing
Efficiency
using
Word

pages 153 - 180
 
EXCEL
CSO Standard

1709.2.1    Create, save and print a copy of a basic worksheet.
1709.2.2    Modify an existing worksheet.
1709.2.3    Create a worksheet graph.
Lesson 1
Excel Basics
pages 3 - 19

 

Lesson 2
Changing
the
Appearance
of a Worksheet

pages 21 - 42
Lesson 3
Organizing
the Worksheet

pages 43 - 66
Lesson 4
Worksheet
Formulas

pages 67 - 85
Lesson 5
Function
Formulas

pages 87 - 107
Lesson 6
Making
the
Worksheet
Useful

pages 109 - 140
Lesson 7
Working
with
Multiple
Worksheets

pages 141 - 154
Lesson 8
Worksheet
Charts

pages 155 - 181
 
ACCESS
CSO Standard

1709.5.1    Create a database file and enter data into the database.
1709.5.2    Sort a database file and create a printed document of the information.
1709.5.3    Update a database file.
Lesson 1
Access Basics
pages 3 - 27

 

Lesson 2
Manipulating Data

pages 29 - 44

 

Lesson 3
Creating
and
Modifying
Forms

pages 45 - 64
Lesson 4
Finding and Ordering Data
pages 65 - 91
Lesson 5
Reports and
Macros

pages 93 - 114
Lesson 6
Integrating Access
pages 115 - 135
     
POWERPOINT
CSO Standard

1709.4.1    Plan and create a presentation using presentation software.
1709.4.2    Deliver a presentation, using proper speaking techniques and effectively use the computer generated presentation.
Lesson 1
PowerPoint Basics
pages 3 - 19
Lesson 2
Creating
and Enhancing PowerPoint Presentations

pages 21 - 60
Lesson 3
Working
with
Visual
Elements

pages 61 - 99
Lesson 4
Expanding on PowerPoint Basics
pages 101 - 135


PP Study Guide

 

PowerPoint QUIZ Crossword

Assignment #1

Assignment #2

   
PROGRAMMING
CSO Standard

1709.7.1 Define a computer program, and identify programs written in two different languages.
1709.7.2 List four of the most popular programming languages used today, and match each with its appropriate environment.
1709.8.1 Define the basic steps in the programming cycle.
1709.8.2 Identify and describe the most common flowchart symbols.
1709.8.3 Describe the differences between a system flowchart and a program flowchart.
1709 8.4 Describe file organization and cases for sequential files, indexed files, and relative ( or direct) files.
1709.9.1 Define a programming problem, and plan a solution to the problem.
1709.9.2 Code, Test, and Debug the program you designed.
1709.9.3 Provide appropriate documentation for the program.
Chapter 1
An Overview of Computers and Logic

 

Chapter 2
Understanding Structure
Chapter 3
Modules, Hierarchy Charts,
and Documentation

 

 

End of Course Test Study Guide

 

Chapter 4
Designing and
Writing
a
Complete Program


State Department Course Standard and Objective

Chapter 5
Making Decisions

 

 

 

End of Course Test QUIZ

Chapter 6
Looping

 

 

 

End of Course Study Sheet

Chapter 11
Sequential File Merging, Matching, and Updating

 

 

End of Course Crossword

Chapter 13
Object-Oriented Programming
Chapter 16
Using Relational  Databases