CIS210OM Spring 2018 Syllabus

Standardized Syllabus

CIS 210 OM Spreadsheets

3 Credits

                                           

Instructor

Kim Mapes

Phone

570-265-3449

Office

Towanda Center

E-mail

mapesk@lackawanna.edu

Office Hours

8am – 4pm

 

 

 

 

Text

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

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

 

Description

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 the 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.

 

Objectives

  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 database and other special functions
  7. To design and trouble-shoot macros

 

Requirements

Complete assignments and tests on time.

Class participation.

Fulfill Discussion requirements.

 

 

Evaluation

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 posting replies in a graded discussion forum or submitting a written assignment. Replies not related to the aforementioned activities will not count for attendance purposes.

 

# of Days Required for Discussion in an Online Course

Maximum # of Weeks Allowed without Discussion 

 

Twice on any four days in a week (8 total)

 

0

 

  • You are required to engage in discussion at least TWICE on FOUR days throughout the week for a total of EIGHT replies in all, minimum.
  • You should respond to the initial DQs Repliesed AND respond to your classmates.
  • Responses MUST be substantive. See the document titled Good Discussions in your Handouts and Links.
  • Responses that do not move the conversation forward by providing information to which others can respond and build upon will NOT be counted toward your weekly score.
  • Students who miss one week of discussion will be DROPPED from the course.
  • Students who do not log on to the course within the drop/add period for the course will be DROPPED from the course. 

 

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.

You MUST reply no less than 8 times per week – twice on any four days.

Good Discussions in Handouts and Links 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!

 

Online Classroom Discussion and Interaction Rubric

20 points per week for a total of 100 points

 

What Should I Do?

Points Available

Did I do This?

Where?

Points Earned

Answer both Discussion Questions directly demonstrating a clear understanding of the material, support your response with research or reading, and promote conversation (2 replies)

4

 

 

 

Respond to at least two classmates’ posts (2 replies)

4

 

 

 

Continue both conversations with at least one additional reply to each peer (2 replies)

4

 

 

 

Respond to at least one of the teacher’s secondary questions, conversing with a classmate who responds to the same question (2 replies)

4

 

 

 

Be sure all responses are detailed and clear and are posted twice on four separate days.

1

 

 

 

Be sure that all responses relate to the course reading and notes, your own everyday life, or to both

1

 

 

 

Provides the class with a response that is non-generic and inspiring – meaning that they learn from what you have contributed and can continue the conversation

1

 

 

 

Use proper grammar, spelling, and netiquette

1

 

 

 

TOTAL POINTS for EACH WEEKLY DISCUSSION:

20

 

 

 

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

  • Be prepared for class by having your own SAM access and USB flash drive. These Items are required!
  • You are expected to read each assigned chapter prior to the lecture.
  • Weekly assignments must be uploaded to SAM by the due date.

 

Grading

Grading Points possible

Module Assignments                                                   400 pts

Module Review Assignment                                       400pts

Budget Team Exercise                                                 100 pts

Discussion Questions                                                   160 pts

Total                                                                                 pts

 

Letter Grade

Numeric Range

Quality Points

A

96 – 100

4.0

A-

90 – 95

3.67

B+

87 – 89

3.33

B

83 – 86

3.0

B-

80 – 82

2.67

C+

77 – 79

2.33

C

73 – 76

2.0

C-

70 – 72

1.67

D+

67 – 69

1.33

D

60 – 66

1.0

F

0 – 59

0

 

 

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, piggam@lackawanna.edu

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, EganG@lackawanna.edu or Gopu Kiron, Affirmative Action Officer/eLearning Director, Angeli Hall, Ground Floor, Vine Street, Scranton PA, (570) 504-7929, Kirong@lackawanna.edu.

 

Additional information regarding Title IX requirements and how to file a complaint with the Office of Civil Rights: Office of Civil Rights at www2.ed.gov/ocr, 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: OCR.Philadelphia@ed.gov.   

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

Day

Topic

Course Objective Met

Related Assignment, Assessment, or Learning Activity

Week 1

10/18-10/21

 

 

 

 

 

 

 

1, 2, 4

 

 

 

 

 

 

Due 10/21/2018

Other Requirements

  • Academic Honesty Pledge
  • Course Navigation Quiz
  • Let’s Get to Know each other
  • Time management planning (extra Credit)
  • Read Module 1 & 2 Pages (EX1-EX57), (EX65-EX121)
  • Discussion Replies 2x’s on any 4 days
  • DQ 1
  • DQ 2

 

Week 2

 

10/22-10/28

 

Module 1

Getting Started with Excel

 

 

 

 

 

 

 

Module 2

Formatting Workbook Text and Data

 

 

 

 

 

 

 

 

 

 

1, 2, 3

 

 

 

 

 

 

 

 

 

 

 

Due 10/28/2018

Module 1

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

Module 2

  • Complete Module 2 Training Assignment (PORTAL)
  • Complete Module 2 Review Assignment (PORTAL)
  • Read Module 3 Pages (EX-131-EX180)

Other Requirements

  • Discussion Replies 2x’s on any 4 days
  • DQ 1
  • DQ 2

Week 3

10/29-11/4

Module 3

Performing Calculations with Formulas and Functions

 

 

 

 

 

1, 3, 6

 

 

 

 

 

 

Due 11/4/2018

Module 3

  • Complete Module 3 Training Assignment (PORTAL)
  • Complete Module 3 Review Assignment (PORTAL)
  • Read Module 4 Pages (EX-187—EX250)

Other Requirements

  • Discussion Replies 2x’s on any 4 days
  • DQ 1
  • DQ 2

Week 4

11/5-11/11

Module 4

Analyzing and Charting Financial Data

 

 

 

 

 

 

 

 

 

 

Mid Term

1, 3, 5, 6

 

Due 11/11/2018

Module 4

  • Complete Module 4 Training Assignment (PORTAL)
  • Complete Module 4 Review Assignment (PORTAL)
  • Budget Team Exercise (PORTAL)
  • Read Module 5 Pages (EX-257-EX318)
  • Complete Mid Term Assignment

Other Requirements

  • Discussion Replies 2x’s on any 4 days
  • DQ 1
  • DQ 2

Week 5

11/12-11/18

Module 5

Working with Excel Tables, PivotTables, and Pivot Charts

 

1, 5

 

Due 11/18/2018

Module 5

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

Other Requirements

  • Discussion Replies 2x’s on any 4 days
  • DQ 1
  • DQ 2

Week 6

11/19-11/25

Module 6

Managing Multiple Worksheets and Workbooks

 

1, 6

 

Due 11/25/2018

Module 6

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

Other Requirements

  • Discussion Replies 2x’s on any 4 days
  • DQ 1
  • DQ 2

Week 7

11/26-12/2

Module 7

Developing an Excel Application

 

1, 6

 

Due 12/2/2018

Module 7

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

Other Requirements

  • Discussion Replies 2x’s on any 4 days
  • DQ 1
  • DQ 2

Week 8

12/3-12/7

Module 8

Working with Advanced Functions

 

 

 

 

Final Exam

1, 6

 

Due 12/7/2018

Module 8

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

Other Requirements

  • Discussion Replies 2x’s on any 4 days
  • DQ 1
  • DQ 2

 

Examinations

Mid Term           Week 4

Final Exam         Week 8

 

Team Exercise

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