Page | 1
BUS150 C. Kushida, Fall 2016 1st 8-weeks (#25982)
Course Catalog Information and Learning Outcomes:
Course Title: Introduction to Information Systems and Applications
Name: BUS150
Units: 3
Advisory Reading Level: 3
Subsequent Appropriate Courses: The student will be prepared to take advanced course work in spreadsheets and database.
Platform Software: Blackboard Courseware will house our virtual classroom.
Email: Student provided Catalog Description: Introduction to computer concepts, and management information systems. Application software used to solve business problems. Student Learning Outcomes - Successful students will:
Develop problem solving skills employing pattern recognition, transfer of learning and the ability to evaluate choices among solution techniques.
Recognize when additional information is needed and obtain that material through researching outside sources.
Page | 2
BUS150 Students:
I am excited to begin working with you on what I feel will be the most useful course in your
college career! Though I am a little biased, you will find that you will gain knowledge of
technology in the business world, spreadsheet skills using Excel (even those of you that are
experienced users) and a good understanding of databases. Welcome!
Class Meetings: There is one mandatory orientation meeting for this course. The Final Exam
will be taken on-campus during the date and time stated in the course syllabus.
Textbooks: Three Textbooks are Required
The SAC custom editions have different images and ISBNs. You can obtain the
custom bundled textbooks at the Don Bookstore. This is a brand new textbook, the
publisher editions are not yet available!
Valacich & Schneider
Information Systems Today:
Managing the Digital World
7th Ed. (non-custom ed.ISBN:
978-0133940305)
Gaskin & Vargas
GO! with Microsoft Excel
2016 Introductory
(ISBN not yet available)
Gaskin & McLellan
GO! with Microsoft Access
2016 Introductory
(ISBN not yet available)
1. You must purchase all three textbooks for this course. Access codes will not be used. Please
ignore any publisher references to these.
2. The bookstore sells the texts (with the custom text) bundled at a reduced cost. You can purchase
the texts either in person at the SAC bookstore (Don bookstore) or you can purchase from the
Don bookstore online. If you need to port your files around from home/work/campus, a USB drive
is the way to go! If you are familiar storing files in the cloud, that’s fine too!
Page | 3
COURSE EVALUATION:
Course grades are determined by test results, project scores, and Discussion Board
participation. The Breakdown is as follows:
Final Exam (proctored) 155
Quizzes (7 x 35) 245
Projects (12 x 40)* 480
Discussion Board (8 x 15)* 120
Total points 1000
Final Grading Scale
A 1000 - 900
B 899 - 800
C 799 - 600
D 599 - 500
F 499 - 0
*5 points will be deducted for late work.
Add'l 5 points are deducted for each Mon &
Thurs due date missed.
COURSE POLICIES:
Academic Honesty Policy: You should be familiar with the Academic Honesty Policy at Santa
Ana College. Academic dishonesty or cheating is defined as an intentional act of fraud in which
a student seeks to claim credit for the work or efforts of another without authorization. This
includes assisting other students in acts of dishonesty or coercing students into acts of
dishonesty, whether it is in coursework or on exams. There is absolutely NO tolerance for
cheating in this class. Any student caught cheating or assisting another student in
the act of cheating, will receive a zero score for the assignment or quiz.
Working with another student on an assignment or quiz meant for individual
completion, is considered an act of dishonesty.
Files may not be shared. Your work needs to be your own.
Using other students’ thoughts from the discussion board as your own is considered an
act of dishonesty. Your work and thoughts must be your own.
If you have any questions regarding this policy or application of this policy, please let the
instructor know.
Page | 4
Attendance and Absence Policy: College policy states that a student may be dropped for
non-participation. In this online course students must:
Show attendance by completion of the following by Wednesday of the first
week of classes or they will be dropped:
Attend the mandatory face-to-face meeting.
Complete all items under “Course Information” including the “Orientation
Quiz”
Post their response in Week #1’s discussion board by Wednesday of the
first week of classes
Participate during the course or they will be dropped for non-attendance.
Students must participate in the following ways:
Discussion board posts, online quiz submissions, project submissions or
other online interactions for that week (blogs, wikis, chat).
Projects after the first week of classes must be at least at a 60% rate of project
submittal.
Non-participation is determined when a student has missed in excess of 10% of
the total course activities including but not limited to discussions, projects,
quizzes, etc.
Under extenuating circumstances, a student may be reinstated by the instructor.
Please note that it is ultimately the student's responsibility to drop the class, not the
instructor's. Do not rely on the instructor to drop you if you wish to drop a course. Log on to
WebAdvisor and drop your course.
Accommodations for Disabilities:
Your success in this course is important to me. Santa Ana College and I are committed to
providing reasonable accommodations for all individuals with disabilities. If you have a
disability that may have some impact on your ability to do well in this course, I encourage
you to speak with me as soon as possible. Also, please contact Disabled Student Programs
& Services so that we can all collaborate on your classroom accommodations in a timely
manner. DSP&S is located in VL-203 and their phone number is 714-564-6295. The DSP&S
office requires documentation of your disability in order to receive reasonable
accommodations. If you do not have documentation they will work with you to acquire it. I
look forward to supporting you to meet your learning goals.
Page | 5
ONLINE COURSE PREPARATION:
SAC Student Online Orientation: All students will be required to show that they have
completed the SAC Student Online Orientation.
After Blackboard login you will see “MY
Organizations” and the “SAC Student Online
Orientation”. Select this self-paced
introduction to online learning at Santa Ana
College. At completion, you will be instructed
to save a screenprint of your Passing grade.
Save this file and submit as directed under
“Course Information”.
Blackboard Basics: If you are unsure of your skills using Blackboard, please use the
Blackboard video links under our “Resources” menu item in our course. In this class it is
important that you are familiar with posting and replying on the Discussion board, taking an
online test, submitting an assignment and checking your grades.
TECHNOLOGY REQUIREMENTS:
SOFTWARE:
Microsoft Office: MS EXCEL and ACCESS 2016 will be used for all application projects in
this course. We will be using Excel and Access. If you have an earlier version of M/S Office you
will not be able to complete many of the projects in its entirety.
OPTIONS IF YOU DO NOT HAVE OFFICE 2016:
OFFICE 365: SAC Students are now able to use Office 365 for FREE! This cloud
version of Office is always at the latest MS Office version and contains the Excel
and Access applications among others. You will need to follow the directions at
our District IT website: http://www.rsccd.edu/Departments/Information-
Technology-Services/Pages/Student-Email-Cloud.aspx
You will need Excel and Access for our coursework. For a free Access
download: I am told you need to create your account and when prompted
to download, you need to download "Office Pro" for Access.
However, if you are a mac user, the mac version does not contain Access.
Computer Lab and Library at the college have Office 2016 for you to use (A-
106 and the Nealley Library).
Purchase Microsoft Office 2016. If you prefer to purchase MS Office, you can
purchase it at a student price.
College Buys: http://foundationccc.org/CollegeBuys
Journey Ed: http://www.journeyed.com/fccc
Page | 6
You can purchase software at a student rate from either of the sites above
as a student of one of the California Community Colleges. You will need a
credit card to purchase the software online. Make sure that whatever version of
MS Office your purchase contains Excel and Access as those will be the applications
we will be using in this course.
If you have Excel, but do not have Access 2016, respond to a request that I will
post before we begin our Access project work. I can request a free Access download for
Windows for SAC students shortly before we begin the Access projects. Again, this is
only for Windows systems.
Mac users: MS Office for the Mac 2016 can be used for our Excel projects. However, you
will need to work on a PC for our Access projects. Plan ahead on how you will do this – use
a work computer, a lab/library on-campus computer, parent’s computer, etc. Work ahead,
devote tons of time and get your projects completed early and out of your hair. Warning: I
have not had any student complete the Excel projects using the Excel for Mac software.
The menus and placement of features are different and will not match our textbook. Be
aware and have an alternate plan to complete your projects.
COMPUTERS:
You do not need to come to campus to use the
computer if you have access to a computer with
Internet access and Excel/Access Applications.
However, be aware that should you have a need, you
can use the computers at SAC in the Academic
Computing Center and Library.
Academic Computing Center: Located in the Caesar Chavez Building (A-Bldg, #106).
Access to the lab is with a photo student ID card. There are student assistants available at
the labs. They are there to assist students in general application assistance and general
Windows assistance. They are not tutors and will not do assignments for students. Lab
Hours at SAC.
Neally Library: The Library also has computers for student usage. Library Hours for
computer use can be found at their website and are linked.
COURSE WORK:
Tests: Quizzes are online in our Blackboard course. The Final Exam is proctored on-
campus. For the final exam you will need:
A photo id card, either a Driver’s license or Student ID card will do.
If you do not live in the county, find a proctor in your local area. It can be a local
community college test center. Please contact me if you will need to utilize a test
center other than the one at SAC. I have had students nationally and internationally
take this course successfully online. We can work it out!
Page | 7
Getting Help: The class discussion board is your place for questions concerning the course
and projects. We have forums for general course, Excel and Access questions. Before you
post, try to find the answer to your question. Can’t find it, POST! Anyone can respond. If
you respond with the correct response, you will receive one extra credit point (+1). I
encourage students to post and respond on the discussion board. Like raising your hand in
class, everyone can learn from the question and response. Our discussion board creates a
lively class community and you will all appreciate the help you receive from one another.
If you have a question of a personal nature (e.g. quiz problem, sick, personal question),
please email me.
Email: In this class you must use your own email for our course. You may use your new
SAC email, but you will need to check it. Please assure that the email you have on
WebAdvisor is the one you regularly check! If you do not already have an email account,
this online class probably isn't the class for you. You must be an experienced email and
Internet user to take this course.
ALL email that you send must use the following format in email Subject
Subject: BUS150, Your Name - Subject
Examples: BUS150, Jane Doe, Project question (this is a sample subject line if you have
a particular problem with scoring of this project) BUS150, Jane Doe, Quiz Question (if
you have a question on a quiz)
Email that is not sent with this format will probably automatically go directly into the
"Junk Email" folder and won't be looked at for a long period. To assure that your email is
read/responded to, use the proper email format!
Instructor: Cherylee Kushida - In this course, perhaps more than any other, you should
not hesitate to ask questions! If you are having any trouble getting on the Internet, using
an application, or understanding the material, let me know! Make sure that you get help
right away. Try not to get behind. But, should that happen, contact me and we will work it
out. You can contact/find me at:
E-mail: [email protected] (email is the usually the best way to reach me!)
Office Location: Cesar Chavez Building, A-101
Office hours: Mon & Wed: 8:00am – 9:00am
Office phone: (714) 564-6766 - If I am not available, please leave a message with your
name, class, and a phone number to return your call. The fastest way to reach me is by
email!
A bit about me: I graduated from University of California, Irvine, with a B.S. in
Mathematics and continued my education at Claremont Graduate School with an M.B.A.
in Management Information Systems. I have been teaching full-time at SAC for 20 years
and three years part-time prior to teaching full-time. Before working in education I was a
Systems Engineer at IBM. I worked mainly in the large systems (mainframe) arena and
operating systems. It was a terrific job, but after having children, a more time flexible
career was better suited to my new family lifestyle. I enjoy teaching at SAC and working
with the variety of students here. It is especially rewarding to assist students in
achieving their educational goals! I hope I can help you achieve yours!
Page | 8
BUS150 Online Syllabus – Spring 2016 – 1st 8-week
(#25982)
Week Content Activities Due Date
Week
1
8/22
Make Certain you:
1. Purchase
textbooks
2. Assure
Software/Internet
access for class
3. Get comfortable
with our course
on Bb
4. Contact me if you
have any
questions
whatsover!
View these videos on Blackboard skills you
will need for this course:
Bb Orientation
Discussion Board Submission
Submitting an Assignment
Checking your Grades
Using the Bb Calendar
Logon to Blackboard you’re your
WebAdvisor ID & password
(http://rsccd.blackboard.com)
Read the BUS150 FAQs
Complete the “SAC Online
Student Orientation” (under “My
Organizations”)
Read Suggestions from Prior
Students
Take your Self-Guided Tour
around our BUS150 course
8/23
Attend an Orientation
Monday, 8/22 in A-222 at:
12:00pm – 12:45pm OR
5:00pm – 5:45pm
8/22
Must be completed
or you will be
dropped
Don’t get
Dropped!
Complete all items under “Course
Information”
Complete Orientation “Quiz”
Create thread - Discussion Board
Week #1
8/24
Must be completed
by 8/24 or you will
be dropped
Page | 9
Getting Started in
Excel 2016
* If you have not used Office 2016,
you should begin on page 2 and do, or
read through, the usage of the toolbars
and saving of files in Office, though
page 43.
8/24
Managing in the
Digital World
1. Read Ch 1
2. View Linked Videos
3. Reply to at least 2 classmates in
Discussion Board Week #1
4. Complete Project #1 (Excel)
5. Take Quiz 1
8/29
Week
2
8/29
Gaining Competitive
Advantage Through
Information Systems
1. Read Ch. 2
2. Create thread for Discussion Board
Week #2
3. View Linked Videos
4. Project #2 (Excel)
9/01
1. Reply to at least 2 classmates in
Discussion Board Week #2
2. Take Quiz 2
3. Project #3 (Excel)
9/05
Week
3
9/05
Managing the
Information Systems
Infrastructure and
Services
1. Read Ch. 3
2. Create thread for Discussion Board
Week #3
3. View Linked Videos
4. Project #4 (Excel)
9/08
1. Reply to at least 2 classmates in
Discussion Board Week #3
2. Take Quiz 3
3. Project #5 (Excel)
9/12
Page | 10
Week
4
9/12
Enabling Business-
to-Consumer
Electronic Commerce
1. Read Ch 4
2. Create thread for Discussion Board
Week #4
3. View Linked Videos
4. Project #6 (Excel)
9/15
1. Reply to at least 2 classmates in
Discussion Board Week #4
2. Take Quiz 4
3. Project #7 (Access)
9/19
Week
5
9/19
Enhancing Business
Intelligence Using
Information Systems
1. Read Ch 6
2. Create thread for Discussion Board
Week #5
3. View Linked Videos
4. Project #8 (Access)
9/22
1. Reply to at least 2 classmates in
Discussion Board Week #5
2. Project #9 (Access)
3. Take Quiz 5
9/26
Week
6
9/26
Enhancing Business
Processes Using
Enterprise Systems
1. Read Ch 7
2. Create thread for Discussion Board
Week #6
3. View Linked Videos
4. Project #10 (Access)
9/29
1. Reply to at least 2 classmates in
Discussion Board Week #5
2. Project #11 (Access)
3. Take Quiz 6
10/03
Page | 11
Week
7
10/03
Strengthening
Business-to-
Business
Relationships via
Supply Chain and
Customer
Relationship
Management
1. Read Ch 8
2. Create thread for Discussion Board
Week #7
3. View Linked Videos
4. Project #12 (Access)
10/06
1. Reply to at least 2 classmates in
Discussion Board Week #7
2. Take Quiz 7
10/10
Last Day to turn in
late Projects
Week
8
10/10
Developing and
Acquiring
Information Systems
&
Securing
Information Systems
Final Exam
Preparation
1. Read Ch 9 & 10
2. Create thread for Discussion Board
Week #8
3. View Linked Videos
4. Take Course Survey
10/12
Final Exam
(Ch 9 & 10)
10/13, Thursday: 5:00 – 6:00pm
(A-215)
10/13
Page | 12
BUS150 - Projects # 1 - 12
Excel Project #1
Creating a Worksheet and Charting Data
You will be creating a simple spreadsheet with formulas, functions and
simple formatting and charting.
The text is very good in that it takes you step-by-step through the project... just
make sure to read the text in between the "How to" steps! (You will be "Doing"
all of the steps that have numbers, and reading all of the information between
the steps.) Begin the project on page 51, making sure to read about the
company that we will be using in this chapter.
Note to experienced Excel users: Make sure you follow along with the
textbook, step-by-step. You will be learning some new and quick
short cuts to add to your Excel toolbelt! If I don't see it, that means
you can't do it.
Do Project 1A and Project 1B (p. 57 - 100) and Project 1L (p.122)
Turn In: THREE files (Under "Assignments" - Project #1)
1. Lastname_Firstname_1A_Quarterly_Sales.xlsx
2. Lastname_Firstname_1B_Plyo_Products.xlsx
3. Lastname_Firstname_1L_Video_Sales.xlsx
You must begin with your OWN NEW spreadsheet
* For one extra point and some fun, create this chart for 1L and include it on
the same spreadsheet:
Hint: to create this chart select range A4:A9, hold down the Ctrl key and
select range D4:D9. Both non-adjacent ranges should be selected. Now
insert and create your chart as you did in 1A.
$-
$1,000.00
$2,000.00
$3,000.00
$4,000.00
$5,000.00
$6,000.00
$7,000.00
$8,000.00
$9,000.00
Pilates Step Weight Training Kickboxing Yoga
Total Sales
Page | 13
Excel Project #2
Using Functions, Creating Tables, and Managing Large Workbooks
Our projects are getting larger simply because you'll be learning so much!
In Project #2 you'll be learning how to work with more functions, using Excel as
a table and working with multiple worksheets in a workbook.
Do Project 2A and Project 2B (p. 124 - 165) and Project 2K (p.185)
Turn In: THREE files (Under "Assignments" - Project #2)
1. Lastname_Firstname_2A_Tree_Inventory.xlsx
2. Lastname_Firstname_2B_Weekly_Sales.xlsx
3. Lastname_Firstname_2K_Products.xlsx
Hint: Follow the directions carefully. Use formulas whenever possible. Apply
what you learned in the tutorials! This is similar to 2B.
Excel Project #3
Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools
In Project #3 you'll be learning when to use various charts. There is an art
to selecting the proper type of chart for various types of analysis! Pay
attention to the reasoning behind the chart selections!
Do Project 3A and Project 3B (p. 190 - 223) and Project 3L (p.243)
Turn In: THREE files (Under "Assignments" - Project #3)
1. Lastname_Firstname_3A_Enterprise_Fund.xlsx
2. Lastname_Firstname_3B_Tourism.xlsx
3. Lastname_Firstname_3L_Employment.xlsx
Hint: This is similar to 3A. Read carefully and ask questions if needed on the
discussion board! You must begin with your OWN NEW spreadsheet!
Excel Project #4
Use Financial and Lookup Functions, Define Names, and Validate Data
In Project #4 you'll be using Financial and lookup functions and well as
defining cell names.
Do Project 4A and 4B (p. 246-289) and Project 4L (p. 314.)
Turn In: THREE files (Under "Assignments" - Project #4)
1. Lastname_Firstname_4A_Loan_and_Costs.xlsx
2. Lastname_Firstname_4B_Lookup_Revnue_Report.xlsx
3. Lastname_Firstname_4L_Key_Chains.xlsx
Page | 14
Excel Project #5
Managing Large Workbooks and Using Advanced Sorting and Filtering
In Project #5 you'll be using new formatting techniques with themes and styles
as well as learning to manage large amounts of data using Excel.
Do Project 5A and Project 5B (p. 316 - 354) and Project 5L (p.373)
Turn In: SEVEN files (Under "Assignments" - Project #5)
1. Lastname_Firstname_5A_Class_Schedule.xlsx
2. Lastname_Firstname_5A_Schedule.pdf
3. Lastname_Firstname_5A_Schedule_CSV.csv
4. Lastname_Firstname_5A_Schedule_Webpage.html
5. Lastname_Firstname_5A_Faculty_Contacts_2015.xlsx
6. Lastname_Firstname_5B_Fall_Sections.xlsx
7. Lastname_Firstname_5L_Summer_Sections.xlsx
Excel Project #6
Creating charts, Diagrams, and Templates
In Project #6 you'll be creating more charts and using templates. Learning
good use of templates can save you quite a lot of time.
Do Project 6A and Project 6B (p. 376 - 411) and Project 6L (p.434)
Turn In: FOUR files (Under "Assignments" - Project #6)
1. Lastname_Firstname_6A_Attendance.xlsx
2. Lastname_Firstname_6B_Order_Template.xltx
3. Lastname_Firstname_6B_Topaz_Order.xlsx
4. Lastname_Firstname_6L_Tech_Industry.xlsx
Page | 15
Access Project #7
Databases are tools that many people do not really know how to create or
customize. It is to your distinct advantage to have database skills in today's job
market.
Getting Started with Access Databases
In Project #7 you'll be learning database design and basics.
Do Project 1A and Project 1B (p. 58 - 108) and Project 1L (p.135)
Turn In: THREE files (Under "Assignments" - Project #7)
1. Lastname_Firstname_1A_Advising.accdb
2. Lastname_Firstname_1B_Student_Workshops.accdb
3. Lastname_Firstname_1L_Student_Clubs.accdb
Access Project #8
Sort and Query a Database
You'll be learning to create table relationships and queries. Queries are the cornerstone of database work. Afterall, with your data housed in a database, you want to know all of the best methods to extract you data efficiently.
Do Project 2A and Project 2B (p. 138 - 190) and Project 2L (p.219)
Turn In: 3 files (Under "Assignments" - Project #8)Con
1. Lastname_Firstname_2A_Instructors_Courses.accdb
2. Lastname_Firstname_2B_Athletes_Scholarships.accdb
3. Lastname_Firstname_2L_Coaches.accdb
Access Project #9
Forms, Filters, and Reports
Forms are used to input data. Whenever you fill out an online questionnaire,
email form, etc, you're completing a form. This data goes directly into a
database.
Reports are formatted output in Access. The queries are requested output as well, but you are not able to format the page in a nice output format for public distribution.
Do Project 3A and Project 3B (p. 222 - 267) and Project 3L (p.296)
Turn In: 3 files (Under "Assignments" - Project #9)
1. Lastname_Firstname_3A_Students_Majors.accdb
2. Lastname_Firstname_3B_Job_Openings.accdb
3. Lastname_Firstname_3L_Food_Services.accdb
Page | 16
Access Project #10
Enhancing Tables
You're becoming better acquainted with Access. Now, it's time to get a bit more
in- depth in creating relationships and validating data.
Do Project 4A and Project 4B (p. 298 - 340)
Turn In: FOUR files (Under "Assignments" - Project #10)
1. Lastname_Firstname_4A_GG_Directory_2015-08-22.accdb (date will vary)
2. Lastname_Firstname_4A_GG_Directory.accdb
3. Lastname_Firstname_4A_GG_Employees.accdb
4. Lastname_Firstname_4B_IT_Workload.accdb
Access Project #11
Enhancing Queries
Let's get more advanced in our queries usage! Learn how to use queries, not only
to extract data, but to help you do large tasks universally within your database!
Do Project 5A and Project 5B (p. 364 - 405)
Turn In: TWO files (Under "Assignments" - Project #11)
1. Lastname_Firstname_5A_Store_Inventory.accdb
2. Lastname_Firstname_5B_Customer_Orders.accdb 3. Lastname_Firstname_5B_Potential_Customers.accdb
Access Project #12
Customizing Forms and Reports
Rather than use a default form or report, learn to create your own user friendly
form and report.
Do Project 6A and Project 6B (p. 430 - 468)
Turn In: TWO files (Under "Assignments" - Project #12)
1. Lastname_Firstname_6A_Locations.accdb
2. Lastname_Firstname_6B_RBC.accdb
Congratulations! If you have completed all of our projects, you are a proficient Excel and
Access user. Use your Excel and database skills whenever possible!