CIS105OA -- Introduction to Computer Applications

3 credits

 

Instructor

David Karr

Phone

570-961-7853

Office

219 Angeli Hall

E-mail

KarrD@lackawanna.edu

Office Hours

By Appointment Only

Meeting Times

Online

Credits

3

 

Text and Materials (required):

  • Shelly Cashman Series Microsoft Office 365 & Office 2016 Introductory ISBN: 9781305870017)
  • USB drive
  • Notebook and pen/pencil

 

Description:

CIS 105 - Intro to Computer Applications

This course provides an introduction to business computer applications. Students receive hands-on practice in Microsoft Office (Word, Excel, and PowerPoint) software. In addition, Google Docs, Google Sheets, and Google Slides are introduced so students become familiar with file sharing options, which can enhance group work and instructor-student interactions.  Example projects include Word announcements, an APA formatted sample research paper, resume and cover letter. Excel workbooks use formulas, functions, charts, absolute cell references, and formatting. PowerPoint slide shows include bulleted lists, themes, clip art, and slide transitions. Students must achieve a prescribed level of proficiency in keyboarding. Extensive work on the student’s own computer or in the college’s computer labs is required. Students who have workplace or previous academic experience using MS Office are encouraged to enroll in CIS115 instead of CIS105. (3 Credits).

 

Objectives:

1. Correctly use the portal and college email.

2. Create, format, and edit a Word document; create a research paper with citations and references; create a business letter with a letterhead and table.

3. Create and edit a PowerPoint presentation with clip art; create a presentation with pictures, shapes, and word art; add media to a presentation.

4. Create an Excel worksheet and an embedded chart; use formulas, functions, and format the worksheet; work with large worksheets, charting, and what-if analysis.

5. Demonstrate the ability to share files and update files in real-time with classmates using Google Docs, Sheets, and Slides. 

 

 

To answer questions on Microsoft Office applications in a discussion format using the college portal as the mechanism for the discussions. 

 


Requirements:

This course is designed as a hands-on course. The majority of your time will be devoted to completing the work I post at the portal that utilize the features of each of the software applications presented. You are expected to work on assignments on your own time in order to complete them by the due date. As you work to complete the assignments, the following resources are available to you: the course text, the student companion site, YouTube videos on my YouTube Channel and my handouts posted on the Handouts and Links / Course resources page on the portal.

 

You will be required to complete assignments on schedule. These will usually include but not limited to the chapter tutorial, the Apply Your Knowledge exercise and an In the Lab exercise. The instructions will be posted under the “Assignments” link at the class Website (https://portal.lackawanna.edu ). You will also upload the finished products instead of printing them, so that I can check and grade them. The assignments will be due by 11:55 pm, on the indicated due date. You must check the portal for the instructions and for what the products are. All course assignments will be posted at the “Assignments” page. Check it every day.

 

You must also reply to each discussion topic (DQ1 or DQ2) I set up on the Discussions page and respond in that topic (DQ1 or DQ2) to at least 3 other students during the discussion period. Since there are 2 topics that means 8 total replies per week. 2 Initial replies to me answering the questions and 6 further responses to myself or your classmates. The exact requirements for responses are given in the Online Course Discussion Policy.

 

The grades for your work in this course will posted to the Grades link on the portal. There will be a grading rubric for the textbook assignments you hand in via the portal. These will be in the form of file(s) attached to the assignment. I will fill in the rubric with the points you earn for each exercise and I will add comments to your assignments via the commenting features available in MS Office.  You can view these completed rubrics by opening the file I send back to the assignment at the “Assignments” page.

 

Evaluation:

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.

 

You will also complete a 2-part exam on each of the applications during the course of the semester, and a comprehensive 2-part final exam at the end of the semester. Exams are task oriented as well as knowledge based.

 

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. *Please note that the beginning of course activities common to all courses (Syllabus quiz, Course Navigation Quiz, Academic Honesty Pledge, Autobiography) DO 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 a course will automatically be dropped from the course.

Students who miss one week of participation 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 respond to at least two 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 participate in the discussion on 4 separate days?
  • 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.

 

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
  • If you fail to complete the assignments for week 1, I will report you to the registrar as ‘Never Attended’ and you will not be allowed to return to the class.
  • Participation in the discussion forum will not be accepted late.
  • Assignments will be closed and will not automatically be re-opened.
  • When I send you e-mail, I will send it to the e-mail address supplied by the college, that is the ‘falcons’ e-mail. If you contact me by e-mail, send me the e-mail message from the address supplied by the college or through the course mates page on this class’s portal page. Your falcons email is accessible from the portal and takes the form firstname.lastname@falcons.lackawanna.edu. Check this site for e-mail from me every day. If you wish, you can set up forwarding to forward your falcons e-mail to your personal account to ensure you regularly check email.
  • Post your questions about the assignments to the topics I will have set up under ‘Discussions’. Doing it this way will enable all students taking the class to see your questions and my answers.
  • Assignments done outside of class must be completed on a PC using Microsoft Office 2016. Using any other computer/program will adversely affect your grade because you cannot complete the instructed tasks.

 


Grading:

Unless changes are announced, your final grade will be calculated from these 5 categories using the corresponding weight. You earn your final grade during the course of the ENTIRE semester.

 

Class Orientation Assignments

5%

Office Projects

40%

Examinations (3)

30%

Final Exam

15%  

Discussion Questions

10%

 

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:

Late Assignments are NOT 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 projects from Major Coursework; and a Lackawanna College Reflection Paper.

 


Course Schedule:

 

Week

Topic

Course Objective Met

Related Assignment, Assessment, or Learning Activity

1-2

Syllabus; Using the Portal and Falcons e-mail; Student Contract and Syllabus Quiz

Windows operating system

Word Chapter 1

Word Chapter 2

 

Word Chapter 3

Word Exam

Correctly use the portal
and college e-mail.

 

 

 

Practice using the computer operating system

Create, format, and edit a Word document.

Create a research paper with citations and references.

 

Create a business letter with a letterhead and table.

Demonstrate the ability to share files and update files in real-time with classmates using Google Docs

 

Chapters 1, 2, 3 Word

Student Contract sent to instructor using Falcons e-mail; Syllabus quiz on portal;

Discussion Questions

Chapter tutorial; Classwork exercises

Chapter tutorials; Classwork exercises;

Discussion Questions

Exam

3-4

Power Point Chapter 1

Power Point Chapter 2

Power Point Chapter 3

Power Point Exam

 

Create and edit a PowerPoint presentation with clip art.

Create a presentation with pictures, shapes, and word art.

Add media to a presentation.

Demonstrate the ability to share files and update files in real-time with classmates using Google Slides. 

 

Chapters 1, 2, 3 Power Point

Chapter tutorials; Classwork exercises; Peer Review

 

Discussion Questions

 

 

Exam

5-6

Excel Chapter 1

 

Excel Chapter 2

 

Excel Exam

 

Create an Excel worksheet and an embedded chart.

Use formulas, functions, and format the worksheet.

Demonstrate the ability to share files and update files in real-time with classmates using Google Sheets

 

Chapters 1, 2,3  Excel

 

Chapter tutorial; Classwork exercises

Discussion Questions

 

Exam

Team Debate

 

7

Final Exam

Word, PowerPoint, Excel

Final Exam

 

Examinations:

Exams will be administered through / uploaded to the College Portal / website and will generally be available for the day each is due. It will be your responsibility to set aside a time period for you to take the exam from start to finish at one sitting.

 

N.B. This schedule is subject to modification and revision depending on the needs of the class. I will announce any changes to the schedule during class time. You are responsible for noting all changes and adhering to them.