Period 2 – CIS118 – Introduction to PC Applications – Fall 2018

Basic Course Information

Course Name: Introduction to PC Applications
Course Sections: CIS118-55273-78B
Semester: Fall 2018
Credits: 3
Prerequisites/Co-requisites: None
Meetings/Times: Mon/Wed/Fri 8:50 AM – 9:45 AM
Location: HS – 228

Instructor Information

Instructor: Wayne Cook, Head of Computer Science Department, CEC-FC
Office Phone: (970) 337-0044
Email: [email protected]
College Web Site: www.frontrange.edu
HS Web Site: https://fortcollins.coloradoearlycolleges.org
Office Location: CEC-FC HS 228
Office Hours: Tuesday or Thursday (same time as your class), or by appointment
Department Contact: N/A

Course Materials

New Perspectives Microsoft® Office 365 & Office 2016: Introductory, Spiral bound or Loose-Leaf Version, 1st Edition. Reference copies will be provided in classroom.
ISBN: 9781337251372 (loose-leaf version)

Windows 10

Microsoft Office 365 (Word, Excel, Access, and PowerPoint) – provided on school computers, must be acquired for home computers, see FRCC for ways to acquire student edition. Currently, Microsoft Office 365 is Microsoft Office 2016.

You need at least two ways to store your files, a USB Flash drive, emailing it to yourself, your hard drive (at home), student storage or submitting to Infinite Campus.  Put your name on all flash drives.  Having a storage device fail or lost will NOT be an accepted excuse for turning in your assignments late.  Most of the time you will be turning in assignments electronically through Infinite Campus or Cengage.

Welcome Message

Welcome to CIS118. Most of the work will be completed 0n-line. If you have any questions, please ask questions. At the end of the semester, every student with an 85% or higher is given the opportunity to take the Microsoft Office Certification.

CCCS Required Syllabus Information

Catalog Course Description

Introduces basic computer terminology, file management, and PC system components. Provides an overview of office application software including word processing, spreadsheets, databases, and presentation graphics. Includes the use of a web browser to access the Internet.

Course Learning Outcomes

  1. Define the basic hardware and software concepts associated with personal computers
  2. Demonstrate the ability to utilize network and internet terminology
  3. Navigate the operating system
  4. Organize and manipulate file names, locations, and backups
  5. Create, modify, use and print word processing documents, spreadsheets, relational databases and presentations
  6. Apply formatting techniques to word processing documents, spreadsheets, databases and presentations
  7. Create, insert and modify visual elements (graphics, charts, tables, ClipArt, etc) in word processing documents, spreadsheets, databases and presentations
  8. Create and format a word processing report
  9. Use desktop publishing features e.g. columns, newsletter, web pages, etc.
  10. Create and use mail merge
  11. Create and modify spreadsheet formulas and functions
  12. Create, insert and modify spreadsheet charts
  13. Make use of relative and absolute cell references
  14. Maintain a database
  15. Query a database
  16. Create and use database forms, filters, and reports
  17. Create and use animation in a presentation
  18. Create and use tables in a presentation
  19. Create and use charts in a presentation
  20. Integrate word processing documents, spreadsheets, databases and presentations
  21. If you have an 85% or higher in this class, take the Microsoft Office Certification exam.

Additional Info: Typing skills are helpful. Students taking this course should allow additional time outside of class hours to complete assignments in the computer lab when classes are not being held OR have access to a computer that has the following operating system and software:

Topical Outline

  1. Computer hardware overview
  2. File System overview
  3. Introduction to Word
  4. Introduction to Excel
  5. Introduction to Access
  6. Introduction to PowerPoint
  7. Office Certification.

Course Overview

Instructor’s Overview of the Course

This is a “hands-on” course, where I will give an overview of each tool and you will do the assignments through Cengage SAM Paper quizzes will be given at the scheduled end of each section. Please keep up with the class schedule so that you will do well on the quizzes.

Graded Instructional Activities

The grade will be calculated based on your total points earned vs points possible. No weighting of assignments will be done.

