This is the first week of a two-week lab studying cell motion. This week we will learn how to use

Excel to analyze the 1-D motion of an amoeba from stop-motion images. Next week we will be

analyzing videos of cell motion: 1) wound closure, 2) neutrophil motion, and 3) bacteria

motion—to determine whether or not a patient should be prescribed antibiotics. Clearly, the

relative speeds of the wound closure, neutrophils, and bacteria will affect your decision. Thus it

becomes important that we learn how to quantify the motion of cells.

On the next page, you will see a graph of the movement of Dictyostelium discoideum, shown as a

sequence of outlines of the amoeba cell at 3.0-minute intervals. Your task is to record and analyze

the motion of the amoeba—specifically, the position, instantaneous and average speed, and

instantaneous and average acceleration. Rather than do all of the mathematical calculations by

hand, Excel can help you do the calculations much more quickly and efficiently. This week you

will practice and master the skills necessary to bend Excel to your will and make it do the grunt

work. Next week, you will be expected to be experts at these skills so take turns and help each

other learn.

Deliverables:

Either individually or with a partner, you will submit a set of graphs (y vs. t, v vs. t) with your

data tables and the typed responses to these questions:

1) What do these graphs say about the motion of this organism?

2) Look at the top speed for the organism. If the organism were moving at the top speed for an

entire day (24 hours) how far would it travel. Compare this to the length of the human

body.

3) What did you learn from this first online lab? What do you think the instructors are hoping

you start to learn and practice from this?

You will upload the graphs, tables, and typed responses in one PDF to the assignment page in

canvas. It is incredibly hard to grade if there are several pages of uploads.

_________________________________________________________________________________________________________________Ad

apted from K. Moore, J. Giannini, B. Geller & W. Losert (Univ. of Maryland, College Park)

1

2

Table 1: Your position vs. time graph – Using the figure above, find the position for the amoeba

for each time given in the graph. Remember, each snapshot of the amoeba is taken in three second

intervals (hence the intervals given in the graph). For consistency it is best to pick the same part of

the amoeba every time (say the top point). When you are done create a graph of your position vs.

time. Usually we use a scatter plot for data like this but this time we will use a line graph. Be

careful to show units! You may use either google spreadsheet or excel. There is an excel review on

the next page.

t y

0

3

6

9

12

15

18

21

24

27

30

3

Table 2: Your velocity vs. time graph – Remember, your velocity is Δy/Δt , so if you can

calculate the average velocity ( y2

- y1

)/ (t2 − t2

) during each time interval in the table above. As an

approximation, we can say that this average velocity occurs in the middle of the time interval so

1.5s for the first velocity, 4.5s for the second velocity, etc, as can be seen in the table below. Once

you complete the table, make a graph for velocity vs. time.

t v

1.5

4.5

7.5

10.5

13.5

16.5

19.5

22.5

25.5

28.5

4

Excel Tutorial Reference

Intro to Scientific Data Analysis with Excel

Excel (or any spreadsheet program) can help you do calculations quickly and efficiently. But Excel

is only a software program—it can only be as smart as the instructions that you give to it. Today

you will practice and master the skills necessary to bend Excel to your will and make it do the

grunt work. After today, you will ALL be expected to be experts at these skills so take turns and

help each other learn. Take notes for the future if you are worried that you will forget. Each

version of Excel (as with the other Microsoft Office programs) varies slightly, but familiarity with

one version should help you intuitively guess/explore the other versions. Some of you may feel

that you are already familiar with Excel; please READ the Technical document anyway! It

contains specific scientific norms that you need to learn.

Entering Data

To enter information in a cell, click on the cell (e.g., cell A1—column A, row 1) and type the

information. When you are finished, press ‘Enter.’ You will see the information in the cell. To edit

the information, click on the cell and type (erases previous entry) or click on the cell and then click

