| Skills in Microsoft Excel | Lesson Plans/ Lesson Plan Ideas/ Teacher Tools
that Incorporate those Skills |
Tutorials for those Skills (these tutorials
cover a variety of versions of Word and you may have to adapt the
instructions to fit your version...and sometimes there are pieces that
are incorrect
because of the difference in versions) |
| Basic Data Entry cell names click, tab, or enter Basic Formula Writing =sum() Chart (Graph) Making highlight cells and use Chart Wizard bar graph Formatting Cells cell background color color text Printing print area print preview gridlines |
Together: M&M Math intro More M&M Math On Your Own: Lesson Plans with Data Entry & Formula Writing an introductory exercise in Excel with higher level math (designed for students at Cal Poly): Your Fortunate Fortune Do Vampires Really Exist? Buy Your Dream Car Code Crackers The Big Allowance Money Changer Magic Squares Lesson Plans with Data Entry, Formula Writing, AND Chart Making One Grain of Rice How Much Water Does Your Family Use? Advanced Stuff Geography Geometry |
A
large collection of Excel tips and tricks (quick how-to's) http://www.exceltip.com/se/10.html This tutorial shows you the basics of Excel (assumes very little prior background) while making a gradebook (Bob Hope and Eddie Murphy will be in your class!); so you'll learn many of the skills listed to the left while learning how to make something useful in Excel http://storywind.net/education/mccarthy/lessons/exceltutorial.html A nice introduction to Excel with lots of screenshots http://www.functionx.com/excel/Lesson01.htm This brief introduction to Excel includes formulas, charts, and formatting cells http://www.bcschools.net/staff/ExcelHelp.htm A tutorial on different types of graphs and how to make them; Section 1 uses an example you may not have, but you could apply it to your M&M data to learn some of the features. From Section 2 to the end, it shows a data set that you could type into Excel in order to follow the rest of the tutorial. http://psdam.mit.edu/RISE/tutorials/excel/excel3.html This introduction to Excel is based on 5th grade science standards about weather. It's from Canada so all the measurements are metric but the Excel is the same. ;-) You can download their sample Excel file so that you can follow along on the tutorial. http://www.quasar.ualberta.ca/edit202/tutorial/spreadsheet/ExcelBasics/ExcelBasics.htm Sections 1, 2, and 3 of this tutorial are nicely done for introducing you to spreadsheet basics, formula writing, and chart making; Section 4 is really cool stuff but it is an engineering example (calculating maximum fiber stress in a homogenous cantilevered beam); don't be frightened by it...learn something new! http://psdam.mit.edu/RISE/tutorials/excel/excel.html All about printing http://www.functionx.com/excel/Lesson03.htm |
| More Chart Making modifying colors, backgrounds, titles, and more adding text boxes, lines, and shapes "on top" of a finished chart |
Ambidextrous
Graph Full lesson plan for ambidextrous graph http://math.rice.edu/~lanius/Algebra/rightleft.html |
Using Excel WordArt http://www.smartcomputing.com/Editorial/daily/dailycontent.asp?guid=&did=970 Though not a complete tutorial (they get you started then want you to pay for the rest), this will get you started nicely using WordArt http://www.elementkjournals.com/premier/showArticle.asp?aid=1217 How to insert clipart in Excel http://www.techtrainteam.com/services/olt/office2000/xls-a7.html |
| Clip Art Word Art |
Single Use Spreadsheets |
|
| Resize Columns and Rows format, manual change,.... print area borders gridlines |
Make your own graph paper/grid paper (see
M&M Math and
Ambidextrous Graph lesson plans above), make specialized paper
including music staff paper Make Word Search puzzles Grid Paper & Scale Drawings Plan Your Garden with Excel |
Nice tutorial with a simple example about
columns and rows (width, height, hide, unhide, format, etc.) http://www.functionx.com/excel/Lesson02.htm |
| Using Excel as a Mini- Database sorting importing/ exporting data |
Lesson
plan for using spreadsheet as software |
Tutorial on sorting using buttons or menu
dialogue http://www.extension.iastate.edu/Pages/Excel/unit4/sorting.html |
| Advanced features absolute references in formulas macros |
Tutorial on absolute references http://www.extension.iastate.edu/Pages/Excel/unit4/absolute.html |