<?xml version="1.0" encoding="UTF-8" standalone="no"?><rss xmlns:atom="http://www.w3.org/2005/Atom" xmlns:blogger="http://schemas.google.com/blogger/2008" xmlns:gd="http://schemas.google.com/g/2005" xmlns:georss="http://www.georss.org/georss" xmlns:openSearch="http://a9.com/-/spec/opensearchrss/1.0/" xmlns:thr="http://purl.org/syndication/thread/1.0" version="2.0"><channel><atom:id>tag:blogger.com,1999:blog-8529825541730311914</atom:id><lastBuildDate>Fri, 13 Sep 2024 07:21:03 +0000</lastBuildDate><title>PDA Assistance in Public Health Research</title><description>Go through the Link.......</description><link>http://pdaassist.blogspot.com/</link><managingEditor>noreply@blogger.com (Prasanta Kr. Biswas)</managingEditor><generator>Blogger</generator><openSearch:totalResults>1</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><item><guid isPermaLink="false">tag:blogger.com,1999:blog-8529825541730311914.post-8028414065882215139</guid><pubDate>Sat, 08 Sep 2012 05:07:00 +0000</pubDate><atom:updated>2012-09-18T12:51:05.876+06:00</atom:updated><title>PDA Assistance in Public Health Research</title><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;div style="text-align: center;"&gt;
&lt;/div&gt;
&lt;div style="text-align: center;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="font-family: Arial,Helvetica,sans-serif; text-align: left;"&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;Here I will describe how to maintain and creating project through PDA at field label Data Collection.&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;i&gt;&lt;u&gt;&lt;b&gt;PDA and Software Selection&lt;/b&gt;&lt;/u&gt;&lt;/i&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;div style="text-align: justify;"&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;b&gt;PDA (Personal Digital Assistant) &lt;/b&gt;is handheld device. It's simply use as a mini PC which only covered into your thumb.&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaUwSbrTAIzsmyFyLBpiU6xyumhvmZ8poYgULYRCLcBOyM5dqtobtb87HcvSqL-1P7CU2opmgTb6HQ3c63KzqNh7tU8rO3tC3AtUhSdQkcpN1TjjBSDmMp1QfNfnBPWNmCMxDCHXvypkYP/s1600/PDA.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"&gt;&lt;img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaUwSbrTAIzsmyFyLBpiU6xyumhvmZ8poYgULYRCLcBOyM5dqtobtb87HcvSqL-1P7CU2opmgTb6HQ3c63KzqNh7tU8rO3tC3AtUhSdQkcpN1TjjBSDmMp1QfNfnBPWNmCMxDCHXvypkYP/s1600/PDA.jpg" /&gt;&lt;/a&gt;&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;First need to select PDA &amp;amp; SD card which will be applicable for your software and database. SD card is applicable only for data transfer which incorporated with your software. Here I supposed to select PDA like HP iPaq 212 and SD card may be Transcend. After selecting PDA then you can concentrate your database design and front-end software.You can use SQL Server 2005 database(.sdf) and front end may be &lt;span style="color: #e06666;"&gt;&lt;b&gt;C# / VB.Net&lt;/b&gt;&lt;/span&gt;. .Net Framework support PDA application and windows Mobile 5.0 Pocket PC SDK need to install for running your software.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;i&gt;&lt;u&gt;&lt;b&gt;Field Selection and Prepare Questionnaire&lt;/b&gt;&lt;/u&gt;&lt;/i&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: justify;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="text-align: justify;"&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;It is very important role to selection your field for research. First you prepare questionnaire for related your topics or project. If you try to develop Demographic Surveillance then you have to follow Demographic rules.Here may be applicable Low Socio Economic Criteria. Due to this perspective may be scheduled Household,Socio Economic Status,Member Information and Event Information. So you have to prepare questionnaire depend upon above those criteria.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;u&gt;&lt;i&gt;&lt;b&gt;Approaching GIS (Geographical Information System)&lt;/b&gt;&lt;/i&gt;&lt;/u&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: small;"&gt;It is newly applied for research &lt;/span&gt;methodology where Data management activities also involved. GIS is playing very effective role to data collection.Because if you want to maintain your project Map based where data collector can find easily their expected field through GIS approach.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;i&gt;&lt;u&gt;&lt;b&gt;Database Design and Development&lt;/b&gt;&lt;/u&gt;&lt;/i&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;After making a &lt;/span&gt;&lt;/span&gt;&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;questionnaire think about your database and data tables. How many tables are covered your questionnaire. &lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;Database table design depend upon your data collection questionnaire.&lt;/span&gt;&lt;/span&gt; Need to concentrate fully about your tables which will be support your performance and quality. If you use SQL Server 2005 as Database I think it will compatible C# and VB.Net. One more important thing is that you have to confirmed that how many PDA's will be used this project. Because each and every PDA used same database but that should be distributed some other PDA's. You need to remember that your database should be gathered into a server database. So, you have to aware about your data field,Primary key and foreign key how you manage your database.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;u&gt;&lt;i&gt;&lt;b&gt;Software Design and Development&lt;/b&gt;&lt;/i&gt;&lt;/u&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;Next come to the software design and development. Software design would be depend upon your project output which will be support your requirements. Here need to specify that GIS information should be linked with software design. Several forms need to make which will be covered your &lt;/span&gt;&lt;/span&gt;&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;questionnaire. You may used several Menus here like to Insert data,Updating Data,Deleting Data,Saving Data and Last of all Process Data. Process object should be there,because you have to Insert,Update and Save event should be one Temp table and process will retrieve from temp table and placed into main table. Otherwise it will be tough to Edit,Insert and Update. Because sometimes need to cancel working menu then what will be happen if you used main table. Bug will appear or database transaction may not work properly. So, need to concentrate carefully and develop a bug free software.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;u&gt;&lt;i&gt;&lt;b&gt;Data collection from field&lt;/b&gt;&lt;/i&gt;&lt;/u&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;Make ready to field worker how they will collect Data. Need to trained about software, Questionnaire field, Data inconsistent and some other applicable field. If you don't trained up or don't aware about questionnaire then performance become low. Create target to visit sample then distribute your concept how customized to reduced error free data collection. One or two days try to collect data as temporary.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;/span&gt; &lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;u&gt;&lt;i&gt;&lt;b&gt;Data Management Activities&lt;/b&gt;&lt;/i&gt;&lt;/u&gt;&lt;b&gt;&amp;nbsp;&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;b&gt;&amp;nbsp;Copy data Into Specific Folder : &lt;/b&gt;Collecting information through PDA you have to copy your hard drive first because you will use so many PDA's into different field site. There need to develop one module for copying database from different PDA's.&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&amp;nbsp; &lt;br /&gt;
&lt;li&gt;&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;b&gt;&amp;nbsp;Merge Data Into Server Database :&lt;/b&gt; After copying database you need to merge into the server.So due to this reason you need to develop module for merging data from stored folder.&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&amp;nbsp; &lt;br /&gt;
&lt;li&gt;&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;b&gt;Check Errors,Data Consistency: &lt;/b&gt;Need to check range error,consistency check for your data you have to write so many queries to find out errors related to your project criteria.&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&amp;nbsp; &lt;br /&gt;
&lt;li&gt;&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;b&gt;Prepare Error free Data: &lt;/b&gt;If you checked properly your database then you can declare that you data is error free.&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&amp;nbsp; &lt;br /&gt;
&lt;li&gt;&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;b&gt;Convert several database platform:&lt;/b&gt; Error free data may be used in some other database format. So, you need to convert your database through SQL query where data field,data type should be declared. It is not necessary to do but your creation of demand through project. You can use ODBC connection also to convert directly from your database into different type of platform.&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&amp;nbsp; &lt;br /&gt;
&lt;li&gt;&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;b&gt;Data transfer for making Report:&lt;/b&gt; Report always depend upon your completion of project. Here you can make report your project requirement. That may be generated into your software through Crystal Report or any other reporting software which is compatible for this environment. Other wise you may use SQL query for generating different types of report. &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;u&gt;&lt;i&gt;&lt;b&gt;Data QC&lt;/b&gt;&lt;/i&gt;&lt;/u&gt; ......................................................&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;u&gt;&lt;i&gt;&lt;b&gt;&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;Demerits&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/i&gt;&lt;/u&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;Each and every transaction should be copied to SD card itself. Otherwise data may be loss in any kind of PDA functional operation. Sometimes message may be displayed like I/O Exception. Then you have to replace SD card and again place it to SD card bucket through formatting. Otherwise need to format SD card then replace.Here need to inform that PDA selection is the vital role for your project where processor, memory and transfer rate should be consistent. Because if you use high volume data then PDA sometimes hanged for recall data browse. So you have to concentrate too much in your database properties, Software and PDA's. In present uses smartphone like Android applicable devices. So you have to think always to be updated one or more usable platform because which is update today, tomorrow is not.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: justify;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="text-align: justify;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="text-align: justify;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="text-align: justify;"&gt;
&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;Update more...................................................... &lt;/span&gt;&lt;/span&gt;&lt;span style="font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class="blogger-post-footer"&gt;http://feeds.feedburner.com/PdaAssistanceInPublicHealthResearch&lt;/div&gt;</description><link>http://pdaassist.blogspot.com/2012/09/pda-used-into-project.html</link><author>noreply@blogger.com (Prasanta Kr. Biswas)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaUwSbrTAIzsmyFyLBpiU6xyumhvmZ8poYgULYRCLcBOyM5dqtobtb87HcvSqL-1P7CU2opmgTb6HQ3c63KzqNh7tU8rO3tC3AtUhSdQkcpN1TjjBSDmMp1QfNfnBPWNmCMxDCHXvypkYP/s72-c/PDA.jpg" width="72"/><thr:total>0</thr:total><georss:featurename>Dhaka, Bangladesh</georss:featurename><georss:point>23.709921 90.407143</georss:point><georss:box>23.4773095 90.091286000000011 23.942532500000002 90.723</georss:box></item></channel></rss>