Excel Tech Resources

Welcome to "Excel Activities for the Classroom"! This is a collection of Microsoft Excel spreadsheets and corresponding activities that you can use in your classroom. These activities were created by the staff at North Canton City Schools.

Help: Learn how to use Excel with the help guides on our spreadsheet Tutorials page and get links to other helpful Excel web sites on our links page.

The Activities:

- Counting Money
Several items are shown along with their costs. The student needs to determine how many pennies, nickels, dimes, and quarters it will take to buy an object, as well as different numbers of coins that will work.
- Bar Graph (8 item)
A generic 8 item bar graph that can be dynamically altered with custom data and labels.
- Visualizing Fractions
As the user enters values for the numerator and denominator of a fraction, a circle graph is generated to show a visual representation of the fraction.
- How Many Ways to 12
Students learn about equivalent expressions by finding how many ways they can make 12, using addition, subtraction, multiplication, and division.
- Mystery Functions
There are 20 different mystery formulas in this spreadsheet. For each one the student enters several numbers for the "Input" and examines what comes out for the "Result", trying to determine each function by looking for patterns.
- Misleading Graphs
Two different bar graphs are made from the same survey of favorite foods. The students need to determine which graph is more fair and why, by studying the graphs and altering the data.
- Map Coordinates
Eleven sites of interests are shown on a 20 by 20 grid map of a city. The students are to determine the coordinates of the spots using Excel's rows and columns.
- Multiples Generator
The user enters in up to three numbers and the spreadsheet generates the first 50 multiples. Great for exploring LCM.
- Comparing Graphs
Three different sets of data (earnings, votes, heights) are shown with three different types of graphs (line, bar, circle). The student is to compare the different graphs to determine which is the best representation.
- Comparing Data
The student enters data and then the spreadsheet generates several measures of that data such as mean, median, mode, quartiles, and range, which the user can investigate and compare.
- Exploring Pi
As students report measurements on circumference and diameter of objects, the spreadsheet calculates their ratio and averages them together to approximate pi.
- Pie Chart (8 item)
A generic 8 item pie chart can be dynamically altered with custom data and labels.
- Effects of Parentheses
The user inputs a mathematical expression, and then alters it with parentheses to see how many different answers can be generated. Great for order of operations.
- Exploring Slope
Students learn about slope by experimenting with different values for "m" in the slope-intercept equation, then looking for patterns, relationships, and generalizations.
- Scatterplots
As the user enters ordered pairs, the spreadsheet graphs a scatterplot, creates a line of best fit, and displays its equation (in linear or polynomial form).

Email us (tech@northcanton.sparcc.org) with comments, suggestions, and submissions
Back to North Canton City Schools home page