8/8/2019 Excel Projects for Classroom Students

http://slidepdf.com/reader/full/excel-projects-for-classroom-students 1/4

Excel Projects for Classroom Students

Amber MacArthur, Bill Jelen, Leo LaPorte, Andy Walker on the set of Call for Help on TechTV Canada. The tip in this show is from Excel for Teachers .Most teachers have computers in their classroom, but don’t know how to utilize Excel. In this segment,we’ll take a look at charting projects your students can do in Excel. 1) Create a bar chart to track surveydata 2) Use a pie chart to demonstrate fractionsBar Chart for Survey DataIn your classroom, your students take a survey of the class and they want to display the information on abar chart. In Excel, type the responses in several cells in column A, starting in cell A2. Enter the number of students with each answer in column B, starting in B2. Leave cell A1 blank. In cell B1, enter thequestion. This will be used for the title of the chart. Your data should look like this.

Select the range of data, from the blank cell in A1, through the last cell in column B. From the menu,select Insert - Chart. In the Chart dialog box, choose a Bar Chart on the left side. In the following screenshot, you can see the cells that are selected, and the various bar chart options.

8/8/2019 Excel Projects for Classroom Students

http://slidepdf.com/reader/full/excel-projects-for-classroom-students 2/4

Click Next twice.In Step 3 of the Wizard, click on the Legend tab. Uncheck the box for Show Legend.

Click on the Data Labels tab. Check the box for Value.

Click Next to go to the 4th step of the wizard. You can either choose to have the chart on a new sheet or embedded on a worksheet. If you want to print a full-page size version of the chart, use New Sheet.

8/8/2019 Excel Projects for Classroom Students

http://slidepdf.com/reader/full/excel-projects-for-classroom-students 3/4

The resulting chart:

To make each bar be a different color, right click one bar and choose Format Data Series.

In the Format Data Series dialog, click on the Options tab and choose Vary Colors by Point.

8/8/2019 Excel Projects for Classroom Students

http://slidepdf.com/reader/full/excel-projects-for-classroom-students 4/4

You can customize many other chart elements. If you don't like the grey background, right click on thebackground and choose Format plot area. You can choose another color (such as white) for thebackground.Pie Chart to Demonstrate FractionsDownload this workbook to demonstrate fractions.

Enter any fraction in the top cell. The pie chart will show that portion of the circle shaded. To downloadthis workbook, right click this link and choose Save Target As.For complete details on creating 25 cool workbooks for your classroom, buy Excel for Teachers .

For the BEST TV show on technology, check out Call for Help . This tip was originally published on June 19, 2006 and aired on TechTV in Canada and Australia on June19, 2006.The permanent URL for this page is http://www.mrexcel.com/tip126.shtml . If you are looking for show notes from another episode, visit my complete list of TechTV appearances .MrExcel.com Consulting can be hired to implement this concept, or many other cool applications,

with your data.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitnessfor a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.