Standardized Syllabus

CIS 210 OA Spreadsheets

Winter Intersession 2019

3 Credits



Kim Mapes




Towanda Center


Office Hours

8 am – 4 pm






New Perspectives: Microsoft Office 365 Excel 2016 Edition: N/A

Author: Parsons 
ISBN: 9781305880412
Copyright Year: 2017
Publisher: Course Technology



CIS 210 (Formerly IS 210) - Computerized Spreadsheets This course provides the student with an in-depth treatment of electronic spreadsheet software using Microsoft Excel. The course proceeds from the basics of spreadsheet design to such advanced topics as graphing, linking worksheets and macro creation (3 Credits). Prerequisite: CIS 105 Spreadsheets concepts are presented and developed in a computer lab environment with hands-on Reviews using Microsoft Excel. Topics included are formulas and functions, charts and graphics, pivot tables, pivot charts, multiple worksheets, advanced functions, conditional formatting and filtering, and integrating Excel with other windows programs. Extensive work on the student’s own computer or on the college’s computer labs is required. (3 credits). Prerequisite: CIS 105 or CIS115.



  1. To gain intensive hands-on experience with the Microsoft Excel spreadsheet package in a laboratory environment
  2. To design, enter, edit, save, and print spreadsheets and graphs
  3. To analyze the needs of a spreadsheet and write formulas
  4. To design templates
  5. To be able to link worksheets
  6. To utilize the database and other special functions
  7. To design and trouble-shoot macros



Complete assignments and tests on time.

Class participation.

Fulfill Discussion requirements.



Training assignments will be required for each chapter, which you will complete and be graded on whether you complete each action item.


Generally, your work will be evaluated by how accurately you complete the lessons presented in the text and how you provide evidence that you know how to use the features of Office applications by completing documents, workbooks, and presentations.


Rubrics provide details on the objectives of your assignments. These are an interactive tool and you must use these as a guide, checking off each item and identifying where each objective has been met within your work, before turning in your assignments. In this way, you are building a good habit of self-monitoring, which not only enables you to focus on the most important course concepts but also helps you to recognize your own level of understanding.


Rubrics empower you to earn all available points on an assignment, but they also ensure that you are learning and that you are able to successfully express that learning.

Detailed rubrics will be provided for each assignment as the course progresses.


Online Course Attendance Policy

Students enrolled in credit-bearing courses at Lackawanna College will fail any course(s) in which they accumulate absences beyond the maximum number allowed. This pertains to online courses as well.


Attendance is defined by participating in an academic activity within the online classroom, which includes making posts and replies in a course-related graded discussion forum or submitting a course-related written assignment. Activities (Syllabus quiz, Course Navigation Quiz, Academic Honesty Pledge, Autobiography) not related to the aforementioned activities will not count for attendance purposes.


Students that fail to participate in an academic activity as described above in the online classroom prior to the last day to drop/add, will automatically be dropped from the course.


  • You are required to engage in discussion by making an initial post to your instructor’s prompt by the assigned day of the week, and then submitting the required number of replies by the end of the week.
  • Students who do not participate in any course-related discussions AND who do not submit any course-related assignments for ONE week will be DROPPED from the course. It is the responsibility of the student to formally withdraw from the course at the Registrar’s office.


Online Course Discussion Policy

In order to understand, remember, and benefit from what we learn in class, discussion and interaction are critical. Responses such as, “I like what you said.” “I agree.” Or “Good thinking.” are NOT acceptable. Also, you should NOT simply repeat what someone else has already said.

Good Discussions in Course Resources will help you, but you should also use this rubric to gain all possible points for your contributions and, more importantly, to get the most out of our class discussion!

Ask yourself the following questions to help guide you in having a great discussion:

  • Did I answer the discussion questions directly demonstrating a clear understanding of the material that promoted conversation?
  • Did I support my answers to the discussion questions with research and reading?
  • Did I make the required number of replies to my classmates?
  • Did I continue the conversation with peers that replied to my discussion?
  • Did I answer any additional questions the instructor may have asked?
  • Are all of my responses detailed and clear?
  • Did I make my initial post and replies by the assigned due dates?
  • Did I relate my responses to the course reading, notes, and/or personal life?
  • Did I provide the class with a response that is non-generic and inspiring – meaning that they learned from what I have contributed and can continue the conversation
  • Did I use proper grammar, spelling and netiquette?


Responses that do not move the conversation forward by providing information to which others can respond and build upon will negatively affect your weekly score.



Withdrawal Policy

A student has the privilege of withdrawing from any courses or from the College itself without academic penalty up to and including the final date for withdrawal indicated on the College calendar.

