Basic Course Information
Course Name: Introduction to PC Applications
Course Section 1: CIS118-64855-78A – Period 2 (number needs updating)
Course Section 2: CIS118-65818-78B – Period 3 (number needs updating)
Semester: Fall 2019
Credits: 3
Prerequisites/Co-requisites: None
Meetings/Times: Mon/Wed/Fri 8:50 AM – 9:45 AM – Period 2
Meetings/Times: Mon/Wed/Fri 9:50 AM – 10:45 AM – Period 3
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
- Course materials are all on-line. The manual is the Shelly-Cushman Microsoft Office 365 abd Iffuce 2019 book (ISBN 978-0-350726229) and can be referenced through the Cengage interface. Scores will be kept in Cengage and in Infinite Campus.
- 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. I will stick to the schedule at the bottom of this document. You have all semester to complete the material, but I will enter 0’s for any modules not yet started by the due date. This will give you a better idea of what your final grade will be for the class as the semester progresses.
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
- Define the basic hardware and software concepts associated with personal computers
- Demonstrate the ability to utilize network and internet terminology
- Navigate the operating system
- Organize and manipulate file names, locations, and backups
- Create, modify, use and print word processing documents, spreadsheets, relational databases and presentations
- Apply formatting techniques to word processing documents, spreadsheets, databases and presentations
- Create, insert and modify visual elements (graphics, charts, tables, ClipArt, etc) in word processing documents, spreadsheets, databases and presentations
- Create and format a word processing report
- Use desktop publishing features e.g. columns, newsletter, web pages, etc.
- Create and use mail merge
- Create and modify spreadsheet formulas and functions
- Create, insert and modify spreadsheet charts
- Make use of relative and absolute cell references
- Maintain a database
- Query a database
- Create and use database forms, filters, and reports
- Create and use animation in a presentation
- Create and use tables in a presentation
- Create and use charts in a presentation
- Integrate word processing documents, spreadsheets, databases and presentations
- 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
- Computer hardware overview
- File System overview
- Introduction to Word
- Introduction to Excel
- Introduction to Access
- Introduction to PowerPoint
- 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. Grades will be entered based on the schedule at the bottom of this document. Zeros will be entered when the assignment is due, if it is not done. You can attempt to catch up, but it is much easier to stay on task. This room will be open on Tuesdays and Thursdays to give you time to catch up with the class schedule.
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.
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:
- Treat each person in this room with the respect with which you would like to be treated.
- 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: 8 August (Thursday)
Non-Attendance Reporting Deadline: 15 August (Thursday)
Payment Deadline: N/A (unless you do not pass the course)
Labor Day: 2 September – no school
Last Day to Drop with Refund: 4 September (Wednesday)
School Closed: 17-18 October – no school
Student Feedback Forms Distributed: 2-6 December
Graduation Application Deadline: N/A
Last Day to Withdraw with “W”: 17 November (Sunday)- Pay for course
Thanksgiving Break: 25-29 November – Enjoy Fall Break!
Student Feedback Forms Returned: 1 December (Sunday)
Last Day of Class: 10 December (Tuesday)
Course Plan
The following table includes the coursework planned for this class.
To Do
| Week | Date | Topic | Read | To Do |
|---|---|---|---|---|
| Week 1, Session 1 | 9 Aug | Orientation, introduction of teachers and students, class overview, Computer login | none | Log into computers |
| Essential Computer Concepts | ||||
| Week 2, Session 1 | 12 Aug | Introduction to file system, USB drive, OneDrive, etc. | None | Listen & take notes |
| Week 2, Session 2 | 14 Aug | Introduction to D2L and/or Infinite Campus and SAM Essential Computer Concepts (ECC) Training |
SAM | ECC Training |
| Week 2, Session 3 | 16 Aug | Essential Computer Concepts Exam | SAM | ECC Exam |
| Exploring the Basics of Microsoft Windows 10 and File Manager | ||||
| Week 3, Session 1 | 19 Aug | File Management Training & Exam | SAM | FMT & FME |
| Internet Basic and Information Literacy | ||||
| Week 3, Session 2 | 21 Aug | Internet Basic and Information Literacy Training & Exam | SAM | IBILT & IBILE |
| Microsoft Word | ||||
| Week 3, Session 3 | 23 Aug | Introduction to Word and MLA/APA Formats | Lecture | MLA/APA Papers |
| Week 4, Session 1 | 25 Aug | Word Lesson 1 Training & Project A | SAM | WL1T & WL1E |
| Week 4, Session 2 | 27 Aug | Word Lesson 1 Project B & Exam | SAM | WL1PB & WL1E |
| Week 4, Session 3 | 29 Aug | Word Lesson 2 Training & Project A | SAM | WL2T & WL2PA |
| Week 5, Session 1 | 2 Sep | Labor Day – no school | None | Enjoy!>/u> |
| Week 5, Session 2 | 4 Sep | Word Lesson 2 Project B & Exam | SAM | WL2PB & WL2E |
| Week 5, Session 3 | 6 Sep | Word Story Telling Project | Lecture | Word Story |
| Week 6, Session 1 | 9 Sep | Word Lesson 3 Training & Project A | SAM | WL3T & WL3PA |
| Week 6, Session 2 | 11 Sep | Word Lesson 3 Project B & Exam | SAM | WL3PB & WL3E |
| Week 6, Session 3 | 13 Sep | Word Lesson 4 Training & Project A | SAM | WL4T & WL4PA |
| Week 7, Session 1 | 16 Sep | Word Lesson 4 Project B & Exam | SAM | WL4PB & WL4E |
| Microsoft Excel | ||||
| Week 7, Session 2 | 18 Sep | Word Capstone Introduction to Excel |
SAM Lecture |
WdCap Intro Excel |
| Week 7, Session 3 | 20 Sep | Excel Lesson 1 Training & Project A | SAM | EL1T & EL1PA |
| Week 8, Session 1 | 23 Sep | Excel Lesson 1 Project B & Exam | SAM | EL1PB & EL1E |
| Week 8, Session 2 | 25 Sep | Lesson 2 Training & Project A | SAM | EL2T & EL2PA |
| Week 8, Session 3 | 27 Sep | Excel Lesson 2 Project B 1 & Exam | SAM | EL2PB & EL2E |
| Week 9, Session 1 | 30 Sep | Excel Lesson 3 Training & Project A | SAM | EL3T & EL3PA |
| Week 9, Session 2 | 2 Oct | Excel Lesson 3 Project B & Exam | SAM | EL3PB & EL3E |
| Week 9, Session 3 | 4 Oct | Excel Lesson 4 Training & Project A | SAM | EL4T & EL4PA |
| Week 10, Session 1 | 7 Oct | Excel Lesson 4 Projects B & Exam | SAM | EL4PB & EL4E |
| Week 10, Session 2 | 9 Oct | Excel Capstone | SAM | ExCap |
| Microsoft Access | ||||
| Week 10, Session 3 | 11 Oct | Introduction to Microsoft Access & Databases | SAM | Access |
| Week 11, Session 1 | 14 Oct | Access Lesson 1 Training | SAM | AL1T |
| Week 11, Session 2 | 16 Oct | Access Lesson 1 Project A | SAM | AL1PA |
| Week 11, Session 3 | 18 Oct | School Closed | None | Enjoy |
| Week 12, Session 1 | 21 Oct | Access Lesson 1 Project B & Exam | SAM | AL1PB & AL1E |
| Week 12, Session | 23 Oct | Access Lesson 2 Training | SAM | AL2T |
| Week 12, Session 3 | 25 Oct | Access Lesson 2 Project A | SAM | AL2PA |
| Week 13, Session 1 | 28 Oct | Access Lesson 2 Project B & Exam | SAM | AL2PB & AL2E |
| Week 13, Session 2 | 31 Oct | Access Lesson 3 Training | SAM | AL3T |
| Week 13, Session 3 | 1 Nov | Access Lesson 3 Project A | SAM | AL3PA |
| Week 14, Session 1 | 4 Nov | Access Lesson 3 Project B & Exam | SAM | AL3PB & AL3P2 |
| Week 14, Session 2 | 6 Nov | Access Lesson 4 Training & Project A | SAM | AL4T & AL4PA |
| Week 14, Session 3 | 8 Nov | Access Lesson 4 Project B & Exam | SAM | AL4PB & AL4E |
| Week 15, Session 1 | 11 Nov | Access Capstone | SAM | AcCap |
| Microsoft PowerPoint | ||||
| Week 15, Session 2 | 13 Nov | PowerPoint Lesson 1 Training & Project A | SAM | PP1T & PP1PA |
| Week 15, Session 3 | 15 Nov | PowerPoint Lesson 1 Project B & Exam | SAM | PP1PB & PP1E |
| Week 16, Session 1 | 18 Nov | PowerPoint Lesson 2 Training & Project A | SAM | PP2T & PP2PA |
| Week 16, Session 2 | 20 Nov | PowerPoint Lesson 2 Project B & Exam | SAM | PP2PB & PP2E |
| Week 16, Session 3 | 22 Nov | PowerPoint Capstone> | SAM | |
| Week 17, Session 1 | 25 Nov | Thanksgiving Week | None | Enjoy! |
| Week 17, Session 2 | 27 Nov | Thanksgiving Week | None | Enjoy! |
| Week 17, Session 3 | 29 Nov | Thanksgiving Week | None | Enjoy! |
| Catch Up | ||||
| Week 18, Session 1 | 2 Dec | PowerPoint Lesson 2 Projects 1 & 2 | SAM | PL2P1 & PL2P2 |
| Week 18, Session 2 | 4 Dec | PowerPoint – Capstone | SAM | PPCap |
| Week 18, Session 3 | 6 Dec | Work on grade improvement Study for Certification |
SAM | Improve/study |
| Certification Exam | ||||
| Week 19, Session 1 | 9 Dec | If offered, last chance to take certification test | Certif! | Exam |