Guide to the CVSEEP Data Entry Database - PowerPoint PPT Presentation

About This Presentation
Title:

Guide to the CVSEEP Data Entry Database

Description:

Unzip the file with WinZip if you have it ... OR Unzip the file with Windows Zipped Folder ... Make sure the zipped folder or WinZip is closed. You're Ready to Start ... – PowerPoint PPT presentation

Number of Views:78
Avg rating:3.0/5.0
Slides: 34
Provided by: micha58
Learn more at: http://cvs.bio.unc.edu
Category:

less

Transcript and Presenter's Notes

Title: Guide to the CVSEEP Data Entry Database


1
Guide to the CVS-EEP Data Entry Database
  • February 5, 2007
  • Michael Lee
  • CVS-EEP Data Entry Database Author
  • Written for version 2.0.4,
  • though broadly applicable to all versions.

2
Summary Slide
  • How it works
  • CVS-EEP Data Entry Database
  • Getting the Entry Database
  • Unzipping the Database
  • You're Ready to Start
  • Confirmation Messages
  • Who are you?
  • The Main Menu
  • Main Menu Planning
  • Main Menu Choose Level
  • Main Menu Data Entry
  • Plot Data
  • New 2.0.3 Picklists Selecting Multiple Items
  • Intro to Stem / Cover Forms
  • More tips
  • Continued on next slide...

3
Summary Slide (cont.)
  • Planted Woody Stems (level 1-2)
  • Natural Woody Stems
  • New 2.0.4 Faster Natural Stem Entry
  • Cover Data
  • New 2.0.4 Faster Cover Data Entry (level 5)
  • Sorting
  • New Species
  • Improved 2.0.4 Error Checking
  • Main Menu Extras
  • Main Menu Reports
  • New 2.0.4 Reports by Project
  • Options
  • New 2.0.4 Upgrade your old Entry Database
  • More Stuff

4
How it works
  • Field Work recorded onto paper datasheets
  • Paper datasheets are used to enter data into
    similar forms in the data entry database
  • Data Entry Database gets sent to CVS and/or EEP
    to have the contents included in the Central
    Archive Database

5
CVS-EEP Data Entry Database
  • What is it?
  • A Microsoft Access database
  • Based on VegBank (www.vegbank.org) data structure
  • Modified to fit our needs we can continue
    modification
  • It is a single file on your computer, with the
    extension .mdb. This file can be downloaded,
    copied as a backup, and sent to others so that
    they can see or use your data

6
CVS-EEP Data Entry Database
  • What does it do?
  • Menu that guides you through the process
  • Forms allow data entry efficiently no redundant
    keystroking quick lookups
  • Data validation ensures that problems are flagged
    and dealt with
  • Reports summarize the final data
  • Reports also are printed to provide a basis for
    Monitoring (VMD)
  • Quality Assurance, Advanced Features

7
Getting the Entry Database
  • It can be downloaded from the website
  • http//cvs.bio.unc.edu/
  • Check to make sure you have the newest version if
    someone requires a certain version.
  • The database is named with the version in it,
    i.e. version 2.0.4 is CVS_EEP_dataEntry_v204.mdb

8
Unzipping the Database
  • If you know how to unzip files, unzip the
    database and skip this slide, otherwise,
    continue...
  • The database file is zipped. This saves disk
    space and also provides a backup copy.
  • Unzip the file with WinZip if you have it ...
  • OR Unzip the file with Windows Zipped Folder
  • Double click the .zip file
  • Select the .mdb file within that folder
  • DO NOT DOUBLE CLICK the .mdb file
  • Copy the file, then paste it into a
    non-compressed folder (a folder without ".zip" at
    the end of the name)
  • Make sure the zipped folder or WinZip is closed

9
You're Ready to Start
  • Double Click the database file icon in Windows
    Explorer
  • This opens it in MS-Access
  • First, in Access 2003, you may get up to two
    messages
  • Do you want to open a file with Macros?
  • CLICK "OPEN"
  • Do you want to block unsafe expressions?
  • CLICK "NO" this doesn't apply in this lab

10
Confirmation Messages
  • Confirmation Messages are part of Access that
    asks you to be sure you want to edit data in
    certain ways.
  • These need to be turned off to use the database
  • The database can do that for you automatically,
    click "Yes, turn off confirmation messages" if
    prompted.
  • They will be turned back on after closing the
    database.
  • You can have it remember this preference.

11
Who are you?
  • The Entry Database keeps track of when records
    are added or updated, and by whom.
  • This may help to track down weird changes by
    administrators
  • Thus, you have to tell the system who you are
  • Select your name if it's on the list, or enter
    your initials and name (there are no passwords)
  • You can check the box to have it remember who you
    are.
  • Make sure the date and time are correct.

