Excel

media type="file" key="Movie_0002.wmv"media type="file" key="Movie_0001.wmv"

media type="file" key="Movie.wmv" width="300" height="300"media type="file" key="Unit Excel_0001.wmv" width="299" height="299"
media type="file" key="Wiki Santiago Pozo Movie excel.wmv" width="299" height="299"

**Why is it better to graph in excel?** Graphing by hand may sometimes not be the most effective way to work with information. Graphing in excel is always faster since it does all the mathematics for you so everything you got to do is input your information. Excel will create a more accurate graph since it is all calculator like software. Since it has calculator like software it does all the operations for you and is always faster with variables. For example only drawing a pie chart you would take more than 5 minutes the computer does it instantly.

**Why should you sort and filter in excel?**
Sorting helps you organize your information and that way the information will look neat. Filter helps you to find a certain value on a big list or a certain salesman you want to buy from. It is faster than just looking on a big list and it is much more organized.

Situations like to see how many times had you bought in a store, or how many tests you had pass in the year. This tool is really helpful because you don't have to be counting if is a long list of things.
 * Why should you use the COUNTIF function?**

There are different situations to use the sum icon, but all of them help for sum any group of numbers that you want to fibd the total of, it is much faster for you tu use Excel instead of using a calculator, because with excel you just higlight the numbers that you want to find the sum of, instead of writing one by one with the calculator.
 * Why should you use SUM icon?**

You should use the SumIf funtion to see the total of one certain thing, for example, if you had bought un alot of markets, but you want to see what is your total in just one market you use the SumIF function,
 * Why should you use the SUMIF function?**

The IF Statements works for many things, it can work with numbers, words and equations. If you want to see how many students fail and passed the tests you would use the IF Statement using words, if you want to see the discount of things you have bought depending on the price, you would use the IF Statement with numbers, and if you want to find the final price of something you've bought, you will use the IF Statement with equations.
 * Why should you use the IF statement?**

Excel is a calculator, it will solve any multiplication, division or substraction problem, the only difference that Excel cand you all that function for you but a lot more faster, and by dragging down you can do that with really large group of numbers.
 * Why should you divide, multiply and substract in Excel?**


 * Vocabulary **

=
//__Pie Chart__//: a graphic representation of quantitative information by means of a circle divided into sectors, in which the relative sizes of the areas (or central angles) of the sectors correspond to the relative sizes or proportions of the quantities.======

**Bibliography**
French,Ted. (2007). Line Chart Tutorial. Retrived on June, 2, 2010. http://spreadsheets.about.com/od/excelcharts/ss/line_graph.htm

French,Ted. (2007). Column Chart Tutorial. Retrived on June, 2, 2010. http://spreadsheets.about.com/od/excelcharts/ss/column_chart_9.htm Give examples and definitions for each of the following features. Highlight the advantages of using each tool compared to a less efficient method. Use of absolute references (constant cells), use of exponents Use of features: pivot table Vocabulary “a **pivot table** is a data summarization tool found in data visualization programs and pivot-table tools can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table (called a "pivot table") displaying the summarized data.” http://en.wikipedia.org/wiki/Pivot_table Constant Cells Vocabulary
 * Computers **
 * Unit 5: Excel **
 * Open Excel
 * Make a list of items of what ever you like in this case Tennis
 * Then go to insert and click on pivot table
 * When the window appears click OK
 * Then you have to click in the pivot table and arrange the information as you want.
 * Let’s say in my case you put tennis information and you can organize it by country and by price. That is the use of the pivot table. AS the definition tells us is helpful to analyze long data just specifying what you want to analyze.
 * Constant cell- when you in put a value in a formula that you need it to be the same always in that formula is a constant cell.
 * To have a constant cell you have to put a formula in the excel formula bar, and in the value that you need it to be constant you click F4(in the keyboard)
 * An example would be if you are in an amusement park and you have two variables like ride and cost. The constant in that formula would be the y intercept in this case 12 and you are always multiplying by 4 in the different number of rides. The best use of this is that you don’t have to write the formula again just drag down with the constant numbers.

Use of exponents Vocabulary
 * a symbol or number placed above and after another symbol or number to denote the power to which the latter is to be raised. http://dictionary.reference.com/browse/exponent
 * An exponent in excel is in a quadratic equation.
 * Is help full to make graphs and tables. You do it by putting insert, object, windows equation.