VISUAL ANALYSIS OF QUESTIONNAIRY DATA
Contents
1. the questionnaire vi the establishment of the information which was collec ted during the questionnaire by filling them vii the bootstrap of the questionnaire results from the file viii the saving of the questionnaire results ix the composition of diagram rates X the composition of chart rates xi the instruction of programs consumption The chart of the questionnaire results is built on the basis of the object StringGrid It is filled in automatically The columns of the chart are built according the user request user must se lect the several numbered positions Numbers are related to the answer variant and the lines of the chart are filled by the num bers of the questionnaire questions The last column of the chart Neatsakyta Unanswered is filled with a number of unanswe I Anketos Anketa Apklausa Statistika Pagalba ooo adyan vana vang vas vae vaz vang Neatsakvtal 10 ar 1 14 i 10 10 Anketa Be pavadinimo UZpildyta 50 Fig 2 The main program window red answers to a certain question The invisible object ListBox in the program code the title is laikinas temporary is used as an array of String type element While creating or loading a set to this program the questionnaire results are being written into it which is later used in a working process of the program 2 2 The creation and the saving of the question naire At the beginning of program s work the func2. Jadzgevicien et al Research results analysis INNOVATIVE INFOTECHNOLOGIES FOR SCIENCE BUSINESS AND EDUCATION VISUAL ANALYSIS OF QUESTIONNAIRY DATA Violeta Jadzgevicien Algirdas Lancinskas Vilnius Pedagogical University Studenty str 39 Vilnius Lithuania Received 24 November 2009 accepted 10 March 2010 Abstract Nowadays surveys play an important role in modern society They are needed in many fields of society to inform the government politicians businessmen scientists media and citizens A lot of information is collected in every survey which one later needs to process and give results of the research A short review of questionnaire research data presentation in a form of a diagram widely usable data analysis software and data visualization with Borland Delphi 7 component Charts are going to be presented in this paper In order to create a visual analysis of questionnaires results a user friendly application was designed also more advanced steps of the task realization are described Keywords Questionnaire research Charts in Borland Delphi Arrays of objects Short title Research results analysis Introduction Questionnaires are one of the most popular methods of public research They enable to gather information from target popu lation in a convenient way There are two ways to complete a questionnaire First respondents could be asked to complete a questionnaire without researcher being present Th
3. chk OO8var 3 Fig 4 An example of a questionnaire set saving file After that the data which was written during the process of the description of the questionnaire set is being transferred to object ListBox and later it can be saved in the questionnaire set file whi ch was indicated by the consumer with an extension ank There is acertain order for writing the data to a file or to the object List Box which makes reading of the data easier The example of a questionnaire set is represented in Fig 4 The first line of the file is made from the title of the questionnaire questionnaire set id and the mark of a possible edit 0 questionnaire set was not edited 1 questionnaire set was edited The further content of the file is built up from blocks which describe each question of the questionnaire Each block is made from the number of the question formulation of the question and possible variants of the answers Before the formulation of the question the symbol is marked Before each variant of the answer the combination of symbols is marked then the mark cmb is written which means that only one answer variant is possible or the mark chk is written which means that there may be more than one answer variant Then the line number of an object which will be created in the process of making questionnaire set review window is in dicated At the end of the line the answer variant formulation is w
4. ible with any version of Microsoft Windows 2 Program structure Fig 1 represents the structure of program All of these opera tions are explained below 2 1 The main window of the program The main page of the program Fig 2 is built from operation zone menu chart of the results from questionnaires status zo ne at the bottom of the window and the object ListBox which is invisible for the consumer The main commands of the status zone are presented as follows INNOVATIVE INFOTECHNOLOGIES FOR SCIENCE BUSINESS AND EDUCATION ISSN 2029 1035 Vol 1 8 2010 Pp 8 11 Jadzgevicien et al Research results analysis Create a new questionnaire Questionnaire Open an existing questionnaire Save active questionnaire Review and edit questionnaire Change name of questionnaire f _ Program Survey Enter survey results by filling created questionnaire Import survey results from a file Export survey results to a file Chart diagrams using entered data Statistics Create a table of entered data Fig 1 The structure of program 1 the description of the new questionnaire 11 the bootstrap of the questionnaire set which was created earlier from the file 11 the saving in the file of the described questionnaire set iv the review and drafting of the described questionnaire set v the emendation of the title of
5. is is a postal questionnaire Second respondents could be asked to complete a questionnaire verbally with the presence of the researcher This variation is called as structured interview All that process of collecting and analyzing data collecting is called questionnaire research Every method has advantages and disadvantages whi ch appear in certain situations of a research It is not difficult to analyze Questionnaires and most statistical analysis software can process them easily Most popular statistical programs are STATISTICA 1 STATGRAPHICS 2 SPSS 3 SAS 4 Purpose and func tions of these programs packages are similar Using this statisti cal software statistical results can be received in various forms However they require higher skills of using computers and ba sic knowledge of statistics Therefore it was decided to create a simple and user friendly application designed for the visual ana lysis of a small sized questionnaires research user manual is also created This work is aimed at processing and getting visual analysis Corresponding author email violeta jadzg gmail com of small sized questionnaires research as they are carried out in schools offices etc 1 Programming tools The program is created on Microsoft Windows XP operating sys tem using Borland Delphi 7 0 programming environment with standard libraries 5 Delphi component TChart was used for diagram charting The program is compat
6. m columns will be visible or not 11 the legend place in the dia gram window is chosen on the right on the left at the top at the bottom or invisible 111 the title of the diagram is indicated iv the titles of horizontal and vertical diagram axles are indica ted The created diagram can be saved in a graphic file bmp which the consumer indicates himself The diagram is drawn by pressing a button Braizyti Draw According to the button Kry min diagrama cross diagram whether it is on or off the procedure of one question diagram drawing or cross diagram dra References wing is prosecuted In both cases the diagram is drawn with the help of the TChart component Conclusions User friendly application was designed in order to make a visual analysis of questionnaires results Arrays of objects are conve nient tools for creating data mining application when the amount of the data is undefined TChart as the component of Delphi programming environment is a useful tool to chart the results of questionnaire research in various types of graphical presenta tions L http www statsoft com unique features statistica features benefits retrieved 2009 11 03 a i Paskaliu Turbo Paskalis ir Delphi Vilnius Piketas 2000 http www statgraphics com product_overview htm retrieved 2009 11 03 http www spss com software statistics retrieved 2009 11 03 http www sas com technologies analytics stati
7. ritten 2 3 Review and edit of the questionnaire set e opo o eded add a question change the question formulation eliminate unwanted questions or change the succession of the questions in the questionnaire The button zone at the top of the questionnaire review window allows editing operation Fig 5 It can be edited untill the first questionnaire is filled After that all the possibilities of questionnaire set editing are turned off 2 4 Filling and data saving of the questionnaire When the questionnaire set is properly prepared one can begin the establishment of the data collected during the questionnaire filling of electronic questionnaires The consumer is presented 10 DEX A Be payadinimo Prid ti klausim Redaguoti klausim Pa alinti klausim Keisti eili kum U daryti 1 Pirmas klausimas M Atsakymo variantas 1 Atsakymo variantas 2 M Atsakymo variantas 3 Atsakymo variantas 4 P Atsakymo variantas 5 2 Antras klausimas Atsakymo variantas 1 M Atsakymo variantas 2 Atsakymo variantas 3 M Atsakymo variantas 4 3 Tre ias klausimas g 4 K Atsakymo variantas 1 Atsakymo variantas 2 Atsakymo variantas 3 Fig 5 Reviewing and editing questionnaire set window with a questionnaire review window Fig 5 only in this case the edit line is hidden and instead the button I saugoti Save appe ars which has a function of saving the data and getting another questionnaire Al
8. so a number of filled questionnaires is added to the questionnaire title After filling the questionnaire the button of saving is pressed The data is written to array and the ques tionnaire set is being prepared for the establishment of new data The answers of one questionnaire questions are saved in doub le matrix The first element in each line is the number of a ques tion and the other numbers are the numbers of the answers to the question From all of the questionnaire data matrixes the matrix array is made up triple matrix The whole triple matrix is saved in the file ats by a column down after printing all the double matrixes The saved data of the questionnaire can be loaded to the prog ram repeatedly While doing this command the data saving mat rix is being filled by the data of a chosen file Before loading the data the program checks if the identification numbers of the questionnaire set and chosen data file can be synchronized in or der to avoid inconsistencies of data file and questionnaire set If there is any inadequacy the consumer will be warned about the mistake The data will not be loaded if the questionnaire set is closed 3 Depiction of the results The results of the questionnaire can be delivered visually accor ding to the data the diagrams are drawn Fig 6 The consumer can choose if the diagram will be drawn according to one ques tion of the questionnaire or according to two cross diagram of t
9. stics stat index html retrieved 2009 11 03 See textbooks of Turbo Pascal and Delphi For lithuanian readers Dzemyda G Stankevicius J Saltenis V Programavimas INNOVATIVE INFOTECHNOLOGIES FOR SCIENCE BUSINESS AND EDUCATION ISSN 2029 1035 Vol 1 8 2010 Pp 8 11
10. tion of the estab lishment of the questionnaire results is inactive If one wants to activate it the description of the questionnaire according to whi ch the data will be established has to be written one has to write a set to indicate the title of the questionnaire the formulation of each question the variants of the elective answers and question to answer format whether you can choose only one answer or more In order to make this procedure the program gives a win dow of the establishment of a questionnaire set Fig 3 where the information mentioned above can be indicated Klausimas nr 1 Anketos payvadinimas Be pavadinimo Klausimas Firmas klausimas p Atsakym variantai Atsakymo variantas 3 Endet Atsakymo variantas 1 n akma variantas 2 Pagalinti Galimas tik vienas teisingas atsakymas Kitas klausimas Pabaiga Fig 3 Window of the establishment of a ques tionnaire set INNOVATIVE INFOTECHNOLOGIES FOR SCIENCE BUSINESS AND EDUCATION ISSN 2029 1035 Vol 1 8 2010 Pp 8 11 Jadzgevicien et al Research results analysis P Anketos forma Notepad TES File Edit Format View Help Pavadinimas 3369163715 1 1 Pirmas klausimas cmb lvwar1 cmb lvar2 2 Antras klausimas chk lvar1 chkoo2var2 chkOo3var3 chkoo4dvar4 chkooSvar5 3 Trecias klausimas cmboo2varl cmboo2var2 cmboo2var3 4 Ketvirtas klausimas
11. wo questions The consumer is offered to choose one of these diagram types circle column or linear diagram At the top of the window the main diagram parameters are shown they are used when the diagram is drawn that is why they are used only after the drawing of repeated diagram 1 the qu estion is chosen to which the diagram will be drawn 11 the type of diagram is chosen 111 the indication whether the diagram is for one question or for two is made iv the data aspect is chosen unitary or percentage INNOVATIVE INFOTECHNOLOGIES FOR SCIENCE BUSINESS AND EDUCATION ISSN 2029 1035 Vol 1 8 2010 Pp 8 11 Jadzgevicien et al Research results analysis Diagrama Pasirinkite klausima Diagramos tipas MV Kryzmine diagrama 1 7 J s am ius Etike i redagavimas Stulpeline Pasirinkite antra klausima 6 Jusy lytis v Etike i redagavimas Duomen i rai ka Be pavadinimo of IN g5 o E4 az T 5 3 a E2 T a 4 0 21 30 31 40 Am ius Legenda De in je a 11 16 16 20 V Duomen ym s Vienetai X Brai yti E vyrai E Moterys O Nepasirinko 41 50 51 60 I saugoti grafiniame faile j Diagramos pavadinimas Be pavadinimo V Xx a is Am ius Iv Y a is Atsakym parinkimo daznis Fig 6 Charting window At the bottom of the window supplementary diagram settings are shown 1 it is chosen if data marks which are above diagra
Download Pdf Manuals
Related Search