S23 Period 3/4 CIS1018 PC Applications

Table of Contents

  1. CCS Required Syllabus Information
  2. Front Range Community College Specific Information
  3. Grading information
  4. Course Plan

Course Information

Course Name: Introduction to PC Applications
Course Section 1: 
9:50-10:45 – Period 3
Course Section 2: 10:50-11:45 – Period 4
Semester: Spring 2023
Credits:
Prerequisites/Co-requisites: 
None
Meeting Days: 
Monday/Wednesday/Friday
Lab Days and Test Days (tests on request only): For periods 3 & 5 – Tuesday/Thursday (Labs independent class) – all tests and labs are in room HS – 228
Location: For periods 3, 5, 7: HS – 228

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.

Instructor Information

Instructors:
Wayne Cook, Head of Computer Science Department, CECFC
Office Phone: (970) 337-0044
Email: [email protected]
College Web Site: www.frontrange.edu
HS Web Site: https://fortcollins.coloradoearlycolleges.org
Office Location: CECFC HS 228
Office Hours: by appointment Tuesday or Thursday during your period or other periods.
Department Contact: N/A

Course Materials

  • Course materials are all on-line, through three sources. You need to create your own account for each. It is best to use the same login name for all sites. For example: first.last (fred.jones).
  • TestOut Office Pro ISBN: 978-1-935080-71-8
  • Windows 10
  • Microsoft Office 365/2019 (Word, Excel, Access, and PowerPoint) – provided on school computers, must be acquired for home computers, see FRCC or office.com for ways to acquire a student edition. Currently, Microsoft Office 365 is Microsoft Office 2019.
  • 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 Teams or D2L. 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 TestOut, Teams, or D2L.
  • Two helpful web pages that will help with Compaas (CertiPort) Microsoft Office Specialist certifications are Certifications :: Certiport (pearsonvue.com) and Exam tutorials :: Exam details :: Educator resources :: Certiport (pearsonvue.com).

The Course Plan is at the bottom of this page.

Welcome Message

Welcome to CIS118. Most of the work will be completed 0n-line. If you have any questions, please ask them when they arise. During the semester, every student is given the opportunity to take the Microsoft Office Certification exams. You need to arrange a time to take the certification exams, there are three (Word, Excel, and PowerPoint), close to completion of each  section. 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 or M’s for any modules, including certification exams not completed 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. Some people will complete these sections early and earn extra certifications.

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. GMetrix & Cengage Microsoft Office Specialist Word Certification Exam
  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. Create and use database forms, filters, and reports
  15. GMetrix and Cengage Microsoft Office Specialist Excel Certification Exam
  16. Create and use animation in a presentation
  17. Create and use tables in a presentation
  18. Create and use charts in a presentation
  19. Integrate word processing documents, spreadsheets, databases and presentations
  20. GMetrix & Cengage Microsoft Office Specialist PowerPoint Certification Exams
  21. Maintain a database
  22. Query a database

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. Online Essentials – from network use through online safety.
  2. Computer Essentials – Hardware and Related Software
  3. Introduction to Microsoft Office – learn all of the common features
  4. Introduction to Word – from basic through more advanced topics, like macros
  5. Introduction to Excel – from basics through complex data
  6. Introduction to PowerPoint – from creating through giving presentations
  7. Office Certification after each section – earn Word, Excel, and PowerPoint certifications after each module. Earn all three and earn your Microsoft Office Specialist Certification.
  8. Introduction to Access – from managing databases through advanced features
  9. (optional) Introduction to Outlook – included with TestOut, but not graded.

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 TestOut. At the end of Word, Excel, and PowerPoint, you will have the opportunity to become certified. Please keep up with the class schedule so that you will do well on the quizzes.

Front Range Community College Campus Information

The following information is applicable for any time you visit FRCC Larimer Campus for any reason.

Mask Requirement

FRCC has returned to requiring masks in all indoor public areas, including classrooms, effective August 10, 2021. The requirement was implemented after careful consideration and feedback from the FRCC community. If you have a medical reason for not wearing a mask, please reach out to Disability Support Services for an accommodation as soon as possible. Mask-wearing supports our plan to maintain on-campus and in-person classroom experiences this fall. Additionally, vaccinations are still critical. If you are not vaccinated, please consider getting the vaccine as soon as possible. Information on vaccines is available online: FRCC Vaccine Clinics.