12
The Main Menu
  • The Tabs show the order in which steps should be
    taken
  • The Help boxes are by default turned on to the
    right.
  • Can be turned off with the "X" icon.
  • You can change who is logged in, view tips on
    using the database, hide the Main Menu, and quit
    the database

13
Main Menu Planning
  • All plot data is associated with a Project
  • You should receive a project code or number from
    EEP or CVS
  • You will probably need to add this project to the
    database (click "add a project")
  • If you want to calculate the required number of
    plots for your project based on its size, there
    is a link to calculate this
  • Go to the next tab

14
Main Menu Choose Level
  • There are 5 levels of plots.
  • The project director should specify the level
  • The level chosen will change the appearance of
    later forms and the Main Menu options
  • More information is available with the link at
    the bottom of the tab
  • Go to the next tab

15
Main Menu Data Entry
  • Plot Data
  • This is information about the whole plot, i.e.
    who sampled, its location, date sampled
  • Planted Woody Stems (Level 1 and 2)
  • Individual planted stems are recorded with
    location
  • Natural Woody Stems (if Level 2)
  • Stems tallied by size classes
  • Cover Data (for Levels 3 and higher)
  • Cover values estimated by species
  • Some options may be hidden depending on the plot
    level chosen.

16
Plot Data
  • You can make new plots
  • You must specify project, team, and plot, and CVS
    sampling level for all new plots
  • Or view/edit existing ones (choose from the
    picklist)
  • The Plot Form matches the Plot Data Sheets
    closely
  • Use the tab button on your keyboard to move
    between boxes (Use Ctrl-Tab out of sub-forms like
    Party and Place Names)
  • "Add Value" lists in Party, Place Name
  • Just start typing a new name in these boxes and
    it will be added to the database
  • Party Names can be typed "LastName, first" or
    "first lastName" (without quotes)

17
New 2.0.3 Picklists Selecting Multiple Items
  • For some picklists in the Plot Data form, you can
    select more than one option.
  • Soil Drainage, Plot Placement, Salinity,
    Topography, Hydrology, Homogeneity, Stand Size,
    Season, Physiognomy
  • Initially, double click in the picklist or select
    multiple.
  • Then in a pop-up white box, use ctrl on your
    keyboard and click any number of values.
  • Press Escape on your keyboard to cancel.
  • Press Enter, Tab, or click another field to save
    selected values.
  • The field will show multiple after you are
    finished entering, but if you double click that
    field again, it will show you which values are
    selected.

18
Intro to Stem / Cover Forms
  • Species picklists are "magic"
  • By this I mean that you can enter the first two
    letters of genus (configurable) and the first two
    letters of the species and the first 1 letter of
    variety/subspecies (or space if no var/ssp) and
    the list alters to show you all available species
    that match what you entered
  • Use CAPS to disable this, and enter an asterisk
    () if the list is not resetting and you want it
    to.
  • e.g. for the genus Carex, you can enter "Carex"
    instead of "carex" which would look for genus
    starting with "ca" and species with "re" and
    variety with "x".

19
More tips
  • Typically, use the tab button to move between
    fields on a form. Use shift tab to move
    backwards
  • Use Ctrl-Tab to get out of a subform, which is a
    box with more fields in it (Plot Data)
  • Use arrow keys on stems/cover forms to get around
    after doing some entry
  • Use the enter key on stems/cover to move to the
    beginning of the next line
  • Enter and arrow keys don't work in picklists
    because up and down and enter can be used to move
    around in the list

20
Planted Woody Stems (level 1-2)
  • There's a link directly from the Plot Data
  • Or you can link from the Main Menu (2nd tab)
  • You can add new stems on the blank bottom line
  • You can edit species and other information
  • Magic Species List
  • Species Lookup
  • You can edit plot header information (date)
  • Notes are available for uncertainty and internal
    comments
  • Ctrl-' (like the ditto mark " ) copies from the
    field above
  • Arrow keys work, as does "Enter" key
  • Can adjust order of plants with blue up/down
    buttons
  • Help is available. You have to turn it on,
    though
  • Enter and arrow keys don't work in picklists
    because up and down and enter can be used to move
    around in the list

21
Natural Woody Stems
  • Level 2 and higher. It isn't an option at level
    1.
  • Very similar in function to the Planted Woody
    Stems Form, but matches the Natural Woody Stems
    Form
  • Magic Species List, Species List Lookup, Arrow
    Keys, Help
  • Using Tab to move to the next field is helpful,
    and hit Enter on your keyboard to go to the
    beginning of the next line
  • "Sp." field for unknowns
  • Enter and arrow keys don't work in picklists
    because up and down and enter can be used to move
    around in the list

