Computer application to business course outline

Total Hours: 157.5

III. CATALOG DESCRIPTION

Introduction to the concepts and skills required for using computer applications for business. Includes fundamental concepts of hardware, the operating system, and the most frequently used office applications: word processing, electronic spreadsheet, database management, presentations, web browsers, and email.

IV. STUDENT LEARNING OUTCOMES

Upon completion of this course, a student will be able to:

  1. Describe basic computer concepts, components, and computer terminology.
  2. Evaluate the purpose and function of an operating system.
  3. Use a web browser to access online resources and cloud-based applications.
  4. Compose professional documents, spreadsheets, databases, and presentations using Microsoft applications.
  5. Create and send e-mail messages; receive and read e-mail messages.

V. CONTENTS

  1. Essential computer concepts
    1. Types of computers
    2. Computer system components
      1. Hardware and software
      2. Motherboard and processor
      3. Input and output
      4. Types of memory
      5. Types of storage media
      6. Personal computer slots and ports
      1. System software
      2. Application software
      1. Windows basics
        1. Start and shut down
        2. Mouse navigation
        3. Parts of a window
        4. Command buttons, menus, and dialog boxes
        1. Files and folders
        2. File and folder views
        3. Open, edit, and save
        4. File duplication and relocation
        5. File search
        6. File deletion and restoration
        1. Web page navigation
          1. Elements of the browser window
          2. URLs, hyperlinks, and command buttons
          3. Tabbed browsing
          4. Bookmarks
          5. Browser security and privacy
          1. Popular search engines
          2. Keywords
          1. Document design
            1. Word processing software
            2. Microsoft Word window
            3. Start and save
            4. Text selection and formatting
            5. Document templates
            6. Document navigation
            1. Cut, copy, and paste
            2. Spelling and grammar
            3. Research
            4. Hyperlinks
            1. Fonts
            2. Line and paragraph spacing
            3. Tabs
            4. Bullets and numbering
            5. Borders and shading
            6. Graphics
            7. Document margins
            8. Sections and columns
            9. Page breaks and page numbers
            10. Headers and footers
            11. Tables
            12. Footnotes and endnotes
            13. Citations and bibliographies
            1. Worksheet design
              1. Spreadsheet software
              2. Formulas
              3. Labels and values
              4. Cell entries
              5. Print options
              6. Cell formatting
              7. Conditional formatting
              1. Complex formulas
              2. Functions
              3. Relative and absolute cell references
              1. Chart planning
              2. Chart design and format
              3. Chart annotations
              1. Database design
                1. Relational databases
                2. Tables and data entry
                1. Query design
                2. Sort, find, and filter
                3. Query criteria
                1. Types of forms
                2. Form controls
                3. Calculations
                4. Graphics
                1. Types of reports
                2. Group and sort
                3. Subtotals and counts
                4. Report controls
                5. Report formatting
                6. Mailing labels
                1. Presentation design
                  1. Presentation planning
                  2. Text entries
                  3. Design themes
                  1. Shapes and graphics
                  2. Charts
                  3. Tables
                  1. Slide transitions and timings
                  2. Animation
                  1. Parts of an email address
                  2. Benefits of an email address book
                  3. Write and send
                  4. Receive and reply
                  5. Email folders
                  6. Email attachments
                  7. Good email practices
                  1. Assignments
                    1. In-class activity: Participation in instructor-led demonstrations of software skills covered in textbook chapters, such as: add bullets and numbering to paragraphs, and create a one-to-many relationship between two database tables
                    2. In-class activity: Written concepts quizzes with questions that assess the student's knowledge and comprehension of concepts and terminology, such as: give an example of an output device, and list examples of Web browser programs
                    3. In-class activity: Case study projects that extend and expand on the skills learned within textbook chapters, such as: create worksheets to analyze data from various divisions of a company, and prepare a sales presentation for a travel company
                    4. Out-of-class assignment: Completion of textbook assignments that measure the student's ability to use business software to professional standards, such as: design an advertising flyer, and create a database to track membership in a community service club
                    5. Out-of-class assignment: Final capstone project which assesses the student's cumulative knowledge of skills and techniques for each application by completing professional business documents, such as: prepare a quarterly marketing report for a retail store, and develop a six-month budget to evaluate how profits are affected when changes are made to projected revenues and expenses
                    1. Written work: Textbook projects that evaluate the student's knowledge of skills presented in each chapter, such as creating a promotional flyer in Microsoft Word, a worksheet and chart in Microsoft Excel, and a business presentation using Microsoft PowerPoint.
                    2. Written work: Case study projects that prepare students to complete typical business documents, such as business reports, databases, and emails.
                    3. Exams/Quizzes/Tests: Online exams to evaluate skill attainment for each chapter that demonstrate compose professional documents, spreadsheets, databases, and presentations using Microsoft applications.
                    4. Final Assessment: Final capstone projects covering cumulative skills learned throughout the entire textbook such as explaining basic computer concepts, components, and computer terminology; evaluating the purpose and function of an operating system; using a web browser to access online resources and cloud-based applications.
                    1. David Beskeen, Carol M. Cram, Jennifer Duffy, Lisa Friedrichsen, Lynn Wermers. 2020. Illustrated Microsoft Office 365 & Office 2019 Introductory , 1st Edition. Cengage Learning.
                    2. Computer loaded with Microsoft Office professional software suite and access to the Internet

                    VII. TITLE 5 CLASSIFICATION
                    CREDIT/DEGREE APPLICABLE (meets all standards of Title 5. Section 55002(a))

                    Generated on: 9/16/2024 4:35:01 PM