Grading Scales and Standards

The grading scale for this class is:.

Letter Grade Range
A 90 – 100%
B 80 – 89%
C 70 – 79%
F 69% and lower

NOTE: Borderline grades will be determined by the student’s work ethic. A good work ethic consists of regular class attendance, a good attitude, the ability to work independently and with a group; professional conduct and language; respect for the instructor, classmates, and other FRCC employees; and problem-solving skills.

Late Policy

Assignments will be expected on-time. Since SAM grades all projects, the main penalty for being late with any project is that you will fall behind and not be able to complete all your projects. Remember that only people who have earned an 85% or higher can take the certification exam.

Attendance and Participation

As per the CECFC Handbook: “All CECFC students are expected to attend school daily and to arrive punctually. Frequent absences undermine the sequential and incremental nature of the CECFC curriculum for the student; in addition, they place burdens on the teachers who must arrange for makeup work. Late arrivals disrupt the classroom.”

All students will come to class on time. If you are late, within the first 10 minutes of class, you will be marked tardy. If you are more than 10 minutes late, you will be marked as absent. However, I will put a time down with the absence so that the attendance team will be aware of when you arrived. As long as you come in quietly, coming to class will allow you to make up in-class projects, but not excuse the tardy or absence.

Students are permitted 5 unexcused absences per course, per semester penalty free, if all these absences are not “skipped” classes. More than 5 unexcused absences will result in a course grade reduction of 5%. Each additional unexcused absence will incur an additional 1% grade decrease.

Students are permitted 2 tardies per course, per semester penalty free. Upon incurring a 3rd tardy, the late instances will turn into an unexcused absence. Every 3 tardies afterward will count as an unexcused absence at the end of the semester and calculate into the grade deduction mentioned above.

You will be graded on your participation in class, this means being here on time, ready to learn and being respectful of classmates and the time allotted for this course. Leaving early, working on homework, reading for another class or packing up to leave before the end of class is not allowed.

.

Academic Honesty

Students are expected to uphold FRCC’s Student Code of Conduct relating to academic honesty and assume full responsibility for the content and integrity of the academic work they submit. The guiding principle of academic integrity will be that a student’s submitted work, examinations, reports, discussions, and projects must be that of the student’s own work and unique to the course. Students are guilty of violating the honor code if they:

  • Represent the work of others as their own (this includes copying material from the Internet for discussion postings or other assignments without proper citation)
  • Use or obtain unauthorized assistance in any academic work.
  • Give unauthorized assistance to other students.
  • Modify, without instructor approval, an examination, paper, record, or report for the purpose of obtaining additional credit.
  • Misrepresent the content of submitted work.
  • The penalty for violating the honor code is severe. Any student violating the honor code is subject to receive a failing grade for the course and will be reported to the Office of Student Affairs. If a student is unclear about whether a particular situation may constitute an honor code violation, the student should contact the instructor to discuss the situation.

Collaboration. Unless otherwise instructed, all work submitted is to be done individually by the student. This means you should not be working in pairs or in a group to write discussion posts, complete assignments or take quizzes and other assessments unless specifically asked to do so by your instructor.

Plagiarism / Dual Submission. Plagiarism, whether intentional or accidental, is academic dishonesty and may incur disciplinary action ranging from receiving a zero on an assignment or failing a course to more severe consequences. Plagiarism means

  • Using someone else’s ideas and not correctly citing that use. This means that if you put someone else’s work into your own words, put it in your work, and do not correctly document it, the idea is plagiarized.
  • Using someone else’s words without quotation marks and not correctly citing that use.
  • Using someone else’s images or other works (such as from the Internet) without correctly citing that use.
  • Submitting work that has been turned in for credit in another class or at another institution unless specifically permitted by your instructor.
  • Students may be required to submit work that is evaluated for originality by Turnitin.com, a plagiarism detection software program that checks for certain forms of plagiarism.

Other

