Example Data Tables: link to more instructions:http://www.ncsu.edu/labwrite/res/gh/gh-tables.html

 

Directions: ( if using a Mac and you don't have a right button on your mouse, you can always find most options under  "format" at the top of your menu toolbar.

1. Enter your data into Excel

2. Make sure the data and column headings are centered by highlighting the column and selecting the "center" icon in your toolbar.

3. Make sure your numbers are consistent (example all whole numbers or 2 decimal places) by selecting all, then right click, select  "format cells", select number and set to number of decimal places.

 

 

4. Copy data from Excel or other spreadsheet program  paste into Word or other word processing program (example openoffice.org http://www.openoffice.org/  has freeware (no cost) similar to MicroSoft Office).

5. Select all, right click and select "borders and shading"... select "none"

 

6. Highlight the cells that you want to place a horizontal line under

 

7. Right click and pull up the "borders" menu again and select a thicker line under "width" and select the bottom of the cell on the right:

 

 

8. Put a vertical line under any set of cells that are difference, example between the column headings and the data or between difference lab tables or between the raw data and the average.

 

Example:

The Effect of Moisture on Sowbug Habitat Preference

 

 

Time (min)

# of Sowbugs Wet

# of Sowbugs Dry

0

5

5

1

4

6

2

5

5

3

5

5

4

6

4

5

5

5

6

4

6

7

7

3

8

5

5

9

8

2

10

9

1

Mean

5.7

4.3

 

Identifying Organic Compounds  (note the lines around the table ARE NOT SUPPOSED TO BE THERE)

 

Substance

Benedictís Solution

IKI Solution

Sudanís IV Solution

Biuretís Solution

 Honey

+ (yellow)

-

-

-

Oil

-

-

+ (floating red droplets)

-

Egg White

-

-

-

+ (violet)

 

 

 

 

 

Key: "+" = positive reaction; "-" = negative reaction; (color change)

 

Example of corrected data table (note yellow highlight of words that should not be capitalized using "title case" format... do not highlight for your tables)

 

Figure 1: The Effect of Light on Behavior of Sowbugs

 

Time(min)

Light

(# of sowbugs)

Dark

(# of sowbugs)

1.0

4

6

2.0

4

6

3.0

2

8

4.0

2

8

5.0

3

7

6.0

1

9

7.0

2

8

8.0

2

8

9.0

5

5

10.0

5

5

Average

3.0

7.0

 

Example of reference for Introduction/Background

Sowbugs are found in leaf litter.1 

 

References:  (from www.easybib.com APA format

1. Newton |, B. (n.d.). Sowbugs of Kentucky - University of Kentucky Entomology. University of Kentucky - Welcome to the University of Kentucky. Retrieved August 31, 2010, from http://www.uky.edu/Ag/CritterFiles/casefile/relatives/sowbugs/sowbug.htm