Skip to main contentSkip to footer

CAWT 156 - Microsoft Excel II - Janet English

Course:Microsoft Excel II
Professor:Janet English
  • Online
  • Hybrid
Course Length:
  • Applies to All Course Lengths


My name is Janet English, and I will be your guide for this learning experience. I have been with College of the Canyons for twenty years. I look forward to getting to know each of you throughout the semester.

In this day and age, we are fortunate to be able to offer online and hybrid education courses in order to accommodate so many of you who may not have the time or resources to always attend classes on campus due to modern societal pressures, including professional obligations, familial responsibilities, and financial or health concerns. It should not, however, be assumed that an online or hybrid education class is in any way easier than an on-campus class. In fact, just the opposite may be true since, to be successful, students in online and hybrid classes must rely more on their own resourcefulness, discipline, good time management and study habits, as well as finding within themselves the means to remain motivated.

This course is either 100% online or a hybrid course.

All correspondence will be carried out using the Inbox in Canvas, Discussion Boards, and email. Students are expected to log in to Canvas often and to read all posted Announcements and Pages as directed.

100% online courses will have no scheduled on-campus meetings. However, there will be non mandatory Zoom lectures for each module, according to the schedule posted on Canvas and in your Weekly Assignment Schedule.

Hybrid courses will meet in the classroom for a specified number of times. A Schedule Announcement will be sent out prior to the first day of the semester. Should you realize that you cannot meet on-ground on any specified day, you must send me a Message via Canvas Inbox. In addition, there will be non mandatory Zoom lectures for modules not reviewed during on-campus meetings, according to the schedule posted on Canvas and in your Weekly Assignment Schedule.

For either online or hybrid courses, a recording of the Zoom lectures will be provided on Canvas for students to review. In addition, there will be one non mandatory open lab Zoom scheduled per week where students may get help with their assignments. One-on-One Zoom Meetings may also be available, by appointment

Whether your course is a hybrid or online format, my hope is to get to know each of you the same as if we interacted weekly face-to-face in a classroom.

Course Description

Provides a continuation of CAWT-155, presenting a comprehensive overview of advanced features of Microsoft Excel, including templates, SmartArt images, Pivot table reports, Pivot chart reports, formula auditing, data validation, and the use of Macros and Visual Basic for applications. Prepares students to take the MOS exam in Excel.

Students will work on a variety of interesting productivity exercises that simulate those projects encountered in a real, modern office environment. Students will be able to assess their progress by using the Cengage Skills Assessment Manager SAM (through MindTap), an engaging and interactive online simulator that transforms students into Microsoft Excel concept masters. SAM (through MindTap) is not only powerful and effective, but it is also fun to use.

All student assignments will be submitted on Canvas or submitted directly to the MindTap website through the individual assignment links in each module on Canvas.

This course requires proficiency with the operating system of your computer, computer file management, the Internet, a browser (Google Chrome), and the ability to send e-mail.

What to Expect in this Course

Students are expected to spend the appropriate amount of time necessary to complete the weekly assignments.

SKILL REQUIREMENTS --Prior to taking this course, students should have acquired the following skills:

  • Proficiency with Microsoft Windows 10 or 11 (especially file management).
  • Proficiency with the Internet and the browser Google Chrome
  • Proficiency with e-mail, including the ability to send and receive attachments.
  • Proficiency with the creation and extraction of zip archives (.zip files)

