Periods 1&2 – CIS118 – Introduction to PC Applications – Spring 2019

Basic Course Information

Course Name: Introduction to PC Applications
Course Section 1: CIS118-64855-78A – Period 1
Course Section 2: CIS118-65818-78B – Period 2
Semester: Spring 2019
Credits: 3
Prerequisites/Co-requisites: None
Meetings/Times: Mon/Wed/Fri 7:50 AM – 8:45 AM – Period 1
Meetings/Times: Mon/Wed/Fri 8:50 AM – 9:45 AM – Period 2
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, your OneDrive account, 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 and CECFC 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 lessons. 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 30 minutes of class, you will be marked tardy. If you are more than 30 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 and CECFC provide faculty, staff and students a resource to report their concern about any member of the FRCC and/or CECFC 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 at FRCC (as long as you pass your courses, financial aid is not needed at CECFC): 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/CECFC, 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. Please also see the CECFC Attendance Policies previously stated.

Computer Ethics: A student will be subject to disciplinary action should he/she try to copy FRCC/CECFC 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 and CECFC are 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/CECFC 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/CECFC 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: 3 January (Thursday)
Non-Attendance Reporting Deadline: 17 January (Thursday)
Payment Deadline: N/A (unless you do not pass the course)
Last Day to Drop with Refund: 5 February (Tuesday)
Student Feedback Forms Distributed: 15-19 April
Graduation Application Deadline: N/A
Last Day to Withdraw with “W”: 14 April (Sunday)
Soring Break: 15-19 April – Enjoy Spring Break!
Student Feedback Forms Returned: 28 April (Sunday)
Last Day of Class: 13 May (Monday)

Course Plan

The following table includes the coursework planned for this class.

Week Date Topic Read To Do
Week 1, Session 1 4 Jan Orientation, introduction of teachers and students, class overview none Log into computers
Essential Computer Concepts
Week 2, Session 1 7 Jan Computer login, file system, USB drive, OneDrive, etc. None Listen & take notes
Week 2, Session 2 9 Jan Introduction to D2L and/or Infinite Campus and SAM
Essential Computer Concepts (ECC) Training
SAM ECC Training
Week 2, Session 3 11 Jan Essential Computer Concepts Exam SAM ECC Exam
Exploring the Basics of Microsoft Windows 10 and File Manager
Week 3, Session 1 14 Jan File Management Training & Exam SAM FMT & FME
Internet Basic and Information Literacy
Week 3, Session 2 16 Jan Internet Basic and Information Literacy Training & Exam SAM IBILT & IBILE
Microsoft Word
Week 3, Session 3 18 Jan Introduction to Word and MLA/APA Formats Lecture MLA/APA Papers
Week 4, Session 1 21 Jan Martin Luther King Birthday None Enjoy!
Week 4, Session 2 23 Jan Word Lesson 1 Training & Exam SAM WL1T & WL1E
Week 4, Session 3 25 Jan Word Lesson 1 Projects 1 & 2 SAM WL1P1 & WL1P2
Week 5, Session 1 28 Jan Word Lesson 2 Training & Exam SAM WL2T & WL2E
Week 5, Session 2 30 Jan Word Lesson 2 Projects 1 & 2 SAM WL2P1 & WL2P2
Week 5, Session 3 1 Feb Word Story Telling Project Lecture Word Story
Week 6, Session 1 4 Feb Word Lesson 3 Training & Exam SAM WL3T & WL3E
Week 6, Session 2 6 Feb Word Lesson 3 Projects 1 & 2 SAM WL3P1 & WL3P2
Week 6, Session 3 8 Feb Word Lesson 4 Training & Exam SAM WL4T & WL4E
Week 7, Session 1 11 Feb Word Lesson 4 Projects 1 & 2 SAM WL4P1 & WL4P2
Microsoft Excel
Week 7, Session 2 13 Feb Word Capstone
Introduction to Excel
SAM
Lecture
WdCap
Intro Excel
Week 7, Session 3 15 Feb Excel Lesson 1 Training & Exam SAM EL1T & EL1E
Week 8, Session 1 18 Feb Presidents’ Day None Enjoy!
Week 8, Session 2 20 Feb Excel Lesson 1 Projects 1 & 2 SAM
SAM
EL1P1 & EL1P2
Week 8, Session 3 22 Feb Lesson 2 Training & Exam SAM EL2T & EL2E
Week 9, Session 1 25 Feb Excel Lesson 2 Projects 1 & 2 SAM EL2P1 & EL2P2
Week 9, Session 2 27 Feb Excel Lesson 3 Training & Exam SAM EL3T & EL3E
Week 9, Session 3 1 Mar Excel Lesson 3 Projects 1 & 2 SAM EL3P1 & EL3P2
Week 10, Session 1 4 Mar Excel Lesson 4 Training & Exam SAM EL4T & EL4E
Week 10, Session 2 6 Mar Excel Lesson 4 Projects 1 & 2 SAM EL4P1 & EL4P2
Week 10, Session 3 8 Mar Excel Capstone SAM ExCap
Microsoft Access
Week 11, Session 1 11 Mar Introduction to Microsoft Access & Databases SAM Intro Access
Week 11, Session 2 13 Mar Access Lesson 1 Training SAM AL1T
Week 11, Session 3 15 Mar Access Lesson 1 Exam SAM AL1E
Spring Break – 15-24 March
Week 12, Session 1 25 Mar Access Lesson 1 Projects 1 & 2 SAM AL1P1 & AL1P2
Week 12, Session 2 27 Mar Access Lesson 2 Training SAM AL2T
Week 12, Session 3 29 Mar Access Lesson 2 Exam SAM AL2E
Week 13, Session 1 1 Apr Access Lesson 2 Projects 1 & 2 SAM AL2P1 & AL2P2
Week 13, Session 2 3 Apr Access Lesson 3 Training SAM AL3T
Week 13, Session 3 5 Apr Access Lesson 3 Exam SAM AL3E
Week 14, Session 1 8 Apr Access Lesson 3 Projects 1 & 2 SAM AL3P1 & AL3P2
Week 14, Session 2 10 Apr Testing – NO CLASS ——-
Week 14, Session 3 12 Apr Testing – NO CLASS ——-
Week 15, Session 1 15 Apr Access Lesson 4 Training & Exam SAM AL4T & AL4E
Week 15, Session 2 17 Apr Access Lesson 4 Projects 1 & 2 SAM AL4P1 & AL4P2
Week 15, Session 3 19 Apr Access Capstone SAM AcCap
Week 16, Session 1 22 Apr School Holiday School Closed Enjoy!
Week 16, Session 2 24 Apr PowerPoint Lesson 1 Training & Exam SAM PL1T & PL1E
Week 16, Session 3 26 Apr PowerPoint Lesson 1 Projects 1 & 2 SAM PL1P1 & PL1P2
Week 17, Session 1 29 Apr PowerPoint Lesson 2 Training & Exam SAM PL2T & PL2E
Week 17, Session 2 1 May PowerPoint Lesson 2 Projects 1 & 2 SAM PL2P1 & PL2P2
Week 17, Session 3 3 May PowerPoint – Capstone SAM PPCap
Catch Up
Week 18, Session 1 6 May Work on grade improvement
Study for Certification
SAM Improve/Study
Week 18, Session 2 8 May Work on grade improvement
Study for Certification
SAM Improve/study
Week 18, Session 3 10 May Repeat None Improve/study
Certification Exam
Week 18, Session 1-3 6-10 May Prepare to take certification test or take test
Week 19, Session 1 13 May If offered, last chance to take certification test Cert Exam?