Business Computer Applications Syllabus - DOC by muz13477


More Info
									             Integrated Business Applications Syllabus

Title of Course:    Integrated Business Applications Syllabus
Teacher:            Mrs. Ferrato, (843)706-8059,
Grade Level:        9-12
Length of Course:   1 Year
Credits:            1
Textbook:           Microsoft Office 2003 – Introductory, MicroTypePro software,
                    Microsoft Office software

Course Description: This course of study is designed to teach the student advanced
computer concepts as related to processing data into useful information needed in
business situations by using advanced database, spreadsheet, word processing, and
presentation software capabilities. Because the design of this course is to prepare
students for Microsoft Office Specialist (MOS) Certification, the emphasis is on the
advanced components of the Microsoft Office software. The student will be able to
successfully complete the standards necessary for MOS Certification for Access 2003,
PowerPoint 2003, Word 2003 and Excel 2003.

ATTENDANCE: Students are expected to be present and punctual for all scheduled
classes and labs. Students must be present 170 days out of 180 schools days (85 out
of 90 A-Days). All work missed due to absence must be turned in within two school
days after absents for credit.

GRADING: Each student will be graded in the following three categories:

        Classwork   50%           Tests               30%           Work Ethic     20%


Grade               Range
A                   93%+
B                   85-92%
C                   78-84%
D                   70-77%
F                   0-69%

CLASSROOM ETIQUETTE: Please show courtesy to the class by restricting
conversation to in-class topics, and raise your hand to gain attention when asking a
question or raising a point of discussion.


TURNING IN WORK: Be sure to include your name, class period and the date on all
work to be turned in. Place it in the proper bin for class. DO NOT HAND WORK TO

LATE COURSEWORK: All assignments are to be turned in on the due date. Late work
may be accepted at the instructor’s discretion.

UNITS OF INSTRUCTION: The units of instructions are derived from the state
competencies and the schools scope and sequence. I will monitor and adjust the units
of instruction throughout the year based on students’ previous knowledge and their
ability to master the objectives. Supplemental materials will be added as needed to
reinforce the standards and competencies. Levels of instruction will be monitored and
review for student performance. Basic skills will be added to units as needed. All
students will have equal opportunity for success in my classroom.

Unit I:            Keyboarding / Windows Review                       Time: 5 weeks

Resources/Materials:      Textbook, Microsoft Office software, MicroTypePro software
Unit Objectives:
    Each student will set a word per minute typing goal above 25 words per minute.
    Learn and be able to use correct terminology for the computer in business
    Learn and develop a level of proficiency with Microsoft windows, including file
         Explain steps in the information processing              Describe the steps in purchasing a personal
          cycle.                                                    computer.
         Identify and explain the components of a                 Demonstrate both cold and warm boots.
          computer system.                                         Define path, prompt, root directory, sub-
         Categorize software according to function                 directory, and wildcard.
          (system and application).                                Identify basic functions and terminology
         Identify functions of input/output devices.               associated with operating systems and system
         Categorize storage as primary or secondary.               software (such as boot, MacIntosh, MS
         Define basic computer terminology (hardware,              Windows, multitasking, GUI, icon, WYSIWYG,
          software, program, pixel, resolution, binary,             mouse, minimize, and maximize).
          RAM, ROM, bit, and byte).                                Define characteristics of LANs, WANs, and
         Identify characteristics and limitations of various       MANs.
          computers based on size and capabilities.                Identify network hardware components.
         List examples of computer use in business,
          education, government, industry, and the home.
         Identify terms commonly found in personal
          computer advertisements.
Unit II:                Word Processing                               Time: 8 weeks

Resources/Materials:       Textbook, Microsoft Office software
Unit Objectives:
    Learn and become proficient with different components of desktop publishing.
      This will include working with clip art and other various forms of graphics.
    Learn and become proficient at producing professional documents including
      multiple page flyers and newsletters.
    Understand and become proficient using the mail merge feature.
      Use the Undo, Redo, and Repeat                      Insert page numbers.
       command.                                            Set page orientation.
      Apply font formats (bold, italics, and              Set margins.
       underline).                                         Use GoTo to locate specific elements in a
      Use the SPELLING feature.                            document.
      Use the THESAURUS feature.                          Create and modify page numbers.
      Use the GRAMMAR feature.                            Create and modify headers and footers.
      Insert page breaks.                                 Align text vertically.
      Highlight text in document.                         Create and use newspaper columns.
      Insert and move text.                               Revise column structure.
      Cut, copy, paste, and paste special using           Prepare and print envelopes and labels.
       the clipboard.                                      Apply styles.
      Copy formats using the Format Painter.              Create sections with formatting that differs
      Select and change font and font size.                from other sections.
      Find and replace text.                              Use click and type.
      Apply character effects (superscript,               Use save.
       subscript, strikethrough, small caps, and           Locate and open an existing document.
       outline).                                           Use Save As (different name, location, or
      Insert date and time.                                format).
      Insert symbols.                                     Create a folder.
      Create and apply frequently used text with          Create a new document using a wizard.
       AutoCorrect.                                        Save a document as a Web page.
      Align text in paragraphs (center, left, right,      Use templates to create a new document.
       and justified).                                     Create hyperlinks.
      Add bullets and numbering.                          Use the Office Assistant.
      Set character, line, and paragraph                  Send a Word document via e-mail.
       spacing options.                                    Create and format tables.
      Apply borders and shading to paragraphs.            Add borders and shading to tables.
      Use indentation options (left, right, first         Revise tables (insert and delete rows and
       line, and hanging).                                  columns, and change cell formats).
      Use TABS command (center, decimal,                  Modify table structure (merge cells and
       left, and right).                                    change height and width).
      Create an outline style numbered list.              Rotate text in a table.
      Set tabs with leaders.                              Use the drawing toolbar.
      Use print preview.                                  Insert graphics into a document (WordArt,
      Print a document.                                    clip art, and images).
      Use Web Page Preview.
      Navigate through a document.
