COMPUTER APPLICATIONS A AND B SYLLABUS
1. INTRODUCTION TO COMPUTERS
Computer operations
Components of the computer
Storage media
Computer communication channels
Purchasing, installing, and maintaning a personal computer
E-commerce
2. MICROSOFT EXCEL WITH EMBEDDED CHART
AutoSum
Copying cell references
Formatting a worksheet
3-D Clustered Column Chart
Autocalculate
Correcting errors
3. FORMULAS, FUNCTIONS, FORMATTING, AND WEB QUERIES
Enter formulas
Apply the AVERAGE, MAX, and MIN functions
Verify a formula using the Range Finder
Add conditional formatting
Display and print the formula version of a worksheet
Use a Web query to get real-time data from a Web site
4. WHAT-IF ANALYSIS, CHARTING, AND WORKING WITH LARGE WORKSHEETS
Use absolute cell references in formulas
Use the IF function to perform a logical test
Create a 3-D pie chart on a separate chart sheet
Goal seek to answer what-if questions
5. CREATE AND EDIT A WORD DOCUMENT
Describe the Word window
Check spelling as you type
Format text and paragraphs
Insert clip art in a document
Correct errors and use Word's Help to answer questions
6. CREATE A RESEARCH PAPER
Describe the MLA documentation style for research papers
Use a header to number pages
Apply formatting using shortcut keys
Add a footnote
Count the words in a document and insert a manual page break
Create a hyperlink
Sort selected paragraphs
Proof and revise a document
Display the Web page associated with a hyperlink
Use the Research task pane to locate information
7. CREATE A RESUME USING WORD WIZARD AND A COVER LETTER WITH A TABLE
Create a resume using Word's Resume Wizard
Set and use tab stops
Collect and paste using the Clipboard task pane
Format paragraphs and characters
Identify the components of a business letters
Create and insert AutoText entry
Insert a Word table, enter data and format
Address and print an envelope
Modify file properties
8. USE A DESIGN TEMPLATE AND TEXT SLIDE LAYOUT TO CREATE A PRESENTATION
Customize PowerPoint
Select a design template
Create a title slide and text slides with multi-level bulleted lists
Change the font size and font style
View a presentation in a slide show view
Display and print a presentation in black and white
9. USE THE OUTLINE TAB AND CLIP ART TO CREATE A SLIDE SHOW
Customize a new slide show from an outline
Add a slide and create a closing slide on the Outline tab
Insert and move clip art and change its size
Animate clip art
Add an animation scheme and run an animated slide show
Print a presentation outline
10. CREATE AND USE A DATABASE
Create a database
Create a table and add records
Print the contents of a table
Create and use simple query
Create and use simple form
Create and print a custom report
Design a database to eliminate redundancy
11. QUERY A DATABASE USING A SELECT QUERY WINDOW
Create and run queries
Print query results
Include fields in the design grid
Use text and numberic data in criteria
Create and use parameter queries
Use compound criteria in queries
Sort data in queries
Join table in queries
Perform calculations in queries
Use grouping in queries
12. INTEGRATE OFFICE APPLICATIONS AND THE WORLD WIDE WEB
Add hyperlinks to a Word document
Embed an Excel chart in to Word document
Add scrolling text to a Web page created in Word
Add a hyperlink to a PowerPoint slide
Create Web pages from a PowerPoint presention
Create a data access page from an Access database
Test a Web site in a browser
13. DRILLS AND TIMED WRITINGS TO INCREASE KEYBOARDING SKILLS
|