Illness

If you are ill, please notify your teacher and stay home. If you test positive for COVID or are exhibiting COVID symptoms, you are required to report. Reporting instructions are available on the FRCC COVID Page.

Mental Health Counseling

Front Range Community College offers mental health counseling services to all students at no cost for the duration of their student experience. This service is provided by licensed professional counselors and is completely confidential. We do not bill insurance or take payments of any type. This service is fully funded by the college. Sessions are offered in both in-person and telehealth modalities. To make an appointment or to ask a question, please call our front desk at 970.204.8210. To request an appointment online go to https://www.therapyportal.com/p/frontrange80526/

If you are teaching an on-campus section and deleted out the template sections about Online Learning/Remote please add in something similar to the following:

Technical Difficulties/Online Requirements

All FRCC Courses have an online course site in Desire2Learn (D2L), and may incorporate other online materials (e.g. publisher content and open educational resources). As a 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 24×7 Help Desk: (http://help.cccs.edu); 888-800-9198 (toll free). Link to the 24×7 Help Desk and System Check can be found in D2L under the Tech Support Menu. D2L 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.

Interacting in Online Learning Environments

FRCC 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 online interactions are civil, respectful, and focused on the topic presented. If you notice behavior that violates this conduct, be sure to contact your instructor.

Use of Video Conferencing Technology

Our class is scheduled as a Face-to-Face Class with class meetings on campus.   Should the instructor and/or several students need to quarantine due to COVID, we will use video conferencing technology (Zoom) to hold class remotely.  Instructors will notify students and any guest speakers in advance if a live class session will be recorded. Students may choose to turn off their camera, and the instructor will only post recordings where access is restricted to other members of the class. Please contact your instructor if you have any concerns about use of video for class meetings or assignments.

Late Policy

Assignments will be expected on-time. Since TestOut, GMetrix, and Compass grade 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. Grades will be entered based on the schedule at the bottom of this document. Zeros or M’s 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.

Culture of Responsibility and Workforce Readiness

Students should read and be familiar with these school policies found on the CECFC website. Behavior contrary to these expectations will be dealt with through my classroom conduct plan outlined below. 

This class is the pre-requisite for college courses. Students are expected to conduct themselves in a manner that shows this college readiness in the following ways:

  • The student communicates questions or concerns with the teacher directly (in person or via email) and not through a third party such as a parent.
  • The student notifies the teacher of absences and communicates needs or confusion over make-up work
  • The student consistently engages respectfully and professionally in the classroom with all individuals.

CECFC’s “SOAR” expectations of student conduct:

  • (S)elf:  Developing awareness of self: strengths and limitations, identifying/understanding emotions, and managing emotions, stress, and anxiety, to become a strong and confident individual.
  • (O)thers: Developing social awareness of others’ perspectives and emotions, while also appreciating diverse backgrounds and cultures to become empathetic towards others.
  • (A)lign:  Developing the skills to build positive relationships through communicating, negotiating conflict, and supporting others (while also reducing bullying).
  • (R)esponsibility:  Developing the skills to make decisions for positive impacts on self and others, while also considering the role of ethics and professionalism in the real world.

CECFC’s expectations of academic student conduct:

  • Management: Time, Organization, and Planning
    Developing effective processes to prioritize time and create organizational systems that transfer to multiple settings.
  • Motivation: Task Initiation and Attention
    Developing motivation to initiate tasks and pay attention with a “big picture” purpose; focusing on the details and putting forth one’s best effort
  • Monitor: Metacognition, Self-Reflection, and Adjustment
    Developing the independent process of monitoring one’s own learning (metacognition), self-reflecting on that progress, and making necessary adjustments for increased success.
  • Mindset: Perseverance, Grit, and Flexibility
    Developing grit in all pursuits, especially exercising flexibility, perseverance, and creative problem solving when challenges arise; internalizing that success comes only as a result of this mindset.

Mr. Cook’s Class Rules

This class follows all CEC-FC and FRCC student policies (such as no wearing hats in class). In addition, there are 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.

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 school. The student will be subject to disciplinary action.

Student Participation expectations

Students must demonstrate active participation to be marked as present for the day. The following behaviors count for earning a present and at least one of these behaviors must be demonstrated during a synchronous class or within the 24-hour window of an asynchronous class:  

  • Posting a thoughtful response to a discussion question  
  • Participating in a “live” discussion during class  
  • Using the chat feature to appropriately engage in class material to meet the learning goal  
  • Completing a class poll related to the learning goal  
  • Completing and/or uploading a worksheet provided by the teacher  
  • Completing a Microsoft Form quiz, questions, or response  
  • Creating and sharing a Flipgrid video  
  • Other assignments according to instructor’s discretion 

Video Recording and Sharing 

If requested, live classes via Teams and D2L will be recorded and provided for all students to access at a later time in order to accommodate students who are unable to attend class and for students to material if needed. All of these course materials provided online are the property of the instructor. This includes videos, voice recordings, pictures, handouts, slides, etc. The following are appropriate uses of all materials provided by your instructor via Teams, D2L, or email. 

  • Downloading videos/voice recordings for yourself to review in connection to the course 
  • Saving or printing files to assist yourself in completing course work 

Students cannot download, print, post, or use the course materials in any other way without written consent from the instructor. Ensure that you ask for permission prior to using or sharing the intellectual property of the instructor for any other purposes other than completing and understanding coursework.  

Tutoring 

Tutoring is available through the Wolf Den and highly encouraged for students at all levels needing or wanting support in their courses. Visit the Wolf Den in person or on the CEC website to make an appointment.  

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.  Whether intentional or accidental, Plagiarism 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 CECFC 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 (if chosen)

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 you must register for the exam. Also, please plan to:

  • Bring a photo ID.
  • Arrive at the FRCC Testing Center (or login to a remote testing site) early enough to allow enough time to complete the exam before it closes.
  • Schedule around busy periods in the semester, there can be an extra wait time 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

Grade Information

Graded Instructional Activities

Total points will be computed as follows. The total points for quizzes and assignments will vary.

ActivitiesOverall Grade %
Participation5%
TestOut Exercises (Word/Excel/PowerPoint/Access)55%
GMetrix MOS Practice Exams (W/E/PP/A)10%
Certiport MOS Certification Exams (Word/Excel/PowerPoint)30%
Weighted Grading for Class

Grading Scales and Standards

The grading scale for this class is:

Letter GradeRange
A90 – 100%
B80 – 89%
C70 – 79%
F69% and lower
Grading Cutoffs – no rounding

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.

Grading for Certiport/Compass MOS Certifications

Certiport (Compass) Microsoft Office Specialists Certification Exams have a possible 1,000. points To earn your certification, you must earn at least 700 points. When you have passed your certification exam, that is considered a completed exam and thus earning 100% on your grade. The point breakdown is as follows:

Minimum Exam GradeGradebook Grade
700 – 1000100
0 – 699% earned  out of 1000
  
Grading Table for Certiport (Compass on Desktop) Microsoft Office Specialist Certification Exams

Course Schedule

CECFC Academic Calendar

FRCC Academic Calendar

Important Dates

  • First Day of Class: 4 January (Wednesday)
  • Martin Luther King Birthday (no school) 16 January (Monday)
  • Non-Attendance Reporting Deadline: 20 January (Friday)
  • Payment Deadline: N/A
  • Last Day to Drop with Refund: 1 February (Wednesday)
  • President’s Day (no school) 20 February (Monday)
  • Graduation Application Deadline: N/A
  • Spring Break: 13-17 March – Enjoy the week!
  • Student Feedback Forms Available: TBD
  • Last Day to Withdraw with “W”: 16 April (Saturday)
  • Student Feedback Forms Returned: Not Scheduled
  • Last Day of Class: 9 May (Tuesday)

Course Plan

The following table includes the coursework planned for this class. I will be grading assignments when they are due. Assignments not yet submitted will be listed as missing (M) in the gradebook. You can still do the assignment for full credit, but this gives you a better idea about your current grade.

WeekTopic
Overview
1Getting Started Online Essentials Create TestOut and Certiport accounts
Computer Essentials
1.1.18 Information Age Questions
1.2.16 Internet and Social Media Questions
1.4.13 Practice Online Safety
1.5.8 Evaluating Online Information
2.1.16 Set Up a Computer
2.1.19 Computer Hardware Questions
2.2.18 System Software Concept Questions
2.3.14 File Management Concept Questions
2Common Office Features
2.4.8 Open and print a document in Word
3.1 through 3.5 Do Skills and Challenge Labs
Microsoft Word Sections
3Introduction to Microsoft Word
4.1- 4.5 Do Skill Labs to learn Skills. Do Applied Labs in each Section to solidify skills.
44.6- 4.10 Do Skill Labs to learn Skills. Do Applied Labs in each Section to solidify skills.
54.11- 4.12 Do Skill Labs to learn Skills. Do Applied Labs in each Section to solidify skills. 6.6 PowerPoint Smart Art (not covered but needed for Word Certification exam). Prepare for Microsoft Office Specialist Certification for Word. Review Section B.1 for information on MOS Word Certification, then take Exam B.2 Word MOS Associate 2019 (MS-100); B.2.1 Microsoft Word Practice – Form A; B.2.2 Microsoft Word Practice – Form B, Practice Exams B.3.1 and B.3.2 may also be helpful. These exams have the instructions across the bottom, the same as the Word Certification Exam. This may be helpful in practicing for the exam.
6Do one or two TestOut Section B Microsoft Word practice exams and, if you have completed the other assignments, schedule Microsoft Office Specialist Word exam either in person on Tuesday or Thursday during your class period or after class on Monday, Wednesday, or Thursday.
Microsoft Excel Sections
7Introduction to Microsoft Excel
5.1- 5.5 Do Skill Labs to learn Skills. Do Applied Labs in each Section to solidify skills.
85.6- 5.10 Do Skill Labs to learn Skills. Do Applied Labs in each Section to solidify skills. Prepare for Microsoft Office Specialist Certification Review Section A.1 and A.3 for Excel Review Section B.1 for information on MOS Excel Certification Exam B.3 Excel MOS Associate 2019 (MS-100) B.3.1 Microsoft Excel Practice – Form A B.3.2 Microsoft Excel Practice – Form B.
9Do one of the projects in Section 5.11. This will help you understand how to use Excel. The three projects are: 5.11.4: Modify Expense Report, 5.11.5: Analyze Sales Data, and 5.11.6: Analyze Sales Transactions. Choose which one will help you the most.
Do B.4 Excel Test or one or two TestOut Section B.5 Microsoft Excel practice exams and, if you have completed the other assignments, schedule Microsoft Office Specialist Excel exam either in person on Tuesday or Thursday during your class period or after class on Tuesday or Thursday.
10Spring Break
Microsoft PowerPoint Sections
11Introduction to Microsoft PowerPoint
6.5, 6.6, and 6.9 Do Skill Labs to learn Skills. Do Applied Labs in each Section to solidify skills. Word covers most of the other sections. If you have problems with the GMetrix exam, then is the time to review the other sections. Prepare for Microsoft Office Specialist Certification Review Section A.1 and A.4 for PowerPoint Review Section B.1 for information on MOS Excel Certification Exam B.4 PowerPoint MOS Associate 2019 (MS-100) B.4.1 Microsoft PowerPoint Practice – Form A B.4.2 Microsoft PowerPoint Practice – Form B.
Microsoft Access
12Catch up and schedule Microsoft Office Specialist PowerPoint exam
137.1- 7.4 Skill Labs, they will be part of the graded assignments Do both Applied Labs in each Section to solidify skills
147.1- 7.4 Skill Labs, they will be part of the graded assignments Do both Applied Labs in each Section to solidify skills
157.5- 7.7 Skill Labs, they will be part of the graded assignments Do both Applied Labs in each Section to solidify skills
16Ask for a GMetrix (gmetrix.net) account code. Do one or two GMetrix Microsoft Access practice exams and, if you have completed the other assignments, schedule Microsoft Office Specialist Access exam either in person on Tuesday or Thursday during your class period or after class on Monday, Wednesday, or Thursday.
17If you want to earn your Outlook Certification, review chapter 8 in TestOut. This should give you enough information to pass Outlook.
Review
18When you have finished the required work, now is the time to earn additional Certificates. The Access is an Expert Exam, so one more Expert (like Word or Excel) will earn you a Microsoft Office Specialist Expert Certification. The Possible certificates are: Word, Excel, PowerPoint, MOS Associate (comes with earning any three), Access Expert, Excel Expert (there is an additional course for this), Word Expert (most people pass this by passing the GMetrix Word Expert practice exam), MOS Expert (need two of the three expert certifications), and Outlook. Taking and passing all three certificates is possible.
19Wrap up and Review
Weekly Schedule