Is the average number of missed days higher among those who answered yes to asthma than the overall average?

What is the overall purpose, or aim, of doing this work?
January 7, 2019
Address each component of the SOAP note as noted in the written guide with relevant data.
January 7, 2019

An informatician conducts data assessments of public health information. They are responsible for organizing, synthesizing, and interpreting data and transforming it into pertinent information that may be used to identify implications for public health program planning and development.

In this assignment, you will continue to use your pre-intervention asthma surveillance data set from the CDC in the Excel spreadsheet to analyze your database from a summary perspective. You will calculate various statistical means of the asthma data in your Excel spreadsheet using Pivot Table reports. You will then answer the following questions in a 3–4-page paper, and embed your pivot tables in your report to explain the summary results.

What statistical mean results do your Pivot Tables demonstrate about this grade school population of students?

Data Means Statistical Questions

  • What was the most frequent number of missed days?
  • What is the mean (average) number of missed days because of asthmatic conditions?
  • Which school had the highest average of missed days? 
  • Was the school with the highest average of missed days for males the same as the school with the highest average of missed days for females?
  • Is the average number of missed days higher among those who answered yes to asthma than the overall average?
  • What is the average age of the student population?

In a summary, explain how an informatician can use an outcome measurement of missed school days to monitor and evaluate population health; in this situation, asthma cases in elementary school children. Refer to the following article by Moonie, Sterling, Figgs, and Castro (2006):

Moonie, S. A., Sterling, D. A., Figgs, L., & Castro, M. (2006). Asthma status and severity affects missed school days. The Journal of School Health, 76(1), 18–24. Retrieved from

http://search.proquest.com.southuniversity.libproxy.edmc.edu/docview/215674744?accountid=87314

Submission Details:

  • Give reasons and examples in support of your responses. Cite all sources using APA format.
  • Submit a 3–4-page report in a Microsoft Word document to the Submissions Area  by the due date assigned.
  • Name your document SU_PHE6203_W3_A2_LastName_FirstInitial.doc.

Asthma Data

