CSCI019m/NURS11IR: Electronic Spreadsheet

Updated 2019.01.07

Spring, 2019 Syllabus

Instructor

Tom Kleen, Heelan Hall 274, 279-5411 (Briar Cliff), tom.kleen@briarcliff.edu

Office Hours

Mon, Wed: 10-11; Tue, Thu: 2-3; Fri: 9-10

Prerequisites

None

Textbook

NONE. All of our materials are online. But if you would like to get a reference, I recommend the Microsoft Excel 2016 Bible by Walkenbach.

Software

Excel 2016 for Windows. Available on Briar Cliff computers. You can also install Office 365 for free and use it as long as you are a BCU student. Note that if you are a Mac user, you can also get Windows 10 for free from the IT Center. If you are using a Macintosh computer, I strongly encourage you to do this.

Course Learning Outcomes

The purpose of this course is to teach students one of the primary uses of personal computers: electronic spreadsheets. Students who complete this class should be prepared to take and pass the MOS (Microsoft Office Specialist) Excel Expert test. Here are the objectives for this class: Common skills, Spreadsheet skills, Database skills.

Expectations

I expect you to:

1.    Be honest.

2.    Attend class every day and arrive on time.

3.    Complete all of the assignments and hand them in on time.

Evaluation methods

Weekly homework assignments, and a hands-on open-book final test.

Grading

You will be based solely on:

Homework assignments……………………

70%

Final test……………………………………………

30%

The following grading scale will be used:

A

95-100

A-

93-94

B+

90-92

B

87-89

B-

85-86

C+

82-84

C

79-81

C-

77-78

D+

74-76

D

70-73

F

0-69

Because this class meets a graduation requirement, you must achieve a score of at least 70 on the final to pass the class, regardless of your homework scores.

Required materials

None.

Assignments

We will have one assignment per class. Each assignment will involve creating a spreadsheet using Excel 2016. Assignments must be on time. If you do not get the assignment in the drop box before it closes, you will not be able to hand it in and you will receive a 0. Exception: Each student is allowed one late assignment. If you fail to get an assignment in on time, you can put it in the drop box before the next class (the following Friday). Note that even though the drop boxes will always remain open for an extra week, only one late assignment is allowed.

Tests

Before missing class on the day of the test, you must clear it with me before the test, and you must have a very serious reason for missing the test. If you are sick, you will need a note from the school nurse or a doctor. If you miss the test without clearing it beforehand, you will receive a 0 for that test. Leaving a voice-mail or an email without a reply is not considered clearing it beforehand. You must talk to me.

Course withdrawal

Withdrawal deadline before the institution of penalty grading is April 2. After the withdrawal deadline students may withdraw, but will receive a penalty grade of WP (withdrawal passing) or WF (withdrawal failing). Withdrawals are not permitted during finals week.

Attendance

I expect you to be here every day. See attendance, test, and homework policies. Print out this document, sign it, and hand it in next class.

Administrative withdrawal policy

Students who do not attend class for two consecutive calendar weeks are subject to administrative withdrawal.

Title IX Educational Act

Info on the BCU Sexual Harassment policy.

Academic Honesty

1.    Homework is an individual activity, and each student is expected to turn in an original work. "Working together" is not allowed. Any student found turning in work which is not his or hers will be failed for the course. See the Briar Cliff academic integrity statement. If you are having problems completing homework assignments, please see me for help.

2.    There is no such thing as "extra credit."

Disability Statement

Persons with disabilities who need accommodations should initially contact Jeanene Sampson (Heelan Hall-108 or 712-279-5562) to discuss needs. Documentation of the disability is required.

Disclosure

The instructor retains the right to clarify and/or to emend the contents of the syllabus, provided that students are given reasonable and timely notice of such adjustments.

Course Schedule

We meet Friday at 8:00 a.m. The time for the final test is on our home page.

Cell phones & other electronic devices

Turn off or silence your cell phone and any other electronic devices that could distract you and put them out of sight before class begins.

Computer use during lectures

You may use your computer during a lecture for the purpose of taking notes. You may not use the computer to play games, surf the Internet, email, IM, tweet, etc. If you do, your computer may get unplugged.

Graduation requirements

This class meets 2 of the 5 components of the information technology general education graduation requirement. It meets the "Use of a spreadsheet to perform repetitive calculations or to create financial tables" component and the "Use of a spreadsheet or statistical software to summarize and manipulate large sets of data" component.

Computer use during lectures

You may use your computer during a lecture for the purpose of taking notes. You may not use the computer to play games, surf the Internet, email, IM, etc. If you do, your computer may be unplugged.