Cover image for Excel for the Math Classroom.
Excel for the Math Classroom.
Title:
Excel for the Math Classroom.
Author:
Hazlett, Bill.
ISBN:
9781932802597
Personal Author:
Physical Description:
1 online resource (259 pages)
Series:
Excel for Professionals series
Contents:
Front Cover -- Table of Contents -- Dedications -- Acknowledgements -- About the Authors -- Preface -- Calculation Basics -- Using the Touch-Typing Method (Addition) -- Using the Mouse Method (Subtraction) -- Using the Arrow Key Method (Addition and Subtraction) -- Entering Multiplication Problems -- Entering Division Problems -- Entering Fraction Problems -- Using Parentheses to Control the Order of Operations -- Calculating Squares, Cubes, Square Roots, Cube Roots -- Adding a Column of Numbers -- Calculating an Average -- Printing Grid Paper -- Opportunity -- Solution and Overview -- Creating the Solution -- Using the Application -- Adding Gridlines -- Formatting with Cell Borders -- Formatting with Gridlines -- Configuring Print Settings -- Saving the Document -- Printing the Grid Paper -- Excel Extras -- Making Larger Grids -- Isometric Grid Sheets -- Cartesian Coordinate Grids -- Opportunity -- Solution and Overview -- Creating the Solution -- Using the Application -- Excel Extras -- Grids with Points or Lines -- Handout Sheet -- Multiplication Tables -- Opportunity -- Solution and Overview -- Creating the Solution -- Using the Fill Handle to Extend a Series -- Copying a Range on its Side -- Entering a Single Formula for Many Cells -- Using the Application -- Excel Details -- Simplifying Dollar Sign Entry in Absolute and Mixed References -- More Cool Fill Handle Tricks -- Math Exercise Sheets -- Opportunity -- Solution and Overview -- Creating the Solution -- Basic Math Facts: Adding Two Terms with an Answer Under 10 -- Using the Application -- Keeping the Worksheet from Changing -- Adapting for Multiplication -- Creating an Answer Key -- Excel Details -- Subtracting with Two-Digits Without Regrouping -- Expressing Problems That Go Across the Page -- Avoiding Duplicate Problems -- Arithmetic Facts Quiz -- Opportunity -- Solution and Overview.

Creating the Solution -- Using the Application -- Excel Extras -- Homework Checker -- Opportunity -- Solution and Overview -- Creating the Solution -- Using the Application -- Excel Details -- Adding Color Based on a Result -- Where Did They Go Wrong? -- Magic Squares -- Opportunity -- Solution and Overview -- Creating the Solution -- Using the Application -- Excel Extras -- Coordinate Grid Matching -- Opportunity -- Solution and Overview -- Creating the Solution -- Using the Application -- Excel Extras -- Math Art -- Opportunity -- Solution and Overview -- Creating the Solution -- String Art -- Tessellations -- Using the Application -- Candy Bar Fractions -- Opportunity -- Solution and Overview -- Creating the Solution -- Using the Application -- Math Facts Game -- Opportunity -- Solution and Overview -- Creating the Solution -- Using the Application -- Secret Code Maker -- Opportunity -- Solution and Overview -- Creating the Solution -- Using the Application -- Excel Extras -- Probability with Coins or Dice -- Opportunity -- Solution and Overview -- Creating the Solution - Tossing a Coin -- Using the Coin Toss Application -- Creating the Solution - Rolling a Die -- Using the Roll the Die Application -- Excel Extras -- Demonstrating and Comparing Fractions with Charts -- Opportunity -- Solution and Overview -- Creating the Solution -- Making a Worksheet Not Look Like Excel -- Customizing a Chart -- Using the Application -- Excel Extras -- Pie Chart with Only One Section Filled in -- Pie Charts Showing Difference between Two Fractions -- Finding Maximum Area and Volume -- Opportunity -- Solution and Overview - Farmer's Fence -- Creating the Solution -- Using the Application -- Excel Extras -- Solution and Overview - Popcorn Box -- Creating the Solution -- Using the Application -- Solving Systems of Equations -- Opportunity -- Solution and Overview.

Creating the Solution -- Using the Application -- Excel Extras -- Index -- Back Cover.
Abstract:
This guide to enabling middle-grade mathematics teachers to use Microsoft Excel in the classroom focuses primarily on concepts taught in grades 410, with some pre-algebra lessons for higher grades. Including files available for downloading to create custom math worksheets, build self-grading interactive spreadsheets, and use Excel to demonstrate charts and Cartesian math, this handbook provides fun examples of probability, solving equations, magic squares, and compound interest.
Local Note:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2017. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Electronic Access:
Click to View
Holds: Copies: