Categories
Math at Work Monday Math for Grownups Math for Teachers

Math at Work Monday: Sarah the Recycling Truck Driver

You probably see your recycling truck driver every week and yet never think about the ins and outs of their job.  Sarah Penrod is one of those faithful people who picks up your recyclable goods on a regular basis so that you can help make the world a little greener.  I found it interesting to hear about her job.

Can you explain what you do for a living?

I work for South Utah Valley Solid Waste District. I drive a roll-off truck, and I haul recyclable cans and deliver compost. I also work the scale which weighs trucks as they come in and out.

When do you use basic math in your job?

We use math a lot in conversions. We convert pounds into ton and then calculate the price per ton. I also use geometry when I am loading or taking the container off my truck. I have to make sure that I have the right angle so the can is able to slide off correctly rather than on its side.

Do you use any technology (like calculators or computers) to help with this math?

We use a computer to convert most of the weights and dollar amounts for us, but I use geometric principles in my head.

How do you think math helps you do your job better?

I have to understand and know my angles and conversions in order to do my job effectively.

How comfortable with math do you feel?

I feel comfortable with basic math, but anything beyond algebra would require some refresher courses.

What kind of math did you take in high school?

I took Algebra and Geometry.

Did you have to learn new skills in order to do the math you use in your job?

No, the math was something that I already knew.

There may be more you’d like to know about Sarah and the job of driving a recycling truck.  This is something you may not have given much thought before. Now that you’re thinking…if you think of anything else you’d like to ask Sarah, just let me know and I’ll catch her in between routes.

Categories
Math at Work Monday Math for Grownups Math for Teachers

Math at Work Monday: Michelle Matlock the Physician Assistant

Math is important in many careers, but one of the most critical is in the field of medicine.  For example, it’s very important for medicine to be dosed in correct amounts.  I’m thankful that Michelle knows her math since she is assisting physicians on a daily basis.  Even though I hope I don’t have to visit her… it’s good to know she’s there.

Can you explain what you do for a living?

I am a physician assistant. It is an advanced degree where I am able to interview, examine, order tests, perform minor procedures, assist in surgery, develop treatment plans and write prescriptions. Basically, I function much like a doctor.

When do you use basic math in your job?

All the time. I have to quickly convert pounds to kilograms because a lot of medicines are dosed in kilograms. This is especially important in trauma situations. Many medicines are weight-based like 50mg/kg divided in 3 doses per 24 hours. It gets complicated. I’m thankful that I don’t work in pediatrics because there are further calculations involving liquid and then interpreting the directions into teaspoons/mL/cc so that it makes sense to the parent based on the measuring device that is accessible to them.

Do you use any technology to help with this math?

Yes, I use calculators. I also use paper and pencil the old-fashioned way to visualize the conversions. Electronic medical record has settings that help and alert you if what you are ordering doesn’t make sense.

How do you think math helps you do your job better?

I don’t know about better, but it’s necessary.

How comfortable with math do you feel?

I rarely feel comfortable, but I feel safe that there are resources available to check my work so that I don’t make mistakes.

What kind of math did you take in high school?

I took Algebra, Geometry, and Algebra II.

Did you have to learn new skills in order to do the math you use in your job?  

No, not really. Occasionally I have to brush up on statistics in order to interpret research or scholarly articles and data. There isn’t much of a role for advanced math, such as trigonometry, in my daily job.

Questions for Michelle?  Let me know, and I’ll ask her!

Categories
Math at Work Monday Math for Grownups Math for Teachers

Math at Work Monday: Rick Scherer the Certified Medical Dosimetrist

In today’s world, we’ve all unfortunately been touched by cancer in one way or another.  We may have stood beside a loved one as they battled the disease, or we may have experienced it first-hand.  Rick at First Dayton Cyberknife encounters cancer patients on a daily basis as he assists in their treatment.  I’m thankful for folks like him who use their math skills effectively to help others.

Can you explain what you do for a living?

I am a certified medical dosimetrist at First Dayton Cyberknife. I work in radiation therapy which is used to treat people who have cancer. I make sure the radiation kills the cancer cells without harming the patient.

The medical dosimetrist is responsible for designing a treatment plan and carrying out calculations with mathematical accuracy for the delivery of radiation treatment based on the oncologist’s prescribed course of therapy. This treatment plan takes into consideration tumor pathology, tumor volume, and inherent dose-limiting structures surrounding the tumor. The treatment plan and radiation field-placement techniques are constructed utilizing sophisticated computer equipment and technology. The medical dosimetrist, along with the radiation oncologist and medical physicist, will work to construct a treatment plan that will meet the prescription written by the oncologist, ensuring that the patient will not lose important healthy organ function and that the radiation delivered will not affect healthy surrounding tissue. These treatment plans not only include the use of radiation but also, in many cases, involve the use of radioactive elements during interstitial brachytherapy procedures. Once the treatment plan is complete, the medical dosimetrist will work closely with the radiation therapists in the implementation of the prescribed plan.

When do you use basic math in your job?

My whole job is math related. I wouldn’t be able to do my job without math skills. Most of my job pertains to the physical properties of radiation and its interactions with matter. There are calculations depending on energy, energy type (photon, electron, gamma ray), size of the treatment field etc. Most of these calculations are done using a treatment planning system (TPS). We use Eclipse, which is from a company called Varian. We also use a Cyberknife, which uses a software called MultiPlan.

