D100A__Syllabus

Course Description and Competencies

What to Expect

In this course, you will work through four units of content. These units are broken into smaller lessons. Throughout the course, you will find readings and a variety of interactive elements. These include practice quizzes and knowledge checks to help deepen your understanding of the content. Engaging with these activities reinforces new learning. It also complements the knowledge you bring to this area of study.

Course Competencies

This course covers the following competencies:

Formatting spreadsheets, using appropriate functions to organize and present data effectively
Applying appropriate formulas and functions to aggregate and summarize spreadsheet data
Creating tables to summarize and analyze data to make decisions
Creating data visualizations using charts and graphs for use in a professional setting

Note

This is a supplemental resource that provides foundational knowledge. It has no assessment and provides no competency units.

Course Outline

Module	Upon completion of this module, you will be able to:
Part 1: Spreadsheet Basics Unit 1: Spreadsheet Basics	Describe the purpose of spreadsheets and define their components Build, customize, and navigate a basic functional worksheet Format page setup in a spreadsheet for publication Sort and filter data based on values and variables
Part 2: Formulas and Functions Unit 2: Formulas and Functions	Examine why spreadsheet functions and formulas are necessary Apply spreadsheet functions to perform simple data manipulation with values in cells Define the purpose and uses of the audit function Correct formulas by identifying appropriate data and operators
Part 3: Tables and Data Analysis Unit 3: Creating Tables	Explain the purposes of creating and using tables Create a table Define the purpose and uses of a pivot table Identify the four components of a pivot table Summarize data using a pivot table
Part 4: Charts and Graphs Unit 4: Charts and Graphs	Define the uses of charts and graphs in spreadsheets Identify commonly used types of charts and graphs Display data graphically using different charting features Use formatting tools to modify a chart or graph

Technology Requirements

We want to be sure you have the tools to succeed! Review the Computer System and Technology Requirements to learn about the technology you'll need. If you have questions about your setup, contact support@academy.wgu.edu.

You will need Adobe Acrobat Reader DC. If you haven't already, download this free software. You may encounter an interactive form that contains fields that you can select or fill in. Review how to fill in a PDF form.

Key Contacts

Certificate Connect
Check out this online community to take advantage of course resources, including videos and tips from your educators. You can ask and answer questions, provide feedback on your progress, and interact with fellow students. You will find this platform in the Student Resources section of the course. Log on and do some exploring!

Technical Support
If you encounter technical issues, be sure to contact the Help Desk. Just submit a Support Request for assistance.

Program Support
Do you have questions about your account? Student Support has answers. They can help with billing, switching courses, and other requests. You can contact them at (888) 320-0540 or support@academy.wgu.edu.

Accommodations

WGU provides compliant and accessible learning experiences. If you require accommodation, please contact us at the start of the course. You can email disability@academy.wgu.edu.

We are committed to ensuring that all students with disabilities have equal access to WGU's services and materials. We strive to use best practices for accessibility. Our goal is to conform to existing U.S. laws, including the Americans with Disabilities Act and Section 504 and Section 508 of the Rehabilitation Act.

Our learning management system (LMS) platform is Open edX. Open edX’s commitment to accessible content is published in their Website Accessibility Policy.