Microsoft Office Learning Coach Guide

Part A:
Welcome to Microsoft® Office

Welcome Letter

Dear Learning Coach,

Thank you for partnering with CCA and investing in your learner’s education. This Learning Coach Guide is intended to help you support your learner in their Intro to Microsoft® Office course.

Within this guide, you will find the goals, components, and features of the online course. Please take time to read and review this information, so you understand how to help your learner interact with all the course’s elements. 

The Learning Coach Guide also includes information about each of the units in this course. On each page of unit information, you will discover the following.  

• The Unit Overview will tell you what the focus, content, and skills of the unit will be.  
• The Unit Assessment section is a place for you and your learner to preview the graded work in the course. At the start of each unit, work with your learner to look at the unit in edio and find out which types of graded work are in this unit. Write them in the box and use it as a checklist. You can check off each one as your learner completes it. 
• The Unit Materials section tells you the materials your learner will need to complete the activities in this unit. You will also find the materials list repeated within each lesson, so that your learner has exactly what they need at the right time. 
• The Unit Discussion Questions are optional questions that you may want to ask your learner during the unit to increase home and school connections about what your learner is studying.   
• The Unit Notables are highlights from the unit. It helps you to understand what your learner is studying, the tips enable you to reinforce and support at home.

CCA wishes you and your learner a terrific school year! 

Supporting Your Learner

Your role as a Learning Coach is very important. Here are a few ways you can help your learner do their very best in the course.

• Help your learner know what time guided or live class instruction is scheduled for, and prompt them to attend sessions or watch recordings.
• Remember, it is okay for your learner to get stuck. Learning new material takes time. Encourage them to take breaks, keep trying, and even ask the teacher for help.
• Help your learner navigate technology. That may mean helping them type information or upload work into edio.
• Always encourage your learner to do their very best.
• Review the course syllabus for your learner’s course.
• Maintain communication with your learner’s teacher.

Part B:
Course Information

Course Goals

In Microsoft® Office, your learner will use their knowledge of the basics of computer vocabulary and skills. By the end of the semester, your learner will be able to do the following in Word, Excel, and PowerPoint.

In Word®,

• create and manage documents;
• format text, paragraphs, and sections;
• create tables and lists;
• apply references; and
• add a form.

In Excel®,

• create and manage worksheets and workbooks;
• identify cells and ranges;
• create tables;
• apply formulas and functions; and
• create charts and objects.

In PowerPoint®,

• create presentations;
• insert and format shapes and slides;
• create slide content;
• apply transitions and animations; and
• present a PowerPoint presentation.

In Outlook® and Forms®,

• write emails with proper etiquette;
• manage schedules and tasks in Outlook®;
• create lists and tasks in Outlook®;
• create graphs using response data in Microsoft® Forms® and Excel®;
• prepare forms for data analysis;
• identify the purpose of the Net Promoter Score® tool;
• collect responses by using the QR code; and
• create survey forms.

In OneNote® and SharePoint®,

• create and format notebooks;
• manage and organize OneNote®;
• edit and link content in OneNote®;
• share and collaborate with others in OneNote®;
• create custom digital planner; and
• create a communication site in SharePoint®.

Course Format

Lesson Components:

Each lesson, your learner will spend 45-60 minutes completing a Microsoft® Office lesson. Some days may take less time, while other days may take a little more time. The lesson does not need to be completed in one sitting. Encourage your learner to take short breaks as they need.

This section will help you to understand how your learner’s course is structured in edio.

Lesson Bundling:

Lesson bundles are collections of related components that provide a structured and comprehensive learning experience. They help your learner progress logically through the course material and understand the connections between concepts.

Within the lesson bundles, there are different components your learner will interact with. These components will not be used every lesson.

1. Getting Started Lesson: There is one Getting Started lesson in this course. It can be found on Day 1 of Unit 1. This lesson includes important information about the course and contact information for your teacher.

2. Unit Overview: Each unit will include a unit overview. This describes what your learner will learn in the unit and how many assessments the unit will have.

3. Prep for Success: At the beginning of each unit, your learner will find a Prep for Success. This component offers learners tips to be successful in the course, such as study tips, important software information, safety reminders, and more.