Do you use any technology to help with this math?

Most of the time I use specialized software for treatment planning but not always. Some plans have to be hand calculated.  

Sometimes I use a hand calculation to basically determine how long the machine needs to stay on to deliver a certain dose to a certain depth. For example, the radiation oncologist will prescribe 2400 cGy (centigray is a unit of absorbed dose) in 10 treatments (240 cGy per treatment) to a depth of 80% or sometimes he will say 2 centimeterss. I will use a simple formula that we call a hand calc, 240 

80% • 1.002 =299cGy
(where 1.002 is the output factor of field and energy)

1 cGy=1 monitor unit on the machine so the machine would be set to 299 mu’s per treatment for ten treatments for 100% coverage of radiation at the 80% isodose line. This is confusing as heck so I won’t get any deeper with this because I will just go on and on and on….

This is a very simple calculation. Most of the time we aren’t this lucky. Actually most of the time everything is calculated with the Treatment Planning System.

How do you think math helps you do your job better?

Math is physics and physics is math, so you can’t have one without the other.

How comfortable with math do you feel?

I feel very comfortable with some math, but with other math I still feel very uncomfortable.

What kind of math did you take in high school?

The highest I took was Algebra II. I barely passed!

Did you have to learn new skills in order to do the math you use in your job?

I have had to learn new calculations for new procedures depending on the type of treatment. Some treatments use a real source of radiation which has different factors. In college, medical physics and radiation physics were totally new to me. I can’t really compare it to normal math class. Lots of formulas, laws and other “math stuff.”

One law that is common is radiation is called the inverse square law: In physics, an inverse-square law is any physical law stating that a specified physical quantity or intensity is inversely proportional to the square of the distance from the source of that physical quantity. That is one of the first things you learn.

Want to know more about using math in the fight against cancer?  Let me know, and I’ll be sure to ask Rick your questions.

Categories
Math at Work Monday Math for Grownups Math for Teachers

Math at Work Monday: Tim Lane the Real Estate Appraiser

Real estate appraisers: whether you love them or hate them, they’re a necessity.  Sometimes we may disagree with their figures, but as Tim Lane shows us, the facts are the facts.  And how does Tim get to those facts? Math of course.  This math has a purpose, backed by meaning, and it’s hands-on.  Tim shows us some of the inside scoop in the field of real estate appraisal.

Can you explain what you do for a living?

The job of a real estate appraiser is to determine what the property is that is being appraised: is the property a single family home, a duplex, an apartment building or something else? As well, what is the home in terms of age, size, construction quality, bedroom/bath count, and other features? Once this has been determined, the appraiser’s job then shifts to the task of analyzing the market area. This includes an analysis of the area on a large scale (city wide) relating to economics and the economic base, then a second analysis of the specific neighborhood within the city to determine what is happening in that neighborhood with real estate price trends, supply and demand, and what features or amenities are most important at this time. Finally, all the data comes together into a 30-40 page report in which all the data is given to the client. Contrary to what most people think, appraisers do not set the value of a property, we simply report what is going on in the area, and what a property is likely to sell for based on other recent sales in the area that are as similar as possible to property being appraised.

When do you use basic math in your job?

From start to finish. Initially, we have to use math to determine simple things such as how much time it takes to get from one property to another, what is the distance between them, and how many hours of daylight we have to work with to get everywhere we want or need to be in a day’s time. Math continues when looking at economic statistics to determine market trends ranging from basic issues such as determining if the area has an oversupply of available real state as compared to what the market has demonstrated can be sold in a given time frame, determining how much of a decline a market may see based on different rates of oversupply, using statistics such as regression analysis to determine a market’s reaction in terms of real dollars to different features or lack of a feature in a home. Math is used to determine the living space of a home, the size of the lot, to determine fractional increments of return on the dollar for investments made in a property.  If the property is income producing, we use math to determine an investment rate of return for dollars investments, sinking fund factors, future value of a dollar, and to help determine what type of funds need to be set aside each month for repairs of items such as roofs, HVAC systems, water heaters and other components of a home. Finally, appraisers use math to determine the cost to build a home.

Do you use any technology to help with this math?

We do use calculators and computers heavily. Calculators such as an HP-12C has been the industry standard for the real estate and finance industry for 25+ years. Software providers in the industry do all they can to calculate as many equations as possible so that we can cut down the time it takes to produce a report. Software such as Excel make complex equations much easier. However, if anyone wants to be an appraiser they are still required to be able to do all the math–much of which is very complex–with a simple pencil and paper, in order to be certified by a state and the federal government.

How do you think math helps you do your job better?

Math certainly helps appraisers do our jobs better. Most appraisers are very adept at being able to simply see a property, and know what it is likely to sell for. However our clients such as banks, accountants, lawyers, and tax courts simply will not accept a quick email with a value. Everything the appraiser says has to be backed up with provable facts; this is always rooted in math. Whether it is the size of a room, the size of a home, the size of a lot, the value of an additional bath, or the value of an additional quarter acre of land, it all has to be proven to our clients beyond any shadow of a doubt. Math is the only way to accomplish this level of proof.

How comfortable with math do you feel?

Initially, as I began to get into appraising, I wasn’t comfortable at all. Algebra and geometry play heavily into real estate appraisal, and I was never a standout in math class. Just sitting around doing math problems over and over, with no real purpose to the questions was extremely monotonous. However, once I began to actually see a purpose and a reason to do math, and had a real reason to apply the knowledge to something concrete, it became much easier. Never in my wildest dreams would I have ever believed I would use any math beyond basic addition, subtraction, multiplication and division, but I do every day now.