We follow all CEC-FC and FRCC student policies(like no wearing hats in class). In addition, I have two primary rules:

  1. Treat each person in this room with the respect with which you would like to be treated.
  2. Except when in an organized group discussion, only one person speaks at a time.

Program Expectations

Disruptive Behavior: If a student engages in any disruptive behavior that negatively affects, disrupts, or impedes (1) the instructor’s ability to teach and/or (2) the other students’ ability to learn and/or (3) the general operation of the college, the student will be subject to disciplinary action.

Student of Concern: Front Range Community College provides faculty, staff and students a resource to report their concern about any member of the FRCC community. If you are concerned about yourself or someone else, please go to www.frontrange.edu/care and report.

Financial Aid: The following actions have eligibility implications for financial aid recipients: non-attendance, dropping courses, withdrawing from courses, repeating courses, academic progress, and the number of credit hours attempted and completed. You are strongly encouraged to seek financial aid advising throughout the term if you have any questions about eligibility implications.

Student Support Services: Students with a disability or in need of support services are encouraged to contact the learning resources and support programs on each campus to arrange for accommodations and support services. The link to the learning resources and support programs is: http://www.frontrange.edu/Current-Students/Learning-Resources-and-Support-Programs/ and the link to the disability services support information is: http://www.frontrange.edu/being-a-student/disability-services

Audio/Video Recording: A student granted permission by the instructor to make an audio or video recording may use the recording only for his or her own study and may not publish or post the recording on YouTube or any other medium or venue without the instructor’s explicit written authorization. All students in the class, as well as guest speakers, must be informed that audio/video recording may occur.

Non-attendance: At FRCC, we want you to succeed. To do so, you must attend class. If you do not attend class during the first two scheduled class sessions, you may be dropped from the course due to non-attendance. Students who are dropped must go through the late add appeal process, which includes securing the signatures of the instructor, Instructional Dean, and Campus Vice President to re-enroll after the add deadline for the course. Course re-enrollment is at the discretion of the instructor and it is unlikely you will be re-enrolled if you have not attended and participated in class.

Computer Ethics: A student will be subject to disciplinary action should he/she try to copy FRCC software or tamper with the network. Copying software is a copyright violation and is against the law. Also, please do not move computer equipment.

Online Learning Expectations

FRCC is committed to helping you succeed in your online courses. Please read the following section for a better understanding of expectations specific to online courses. If you have questions or concerns about course content and activities, contact your instructor right away. If you have questions or concerns related to support services or the student code of conduct, contact your Pathways Advisor or a member of the Online Learning team at 970-204-8250 or 303-404-5513. You can also email us ([email protected]).

Required Introduction to Online Learning