4. Knowledge Check: There will be one Knowledge Check in each unit. The Knowledge Check is designed to check prior learning and understanding about key skills and concepts that will be taught in the unit. The Knowledge Check is not a graded assessment.

Each lesson has its own components to help guide your learner through the lesson.

1. Lesson Overview: At the beginning of every lesson, your learner will see the lesson overview. This section contains lesson objectives, lesson vocabulary, materials your learner will need for the lesson, and the suggested lesson length.

2. Engage: The first section of the lesson is Engage. In this section, learners will be introduced to the lesson by making a connection to past and present knowledge, and will get ready for the lesson’s instruction.

3. Discover: New content and instruction is presented in the Discover section. Your learner will interact with the lesson content through defined vocabulary terms, videos, audio, and Pause and Think activities. Your learner will be able to practice and answer questions as they work through the lesson.

4. Show: Learners will demonstrate what they have learned in the lesson through a series of practice questions.

5. Summary: This section recaps the day’s objectives and prepares learners for a future lesson or assessment.

The course includes assignments and projects. These graded assignments allow your learner to show what they have learned and apply their new skills. All CCA assignments and projects include these components.

1. Assessment Overview: At the beginning of each assessment, your learner will see the assessment overview. This section contains the goals of the assessment, materials your learner will need, length of the assessment, and directions for

completion.

2. Plan: In the Plan section, learners will be introduced to the assignment or project. Learners may be provided with a review of content from the previous lessons, strategies for completing the activity, graphic organizers, and grading rubrics.

3. Do: Learners put their plan into action and work to complete the assignment or project successfully. This section also provides the grading expectations and/or rubric the teacher will use to grade the work.

4. Reflect: In Reflect, learners will think back to the work they completed. They will reflect upon the experience and analyze how well they completed the task. These moments of reflection are important and allow learners to think about their learning and their work habits.

In addition to assignments and projects, this course also includes quizzes, tests, and exams.

• Quiz Review: Before a quiz, learners will have the opportunity to review the content they will be assessed on in a quiz.
• Quiz: A quiz may be given at the end of a topic or the end of a unit.

Course Features

This course includes and uses unique features, such as:

• Application Activities: Application activities allow your learner to actively apply their knowledge and skills in practical tasks, fostering deeper understanding and enhancing the real-world applicability.
• Stop and Think: Stop and Think activities give your learner a chance to pause and reflect on what they have learned in the lesson. This helps them understand the material better and remember it for longer.
• Did you Know? Did you Know? highlights provide valuable additional information and interesting facts that enhance the learning experience and encourage your learner to explore beyond the core content.
• Interactive Games: Learners will engage in interactive games that promote engagement and refining skills. These benefits contribute to more effective and enjoyable learning experiences.

Part C: Unit Information

Part C:
Unit Information

Microsoft® Word® Unit

Unit Assessments

Unit Overview

In this unit, your learner will explore how to use the different tools in Word. Some of the Word features include formatting, editing, creating tables and lists, inserting shapes and objects, and adding references.

Your learner will practice applying these tools to real-life situations, such as creating professional and academic documents.

Unit Overview

In this unit, your learner will explore how to use the different tools in Word. Some of the Word features include formatting, editing, creating tables and lists, inserting shapes and objects, and adding references.

Your learner will practice applying these tools to real-life situations, such as creating professional and academic documents.

Have your learner identify which assessment type they see in their unit. Check all that apply.

Quiz ___________________________

Test ___________________________

Assignment __________________

Project _______________________

Exam _________________________

Quiz ___________________________

Test ___________________________

Assignment __________________

Project _______________________

Exam _________________________

Unit Discussion Questions

What Word features challenged you and how did you overcome them?

What are some key formatting features or techniques that you find most useful or important?

What techniques or tools do you use to proof a document in Word?

Unit Discussion Questions

What Word features challenged you and how did you overcome them?

What are some key formatting features or techniques that you find most useful or important?

What techniques or tools do you use to proof a document in Word?

Unit Notables

To support your learner in the real-world application of Word for creating a small business, encourage them to brainstorm and plan their ideas. By assisting them in organizing their thoughts and providing guidance on effectively communicating their business concept through Word, you can enhance their learning experience and foster their entrepreneurial skills.

