Mrs. Romero – Room 237

Class Syllabus

Computer Applications is a one-year course, which provides the student with a variety of business skills in the areas of word processing, spreadsheets, database management, presentations and desktop publishing. Concepts are taught with a hands-on approach. In the lab, students will reinforce lecture-based learning with interactive lessons on the computer.

Textbooks

Beskeen, David, L. Friedrichsen,  E. Reding, and M. Swanson. Microsoft Office 2000 Professional Edition Illustrated Introductory. Course Technology: Cambridge, 2000.

Shelly, Gary, T. Cashman, and J. Starks. Microsoft Publisher 2000 Complete Concepts and Techniques. Course Technology: Cambridge, 2000.

First Semester

Word Processing: Microsoft Word 2000
	Basic Skills Creating and editing a document Printing a document	2 weeks
	Editing and proofing documents Selecting, moving and copying text Using language tools, i.e. Spell Check, AutoCorrect and Thesaurus	2 weeks
	Formatting a document Page breaks, headers and footers Tables Clip Art, Word Art, Drawing Tools	4 weeks
Spreadsheets: Microsoft Excel 2000
	The Basics Understanding and creating a simple worksheet Entering data and Basic Formulas Enhancing the spreadsheet, time-saving tools	2 weeks
	Developing a worksheet Display options and printing Copying features Ranges Sorting	3 weeks
	Make it Visual: Charts Pies or Bars? Choosing the right type of chart for your data Creating and modifying a chart	2 weeks
Excel Projects		1 week
Database: Microsoft Access 2000
	Understanding Databases Parts of the Access screen Tables and other objects Managing records: find, sort	2 weeks

First Semester – Grading Policy

Tests	50%
Quizzes	30%
Daily Work	20%

Second Semester

Database: Microsoft Access 2000 (Continued)
	Building a Database Putting your tables to work: Formats, Input Masks, Validation Rules Forms and their controls Reports: creating and customizing	3 weeks
Desktop Publishing: Microsoft Publisher 2000
	Creating and editing a publication The Publication Wizard Publisher basics Modifying objects	2 weeks
	Designing a Newsletter Format elements: pagination, mastheads,  Graphic elements: Logos, WordArt	3 weeks
Presentations: Microsoft PowerPoint 2000
	Understanding Presentations The PowerPoint Views Running a Slide Show Presentation skills	2 weeks
	Developing a Presentation Adding New Slides and Slide Layouts Speaker’s Notes The Outline pane Enhancing text in a presentation	2 weeks
	Customizing a Presentation Creating and modifying objects Lines, fills and colors Grouping, layering and special effects Sound and animation	3 weeks
Class Project ·         A year-end cumulative project, which encompasses all applications. ·         Students will generate a final product that demonstrates their understanding of applications.		3 weeks

Second Semester – Grading Policy

Tests	50%
Quizzes	30%
Daily Work	20%