CONTINUING EDUCATION

In the Look-up functions course, students will learn the use of the following functions:

• V-look up and H-look up functions
• Match and Index functions

Upon completion of this 2-hour course, students will be able to look-up and retrieve pieces of data from a dataset, combine data from 2 or more tables and classify/categorize data all through the use of look-up functions.

In the Pivot Table course, students will learn the following:
• creating and modifying PivotTables
• creating and modifying PivotCharts
• filtering data using timelines and slicers

Upon completion of this 2-hour course, student will be more efficient in analyzing and organizing data through PivotTables and PivotCharts.

In the MS Excel Macros course, students will learn the following:

• recording and saving macros for a variety of simple tasks
• performing basic edits of a macro
• debuging simple macro errors
• adding simple form controls to help run macros

Upon completion of this 4-hour course, students will better understand the purpose and function of macros. In addition, students will have a simple understanding of how macros are designed through coding.

In the Excel 3 course, students will learn the following:
•        purpose and functionality of 3D and external references
•        grouping and subtotals
•        sorting and applying filters on data
•        data validation and restriction
•        some logical functions such as AND, OR, nested IF functions and more
•        special formatting such as table styles and sparklines
•        paste special options

Throughout the course, students will learn to be more efficient and use a variety of short-cuts.

Upon completion of this 8-hour course, students will be able to better navigate and create relationships in larger and multiple worksheets and better analyze and organize large amounts of data as well as be able to set data entry restrictions.

In the Excel 2 course, students will learn the following: 
•        functions to format text including Abs, Substitute, Upper, Lower, Trim, Concat, etc...
•        calculations using absolute references and order of operation 
•        basic logical functions such as If, Sumif, Countif, etc… 
•        creation and purpose of named ranges
•        basic statistical and date/time functions such as Small, Large, Rank, Now, Today, Days, etc… 

Throughout the course, students will learn to be more efficient and use a variety of short-cuts. 
Upon completion of this 8-hour course, students will be able to perform a variety of spreadsheet functions to be more efficient in formatting and analyzing data.

Teacher Summer Camp

This is outside the normal summer camp; BUT similar to introduction to Rocketry but for Middle and HS Teachers. Camper would build and fly a rocket and we'd add in resources and tips for using rocketry as a classroom project to promote STEM learning.

Room: TBD

Days: W

Time: 10:00-3:00

Instructor: Kenneth Dotzler

Recommended Age Range: Teachers