 |
Technology Resources for Volunteer Tutors
and Others Who Work with Adults |
Using Excel with Adult Learners
Excel is one of the richest learning applications available for teachers and students. Learners can create exciting interaction with very little knowledge about all of the spreadsheet possibilities. Excel is addictive, so be careful. Once you get started, you may not want to stop!PROJECTS: Following are simply examples of projects that can be given to students or assigned for them to develop themselves. As you open each sheet, remember to check all tabs since some projects have multiple tabs.
Math
- Playing with Fractions and Decimals
- More Fractions
- Counting Money
- Simple Fraction Pie
- Trip Cost Esimator (Read Only)
Language/ Literacy
- Literacy Activities (Several tabs)
- Matching with Excel
- Dependent Intros
Health
Games
Following are just a few sites to get your started. At the bottom, I've also added some of the Excel projects thatyou are welcome to use and modify.
- http://office.microsoft.com/training/training.aspx?AssetID=RC011055061033 - How to create a chart - audio
- http://www.internet4classrooms.com/excel_task.htm - Classroom data in Excel
- http://math.rice.edu/~lanius/Lessons/graph.html - Very simple ideas on graphing class information
- http://academic.pgcc.edu/~ssinex/excelets/ - Huge list of wonderful, downloadable project with instructions!
- http://spreadsheetpage.com/index.php/file/ - There are some great downloads here, including developing bingo cards!
- http://www.vertex42.com/ExcelTemplates/ - What a hoot! Browse through the categories and find those your students need or want the most! Hundreds of spreadsheet templates are there for downloading. Want a budget? It's there. Can you imagine it? It's there. The site has dozens of its own, but it also links to other sites with free templates, including the wealth of materials at Microsoft. I do believe in reinventing the wheel sometimes since that's how I often learn. On the other hand, if you find a good template, study its features and teach your students to recreate it!
- http://www.teacherlink.org/content/math/interactive/interactiveexcel.html - Project samples and instruction for math projects.
- Descriptions of projects for Excel (Word)
- https://celia.wikispaces.com/file/view/excelprojects08.pdf - Lots of good ideas and project, but some links no longer work.
- http://www.makeuseof.com/tag/7-fun-weird-things-can-create-microsoft-excel/ - 7 Fun & Weird Things You Can Create With Microsoft Excel
- http://spreadsheetpage.com/index.php/file/ - More downloadable projects with animations embedded. - So many uses for graphs in all of our disciplines. Learn how!
- https://www.thoughtco.com/create-a-line-graph-in-excel-3123563 - Same as above.
- http://www.mrexcel.com/tip126.shtml - Really great ideas and instructions.
- http://www.shodor.org/interactivate/activities/PieChart/ - Interactive pie chart to play with and learn from.
