Department:    BMT

 Course #:    121

 Credits:    5

 Variable:     No

 Course Description  

Strategic use of software applications to create a business image and competitive advantage. Create brochures, flyers, and business cards using Microsoft Publisher. Set up a customer database using Microsoft Access and merge information using Microsoft Word. Create spreadsheets in Microsoft Excel to analyze financial business scenarios. Create simple Web pages.

 Prerequisite  

Prerequisite: BMT 120 or department chair approval.

Contact Hours (based on 11 week quarter)

Lecture: 55

Lab: 0

Other: 0

Systems: 0

Clinical: 0

Intent: Distribution Requirement(s) Status:  

Vocational Preparatory Required for ATA degree, Required for certificate  

Equivalencies At Other Institutions

Learning Outcomes

After completing this course, the student will be able to:

1. Describe the strategic use of computer applications in business.
2. Describe the technical infrastructure that supports eBusiness.
3. Save basic Web pages using standard Microsoft office software applications.
4. Define database management system structure and capability.
5. Create business marketing materials using a desktop software application.
6. Use basic systems development procedure to solve business problems.
7. Create a problem solving business applications in Microsoft Excel.
8. Create a relational database system in Microsoft Access.

General Education Learning Values & Outcomes

Revised August 2008 and affects outlines for 2008 year 1 and later.

2. Critical Thinking

Definition: The ability to think critically about the nature of knowledge within a discipline and about the ways in which that knowledge is constructed and validated and to be sensitive to the ways these processes often vary among disciplines.

Outcomes: Students will be able to . . .
2.5 Identify similarities and differences in the ways in which data is collected and analyzed in different disciplines.

3. Communication

Definition: Understanding and producing effective written, spoken, visual, and non-verbal communication.

Outcomes: Students will be able to . . .
3.1 Recognize, read, and comprehend academic and/or professional writing.
3.4 Produce academic and/or professional writing and integrate it into written and spoken projects.
3.6 Recognize, comprehend, and use visual communication appropriate to a given context.

7. Aesthetics & Creativity

Definition: Interpreting human experience through engagement with creative processes and aesthetic principles.

Outcomes: Students will be able to . . .
7.1 Demonstrate an understanding of the creative process.
7.2 Demonstrate knowledge of aesthetic principles.

8. Mathematical Reasoning

Definition: Understanding and applying concepts of mathematics and logical reasoning in a variety of contexts, both academic and non-academic.

Outcomes: Students will be able to . . .
8.1 Analyze problems to determine what mathematical principles apply.
8.2 Correctly apply logical reasoning and mathematical principles to solve problems.
8.3 Interpret information and reasoning expressed mathematically (for example in spreadsheets, diagrams, charts, formulas, etc.).
8.4 Communicate mathematical information effectively.

10. Technology

Definition: Understanding the role of technology in society and using technology appropriately and effectively.

Outcomes: Students will be able to . . .
10.3 Use technology appropriate to the context and task to effectively retrieve and manage information, solve problems, and facilitate communication.

Course Contents

1. Use of technology in creating an integrated business system.
2. Technical infrastructure for eBusiness.
3. Web page development.
4. Database management systems.
5. Creative process in developing marketing materials using Microsoft Publisher.
6. Systems analysis process.
7. Develop complex Excel applications (list management, functions, macros).
8. Creating relational database systems with Microsoft Access.