bus150 c. kushida, fall 2016 1 8-weeks - santa ana college · bus150 c. kushida, fall 2016 1st 8...

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!

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

http://sis.rsccd.edu/

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

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

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

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

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!

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

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

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

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

http://rms.rsccd.edu/distance_ed/blackboardorientation2014/blackboardorientation2014.html

http://rms.rsccd.edu/distance_ed/blackboardorientation2014/blackboardorientation2014.html

http://ondemand.blackboard.com/r91/movies/bb91_discussion_board_interacting.htm

http://ondemand.blackboard.com/r91/movies/bb91_student_submit_assignment.htm

http://ondemand.blackboard.com/r91/movies/bb91_student_checking_grades.htm

http://ondemand.blackboard.com/r91/movies/bb91_student_checking_grades.htm

http://ondemand.blackboard.com/r91/movies/bb91_course_tools_calendar.htm

http://rsccd.blackboard.com/

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


4. Project #2 (Excel)

9/01



2. Take Quiz 2


9/05

Week

3

9/05

Managing the

Information Systems

Infrastructure and

Services

1. Read Ch. 3


Week #3



9/08



2. Take Quiz 3


9/12

Page | 10

Week

4

9/12

Enabling Business-

to-Consumer

Electronic Commerce

1. Read Ch 4


Week #4



9/15



2. Take Quiz 4

3. Project #7 (Access)

9/19

Week

5

9/19

Enhancing Business

Intelligence Using

Information Systems

1. Read Ch 6


Week #5



9/22




3. Take Quiz 5

9/26

Week

6

9/26

Enhancing Business

Processes Using

Enterprise Systems

1. Read Ch 7


Week #6



9/29




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


Week #7



10/06



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


Week #8


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)


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


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


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, fall 2016 1 8-weeks - santa ana college · bus150 c. kushida, fall 2016 1st 8...

Documents