Data Mining&Business Planning of Engineering/Research Projects

Data Mining&Business Planning of Engineering/Research Projects Presentation 6 Balázs Kovács (Terminator 2) PhD Student Faculty of Economics, University of Pécs E-mail:kovacs.balazs.ktk@gmail.com

Content of the Presentation • Online survey services • LimeSurvey • Licence and usage • Creating surveys in LimeSurvey • Creating question groups • Creating questions • Setting Controls • Survey management • Data operations • Closing a survey • References

Online survey services 1 • At the middle of March, you usually receive increased amount of online questionnaires… Why?Students should finish theirThesis (Szakdolgozat) latest at the end of April. So lazy guys google on „survey”, and click on the first result. They register on the site, and write a couple of questions and e-mail the survey-link to everybody they know. They will then receive a completely distorted data, because: • They do not design questionnairecorrectly: page breaks, question-types, logical conditions, etc. • Online survey providers (Weblekérdezés-szolgáltatók) offer many types of questions, moreover they declare themselves as the ultimate and most easy tool to create a survey. Yes, it’s easy… to make worse. • Majority of online survey providers offer a limited service. E.g. you can register free, but the amount of questions per surveys is limited up to 10 or the number of respondents cannot be more then 50, etc. • Another survey services offer a limited type of questions and do not allow you to extract the results directly. • Most popularonline survey services are: • In English: • Simple Poll http://www.free-php.net/detail/link-19.html • Advanced Poll http://drupal.org/project/advpoll • phpESP http://www.butterfat.net/wiki/Projects/phpESP/ • LimeService http://www.limeservice.com/index.php?sid=67384&lang=sl • SurveyMonkey http://www.surveymonkey.com/ • survey.com http://www.survey.com/ • In Hungarian: • Kérdőívem.hu http://www.kerdoivem.hu/register/ • ripet.hu http://www.ripet.hu/index.php?page=demo# • szavazz.net http://szavazz.net/WebUI/

