Regional Technology Integration Specialist Clint Stephens brings thirteen years classroom experience to SEDC. Clint was awarded the Utah Middle School Science Teacher of the Year award by his peers and also won several technology innovation grants & awards. He has taught secondary science in Escalante, Hurricane and Salt Lake City, and has been helping teachers in the SEDC region for over 3 years.
If you would like to set up a technology training at your school, make a request to your district technology coordinator, and they will work with Clint to get you the training you need. Have a date in mind? Take a look at his calendar. His training resources, tutorials, and handouts and training blog are also available online.
Today we'll be looking at the new Excel 2007. We'll show you the new features of the interface, show you some tricks & shortcuts that have been hiding "under the hood" for a long time, and then take it to the next level with 3-D equations and editing multiple sheets at the same time. We'll use the CustomGuide Quick Reference Guide as we go.
3-D Chart Building and 3-D Equations
Here's the setup - Your school is participating in an annual fundraiser to sell items from a catalog. There are 4 classes competing for the grand prize of a trip to Lagoon selling items for a 4 month period. You must keep track of the following details:
The number of items each class sold per month
The sum of all items sold for a 4 month period
The dollar amount each class sold per month
The total dollar amount each class sold
Your Principal also wants a summary sheet with all current count of all of the items that a class has sold and a total dollar amount so that each class will know how the competition is going. She does not want all of the details of each class included, just all of the totals on one sheet.
She would also like to know how many items and how much money is taken in month by month since there is also a monthly school goal to reach as well.
Let's build this the quick and easy way in Excel!
Make a worksheet for each class, plus a summary sheet
Build the class sheets all at once! Hold down the CTRL or Shift key and select all of the worksheets, then edit one sheet. The information added in one sheet will appear in all of the other selected worksheets. Nice!
Create the SUM formulas to add up the items and dollars for each month
Enter in the teacher data that follows:
Gardner's Class: 73 items for $435, 45 items for $233, 65 items for $487, and 86 items for $721.
Yardley's Class: 23 items for $120, 21 items for $257, 59 items for $630, and 54 items for $511.
Phillips' Class: 98 items for $640, 104 items for $833, 43 items for $654, and 32 items for $303.
Schmitt's Class: 75 items for $385, 92 items for $695, 87 items for $860, and 78 items for $612.
Create the summary sheet with each teachers name, and columns for total number of items and total dollar amounts.
Create the 3-D formulas to add the totals from each teachers worksheet to the summary page
Regional Technology Integration Specialist Clint Stephens brings thirteen years classroom experience to SEDC. Clint was awarded the Utah Middle School Science Teacher of the Year award by his peers and also won several technology innovation grants & awards. He has taught secondary science in Escalante, Hurricane and Salt Lake City, and has been helping teachers in the SEDC region for over 3 years. 
Technology 
