TP – Students will create and analyze a budget by using the functions and features of Microsoft Excel
Download the following file and follow the directions shown:
Monthly Archives: December 2013
What color are my Skittles?
TP – Students will represent data by creating charts and graphs in Microsoft Excel
First, we will refresh our memories and review our excel vocabulary.
Next, I would like you to download this worksheet to your flashdrive:
We will open Microsoft Excel and follow the directions within the worksheet.
Here is the rubric:
Some tips:
Remember the autosum key
For a project title make sure to insert Wordart
Do you think you are done?
Did you share it with a classmate to get their input?
What does your pie chart show? Is that what you anticipated?
Do you think everybody has the same chart? Why/Why not?
Then…Make sure your project is named properly and send it 🙂
You may go to code.org
Excel references
In order to understand both the directions of the teacher and the directions within your worksheet (webpage) there are some common vocabulary words you must understand.
For some of the basic functions, please refer back to the previous post:
Here is a simple labelled screenshot:
Here is a more detailed screenshot with some information:
If you have any questions beyond these, please ask me!
7th Grade Budget Project
TP – Students will create and analyze a budget by using the functions and features of Microsoft Excel
As you get older and become more responsible for your own financial stability, it is important to learn how to budget your money properly. In this lesson you will view what is like to create a budget. The information about what money is spent and gained are included, but you will need to formulate the spreadsheet for the proper calculation. A follow-up project will have you create your own budgets. Directions and rules are in the following link.
As you perform these tasks, think about your own monetary needs. How do you get money? Where do you spend it?
Here is the rubric for your guidance: