BCIS 1305
BUSINESS COMPUTER APPLICATIONS

Western Texas College

  1. Basic Course Information
    1. Course Description: Introduces and develops foundational skills in applying essential and emerging business productivity information technology tools. The focus of this course is on business productivity software applications, including word processing, spreadsheets, databases, presentation graphics, data analytics, and business-oriented utilization of the internet. (BCIS 1305 is included in the Business Field of Study.)
    2. Required Prerequisite: None
  2. Student Learning Outcomes
    1. Describe the fundamentals of information technology concepts – hardware, software, security, and privacy.
    2. Demonstrate proper file management techniques to manipulate electronic files and folders in local, network, and online environments.
    3. Create business documents with word processing software using spelling and grammar check, format and layout, tables, citations, graphics, and mail merge.
    4. Create business documents and analyze data with spreadsheet software using (1) tables, sorting, filtering, charts and graphics, pivot tables, macros; (2) statistical, financial, logical and look-up functions and formulas; and (3) add-ins.
    5. Create business multimedia presentations with presentation software using templates, lists, groups, themes, colors, clip art, pictures, tables, transitions, animation, video, charts, and views.
    6. Create databases and manage data with database software using tables, fields, relationships, indexes, keys, views, queries, forms, reports, and import/export functions.
    7. Integrate business software applications.
    8. Use web-based technologies to conduct ethical business research.
    9. Use “goal seeking” and “what-if analysis” to solve problems and make adjustments/recommendations in a business environment.
  3. Testing Requirements
    1. The final exam must be proctored. (ask your instructor for more details)
    2. Students will be allowed to use the one sheet study sheet provided by instructor for the final exam
  4. Major Course Requirements
    1. Lab Assignments          45%
    2. Attendance                    20%
    3. Final                              35%
  5. Information on Books
    1. Required Book: MyLab IT with Pearson eText --  Access Card -- for Exploring Microsoft Office 2019 ISBN 9780135402467
  6. Other Policies, Procedures and important dates. Please refer to the WTC Catalog for the following:
    1. Campus Calendar
    2. Final Exam Schedule
    3. How to drop a class
    4. Withdrawal Information
    5. Student Conduct/Academic Integrity
    6. Class Attendance
    7. Student with disabilities
  7. Course Content

***Disclaimer: Assignments due to change by instructor

 

Chapter Description

Activity

 

Logon instructions for MYITLAB & getting started with labs

 

 

Hardware, File Management, Computer Security

Videos, Exams

Chapter 1

Exploring Office: Word

Assignments, Exams

Chapter 2

Exploring Office: Word

Assignments, Exams

Chapter 3

Exploring Office: Word

Assignments, Exams

Chapter 1

Exploring Office: Excel

Assignments, Exams

Chapter 2

Exploring Office: Excel

Assignments, Exams

Chapter 3

Exploring Office: Excel

Assignments, Exams

Chapter 1

Exploring Office: Access

Assignments, Exams

Chapter 2

Exploring Office: Access

Assignments, Exams

Chapter 3

Exploring Office: Access

Assignments, Exams

Chapter 1

Exploring Office: PowerPoint

Assignments, Exams

Chapter 2

Exploring Office: PowerPoint

Assignments, Exams

Chapter 3

Exploring Office: PowerPoint

Assignments, Exams

Review

 

Review for Final

Final

 

Final Exam

 

 

Last Modified: August 19, 2019