Microsoft Excel 2019 Lessons 4-6 - MOS Focus

You don't have to convince your administration to buy another expensive program. You don't have to write any new assignments or figure out how to grade it. Whether you just want to teach basics or you are preparing students for the MOS certification, these lessons will get your students there--whether they are in your classroom or at home, provided they have access to Office or 365. Lessons are all inclusive, self-directed and include step by step videos--perfect for teaching live, blended, or strictly online. For a fraction of the price.

Welcome to the second installment of my new Excel 2019 Video Tutorial Lessons! This bundle contains lessons 4-6 in my 8 part series, with a focus more advanced features that may be seen on the MOS Certification test. I took and passed the 2019 MOS test three times before writing these lessons to ensure that they cover everything you need to know to pass! These lessons go over some important advanced features, and also some more unusual, lesser-known features that are often seen on the exam.

These lessons are designed to be used in a blended learning format, where students learn at the own pace. The teacher acts as more of a guide to help students who get stuck or need additional one-on-one help, but students are responsible for their own learning and pacing.

These lessons are a great way to teach Microsoft in a home format as well, provided students have access to Excel or Office 365. I used these exact lessons during the second half of the 2019-2020 school year and still had a high passing rate on the MOS test.

Step 1: WATCH - Students begin by opening the lesson video, which has a table of contents and allows them to learn about each feature and skip to where they need to be. Some students may be able to skip entire sections if they already know that features, while others can watch sections multiple times if they are having difficulty or need to go back. The video does not show them their assignment step by step, but shows them how to do each feature. They must then use that knowledge to figure out how to use it themselves in their own assignment.

Step 2: PRACTICE - Students then open the Lesson Excel sheet and go to the practice section, usually comprising 4-5 different mini-lessons labeled by letter. Following the step by step directions, students practice the feature several times until they are confident using it. The results of their efforts will either be calculated automatically or with a screenshot. This provides the student with immediate feedback if they did it right, and allows the teacher to grade with ease.

Step 3: APPLY - After practicing, students can apply their knowledge in a real-world application where they use the skills they have just learned to create something in Excel.

Step 4: ASSESS - At the end of each lesson, students go to the cover page and check the boxes of each feature if they can remember how to use it and feel confident with it. They print the coversheet, which has their scores, and also the application.

This bundle includes Lessons 4-6, which are designed to teach more advanced and unusual features seen on the MOS exam. Lessons 1-3 are available as well, and teaches the more common, every-day uses of the program. Lessons 7-8 will probably come out by winter, but will focus on more advanced features not seen on the exam but that may be of interest to your gifted and talented students. They will include things like pivot tables, Vlookup tables, etc.

I have tried to write these lessons like an accordion--with room to expand and contract as the student needs require. Gifted students can go as quickly as they like and will have advanced lessons to keep them challenge. Slower students can go at their own pace as well, with a teacher more free to spend time with them as needed. The solution videos included are another way of making the lessons simpler for slower students who need more scaffolding.

Lesson 4 - Teaches conditional formatting, formatting tables, advanced formatting and some particular 2019 features like 3-D models and the new draw ribbon. It also covers some lesser known features like split screen, set print area, grouping, document properties, and inspect document.

Lesson 5 - Focuses on advanced functions. First, the If functions including Sumif, Averageif, and countif. Then text functions like Concatenate, proper, upper, mid, etc. Finally it teaches date functions and nested functions--combining more than one function into one.

Lesson 6 - This lesson covers sparklines, pareto charts, and subtotals, and also provides an overall review of the most common features on the MOS test. They will learn some of the file features as well like customizing quick access bar and ribbons, show formulas, etc, and review graphing.

*The application for Lesson 6 is the only part of these plans that have not been classroom tested, as COVID hit before I was able to test them in class. When I test it next semester I may make changes and re-upload.

**11/20 Update - have also updated the version A and version B multiple choice test to more closely align with what is taught, and there are now 48 questions. A teacher tips and tricks page is included which goes over the testing options. MP4 versions of the videos are also included in case there are connection issues, but those versions will not have the table of contents.

*****************************************************************************

Related Products

Microsoft Excel 2019 - Bundle 1 (Lessons 1-3)

Microsoft Excel 2019 - Bundle 2 (Lessons 4-6)

Microsoft Excel 2019 - Bundle 3 (Lessons 7-8)

Microsoft Excel 2019 FULL BUNDLE (1-8)

Microsoft Word 2019 - Bundle 1 (Lessons 1-4)

Microsoft Word 2019 - Bundle 2 (Lessons 5-6)

Microsoft Word 2019 - Bundle 3 (Lessons 7-8)

Microsoft Word 2019 FULL BUNDLE (1-8)

Microsoft PowerPoint 2019 - FULL BUNDLE (1-4)

Microsoft Excel 2016 Bundle 1 (Lessons 1-5 only)

Microsoft Word 2016 Video Tutorial

Microsoft PowerPoint 2016 Video Tutorial

*****************************************************************************

How to get TPT credit to use on future purchases:

Please go to your My Purchases page (you may need to login). Beside each purchase you'll see a Provide Feedback button. Simply click it and you will be taken to a page where you can give a quick rating and leave a short comment for the product. Each time you give feedback, TPT gives you feedback credits that you use to lower the cost of your future purchases. Your feedback is much appreciated, and helps me provide more work that you are looking for. I am always quick to respond to questions as well.

Be the first to know about my new discounts, freebies and product launches:

Look for the green star next to my store logo and click it to become a follower. Voila! You will now receive email updates about this store.