bus150 c. kushida, spring 2018 1st 8-weeks · 2018-01-19 · 1. complete all items under “course...

Page | 1

BUS150 C. Kushida, Spring 2018 1st 8-weeks (#51627)

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: Canvas 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: We do not have any on-campus meetings for this course. However, the Final Exam will be taken on-campus during the date and time stated in the course syllabus.

Textbooks: Three Textbooks are Required

BEST OPTION: Obtain the bundle of three textbooks (ISBN 9781323579497) at the Don Bookstore. You will see the following two covers in the shrinkwrap:

All three textbooks will be included in this package.

If you purchase from a prior BUS150 student, it should be the above textbooks and will be fine to use. It is up to you to verify that the textbooks are same as the ones we will be using for this course. Any prior versions are not acceptable. Do not purchase them.

1. You must purchase all three textbooks for this course.

2. We will NOT use any publisher Access codes. Please ignore any publisher references to these.

3. 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 great too!

http://www.donbookstore.com/

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.

http://sac.edu/StudentServices/AdmissionsRecords/Pages/Academic-Honesty-Policy-.aspx

Page | 4

Attendance and Absence Policy: In accordance with the college drop policy, students who do not access the class web site or submit the “first assignments” by the due date may be dropped as a no show. Students who fail to turn in the weekly assignments and or participate in the discussion boards will be considered “absent” and may be dropped from the class for “excessive absence.” Students are responsible to officially drop the class or they will receive a letter grade based on their performance. 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 as a no-show:

1. Complete all items under “Course Information”, including the “Orientation Quiz”

2. Post a thread response in Week #1’s discussion board

Participate throughout 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 to

remain in this course.

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. DSPS is located in VL-203 and their

phone number is 714-564-6295. The DSPS 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.

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 Courses” and the “SAC Online Student

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. http://rsccd.blackboard.com

Save this file and submit as directed under “Course Information”.

http://sis.rsccd.edu/

http://sac.edu/StudentServices/DSPS/Pages/default.aspx

http://rsccd.blackboard.com/

Page | 5

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 have access to 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

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. The menus and placement of Excel for the mac features are a bit different from your textbook

screenshots for the Windows version. It does not seem to affect the majority of mac users – just be aware.

http://www.rsccd.edu/Departments/Information-Technology-Services/Pages/Student-Email-Cloud.aspx

http://www.rsccd.edu/Departments/Information-Technology-Services/Pages/Student-Email-Cloud.aspx

http://foundationccc.org/CollegeBuys

http://www.journeyed.com/fccc

http://www.journeyed.com/fccc

Page | 6

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 Canvas 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!

COMMUNICATION:

The primary sources of communication in this course will be through the discussion board and by email.

Please be sure to have a current working email address in your WebAdvisor profile.

Personal Issues: For questions regarding personal issues such as a grade on a specific assignment, please

communicate with me via email. Emails must include our Course Number (e.g. BUS150), your name and

the subject, in the subject line. (e.g. BUS150 Your Name – Project #4 Question)

I will generally respond to emails within 24 hours between Monday 8am and Friday 4pm if they have the

proper subject line. Emails received over the weekend will be answered on Monday.

Responses to emails without the proper subject information will be delayed.

Assignment and Course Questions: For questions about specific assignments, course or Canvas, please refer

to our “Frequently Asked Questions” and Discussion Board Questions forum. If an answer to your question

cannot be found, please post a question on our discussion board. Before you post, it is expected that you

have attempted 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.

http://sac.edu/AcademicProgs/Business/ACC/Pages/default.aspx

http://sac.edu/Library/Pages/hours.aspx

Page | 7

If you have a Canvas how-to related question, please feel free to use the 800# on the Canvas help number!

Email: In this class you must use your SAC email and you will need to check it. Please assure that the email

you have on WebAdvisor is the one you regularly check!

Netiquette / Guidelines for a Productive and Effective Online Classroom:

It is expected that every class member will participate in a mature and respectful fashion. Participate actively in the discussions and other course activities, having completed the readings and thought

about the issues. Pay close attention to what your classmates write in their online comments. Ask clarifying questions, when

appropriate. These questions are meant to probe and shed new light, not to minimize or devalue comments. Think through and reread your comments before you post them. Assume the best of others in the class and expect the best from them. Value the diversity of the class. Recognize and value the experiences, abilities, and knowledge each person

brings to class. Disagree with ideas, but do not make personal attacks. Do not demean or embarrass others. Do not make sexist,

racist, homophobic, or victim‐blaming comments at all. Be open to be challenged or confronted on your ideas or prejudices.

EXPECTATIONS: This is a college level course. Many students expect that an online course will be easier, or entail less time.

This is not true. This online class will take just as much time as a traditional classroom course. College

credits are based on the Carnegie Unit, the structure of the US Education system, for a system of “units”.

One semester unit represents one lecture hour of required classroom time and two hours of student

preparation time. Thus, our three unit course requires, 3 lecture hours and 6 hours of student preparation,

or approximately 9 hours total, per week that you will need to spend on this course.

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 usually the best way to reach me!)

Office Location: Cesar Chavez Building, A-101

Office hours: Generally 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 2018 – 1st 8-week

(#51627)

Week Content Activities

Due Date

(Think: by

midnight) (Slider: following

date by 6:00am)

Week

1

2/05

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

whatsoever!

Logon to Canvas using your

WebAdvisor ID & password

(http://rsccd.instructure.com)

Read the BUS150 FAQs

Complete the “SAC Online Student

Orientation” (under “My

Organizations” n Blackboard)

Read Suggestions from Prior

Students

Take your Self-Guided Tour

around our BUS150 course

8/28

Don’t get

Dropped!

Complete all items in our “Course

Information” module

Complete Orientation “Quiz”

Create thread - Discussion Board

Week #1

2/07

Must be completed

by 2/07 or you will

be dropped

Getting Started in

Excel 2016

* If you have not used Office 2016, you

should begin on page 3 and do, or read

through, the usage of the toolbars and

saving of files in Office, though page

48.

2/09

http://rsccd.instructure.com/

Page | 9

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

2/09

Week

2

2/12

Gaining Competitive

Advantage Through

Information Systems

1. Read Ch. 2

2. Create thread for Discussion Board

Week #2


4. Project #2 (Excel)

2/15



2. Take Quiz 2


2/19

Week

3

2/19

Managing the

Information Systems

Infrastructure and

Services

1. Read Ch. 3


Week #3



2/22



2. Take Quiz 3


2/26

Page | 10

Week

4

2/26

Enabling Business-to-

Consumer Electronic

Commerce

1. Read Ch 4


Week #4



3/01



2. Take Quiz 4

3. Project #7 (Access)

3/05

Week

5

3/05

Enhancing Business

Intelligence Using

Information Systems

1. Read Ch 6


Week #5



3/08




3. Take Quiz 5

3/12

Week

6

3/12

Enhancing Business

Processes Using

Enterprise Systems

1. Read Ch 7


Week #6



3/15




3. Take Quiz 6

3/19

Page | 11

Week

7

3/19

Strengthening

Business-to-Business

Relationships via

Supply Chain and

Customer Relationship

Management

1. Read Ch 8


Week #7



3/22



2. Take Quiz 7

3/26

Last Day to turn in

late Projects

Week

8

3/26

Developing and

Acquiring Information

Systems

&

Securing Information

Systems

Final Exam Preparation

1. Read Ch 9 & 10


Week #8


4. Take Course Survey

3/28

Final Exam

(Ch 9 & 10)

Taken at the SAC Assessment

Center, arrangements made during

week 7.

3/26 -3/30

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)


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!



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.)


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.


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.


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.



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 will 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.


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.


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 are 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!


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.


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!

bus150 c. kushida, spring 2018 1st 8-weeks · 2018-01-19 · 1. complete all items under “course...

Documents