Unit III:      Spreadsheet                                   Time: 8 weeks

Resources/Materials:     Textbook, Microsoft Office software
Unit Objectives:
    Learn advanced formulas and functions
    Learn to create charts
    Learn advanced formatting techniques
      Use Undo and Redo.                                 Set page margins and centering.
      Clear cell content.                                Insert and remove a page break.
      Enter text, dates, and numbers.                    Set print and clear a print area.
      Edit cell content.                                 Set up headers and footers.
      Go to a specific cell.                             Set print titles and options (gridlines, print
      Insert and delete selected cells.                   quality, and row and column
      Cut, copy, paste, paste special, and move                    headings).
       selected cells; use the Office Clipboard.          Insert and delete rows and columns.
      Use Find and Replace.                              Hide and unhide rows and columns.
      Clear cell formats.                                Freeze and unfreeze rows and columns.
      Work with series (AutoFill).                       Change the zoom setting.
      Create hyperlinks.                                 Move between worksheets in a workbook.
      Use Save.                                          Check spelling.
      Use Save As (different name, location, and         Rename a worksheet.
       format).                                           Insert and delete worksheets.
      Locate and open an existing workbook.              Move and copy worksheets.
      Create a folder.                                   Link worksheets and consolidate data
      Use templates to create a new workbook.             using 3D References.
      Save a worksheet/workbook as a Web                 Enter a range within a formula by
       page.                                               dragging.
      Send a workbook via E-mail.                        Enter formulas in a cell, and use the
      Use the Office Assistant.                           formula bar.
      Apply font styles (typeface, size, color, and      Revise formulas.
       styles).                                           Use references (absolute and relative).
      Apply number formats (currency, percent,           Use AutoSum.
       dates, and comma).                                 Use Paste Function to insert a function.
      Modify size of rows and columns.                   Use basic functions (AVERAGE, SUM,
      Modify alignment of cell content.                   COUNT, MIN, and MAX).
      Adjust the decimal place.                          Enter functions using the formula palette.
      Apply AutoFormat.                                  Use date functions (NOW and DATE).
      Use the Format Painter.                            Use financial functions (FV and PMT).
      Apply cell borders and shading.                    Use logical functions (IF).
      Merge cells.                                       Preview and print charts.
      Rotate text and change indents.                    Use chart wizard to create a chart.
      Define, apply, and remove a style.                 Modify charts.
      Preview and print worksheets and                   Insert, move, and delete an object
       workbooks.                                          (picture).
      Use Web Page Preview.                              Create and modify lines and objects.
      Print a selection.
      Change page orientation and scaling.
Unit IV:       Database                                       Time: 4 weeks

Resources/Materials:     Textbook, Microsoft Office software
Unit Objectives:
    Learn formatting techniques for accessing data in a database
    Learn the concepts behind a relational database

      Determine appropriate data inputs for a              Navigate through records in a table,
       database.                                             query, or form.
      Determine appropriate data outputs for a             Create a database (using a wizard or in
       database.                                             Design View).
      Create table structure.                              Create tables by using the Table Wizard.
      Establish table relationships.                       Set primary keys.
      Use the Office Assistant.                            Modify field properties.
      Select an object using the Objects Bar.              Use multiple data types.
      Print database objects (tables, forms,               Modify tables using Design View.
       reports, and queries).                               Use the Lookup Wizard.
                                                            Use the input mask wizard.

Unit V:        Presentation Software                          Time: 8 weeks

Resources/Materials:      Textbook, Microsoft Office software
Unit Objectives:
    Focus on components of PowerPoint a business or organization would need like
      tables and organization charts.
    Learn how to jump, skip, and merge different presentations
    Develop a level of proficiency delivering presentations before an audience
      Create a presentation from a template                 Create a text box for entering text.
       and/or a wizard.                                      Use the wrap text in text box feature.
      Create a blank presentation.                          Promote and demote text in slide and
      Create a specified type of slide.                      outline panes.
      Navigate among different views (slide,                Add a picture from the ClipArt Gallery.
       outline, sorter, and tri-pane).                       Apply formatting.
      Delete slides.                                        Scale and size an object including clip
      Change the order of slides using Slide                 art.
       Sorter view.                                          Add slide transitions.
      Change the layout for one or more                     Animate text and objects.
       slides.                                               Preview presentation in black and white.
      Modify slide sequence in the outline                  Print slides in a variety of formats.
       pane.                                                 Start a slide show on any slide.
      Apply a design template.                              Use screen navigation tools.
      Check spelling.                                       Save changes to a presentation.
      Change and replace text fonts                         Save as a new presentation.
       (individual slide and entire presentation).           Use Office Assistant.
      Enter text in tri-pane view.
      Change the text alignment.
Unit VI:     Integration / Review / MOS Test          Time: 3 weeks

Resources/Materials:      Textbook, Microsoft Office software
Unit Objectives:
    Use skills learned from the 4 different types of software to produce an integrated
    Use practice software to review for MOS Test
    Produce documents integrating word processing, spreadsheet, database, and/or
      presentation files.
    Apply problem solving and critical thinking skills to projects and/or simulations.

To top