NIH Training Grant T32 Database A UW tool for grant applications

1
NIH Training Grant T32 DatabaseA UW tool for
grant applications

• Quick Guide to Entering Data Records
• This brief guide is intended to assist those who
  will add and update data for the MBTG program
  competitive grant application. Contact Kim Voss
  with questions/problems 262-9880, krvoss_at_wisc.edu

2
Opening the guide and database simultaneously

• You can open both the Guide (MS PowerPoint
  format) and the T32 database (MS IE browser
  application) in separate windows to make it
  convenient to refer to the help as needed.
• To run the programs in separate windows requires
  a simple setting in the tutorial presentation
  setup. The PowerPoint slides have hyperlinks that
  allow easy navigation from a table of contents to
  a desired example slide and back. The internal
  hyperlink feature requires running in Slide
  Show mode. To run a Slide Show in a window Open
  the presentation From the Slide Show menu bar
  select Set Up Show In the box under Show
  Type mark the Browsed by Individual option,
  then OK. The slide show should now run in a user
  sized window along side other programs.

3
Required Information

• The instructions assume the perspective of a
  faculty user going into the database to verify
  and add required information about him or
  herself.
• The following information from each trainer on
  the grant is required to generate the grant
  application tables
• Faculty Contact and Department/TG/Program
  affiliations
• Faculty Research/Expertise descriptor paragraph
  
• Faculty Grant Support
• Listing of all Pre Postdocs trained in past 10
  yrs
• For every Pre Postdoc UW dates, support if
  here, prior degree info, scores, current
  research, publications, current position if
  post-training

Go to navigation page
4
Navigation of Data SectionsClick links to jump
forward to sections

• 1 Title page
• 2 Required information
• 3 Contents / Navigation
• 4 Login
• 5 Select faculty user
• 6 Faculty detail -contact
• 7 Faculty detail -research
• 8 Faculty detail -depts,TG
• 9 Faculty detail - support
• 10 Faculty detail -predocs
• 11 Faculty detail -postdocs

• 12 Add a student
• 13 Add a student (contd)
• 14 Select a student
• 15 Student detail -contact
• 16 Student detail -undergrad
• 17 Student detail -research
• 18 Student detail -PI, programs
• 19 Student detail -publications
• 20 Note on relational database

5
LOGIN Screen - need a Wiscmail email acct. -
Use Internet Explorer or Safari Browser -
https//wiscinfo.doit.wisc.edu/t32database/login/i
ndex.asp
Return to navigation page
6
Access your (faculty) data records (e.g. Dave
Brow) Set 1. and 2. to bring up the list of
trainer names, then 3. select
Return to navigation page
7
Faculty data detail (Initial screen)

• Right side contact information fields
• Left Side links to faculty-specific records
  (add/update as needed)
• Research/Expertise
• Dept. affiliations
• TG affiliations
• Grad students (all)
• Post docs (all)
• Grant support

Return to navigation page
8
Add/update Faculty Research / Expertise

• Select the Research /Expertise link
• Enter a research summary phrase and paragraph
  (cut paste from other docs)
• Save Close
• If other records are to be updated, goto that
  record and enter information. All updates can be
  saved at session end.

Return to navigation page
9
Add / Update Departmental AffiliationsAdd /
Update Training Grant Program
Affiliations(both records are updated by the
same procedure)
Return to navigation page
10
Add /Update grant support information Actions
1) Add new grant, 2) Edit listed entry, 3) Make
inactive
Return to navigation page
11
Add / Update list of all grad students trained in
past 10yrs

• Select the Students link to bring up a list of
  students trained in the faculty (e.g. Brow) lab
• Add / Update the Start and End Dates for all
• Add students to the list using the search feature
• Enter a name
• Click search
• Click arrowhead to attach
• Student not found
• Save and Close
• then goto 12

Return to navigation page
12
Add / Update list of all postdocs trained in past
10yrs

• Select the Post Docs link to bring up a list of
  postdocs trained in the faculty (e.g. Brow) lab
• Add / Update the Start and End Dates for all
• Add postdocs to the list using the search feature
• Enter a name
• Click search
• Click arrowhead to attach
• Postdocs not found
• Save and Close
• then goto 12

Return to navigation page
13
Add a student or postdoc not in the database
Return to navigation page
14
(Contd) Add a student

• Complete name field and other if known
• Click Save User button
• These actions put the student in the database.
  To attach the student to a trainer go back to
  Faculty Detail and Add Student (Slide 10)

Return to navigation page
15
Add / Update information for each grad students
trained follow the same for postdocs

• Select the Students link to bring up a list of
  students trained in the faculty (e.g. Brow) lab
• Click on a student name to access
  student-specific records

Return to navigation page
16
Student Data Detail (Initial Screen) Must be
completed for every student in list!!

• Right side
• Contact information
• Support
• UW Degree recd
• Current position
• Left Side links to student-specific records
  (add/update as needed)
• Pre-PhD Training
• Research/Expertise
• PI (Advisor)
• TG affiliations
• Publications

Return to navigation page
17
Add / Update Student Pre-PhD Training 1)
Undergraduate degree, 2) Test scores
3. SAVE exit, or go to other detail windows
1. Undergrad Degree Click Add or Edit for
entry window
Return to navigation page
18
Add / Update Student Research
Thesis Research Enter text in boxes
Return to navigation page
19
Add /Verify Student PI Programs
Thesis Advisor (PI) Verify student is attached to
faculty thesis advisor
Program Training Grant Use Add-Search to
attach degree program and TG
Return to navigation page
20
Student Publications

• Note MBTG requires this information as a
  separate text file list - you do not need to
  enter it in the database
• The publication search only looks at an internal
  list of publications that is not current. The
  Add New Publication feature allows
  bibliographic information to be entered but since
  this information likely comes from a list and the
  output is a simple list, program administrators
  should evaluate the utility of this data field
  for their grant application or other purposes.

Return to navigation page
21
Relational Database

• The T32 database is relational - data records
  are put in and relationships or affiliations are
  made between selected records. For example, a
  faculty-department relation or a student-faculty
  relation, etc. Other records are automatically
  specific to one individual and cannot be linked
  to any other individual or entity. An example
  would be degree information or a research
  description. Once a relationship is made between
  individuals or programs there becomes multiple
  navigational paths to reach a given individual.
  This tutorial follows the path of a faculty
  trainer with graduate students and/or postdocs
  attached coming from the perspective that each
  faculty trainer on a program will be responsible
  for the relations assigned to him/her.
  Experienced users will recognize alternate paths
  to particular data records.