Lewis-Clark State College BUS-221: Intro to Computers & Information Systems – Spring 2020

Course Information

Instructor:

Randy Eriksen. JD

Contact Info:

Phone: 208-792-2426 Email: rweriksen@lcsc.edu

Office Hours:

Room 203 TJH Monday - Thursday: 8:00 – 9:00, Other days/times by appointment

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: Homework: 16 assignments (drop lowest 4 scores) 25 points each 300 total Tests: 4 Tests 100 points each 400 total Final Project: 100 total Total Points Available: 800 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 phone calls and emails within 48 hours, hopefully sooner. I will have your submitted assignments graded within one week of their due date.

Due Dates: All quizzes and 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. These assignments are worth a total of 114 points. Homework assignments will be submitted via Blackboard.

Practical Exams: Each component of MS office will have a practical exam. These will be completed in class and will include the range of topics covered for that MS Office component.

IACBE Accreditation - Bus 221: Information Systems for Managers

Component Hours

A.     Accounting (ACT) 4

B.     Marketing (MKT) 0

C.     Finance (FIN) 0

1.      Management Principles (MGT) 2

2.      Organizational Behavior (OB) 0

3.      Human Resource Management (HRM) 0

4.      Operations Management (OM) 0

Total Management 2

1.      Legal Environment of Business (LAW) 0

2.      Economics (ECN) 0

3.      Business Ethics (ETH) 3

Total Economic/Social/Legal Environment 3

1.      Information Systems (IS) 45

2.      Quantitative Methods/Statistics (QM) 8

Total Decision-Support Tools 53

G.     Global Dimensions of Business (GLOB) 0

H.     Integrative Experience (INT) 0

Total Contact Hours 62

D.     Management

E.      Economic/Social/Legal Environment

F.      Decision-Support Tools

Class Schedule

Week Class

day

Topic in class Homework & Assignments

Week #1

Monday

Holiday

Wednesday

Syllabus/ Course Overview/

The big Picture

Read: Syllabus

Week#2

Monday

Word 1:Creating Business

Documents

W1 D3 – D7

W1 – A1, W1 – A2, W1 – A3

Submit all three files in Blackboard

(before start of next class)

Wednesday

Word 2:Creating a resume

W2 D1 – D5

W2 - A1, W2 – A2

Submit two files in Blackboard

(before start of next class)

Week #3

Monday

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)

Wednesday

Word 4:Creating Reports

W4 D1 – D5

Styles, section breaks and TOC exercise

Submit 1 file in Blackboard

Week #4

Monday

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)

Wednesday

Applied Word Exam

Week #5

Monday

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 Class

day

Topic in class Homework & Assignments

Wednesday

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)

Week #6

Monday

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)

Wednesday

Excel 4: Organizing data

E4 D1 – D8

E4 - A1, E4 – A2, E4 – A3

Submit all three files in Blackboard

(before start of next class)

Week #7

Monday

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)

Wednesday

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)

Week #8

Monday

Review for test

Wednesday

Applied Excel Exam

Week #9

Monday

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)

Wednesday

PowerPoint 2: Designing the presentation

P2 - A1, P2 – A2, P2 – A3

Week Class

day

Topic in class Homework & Assignments

P2 D1 – D14

Submit all three files in Blackboard

(before start of next class)

Week #10

Monday

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)

Wednesday

PowerPoint 4: Multimedia P4 D1 – D8

P4 - A1, P4 – A2, P4 – A3

Submit all three files in Blackboard

(before start of next class)

Week 11 Spring Break

Week #12

Monday

Applied PowerPoint Exam

Wednesday

Access Intro: Database Design

Week #13

Monday

Access 1: Tables A1 D1 – D7

A1 – A1, A1 – A2, A1 – A3

Submit all three files in Blackboard

(before start of next class)

Wednesday

Access 2: Forms A2 D1 – D7

A2 - A1, A2 – A2, A2 – A3

Submit all three files in Blackboard

(before start of next class)

Week #14

Monday

Access 3: Queries A3 D1 – D8

A3 - A1

A3 – A2

A3 – A3

Submit all three files in Blackboard

(before start of next class)

Wednesday

Access 4: Reports A4 D1 – D6

A4 - A1

A4 – A2

A4 – A3

Submit all three files in Blackboard

(before start of next class)

Week #15

Monday

Applied Access Exam

Wednesday

Outline of Final Project

Week #16

Monday

Work day: final project

Wednesday

Final Project Due

Week #17

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.