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.
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
- 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
- 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
- Pie Chart (8 item)
A generic 8 item pie chart can be dynamically altered with custom data and
- 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,
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 (firstname.lastname@example.org)
with comments, suggestions, and submissions
Back to North Canton
City Schools home page