TECHNOLOGY REQUIREMENTS --Prior to taking this course, students must have in their possession or access to the following:

  • Cengage Unlimited MindTap account which includes access to the MindTap Program and the E-Book
  • The Microsoft Excel 365, 2019, or 2021 application as well as Word and PowerPoint. You can Download Microsoft Office for Students through your MyCanyons Email. These instructions walk you through the process step-by-step.
  • Reliable access to broadband Internet
  • A computer with Windows 10 or higher
  • Browser software (Latest version of Google Chrome)
  • Adobe Reader, latest version (free download at
  • Izarc, Winzip (free download from, 7 zip (free download from or an equivalent archive and file extracting utility(a zip and unzip program)
  • Windows 10 and 11 have a built-in archiving utility
  • A media player that is compatible with mpg4, mov, wmv, and swf formats (free VLC media player is recommended:
  • A College of the Canyons e-mail account
  • IMPORTANT: Students must have access to a desktop or regular laptop computer to work effectively with SAM. Use of the Surface Pro, tablets, or smartphones is problematic with SAM and these devices are not adequate for this class.


Types of Assessments

Online Assessments, Exams, and Discussions.

Textbook Information / Link to ZTC Textbook

Cengage Unlimited is a subscription program from Cengage Publishing. When students subscribe to Cengage Unlimited, they will have access to ALL Cengage digital learning platforms, ebooks, and online homework and study tools, for one price, for the length of their subscription, for any course that uses Cengage materials.

Students will have the opportunity to subscribe for one term, one year, or two years. If students want a printed book, they will be available for rental through the Cengage Unlimited subscription.

When the subscription ends, students can keep up to six textbooks in a "digital locker" and access them anytime for up to a year at no cost. Students may also upgrade to a longer subscription at any time during their subscription period for the difference in the price of the two subscriptions.

Students will be able to purchase this subscription from directly, ISBN: 9780357700006

Cengage Unlimited is also available at the Campus Bookstore; however, please check the price before purchasing.

Click Here for More Information about Cengage Unlimited:

Review the video and scroll down to read all the information about this exciting new program.

PLEASE NOTE: If you purchased Cengage Unlimited for CAWT 155 in the previous semester, you do not need to purchase another Cengage Unlimited code for this course. This course is a continuation of CAWT 155 and uses the same book. You will login in to MindTap through Canvas, as you did for CAWT 155, with the same user name and password. However, if you took CAWT 155 several semesters prior, you may need to purchase a new subscription.

Other Relevant Course Information


All students must use their e-mail account created for them by the College. In order to authenticate student identities and comply with FERPA regulations, instructors have been asked by the College to respond only to student e-mail originating from a account. The account is integrated with Microsoft Office 365, which includes a free 1TB OneDrive account for cloud data storage. All students must make sure that they have activated their e-mail account. To activate your account, log into MyCanyons (WebAdvisor) on the college web site and follow the appropriate links related to student e-mail.

Please always insert your course number (156 and course section number) in the Subject header of your e-mails and identify yourself at the end of your e-mail messages with your full name.

If you send your e-mail messages directly through Canvas, the course and section will be identified automatically.

Additional Resources


This course can be accessed on the first day of class via Canvas at Log into Canvas using your CanyonsID single sign-on:

  • CanyonsID Username is your COC student email address (Ex:
  • CanyonsID Password is your COC student email password

Please visit the Get to Know Your Online Classroom page for help logging into Canvas and for tips on using Canvas and Zoom. Canvas Chat Support is also available 24/7 for any Canvas related issues.

Online Education

Check out the Online Education website for more information on a variety of topics that can help you be a successful online student such as: exam proctoring, learning styles, computer skills, and tips for student success. If this is your first online course, feel free to take our online learning readiness assessment to assess your skills.

The Learning Center (TLC)

The TLC provides FREE online tutoring resources to COC students!

Academic Accommodation Center (AAC)

College of the Canyons AAC provides educational services and access for eligible students with documented disabilities who intend to pursue coursework at COC. A variety of programs and services are available which afford eligible students with disabilities the opportunity to participate fully in all aspects of the college programs and activities through appropriate and reasonable accommodations. For more information on their services visit the Academic Accomodation Center website.

Online Counseling

The Counseling Department offers appointments online. You can schedule an appointment by visiting the Online Counseling website. Counselors can help you map out a plan to reach your educational goals as well as advise you on course selection and registration.

Management of Stress and Mental Health

College of the Canyons cares about your emotional and physical health. Learn more about the broad range of confidential student services, including free counseling and mental health services available during this time by visiting the Student Health & Wellness Center website or by calling them at: 661-362-3259.

The National Suicide Lifeline number is 1-800-273- 8255 (TALK). Please call it if you or someone you know is having thoughts of suicide or is in severe distress - it could save someone's life.

You can also use the Crisis Text Line: Just text "Courage" to 741741. It's free, available 24/7, and confidential.

Veterans Resource Center

The College of the Canyons Veterans Resource Center is a department within the Student Services Division at the college, created to help veterans and veteran dependents with applying to College of the Canyons, enrolling in classes, and requesting VA Education or Vocational Benefits. For more information please visit the Veterans Resource Center website, email or phone (661) 362-3469.


The Library provides live online and in-person research help, access to a full range of e-resources and physical materials that support the curriculum, individual and group study areas, and much more!

Last updated: 10/25/2022 Sub#: 1049