BCIS-1305 Business Computer Applications


Jon-Mikel Pearson

Credit Summer 2024


Section(s)

BCIS-1305-006 (79647)
LEC DIL ONL DIL

LAB DIL ONL DIL

Course Requirements

Course Description:  Computer terminology, hardware, software, operating systems, and information systems relating to the business environment will be covered.  The course will explore business applications of software, including spreadsheets, presentation graphics, word processing, and business-oriented utilization of the Internet. The course will also offer an introduction and utilization of artificial intelligence (AI) in an educational environment, including the history of and proper ethical and legal uses.

 

Pre-requisite:  E-Reading and Writing.

 

Instructional Methodology:  This course will have assignments on both the CONNECT and SIMNET sites each week including an online Smartbook text. All of the assignments are accessible from Blackboard under the link CONNECT/SIMNET assignments. You need to initially pair your Blackboard ID with both the CONNECT and SIMNET McGraw-Hill website - instructions are in Blackboard. The SIMNET assignments will be based on Microsoft Office (MS Word, MS Excel, MS Power Point). Please connect into the online classroom with a laptop or computer that you will be able to also work on your SIMNET for all projects in the Office 365 product suite (available free from ACC during your time as a student at ACC).

 

To Download Microsoft 365: https://instruction.austincc.edu/students/article/office-365-steps/

 

Course Rationale:  This course is designed to teach students the theoretical approach to information technology and management information systems within a business/computer science environment. Practical business computer applications will emphasize word processing, spreadsheets, databases, presentation software, and electronic commerce of the Internet.  Since this course is designed to transfer into a bachelor’s degree program, check with your degree plan as to what business computer courses the transferring college requires.

 


Student Learning Outcomes/Learning Objectives

Course Objectives/Learning Outcomes:

  1. Recognize the concepts and terminology used in the development, implementation, and operation of business application systems.
  2. Explore various methods that Information Technology can be used to support existing businesses and strategies.
  3. Investigate emerging technology in shaping new processes, strategies, and business models.
  4. Use productivity/application software to enhance business activities.
  5. Accomplish projects utilizing business theories, Internet resources, and computer technology.
  6. Work with simple design and development tasks for the main types of business information systems.
  7. Develop an advanced information technology skill, focusing on office productivity software with emphasis on spreadsheet, database, and presentation software.
  8. Develop advanced techniques for use in data analysis and decision-making using electronic spreadsheets and databases.
  9. Recall the fundamental concepts of artificial intelligence, including its definition and key components.
  10. Analyze ethical and legal implications associated with AI technologies, including issues related to privacy, bias, and job displacement and its use in education.
  11. Integrate various AI tools into Microsoft Office software used for word processing and presentation software.

Readings

COURSE SUBJECTS

 

Smart Book - Business Driven IS 8e, By Baltzan (referred to as SB)

Chapter 1 – Management Information Systems: Business Driven MIS

Chapter 2 – Decisions and Processes: Value Driven Business

Appendix A – Hardware and Software Basics

Chapter 3 – Ebusiness: Electronic Business Value

Chapter 4 – Ethics and Information Security: MIS Business Concerns

Chapter 5 – Infrastructures: Sustainable Technologies

Appendix C – Designing Databases (Complementary Reading)

Chapter 6 – Data: Business Intelligence

Appendix B – Networks and Telecommunications (Complementary Reading)

Chapter 7 – Networks: Mobile Business

Chapter 8 – Enterprise Applications: Business Communications

Chapter 9 – Systems Development and Project Management: Corporate

 

MS Office 2021 SIMbook – A Skills Approach

Word 2021:

     Chapter 1 - Getting Started with Word 2021

 

PowerPoint 2021:

     Chapter 1 - Getting Started with PowerPoint 2021

 

Excel 2021:

     Chapter 1 - Getting Started with Excel 2021

Chapter 2 - Formatting Cells

Chapter 3 - Using Formulas and Functions

Chapter 4 - Formatting Worksheets and Managing the Workbook

Chapter 5 - Adding Charts and Analyzing Data

Chapter 6 - Exploring Advanced Functions

Chapter 7 - Exploring Advanced Charts and Graphics

Chapter 8 - Exploring Advanced Data Analysis

Chapter 9 - Importing Data, Reviewing, and Finalizing the Workbook

Chapter 10 - Working with Macros

 

Artificial Intelligence:

Concepts and Theories:

            What is Artificial Intelligence (AI)?

            History of AI.

            Examples of AI.

            Legal and Ethical implications of AI.

            Educational uses for AI.

 

Applications:

            How to use ChatGPT.

            What is Iterative Prompt Engineering?

                   How to use generative AI with Microsoft office applications.


Course Subjects

WEEK READINGS (SB = Smart Book) ACTIVITIES, ASSESSMENTS, &  CONCEPT QUIZ (CQ) 
1 Orientation


Chapter 1 (SB)
Pre-Assessment Competency 1 for CONNECTand SIMNET
Orientation Exam, CONNECT Orientation,SIMNET Orientation
CONNECT: CQ1: Ch1, SB, Excel 1:
Simulation & Quiz 
2 Chapter 2 (SB) CONNECT: CQ2: Ch2, SB
Excel 2: Simulation & Quiz 
3 Appendix A (SB) CONNECT: CQ3: App A, SB
Excel 3: Simulation, Quiz, & Project (1) 
Chapter 3 (SB) CONNECT: CQ4: Ch3, SB
Excel 4: Simulation & Quiz 
4 SIMNET Homework Excel 5: Simulation & Quiz (5) 
Exam 1: App AChapters 1 – 3  Exam 1 
Chapter 4 (SB) Pre-Assessment Competency 2 for CONNECTand SIMNET
CONNECT: CQ5: Ch4, SB
Excel 6: Simulation & Quiz (6) 
Chapter 5 (SB)  CONNECT: CQ6: Ch5, SB
Excel 7: Simulation, Quiz, & Project (2) 
Appendix C (SB)  CONNECT: CQ7: App C 
CONNECT: CQ8: Ch6, SB
Chapter 6 (SB)  Excel 8: Simulation, Quiz, & Project (3)
Excel 9: Simulation & Quiz
7 Exam 2: App CChapters 4 – 6  Exam 2 
SIMNET Homework Excel 10: Simulation & Quiz
Word 1: Simulation, Quiz, & Project (4) 
PP 1: Simulation, Quiz, & Project (5) 
8 Appendix B Pre-Assessment Competency 3 for CONNECT and SIMNET

CONNECT: CQ9: App B 
CONNECT: CQ9: App B 
Chapter 7 


Chapter 8
CONNECT: CQ10: Ch7, SB
Access 1: Simulation & Quiz
CONNECT:CQ11: Ch8, SB
Access 2: Simulation & Quiz
9 Chapter 9 (SB) CONNECT: CQ12: Ch9, SB
Access 3: Simulation & Quiz
Access 4: Simulation & Quiz
Exam 3: App B Chapters 7 – 9  CONNECT Exam 3 - Available Now
ApplicationAssessment (FinalExam)  SIMNET Application Exam (Word, PowerPoint, Excel, Access (available after 7/23/24)
AI Slides 1, 2, 2a_1, and 3 Artificial Intelligence Quiz
AI - Apply it!! - Prompt Engineering
AI - Apply it!! - PowerPoint with ChatGPT
Artificial Intelligence - Lab

Office Hours


Published: 05/14/2024 08:57:16