This 3 lesson bundle is aimed at middle school to high school students. It provides engaging, ready to go beginner to intermediate level activities for your students. It is priced to save you over 33%
off buying each of the products individually. Note that this will be a growing bundle
, so buy now and get free updates as the bundle grows. I have been giving these assignments to beginners of Excel for years and they have worked extremely well. Each lesson comes with detailed step by step instructions with plenty of screenshots. There are 2 sets of instruction options for each assignment; one is extremely step by step and the other is less instructive if you want students to have a little more of a challenge (great for if they are working in groups).
Please feel free to contact me with questions or comments regarding this bundle! I hope that you find it useful and I look forward to hearing from you.
Included in this package:
Excel 2010 Tutorial - Intro to Excel, data entry and formatting
This is definitely a beginner, novice level, newbie assignment! It should be your starting point in this bundle. Students learn basic data entry as well as how to use the AutoFormat feature to make tables look nice and colorful! This is literally the first exercise I give my students in an Excel unit. Being a Canadian, I am affirming the stereotype about us loving hockey by making this an NHL (fictional) standings data table :)! Obviously students could choose NFL, NBA, MLB or other non sports related information to include in their table.
Excel 2010 Tutorial - NBA stats Using the AVERAGE math function
In this engaging beginner level activity, we will use the world of sports to illustrate how to use the AVERAGE function in Excel. Specifically, students build a spreadsheet that calculates averages based on a fictional 10 game cross sample of NBA players scoring stats. Formatting skills are reviewed here as the exercise requires the creation of headings, the formatting of shapes, the use of borders, as well as different font sizes and colors.
This lesson can be used in other versions of Excel, and is a classroom tested exercise. I usually give this assignment within the first couple of classes of an Excel unit, after having covered basic data entry and after the students are familiar with basic math functions such as SUM and AutoSum.
Excel 2010 Tutorial - Using Sparklines to graph data trends
This is a popular assignment as students get to visually represent data trends using Sparklines. We make up some car sales data for a fictional company and use the numbers to show sales highs and lows like a stock market graphic.
This is an engaging beginner to intermediate level activity. Formatting skills are reviewed here as the exercise requires the creation of headings, the formatting of shapes, the use of borders, as well as different font sizes and colors.
This lesson can be used in other versions of Excel, and is a classroom tested exercise. I usually give this assignment towards the end of an Excel unit, after having covered basic data entry and after the students are familiar with math functions such as SUM, AVERAGE, AutoSum and creating their own formulas to perform various calculations including multiplication and subtraction.
- Take the time to do these exercises yourself prior to presenting to the students so you are familiar with the steps.
- It is helpful to present the teacher demo excel files that come with data already populated, and use these demo files to highlight the math / formatting key teaching points as you see fit.
- Pick the instructions which match your class the best. There are very hands on instructions as well as instructions that are designed for students to be more independent and investigative.