Instructor: Sompheng Batch
Email: sbatch@wvc.edu
Zoom Meeting ID/Phone: (509) 682-6653
Office: Sexton 6002A
Zoom Office Hour Link: https://wvc.zoom.us/my/sbatch
Schedule an appointment with me
Components Included
- Lecture
Preparation for Microsoft Office Specialist Excel exam. Students will create and manage workbooks and worksheets, modify and format cell content, present data in tables and charts, perform calculations on data, and insert and format objects in a worksheet.
GRADE EQUIVALENT BY PERCENTAGE:
|
Grade |
Percentage |
Grade |
Percentage |
|
A |
94-100% |
C |
73-76% |
|
A- |
90-93% |
C- |
70-72% |
|
B+ |
87-89% |
D+ |
67-69% |
|
B |
83-86% |
D |
60-66% |
|
B- |
80-82% |
F |
0-59% |
|
C+ |
77-79% |
|
|
GRADING CRITERIA:
|
Criteria |
Percentage |
|
Projects |
50% |
| Professionalism (Trainings & Discussions) |
30% |
| Exams |
20% |
- Manage and share workbooks
- Apply custom formats and layouts
- Create advanced formulas
- Create advanced charts and tables
|
Professionalism is an important part of any career – especially in the business world! As a student in this course you must be self-motivated, prepared, timely, and thorough in your work to be considered “Professional.” As a professional you will also be expected to do the following:
- Login to class sessions regularly (at least 5 times a week) and participate in roll call activities and group discussions.
- Read, complete and submit assignments and exams by due dates.
- Communicate clearly and effectively with instructor and peers.
- Be able to troubleshoot technical issues as it occurs.
- Follow all course policies and procedure
- Have all the necessary resources and technology requirements for the course.
- Be courteous and respectful when interacting with others.
- All assignments and exams must be submitted before or on the due date. Late assignments/exams will not be graded unless there is a prior arrangement for completing work. All submitted work is final after the due date and no extra credit work is available.
- Academic dishonesty is unacceptable! Plagiarism and cheating are serious offenses and may result in failure on exam or assignments or failure in the course. Please refer to the “WVC Discipline Code” in the WVC Student Handbook for more details. All SAM project submissions are aligned with your account and the instructor is notified when student submission has been copied, altered or shared. In other words, please submit your own work at all times.
- If you have concerns about your ability to be successful in this class or need accommodation, please email the Student Access Department or you can contact the coordinator by phone at (509) 682-6854 for the Wenatchee campus and at (509) 682-7852 for the Omak campus.
| Weeks | Topics | Assignments |
|---|---|---|
| Weeks 1/3 | Course Logistics Module 1: Getting Started With Excel |
SAM Module 1 Training and 3 SAM Projects: |
| Weeks 2/4 | Module 2: Formatting Workbook Text and Data |
SAM Module 2 Training and 3 SAM Projects: |
| Weeks 3/5 | Module 3: Performing Calculations with Formulas and Functions |
SAM Module 3 Training and 3 SAM Projects: Textbook, A & B Module 3 Canvas Discussions and Exam |
| Weeks 4/6 |
Module 4: Analyzing and Charting Financial Data |
SAM Module 4 Training and 3 SAM Projects: Textbook, A & B Module 4 Canvas Discussions and Exam SAM Midterm Capstone Project |
| Weeks 5/7 |
Module 5: Generating Reports from Multiple Worksheets and Workbooks |
SAM Module 5 Training and 3 SAM Projects: Textbook, A & B Module 5 Canvas Discussions and Exam |
| Weeks 6/8 | Module 6: Managing Data with Data Tools |
SAM Module 6 Training and 3 SAM Projects: Textbook, A & B Module 6 Canvas Discussions and Exam |
| Weeks 7/10 | Module 7: Summarizing Data with PivotTables | SAM Module 7 Training and 3 SAM Projects: Textbook, A & B Module 7 Canvas Discussions and Exam |
|
Week 10 |
Note: Use the downloaded module files for case problems found at the end of each module to further practice concepts on your own. NO submissions required. |
|
SAM (Skills Assessment Manager) is a web-based application that measures student proficiency in Microsoft Office software and technology-related topics. SAM uses skill-based assessments, interactive training, real-world projects and just-in-time remediation to help you master essential computing skills. You will need to have a Cengage Unlimited account or purchase a SAM access code with an e-book in order to complete projects and trainings for modules 1 through 7. You can purchase Cengage Unlimited/SAM access code through the WVC bookstore or through the publisher’s website at Cengage.com. If you already have a Cengage Unlimited account for the year, you should have access to SAM and the textbook. You can access SAM at sam.cengage.com to complete all required module trainings and projects.
For each SAM tutorial module, you will complete one training and three projects. The training for each module can be completed multiple times before the due date; however, the three projects have limits. You can complete and submit the textbook project up to three times and each A & B project only twice before the due date. All training and projects for each tutorial must be completed and submitted to Canvas by their due date for credit.
All group discussions and exams for each module are posted on Canvas and must be completed by their due date. Please check Canvas modules for specific due dates.
MIDTERM/FINAL PROJECTS:
You will have one midterm capstone project in SAM that covers Modules 1-4. At the end of the quarter, you will have an optional final workbook as a final project if you are unable to take the Microsoft Excel 2019 certification exam. As an alternative option to the certification test, you will create a final workbook project. Details for the exam and optional final project is in the Finals module on Canvas.
MICROSOFT OFFICE SPECIALIST EXCEL 2019 EXAM:
You will take the Microsoft Office Specialist (MOS) exam for Excel 2019 via Certiport's Exams From Home (EFH) option. You must create an account with Certiport in order to take the exam. When you sign up for a Certiport account, you should use your personal email rather your school email as your certification transcript is hosted on this site. More details and instructions about the certification exam process can be found on Canvas.
Signup for GMetrix to prepare yourself to pass the Excel 2019 certification exam. With a GMetrix account, you can access up to 100 practice exams which mimics the real testing environment. To use this resource, please download the GMetrix app at gmetrix.net/download. After downloading the application and creating an account with GMetrix login into the site and redeem the access code found in the Canvas course logistics page or contact your instructor for current code. This will give you access to the test prep materials to help prepare you to take the MOS certification exam.
Current Quarter Academic Calendar can be found on the WVC website.
- Create and manage workbooks and worksheets,
- Modify and format cell content,
- Present data in tables and charts,
- Perform calculations on data,
- Insert and format objects in a worksheet.
General Statements
“The Disability Support Services Office has been designated by the college as the primary office to guide, coach and assist students with disabilities. If you receive services (or think you should) through that office and require accommodations for this class, make an appointment with the Director of Student Access (509-682-6854 or sas@wvc.edu) as soon as possible to discuss your approved accommodation needs. Any information you share is kept in strictest confidence unless you give written permission to do otherwise.
If you need a referral to that office or have further questions, please contact the Director of Student Access to assist you. Following through on these services can help you be more successful in your academic endeavors at WVC. (Note: the Director of Student Access will require appropriate documentation of disability. The use of that office is voluntary).”
WVC is committed to providing a safe learning environment. For your safety, the Bias Incident Response Team (BIRT) can connect you with resources/support to address bias-related incidents that may interfere with your academic success, particularly those directed at persons protected under WVC’s Non-Discrimination Policies and Procedures (https://www.wvc.edu/publicdisclosure/aa-eo-statements.html). Please visit the BIRT site at https://www.wvc.edu/bias to learn more and find out how you can report bias-related incidents.
WVC students are entitled to two days of excused absences per academic year for reasons of faith or conscience or for organized activities conducted under the auspices of a religious denomination, church or religious organization. Students’ grades may not be adversely impacted by absences authorized under this policy. Each holiday taken under this policy must be taken as a whole day, i.e. the day may not be divided into hours and taken piecemeal. Related Procedures 1400.610.
Any student who engages in any form of academic dishonesty may be subject to discipline. Common instances of academic dishonesty include (but are not limited to): cheating; fabrication; plagiarism; facilitating, aiding or abetting others in academic dishonesty; collusion; or resubmitting work previously submitted for another course without instructor permission. Academic dishonesty may be subject to both academic sanctions and/or code of conduct sanctions.