This is our catalog of courses. We will occasionally adjust the course listing to reflect the addition of new courses and the retirement of others.
In this course, students will learn the basics of Microsoft Excel. Excel is beneficial to students as it helps them to make accurate calculations, build analytical thinking, visualize data, and more. Proficiency in Excel will help your student be successful in school and beyond.
Total classes: 8
Prerequisite: Students will need to have the Microsoft Excel application installed on their computer. Excel for Windows is covered in the course. Students using Excel for Mac will still benefit from the course, but the user interface may be different at times.
Suggested grade level: 7th to 12th
Suggested credit: 1/2 semester Computer Skills or Excel
Description
Microsoft Excel is a spreadsheet application and one of the core components of the Microsoft Office suite of applications. It is capable of handling simple to advanced calculations, contains various graphing tools, provides pivot tables for data discovery, and utilizes Visual Basic for Applications (VBA) programming. (The topic of VBA programming is studied more deeply in Mr. Ruggiero’s “Microsoft Office Automated Productivity with VBA Programming course” available in Unlimited Access.)
This course focuses on the most utilized functions and capabilities within Excel to perform numerical analysis. Students completing this course will emerge with a firm understanding of the essential elements of Excel which is necessary for anybody that wishes to demonstrate proficiency in computer skills.
Outline
Topics are subject to slight change. These topics will be covered in an interspersed manner throughout the course.
Getting to know the Excel Interface
Understanding cell references – Relative, Absolute, and Named Ranges
Data types and Format options
Entering formulas — simple to complex
Logic conditions (if-this-then-that)
Goal seeking
Pivot Tables
Data Visualization: Charts and Graphs
Avoiding pitfalls and evaluating equations
Materials and Homework
Course Materials:
Microsoft Excel application must be installed on the student’s computer. Excel for Windows is covered in the course. Students using Excel for Mac will still benefit from the course, but the user interface may be different at times.
The instructor will provide all other necessary materials free to students. Recommendations for other resources will be provided with no obligation to purchase.
Homework: Workbook submissions will be associated with lecture topics. A final workbook submission will be a comprehensive review of course material and a final exam will ask supplemental questions.
