Oneida High School
Business
Information Systems
Bertha Lay
Instructor: Bertha Lay
COURSE DESCRIPTION
This course provides an introduction
to Microsoft Publisher 2000. Topics
include creating and editing single-page and multi-page publications, using
wizards, commercial printing considerations, editing text, colors, and graphic
design objects, personal information sets, logos, the Pack and Go Wizard, and
using Publisher to create flyers, newsletters, brochures, logos, calendars, and
Web pages. Business forms such as
letterheads, business cards, envelopes, labels with mail merge, business cards,
invoices, fax covers, tables, Web forms for e-commerce, and object linking and
embedding is covered.
Course Outline:
A. Creating and
Editing a Publication
1. Creating an
advertising flyer
2. Editing, and
saving a publication
3. Moving 7 resizing
objects
4. Enhancing a
publication
B. Designing a
Newsletter
1. Using
Publisher Wizard
2. Editing a
newsletter template
3. Editing the
Masthead
4. Using Graphics
in a publication
5. Inserting
WordArt
6. Printing a
Two-sided Page
C. Preparing a
Tri-fold Brochure for Outside Printing
1. Using the
wizard
2. Editing text
and deleting objects
3. Setting
publication margins using layout and ruler guides
4. Creating a
company letterhead
5. Using the
business card wizard
6. Creating a
custom size business card
7. Creating a
publisher address list
8. Inserting
Field Codes
9. Merging and
printing the main publication with address list
D. Creating
business forms and tables
1. Creating and formatting invoice templates
2. Creating a fax
cover
3. Creating a
work schedule table
4. Merging cells
5. Entering data
into a table
6. Using the Fill
command
7. Attaching a
publication to an E-Mail Message
E. Integration
Feature: Linking a Publication to an
Excel Worksheet
1. Linking an
Excel Worksheet to a Publisher Publication
2. printing and
Saving the Publisher Publication with Linked Worksheet
3. Editing Linked
Worksheet
FEATURES
1. Projects that teach students to create polished business documents
2.
Design quality, professional documents using templates, customized
content, graphics
3.
Use advanced publisher features using design sets, color schemes, web
functionality
4.
End-of-project exercises, including unique cases and places (case
studies that require critical thinking, reinforce concepts and skills learned).
Software
Tools
Instructor: Bertha Lay
Course Description
This course provides an introduction to Microsoft Office. Office is a suite of computer applications that work alike and work together. Topics include self-contained sections for learning Word, Excel, Access, and PowerPoint, and lessons and exercises for integrating data from different Office applications.
Course Outline
A. Word Processing
1. Document Basics
2. Enhancing Documents
3. Basic Formatting
4. Timesaving Features
5. Tables
6. Mail Merge
7. Graphic Objects
8. Forms, Web Pages
B. Excel Spreadsheet
1. Understanding Workbook Basics
2. Creating, printing, and distributing worksheets
3. Formatting & editing worksheets
4. Calculating Data (entering formulas, using operators, copying formulas, editing formulas, understanding cell references, naming ranges)
5. Understanding workbook features
6. Understanding workbooks
7. Grouping Worksheets
8. Inserting and deleting sheets
9. Moving and copying sheets
10. Consolidating Data
11. Working with Charts
12. Automating, protecting, and enhancing work
13. Working with database features
C. Integrating Work Processing & Spreadsheet
1. Sharing information between documents or applications
2. Using Object Linking and Embedding to share information.
D. Database
1. Working with data
2. Filtering and querying records
3. Creating and enhancing reports
E. Case Studies
F. PowerPoint
1. Creating a presentation
2. Using wizards and templates, printing, and sending a presentation
3. Inserting tables and charts
4. Working with graphic objects.
5. Delivering a presentation
6. Integrating Word, Excel, and PowerPoint.
G. Special Projects
H. Portfolio
Instructor: Bertha Lay
Course Outline
A. Keyboarding
B. Windows 98
C. Microsoft Office
1. Microsoft Word
a. Memos
b. Business Letters
c. Reports
d. Tables
e. Word Processing Skills
2. Microsoft Excel
a. Spreadsheet design
b. Working with formulas
c. Working with charts
d. Macros
3. PowerPoint
a. Creating a Presentation
b. Creating charts
c. Creating Tables
d. Creating flowcharts and Organization Charts
e. Animation and Slide show Effects
Classroom Rules
1. Come to class prepared to learn; bring notebook, paper, pen/pencil.
2. Show respect for all.
3. Be in your seat, quiet, and ready to learn when the tardy
bell rigns or you are tardy.
4. Think “Computer Safety” Please be nice to your computer
station and all its’ parts. Leave the
station neat and orderly for the next person.
5. All student handbook rules and regulations will be
implemented.
6. Dismissal is by teacher, not by bell.
7. NO FOOD OR DIRNK ALLOWED IN CLASSROOMS.
8. Do not load any personal software on computers. This includes downloading from the internet.
9. Do not change the desktop.
10. Students may not use MSN INSTANT MESSENGER.
11. No headset/ear phones or other listening devices are
allowed in the classroom.
12. Keep up with your diskette. It is your responsibility.
13. PLEASE REMEMBER TO CHECK EQUIPMENT AT THE BEGINNING OF
EACH CLASS PERIOD. Things to check
are: desktop, keyboard, mouse, and monitor.
Inform the instructor immediately if something is wrong.