How to fill in the insect data sheet and analyze the data

Insect spreadsheet and analysis

1. Open “Copy of insect data sheet” in third grade Mentorship Project folder:
1. Fix spelling errors
2. Make words consistent – for example: “Stink bug” should be “stink bug”
3. Add Order for each specimen (example:  Lepidoptera)
4. Add student ID code

                                                               i.      Use list given to Mr. Grillo

                                                             ii.      “Class” will use “3rdschool” as their ID

                                                            iii.      Karen will get the missing codes and codes for teachers

2. Make a chart of the specimens to match how they are stored in the trays.
3. Sort and summarize data (Karen will show how to do this) by:
1. Order
2. Year
3. Bioblitz
4. Create a map in ArcView of insect locations

Orders

Refer to the insect book – All the World’s Animals

Odonata – dragonflies (p. 32)

Mantodea – mantids (preying mantis) p. 46

Orthoptera – crickets and grasshoppers (p. 50)

Hemiptera – bugs (p. 62)

Coleoptera – beetles (p. 72)

Diptera – flies (p. 88)

Lepidoptera – moths and butterflies (p. 102)

Hymenoptera – wasps, ants and bees (p. 118)