Practicing Excel
Spreadsheet Formulas
Excel spreadsheet formulas are the cornerstone of record keeping in the office, and are an essential work skill. Sadly this topic is often neglected in schools mainly due to a lack of teaching time in mathematics. While children may use computers a lot in the classroom, they are rarely used for mathematical tasks.
The assignments and accompanying teaching notes are designed to get kids using spreadsheets for math applications. The assignments were written mainly for use on the now outdated 2003 version of Microsoft Excel. I found this the easiest to use but I am slowly coming to grips with the reorganized 2007 version. There are bucket loads of free spreadsheet programs out there and the directions given here may not work for all those versions. The best of these is the free OpenOffice application that comes as part of a complete office package. These assignments slowly introduce the idea of formula use as a method of reducing workload. Once formulae are seen as a benefit they are more easily retained by students. Spreadsheet Exercises These files are free for personal use. Clicking on the link will open the PDF which you can then save to your desktop. Excel Addition PracticeHere's a short video first about using the addition and subtraction features in excel. Further down the page is a PDF file with excel addition exercises.
Excel Formula Practice 1: Addition Exercises
This is basically a list of number columns to practice adding using the method shown in the video.
Graphmatica Exercise 1
More info on this exercise will be added soon. More files will be uploaded as soon as I have time to convert them to PDF form so keep an eye out here. Note: Keep your ink cost low by using "Draft" mode if you're going to print these pages.
Top Of Page
Return from Excel Spreadsheet Formulas to Algebra Help
or
return to the Green Planet home page for Solar Power Facts.
|
