Nimms Capturing Manual
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Nimms Capturing Manual as PDF for free.
More details
- Words: 988
- Pages: 5
The National Injury Mortality Surveillance System (NIMSS)
DATA CAPTURING MANUAL
JANUARY 2007
MRC-UNISA Crime, Violence & Injury Lead Programme
NIMSS MANUAL FOR DATA ENTRY IN EXCEL Starting up the Excel Programme 1. 2. 3. 4.
Right click on the Excel icon on the desk top Right click on the word in the top tool bar in excel Click on and click on file called NIMSS DATA COLLECTION spread sheet will open up with the following columns: A- MORTUARY B- POLICE NO C- OFFICER COLLECTING D- PMNO E- PMDATE F- PHATHOLOGIST G- DATE INJURY H- TIME INJURY I- RACE J- SEX K- DATE DEATH L- TIME DEATH M- AGE IN YEARS N- AGE MONTHS O- MEDICAL TREATMENT P- PROVINCE INJ Q- OTHER SPECIFY (Name of other Province) R- SCENEINJURY S- OTHER SPECIFY (List other scene of injury) T- TOWN INJURY U- SUBURB INJURY V- NEARSAPS W- EXTERNAL CAUSE X- OTHER SPECIFY (List other external cause/s) Y- APPARENT MANNER Z- SAMPLE 01 AA- SAMPLE 02 AB- SAMPLE 03 AC- SAMPLE 04 AD- BLOOD ALCOHOL AE- EYE FLUID AF- OTHER SUBSTANCE
Start Capturing 1. PRESS and capture all data in capital letters 2. 1Now enter the data as it appears on the form ensuring you capture all the information. 3. REMEMBER TO SAVE REGULARLY! To save click on go to <Save as> in file name type in Mortuary name and year click on <save>
NOTES FOR CAPTURING A MORTUARY PINETOWN
B POLICENO 202/09/05
C OFFICERCOL SHELEMBE
D PMNO 800/05
1. Column A (Mortuary Name) should have the full name of the Mortuary REMEMBER TO PRESS; DO NOT USE ABREVIATIONS, Make sure the mortuary is spelt correctly each time 2. Column B (Police Number) must read as number/ month/ year (Keep format of cell as general for this column) Column B (Police Number) Months are captured from 01 (for January) to 12 (for December) Column C (Officer Collecting) and D(PMNO) Years are captured as for example 05 and not 2005 3. Column C (Officer Collecting) must have the officers full names; ensure that officers names are correctly spelled each time 4. Column D (PMNO) must read as number/ year (Keep format of cell as general for this column) E PMDATE 10-SEP-2005
F PATHOLOGIS SULIMEN
G DATEINJURY 08-SEP-2005
H TIME INJURY 15
I RACE B
J SEX M
K DATEDEATH 09-SEP-2005
L TIME DEATH 18
Column E; G and K (Date columns) 1. Capture as day/month/ year; Type name month out in full as above 2. Make sure date in (E) is later than Dates in (G) and (K) (as in above example) Column F (Pathologist) must have the Pathologist’s full names; ensure that pathologist’s names are correctly spelled each time Columns H and L (Time columns) 1. Time should be captured using 1 (for 1am in the morning) through to 23 (for 11pm in the evening) 2. Note that 12am or 24:00 is not captured as 24 but as 0 (for midnight) Column I and J 1. Column I can only have the letters B (black), C (coloured), W (white) or U (unknown) 2. Column J can only have the letters F (Female), M (male) or U (unknown) MAKE SURE NO OTHER LETTERS ARE USED IN THESE COLUMNS! NIMMS DATA CAPTURING MANUAL DECEMBER 2006
3
M AGEYEARS 30 0
N MONTHS 8
Column M and N(age) 1. When capturing age and a person is less than a year old put 0 in column M (age column) and the number of months in column N (months Column) as above O MEDICALTRE 1
P PROVINCEIN 3
Q OTHERSPECI
R SCENEINJUR 16
S OTHERSPECI
Columns O (Medical Treatment), P (Province), S (Scene of injury) 1. Make sure that the correct numbers are typed and that you stay in the correct range. 2. Medical treatment (O) can only be numbered 1 to 3; 3. Province (P) can only be numbers 1 to 11 and if 11 is used then the written response must also be typed in column (Q) 4. Scene of injury (R) can only be numbered 1 to 18 and if 17 is used then the written response must also be typed in column (S). T TOWNINJURY BARBERTON
U SUBURBORDI NELSPRUIT
V NEARSAPS BARBERTON
Columns T (Town of Injury), U (Suburb or District), V (Nearest SAPS) 1. Make sure places are spelt correctly 2. Please ensure that (Column V) the nearest police station is filled in W EXTERNALCA 2
X OTHERSPE
Y APPARENTMA 1
* COMPULSARY INFORMATION: Column W (External Cause), X and Y(Apparent Manner) THESE FIELDS MUST BE CAPTURED FOR ALL CASES! 1. EXTERNAL CAUSES (W) can only be numbered between 1 and 30 and if 29 is used then the written response must also be typed in column (X) (otherspec). 2. APPARENT MANNER (Y) can only be numbered between 1 and 4 (however, if body was stored and no PM was conducted at the mortuary: APPARENT MANNER = 6)
NIMMS DATA CAPTURING MANUAL DECEMBER 2006
4
Z SAMPLEST01 1
AA SAMPLEST02 2
AB SAMPLEST03 3
AC SAMPLEST04 4
Column Z; AA; AB; AC 1. 2. 3. 4.
Only 1 (none) is captured in column Z (SAMPLEST01) Only 2 (blood) is captured in column AA (SAMPLEST02) Only 3 (Tissue) captured in Column AB (SAMPLEST03) Only 4 (Other Fluid) captured in Column AC (SAMPLEST04) AD BLOODALCOH 1
AE EYEFLUIDAL
AF OTHERSUBST
Column AD 1. This information is to be captured if available 2. Column AD (BLOOD ALCOHOL) numbering should follow this example format: 1 for 0.01g/100ml (as captured in above example) 4 for 0.04g/100ml 10 for 0.10g/100ml 25 for 0.25g/ 100ml Column AE and AF 1. If available, capture eye fluid alcohol and other substances listed in column AE and AF. Send captured data (i.e. for Jan-Dec 2006) in Excel format to the relevant regional NIMSS coordinators by January of the following year (i.e. January 2007).
NIMMS DATA CAPTURING MANUAL DECEMBER 2006
5
DATA CAPTURING MANUAL
JANUARY 2007
MRC-UNISA Crime, Violence & Injury Lead Programme
NIMSS MANUAL FOR DATA ENTRY IN EXCEL Starting up the Excel Programme 1. 2. 3. 4.
Right click on the Excel icon on the desk top Right click on the word
Start Capturing 1. PRESS
NOTES FOR CAPTURING A MORTUARY PINETOWN
B POLICENO 202/09/05
C OFFICERCOL SHELEMBE
D PMNO 800/05
1. Column A (Mortuary Name) should have the full name of the Mortuary REMEMBER TO PRESS
F PATHOLOGIS SULIMEN
G DATEINJURY 08-SEP-2005
H TIME INJURY 15
I RACE B
J SEX M
K DATEDEATH 09-SEP-2005
L TIME DEATH 18
Column E; G and K (Date columns) 1. Capture as day/month/ year; Type name month out in full as above 2. Make sure date in (E) is later than Dates in (G) and (K) (as in above example) Column F (Pathologist) must have the Pathologist’s full names; ensure that pathologist’s names are correctly spelled each time Columns H and L (Time columns) 1. Time should be captured using 1 (for 1am in the morning) through to 23 (for 11pm in the evening) 2. Note that 12am or 24:00 is not captured as 24 but as 0 (for midnight) Column I and J 1. Column I can only have the letters B (black), C (coloured), W (white) or U (unknown) 2. Column J can only have the letters F (Female), M (male) or U (unknown) MAKE SURE NO OTHER LETTERS ARE USED IN THESE COLUMNS! NIMMS DATA CAPTURING MANUAL DECEMBER 2006
3
M AGEYEARS 30 0
N MONTHS 8
Column M and N(age) 1. When capturing age and a person is less than a year old put 0 in column M (age column) and the number of months in column N (months Column) as above O MEDICALTRE 1
P PROVINCEIN 3
Q OTHERSPECI
R SCENEINJUR 16
S OTHERSPECI
Columns O (Medical Treatment), P (Province), S (Scene of injury) 1. Make sure that the correct numbers are typed and that you stay in the correct range. 2. Medical treatment (O) can only be numbered 1 to 3; 3. Province (P) can only be numbers 1 to 11 and if 11 is used then the written response must also be typed in column (Q) 4. Scene of injury (R) can only be numbered 1 to 18 and if 17 is used then the written response must also be typed in column (S). T TOWNINJURY BARBERTON
U SUBURBORDI NELSPRUIT
V NEARSAPS BARBERTON
Columns T (Town of Injury), U (Suburb or District), V (Nearest SAPS) 1. Make sure places are spelt correctly 2. Please ensure that (Column V) the nearest police station is filled in W EXTERNALCA 2
X OTHERSPE
Y APPARENTMA 1
* COMPULSARY INFORMATION: Column W (External Cause), X and Y(Apparent Manner) THESE FIELDS MUST BE CAPTURED FOR ALL CASES! 1. EXTERNAL CAUSES (W) can only be numbered between 1 and 30 and if 29 is used then the written response must also be typed in column (X) (otherspec). 2. APPARENT MANNER (Y) can only be numbered between 1 and 4 (however, if body was stored and no PM was conducted at the mortuary: APPARENT MANNER = 6)
NIMMS DATA CAPTURING MANUAL DECEMBER 2006
4
Z SAMPLEST01 1
AA SAMPLEST02 2
AB SAMPLEST03 3
AC SAMPLEST04 4
Column Z; AA; AB; AC 1. 2. 3. 4.
Only 1 (none) is captured in column Z (SAMPLEST01) Only 2 (blood) is captured in column AA (SAMPLEST02) Only 3 (Tissue) captured in Column AB (SAMPLEST03) Only 4 (Other Fluid) captured in Column AC (SAMPLEST04) AD BLOODALCOH 1
AE EYEFLUIDAL
AF OTHERSUBST
Column AD 1. This information is to be captured if available 2. Column AD (BLOOD ALCOHOL) numbering should follow this example format: 1 for 0.01g/100ml (as captured in above example) 4 for 0.04g/100ml 10 for 0.10g/100ml 25 for 0.25g/ 100ml Column AE and AF 1. If available, capture eye fluid alcohol and other substances listed in column AE and AF. Send captured data (i.e. for Jan-Dec 2006) in Excel format to the relevant regional NIMSS coordinators by January of the following year (i.e. January 2007).
NIMMS DATA CAPTURING MANUAL DECEMBER 2006
5
Related Documents
Nimms Capturing Manual
May 2020 21
Capturing Input
November 2019 35
Capturing Tacit Knowledge
June 2020 11
Capturing The Research Advantage
April 2020 31
Capturing The Enterprise Imagination
May 2020 23
