BCIS-1305 Business Computer Applications
Ralph Hooper
Credit Fall 2024
Section(s)
BCIS-1305-018 (89107)
LEC MW 10:55am - 12:10pm DIL DLS DIL
LAB MW 12:10pm - 12:40pm DIL DLS DIL
Course Requirements
Grading Policy
The final course grade will be assigned based both on concepts and practical application. Concepts Smart Books (SB), quizzes, & exams, labs (simulations, quizzes, & projects), and the Application Exam will each be a part of the grade. An overall grade will be assigned on the following grading scale:
|
Percentages |
Grades |
|---|---|
|
90% - 100% |
A |
|
80% - 89% |
B |
|
70% - 79% |
C |
|
60% - 69% |
D |
|
0% - 59% |
F |
|
Assignments |
Percentages |
|---|---|
|
3 – Concepts Exams #1 (Chapter 1 – 3, Appendix A) 15% #2 (Chapter 4 – 6) 15% #3 (Chapter 7 – 9) 15% |
45% |
|
Labs/Simulations (16) and Quizzes (16) |
15% |
|
Lab Projects (5) |
15% |
|
Application Assessment (MUST BE TAKEN TO PASS CLASS!) |
10% |
|
Smart Books (10) / Concepts Quizzes (CQ) (10) |
15% |
|
Total |
100% |
Course Subjects
Business Driven IS 8e, By Baltzan
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
Chapter 6 – Data: Business Intelligence
Chapter 7 – Networks: Mobile Business
Chapter 8 – Enterprise Applications: Business Communications
Chapter 9 – Systems Development and Project Management: Corporate
MS Office SIMbook – A Skills Approach
Word:
Word - Chapter 1 - Getting Started With Word
PowerPoint:
PowerPoint - Chapter 1 - Getting Started with PowerPoint
Excel:
Excel - Chapter 1 - Getting Started with Excel
Excel - Chapter 2 - Formatting Cells
Excel - Chapter 3 - Using Formulas and Functions
Excel - Chapter 4 - Formatting Worksheets and Managing the Workbook
Excel - Chapter 5 - Adding Charts and Analyzing Data
Excel - Chapter 6 - Exploring Advanced Functions
Excel - Chapter 7 - Exploring Advanced Charts and Graphics
Excel - Chapter 8 - Exploring Advanced Data Analysis
Excel - Chapter 9 - Importing Data, Reviewing, and Finalizing the Workbook
Excel - Chapter 10 - Working with Macros
Access:
Access - Chapter 1 - Getting Started with Access
Access - Chapter 2 - Working with Tables
Access - Chapter 3 - Working with Forms and Reports
Access - Chapter 4 - Using Queries and Organizing Information
Student Learning Outcomes/Learning Objectives
Course Objectives/Learning Outcomes:
- Gain familiarity with 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.
- Achieve hands-on experience with 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 spreadsheet and databases.
SCANS (Secretary’s Commission on Achieving Necessary Skills):
The following list summarizes the SCANS competencies addressed in this particular course:
|
RESOURCES 1.1 Manages Time |
INTERPERSONAL |
INFORMATION 3.1 Acquires and Evaluates Information 3.2 Organizes and Maintains Information 3.3 Uses Computers to Process Information |
SYSTEMS 4.1 Understands Systems 4.2 Monitors and Corrects Performance |
|
TECHNOLOGY 5.1 Selects Technology 5.2 Applies Technology to Task |
BASIC SKILLS 6.1 Reading 6.5 Listening |
THINKING SKILLS 7.2 Decision Making 7.3 Problem Solving 7.4 Mental Visualization 7.5 Knowing How to Learn 7.6 Reasoning |
PERSONAL SKILLS 8.1 Responsibility 8.2 Self-Esteem 8.3 Sociability 8.4 Self-Management 8.5 Integrity/Honesty |
Schedule
|
Week |
Date |
Lecture SmartBooks (SB) |
Laboratory Activities/Projects Concept Quiz (CQ) |
Ideal Completion Dates |
|
1 |
8/26 |
Orientation |
Excel 1: Simulation & Quiz |
9/1 |
|
2 |
9/2 |
Chapter 1 (SB) |
CQ1: Ch1 Excel 2: Simulation & Quiz |
9/8 |
|
3 |
9/9 |
Chapter 2 (SB) |
CQ2: Ch2 Excel 3: Simulation, Quiz, Project (1) |
9/15 |
|
4 |
9/16 |
Appendix A (SB) |
CQ3: App A Excel 4: Simulation & Quiz |
9/22 |
|
5 |
9/23 |
Chapter 3 (SB) |
CQ4: Ch3 Excel 5: Simulation & Quiz |
9/29 |
|
6 |
9/30 |
Exam 1: App A Chapters 1 – 3 |
Excel 6: Simulation & Quiz |
10/6 |
|
7 |
10/7 |
Chapter 4 (SB) |
CQ5: Ch4 Excel 7: Simulation, Quiz, Project (2) |
10/13 |
|
8 |
10/14 |
Chapter 5 (SB) |
CQ6: Ch5 Excel 8: Simulation, Quiz, Project (3) |
10/20 |
|
9 |
10/21 |
Chapter 6 (SB) |
CQ7: Ch6 Excel 9: Simulation & Quiz |
10/27 |
|
10 |
10/28 |
Exam 2: Chapters 4 – 6 |
Excel 10: Simulation & Quiz |
11/3 |
|
11 |
11/4 |
|
Word 1: Simulation, Quiz, Project (4) PP 1: Simulation, Quiz, Project (5) |
11/10 |
|
12 |
11/11 |
Chapter 7 (SB) |
CQ8: Ch7 Access 1: Simulation & Quiz |
11/17 |
|
13 |
11/18 |
Chapter 8 (SB) |
CQ9: Ch8 Access 2: Simulation & Quiz |
11/24 |
|
14 |
11/25 |
Chapter 9 (SB) |
CQ10: Ch9 Access 3: Simulation & Quiz |
12/1 |
|
15 |
12/2 |
Exam 3: Chapters 7 – 9 |
Access 4: Simulation & Quiz |
12/8 |
|
16 |
12/9 |
-------- |
Application Exam (Word, PowerPoint, Excel, Access) |
EVERYTHING MUST BE COMPLTED BY SUNDAY Dec 15, 2024 @ 11:59 pm |
This schedule is intended to give the student guidance on what may be covered during the semester and will be followed as closely as possible. However, the professor reserves the right to modify, supplement and make changes as needs arise.
Instructor Information
Professor Ralph E. Hooper
Office Phone: 512-223-2599
Office Location: Room 1300.25 San Gabriel Campus
Virtual Office Hours: Mon & Wed 1:00 pm -- 3:30 pm via Zoom (email for appt.)
ACC email: ralph.hooper@austincc.edu -- Zoom will be available for meetings
Instructor Website: https://hooper.accprofessors.com/
Instructor Bio: I have been teaching at the college level for over 35 years in both mathematics and computer science. My research interests are computational thinking and educational technology. I enjoy travel and baseball.
Office Hours
M W 1:00 PM - 3:30 PM online via Zoom
NOTE email for an appointmentPublished: 08/26/2024 11:42:04