To withdraw officially from a course or from the College, a student must obtain the proper withdrawal form from the Student Affairs Office or from your Center Director, complete this form and submit it to the Registrar's Office before the final day for withdrawal without academic penalty as indicated on the College calendar. If a student stops attending a course for which he/she is registered after the published census date (end of drop/add) without having officially withdrawn from the course, the student will be assigned an AW (penalty-grade failure) for the class. No exceptions will be made.

Students who violate the College's Academic Integrity Policy and fail a course in consequence may not exercise the withdrawal privilege in that particular course.


Financial obligations to the College will be determined according to the Refund Policy.


Instructor Policies

  • All emails and responses posted in the General Questions section of the forum will be answered within one day.
  • All assignments will be graded within 3 days of the assignment due date



Grading Points possible

Module Assignments                                                   400 pts

Module Review Assignment                                       400pts

Budget Team Exercise                                                 100 pts

Discussion Questions                                                   60 pts

Midterm and Final                                                        200 pts

Total                                                                                 1260 pts


Letter Grade

Numeric Range

Quality Points


96 – 100



90 – 95



87 – 89



83 – 86



80 – 82



77 – 79



73 – 76



70 – 72



67 – 69



60 – 66



0 – 59




Due Dates and Late Penalties

  • There will be no “extra credit.”
  • There will be no Late Assignments Accepted.



Academic Integrity

Academic dishonesty in any form, such as plagiarism and cheating, will not be tolerated. Sanctions will include an automatic F for plagiarism, but the severity or frequency of the violation may result in dismissal from the College as well. Please see the Student Handbook for a complete explanation.


The following are among the forms of dishonesty, in a classroom of any type, for which sanctions may be applied:

  • Using books, notes or other materials during an examination, unless expressly permitted;
  • Using purchased essays, term papers or preparatory research for such papers;
  • Copying others' work or engaging in unauthorized cooperation during an assignment or examination;
  • Allowing another student to copy from an examination or other assignment intended to be performed independently;
  • Borrowing from published works, whether material is taken verbatim or with minor alterations, without proper and/or sufficient acknowledgment;
  • Submitting as one’s own work originally done by someone else;
  • Submitting the same written report in more than one course without prior approval from the instructor(s) involved;
  • Stealing examinations or assignments;
  • Supplying or selling examinations or assignments;
  • Misrepresenting statements concerning work submitted;
  • Falsifying or fabricating experimental data or results;
  • Falsifying or fabricating the need for extensions on papers or make-up examinations.
  • Misrepresenting identity in an online course


(Please see student handbook for more information)


Disability Statement

Lackawanna College is an Affirmative Action, Equal Employment Opportunity institution.  Students with disabilities and other needs should feel free to contact the instructor privately if there are services and adaptations which can be made to accommodate specific needs.  Students who are having difficulties with class material are strongly advised to seek assistance in the reading and writing lab.  If you feel that you have a disability that has not been formally documented, you may meet with Mrs. Christine Kiehart in the Disability Services office to discuss your options. Please note that disability services do not include exemption from participation requirements in courses considered part of the School of Distance Education, including online and hybrid courses.


Lackawanna College Notice of Nondiscrimination

Lackawanna College will not discriminate in its educational programs, activities, or employment practices, based on race, color, national origin, sexual orientation, disability, age, religion, ancestry, union membership, or any other legally protected classification. Announcement of this policy is in accordance with State Law including the Pennsylvania Human Relations Act and with Federal Law including Titles VI and VII of the Civil Rights Act of 1964, Title IX of the Education Amendments of 1972, Sections 503 and 504 of the Rehabilitation Act of 1973, the Age Discrimination Act of 1975, and Americans with Disabilities Act of 1990.


Title IX of the Education Amendment of 1972 is a federal civil rights law that prohibits discrimination on the basis of sex in federally funded education programs and activities. Lackawanna College is committed to providing an educational and work environment that is free from unlawful sexual discrimination including sexual harassment, sexual violence, and gender based harassment. 


In accordance with Title IX of the Education Amendments of 1972, Lackawanna College will not tolerate any forms of sexual misconduct including but not limited to: sexual harassment, sexual assault, sexual violence and gender-based harassment by employees, students or third parties. This includes prohibiting discrimination against pregnant and parenting students. The College also prohibits retaliation against any person who makes a claim of discrimination or harassment or who provides information in such an investigation. This policy applies to admissions, employment, treatment and access to all programs and activities that take place either on or off the campus at Lackawanna College. 


Lackawanna College will fully and promptly investigate all allegations of sexual misconduct and will take action reasonably designed to resolve the complaint in an equitable manner, end a hostile environment if one has been created, prevent its recurrence, and, when appropriate, take steps to remedy its effects on individuals and the college community.

Lackawanna College complies with Title IX and all other federal laws and regulations that prohibit discrimination in education programs or activities receiving federal financial assistance.

Reports or inquiries regarding nondiscrimination should be made to:

