Search for...

Excel High School Projects

by Danielle Hill, Demand Media

    Teach your high school students to use Microsoft Excel through engaging and creative projects. Whether you teach a class in computers and information technology or in another discipline altogether, you can integrate practice with Excel into a range of relevant topics.

    Consulting

    Encourage your high school students to improve their understanding of Excel software by giving them an activity based on business consultancy. To complete the activity, each of your students must pretend to be a consultant for a furniture company with several lines of furnishings. Using Excel, students must catalog and track the performance of various furniture lines and evaluate their relative profitability. Ultimately, students must use the data to make a recommendation to the business on how to improve financially. Students may also use Excel to design payment plans for the furniture company to use, as an alternative financing option for its customers. In addition, they may compare personnel performance on Excel.

    Time Lines

    Show your students how to use Excel to create informative and well-organized time lines. You can adapt the project to a language arts class, creating a time line of production from a single author or a group of affiliated writers. For a science class, you can use the time line to chart evolutionary trends or geological changes. For history students, a time line project lends itself to a myriad of possibilities. Show students how to orient the text at an angle, through the "Format Text" window and the "Orient Text" tab, to fit it onto the time line.

    Budgeting

    Teach your students about personal finance as you teach them how to use Excel. Using the software to create spreadsheets, have students create either a personal budget for themselves or a fictitious budget for themselves plus a family of dependents. If you're hoping to create a more realistic and immediately useful lesson on personal finance, it may be most beneficial to create budgets that reflect students' actual finances. If you'd prefer to make the budgets more complex and to offer some privacy regarding your students' actual finances, a fictional scenario may work better.

    Buying a Dream Car

    Have students use Excel spreadsheets to compare the prices of their various dream cars. If any students would prefer to substitute a house, boat or other large purchase for a dream car, just ensure that they choose an item they can find plenty of examples of, at various prices. Have the students create a spreadsheet with the cost of their various options. If your students have studied compounding interest rates, you can have them determine a few payment plans and compare them, based on each of their options. Have them add that information into the spreadsheet, as well. Have your students compare their options based on the data they have organized within Excel.

    Style Your World With Color

    About the Author

    Danielle Hill has been writing, editing and translating since 2005. She has contributed to "Globe Pequot" Barcelona travel guide, "Gulfshore Business Magazine," "Connecting Lines: New Poetry from Mexico" and "The Barcelona Review." She has trained in neuro-linguistic programming and holds a Bachelor of Arts in comparative literature and literary translation from Brown University.

    Photo Credits

    • Manos en teclado 20509 image by pablo from Fotolia.com

    Watch An Education Video!