Unit Notables

To support your learner in the real-world application of Word for creating a small business, encourage them to brainstorm and plan their ideas. By assisting them in organizing their thoughts and providing guidance on effectively communicating their business concept through Word, you can enhance their learning experience and foster their entrepreneurial skills.

Kit Materials

Household Materials

paper, pencil

Household Materials

paper, pencil

Microsoft® Excel® Unit

Unit Assessments

Unit Overview

In this unit, your learner will gauge the fundamental understanding of Excel and the different types of applications that are featured in Excel 365. Learners will go through steps in order to understand the basic formulas and features to create and edit workbooks with multiple sheets for a variety of purposes and situations.

Unit Overview

In this unit, your learner will gauge the fundamental understanding of Excel and the different types of applications that are featured in Excel 365. Learners will go through steps in order to understand the basic formulas and features to create and edit workbooks with multiple sheets for a variety of purposes and situations.

Unit Discussion Questions

What tips do you have for others just starting to use Excel?

How do you realize a mistake in Excel and how do you fix them?

Can you think of a time when images or shapes would be helpful in conveying information?

Unit Discussion Questions

What tips do you have for others just starting to use Excel?

How do you realize a mistake in Excel and how do you fix them?

Can you think of a time when images or shapes would be helpful in conveying information?

Unit Notables

Your learner will have an opportunity to expand on the small business from the last unit to organize business information using Excel.

One useful tip to assist your learner with Excel is to encourage them to practice using formulas and functions to perform calculations and automate processes.

Unit Notables

Your learner will have an opportunity to expand on the small business from the last unit to organize business information using Excel.

One useful tip to assist your learner with Excel is to encourage them to practice using formulas and functions to perform calculations and automate processes.

Quiz ___________________________

Test ___________________________

Assignment __________________

Project _______________________

Exam _________________________

Quiz ___________________________

Test ___________________________

Assignment __________________

Project _______________________

Exam _________________________

Have your learner identify which assessment type they see in their unit. Check all that apply.

Kit Materials

Household Materials

notebook, paper, pencil

Household Materials

notebook, paper, pencil

Microsoft® PowerPoint® Unit

Unit Discussion Questions

What design elements did you find most effective in customizing your presentation templates?

How can these tables, charts, and media help to explain your ideas or make your presentation more interesting?

What was a strength of your project?

Unit Discussion Questions

What design elements did you find most effective in customizing your presentation templates?

How can these tables, charts, and media help to explain your ideas or make your presentation more interesting?

What was a strength of your project?

Unit Notables

Your learner has an opportunity to showcase their understanding of PowerPoint as they engage in a presentation task surrounding their small business.

Encourage your learner to combine their knowledge of PowerPoint, Word, and Excel by integrating them into a dynamic presentation for their small business project.

Unit Notables

Your learner has an opportunity to showcase their understanding of PowerPoint as they engage in a presentation task surrounding their small business.

Encourage your learner to combine their knowledge of PowerPoint, Word, and Excel by integrating them into a dynamic presentation for their small business project.

Quiz ___________________________

Test ___________________________

Assignment __________________

Project _______________________

Exam _________________________

Quiz ___________________________

Test ___________________________

Assignment __________________

Project _______________________

Exam _________________________

Unit Assessments

Have your learner identify which assessment type they see in their unit. Check all that apply.

Unit Overview

In this unit, your learner will explore PowerPoint tools and learn how to create engaging presentations. Through performance-based scenarios, learners will demonstrate their ability to manage presentations, format slides, apply animations, and more. The unit includes a real-world assignment to test learners’ skills and measure their outcomes.

Unit Overview

In this unit, your learner will explore PowerPoint tools and learn how to create engaging presentations. Through performance-based scenarios, learners will demonstrate their ability to manage presentations, format slides, apply animations, and more. The unit includes a real-world assignment to test learners’ skills and measure their outcomes.

Kit Materials

Household Materials

notebook, paper, pencil

Household Materials

notebook, paper, pencil

Microsoft® Outlook® and Microsoft® Forms®

Unit Discussion Questions

How to create and manage the different features of a Database in MS Access?