What kind of math did you take in high school?

I avoided math like the plague. I was forced to take Introduction to Algebra, which was the worst year of my life at the time. I later took Algebra I, which turned out to be even worse! Then geometry, which I loved! But still, math was math and that was all I was required to take, so that is all I took.

Did you have to learn new skills in order to do the math you use in your job?

Yes, I did have to learn some new skills to do my job; and in some cases I had to simply relearn what I had assumed I would have no reason to remember. Real estate appraisal obviously has roots in real estate, and just as much in finance, investments and banking as well. No basic public schooling teaches this type of math. Some math skills transfer well such as word problems, or some geometry, but much of what is needed is more complex financial based math that relates to business math, statistics, projections, finance, and investments.

Questions for Tim?  Let me know, and I’ll see if he can squeeze in an answer between calculations.

Categories
Math at Work Monday Math for Grownups Math for Teachers

Math at Work Monday: Kathy, manufacturing company president

Can you imagine being the president of a twenty person manufacturing company–without  math?  Meet Kathy Keel, president of BSF, Inc. and let me tell you, she has to know her math.  In her position, she must keep an eye on profitability, for her own benefit and the benefit of her employees.  But for Kathy, the math goes even deeper. Let’s take a look.

Can you explain what you do for a living?

I am the president and co-owner of a manufacturing company that makes a custom part for the hydraulic industry, called a pump-motor adaptor. My main duties on a daily basis involve managing all of the office employees, designing custom fit pump motor adaptors, editing all drawings done by other designers, costing the part, and processing orders. I also do a lot of customer service as well as troubleshooting problems, processing payroll, and managing human resource duties.

When do you use basic math in your job?

I use basic math while designing the parts to figure dimensions and angles needed for design features. We have to research the dimensions of each component being attached to the adaptor (pump, motor, and coupling usually). Then, we have to design the adaptor to fit those components. This requires fractions and decimals to figure adaptor dimensions and tolerances. I also use math during costing/pricing activities in order to determine what our cost is for manufacturing the part and what our selling price should be on the final part. This involves working with money, percentages, and markups. In addition, I use math when processing payroll.

Do you use any technology (like calculators or computers) to help with this math?

I use a calculator, Microsoft Excel, and design programs such as Solidworks.

How do you think math helps you do your job better?

I could not properly design an adaptor to fit the components without math, and I could not cost and price parts without math. Overall, I couldn’t run a company without math. I use it in almost every facet of my business to make sure that we are profitable.

How comfortable with math do you feel?

I am somewhat comfortable with basic math only. I’m not comfortable at all with more complex math.

What kind of math did you take in high school?

One year of Algebra as a freshman.

Did you have to learn new skills in order to do the math you use in your job?

I had to learn to translate metric to English measurements and to equate fractions to decimals.

Have questions about Kathy’s company, their products, or her use of math skills at work?  Let me know and I’ll be happy to check in with her.

Categories
Holidays Math for Grownups Math for Parents Math for Teachers Math for Writers

Happy Valentines Day!

valentines day

I couldn’t resist sharing this happy little math gif. Mathematically speaking, it makes no sense, but it’s still sweet.

Happy Valentines Day!

Categories
Math for Grownups Math for Teachers Math for Writers

Spreadsheets 101: Troubleshooting

This is the third post in a series about spreadsheets, called Spreadsheets 101. Click if you missed the first (Spreadsheets are Powerful. Here’s How) or second (How to Use Formulas) post.

Mistakes happen. But boy they can be frustrating, especially if you’re learning something new or not feeling so confident with your skills. In terms of spreadsheets, these mistakes can show up in one of two ways: a value that doesn’t make sense or an error message. In this post, you’ll get the ins and outs of diagnosing and fixing these problems.

Errors in spreadsheets are almost always user-generated. In other words, you can’t blame the developer or your computer or Mercury rising. This is both good and bad news — and the process for identifying and fixing these issues is very similar to working your way out of a vexing math problem. Don’t let that worry you. Instead, think of it this way: you have a great opportunity to deal with two difficulties at once.

Bad Numbers

When numbers matter, it’s always a good idea to check everything carefully. This might feel like a real drag, but this little habit can save you time, money and heartache in the long run. Take a look at the spreadsheet below. Can you spot the questionable values?

Did you notice the numbers that are out of whack? They’re in E12 and F12: $36,926 and $34,076. It would be awesome to earn that much dough from the sale of 1,000 ebooks, but with a net of $3.69 per book, that doesn’t make any sense at all.

There’s a problem with one of the formulas — probably in E12 or F12. So, let’s take a closer look. If this were your spreadsheet, you could double-click on E12, showing the formula.

Now, this time, I’ve also included the tool bar over the table itself. Notice that the formula is listed to the right of fx. You can also see it in the cell itself. This formula says that you want to multiply the value in D12 by 10,000. (Count the zeros, if you can’t quite read it.) In other words, this is the net, if you were to sell 10,000 ebooks. But what you’re looking for is the net on 1,000 sales. Ta-da! That’s the problem.

Next, you want to fix the error and see if that solves the problem in F12.

Yep, it did. See what happens there? If you make a mistake in one cell, it can carry to other cells. It pays to be diligent.

