|
Woodruff High School
Business Education Department 2004 - 2005 Integrated Business Applications Syllabus
|
||
|
COURSE
DESCRIPTION:
CREDITS:
1.5 Units
PREREQUISITE:
Keyboarding
COURSE COMPETENCIES: Given the necessary equipment, supplies, and appropriate software, the student on completion of 180 hours of instruction will be able to successfully complete the introductory competencies for Word 2000, Excel 2000, Access 2000, and PowerPoint 2000. Note:
The following competencies are for
Office 2000 Unit A. BASIC COMPUTER CONCEPTS 1. Explain steps in the
information processing cycle. 2. Identify and explain
the components of a computer system. 3. Categorize software
according to function (system and application). 4. Identify functions
of input/output devices. 5. Categorize storage
as primary or secondary. 6. Define basic
computer terminology (hardware, software, program, pixel, resolution, binary,
RAM, ROM bit, and byte). 7. Identify
characteristics and limitation of various computers based on size and
capabilities. 8. List examples of
computer use in business, education, government, industry, and the home. 9. Identify terms
commonly found in personal computer advertisements. 10. Describe the steps
in purchasing a personal computer. 11. Demonstrate both
cold and warm boots. 12. Define path,
prompt, root directory, sub-directory, and wildcard. 13. Identify basic
functions and terminology associated with operating systems and system software
(such as boot, MacIntosh, MS Windows, multitasking, BUI, icon, WYSIWYG, mouse,
minimize, and maximize). 14.
Define characteristics of LANs, WANs, and
MANs. 15. Identify network hardware components. Unit B. WORD
1. Use
the
Undo, Redo, and Repeat command. 2. Apply
font formats (bold, italics, and underline). 3. Use the
SPELLING feature. 4. Use the
THESAURUS feature. 5. Use the
GRAMMAR feature. 6. Insert
page breaks. 7. Highlight
text in documents. 8.
Insert and move text. 9. Cut, copy, paste, and paste special using the clipboard. 10. Copy formats using Format Painter. 11. Select and change font and font size. 12. Find and replace text. 13. Apply character effects (superscript, subscript, strikethrough, small
caps, and outline). 14. Insert date and time. 15. Insert symbols. 16. Create and apply frequently used text with AutoCorrect.
17.
Align text in paragraphs (center, left, right, and justified). 18.
Add bullets and numbering. 19.
Set character, line, and paragraph spacing options. 20.
Apply borders and shading to paragraphs. 21.
Use indentation options (left, right, first line, and hanging). 22.
Use TABS command (center, decimal, left and right). 23.
Create an outline style numbered list.
24.
Set tabs with leaders.
25.
Use print preview. 26.
Print a document. 27.
Use Web Page Preview. 28.
Navigate through a document. 29.
Insert page numbers. 30.
Set page orientation. 31.
Set margins. 32.
Use GoTo to locate specific elements in a document. 33.
Create and modify page numbers. 34.
Create and modify headers and footers. 35.
Align text vertically.
36. Create and use newspaper columns. 37.
Revise column structure. 38.
Prepare and print envelopes and labels. 39.
Apply styles. 40.
Create sections with formatting that differs from other sections. 41.
Use click and type.
42.
Use save. 43.
Locate and open an existing document. 44.
Use Save As (different name, location, or format). 45.
Create a folder. 46.
Create a new document using a wizard. 47.
Save as Web page. 48.
Use templates to create a new document. 49.
Create hyperlinks. 50.
Use the Office Assistant 51.
Send a Word document via e-mail.
52.
Create and format tables. 53.
Add borders and shading to tables. 54.
Revise tables (insert and delete rows and columns, and change cell
formats). 55.
Modify table structure (merge cells and change height and width). 56.
Rotate text in a table.
57.
Use the drawing toolbar. 58.
Insert graphics into a document (WordArt, clip art, and images). Unit C. EXCEL
1.
Use Undo
and Redo. 2.
Clear
cell content. 3.
Enter
text, dates, and numbers. 4.
Edit
cell content. 5.
Go to a specific cell. 6.
Insert and delete selected cells. 7.
Cut, copy, paste, paste special, and move selected cells; use the Office Clipboard. 8.
Use Find and Replace. 9.
Clear cell formats.
10.
Work with series (AutoFill).
11.
Create hyperlinks.
12.
Use Save. 13.
Use Save As (different name, location, and format). 14.
Locate and open an existing workbook. 15.
Create a folder. 16.
Use templates to create a new workbook. 17.
Save a worksheet/workbook as a Web page. 18.
Send a workbook via E-mail. 19.
Use the Office Assistant.
20. Apply font styles (typeface, size, color, and styles). 21.
Apply number formats (currency, percent, dates, and comma). 22.
Modify size of rows and columns. 23.
Modify alignment of cell content. 24.
Adjust the decimal place. 25.
Use the Format Painter. 26.
Apply AutoFormat. 27.
Apply cell borders and shading. 28.
Merge cells. 29.
Rotate text and changed indents. 30.
Define, apply, and remove a style.
31. Preview and print worksheets and workbooks. 32.
Use Web Page Preview. 33.
Print a selection. 34.
Change page orientation and scaling. 35.
Set page margins and centering. 36.
Insert and remove a page break. 37.
Set print and clear a print area. 38.
Set up headers and footers. 39.
Set print titles and options (gridlines, print quality, and row and
column headings).
40. Insert and delete rows and columns. 41.
Hide and unhide rows and columns. 42.
Freeze and unfreeze rows and columns. 43.
Change the zoom setting. 44.
Move between worksheets in a workbook. 45.
Check spelling. 46.
Rename a worksheet. 47.
Insert and delete worksheets. 48.
Move and copy worksheets. 49.
Link worksheets and consolidate date using 3D References.
50.
Enter a range within a formula by dragging. 51.
Enter formulas in a cell, and use
the formula bar. 52.
Revise formulas. 53.
Use references (absolute and
relative). 54.
Use AutoSum. 55.
Use Paste Function to insert a
function. 56.
Use basic functions (AVERAGE, SUM,
COUNT, MIN and MAX). 57.
Enter functions using the formula
palette. 58.
Use date functions (NOW and DATE). 59.
Use financial functions (FV and
PMT). 60.
Use logical functions (IF).
61. Preview and print charts. 62.
Use chart wizard to create a chart. 63.
Modify charts. 64.
Insert, move, and delete an object (picture). 65.
Create and modify lines and objects. Unit D. POWERPOINT
1.
Create a presentation from a template and/or a wizard. 2.
Create a blank presentation. 3.
Create a specified type of slide. 4.
Navigate among different views (slide, outline, sorter, and tri-pane). 5.
Delete slides.
6. Change the order of slides using Slide Sorter view. 7.
Change the layout for one or more slides. 8. Modify slide sequence in the outline pane. 9.
Apply a design template.
10.
Check spelling. 11.
Change and replace text fonts (individual slide and entire presentation). 12.
Enter text in tri-pane view. 13.
Change the text alignment. 14.
Create a text box for entering text. 15.
Use the wrap text in text box feature. 16.
Promote and demote text in slide and outline panes.
17. Add a picture from the ClipArt Gallery. 18.
Apply formatting. 19.
Scale and size an object including clip art.
20. Add slide transitions. 21.
Animate text and objects.
22. Preview presentation in black and white. 23.
Print slides in a variety of formats.
24.
Start a slide show on any slide 25.
Use screen navigation tools.
26. Save changes to a presentation. 27.
Save as a new presentation. 28.
Use Office Assistant. Unit E. ACCESS
1. Determine
appropriate data inputs for a database. 2. Determine
appropriate data outputs for a database. 3. Create
table structure. 4.
Establish table relationships.
5. Use the Office Assistant. 6.
Select an object using the Objects Bar. 7.
Print database objects (tables, forms, reports, and queries). 8.
Navigate through records in a table, query, or form. 9.
Create a database (using a wizard or in Design View).
10. Create tables by using the Table Wizard. 11.
Set primary keys. 12.
Modify field properties. 13.
Use multiple data types. 14.
Modify tables using Design View. 15.
Use the Lookup Wizard. 16.
Use the input mask wizard. Unit F. INTERNET APPLICATIONS 1. Understand
net addresses. 2. Demonstrate
ability to use search engines. 3. Use
E-mail. 4. Evaluate
Web site integrity and usefulness. 5. Understand
basic Web design development and publishing. Unit G. SAFETY 1. Identify
good work attitudes that affect safety on the job. 2. Identify
the major causes of work-related accidents and injuries in the office. 3. Demonstrate knowledge of an emergency plan. 4. Describe the threat of viruses to a computer network, methods of avoiding
attacks, and options in dealing with a virus attack. 5. Identify potential abuse and unethical uses of computers and networks.
INSTRUCTIONAL
MATERIALS AND SUPPLIES: Required
textbook: Pasewark & Pasewark. Microsoft Office 2000 - Introductory
Course, South-Western Educational Publishing, Cincinnati, Ohio, 2000. Provided
by the student: One 3-ring, loose leaf
notebook with dividers and paper. The
notebook should be labeled and organized as follows: HW/CW, Notes, Quizzes, and
Handouts.
IBA
EVALUATION SYSTEM
FIRST
QUARTER Quizzes
20% Major
Tests
45% Homework/Classwork
10% Nine
Weeks Test
25% SECOND
QUARTER Quizzes
20% Major
Tests
50% Homework/
Classwork
30% SEMESTER
GRADE Average
of Two Nine Weeks
75% Semester
Exam
25% THIRD
QUARTER Quizzes
20% Major
Tests
45% Homework/Classwork
10% Nine
Weeks Test
25% FOURTH
QUARTER Quizzes
20% Major
Tests
50% Homework/Classwork
30% SEMESTER
GRADE Average
of Two Nine Weeks Grades
75% Semester
Exam
25% FINAL
GRADE First
Semester Grade
50% Second
Semester Grade
50% **Grades will be assigned based on the grading scale printed in your WHS Student Handbook.** |
||