The concepts covered include inputting formulas that use basic arithmetic operations, statistics functions built into Excel, and some of Excel’s conditional functions that include logical comparisons. Students should have completed Algebra 1 prior to taking the course and are encouraged to at least be taking Geometry concurrently. While the recommended audience is Grades 10–12, younger students who have completed Algebra 1 and have a strong aptitude in math can be successful in this course.
Topics covered include:
- importing & formatting data
- using shortcuts to work efficiently in Excel
- performing automated calculations
- validating input
- analyzing univariate and bivariate data
- analyzing subsets of data
- visualizing univariate and bivariate data
- visualizing subsets of data
- working with text
Technical Requirements: The software required for this course is the desktop version of Microsoft Excel, version 2016 or later. The online version through Office 365 is not sufficient for this course. Students are responsible for acquiring an appropriate desktop version of Microsoft Excel which is available for both Windows and Mac. All Catapult courses require a high speed internet connection.