All students who are taking their first online course at FRCC are required to complete the “Introduction to Online Learning.” You will learn strategies for succeeding in online courses at FRCC, including how to use the online learning management system (D2L). Look for the “Introduction to Online Learning” under the “My Courses” heading on the home page when you login to D2L (https://frcc.desire2learn.com).

Interacting in Online Courses

Online classes provide opportunities for you to interact with your instructor and peers in a variety of online formats. Despite what is often modeled in public forums and social networks, civility and etiquette are important aspects in creating deep and meaningful learning. Personal attacks, monopolization, and bullying can stop valuable discussion and are harmful to academic discourse. For this reason, it is important that interaction in an online class is civil, respectful, and focused on the topic presented. If you notice behavior that violates this conduct, be sure to contact your instructor.

FRCC Online Attendance and Participation Policy

Students establish attendance in online courses by completing an academic activity based on course content. As defined by the Federal Department of Education, merely logging into the course site or introducing oneself to the class does not count as attendance. Some examples of successfully attending class include participation in a content-related discussion, quiz, assignment, or contacting your instructor. Students who have not participated by 11:59 PM on the deadline date will be dropped. Similarly, the last date of academic attendance must be reported to Financial Aid for students who do not earn a D or better; students who have not been in regular attendance may experience financial aid ramifications.

Online Proctored Exams

This course requires one or more proctored exams, either at an FRCC Testing Center, through an online proctoring service , or at another pre-approved location. Students who are unable to come to an FRCC Testing Center should contact their instructor and the FRCC Testing Center during the first week of class to arrange another option.

Before taking an exam at an FRCC Testing Center or other proctored location, plan to:

  • Bring a photo ID.
  • Arrive at the FRCC testing center early enough to allow enough time to complete the exam before it closes.
  • Work around busy periods in the semester, there can be an extra wait for a testing space to come available during common testing times.

FRCC Testing Center hours and proctoring information are available online (https://www.frontrange.edu/campuses/testing-centers).

Campus Closure Procedure

If Colorado Early Colleges closes due to inclement weather or another emergency, online courses will proceed unless Desire2Learn and/or Infinite Campus is impacted. If you experience particular hardship or problems completing the course as a result of an emergency, contact your instructor or call Online Learning at 970-204-8250 or 303-404-5513.

Technical Difficulties

FRCC’s Online Courses are hosted by Desire2Learn, and may incorporate other online materials (e.g. publisher content and open educational resources). As an online student, you are responsible for ensuring that you have a reliable internet connection and the necessary equipment to access your online course(s) and any required course materials listed in the course syllabus. Computer failure or problems with internet access are not considered valid excuses for not completing coursework, so be sure to have a backup plan in place so that you can still complete your work on time even if you run into technical problems. Local libraries and computer labs on campuses can be great alternatives, but be sure to check on hours and availability.

For technical assistance with Desire2Learn, contact the Help Desk which is available 24 hours every day: (http://help.cccs.edu); 888-800-9198 (toll free). Desire2Learn is available 24×7, with the exception of limited maintenance windows posted on the home page. In the unlikely event of an unplanned D2L outage, faculty and staff will be informed so that they can make reasonable adjustments to the course schedule and assignment deadlines.

Student Rights, Responsibilities, and Resources

For important information on rights and responsibilities of all FRCC students, as well as the many support resources available to you, please refer to the link to “Student Rights, Responsibilities and Resources” in the online course shell. Topics include:

  • Course Questions
  • Access to Course Materials
  • Student Email
  • Student Drop for Non-Attendance
  • Student Drop for Non-Payment
  • Financial Aid
  • Academic Assistance
  • Disability Support Services
  • Use of Audio / Video Recordings
  • Crisis Counseling and Stress Management
  • FRCC Cares
  • Notice of Non-Discrimination
  • Mandatory Reporting (Title IX)
  • Student Code of Conduct
  • Philosophy of Inclusion

Course Schedule

Important Dates

First Day of Class: August 10th (Thursday)

Non-Attendance Reporting Deadline: August 23 (Thursday)

Payment Deadline: N/A

Last Day to Drop with Refund: September 6 (Tuesday)

Student Feedback Forms Distributed: November 5 – 9

Graduation Application Deadline: N/A

Last Day to Withdraw with “W”: November 18 (Sunday)

Fall Break: November 19 – 23 – Enjoy Thanksgiving!

Student Feedback Forms Returned: November 30 (Sunday)

Last Day of Class: December 10 (Monday)

Course Plan

The following table includes the coursework planned for this class.

Week Date Topic Read To Do
Week 1, Session 1 10 Aug Orientation, introduction of teachers and students, class overview none Log into computers
Essential Computer Concepts
Week 2, Session 1 13 Aug Computer login, file system, USB drive, one drive, etc. None Listen & take notes
Week 2, Session 2 15 Aug Introduction to D2L and SAM
Essential Computer Concepts (ECC)
SAM ECC Training
Week 2, Session 3 17 Aug Take ECC Exam SAM ECC Exam
Exploring the Basics of Microsoft Windows 10 and File Manager
Week 3, Session 1 20 Aug File Management Training SAM FM Training
Week 3, Session 2 22 Aug File Management Exam SAM FM Exam
Week 3, Session 3 24 Aug Quiz 1 – Windows and FM
Word Project 1 Training
None
SAM
Take Quiz
WP1 Training
Microsoft Word
Week 4, Session 1 27 Aug Word Project 1 Exam SAM WP1 Exam
Week 4, Session 2 29 Aug Word Project 1 Project SAM WP1 Project
Week 4, Session 3 31 Aug Word Project 2 Training SAM WP2 Training
Week 5, Session 1 3 Sep Labor Day None Enjoy!
Week 5, Session 2 5 Sep Word Project 2 Exam SAM WP2 Exam
Week 5, Session 3 7 Sep Word Project 2 Project SAM WP2 Project
Week 6, Session 1 10 Sep Word Project 3 Training SAM WP3 Training
Week 6, Session 2 12 Sep Word Project 3 Exam SAM WP3 Exam
Week 6, Session 3 14 Sep Word Project 3 Project SAM WP3 Project
Week 7, Session 1 17 Sep Word Project 4 Training SAM WP4 Training
Week 7, Session 2 19 Sep Word Project 4 Exam SAM WP4 Exam
Week 7, Session 3 21 Sep Word Project 4 Project SAM WP4 Project
Week 8, Session 1 24 Sep Quiz 2 – Word
Excel Project 1 Training
None
SAM
Complete Quiz
EP1 Training
Microsoft Excel
Week 8, Session 2 26 Sep Excel Project 1 Exam SAM EP1 Exam
Week 8, Session 3 28 Sep Excel Project 1 Project SAM EP1 Project
Week 9, Session 1 1 Oct Excel Project 2 Training SAM EP2 Training
Week 9, Session 2 3 Oct Excel Project 2 Exam SAM EP2 Exam
Week 9, Session 3 5 Oct Excel Project 2 Project SAM EP2 Project
Week 10, Session 1 8 Oct Excel Project 3 Training SAM EP3 Training
Week 10, Session 2 10 Oct Excel Project 3 Exam SAM EP3 Exam
Week 10, Session 3 12 Oct Excel Project 3 Project SAM EP3 Project
Week 11, Session 1 15 Oct Excel Project 4 Training SAM EP4 Training
Week 11, Session 2 17 Oct Excel Project 4 Exam SAM EP4 Exam
Week 11, Session 3 19 Oct Excel Project 4 Project SAM EP4 Project
Week 12, Session 1 22 Oct Quiz 3 – Excel
Access Project 1 Training
None
SAM
Complete Quiz
AP1 Training
Microsoft Access
Week 12, Session 2 24 Oct Access Project 1 Exam SAM AP1 Exam
Week 12, Session 3 26 Oct Access Project 1 Project SAM AP1 Project
Week 13, Session 1 29 Oct Access Project 2 Training SAM AP2 Training
Week 13, Session 2 31 Oct Access Project 2 Exam SAM AP2 Exam
Week 13, Session 3 2 Nov Access Project 2 Project SAM AP2 Project
Week 14, Session 1 5 Nov Quiz 4 – Access
PowerPoint Project 1 Training
None
SAM
Complete Quiz
PPP1 Training
Week 14, Session 2 7 Nov PowerPoint Project 1 Exam SAM PPP1 Exam
Week 14, Session 3 9 Nov PowerPoint Project 1 Project SAM PPP1 Project
Week 15, Session 1 12 Nov PowerPoint Project 2 Training SAM PPP2 Training
Week 15, Session 2 14 Nov PowerPoint Project 2 Exam SAM PPP2 Exam
Week 15, Session 3 16 Nov PowerPoint Project 2 Project
Quiz 5 – PowerPoint
SAM
None
PPP2 Project

Complete Quiz

Catch Up
Week 16, Session 1 26 Nov Work on grade improvement
Study for Certification
None Improve/study
Week 16, Session 2 28 Nov Repeat None Improve/study
Week 16, Session 3 30 Nov Repeat None Improve/study
Certification Exam
Week 17, Session 1-3 3-7 Nov Prepare for take certification test or take test
Week 18, Session 1 10 Dec Last chance to take certification test