# CHAMBERSBURG AREA SCHOOL DISTRICT by HC120929111845

VIEWS: 2 PAGES: 6

• pg 1
```									                                             CHAMBERSBURG AREA SCHOOL DISTRICT
COURSE OF PLANNED INSTRUCTION

SCHOOL      CASHS                                DEPARTMENT    BUSINESS                    DATE   7/5/00

COURSE TITLE         Computer Applications III                GRADE   10/11/12      COURSE LENGTH 1 yr

LESSON FREQUENCY (PER WEEK)                 1        TIME                   COURSE REVISED June 5, 2000

COURSE CREDIT               1                    COURSE REQUIRED                 ELECTED

======================================================================================================

I. MAJOR COURSE OBJECTIVES AND STUDENT PERFORMANCE INDICATORS

All Students Will:

A. Be able to utilize the PC to create basic and advanced documents with the software package Microsoft Excel, Access,
and PowerPoint in preparation for MOUS test and certification.

1. Microsoft Excel 2000

A. Basics
Reading and Writing Standards: 1.1.11 D F G / 1.2.11 A / 1.5.11 E / 1.6.11 A D
Math Standards: 2.2.11A F
Technology Standards: 3.7.4D; 3.710CDE; 3.7.12DE
1) Open, close, and save and print an Excel document
2) Learn window and screen elements including menu and toolbar
3) Work with mouse and keyboard
4) Create a new workbook
5) Make simple corrections and use view menu
6) Work with labels
7) Use Auto Correct feature and Undo and Redo, and spelling
8) Enter numeric labels and values
9) Change label alignment and work with indents and column widths
10) Integrate an Excel worksheet and a Word document

B. Entering Formulas and Formatting a Worksheet
Reading and Writing Standards: 1.1.11 D F G / 1.2.11 A / 1.5.11 E / 1.6.11 A D
Math Standards: 2.2.11 A F / 2.5.11A
Technology Standards: 3.7.4D; 3.710CDE; 3.7.12DE
1) Formula basics and ranges
2) Enhance data with different formats, fonts, and font sizes
3) Copy and paste data and formulas
4) Save a worksheet as a Web page and view the Web page

C. Working with Functions, Formulas, and Print Options
Reading and Writing Standards: 1.1.11 D F G / 1.2.11 A / 1.5.11 E / 1.6.11 A D
Math Standards: 2.2.11 A F / 2.5.11A / 2.7.11 E / 2.4.8 B C / 2.5.11 C
Technology Standards: 3.7.4D; 3.710CDE; 3.7.12DE
1) Function basics including formula bar and palette
2) If Statements
3) V-Lookup
4) Paste function and AutoCalculate data
6) Set up print options, work with page setup, and insert headers and footers
7) Insert page breaks and preview page break
8) Use print titles and create an interactive Web report
Reading and Writing Standards: 1.1.11 D F G / 1.2.11 A / 1.5.11 E / 1.6.11 A D
Math Standards: 2.2.11 A F / 2.5.11A / 2.7.11 E / 2.5.11C
Technology Standards: 3.7.4D; 3.710CDE; 3.7.12DE
1) Insert and delete columns and rows
2) Cut and paste data , drag and drop, and Copy and Paste Special
3) Transpose data in a worksheet
4) Freeze titles and split panes and window between open workbooks
5) Use scroll tips
6) Name ranges and extract and combine data
7) Display open workbooks, link workbooks and drag and drop data between workbooks
8) Work with 3-D formulas, copy sheets and duplicate workbook window
9) Link and embed objects and files and work with linked files

2. Microsoft Access 2000

A. Basics
Reading and Writing Standards: 1.1.11 D F G / 1.2.11 A / 1.5.11 E / 1.6.11 A D
Math Standards: 2.2.11A
Technology Standards: 3.7.4D; 3.710CDE; 3.7.12DE
1) Copy data files and deselect the read-only attribute
2) Open, save, navigate, preview and print a database
3) Enter records and sort in a database
4) Correct a field entry
5) Plan and create a new database
6) Create a table and change field names in Datasheet view
7) Edit a table in Design view and switch between views
9) Change column widths, freeze columns, and set security
10) Create a form from a datasheet, use form design view, and work with controls
11) Export an Access object to an Excel worksheet and publish an object to a Word Document

B. Editing and Printing
Reading and Writing Standards: 1.1.11 D F G / 1.2.11 A / 1.5.11 E / 1.6.11 A D
Math Standards: 2.2.11A
Technology Standards: 3.7.4D; 3.710CDE; 3.7.12DE
1) Work with fields in Design view, rename a field, and add a Lookup Value
2) Insert, delete, and move columns in datasheet view
3) Hide datasheet fields and print datasheets and forms
4) Work with Form View Toolbox
5) Create labels
6) Use Print Setup and print with headers and footers
7) Work with records, remove gridlines and add form backgrounds
8) Switch among open objects, use form AutoFormat, and lookup field values from another table
9) Import Excel data into an Access table, link to an Excel worksheet and copy data from Word or Excel
10) Relate tables, enforce referential integrity, work with related records and set subdatasheets

C. Find Information in a Database
Reading and Writing Standards: 1.1.11 D F G / 1.2.11 A / 1.5.11 E / 1.6.11 A D
Math Standards: 2.2.11A
Technology Standards: 3.7.4D; 3.710CDE; 3.7.12DE
1) Use wizards and work with switchboards
2) Find and replace data, search using wildcards
3) Work with multiple sorts, remove sorts, and change column order
4) Filter a record subset, by selection, excluding selection, for entry, and by form
5) Use Advanced Filter/Sort, sort rows, use criteria row
6) Work with Data Access Pages, add fields, align and size controls

2
D. Work with Queries
Reading and Writing Standards: 1.1.11 D F G / 1.2.11 A / 1.5.11 E / 1.6.11 A D
Math Standards: 2.2.11A
Technology Standards: 3.7.4D; 3.710CDE; 3.7.12DE
1) Query basics, create a query, choose fields for a query, sort records and save a query
2) Use all fields of a table for a query, change query design, delete and move fields and rename and print a
query
3) Change field format in query design, change field names and add calculations to a query
4) Create a query using data from multiple tables

4. Microsoft Power Point

A. Basics
Reading and Writing Standards: 1.1.11 D F G / 1.2.11 A / 1.5.11 E / 1.6.11 A D
Technology Standards: 3.7.4D; 3.710CDE; 3.7.12DE
1) Use blank presentation option, AutoLayout, and Template Option
2) Screen elements
3) Insert text and add slides in a presentation
4) Open, Save a presentation and save as a Web Page
5) Work with slide views and move around in a presentation
6) Use spell check, Change a slide layout, and apply a different template
7) Insert objects in a presentation and correct with Undo
8) Move, copy, duplicate, and delete slides
9) Work in Slide Sorter view
10) Work in Outline view and create a summary slide
11) Use data created in other programs
12) Import/export an outline created in Word

B. Editing and Formatting a Presentation
Reading and Writing Standards: 1.1.11 D F G / 1.2.11 A / 1.5.11 E / 1.6.11 A D
Technology Standards: 3.7.4D; 3.710CDE; 3.7.12DE
1) Select and align text, enhance text appearance and work with Change Case
2) Apply slide color schemes and backgrounds
3) Copy, and move text, adjust paragraph spacing and work with objects
4) Create slide and title masters
5) Insert footer text, and change bullets
6) Work with rulers and guides, use floating toolbars and create graphic objects
7) Work with AutoShapes, group and ungroup and layer objects
8) Create a custom template
9) Organization charts
10) Use charts and tables
11) Embed a slide in a Word document
12) Export slides and notes to a Word document, export text to a Word document

C. Setting Up a Slide Show
Reading and Writing Standards: 1.1.11 D F G / 1.2.11 A / 1.5.11 E / 1.6.11 A D
Technology Standards: 3.7.4D; 3.710CDE; 3.7.12DE
1) Show a presentation, add transitions, sound, and timings
2) Hide slides
3) Work with animation and use effects toolbar
4) Use Annotation feature, add music and movie files
5) Create notes pages and handouts, work with notes master and handout master
6) Pack and Go feature and Meeting Minder
7) Run a presentation and create continuously running presentations
8) Save a presentation as a Web site, publish a presentation
9) Export a presentation to overhead

3
D. Be able to operate an office calculator using the ten key method
Reading and Writing Standards: 1.1.11 D F G / 1.2.11 A / 1.5.11 E / 1.6.11 A D
Math Standards: 2.2.11 A / 1.5.11 A / 2.5.11C / 2.7.11 E
Technology Standards: 3.7.4D; 3.710CDE; 3.7.12DE
1. Proper finger reaches
2. Simulation calculator problems

4
II.   CONTENT OUTLINE AND TIME ALLOCATION

A. Basic calculator usage – ½ marking period
1. proper finger reaches
2. drill/practice
3. simulation activity

B. Microsoft Office
1. Microsoft Excel – 1 1/2 marking periods
2. Microsoft Access – 1 marking period
3. Microsoft PowerPoint – 1 marking period

5
III.   TEXTS, MATERIALS, AND MAJOR RESOURCES

PC’s with Microsoft Office 2000
SAMS (Software in Microsoft Testing Preparation)
Monroe office style calculators
Texts: Microsoft Office 2000, Advanced Course; Computer Applications for the New Millennium
LCD Projector

IV.    PROCEDURES FOR ASSESSMENT OF PA ACADEMIC STANDARDS

Problem tests
Classroom assessment
Written testing
Simulation completing

V.     SPECIAL CONDITIONS OR PREREQUISITES

Computer Keyboarding Applications or Computer Applications II
Class size should be limited to the number of machines in the room.

VI.    COURSE EVALUATION PROCEDURE

All planned courses will be monitored by the Assistant Superintendent for Curriculum and Instruction,
administrators, and the department chair and revised according to designated revision cycle.

VII.   ACCOMMODATIONS (Describe methods of assistance to students needing additional learning opportunities and/or
enrichment activities for students who are capable of advanced work)

CORRECTIVES                                                   ENRICHMENTS

Supplemental Activities and Exercises                         Supplemental Activities & Exercises
Visual Presentations                                          Computer Applications
Peer Assistance                                               Cooperative Learning Activities