CHAMBERSBURG AREA SCHOOL DISTRICT by HC120929111845

VIEWS: 2 PAGES: 6

									                                             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
           5) Create a series, add natural language formulas and add comments
           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
   D. Advanced Formatting and Editing
       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
      8) Add a primary key
      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
      13) Link an Excel worksheet

   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
               Individual Assistance                                         Advanced Projects
               Extended Time
               Break down tasks into smaller units




                                                                                                                     6

								
To top