22
New 2.0.4 Faster Natural Stem Entry
  • Space bar moves to next field (easier than tab)
  • Often, there is just one size category, or the
    smaller categories are absent
  • To jump to a particular size
  • Press and hold ctrl, then enter the size of the
    stem class (lower bound, e.g. 30 or 45), then
    release ctrl
  • Or, press or , then the size, then or
  • If you enter a size less than 40cm, the default
    of 1 stem is filled in (you can change the number
    if not 1)
  • If you enter a size of 40cm or greater, that size
    is entered in the first box for stems at least
    40cm

23
Cover Data
  • Also known as "Herb Data"
  • For levels 3 and 4, you enter cover-by-strata,
    species, and cover for each module
  • For level 5, you enter cover-by-strata, species,
    and presence/cover values under module/corner
    headings.
  • "Auto-tab" is on, meaning that entering a cover
    value moves the cursor to the next box.
  • The Form attempts to figure out what you are
    doing and skips unneeded columns.
  • Use Enter to go to the beginning of the next
    line
  • Enter and arrow keys don't work in picklists
    because up and down and enter can be used to move
    around in the list

24
New 2.0.4 Faster Cover Data Entry (level 5)
  • Space bar moves to next field (easier than tab)
  • Often, you want to skip to the next module
  • Ctrl-Space or Ctrl-(right arrow) or Ctrl-tab
    move to next MODULE
  • Ctrl-(left arrow) or Ctrl-Shift-Tab move to
    previous MODULE

25
Sorting
  • To move a record in stem or cover entry, use the
    blue up and down arrows in the header section
  • This moves the current row up or down relative to
    the others
  • If you sort manually using access functions, you
    can restore the normal order by pressing the (A-Z
    sort) button next to the up and down arrows.

26
New Species
  • You can search for species in the cover and stem
    forms using the "Search for species" button.
  • Then you can search for a species by entering
    some part of the name and searching in the new
    form.
  • When you find the one you want, press "Get
    Species" at the bottom.
  • Press cancel if you don't find what you want, or
    add a new species with the button at the bottom.
    (You can also add new species from the Extras tab
    on the Main Menu.)

27
Improved 2.0.4 Error Checking
  • You can check a plot for errors after entering
    data (plot data form, cover form, stems forms) by
    pressing the "(Re)Check for Errors" button in the
    upper right
  • You can check all plots for errors by pressing
    the "Check For Errors" button on the Data Entry
    Tab of the Main Menu.

28
Main Menu Extras
  • The extras tab is used to view or add new data
    that isn't routine, such as party (people),
    reference, species, or projects.
  • Some of the data in the linked forms is "locked"
    meaning that these were already in the database
    when you got it and you can't edit the
    information there. Instead, add a new item in
    the bottom row of the form, or press the ""
    button at the bottom.

29
Main Menu Reports
  • Simple Reports exports directly to Excel as a new
    Excel file. This gives you all you will normally
    need for level 1 sampling.
  • Advanced Customizable Stats also available
  • Can be copied and pasted into a Word document and
    used in larger written reports
  • Resampling plots for monitoring (VMD)
  • Select plots to resample and print datasheets
  • Add these plots to the database as templates to
    fill out in VMD
  • Enter update info for VMD

30
New 2.0.4 Reports by Project
  • In earlier versions of this database, you could
    only get quick reports based on all plots.
  • Now, you can get a report based on a project, or
    whichever plots you like.
  • Start at the Main Menu, Reports Tab
  • Then select Customizable Statistics...
  • Then select plots you want in step 1
  • Then push the button in step 2b (skipping 2a)

31
Options
  • Messages (do you want a few questions that may
    help you enter data better?)
  • Error checking as you finish plots
  • Error checking can also be done on all plots by
    an administrator
  • Advanced Options (Database Admin)
  • Protect Page with Password
  • Configure "Magic" Species Picklists
  • Plot Deletions
  • Compact/Backup the database (automatically)

32
New 2.0.4 Upgrade your old Entry DB
  • You can upgrade your old CVS-EEP Entry Database
    by importing data into a new database (version
    2.0.4 or later)
  • Useful if you have data in an older format and
    want to use the new functionality
  • Start at the Main Menu Options Tab
  • Then press "Advanced Features"
  • Scroll down to "Import data into this db..."
  • Browse for the old file (put it in the same
    folder as the new one for ease of finding it)
  • This will DELETE everything in the new database
    and replace it with the data in your old database!

33
More Stuff
  • Use Alt-Down Arrow on your keyboard to see the
    contents of a picklist without using the mouse.
  • Just start typing in a picklist to zoom to a
    letter (i.e. a quadrangle starting with "R" is
    way down the list).
  • As soon as you see the triangle next to a field,
    the record is saved. Power outage wont erase
    it.
  • If you dont know the species name, filling
    DONTKNOW as the species name (using caps
    disabled magic picklist).
  • Someone will have to come back and look at this
    species again to try and fill in the name. If it
    is completely unknown, use the "Unknown" species
    name.
Write a Comment
User Comments (0)
About PowerShow.com