In this case, I had simply typed too many zeros. Another easy mistake is referencing the wrong cell (typing C12 instead of D12, which would be a tougher mistake to find). It’s also fairly common to accidentally add a cell name to a formula, by clicking the cell before closing up the formula.

Finally, errors in using the order of operations are really easy to make. If you need to add before multiplying, be sure to put the addition step in parentheses. Otherwise, the computer will follow PEMDAS — multiplying before adding. Take a look:

=((D12+E12)*5) means: Add the values in D12 and E12 and then multiply by 5
=(D12+E12*5) means multiply the value in E12 by 5 and then add the value found in D12

Big difference!

The Formula You Typed Contains an Error

Sometimes your spreadsheet program might give you an error message, like the one below.

Of course the error message isn’t helpful at all. But look closely at the formula in the cell. Instead of typing “1000”, I’ve typed “1,000”. And that’s a big no-no. Take away that comma separating the 1 from the 0, and all will be right with the world. Other characters you want to avoid include dollar signs ($) and percentage signs (%). Stick to the symbols outlined in the previous post on building formulas.

The key here is not to ever make mistakes but to identify them, if you do. Review all of your formulas before trusting their outcomes. Check that you’ve included the correct cell names, operations and used parentheses where necessary (so that your order of operations is correct. If you get an error message, look for symbols or letters that shouldn’t be in the formulas.

With a little attention to detail, you can be sure that the data generated by formulas is good to go!

What steps do you take to troubleshoot your spreadsheets? Do you have some advice to share or questions you need answers for? Talk to me in the comments section! There’s one more post coming up soon. Later this week, I’ll teach you how to make pretty graphs using spreadsheets. So easy, you won’t believe it!

Categories
Math for Grownups Math for Teachers Math for Writers

Spreadsheets 101: How to Use Formulas

This is the second post in a series about spreadsheets, called Spreadsheets 101. Click if you missed the first post, Spreadsheets are Powerful. Here’s How.

Spreadsheets are powerful for an important reason: formulas. But if that feels like a scary word, let me reassure you. We’re not talking about the formula for finding compound interest (unless that’s what you need for your spreadsheet). In spreadsheet-speak, formulas are simple math sentences, using operations like addition and multiplication. They also employ the names of cells.

Cell, What’s Your Name?

First, remember that a cell in a spreadsheet is one of those little boxes in a spreadsheet. The best way to consider a cell is to think about it in terms of a column and row. The columns are identified by letters and the rows are numbered. So a cell’s name is identified by its letter (column) and number (row).

Take a look at the spreadsheet below. There are two cells with $300. What are their names?

Did you guess B6 and B7? (It’s a little tough to see the numbers, but you can count from the top to the bottom.) If so, you’re right on target. Feel free to identify some additional cells, if you need a little more practice. Remember, these cell names are going to play a role in the formulas. So it’s important to be able to identify them correctly.

Symbolism

For the most part, you’ll probably use really simple formulas — finding the total of a set of numbers, finding the difference between two numbers, multiplying a value by another value. When you get into more complicated formulas, you may need to pay attention to the Order of Operations (PEMDAS). This is where parentheses can really come in handy. (We’ll focus on simple formulas in this post, leaving the more complex ones for another time.)

But first, you’ve got to know a little bit of shorthand. Because your computer does not have the same keyboard as a calculator, you’ll use ordinary keyboard symbols for a few of the math symbols. Take a look.

+  Addition
–   Subtraction
*   Multiplication
/   Division
^   Exponents
=  A formula is coming!

Notice that the symbol for multiplication is not an “x.” This is because “x” means the letter x. (It can’t mean two things at once.)

The equals sign (=) tells the spreadsheet that a formula is coming. Otherwise, it would simply output the formula — and not the resulting value, after the formula is applied — in the cell. For that reason, each formula follows this pattern:

=(formula)

The word formula is the formula itself.

Now technically, you don’t need the parentheses around the formula, but I find it useful to use them. That’s because they’re necessary with all special formulas. Either way, you must have the equals sign.

Writing the Formula

Before writing the formula, think about what it is that you want to accomplish. In the spreadsheet above, the estimated costs and revenues from self-publishing a book are tabulated. In cell D16, the net for each printed authors copy is $9.35. That value was found using a formula.

You can see this formula in the spreadsheet above: =(C16-B16). In other words, the net for each author’s copy is the price per book minus the estimated cost of producing the book. The price per book is in cell C16 and the estimated cost of one author copy is in cell B16. So the formula is =(C16-B16). Notice there are no spaces between any characters in the formula.

What about the net per ebook (cell D12)? The price of an ebook is quite a bit lower than a printed book, and there is no estimated cost. The net per ebook is found by multiplying the cost of the book by the royalty rate, which is usually a percentage. (Remember, you’ll need to convert the percentage to a decimal before you can multiply. Do that by moving the decimal place two places to the left.)

As you can see above, the formula used to find the net per ebook is =(0.74*C12), which means 74% of the value in C12. Notice that if you want to change the book price — to see how your numbers shake out with a lower or higher price — the net per book will automatically change. That’s because the formula pulls in whatever value you have in C12.

Special Formulas

There’s one more thing to consider: special formulas. If you find that you’re totaling long lists of values, you can use the SUM formula and select the values you want to total. Take a look at the example below.

Cell B10 is the total of all publishing costs. In other words, you want to add all of the costs together. The formula =SUM(B4:B8) simply means this: Add all of the values in the cells from B4 through B8. In this case the colon means all of the values in the cells B4 through B8.

There is another way you can write this formula: =(B4+B5+B6+B7+B8). And if you want to do that, go for it. You’ll get the exact same answer. Of course the SUM formula is a simplified version of that same process.

And there are lots and lots of other special formulas. You can find these by nosing around in your spreadsheet program. These programs typically include a master list of special formulas. A Google search can unearth others.

So there you have it, a quick overview of using formulas in spreadsheets. This can be a lot more complex, depending on what you are doing. The key to remember is that a formula must appear between parentheses and after an equal sign. So play around with it. Don’t be afraid, you won’t break the program. If you find that you have some errors, stop by later to read my post on troubleshooting.

What special formulas have you found useful in spreadsheets? Do you have some advice to share or questions you need answers for? Talk to me in the comments section! And don’t forget to read my post about troubleshooting spreadsheets.

Categories
Math for Grownups Math for Teachers Math for Writers

Spreadsheets Are Powerful. Here’s How.

This post is the first in a writer-centric series, called Spreadsheets 101. In later posts, I look at how to use formulas in spreadsheets, troubleshoot problems and create graphs. 

Want to tell a geek from a non-geek? Ask a simple question: How do you feel about spreadsheets? Geeks will wax poetic about the grace and sensibility of spreadsheets, while non-geeks will either shrug or recoil in horror.

At least that’s my experience.

As a proud geek, I embrace my love of spreadsheets. As a teacher and writer, I know that not everyone is as excited about these technological marvels. Still, while I might fire up Excel for the most mundane tasks — grocery lists or wedding invitation RSVPs, for example — I do think the humble spreadsheet can be quite useful in a variety of more robust and complex settings. This is especially true for freelance writers and other entrepreneurs. We solo artists may not have access to the latest bookkeeping software or even a bookkeeper. We can’t turn to the IT team to help us project revenues for the next year or track the time spent on certain types of projects. (Most of us are the IT team.) That’s where spreadsheets can come in handy.

What Is a Spreadsheet?

A spreadsheet is more powerful than a table, with fewer bells and whistles than a database. The data is arranged in columns and rows. The columns are labeled with capital letters, and the rows are numbered. So each cell can be identified by its unique letter (column) and number (row). For example, A25 or FF102.

All of the data in each row is related somehow. The same goes for the data in each column. That’s how a spreadsheet is like a table. Here’s a picture:

In this example from Math for Writers, a writer is costing out the price of self-publishing. Notice how the columns and rows are related. In every spreadsheet, each cell (one of the little boxes) is related to the headings of the row and column that define that cell. So, $9.35 is the NET per book (column) of print, author’s copies (row) in the spreadsheet above.

But this spreadsheet isn’t just a table. Because of the way it was built, if I change the value in cell B16, the value in D16 will also change. It’s also not a database. That’s because the data cannot be output elsewhere. For example, if I wanted to output this data onto my website — in a simple list, for example — I’d need to use a database. (Examples of databases include the contacts on your smartphone and the movie listings on Netflix. The data — names and phone numbers of contacts or names and ratings of movies — is stored in a database and output on your phone, computer or television set.) Unlike with databases, the data in spreadsheets pretty much stays put.

When Should You Use a Spreadsheet?

Notice that some cells contain text and some cells contain numbers. Spreadsheets are most powerful when the data is numerical. That’s because with a few carefully placed formulas, you can manipulate those numbers — quickly and easily.

For example: in the spreadsheet above, the value $9.35 was not typed into that cell. Surprise! Instead, this values is the result of a formula. Take a look:

When I highlight the $9.35 cell, it changes to show the formula: =(C16-B16). At the same time, cells C16 and B16 are highlighted. This formula is a really simple subtraction problem, but it’s pretty potent. That’s because if I change the value in C16 or B16, the value of D16 changes, too.

This means you don’t have to keep up with a ton of changes. If your formulas are set up correctly, you can simply change the data in other cells as needed, and the formulas keep up with the calculations. For this reason, spreadsheets are really useful in projecting. For example, if the price of the book is changed in the above spreadsheet, you can see how the net and gross values will automatically change. In other words, you can play with the pricing and watch how the total income goes up or down as a result.

Want to make fancy-schmancy graphs? That’s another reason to use a spreadsheet. Once your data is safe and snug inside multiple rows and columns, it can be displayed graphically with the click of a couple keys. Really. It’s that easy. (I’ll show you how in a later post.)

And there you have it. The what and whys of spreadsheets. Stick around. In a day or two, I’ll teach you how to create the all-powerful formula. (It’s not all that magical, and it’s not all that hard either.)

Next up: Learn how to use formulas in spreadsheets and troubleshoot problems.

When have you found spreadsheets most useful? What frustrations have you had with spreadsheets? Share your experiences in the comments section. Also be on the lookout for my next book Math for Writers, which will be available in late January. Yes, writers do use math! I’m so excited to show you how!

Categories
Basic Math Review Math for Grownups Math for Parents Math for Teachers

Five Cool Math Tricks You Didn’t Know

When it comes to basic calculations, kids can benefit from knowing math facts cold. When the arithmetic is simple, we can focus on more complex concepts.

That’s one reason your children are encouraged to memorize their multiplication tables. But over the years, educators have discovered that straight memorization is not always the best. In fact, when kids spend a great deal of time really unpacking what these math concepts mean, they’re far more likely to expand their understanding of many other concepts.

So are math “tricks” a good thing or a bad thing?

“Kids should have a way of figuring out the math fact that uses reasoning,” says Dr. Felice Shore, assistant professor and co-assistant chairperson of Towson University’s math department in Maryland. As an expert in mathematics education, Shore knows that when children’s natural curiosity is stimulated, they can make important mathematical connections that will deepen their understanding.

“But once kids can reason their way to the answer and understand various ways to do so, these ‘tricks’ can help them get answers quickly,” she continues.

The key is to introduce these tricks at the right age.

“I don’t think the third or even fourth-graders should learn tricks,” Shore says. “The important mathematics at those grades is still about building an understanding of relationships between numbers—the very reasons behind math facts. Once you show them the trick, it’ll most likely just shut down their thinking.”

But math tricks can be useful. If your fifth grader is still struggling with her multiplication tables, these can be a godsend. Even better is when they reveal something about the math that makes them work.

If you’re going to show your child a quick way to multiply, make sure that you help her understand why the trick works. Here are five cool examples—and the math behind them.

[laurabooks]

Multiplying by 4

This trick is so simple and logical, that it could hardly be called a trick. But it could come in handy for your budding Sir Isaac Newton. To multiply any number by 4, simply multiply it by 2 and then double the answer.

35 x 4
35 x 2 = 70
70 x 2 = 140
35 x 4 = 140

Why does it work?

This trick is based on a very simple fact:

2 x 2 = 4

That means that:

35 x 4 = 35 x (2 x 2)

And

35 x 2 x 2
70 x 2
140

The underlying lesson of this “trick” is that you can solve a multiplication problem by multiplying by its factors.

Multiplying by 9

Hold up both hands, with your fingers spread. To multiply 4 x 9, bend your fourth finger from the left. Count the number of fingers to the left of your bent finger—you should get 3. Then count the number of fingers (and thumbs) to the right of your bent finger—you should get 6. The answer is 36. This works when multiplying any number 1-10 by 9.

Why does it work?

Simple algebra can show that what you’re doing with your fingers boils down to this: When you multiply by 9, you’re really multiplying by 10 and then subtracting that number. But you don’t need to do the algebra. Some kids figure out that reasoning without the mysterious finger trick.

You can help your child extend her understanding of the number 9 by pointing out an important piece of this trick: in the 9s multiplication tables, the digits add up to 9!

4 x 9 = 36   —>   3 + 6 = 9

9 x 9 = 81   —>  8 + 1 = 9

Then you can prompt your child to notice other patterns. For example, 4 -1 = 3 and 3 + 6 = 9 and 4 x 9 = 36. The patterns in the 9s multiplication tables are endless and can lead to many other discoveries about numbers.

Multiplying by 11

Sure, multiplying a one-digit number by 11 is a cinch.

4 x 11 = 44
7 x 11 = 77

But did you know there’s a trick to multiplying any number by 11?  Here’s how using an example: 52 x 11.

The first digit of the answer will be 5 and the last digit of the answer will be 2. To get the digit between, just add 5 and 2.

5 (5+2) 2
572

You may have noticed that when you add the two digits together, you get a one-digit number. If you get a two-digit number, things are a little trickier.

87 x 11
8 (8+7) 7
8 (15) 7
(8+1) 57
957

Why does it work?

If you think of doing long-hand multiplication by stacking the two numbers, you’ll see right away:

But the more precise reasoning has to do with place value. What you’re really doing is multiplying 87 by 1, then multiply 87 by 10, and finally adding the two products together:

87 x 1 = 87
87 x 10 = 870
870 + 87 = 957

The trick itself is just a shortcut to the answer.

Multiplying by 12

Just like the previous track, you can multiply any number by 12 very quickly and easily. Let’s try it with 7 x 12.

First multiply 7 by 10. Then multiply 7 by 2. Finally, add them together.

7 x 12
7 x 10 = 70
7 x 2 = 14
70 + 14 = 84

Easy peasy. When this gets really impressive is with larger numbers.

25 x 12
25 x 10 = 250
25 x 2 = 50
250 x 50 = 300

Why does it work?

This trick works for the same reason that the 11s trick works. But there’s another way to describe it. Think of 12 as the sum of 10 and 2.

25 x 12
25 x (10 + 2)
(25 x 10) + (25 x 2)
250 + 50
300

Is a number divisible by 3? (Or in math terms: Is a number a multiple of 3?)

When a number is evenly divisible by another number it is said to be a multiple of that number. In other words: since 27 is evenly divisible by 3, 27 is a multiple of 3.

Turns out, there’s a nice little trick for this as well. Add up the values of the digits. Is that sum a multiple of 3? If so, the number itself is also evenly divisible by 3. Check it out:

Is 543 divisible by 3?
5 + 4 + 3 = 12
12 is divisible by 3
So 543 is divisible by 3

Why does this work?

Place value is key here, but there’s an easy way to show your child what’s happening before you even introduce the trick. Do this with something tangible, like M&Ms or pieces of cereal.

  1. Start with 45 candies.
  2. Have your child divide the candies into two piles based on the place value—one pile of 40 candies and one pile of 5 candies.
  3. Now ask your child to divide the 40 candies into groups of 10 candies. (She should notice that there are four groups of 10 candies.)
  4. Now ask her this question, “How can you change each of these groups often, so that the number is divisible by 3?” She should suggest that you take away one candy from each pile. (If not, coax her to that answer.)
  5. Have her take one candy from each group of ten and move them into another group.
  6. Point out that she has six piles of candies: four piles of 9 candies, one pile of 4 candies and one pile of 5 candies.
  7. Ask her what happens if she combines the pile of 4 candies and the pile of 5 candies. She should notice that she’ll get 9, which is divisible by 3.
  8. By now, she will probably notice that the 4 and 5 come from number 45. See if she can come up with the trick, after doing this with a few examples using the candies.

So what do you think? Are math tricks a good idea or not? Do you have any other tricks to share? And can you explain why they work? If you need help with your math, I have written these great books to help you learn the easy way.

Categories
Math Education Math for Parents Math for Teachers

Lowering Homework Stress: 5 Easy Steps for Parents

Last week, I shared some unpopular opinions about homework. Mostly, here and on Facebook, people disagreed with me that three hours of meaningful homework was not too much. And looking back at that statement — which wasn’t exactly what I said — I see their point. Do I want my kid to be focused on academics for a full 10 hours a day? (Assuming that for those seven hours of school, she’s being taught.) When it’s put in those black-and-white terms, no, I don’t think that’s reasonable. Nor do I think the debate is all that black and white.

Regardless, parents all over the interwebs are pissed off about the amount of homework our kids are assigned. Their complaints range from the truly anguished (“I tried for two hours to help my son with his math homework, but with his learning differences, I just can’t get him to understand!”) to the kind of petty (“Having to sign a reading log is busy work — for me!”). It got me wondering, what do we do to lower this stress, for parents and students?

So I came up with some ideas. Try them out at home, and let me know how it works for you. And if you have your own ideas, please share them!

1. Reset the Priorities

What is the point of homework? Is it meant to help kids practice what they’ve learned? Extend lessons from class? Finish up something that didn’t get done in school? Complete a long-term project from start to finish? Torture you and your kid?

If you know what you want your kid to get out of homework, you can better set the parameters. See, this is your kid, not the school’s. What you want your kid to get out of his or her education matters. A lot. Once you know your homework philosophy, find out what the school and teachers think. (They might feel differently from one another.)

Then you’ve got to decide what hill to die on. If getting the right answer is a big deal for your kid’s math teacher but a conceptual understanding is what you value, someone’s going to have to compromise. For example, I’ve told my kid that I don’t believe timed math drills are useful tools. (And that’s backed up by research, y’all.) We agreed that if her grade was negatively affected by them, I would go in and talk to the teacher. Stress was instantly lowered. If signing a reading log is arduous for you, give your child that responsibility. Or decide that you’re not going to figure everything down to the minute and shoot for an estimate instead.

When the stress gets high, go back to those priorities. Talk to teachers about assignments that don’t meet your homework priorities. And if necessary, allow your kid to blow off things that are not meaningful. (Yes, I just said that.)

2. Set a Flexible Homework Routine

Whatever this schedule is, it needs to work with your family. Kids who go to aftercare may finish up their assignments before they get home. (At my daughter’s school, that’s a requirement for most assignments and students.) Other kids may come straight home, have a snack and shoot some hoops before hitting the books. Still others may not start homework until after dinner or even get up super early in the morning to finish an assignment.

Most kids really do count on structure, and it’s important that they know what to expect. At the same time, the schedule should be flexible enough to make room for everyday life — like a good cry after a fight with a friend or a quick trip to the ice cream shop for an after-school treat. When they know they can “break the rules” from time to time, they’re less likely to test their parents all of the time.

It’s also important to pay attention to how the schedule is working out — especially from year to year. My daughter used start her homework as soon as she walked in the door. But when she got a little older, it was apparent that she needed 30 minutes or so to unwind, to do something that had nothing to do with school. Of course, as kids enter middle and high school, this schedule should be their own.

3. STOP Reteaching

I can’t emphasize this enough. Stop it. Right. Now.

You are not the teacher. When you reteach, not only do you risk making your kid furious and even more frustrated with the work, you risk confusing your kid. Big time.

There is a reason that long division is going the way of the dodo bird. There is a reason that teachers introduce algebra in earlier grades. There is a reason that kids learn how to find the least common multiple before they learn to add fractions. And you might not know what those reasons are.

I would never attempt to perform brain surgery on my kid. I wouldn’t try to fix the hybrid system on my car. That’s because I’m not trained to do these things. And while many parents do an amazing job homeschooling their kids, mostly, they’re achieving this with the whole picture — and a lot of professionally developed resources.

This is probably the hardest step. It also holds the most promise for lowering stress. I promise.

4. Ask Questions, Don’t Give Answers

Want to know how to accomplish the last step? It’s pretty simple, actually. When your kid says, “I don’t know how to do this!” respond with a question.

“What does the assignment say?”
“Can you explain to me what the teacher asked for?”
“What is confusing you?”
“How can I help you figure it out?”

This puts the responsibility back onto your kid — where it belongs — without taking on any of her stress. Keep asking questions, even if she can’t answer them. Don’t solve the problems for her, but look for her to find her own solutions.

5. Let Your Kid Fail

Kids learn from making mistakes. We don’t do them any favors by preventing them from failure.

I’d rather my kid fail a homework assignment than a test and a test than a grade. And I’d rather my kid fail at something when she’s 10 years old than when she’s 40 years old. Failure at a young age won’t keep her from experiencing later failures. But she will learn from those little failures.

For that reason, you should quit checking your kids’ homework for accuracy. Heck, when they get to be in middle school, you should probably stop checking to see if their homework is done. Give them the right structure for success — space and time to complete homework assignments, little reminders, etc. — but let them chart their own way. (My friend and colleague, Denise Schipani calls this African-Violet Parenting. I call it parenting by benign neglect.)

So there you have it, five steps for lowering the homework stress in your house. I can’t promise that you’ll never have another fight with your kid, but I can say that following these steps will help you keep your cool.

Do you have other suggestions? Share them in the comments section. 

Categories
Math Education Math for Parents Math for Teachers

The Homework Wars: What matters? What doesn’t?

Last week, I heard from many friends and colleagues about Karl Taro Greenwood’s Atlantic.com piece, “My Daughter’s Homework Is Killing Me.”

“Amen!”

“I could have written this!”

“When are teachers going to learn that they’re piling on way too much???”

It was clear to me that the emotion of this piece resonated. But really what I think is this: Mr. Greenwood is probably a very nice man, but he comes off like a whiney, know-it-all parent. And he’s worried about the wrong damned things.

If you read Greenwood’s story, you know he’s worried that his daughter is getting too much homework. At the tender age of 13 years, she wasn’t able to fall asleep until after midnight, because of her homework load. He admitted that bias up front, and decided to see for himself. He took on his daughter’s assignments for a full week.

But really, what he should be paying attention to is the kind of homework his kids are doing.

At the same time, I can compeltely identify with his frustration about his kid’s bedtime. My kid often goes to sleep after midnight. She spends way too much time on homework, but I can say without hesitation that the fault lies with her, because her routine looks something like this: text friends, try to find her worksheet, text, check out when the new episodes of New Girl are coming on Netflix, text, do three math problems, text, find a new Pandora station on her phone, read her library book, finish her math, start science… well, you get the picture. By 10:00 p.m., she’s an anxious mess sometimes.

Her homework load is not too much. It’s generally between one and three hours each night, depending on how much she’s procrastinated on her weekly projects/assignments. (That is, if she actually gets to work, instead of goofing off.)

Greenwood’s daughter averages about three hours. Yes, that’s a lot. But if she’s staying up so late, it’s because she’s not getting started until 8:00 p.m.. (He never says why.) That’s a full five hours after my kid gets out of school, and even with her three-times-a-week soccer practice, it’s way, way later than she usually gets started.

But the thing that bothers me the most is what Greenwood writes here:

The Spanish, however, presents a completely different challenge. Here, Esmee shows me that we have to memorize the conjugations of the future tense of regular and irregular verbs, and she slides me a sheet with tenertendré,tendrástendrátendremos, etc., multiplied by dozens of verbs. My daughter has done a commendable job memorizing the conjugations. But when I ask her what the verb tener means (“to have,” if I recall), she repeats, “Memorization, not rationalization.”

She doesn’t know what the words mean.

Shocking. Certainly, each subject requires a little bit of “fake it ’til you make it,” but not to know what the verb means is pretty amazing. And the fact that his daughter has so completely internalized the message “memorization, not rationalization” is truly tragic. That message goes against any educational philosophy I was taught at university.

At the same time, the author is incredibly proud of his (and his daughter’s) ability to pick up on the patterns presented by combining like terms in algebraic expressions. He whizzes right through those problems (none of the math homework is excessive, in my opinion), but has he merely memorized or is he really understanding what the process means? I could be wrong, but my guess is that he might have trouble explaining why the process works.

In other words, critical thinking is important in Spanish, science and literature, but really thinking through the whys of math? Nah, it’s way better to finish those problems as quickly as possible.

Easy homework = good homework?

The homework wars will never end. And that’s because when we all get home from work and school, no one wants the fight that ensues. We want to play board games or curl up on the couch and watch stupid television or read books that weren’t assigned to us.

But if teachers assigned homework that really mattered, would parents still be upset? If teachers asked kids to answer the hard questions, like “How did you get your answer?” or “Ask a family relative about his or her experience with immigration,” would we revolt, because that’s hard too? When schools are serious about rigor, do parents retaliate?

Homework shouldn’t be busy work. But I still believe that there’s real value to asking students to practice what they’ve learned or make some connections on their own. When we parents approach this in a positive way, we have an opportunity to teach our children than learning doesn’t stop at 2:50 p.m. or when we graduate from college.

What would happen if we sent our kids a positive message about their homework? (While working against excessive or stupid assignments, of course.)

This afternoon, my kid walked home from soccer practice, grabbed a snack and ran up to her room shouting, “I’m going to work on my science essay!” I don’t think this thing is due  until the beginning of next month. I didn’t have anything to do with her being excited to get to work. I also didn’t get in her way. She likes this assignment — probably because it’s challenging — and she’s happy to do it.

I’d say that one step in that direction is a little less whining, and a little more listening to kids and teachers.

P.S. Greenwood had lots of reasons to be ticked off about his kid’s school, starting with the lousy parent-teacher conferences. I don’t mean to suggest that he was off-base with everything.

P.P.S. Atlantic also had a great piece from a teacher, who is reassessing her practice of giving homework. I thought her reasons and concerns were compelling. Parents should read that piece as well: Should I Stop Assigning Homework? by Jessica Lahey.

What do you think about the homework your kid is getting? Homeschooling parents, what’s your take on the homework wars?