on the formula bar to edit (the formula bar is above all the cells but below all the icons for text

manipulation (bold, italicize, center in cell, etc.).

Title each column with the quantity’s name and units. In the cells beneath each column title, enter

the data that you have collected by typing the numbers into the cells. When you have finished

entering your data, save the file by pressing ‘Ctrl’ + ‘C’ (name the file and note the saved location

for future use) or by selecting the ‘File’ tab, then the ‘Save as’ icon. Save regularly to avoid losing

work. Every time you save the file, it overwrites the previous version.

The number of decimal places displayed in the cell can be controlled by icons in the ‘Number’

menu on the ‘Home’ tab. Use these icons to give your data uniform appearance.

5

Generating Columns of Data Calculated from a Formula

To generate information from a formula (i.e., to mathematically manipulate cells), click on a cell

and begin with =. All Excel entries for which you expect a numerical result/output MUST begin

with an equals sign, =. The mathematical manipulators are what you would expect: * to multiply, /

to divide, + to add, and – to subtract. To exponentiate, type ^ and the power (e.g., 62 is 6^2). Let us

say you wished to multiply the entry in cell A1 by 60. To do this you would click on the cell where

you wish the output to go and then type ‘=60*A1.’ You can type the input cell, A1, on the

keyboard, or you can use the mouse to click on cell A1 while typing the formula. For more

complex mathematical operations, parentheses often become necessary. Excel will color-code the

parenthesis to help you see where each set opens and closes. Be VERY careful with your

parentheses! (Again, Excel is only as smart as the instructions that you give to it!)

If you wish the same mathematical formula to be applied to every cell in a column (e.g., column F

is column A times 60), type the formula into the output cell for the first row. Then click on the

output cell and move your mouse over the bottom, right corner of the cell. Your pointer will

change shape and become a plus. Press down the left mouse button, drag down to the last cell you

wish to effect, then release the mouse button. The cells will automatically fill in. By clicking on

any of these cells, you can see in the formula bar that the formula has been adjusted to reference

the correct input cell (i.e., for the row you are currently in). The same process can be used to copy

a formula across a row into multiple columns. If, in a formula, you wish to reference a specific

column or cell (that will NOT change when the formula is dragged over a column or row), use the

$ symbol: e.g., $A1 will always be column A, but the row number can change; and $A$1 will

always be column A and row 1—neither can change.

Generating Graphs

When creating a graph/plot, Excel will usually plot the first column on the independent/horizontal

axis and the second column on the dependent/vertical axis. You should always check that the

correct data has appeared on the correct axis. If the data has been entered with the columns in

reverse order, this can be fixed after the plot is created. To generate a graph/plot, use the mouse to

highlight the data that you wish to graph (if the data is adjacent, just highlight the entire chunk; if

the columns are not adjacent, highlight each column separately while holding the ‘Ctrl’ key). Once

the data is highlighted, click on the ‘Insert’ tab and then the ‘Scatter’ icon (on the ‘Charts’

menu—other types of charts may be appropriate for different data types, but the Scatter plot is the

most commonly used).

6

From the sub-types of scatter plot available, choose the one that hasdata points but no lines. A

graph will appear—but you are NOT finished yet! The design of the graph can be adjusted using

the ‘Chart Layout’ menu—you will want to be able to label the individual axes with the quantity

graphed and its units and you will want to be able to title the graph. When the graph has been titled

(for the ‘vs.’ format, it is always ‘Dependent’ vs. ‘Independent’) and the axes have been properly

labeled, you can choose to keep or delete the Legend (not needed if only one data set is plotted,

absolutely necessary for multiple data sets). The location of the chart can be changed by:

left-clicking on the chart (the upper right corner works well), then right clicking and choosing

‘Move Chart’ from the menu. It is often best to make the chart a ‘New Sheet’ (so that it doesn’t

block your view of the data)—give it an appropriate title and click ‘Okay.’ You chart will become

its own sheet—and your data will disappear! But the data is not gone—to find it, use the tabs on

the bottom of the Excel window (‘Sheet 1’ is usually the data; now might be a good time to rename

it ‘Data’: right click, select ‘Rename’ and name it).

Before you finish, check that the correct data has been plotted on the correct axis and that the axis

labels match the quantities plotted. If the original columns were in reverse order, this can be

adjusted by left-clicking on a data point (to select the data), and then right-clicking and choosing

‘Select Data’. Click on the Legend Entry you wish to adjust, and then click ‘Edit.’ Highlight the

appropriate Series X and Series Y data and then click ‘Okay.’

Adding a Best Fit (“Trendline”) to a Graph:

To add a line of fit (called a “Trendline” in Excel) to a graph, left-click on a data point to select the

data, then right-click and choose ‘Add Trendline.’ Choose the appropriate Trend/Regression type,

and tick the boxes for ‘Display Equation on chart’ and ‘Display R-squared value on chart’. As a

general rule, do not ‘Set Intercept’ to a specific number (i.e., do not force the origin to be part of

the trendline). Do you know what the R-squared value really means? If not, you should look it up!!

Look at the equation for the trendline and think about it. What does the slope mean? What does the

y-intercept mean? What does this R-squared value mean?

Adding Error Bars to the Data Points on a Graph

Error bars represent the uncertainty of the measurement of the data. Do you have uncertainty? Do

you have uncertainty in both quantities (horizontal and vertical)? Is the uncertainty the same for all

data points, or does it change with the value of the quantity plotted? Wherever you have

uncertainty, you must have error bars! Once you have determined the amount of uncertainty, you

can add error bars by clicking on the ‘Layout’ tab (inside the ‘Chart Tools’ tab) and clicking on the

7

‘Error Bars’ icon. To get both horizontal and vertical error bars, a good choice is the ‘Error Bars

with Standard Error,’ and then click on the vertical and horizontal bars (individually) and right

click to ‘Format Error Bars.’ Apply the error bars according to the decisions that you have made

about your uncertainty. To remove either vertical or horizontal error bars, left-click on the bars,

then right- click and choose ‘Delete.’ (Future Lab Skill Goal: How do we propagate uncertainty

into calculated quantities?)

Other Cool Tools

As a spreadsheet program, Excel can do a lot of useful statistical analysis and mathematical

manipulation. Some functions you will find useful include: Sum, Average, and Standard

Deviation.

To Sum elements, click on the cell in which you wish the result to appear, then enter ‘=sum.’

Immediately, Excel will list possible formula options that begin with ‘sum’. For a simple

summation of elements, you would choose the SUM function, which you have already typed, but

you should note the other options available. Open parentheses following your sum, so that you

have now types ‘=sum(‘ and then highlight the cells to be summed. Close your parentheses and

press ‘Enter.’ (It would look like this ‘=sum(A1:A5)’ for a sum of the cells in rows 1 through 5 of

column A.)

To Average elements, click on the cell in which you wish the result to appear, and then enter

‘=average(.’ Highlight the cells you wish to average and then close your parentheses and press

‘Enter.’ Note that Excel will offer you a list of average functions—the most commonly used option

is the AVERAGE function. (It would look like this ‘=average(A1:A5)’ for the average of the cells

in rows 1 through 5 of column A.)

To perform a Standard Deviation on a set of elements, click on the cell in which you wish the

result to appear, and then enter ‘=stdev(.’ Highlight the cells you wish to perform a standard

deviation upon and then close your parentheses and press ‘Enter.’ Note that Excel will offer you a

list of standard deviation functions—the most commonly used option is the STDEV function.

Sample Solution

The United States is home to the absolute generally famous and productive chronic executioners ever. Names, for example, Ted Bundy, Gary Ridgeway, and the Zodiac Killer have become easily recognized names because of the horrendous idea of their violations. One of the most productive chronic executioners in American history is John Wayne Gacy. Nicknamed the Killer Clown as a result of his calling, Gacy assaulted and killed at any rate 33 adolescent young men and youngsters somewhere in the range of 1972 and 1978, which is one of the most elevated realized casualty tallies. Gacy's story has become so notable that his wrongdoings have been highlighted in mainstream society and TV shows, for example, American Horror Story: Hotel and Criminal Minds. Legal science has, and keeps on playing, a significant function in the fathoming of the case and ID of the people in question. John Wayne Gacy's set of experiences of sexual and psychological mistreatment was instrumental in provoking examiner's curiosity of him as a suspect. John Wayne Gacy was conceived on March 17, 1942, in Chicago, Illinois. Being the main child out of three kids, Gacy had a stressed relationship with his dad, who drank intensely and was regularly injurious towards the whole family (Sullivan and Maiken 48). In 1949, a contractual worker, who was a family companion, would pet Gacy during rides in his truck; notwithstanding, Gacy never uncovered these experiences to his folks inspired by a paranoid fear of revenge from his dad (Foreman 54). His dad's mental maltreatment proceeded into his young grown-up years, and Gacy moved to Las Vegas where he worked quickly in the emergency vehicle administration prior to turning into a funeral home chaperon (Sullivan and Maiken 50). As a funeral home specialist, Gacy was vigorously associated with the preserving cycle and conceded that one night, he moved into the final resting place of an expired young kid and stroked the body (Cahill and Ewing 46). Stunned at himself, Gacy re-visitations of Chicago to live with his family and graduates from Northwestern Business College in 1963, and acknowledges an administration learner position with Nunn-Bush Shoe Company. In 1964, Gacy is moved to Springfield and meets his future spouse, Marlynn Myers. In Springfield, Gacy has his subsequent gay experience when an associate unsteadily performed oral sex on him (London 11:7). Gacy moves to Waterloo, Iowa, and starts a family with Myers. Nonetheless, after routinely undermining his significant other with whores, Gacy submits his initially known rape in 1967 upon Donald Vorhees. In the coming months, Gacy explicitly mishandles a few different young people and is captured and accused of oral homosexuality (Sullivan and Maiken 60). On December 3, 1968, Gacy is indicted and condemned to ten years at the Anamosa State Penitentiary. Gacy turns into a model detainee at Anamosa and is allowed parole in June of 1970, an only a brief time after his condemning. He had to move to Chicago and live with his mom and notice a 10:00PM time limitation. Not exactly a year later, Gacy is accused again of explicitly attacking a young kid however the adolescent didn't show up in court, so the charges were dropped. Gacy was known by numerous individuals in his locale to be an enthusiastic volunteer and being dynamic in network legislative issues. His part as "Pogo the Clown" the jokester started in 1975 when Gacy joined a neighborhood "Sprightly Joker" comedian club that consistently performed at raising money occasions. On January 3, 1972, Gacy submits his first homicide of Timothy McCoy, a 16-year old kid going from Michigan to Omaha. Asserting that McCoy went into his room using a kitchen blade, Gacy gets into an actual squabble with McCoy prior to wounding him consistently in the chest. In the wake of understanding that McCoy had absentmindedly strolled into the live with the blade while attempting to get ready breakfast, Gacy covers the body in his slither space. Gacy conceded in the meetings following his capture that executing McCoy gave him a "mind-desensitizing climax", expressing that this homicide was the point at which he "understood demise was a definitive rush" (Cahill and Ewing 349). Just about 2 years after the fact, Gacy submits his second homicide of a unidentified young person. Gacy choked the kid prior to stuffing the body in his storeroom prior to covering him (Cahill 349). In 1975, Gacy's business was developing rapidly and his hunger for youngsters developed with it. Gacy frequently attracted youngsters under his work to his home, persuading them to place themselves in cuffs, and assaulting and tormenting them prior to choking them (Cahill 169-170). The vast majority of Gacy's homicides occurred somewhere in the range of 1976 and 1978, the first of this time occurring in April 1976. Huge numbers of the adolescents that were killed during this time were covered in a creep space under Gacy's home. For the rest of the homicides, Gacy confessed to losing five bodies the I-55 scaffold into the Des Plaines River; nonetheless, just four of the bodies were ever recuperated (Linedecker 152). In December 1978, Gacy meets Robert Jerome Piest, a 15-year old kid working at a drug store and extends to him an employment opportunity at Gacy's firm. Piest illuminates his mom regarding this and neglects to restore that night. The Piest family records a missing individual's report and the drug specialist educates police that Gacy would doubtlessly be the man that Jerome addressed about a work. When addressed by the police, Gacy denied any association in Piest's vanishing. Be that as it may, the police were not persuaded, and Gacy's set of experiences of sexual maltreatment and battery incited the police to look through his home. Among the things found at Gacy's home were a 1975 secondary school class ring with the initials J.A.S., various driver's licenses, binds, attire that was excessively little for Gacy, and a receipt for the drug store that Piest had worked at. Throughout the following not many days, examiners got different calls and tips about Gacy's rapes and the secretive vanishings of Gacy's representatives. The class ring was in the long run followed back to John A. Szyc, one of Gacy's casualties in 1977. Futhermore, after looking at Gacy's vehicle, specialists found a little bunch of filaments taking after human hair, which were shipped off the labs for additional investigation. That very night, search canines were utilized to identify any hint of Piest in Gacy's vehicle, and one of the canines showed that Piest had, indeed, been available in the vehicle. On December 20, 1977, under the pressure of steady police reconnaissance and examination, Gacy admits to more than 30 homicides and educates his attorney and companion where the bodies were covered, both in the creep space and the stream. 26 casualties were found in the creep space and 4 in the waterway. Gacy is captured, indicted for 33 homicides, and condemned to death by deadly infusion. He endeavored a craziness supplication however was denied, and was executed on May 10, 1994. There were a few legal markers that agents used to attach Gacy to the homicides. A portion of these include fiber investigation, dental and radiology records, utilizing the decay cycle of the human body, and facial reproduction in recognizing the people in question. Specialists discovered filaments that took after human hair in both Gacy's vehicle and close to the slither space where the bodies were covered. Notwithstanding these hair tests, specialists likewise discovered filaments that contained hints of Gacy's blood and semen in a similar territory. Blood having a place with the casualties was found on a portion of the filaments, which would later straightforwardly attach Gacy to the wrongdoings. The strands in Gacy's vehicle were dissected by criminological researchers and coordinated Piest's hair tests. Besides, the pursuit canines that verified that Piest had been in Gacy's vehicle demonstrated this by a "demise response", which told examiners that Piest's dead body had been within Gacy's vehicle. Out of Gacy's 33 known casualties, just 25 were ever indisputably distinguished. A considerable lot of Gacy's casualties had comparable actual portrayals and were accordingly difficult to recognize by simply asking general society. To distinguish the people in question, agents went to Betty Pat Gatliff, a pioneer in scientific science and facial remaking. Facial remaking is the way toward reproducing the facial highlights of a person by utilizing their remaining parts. Certain facial highlights, for example, facial structures, nasal structure, and in general face shape can be helpful in recognizing a casualty even long in the afterlife. By utilizing these highlights, and with the assistance of program, scientific agents can make a picture of an individual's face, which is instrumental in recognizing casualties after their bodies have rotted. Facial remaking should be possible in a few measurements. Two-dimensional facial recreations is utilized with skull radiographs and depend on pre-demise photos and data. Nonetheless, this isn't really ideal in light of the fact that cranial highlights are not generally obvious or at the correct scale (Downing). To get a reasonable and more exact portrayal of the casualty's face, a craftsman and a measurable anthropologist are typically fundamental (Downing). Three-dimensional facial recreation is finished by figures or high goal, three-dimensional pictures. PC programs can make facial reproductions by controlling checked photos of the remaining parts and use approximations to reproduce facial highlights. These will in general deliver results that don't look counterfeit (Reichs and Craig 491). In some cases, specialists will utilize a strategy called superimposition as a method for facial reproduction. Shockingly, it's anything but a generally utilized strategy, as it expects agents to have some information about the personality of the remaining parts they are managing. By superimposing a photo of a person over the skeletal remaining parts, examiners can check whether the facial highlights line up with the anatomical highlights, permitting them to distinguish a casualty. On account of John Wayne Gacy's casualties, specialists had the option to utilize facial reproduction to recognize nine of the bodies found in the slither space. The accompanying realistic shows the facial reproductions of these nine casualties: Since facial recreation was insufficient to distinguish the entirety of the v>

GET ANSWER