Spreadsheets complete Study Guide 2025 working
new update Western Governors University
The D100 Study Guide provides a structured process for completing D100 using our best
practices for course success. The D100 Study Guide presents the following information:
A sequential, detailed list of learning activities to complete for course success. This can
serve as a checklist to make sure all course activities are completed in preparation for
the Pre-Assessment and Objective Assessment.
A list of the learning objectives related to each course content area.
Course Overview
In this course you will learn the fundamentals of spreadsheet development and analysis for
business applications. This course will help students from any discipline learn and apply
foundational elements of spreadsheet software. Students will develop competency in creating
spreadsheet models that include presenting reports, performing data analysis, and depicting
information using charts and graphs. While students will rely primarily on content
understanding, retention, and concept application in this course, they will also use critical
thinking skills. The course content is also grounded in data science concepts such as data
management, data analysis, and data visualization; this gives the student a foundation to
process business data in a current, industry relevant context.
Process Notes:
All scored Assessment activities are listed in bold italics.
You may complete the scored Assessment activities as many times as you want.
Review Supplemental Course Resources (Not applicable to OA)
Click on the COURSE TIPS link on the D100 Course Page to examine the supplemental Resources
to facilitate course success.
Complete the following activities:
Review the contents of the D100 Course Resources Page.
Review the Course Welcome Video and Slideshow
Review the Course Success Tips section for best practices
Review the Study/Pacing Guides for pacing
Review the D100 Course Instructor Contact Information page.
Review the MyEducator FAQ's document for information about the MyEducator
learning platform, the Pre-Assessment and Objective Assessment (OA) processes, and
Coaching Report access.
Use this link to download and review the D100 Support Reference Card. This is a quick
summary of which WGU Support Service to contact for specific types of course
assistance.
, You should be able to do the following after completing this activity:
Access the supplemental learning materials and study aides to facilitate course success.
Understand the activities required for course completion and recommended course
pacing.
Understand how to contact D100 Course Instructors for assistance.
Understand how to complete assignments in the MyEducator learning materials.
Understand how to access Coaching Reports for the Pre-Assessment and Objective
Assessment.
Understand which WGU Support Group to contact for specific types of course
assistance.
Unit 1: Introduction and Device Setup (Not applicable to OA)
Read/Listen to all the module content. Watch all the embedded videos. Complete required
device setup tasks.
Complete the following activities:
Excel Assignments
Installing the Add-In
Course Organization
Topics and Pacing
Course Introduction – Excel
You should be able to do the following after completing this Unit:
Change the MyEducator settings to show course content for your device platform
(Windows or MAC).
Perform the installation and setup of your Microsoft Office software and MyEducator
Excel Add-In.
Understand how the MyEducator course materials are organized.
Have awareness of the course topic areas and suggested pacing to complete the
learning activities.
Unit 2: Spreadsheet Basics (Competency Weight 20%)
Read/Listen to all the module content. Watch all the embedded videos. Complete all Learning
Checks and Unit Test.
Unit Introduction: Spreadsheet Basics
Module 1: The Use of Spreadsheets
Complete the following activities:
Module Introduction
Lesson 1: The Purpose and Use of Spreadsheets