How can creating and managing calendars in Outlook® help you in real-world scenarios?

What are uses of the Net Promoter Score® tool and QR code in the real-world scenarios?

Unit Discussion Questions

How to create and manage the different features of a Database in MS Access?

How can creating and managing calendars in Outlook® help you in real-world scenarios?

What are uses of the Net Promoter Score® tool and QR code in the real-world scenarios?

Unit Notables

Your learner has an opportunity to utilize the basic features of Outlook with its functions including the email management tools.

Encourage your learner to use Microsoft® Forms® to customize the questions, analyze and adjust question sequencing, and collect responses from the Forms in real-world situations.

Unit Notables

Your learner has an opportunity to utilize the basic features of Outlook with its functions including the email management tools.

Encourage your learner to use Microsoft® Forms® to customize the questions, analyze and adjust question sequencing, and collect responses from the Forms in real-world situations.

Quiz ___________________________

Test ___________________________

Assignment __________________

Project _______________________

Exam _________________________

Quiz ___________________________

Test ___________________________

Assignment __________________

Project _______________________

Exam _________________________

Unit Assessments

Have your learner identify which assessment type they see in their unit. Check all that apply.

Unit Overview

In this unit, your learner will explore Microsoft® Outlook® to create, send, and read email. They will also learn to create and share contacts and to stay on schedule with calendars and tasks using Outlook®.

They will gain an understanding of how to use Microsoft® Forms® to create surveys and use Forms® to create quizzes.

Unit Overview

In this unit, your learner will explore Microsoft® Outlook® to create, send, and read email. They will also learn to create and share contacts and to stay on schedule with calendars and tasks using Outlook®.

They will gain an understanding of how to use Microsoft® Forms® to create surveys and use Forms® to create quizzes.

Kit Materials

Microsoft® 365, Coffee Treat for the Summer Heat Survey, Summer Fun at Hilliard High School survey

Kit Materials

Microsoft® 365, Coffee Treat for the Summer Heat Survey, Summer Fun at Hilliard High School survey

Household Materials

paper, pencil

Household Materials

paper, pencil

Microsoft® OneNote® and Microsoft® SharePoint®

Unit Discussion Questions

What features did you find most effective in OneNote®?

How does Microsoft® SharePoint® help in managing pages, web parts of a page, content types, users, and groups?

How will you share OneNote® content with other users through different sharing mediums?

Unit Discussion Questions

What features did you find most effective in OneNote®?

How does Microsoft® SharePoint® help in managing pages, web parts of a page, content types, users, and groups?

How will you share OneNote® content with other users through different sharing mediums?

Unit Notables

Your learner has an opportunity to create a digital planner using OneNote®.

Encourage your learner to apply customized settings within Microsoft® SharePoint® and apply links and linked notes, insert files, edit text, insert and modify dictation, and insert multimedia in OneNote® in real-world scenarios.

Unit Notables

Your learner has an opportunity to create a digital planner using OneNote®.

Encourage your learner to apply customized settings within Microsoft® SharePoint® and apply links and linked notes, insert files, edit text, insert and modify dictation, and insert multimedia in OneNote® in real-world scenarios.

Quiz ___________________________

Test ___________________________

Assignment __________________

Project _______________________

Exam _________________________

Quiz ___________________________

Test ___________________________

Assignment __________________

Project _______________________

Exam _________________________

Unit Assessments

Have your learner identify which assessment type they see in their unit. Check all that apply.

Unit Overview

In this unit, your learner will explore Microsoft® SharePoint® and Microsoft® OneNote®. They will explore essential features of SharePoint such as login, navigation, use of team and communication sites, editing and coauthoring documents, working with lists, integration with Microsoft® 365. They will also learn to organize notes, files, articles, pictures, and more information in a single digital notebook.

Unit Overview

In this unit, your learner will explore Microsoft® SharePoint® and Microsoft® OneNote®. They will explore essential features of SharePoint such as login, navigation, use of team and communication sites, editing and coauthoring documents, working with lists, integration with Microsoft® 365. They will also learn to organize notes, files, articles, pictures, and more information in a single digital notebook.

Kit Materials

Household Materials

paper, pencil

Household Materials

paper, pencil