Synopsis

The use of formulas and functions is what makes Microsoft Excel, a powerful tool. This introductory workshop explores some of the formula and functions that are useful for computing and managing student grades. Participants will learn about statistical functions, weighted averages, dropping low test scores, conditional calculations, and lookup tables to assign letter grades. In addition, the use of Analysis ToolPak will be discussed to generate descriptive statistics and histograms for grade distribution.

Learning objectives

By the end of this workshop, participants should be able to:

• Set up and verify data
• Understand the mathematical order of operations used by Excel
• Use the appropriate type of cell reference
• Construct basic formulas
• Use statistical functions
• Perform conditional calculations
• Generate descriptive statistics

Prerequisites

Participants should have a basic working knowledge of Microsoft Excel and the Windows operating system.

Registration is closed.