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