Online Skills & Competence Analysis Tool
INDEX
A survey has three integral elements. Every survey must have:
Optional elements to a survey include:
The Survey Name is the name of the survey, and the place where various options are set that relate to the survey as a whole. Options such as the “Definition” message, the “description” of the survey, contact information for the survey administrator, what “format” the survey will appear in, and so forth.
Each survey divides the questions into groups. This allows for logical organisation of the survey into groupings of similar questions. A group has a title and an optional description. You must have at least one group in each survey, even if you don’t wish to divide the survey into multiple groups.
Questions are the core of your survey and fit into a group, as explained above. There are no technical limits to the number of questions you can have in your survey, or the number of questions per group. Questions include the actual question itself, as well as settings that determine what type of answer you expect. You can also include a short “help” explanation for each question and determine whether the question is mandatory (ie: must be answered before continuing).
Question
Types
There are two kind of questions:
1. questions that allow ASSESSMENTS
2. questions that DON'T allow
assessment:
ASSESSMENT
Using these kind of questions authors can benefit the assessment function of
the tool.
NO ASSESSMENT
Using these kind
of questions authors can only gather users' choices and can't benefit the assessment
function of the tool.
To create a new survey click on the
button
at the right hand side of the administration button bar.
The "Create New Survey" screen will appear below. Following is a description of each field:
No email notification - self explanatory
Basic email notification - an email is sent informing the administrator that a survey response has been saved
Send email notification with response codes - sends the full answers to the survey after saving
{FIRSTNAME} - gets replaced with the token table's "firstname" value
{LASTNAME} - gets replaced with the token table's "lastname" value
{SURVEYNAME} - gets replaced with your surveys name
{SURVEYDESCRIPTION} - gets replaced with your surveys description
{ATTRIBUTE_1} - gets replaced with the token table's "attribute_1" value
{ATTRIBUTE_2} - gets replaced with the token table's "attribute_2" value
{SURVEYURL} - gets replaced with the fully qualified URL to this particular survey
Importing
a Survey
If you have previously exported a survey, you can import it from
the "New Survey" screen. Click on the browse button to choose the sql file,
and then click on the button. The import process
reads a 'sql' file created by the tool and 'intelligently' renumbers the
survey, group, question, answer and condition id's so that they all match
each other. See section on Exporting a Survey
for more information.
Before you can add
any questions to your survey you must create a group. If
you will only have one group in your survey, then how you name this group
is irrelevant (except of course for show). If, however, you are going to
have multiple groups, you should note that the survey questions will be
displayed by group, and the groups will be displayed in alphabetical
order. So, if you really need the groups to be displayed in
a particular order, consider naming them with an alphabetic start such as
"A) Questions about you" and "B) Questions about health".
Doing it this way will ensure that your groups are displayed in order. If,
for example, you entered the group names as "Questions about you"
and "Questions about health", the "Questions about health"
group will display first, because alphabetically it comes first. PHPSurveyor
is designed to do this deliberately, because it allows you to add extra
groups in later, and arrange their positioning by adjusting the title. For
example, you could squeeze an extra group between the two by naming it "A1)
Questions about your history".
You can create as many groups as you like.
Groups can also include a "description". This field allows you to publish an explanatory note for any set of questions. If you add a description, then when the public are using the public survey system, they will be presented with that explanation before commencing any of the questions in that group. If you do not include any text here, then public participants will simply move on to the first question in the group with no stop.
Create a new group by clicking on the
icon in the Survey Button Bar.
Once you have created
your groups, you can start adding questions within each
group. Create a new question by clicking on the add icon (
)
on the right hand side of the "Group" menu bar.
When adding a question, you will be asked for a "Question Code", the "Question",
"Help" and a "Question Type". All new questions are assigned to the Group
you were viewing when you clicked "Add Question", however you can change
the group the question belongs too at a later point.
Question
Code: Your ID, or number or code for the question. This
field is important, because the entry in this will determine the positioning
of the question in your survey. Again, numbering this "Q1", and following
questions "Q2" and "Q3" will ensure that they appear in the correct
order. Using this system allows you to add in extra questions as an
afterthought by giving them a code such as "Q1a". Try to be consistent
with your coding in this field. Planning makes this process a lot easier.
Question:
This is the actual question being asked. There is no real limit to the
length of the question here, however if you want to explain the question,
leave that for the next field.
Help:
This is an optional field. It is useful if a question needs some explanation,
or you want to explain how it should be answered. When you put text
in this field, a "Question Mark" icon appears on the survey entry screens,
and clicking on this allows the survey participant (or data entry person)
to read the help.
Mandatory? For all question types, except the text ones, this setting allows you to require users to answer the question, before they can move on to the next question.
You
can create as many questions as you like.
When you have created a question that uses pre-determined answers (ie: dropdown
list) you can then add answers to that question.
(D) Setting Conditions (Branching)
A question can be
set to display ONLY IF certain conditions are met. You can set these conditions
by clicking on the
icon in the question button bar,
when viewing a question.
When you choose "Set Conditions" a new window will appear allowing you to delete or create conditions for the current question. An example is show below.
| Condition Designer |
| Only
show question 02-07b |
||||
| 02-07: Have workers or former workers.. (qid510) | Equals |
|
||
| Copy Conditions | ||||
| Condition | Question | |||
|---|---|---|---|---|
| copy to | ||||
| Add Condition | ||||
| Question | Answer | |||
| Equals | ||||
Existing
Conditions
The top part of the window shows any conditions
already set for this question, and the bottom part allows you to
create new conditions.
New Conditions
To create a new condition, click on the question (left hand column)
that you wish to use for your condition. When you have chosen a question the
Answer section on the right hand side will display the possible answers for
that question. Choose the answer that you want to use, then click on the "Add
Condition" button. You can choose multiple answers in one go by using the CTRL
button and clicking on more than one answer in the right hand select list.
Multiple
Conditions
You can set more than one
condition to apply for a
question. Conditions can be based on more than one previous question.
So, for example, you can set a question to display only if the answer
to Question 1 is "Y" and question 2 is "N". Or
only if the answer to Question 1 is "Y" or "No answer"
and the answer to question 2 is "N".
Copying Conditions to Later Questions
It is not uncommon for a group of questions to have the same condition. If you set a condition for one question, you can copy this condition to any subsequent question from the conditions designer. Once a condition has been set, the following screen will be displayed:
|
Copy Conditions |
||
|
Condition |
|
Question |
|---|---|---|
|
|
copy to |
|
|
|
||
The select box on the left displays the conditions already set on this question, and the select box on the right shows all subsequent questions in the survey. Highlight all the conditions on the left side that you wish to copy (using the CTRL key to select multiples) and then highlight all the questions you wish to copy these conditions to on the right hand side (using the CTRL key to select multiples). The click on the "Copy Conditions" button to copy them across. It is usually best to leave this until you have finished entering all your survey questions, and are satiisfied with the question order.
Things to
watch out for
If you set conditions on a question that, itself, has conditions, then
there may arise occasions where the survey behaves in ways you might not have
predicted. So if you are designing a complicated survey with large numbers of
conditions, make sure you test the survey for as many different combinations
of results as you can think of. In the above example, a question is displayed
'Do you like being male?' which has conditions set, and which will only display
if the answer to "what is your gender?" is "M". If you were to add a condition
to this question requiring a specific answer from the "Do you like being male?"
question, then this question will never display, because the question "Do you
like being male" will not be presented. If this seems confusing, don't worry
too much, because when you are designing your survey the logics of these conditions
will make themselves far more clear.
There are a few basic rules you should
keep in mind before setting conditions on a question.
- Once a single
condition has been set for a question, that question WILL NOT DISPLAY
unless that condition is met.
- Conditions can
only be set based on questions that appear BEFORE
the question on which the condition is
set.
- Multiple conditions based on a single
earlier question are evaluated using boolean "OR" principles. Multiple
conditions based on multiple earlier questions are based on boolean "AND"
principles. This is important because it means you cannot (for example)
set a condition that a question will only display if either previous question
a is "Y" OR previous question b is "N".
- You can modify conditions even after
a survey has been activated. This should be done with caution, as there
is no "consistency checking" applied here.
(E) Adding ANSWERS
Various question types require you to add a list of 'answers' from which the
survey participant chooses, or which are used as headings for responses. To
add answers to one of these question types click on the
icon in question button bar.
When adding an answer you will be asked for an "Answer Code", an "Answer" and
whether that answer is the "Default".
Answer Code: This is the data that will usually be exported to your spreadsheet when compiling results. You may choose whatever code you want (5 character maximum). The code can only contain standard alpha-numeric characters. Please note that if you want to use assessment the system doesn't allow to assign the same number for different answer code:
Correct:
2 I cooperate with one or several colleagues on predictable previously defined tasks.
1 I work with one or several colleagues on varying tasks. The tasks are previously defined, though there is flexibility for own initiative. I actively participate in complex team working relations.
0 We perform tasks that follow a given general structure, but there is an extensive margin for variation.
Uncorrect:
2 I cooperate with one or several colleagues on predictable previously defined tasks.
0 I work with one or several colleagues on varying tasks. The tasks are previously defined, though there is flexibility for own initiative. I actively participate in complex team working relations.
0 We perform tasks that follow a given general structure, but there is an extensive margin for variation.
Tip: if more than an answer is scored 0, you can assign a "00" or "000" as a right code for a null value.
Answer:
The answer that will be displayed.
Sortorder: You can use the "Up" and "Dn" buttons next to each answer to change the position of that answer in the list.
Default:
One answer from all can be chosen as the default answer (ie: this one will
be chosen and entered into your survey results unless it is changed). Change
the Default field to "Y" if you want this answer to be the default answer.
If you don't choose any default answer the survey result will record nothing
if one of the answers is not specifically chosen.
(F)
Exporting a survey
The
button in
the survey button bar will dump all the groups, questions,
answers and conditions for your survey into a standard sql dump file. This dump
file can be used with the 'Import Survey' feature.
You can test a survey at any
point while you are creating it, by choosing the
button in the 'Survey' section of the web page. This allows you to check how
the survey looks and feels, before you actually initialise it. When testing
a survey your responses will not be saved.
Assessments are rules which evaluate the responses to the survey immediately after it is submitted, and can then display text based on that.
As an example, consider the following. You have two questions in your survey, the first question asks if the user smokes: "Do you smoke?". The question has 3 possible answers, "Yes more than 10 per day" with an answer code of "10", "Yes, but less than 10 per day" with an answer code of "5" and "No, I don't smoke at all" with an answer code of "0".
The second question "Do you exercise?" has three possible answers; "Yes, I exercise for at least half an hour three times a week" with a value of "0", "Yes, I exercise every now and then" with a value of "5" and "No, I don't ever do any exercise" with a value of "10".
If we were to add the totals of the values for each possible answer at the end of the survey, we'd have a good indication of the general health of the respondent. Someone who smokes and doesn't ever do any exercise will have scored 10 in each of their answers, giving a sum of 20 when we add the values together. Someone who doesn't smoke and exercises regularly will have scored 0 in each of the answers with a total of 0 when we add the values together.
The assessments tool allows you to set some rules based on the summed values of the questions in the survey, either for the Total survey, or for each Group within the survey.
If we visit the
assessments tool from the survey administration toolbar, we can create
some assessments for this survey. From this screen you can view, edit
or delete existing assessments or create new assessments.
| If you create any assessments in this page, for the currently selected survey, the assessment will be performed at the end of the survey after submission | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||||||||||||||||||||||
In the "Add/Edit" box you can choose the following:
Scope: The scope of the assessment. Choose either "Total" which will create an assessment based on the sum of all the answers in the entire survey, or "Group" which will create an assessment based on the sum of all the answers in a group (chosen in the next row)
Group: If the scope of this assessment is for the current "Group", this is where you choose which group to assess.
Minimum: The minimum "sum" of answers to which this assessment will apply
Maximum: The maximum "sum" of answers to which this assessment will apply
Heading: The heading of the assessment which will display if this assessment is shown
Message: The actual message for this assessment (it may include html code)
URL: A URL link which will display with this asssessment.
You can create as many assessments as you like, and you can create more than one assessment to display for a given score.
It is important to note that if you use assessments, you must ensure that you have not chosen to autoload the URL at the end of the survey in the general survey setup, because the assessments only show on the final "completed" page after submitting a survey.
Once you are happy with the structure of your survey you can activate it. Activating a survey does a number of things.
If your survey is set to "not anonymous", a tokens table will be created automatically.
Before you activate a survey you should note the following points:
You cannot add new questions or delete questions. Nor can you add answers to any of the array or multiple choice questions, however you can add answers to the basic list type questions.
Once a survey has been activated, and survey responses have been submitted, you will want to be able to view those responses, maybe edit some of them (or possibly delete some), export them, get some information about the responses received so far, and so on. All of this is done through the "browse" function.
When your survey is active, a 'Browse' button (| Browse Responses: CPSU EB2003 Survey | |
| |
|
Editing
and Deleting
Responses
When viewing your reponses, you
will be able to view
a specific response by clicking on the id number. An example of
'browse' responses is shown below.
|
id |
What is your Employment Type? |
What are your Hours of Work? |
What is your Spread of Hours? |
What is your Gender? |
What is your Classification? |
What
is your Top
Priority for outcomes of the
next Enterprise Agreement? |
What
is your Top
Priority for outcomes of the
next Enterprise Agreement? |
|
A |
A |
A |
F |
A |
I |
Please pay us more money. |
|
|
B |
A |
A |
F |
B |
J |
Possibility of further tertiary study and working that in with my current job. |
Clicking
on the hyperlinked id number will present the 'view record' screen:
|
Viewing Answer ID 1 |
|
|
id |
1 |
|
What is your Employment Type? |
Full Time [A] |
|
What are your Hours of Work? |
76 Hours Per Fortnight [A] |
|
What is your Spread of Hours? |
9 to 5 [A] |
|
What is your Gender? |
Female [F] |
|
What is your Classification? |
Administrative Officer [A] |
|
Do you manage staff in your current job? |
No [N] |
|
What is your Region/Division? |
Health Sector [H] |
|
What
is your Top Priority
for
outcomes of the next Enterprise Agreement? |
Increased Salaries [I] |
|
What
is your Top Priority
for
outcomes of the next Enterprise Agreement? |
Please pay us more money. |
From this point you can choose to "Edit" or "Delete" this response.
Deleting the responses is, of course, fairly self-explanatory - and as anyone who regularly runs surveys would know, is not recommended, unless you've got a pretty good reason (ie: a doubled up entry, or some sufficiently serious reason as to why it should be deleted). Don't click on this button thinking it will give you a second chance. If you click "Delete", the entry will be deleted with no second guessing or second checks.
Editing the response is also fairly self-explanatory. It will take you to a 'data-entry' screen with the responses provided, and allow you to make and save any modifications. Again, in a survey you generally don't want to make changes to the responses made by the participants - but hey - it's your survey. Do what you want!
On many occassions you will want to invite a group of people to participate in your survey, keep track of who has completed the survey, and ensure that each person can only participate once. Tokens can be setup once a survey has been activated. The tokens feature allows you to do the following:
Edit/change any details in your list
Once you enable tokens for a survey, then the only people who can access the survey are those who have been issued a token number. Access to the public script will rely on the participant being able to provide their unique token id.
Tokens can be matched to surveys that have been set up as "not-anonymous". This is determined when creating a survey. If a survey is not anonymous (or 'tracked') then the token list can be used to find the particular response that an individual has made to the survey. If the survey is anonymous, then no link is available between the tokens table and the responses.
The following is a brief rundown of the menu options in the tokens screen:
tokenify: A new word for the english language, specifically invented for this script. Creates unique tokens for all individual entries in the tokens table that do not yet have one.
Database
Admin
While the summary
screen shows a brief
summary of tokens in the table, it also provides access to the
"Database Admin" features which include:
drop tokens: Allows you to remove the tokens feature from your script. Deletes the entire table and all records, and allows the survey to be accessed by anybody who knows the URL.
Using
the browse screen
The browse screen will show
you a list of
all entries in the tokens table, as well as giving you some 'action'
buttons that can perform specific tasks for that individual entry.The top
row of the table gives options for displaying a number of records,
and a starting point.
The second row of the table includes the
field name, and a green arrow that - if clicked - will refresh the
screen showing the tokens ordered by that field.
The last row of
the table lets you move backwards or forwards through your list
(based on the settings at the top).
|
Showing |
records starting at |
|
|
|
|
|
|
|
|
attribute_1 |
attribute_2 |
Action |
|
|---|---|---|---|---|---|---|---|---|---|---|
|
1 |
a |
a |
a@a.org |
0829007266 |
Y |
Y |
|
|
|
|
|
2 |
b |
b |
b@b.org |
1371896219 |
Y |
|
||||
|
3 |
c |
c |
c@c.org |
R193857398 |
Y |
Y |
|
|
|
|
Allowing
Public Registration
You may want to open your survey to the public, but utilise the sort
of respondent control available when using tokens. If you initialise your tokens
table, and have chosen to Allow Public Registration in the main survey setup,
people who visit your survey's URL without a token, will be given the opportunity
to register. If they provide an email address that is not already in the current
survey's tokens table, an entry in the tokens table will be created, and they
will be emailed an invitation containing their unique Token. All tokens provided
to "registering" visitors will begin with the letter "R".
This program is opensource software under
the terms of the GNU General Public License.