SchoolNumStudentIDGenderZipDOBAsthmaRADBronchitisWheezingMedicationWMonthMissDays
A1Male122071/29/0510011910
A2Female1221010/28/08111111011
A3Male122066/23/0511001107
A4Male121832/1/0610111914
A5Male121104/3/051011118
A6Male120473/13/0510100910
A7Male122027/21/0410100911
A8Male122099/12/06111111010
A9Male122099/5/08110111012
A10Male1220812/18/0511111913
A11Female1220811/30/0511111912
A12Female1220311/8/0511011614
A13Male1220310/29/0611100710
A14Male122039/23/0511100912
A15Male1220512/19/04111111013
A16Male122051/17/0311011810
A17Female122055/17/05110111014
A18Female122058/12/05110111111
A19Male1221112/13/0611011915
A20Female122119/5/081101199
A21Female122113/23/0510111312
A22Female122118/15/0810110410
A23Male121891/26/04101011012
A24Female1218910/19/0311101911
A25Female122045/26/0810111109
A26Male122045/17/06100111113
A27Female121893/9/0411011510
A28Female122054/8/041100129
A29Female122022/7/0311101911
A30Female122109/24/050100146
A31Female122104/16/0401000117
A32Female122106/19/05000001
A33Male122106/19/05000002
A34Male122101/25/050010079
A35Male122109/14/050010097
A36Male122105/22/0400100108
A37Male1221010/11/0500100107
A38Male1221011/18/030010055
A39Male122107/12/040100049
A40Female122106/19/050100026
A41Female122109/18/060100017
A42Female1204712/18/050100068
A43Female1204711/28/050010079
A44Female1204710/21/0500100210
A45Female120477/28/050010037
A46Female120479/28/050010048
A47Male120474/10/030100059
A48Male120473/21/060100098
A49Male120476/12/0401000810
A50Male120475/13/050010026
A51Male120473/18/06000003
A52Male120477/25/05000001
A53Male120478/27/06000002
A54Female120472/18/06000001
A55Male121833/30/05000002
A56Male1218310/27/08000001
A57Male121838/10/04000002
A58Male121839/13/04000003
A59Male121834/23/08000001
A60Female121839/16/050001037
A61Female121836/17/050001068
A62Female121832/14/050001019
A63Female121898/15/0400010210
A64Female121892/4/060001089
A65Female121893/23/08000001
A66Female121896/21/06000002
A67Female1218912/16/03000001
A68Male121898/24/050001078
A69Male121893/26/040001049
A70Male121894/18/08000001
A71Male121895/16/05000002
A72Male121892/28/03000001
A73Male122046/13/050001058
A74Male122044/13/050001097
A75Male122048/27/040001049
A76Male1220410/11/03000002
A77Male1220411/21/05000001
A78Female1220412/15/08000001
A79Female122043/12/06000002
A80Female122046/28/05000001
A81Female122047/21/08000002
A82Female122114/29/05000001
A83Female1221110/10/06000002
A84Female122119/23/05000003
A85Female122119/28/04000004
A86Female122113/29/08000001
A87Female122115/16/04000001
A88Female122118/27/08000001
A89Male122119/15/05000002
A90Male122115/17/05000001
A91Male122116/19/03000002
A92Male122113/28/05000001
A93Male1221110/5/06000002
A94Male1221112/1/08000003
A95Male1221111/3/05000001
A96Male1221110/1/05000002
A97Male122058/1/05000003
A98Male122057/6/05000002
A99Male122058/5/04000002
A100Male122059/6/06000002
A101Male122056/22/05000004
A102Male122053/22/03000001
A103Male122059/3/08000000
A104Female1220510/6/04000000
A105Female1220512/8/05000000
A106Female1220511/6/05000000
A107Female122055/14/05000001
A108Female122056/3/08000002
A109Female122052/13/04000001
A110Female122053/15/03000002
A111Female122056/25/05000001
A112Female122047/16/05000001
A113Female122043/13/05000002
A114Female122048/30/05000002
A115Female122047/14/08000003
A116Female122049/19/06000002
A117Female1220410/6/05000001
A118Female1220412/25/05000001
A119Female122043/14/06000001
A120Female122049/7/04000002
A121Male122048/1/08000002
A122Male122045/25/03000001
A123Male122043/21/06000002
A124Male122041/11/05000003
A125Male122041/2/05000001
A126Female122032/24/06000001
A127Female122033/15/04000001
A128Female122032/7/08000004
A129Female122039/28/03000002
A130Female122036/29/08000002
A131Male122033/29/06000001
A132Male122036/19/05000001
A133Male122038/24/05000003
A134Male122036/30/04000004
A135Male122039/9/05000001
A136Male122038/8/08000002
A137Male122036/5/05000001
A138Male122033/13/08000004
A139Male122038/1/03000002
A140Male1220310/21/05000002
A141Female1220611/5/06000001
A142Female122065/12/03000004
A143Female122063/24/05000001
A144Female122066/21/06000002
A145Female122063/3/05000004
A146Female122069/4/05000003
A147Female122067/12/04000003
A148Female122068/2/08000004
A149Female122066/14/06000002
A150Female122063/12/05000004
A151Female122068/1/03000002
A152Female122067/14/04000005
A153Female122063/17/06000003
A154Female122024/13/05000002
A155Female122023/14/05000001
A156Female122027/14/06000004
A157Female122028/12/05000001
A158Female122022/12/06000001
A159Male122021/14/04000001
A160Male122023/15/04000002
A161Male122022/14/08000004
A162Male122079/25/03000002
A163Male122076/4/06000003
A164Male122073/12/05000005
A165Male122077/12/04000002
A166Male122073/9/06000004
A167Female122076/15/05000002
A168Female1220712/4/06000002
A169Female122072/14/08000001
A170Female122073/6/03000002
A171Female122077/8/05000001
A172Female122075/8/05000001
A173Male1220810/19/05000003
A174Male1220812/18/08000001
A175Male122083/25/03000002
A176Male122084/18/06000004
A177Male1220811/15/06000002
A178Male122089/18/05000002
A179Female122088/16/08000003
A180Female122086/28/06000002
A181Female1220810/13/04000002
A182Female1220812/10/03000004
A183Female122093/5/08000002
A184Female122097/15/06000002
A185Male122098/6/04000002
A186Male122091/19/05000001
A187Male1220911/28/08000001
A188Male122096/3/05000001
A189Male1220912/1/06000001
A190Male122095/3/05000001
A191Male122103/13/05000001
A192Male122107/2/04000001
A193Male122106/12/06000001
A194Female122105/5/08000002
A195Female1221012/13/05000001
A196Female1221011/30/08000002
B197Female1208411/8/0511101911
B198Male1208410/25/06111011013
B199Female1208410/23/0510111914
B200Female123032/1/04111111015
B201Female123037/11/0311111812
B202Female123036/17/05110111113
B203Female123038/15/05110111014
B204Female1215911/13/0610011912
B205Male121596/5/0511011912
B206Male121594/5/05101001010
B207Male121598/11/08101001210
B208Male120541/30/0410110211
B209Male1205410/14/031011199
B210Male120548/26/08111111014
B211Female1205412/17/0611011912
B212Female121863/19/0411010110
B213Female121864/18/081101139
B214Male1218612/7/0611010913
B215Male121863/2/05110101011
B216Male1218610/16/04100101014
B217Male1200910/19/0510100612
B218Male120096/19/05111011013
B219Male120091/25/05111011111
B220Female120099/14/0511101912
B221Female120095/2/04111111011
B222Female1208410/11/050110029
B223Female120841/18/03000001
B224Female120847/12/040010058
B225Female120846/19/050010077
B226Female120841/18/060010199
B227Female1208412/11/0500000108
B228Female120841/28/05000101210
B229Male1208410/20/080100087
B230Male120847/8/050100068
B231Male120845/28/050100036
B232Male120844/19/030100098
B233Male120843/2/060100057
B234Male120846/12/030001016
B235Male1208411/13/0500010107
B236Male120849/18/0600010129
B237Male120847/25/0600010118
B238Male120848/27/050100038
B239Female120849/18/060100029
B240Female120843/3/050100068
B241Female1208410/7/080000092
B242Female120848/20/0400100106
B243Female123039/1/040010076
B244Female123034/3/0800100117
B245Female1230310/16/050010018
B246Female123036/27/050010036
B247Female123032/14/040000082
B248Female123038/25/040001047
B249Female1230311/4/060001057
B250Female123033/3/080001046
B251Female123036/11/060001099
B252Female1230312/26/0300010105
B253Male123038/24/050001088
B254Male123033/6/04000001
B255Male1230312/18/08000001
B256Male1230310/16/05000002
B257Male123034/28/03000002
B258Male123036/23/05000001
B259Male123038/13/05000002
B260Male123039/27/04000001
B261Male1230311/11/03000002
B262Male1230311/1/05000001
B263Female1230312/5/08000002
B264Female123036/12/06000001
B265Female123038/28/05000002
B266Female1230310/21/08000001
B267Female123037/29/05000001
B268Female1230310/19/08000003
B269Female1230311/23/05000004
B270Female123031/28/04000005
B271Male123032/2/08000004
B272Male123032/16/04000002
B273Male123032/27/08000002
B274Male121595/15/05000002
B275Male1215911/17/05000001
B276Male121591/19/03000003
B277Male121597/28/05000001
B278Male1215912/5/06000003
B279Male121592/1/08000001
B280Male121596/3/05000003
B281Male121594/1/05000001
B282Male121593/1/05000002
B283Male121598/6/05000002
B284Male121593/5/04000002
B285Male121595/6/06000001
B286Male1215911/22/05000004
B287Male121597/22/03000002
B288Male121599/13/08000000
B289Female1215910/26/04000002
B290Female1215912/18/05000001
B291Female121591/6/05000001
B292Female121593/14/05000002
B293Female121594/3/08000001
B294Female121592/13/04000001
B295Female121593/15/03000002
B296Female121596/25/05000003
B297Female121597/16/05000002
B298Female121593/13/05000003
B299Female121598/30/05000004
B300Female121597/14/08000002
B301Female121599/19/06000004
B302Female1215910/6/05000002
B303Female1215912/25/05000002
B304Female121593/14/06000002
B305Female121599/7/04000002
B306Female121598/1/08000002
B307Female121595/25/03000001
B308Male121593/21/06000001
B309Male121591/11/05000001
B310Male121591/2/05000003
B311Male120542/24/06000001
B312Male120543/15/04000002
B313Male120542/7/08000001
B314Male120549/28/03000002
B315Male120546/29/08000004
B316Male120543/29/06000002
B317Male120546/19/05000001
B318Male120548/24/05000003
B319Male120546/30/04000004
B320Male120549/9/05000000
B321Male120548/8/08000001
B322Male120546/5/05000001
B323Male120543/13/08000002
B324Male120548/1/04000001
B325Male120541/21/05000004
B326Male1205411/5/08000001
B327Female120544/12/03000002
B328Female120543/14/05000003
B329Female1205411/21/06000001
B330Female1205410/3/05000002
B331Female1205412/4/05000004
B332Female120549/12/04000001
B333Female1205412/2/08000002
B334Female120549/24/06000004
B335Female120542/12/05000001
B336Female120543/1/03000002
B337Female120547/4/04000001
B338Female121868/7/06000002
B339Female1218612/13/05000003
B340Female121868/14/05000002
B341Female1218610/14/06000002
B342Female121863/2/05000001
B343Female121862/22/06000001
B344Female121861/4/04000001
B345Female121863/5/04000001
B346Female121865/14/08000004
B347Female121861/2/03000001
B348Female121869/4/06000001
B349Female121867/12/05000002
B350Female121868/11/04000001
B351Male1218611/9/06000002
B352Male121861/15/05000001
B353Male121863/4/06000002
B354Male121862/24/08000002
B355Male121865/6/03000001
B356Male121864/8/05000003
B357Male121865/8/05000002
B358Male121864/19/05000002
B359Male1218611/18/08000001
B360Male121868/25/03000001
B361Male121864/18/06000001
B362Male121867/15/06000001
B363Male121866/18/05000002
B364Male121865/16/08000001
B365Female121866/28/06000001
B366Female121869/13/04000002
B367Female1218610/10/03000002
B368Female1218612/5/08000004
B369Female121867/5/06000001
B370Female121868/16/04000002
B371Female121862/8/05000001
B372Male121861/29/06000004
B373Male121863/23/05000004
B374Male1218612/19/04000002
B375Male121864/17/03000004
B376Male120095/17/05000003
B377Male120097/12/05000002
B378Male120096/13/06000004
B379Male120099/5/08000001
B380Male120098/23/05000002
B381Male1200911/15/08000001
B382Male1200910/26/04000001
B383Male120093/19/03000001
B384Male120094/26/08000004
B385Male120091/17/06000002
B386Male120092/9/04000003
B387Female120095/8/04000005
B388Female1200912/7/03000001
B389Female120098/24/05000002
B390Female120097/16/04000004
B391Female120099/19/05000002
B392Female1200911/19/05000001
B393Female1200910/25/05000002
B394Female120096/14/05000004
B395Female1200912/22/04000001
B396Female120093/11/05000002
B397Female1200910/18/03000001
B398Female120094/12/04000004
B399Male120092/19/05000002
B400Male120091/18/06000001
B401Male120099/18/05000001
C402Male120777/28/0511101913
C403Female120776/21/05111011012
C404Female120675/28/0511100911
C405Male120678/28/05101101110
C406Male121587/10/0311010912
C407Male1215811/21/06110101011
C408Female1215810/12/04100111212
C409Female121583/13/0511111914
C410Female1214312/18/0611111812
C411Female121432/25/0510111913
C412Male121431/27/06111101015
C413Male121434/18/0610110214
C414Male121439/30/0511010712
C415Female1204612/27/0810100910
C416Female120469/10/0411100109
C417Female120467/13/0411000614
C418Female1204611/23/0811011911
C419Male120466/16/05110111012
C420Male1204610/17/0511011911
C421Male120465/14/0511111415
C422Male120464/15/0410111914
C423Female120778/4/0601101213
C424Female120777/23/0800101311
C425Female120773/21/0600100712
C426Female1207711/16/0300100814
C427Female1207710/24/050000091
C428Female120774/26/0400000101
C429Female1207712/18/0801000116
C430Female120779/16/0501000127
C431Female120776/15/050100058
C432Female120773/13/050000076
C433Female120772/13/050010019
C434Male120771/27/040010098
C435Male120778/11/030100087
C436Male120777/21/0501000106
C437Male120771/15/0800000122
C438Male120775/12/060000033
C439Male120774/28/050100067
C440Male120773/21/0800100910
C441Male120776/29/05000001
C442Male1207711/10/060001016
C443Male120777/23/050001028
C444Female120778/28/040001046
C445Female1207712/29/0800000119
C446Female120779/16/040001067
C447Female1207710/27/080001088
C448Female120774/15/050001029
C449Female120677/17/050001038
C450Female120671/19/030001056
C451Female120672/28/05000001
C452Female120675/5/06000002
C453Female1206711/1/08000001
C454Male1206712/3/05000001
C455Male120676/1/05000001
C456Male120673/1/05000001
C457Male120678/6/05000001
C458Male120675/5/04000001
C459Male120676/6/06000001
C460Male120671/22/05000002
C461Male1206710/22/03000002
C462Male120678/3/08000002
C463Male1206712/6/04000003
C464Female120676/8/05000002
C465Female120672/6/05000002
C466Female120673/14/05000001
C467Female120677/3/08000001
C468Female120676/13/04000004
C469Female1206712/15/03000003
C470Female1206711/25/05000004
C471Female120679/16/05000001
C472Female120672/13/05000002
C473Female120677/30/05000004
C474Male120675/14/08000003
C475Male120674/19/06000001
C476Male120671/6/05000004
C477Male1206712/25/05000002
C478Male1206711/14/06000001
C479Male121587/7/04000004
C480Male121586/1/08000002
C481Male121585/25/03000001
C482Male121589/21/06000002
C483Male1215810/11/05000001
C484Female1215812/2/05000001
C485Female121588/24/06000004
C486Female121587/15/04000000
C487Female121583/7/08000002
C488Female121584/28/03000004
C489Female121588/29/08000001
C490Female121585/29/06000002
C491Female121586/19/05000001
C492Female121584/24/05000002
C493Female121587/30/04000001
C494Male121588/9/05000002
C495Male121581/8/08000001
C496Male121582/5/05000002
C497Male1215810/13/08000004
C498Male121585/1/03000001
C499Male121586/21/05000001
C500Male121589/5/06000001
C501Male121583/12/03000002
C502Male121587/24/05000002
C503Male121585/21/06000002
C504Female121589/3/05000003
C505Female121581/4/05000004
C506Female121588/12/04000002
C507Female121584/2/08000001
C508Female121589/14/06000003
C509Male121586/12/05000002
C510Male121584/1/03000001
C511Male121586/14/04000002
C512Male121582/17/06000004
C513Male121438/13/05000001
C514Male1214310/14/05000002
C515Male1214311/14/06000003
C516Male1214312/12/05000002
C517Male121433/12/06000001
C518Male1214311/14/04000004
C519Male121436/15/04000002
C520Male121437/14/08000001
C521Male1214310/25/03000002
C522Male121434/4/06000003
C523Male121431/12/05000001
C524Female121431/12/04000002
C525Female121438/9/06000004
C526Female121433/15/05000002
C527Female121432/4/06000003
C528Female121435/14/08000004
C529Female121435/6/03000002
C530Female121439/8/05000003
C531Female121439/8/05000004
C532Female121432/19/05000001
C533Female121433/18/08000002
C534Female121435/25/03000005
C535Female121431/18/06000002
C536Female121436/15/06000003
C537Female121437/18/05000004
C538Female121436/16/08000002
C539Female121438/28/06000003
C540Female121438/13/04000001
C541Female121432/10/03000002
C542Male121437/5/08000004
C543Male121437/15/06000001
C544Male121431/6/04000002
C545Male121436/19/05000002
C546Male1214311/2/08000001
C547Male121436/30/05000005
C548Male1214312/19/06000002
C549Male121435/30/05000001
C550Female121433/3/05000004
C551Female121437/21/04000002
C552Female120466/22/06000001
C553Female120467/5/08000003
C554Female1204612/3/05000001
C555Female120461/30/08000002
C556Female120462/8/05000001
C557Female1204610/5/06000004
C558Female1204612/23/05000002
C559Female120464/1/04000001
C560Male120467/16/03000002
C561Male120466/12/05000002
C562Male120469/15/05000004
C563Male1204611/30/06000002
C564Male120464/5/05000003
C565Male120467/5/05000001
C566Male120468/29/08000002
C567Male120468/30/04000004
C568Male1204611/14/03000001
C569Male120468/26/08000002
C570Male1204612/17/06000003
C571Male120463/19/08000004
C572Male120464/18/04000001
C573Male1204612/7/05000002
C574Male120463/2/06000003
C575Male1204611/16/04000002
C576Male1204610/19/04000001
C577Male120467/19/05000004
C578Male120461/25/03000002
C579Male120469/14/03000002
C580Female120465/2/05000002
C581Female120465/11/05000004
C582Female120467/18/03000000
C583Female120465/12/04000003
C584Female120466/19/08000001
C585Female1204611/18/06000002
C586Female1204612/11/05000001
C587Female120468/28/05000002
C588Female1204612/20/08000003
C589Female120466/8/05000001
C590Female120465/28/05000002
C591Female120468/19/03000002
C592Female120467/2/06000001
C593Female120466/12/04000002
C594Female120461/13/05000003
C595Female120462/18/06000001
C596Female120467/25/08000001
C597Female120463/27/05000001
C598Female1204610/18/06000002
C599Female120467/3/05000001
C600Male120462/7/08000002
C601Male120463/20/04000001
C602Male1204610/1/04000002
C603Male120468/3/08000001
C604Male1204610/16/05000002
C605Male120462/27/05000003
C606Male1204610/14/04000002
C607Male120468/25/05000001
C608Male1204611/4/05000001
C609Male120464/3/08000001
D610Male120596/11/0311101911
D611Female1205912/26/03111011012
D612Female121938/24/0511001911
D613Female121933/6/04101101014
D614Male1219312/18/08101101113
D615Male1200710/16/0510101810
D616Male120234/28/0311010912
D617Male120236/23/0511000213
D618Female120238/13/0511110614
D619Female121479/27/0410111911
D620Female1212011/11/03101111012
D621Male1212011/1/0511010914
D622Male1246912/5/08110101013
D623Female124696/12/0611010710
D624Female120558/28/0511111915
D625Male1205510/21/0811111915
D626Male120597/29/0501000110
D627Male1205910/19/080100039
D628Male1205911/23/050010048
D629Male120591/28/040010057
D630Male120592/2/0800100118
D631Male120592/16/0401100128
D632Male120592/27/080100099
D633Male120595/15/0501000107
D634Male1205911/17/050100068
D635Male120591/19/030010028
D636Female120597/28/05000001
D637Female1205912/5/060001022
D638Female120592/1/080001087
D639Female120596/3/050001096
D640Female120594/1/0500010108
D641Female120593/1/0500010117
D642Female120598/6/050001076
D643Female121933/5/04000108
D644Female121935/6/06000001
D645Female1219311/22/05000001
D646Male121937/22/03000001
D647Male121939/13/08000002
D648Male1219310/26/04000001
D649Male1219312/18/05000002
D650Male121931/6/05000001
D651Male121933/14/05000002
D652Male121934/3/08000003
D653Male121932/13/04000001
D654Male121933/15/03000002
D655Male121936/25/05000004
D656Female121937/16/05000001
D657Female121933/13/05000002
D658Female121938/30/05000002
D659Female121937/14/08000001
D660Female121939/19/06000001
D661Female1219310/6/05000002
D662Female1219312/25/05000001
D663Female121933/14/06000002
D664Female121939/7/04000001
D665Female121938/1/08000004
D666Female121935/25/03000002
D667Female121933/21/06000001
D668Female121931/11/05000003
D669Female121931/2/05000002
D670Male120072/24/06000001
D671Male120073/15/04000002
D672Male120072/7/08000001
D673Male120079/28/03000004
D674Female120076/29/08000002
D675Female120073/29/06000001
D676Female120076/19/05000002
D677Female120078/24/05000001
D678Female120079/30/04000002
D679Female120079/9/05000001
D680Female120078/8/08000002
D681Male120076/5/05000002
D682Male120077/13/08000002
D683Male120238/1/04000002
D684Male120235/21/05000001
D685Male1202311/5/08000001
D686Male120234/12/03000001
D687Male120233/14/05000003
D688Female1202311/21/06000001
D689Female120231/3/05000001
D690Female120231/4/05000002
D691Female120239/12/04000001
D692Female1202312/2/08000001
D693Female1202312/24/06000001
D694Female120232/12/05000001
D695Male120233/1/03000001
D696Male1202310/4/04000002
D697Male120238/7/06000002
D698Male1202312/13/05000002
D699Male120238/14/05000001
D700Male1202310/14/06000002
D701Male120233/2/05000001
D702Female120232/22/06000001
D703Female120231/4/04000002
D704Female120233/5/04000001
D705Female120235/14/08000002
D706Female121471/2/03000001
D707Female121479/4/06000002
D708Female121477/12/05000001
D709Male121478/11/04000002
D710Male1214711/9/06000002
D711Male121471/15/05000001
D712Male121473/4/06000002
D713Male121472/24/08000001
D714Male121475/6/03000002
D715Male121474/8/05000003
D716Male121475/8/05000002
D717Male121474/19/05000001
D718Male1214711/18/08000002
D719Female121478/25/03000003
D720Female121474/18/06000001
D721Female121477/15/06000001
D722Female121476/18/05000002
D723Female121475/16/08000001
D724Female121476/28/06000004
D725Female121479/13/04000001
D726Female121201/10/03000002
D727Female1212012/5/08000001
D728Female121207/5/06000002
D729Female121208/16/04000001
D730Female1212010/18/03000002
D731Female121204/12/04000001
D732Male1212011/19/05000002
D733Male121201/18/06000001
D734Male121209/18/05000002
D735Male121207/28/05000001
D736Male121206/21/05000002
D737Male121205/28/05000001
D738Male121206/28/05000001
D739Male121207/10/03000001
D740Male1212011/21/06000001
D741Male1212010/12/04000002
D742Female121203/13/05000002
D743Female1212012/18/06000002
D744Female121202/25/05000003
D745Female121201/27/06000002
D746Female120554/18/06000001
D747Female120559/30/05000002
D748Female1205512/27/08000001
D749Female120551/10/04000002
D750Female120557/13/04000001
D751Female1205511/23/08000002
D752Male120556/16/05000001
D753Male1205510/7/05000004
D754Male120551/14/05000002
D755Male120553/15/04000001
D756Male1205511/4/06000002
D757Male120556/23/08000001
D758Male120553/21/06000001
D759Male1205511/16/03000001
D760Male120559/24/05000001
D761Male120554/26/04000002
D762Female1205512/18/08000001
D763Female120559/16/05000003
D764Female120555/15/05000002
D765Female120553/13/05000002
D766Female120552/13/05000002
D767Female120551/27/04000003
D768Female120558/11/03000002
D769Female124696/21/05000004
D770Female124691/15/08000002
D771Female124698/12/06000001
D772Female124694/28/05000003
D773Male124693/21/08000001
D774Male124697/29/05000001
D775Male1246911/10/06000002
D776Male124697/23/05000001
D777Male124698/28/04000002
D778Male1246912/29/08000004
D779Male124699/16/04000002
D780Male1246910/27/08000001
D781Male124694/15/05000001
D782Male124697/17/05000002
D783Female124691/19/03000003
D784Female124692/28/05000002
D785Female1246910/5/06000002
D786Female1246911/21/08000001
D787Female1246912/30/05000002
D788Female124696/10/05000001
D789Female124692/1/05000001
D790Female124699/6/05000002
D791Female124695/25/04000002
D792Female124696/26/06000003
D793Female1246911/22/05000002
D794Female1246910/2/03000002
D795Female124698/30/08000003
D796Female1246912/16/04000002
D797Male124695/8/05000002
D798Male124698/6/05000001
D799Male124693/14/05000004
D800Male124696/3/08000002

Asthma DD

Asthma Study Data Definitions:
Field NameField Name Data Definitions
SchoolNumSchool ID representing School District Number SchoolNum A = School District Number 123, SchoolNum B = School District Number 234, SchoolNum C = School District Number 345, SchoolNum D = School District Number 456
StudentIDUnique identification number for each patient
GenderMale, Female
ZipFive-digit zip code
DOBMM/DD/YYY
Asthma1 = yes, student has asthma, 0 = no, student does not have asthma
RAD1 = yes, student has Reactive Airway Disease, 0 = no, student does not have Reactive Airway Disease
Bronchitis1 = yes, student has had Bronchitis, 0 = no, student has not had Bronchitis
Wheezing1 = yes, student has had Wheezing, 0 = no, student has not had Wheezing
Medication1 = yes, student is taking prescribed asthma medications, 0 = no, student does not take any prescribed asthma medications
WMonthNumber of days student has missed in the last month of school
MissDaysTotal number of days student has missed in the school year

Sheet3

 

"Are you looking for this answer? We can Help click Order Now"

UK BEST WRITING