Course Syllabus

Jump to Today

This course utilizes the Microsoft Imagine Academy software and curriculum package to provide the most up to date technology and curriculum resources. In this class students will learn to use Microsoft® Office Excel 2016® as an effective tool for organizing, analyzing and presenting data. Students will learn how to enter data; move, copy and edit cells; construct tables and charts; and create and apply basic mathematical functions to spreadsheet data. Upon successful completion of this course, students will be able to create and edit basic Microsoft® Office Excel® 2016 worksheets and workbooks. In addition, students will complete an Honors Project Portfolio.  Students will also attempt the Microsoft Office Specialist Certification Exam for Microsoft Excel 2016®.

 

Throughout this course, we will address the following standards:

1.00

Understand basic and intermediate spreadsheet software skills using Microsoft Excel 2016.

1.01

Overview

1.02

Working with Microsoft Excel 2016

1.03

Using Office Backstage

1.04

Using Basic Formulas

1.05

Using Functions

1.06

Formatting Cells and Ranges

1.07

Formatting Worksheets

1.08

Managing Worksheets

1.09

Working with Data and Macros

1.10

Using Advanced Formulas

1.11

Securing Workbooks

1.12

Creating Charts

1.13

Adding Pictures and Shapes to a Worksheet

2.00

Understand advanced spreadsheet software skills to achieve Microsoft Excel Expert 2016. 

2.01

Managing and Protecting Workbooks

2.02

Applying Custom Formatting and Layouts

2.03

Using Advanced Functions and Analyzing Data

2.04

Working with Advanced Charts and Pivot Tables

 

Course Summary:

Date Details Due