Online survey services 2 • Of course you have the option to pay a fee for a less limited service, and more fee for a completely unlimited service. • If you have enough money then, someone can design, build, query your survey and analyze the data for you. • But, as a student, you don’t have money for this, you must pay the rent ofyour flat, pay for the beer in the pub, and the gifts for your(girl)friend(s). • There are open source survey systems also (Eg. PTE-KTK: http://exam.ktk.pte.hu/limesurvey ), which are free to implement. You can download it, customize the parameter settings, and upload to a server. • You need server space • You need competency as administrator • But you can fully supervise your survey • These survey systems are used by universities as a tool of supporting teachers and students in they work. •  As student you can: • Use the complete service free • Own as many survey as you want • Store as many responses as you want • Design as long survey as you want •  But you must satisfy some conditions : • Your data and your research belongs to the university also • The university may carry out researches based on your data • Your published results must contain the next text:„Made in Web-Query System of PTE-KTK készült (http://exam.ktk.pte.hu/limesurvey )” • You must reference the system operator as co-author • There are also smaller details of TERMS OF USE, please read before using it

LimeSurvey - Licence and usage 1 • What is LimeSurvey? (Earlier: PHPSurveyor) • You can build any survey as you want. • It supports development, publishing, collecting data • Source: http://limesurvey.org • Features • Open source, free • About 30 countries and 100 developers • Supports 50 languages (multilingual surveys also) • Internet PHP application ( runs on every system, everywhere on the world, every time) • You can mange your survey under your login name • Graphical user interface • Manages embedded pictures, videos • You can recycle previous surveys (not only yours, but shared by others) • About 30 built-in question types • No limits on • Sample size • Number of questions per survey • Number of surveys per user • Manages conditions in surveys

LimeSurvey - Licence and usage 2 • Which type of querys allows LimeSuvery? • Paper-based (printable version, data recording surface) • Phone, personal (data recording surface) • Electronic-online • How can you extract data from LimeSurvey questionnaries? • Simple statistical tables • PDF, Excel • Diagrams • PDF, Excel • Raw data • Word, Excel, CSV, SPSS • Licence • This program is free software; • You can redistribute it and/or modify itunder the terms of the GNU General Public License Version 2 as published by the Free Software Foundation. • This program is distributed in the hope that it will be useful, • But WITHOUT ANY WARRANTY; • Without even the implied warranty of MERCHANTABILITY or • FITNESS FOR A PARTICULAR PURPOSE. • See the GNU General Public License for more details.

Creating surveys in LimeSurvey 1 • First of all you will need a login name. You can ask one if you contact an admin. Here is a link toWeb-kérdőív, the survey service of the University of Pécs, Faculty of Economics. • When you try to visit the link above, you will receive a warning about the site’s security certificate, but click on Proceed anyway button to continue. • Then you will see the login sreen. Fill the fields, then click on the login (Bejelentkezés) button. • The next screen is the Welcome sreen. At the first login you should check your settings and personal data. • First, click on the key icon. If you are not admin, you can edit only your own data with the pencil icon. Click Click Click Click Click Click

Creating surveys in LimeSurvey 2 • Next click on the username (or the pencil rightwards) at the top of the screen. Edit your settings. • To create a new survey click on the page icon on the right side of the screen. • Choose the Base language of the survey and fill out the textboxes. (You can insertpictures and videos also.) • Set up your name and e-mailaddress as Administrator and Admin e-mail. • If you send out your survey ine-mail, you should set up a Bounce e-mail address, whereyou will receive deli-very error notifications. • If you are ready, click on thePresentation & navigation tab. Click Click Click Click Click Click • Let’s see the General tab first on the Create, import or copy survey screen. Click Click

Creating surveys in LimeSurvey 3 • Choose the Group by group option in the Format dropdown list. • It will display one group at a time, and the respondent will see all questions in a group on one page. • We will discuss later, how can you create question groups. • Click on the Publication & access control tab. • Allow public registration • Set up Start and Expiry date • Set cookies to prevent repeated participation Click Click • Click on the Notification & data management tab. Click Click Click Click Click

Creating surveys in LimeSurvey 4 • Coose Yes to Anonymous answers? • Click on the Save survey button. • On the upcoming screen you can manage your survey, add groups and questions. Click Click • Check the settings of your survey! • You can copy from here the URL of your survey also.

Creating question groups • Before you can add question to your survey you most create a group. • Click on the icon on the survey toolbar. • You can here add anew group or Import anexisting one. • If you have more than onegroup, you can change theorder of groups. • If you set conditions on question then this condition may prevent reordering the involved groups. • You can edit or delete groups by choosing it’s name on the survey toolbar thanclickingon theicons. Click Click Click • Click on the icon to export the chosen group.

Creating questions 1 • Choose a group on the survey toolbar. After that click on the icon on the question group toolbar. Click Click • First of all you can edit the question text, code and in-structions (help). • Choose the type of the question. • You can alter the group of the question at this point again. • The other options depend on the question type. Click Click Click

Creating questions – Question types 1 • Array type • A block of similar ques-tions with the same an-swer options. • Create a new question as it is described on the previ-ous slide. • Code: the block-ID (what you used in the Excel-Fieldlist) • Question: block-question • Type: Array • Update ques-tion Click Click

Creating questions – Question types 2 • Click on the icon on the question toolbar to edit sub-questions of the array. Click Click Click Click • Click on the + icon on the right side of the screen to add subquestions one by one. • Fill out the field names and the question texts • Delete subquestions with the – icon. • Alternatively, if you have a prepared Fieldlist, you can use the Quick add button. • Copy the table of field names and question texts in the editor window. (Delimiters: „;” or tab)

Creating questions – Question types 3 • Click on the icon on the question toolbar to edit answer options of the array. Click • You can use Predefined label sets also, but be sure,that these fit for your purposes. Click Click Click Click • Click on the + icon on the right side of the screen to add answer options one by one. • Fill out the answer code and the answer text fields • Delete answers with the – icon. • Alternatively, if you have a prepared table of answer options, you can use the Quick add button. • Copy the table of codes and answer texts in the editor window. (Delimiters: „;” or tab)

Creating questions – Question types 4 • Finally, an Array-type question looks like the screenshot in the top right corner of the slide. • The next question type is called Array (Numbers). • It is a 2 dimensional array, which can handle max 2 sets of subquestions. • A special subtype of the Number-Arrays is the 2 dimensional 0/1 (No/Yes) questions. • Create a new question: • Code: block-ID • Question: block-question • Type: Array (Numbers) • Show advanced settings: see on the next slide

Creating questions – Question types 5 • Fill the Code, Question and Help fields. • Choose Array (Number) Question type • Click on the Show advanced settings caption. • The 3rd block of the CarSculpturers survey asks for a 5-degree evaluation. • So set the Mini-mum value to 1 • Set the Maxi-mum value to 5 • And set the Step value to 1 • Update question • Click on the icon to edit sub-questions of the 2 dimension Click Click Click

Creating questions – Question types 6 • Fill out both the x and y scale with the Sub-question texts. • Codes of y and x scale will combining with each other forming variables. (Cartesian product /Descartes szorzat/) Click Click • You can alternatively use Predefined Label sets. • If a table like form alredy exists of the array of the subquestions and its’ codes, you should use Quick add as it was described earlyer. Click Click Click Click

Creating questions – Question types 7 • Finally, an Array (Num-ber) type question looks like this. • A block can be formed by a set of diffe-rent questions also. • So you some-times need an empty question without answer options to se-parate blocks. • Make a Boi-lerplate type question to create such a block caption. Click

Creating questions – Question types 8 • If a question allows to check multiple answers, we use Multiple options type. • Code: question-code • Option ’Other’: We use it only if we want to receive a text as other option. In this case: No. Click • Click on the icon on the question toolbar to edit answer options. • Code: answer-codes Click Click Click • Show advanced settings • Display columns: 3 • Compact but yet readable Click

Creating questions – Question types 9 • A block of different ques-tions, which have not the same answer options, cannot be handled together. (Block 5) • Create a boilerplate type question with the block title. • Then create each question individually. • To create a single option question choose one of the following types: • List (dropdown) • Recommended using long list • List (radio) • paper based survey-like layout • Use the block code as prefix of the question code. • The settings are the usual… Click Click Click Click Click

Creating questions – Question types 10 • Sometimes we ask text input or a free number input (like Question 40). • Be sure that the question code contains the block ID also. • The basic settings are the usual. • But these question types does not contains answer options. • Short free text • Numerical input • Numerical input fields may refer to currencies. • You can add currency abbreviation as answer suffix by clicking on the advan-ced settings caption. Click Click Click Click

Creating questions – Question types 11 • We do not process long free text answers, but they maintain intrest. • Choose Long free text type. • Use block ID as question code prefix. • There are not any special settings. • You may ask a set of text answers. (like questions 59-62). • Choose Multiple short text type. • The first part of the subquestions’ ID is the question code • Click on the icon on the question toolbar to edit answer options. • Second part of subquestions’ ID is the subquestions’ code. Click Click Click

Setting controls • Hide/Show Branching Logic: • You can define a con-dition or a set of con-ditions on each ques-tion of your survey • If the condition is met, the question will be displayed • a question without a condition defined on it will always be displayed • a question with a condition defined on it will not be displayed unless the condition is met • Coose the question you will set a condition on it. • Click on the icon (question toolbar). • Choose the question whose answer the condition should evaluate. Click Click Click Click Click • Set comparison operator • Choose the answer to be evaluating • Add condition • If necessary: • add more conditions • Choose more answer options (ctrl+click)

Setting controls 2 • Using Scenarios: • enable using OR ope-rator to conditions with different tested values • Limitations: • evade using chained conditions, because they are buggy • use the original tested values also and link to the unique conditions with AND operator • Combined conditions: • conditions sharing the same tested value are linked with OR operator • Conditions with diffe-rent tested value are linked with AND operator • OR operator has priority • Copying conditions: • Click on the icon on the condition designer toolbar. • Choose the question whose conditions you want to copy. • Select the conditions to copy. • Select questions copy conditions to them. • You can delete or edit condi-tions after defining them. Click Click Click Ctrl+ Click Click Ctrl+ Click Click

Survey management • Activating survey • Click on the icon on the survey toolbar. • You receive a Warning message: • you cannot change the ques-tiontype or the type of answer. • You cannot add new ques-tions or delete questions. • Nor can you add answers to any of the array or multiple choice questions. • It creates a separate database table to hold all survey res-ponses, and creates for each possible answer to the survey a field in that table. • It allows people to enter data into that table. • Running a survey safely • Export the survey structure imme-diately and save the .csv file on a safe place. Click Click Click • Regularly export the received responses and make backups. • Try not to make changes to the survey

Survey management – Data operations • We want make public our survey so choose No if the computer asks. • Now we can print out our survey to make a test query. • It cosumes paper space strongly, so it isn’t a real option to use this version in the live query. • If we use a papaer based survey, we can use the dataentry sreen. • You can add entries manually to record paper based responses • To extracting data chooseBrowse data icon. Click Click Click Click Click Click • Export to application • General: • Allresponses • Questions: • Abbr. headingsorQstn. codes • Answers: • Answercodes • Excelor.csvformat Click Click Click Click

Data operations 2 • SPSS Export • Data selection: • All responses • SPSS version • 16 or up • SPSS export includes two files: • a syntax file survey_xxxx_SPSS_syntax_file.sps • a data file survey_xxxx_SPSS_data_file.dat • You will need both to import data in SPSS. • Import data in SPSS: • Place the two files in the same folder on your drive. • Open SPSS • Choose: File->Open->Syntax • Choose the appropriate file: • c:\data\survey_xxxx_SPSS_syntax_file.sps • Now the syntax opens. • Change the line that reads • /FILE='survey_xxxx_SPSS_data_file.dat’ • to include the path where the files are: • /FILE='c:\data\survey_xxxx_SPSS_data_file.dat' Click Click Click Click Click Click Click • Now choose Run->All and after a while you have the dataset with all info like questions, labels etc.

Data operations 3 • Check the output file if occured any errors. • If everything is fine, check the variables in your newly created SPSS table. • Names • Types • Labels • Values • If everything is correct, save the table: • Format: .sav Click Click Click • Close syntax flie • Save changes • Close output file • We do not need it, do not save

Closing a survey • Expire • Survey settings • Publication and acces control • Expiry Date •  No results lost •  No respondent information lost •  Change of questions, groups and parameters is limited • An expired survey is not accessible to participant • they only see a message that the survey has expired •  It's possible to perform statistics on responses inside LimeSurvey • There are two ways for closing a survey: Expiry or deactivation. • It is strongly recommended to use the expiry option to close a survey. • Deactivation • Survey toolbar • Deactivation icon •  All results lost • at least you can not access them via LimeSurvey •  All respondent information lost •  All questions, groups and parameters are editable again • An expired survey is not accessible to a respondent • only a message appears that you are not permitted to see this survey

References • Video tutorials: • http://konyvtar.hu/wiki/Limesurvey • http://elearning.szie.hu/file.php/1/onlinekutatas_kezikonyv/html/limesurvey_tananyagok.html • Short overview: • http://konyvtar.hu/wiki/Limesurvey • http://www.installatron.hu/lime.html • http://survi.hu/ • http://elearning.szie.hu/file.php/1/onlinekutatas_kezikonyv/html/limesurvey_bevezetes.html • Detailed description and documentation: • http://docs.limesurvey.org/ • Services: • http://www.limeservice.com/index.php?sid=67384&lang=sl • https://exam.ktk.pte.hu/limesurvey/admin/admin.php • http://docs.limesurvey.org/LimeSurvey-compatible+hosting+companies • Comparison of online surveys: • http://wac.osu.edu/workshops/survey_of_surveys/ • Terms of use – Webkérdőív: • http://exam.ktk.pte.hu/limesurvey/setup/FelhasznalasiFeltetelek.pdf

Data Mining&Business Planning of Engineering/Research Projects