Lewis-Clark State College

BUS-221: Intro to Computers & Information Systems – Spring 2019

Course Information

Instructor: Casey Wilhelm

Instructor Info: MBA – Gonzaga University

M.S. – Organizational learning and leadership – University of Idaho

Contact Info: Please use Black email/messaging for ALL course communications.

Required Texts: Building a foundation with MS Office 2016 Fehl, Hovey, Linford, Murphy, Scott: Labyrinth Publishing ISBN:

945-1-59136-820-5

Required Software: To complete homework assignments, students will need to have access to MS Office 2016 Professional, including MS Access. Students can download a free copy of MS Office for both PC’s and Mac’s directly from Microsoft. (Full URL https://products.office.com/en-us/student/office-in-education.) Note: The

MAC version of MS office does not have Access.

Prerequisites: Courses: None

Skills: Students should have a basic understanding of file management and be able to save, email, and

upload files. Students are expected to be able to utilize Blackboard to access course materials,

participate in discussion boards, and submit completed assignment files.

Students must also have good oral & written communication skills; be able to communicate via email including submitting course work via email attachments; and be able to do research on the Internet.

Course Overview & Student Learning Outcomes BUS 221 teaches some of the most essential skills for using programs of the Office 2016 suite. In

addition to exploring some of the features and capabilities that all the Office programs share, you will

learn many skills specific to each program, like promoting and demoting lists in Word, creating simple

formulas in Excel, applying a theme in PowerPoint, reorganizing forms in Access, and much more.

By the end of this course, you will be able to:

• Identify parts of the Office user interface • Search for Help within Office applications

• Combine items created in various applications • Create a professional business letter (Word)

• Prepare a professional résumé using a table (Word) • Create a promotional brochure (Word) • Create a report using headers/footers, table of figures, and footnotes/endnotes (Word)

• Discuss how Excel helps productivity (Excel)

• Use functions to perform calculations (Excel)

• Create, modify, and format charts (Excel)

• Sort and filter data (Excel) • Apply a document theme (PowerPoint)

• Create a presentation from a Word outline (PowerPoint) • Add transition effects (PowerPoint)

• Acquire and add audio to a presentation (PowerPoint) • Identify database objects and functions (Access)

• Create basic forms (Access)

• Create, save, and run select queries (Access)

• Create basic reports (Access)

Student Support

Email: All students are required to assure that they have access to lcmail.lcsc.edu, and that they understand

how to access and use the academic/course features of the system. All email to students from the

instructor will be sent to this email account. The portal is also available at www.lcsc.edu.

Blackboard Orientation:

LCSC offers a Blackboard Orientation, which is a module designed to familiarize you with navigating and

using the Blackboard tools. It also offers some tips for being a successful online student and information

about getting technical support. (Full URL: https://lcsc.blackboard.com/bbcswebdav/institution/Community%20Programs/RTF/BbLearn_RTF/index.html)

The 24/7 LCSC Blackboard Help Center The Help Center is currently available to LCSC students. You can call, start a ticket, or use the live chat on

the website (recommended). Phone: 855-671-6899 (Toll Free)

24/7 Blackboard Support Website (Full URL: http://lcsc.edusupportcenter.com/)

Academic Support: If you need additional academic or other support, here are some options:

LCSC Writing Center (http://www.lcsc.edu/writing-center/ )

LCSC Advising (http://www.lcsc.edu/advising/ )

LCSC Student Support Services, TRiO (http://www.lcsc.edu/student-support-services/ )

LCSC Campus Accessibility (http://www.lcsc.edu/media/2714343/lcsc-eit-policy-and-procedures.pdf )

LCSC Accessibility Policies (http://www.lcsc.edu/accessibility/ )

LCSC Disability Services (http://www.lcsc.edu/disability-services/ )

LCSC Student Counseling Center (http://www.lcsc.edu/student-counseling/) LCSC Student Affairs (http://www.lcsc.edu/student-affairs/)

IMPORTANT NOTE: If you need course adaptations or accommodations because of a disability, if you

have emergency information to share with me, or if you need special arrangements in case the building

must be evacuated, please make an appointment to talk with me as soon as possible.

You can find additional accommodation resources at:

Microsoft Accessibility https://www.microsoft.com/en-us/accessibility/ Blackboard Accessibility

http://www.blackboard.com/accessibility.aspx

Privacy policies: You can view the privacy policies of Blackboard and Microsoft at the following links: Microsoft

Privacy Statement https://privacy.microsoft.com/en-us/privacystatement

Blackboard Privacy http://www.blackboard.com/footer/privacy-policy.aspx

Grading:

Grading will be based on the following course requirements and examinations:

Qty Item Points Total %

40 Chapter Exercises 6 240

36.92%

4 Practical Exams 50 200 30.77%

1 Participation 60 60 9.23%

1 Midterm 50 50 7.69%

1 Final 50 50 7.69%

1 Final Project 50 50 7.69%

Total 650

Accumulated points will be divided by the total available and a grade will be determined using the

following percentage scale:

% Range Grade % Range Grade

92% to 100% A 70% to 77% C

90% to 91% A- 68% to 69% D+

88% to 89% B+ 60% to 67% D

82% to 87% B 0% to 59% F

80% to 81% B- See catalog I

78% to 79% C+

Response Time: I will respond to all emails within 48 hours, hopefully sooner. I will have your submitted assignments

graded within one week of their due date.

Due Dates: All assignments to be turned in must be submitted before the start of the next class session.

Late Work Policy: All work MUST be completed on time. If anything is time stamped after the due date and time no points

will be given. In extenuating circumstances only, an extension with reduced point totals may be granted

at the discretion of the instructor; however, the student must notify instructor PRIOR to due date/time.

Homework: Word, Excel, PowerPoint, and Access assignments will be assigned during the course in almost every

module. Aassignments will be submitted via Blackboard.

Practical Exams: Each component of MS office will have a practical exam. These exams include the range of topics covered for that MS Office component.

Midterm & Final Quizzes: The midterm and final multiple choice and closed book. Each exam will have a time limit of 90 minutes. These exams are worth 50 points each.

Class Participation and Attendance: Your participation is an important component of your learning. Not only will participation prepare you to complete the assignments, it is also part of your grade. Participation will be based on the percentage

of assignments completed. If you don’t miss any assignments you’ll receive full points.

Additional Documents for Review

These documents are imperative to your success in the course. Each can be found in the Blackboard

course space.

• LCSC Syllabus Addendum • Course Assignments

• Course Schedule

IACBE Accreditation - Bus 221: Information Systems for Managers

Class Schedule

Week Topic in class Homework & Assignments

Week#1 (Jan 14)

Syllabus/ Course Overview/ The big Picture Word 1:Creating Business Documents

Read the syllabus W1 – A1, W1 – A2, W1 – A3

W1 D3 – D7 Submit all three files in Blackboard

(before start of next class)

Week#2 (Jan 21)

Word 2:Creating a resume W2 D1 – D5

W2 - A1, W2 – A2

Submit two files in Blackboard (before start of next class)

Word 3:Creating a promotional

brochure W3 D1 – D7

W3 - A1, W3 – A2, W3 – A3

Submit all three files in Blackboard

(before start of next class)

Week #3 (Jan 28)

Word 4:Creating Reports W4 D1 – D5

Styles, section breaks and TOC exercise

Submit 1 file in Blackboard

Word 4: Creating reports contd.

W4 D6 – D10

W4 - A1, W4 – A2, W4 – A3

Submit all three files in Blackboard

(before start of next class)

Week #4 (Feb 4)

Applied Word Exam

Excel 1:Tracking Customer Data E1 D1 – D10

E1 - A1, E1 – A2, E1 – A3

Submit all three files in Blackboard

(before start of next class)

Week Topic in class Homework & Assignments

Week #5 (Feb 11)

Excel 2: Recording Student Grades E2 D1 – D9

E2 - A1, E2 – A2, E2 – A3

Submit all three files in Blackboard (before start of next class)

Excel 3: Data Visualization and Images E3 D1 – D7

E3 - A1, E3 – A2, E3 – A3

Submit all three files in Blackboard (before start of next class)

Week #6 (Feb 18)

Excel 4: Organizing data E4 D1 – D8

E3 - A1, E3 – A2, E3 – A3

Submit all three files in Blackboard (before start of next class)

Excel 5a: Database/Stats

Excel Database and Statistics: pages 1 - 42 • Save Trip Report Workbook as

Excel5b and submit it. • Save Sales Report Workbook

as Excel5c and submit it.

Submit two three files in Blackboard (before start of next class)

Week #7 (Feb 25)

Excel 5b: Database/Stats

Excel Database and Statistics pages 43 - 90

Save as Excel5d and submit.

Excel Database and Statistics pages 91 - 100

Save workbook and submit as Excel5e

Submit two files in Blackboard (before start of next class)

Applied Excel Exam

Study for midterm

Week #8 (Mar 4)

Midterm Review

Midterm Practical and Multiple choice

Week #9 (Mar 11)

PowerPoint 1: Creating a presentation P1 D1 – D8

P1 - A1, P1 – A2, P1 – A3

Submit all three files in Blackboard (before start of next class)

Week Topic in class Homework & Assignments

PowerPoint 2: Designing the presentation P2 D1 – D14

P2 - A1, P2 – A2, P2 – A3

Submit all three files in Blackboard (before start of next class)

Week #10 (Mar 18)

PowerPoint 3: Graphics, animation, sound P3 D1 – D11

P3 - A1, P3 – A2, P3 – A3

Submit all three files in Blackboard (before start of next class)

PowerPoint 4: Multimedia P4 D1 – D8

P4 - A1, P4 – A2, P4 – A3

Submit all three files in Blackboard (before start of next class)

Spring Break! No Assignments

Schedules. Enjoy your break.

Week #11

(April 1)

Applied PowerPoint Exam

Week #11 (April 1) Week #12 (Apr 8)

Access Intro: Database

Design

Access 1: Tables A1 D1 – D7

A1 – A1, A1 – A2, A1 – A3

Submit all three files in Blackboard (before start of

next class) Week #12 (Apr 8)

Access 2: Forms A2 D1 – D7

A2 - A1, A2 – A2, A2 – A3

Submit all three files in Blackboard (before start of next class)

Week #13 (Apr 15)

Access 3: Querie s A3 D1 – D8

A3 - A1 A3 –A2 A3 –A3

Submit all three files in

Blackboard (before start of

next class)

Access 4: Reports A4 D1 – D6

A4 - A1 A4 – A2 A4 – A3 Submit all three files in Blackboard (before start of next class)

Week #14 (Apr 22)

Applied Access Exam

Applied Access Exam Integration 1: I1 D1 - D6

Review for

final exam

Final Project Due

Week 15&16 (April 29 and May 6)

Study for Final Exam. Final Exam

will be available May 6 and is due on May

9.

NOTE: This syllabus is subject to change. Additional lecture topics may be added, minor changes to the

schedule of topics, and changes to course policies may be required as the course progresses, and as deemed

appropriate by the instructor.