CSCI019m/NURS11IR: Electronic Spreadsheet

Updated 2018.08.20

Fall, 2018 Syllabus


Tom Kleen, Heelan Hall 274, 279-5411 (Briar Cliff),

Office Hours

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




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.


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.


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.


You will be based solely on:

Homework assignments……………………


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


The following grading scale will be used:























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.

Course withdrawal

Withdrawal deadline before the institution of penalty grading is 11/5/2018. 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.

Required materials



We will have one assignment per class. Each assignment will involve creating a spreadsheet using Excel 2016. Assignments must be on time. The drop box closes 30 minutes before class on the due date. 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 Late Assignments drop box. However, it must be before the next assignment is due (the following Friday).


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.

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 Student Support Services (Heelan Hall-057 or 712-279-1717) to discuss needs. Documentation of the disability is required.


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.


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

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.

Electronic devices

Turn off or silence all cell phones and other electronic devices that might 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, etc. If you do, your computer may be unplugged.