Title IX Coordinator/ Executive Director of the Student Wellness Program, Marsha Pigga, Angeli Hall, Room 102, 501 Vine Street, Scranton PA, 18509 (570) 955-1466/ (570) 677-7589,

Equal Opportunity and Affirmative Action inquiries: Georgia Egan, Affirmative Action Officer/Director of Continuing Education, Angeli Hall, Room 300C, Vine Street, Scranton PA (570) 961-7815, or Gopu Kiron, Affirmative Action Officer/eLearning Director, Angeli Hall, Ground Floor, Vine Street, Scranton PA, (570) 504-7929,


Additional information regarding Title IX requirements and how to file a complaint with the Office of Civil Rights: Office of Civil Rights at, 800-421-3481. Philadelphia Office: Office for Civil Rights U.S. Department of Education, The Wanamaker Building,100 Penn Square East, Suite 515, Philadelphia, PA 19107-3323 Telephone: 215-656-8541, Email:   

Portfolio and Coursework

Lackawanna College will empower you to experience learning by inspiring your critical thinking, accessing your talents and skills, motivating you toward a career choice, and encouraging you to make a difference. In evidence of this learning, the College requires a graduation portfolio containing Career Documents, including a résumé, two letters of recommendation, and a career exploration; Core Coursework, including a research paper from College Writing; three sample papers or Reviews from Major Coursework; and a Lackawanna College Reflection Paper.



Course Schedule



Course Objective Met

Related Assignment, Assessment, or Learning Activity

Week 1

Jan 2 – Jan 6











Module 1

Getting Started with Excel





Module 2

Formatting Workbook Text and Data




Module 3

Performing Calculations with Formulas and Functions


1, 2, 4


















1, 2, 3










1, 2, 3


Due 1/6/2019

Other Requirements

  • Academic Honesty Pledge
  • Course Navigation Quiz
  • Let’s Get to Know each other
  • Time management planning (Extra Credit)

Module 1

  • Complete Module 1 Training Assignment (PORTAL)
  • Complete Module 1 Review Assignment (PORTAL)

Module 2

  • Complete Module 2 Training Assignment (PORTAL)
  • Complete Module 2 Review Assignment (PORTAL)

Module 3

  • Complete Module 3 Training Assignment (PORTAL)
  • Complete Module 3 Review Assignment (PORTAL)

Other Requirements

  • Discussion Posts and replies See Discussions for due Dates
  • DQ 1
  • DQ 2

Week 2

Jan 7 – Jan 13


Module 4

Analyzing and Charting Financial Data













Module 5

Working with Excel Tables, PivotTables, and Pivot Charts






Module 6

Managing Multiple Worksheets and Workbooks






Team Exercise







Midterm Exam



1, 2, 3














1, 5









1, 6



Due 1/13/2019

Module 4

  • Complete Module 4 Training Assignment (PORTAL)
  • Complete Module 4 Review Assignment (PORTAL)
  • Budget Team Exercise (PORTAL)
  • Team Exercise

Module 5

  • Complete Module 5 Training Assignment (PORTAL)
  • Complete Module 5 Review Assignment (PORTAL)
  • Read Module 6 Pages (EX-327-EX380)

Module 6

  • Complete Module 6 Training Assignment (PORTAL)
  • Complete Module 6 Review Assignment (PORTAL)
  • Read Module 7 Pages (EX-387-EX452)

Other Requirements

  • Discussion Posts and replies See Discussions for due
  • DQ 1
  • DQ 2
  • Complete Midterm Exam

Week 3

Jan 13 – Jan 18

Module 7

Developing an Excel Application










Module 8

Working with Advanced Functions






Final Exam

1, 6


Due 1/18/2019

Module 7

  • Complete Module 7 Training Assignment (PORTAL)
  • Complete Module 7 Review Assignment (PORTAL)
  • Read Module 8Pages (EX-463-EX522)


Module 8

  • Complete Module 8 Training Assignment (PORTAL)
  • Complete Module 8 Review Assignment (PORTAL)
  • Complete Final Exam

Other Requirements

  • Discussion Posts and replies See Discussions for due
  • DQ 1
  • DQ 2



MidTerm Exam               Week 2

Final Exam                        Week 3


Team Exercise               Week 2

For this exercise, you will work as a team. your team is posted under the discussion Team Assignment. Print off the instructions for the exercise and download your beginning template from the Portal. Prepare the entire budget, don't forget to pretty up the worksheet and make sure it prints nicely. Numbers need to be entered as a formula where applicable. 

One team member will post your budget to the Team Review Discussion. Be sure to note whether there will be a loss or profit!

Each team member must Participate! Once the assignment has been completed, upload it to the portal. Each team member should email me with the participation of the other members. The scale for points deducted for non-participation is as follows:

Participated some - 25 points

Did not Participate - 50 points