Generic Spread Sheets |
GENERIC SPREAD SHEETS:
This page is not meant to teach you spread sheets, only to introduce you to them. We will learn how to use them in more detail in class. Within most spread sheet programs, you can:
The working area of a spread sheet file consists of cells which are designated by which row and column they fall into. For example there are 72 cells in the 12 rows and 6 columns in the figure below. Although only 72 cells are shown, I have made spread sheets containing over 10,000 cells.
Cells can contain text, equations, images, and other useful things.
THE MICROSOFT EXCEL GRAPHICAL USER INTERFACE (GUI)
The file menu is used to handle and print files.
The edit menu is mainly used to edit the content of your spread sheet, for purposes of this class, you will find it most useful for using the copy/paste functions and the find function (will find text/numbers in large spread sheets.)
From the insert menu, you can choose to insert/add extra columns, rows, cells, and CHART/PLOTS!!! We will be using the plotting function in a few of your labs. The next section will discuss this, but first....
You can use this menu to insert functions/equations (you could type them by hand.) Typical functions/equations would include trigonmetric, averages, and sums of rows or columns. There are also logical (and/if/or) functions, statistical functions, and many other equatons.
PLOTTING DATA WITH EXCEL
Say you wanted to plot the equation y= x2.
To get the results (see graphic belwo,) I followed these steps:
Your results should look like this
To make a plot, highlight the cells you want to pick. Then click on
in the insert
Excel will prompt you for the type of chart you wish to make, we will be using mostly scatter plots (#4.) To choose this type, highlight XY (Scatter) in the left window, then highlight the chart type labeled #4 in the graphic.
With respect to why we are using the #4 chart type and not the others, consider the following about each chart type:
1. This type hard to see and communicate trends
2. This type may lead others to make conclusions about trends, slopes, or at points for which you have no real data
3. This type hard for some to see original data points
4. This type works well, you should be able to say why considering types 1 -3...
You can finish the rest of the process by following the on screen instructions.
SPREAD SHEET EXAMPLE
Now suppose you want to know what the stress and moment are in the same beam loaded with a different force.
All you have to do is change the value in cell C20. Say we change it from 5 to 2 pounds. The spread sheet automatically recalculates and replots all the output.