Enquette

This documentation is powered by the Dispute component based on the pj DataProvider and the pj DataProvider Framework respectively.

Description:

The Enquette consists basically of one or more pairs of question item and evaluation control, eventually organized in more layers. It either lets the visitor to choose his votes or it displays results statistics together with distribution graphics.

The Enquette can be implemented either as a component (menu) or as a part of Joomla content (article). An important feature is the export in the Office Open XML format (e. g. MS Excel) enabling further processing with external tools.

Administrate Enquette:

  1. Have a look at the Enquette Anatomy
  2. Purchase and Install Enquette package
  3. Create Enquette Menu, Create Enquette Module or Append Enquette to an Article
  4. Set up Enquette
  5. Optionally, Invite selected respondents
  6. Download / upload Enquette
  7. Work up results with Excel

On the Enquette Setup page, at the Tab Enquette, you can download or upload the Enquette content. This enables to port the Enquette to other page or site, to work Enquette results up with Excel or other applications or to prepare the survey on a local machine and upload it - ready to use - to the production site.

There are two possible file formats used for the Enquette porting: the pure XML format containing just data necessary, and the Excel XML format (Office Open XML) enabling desktop results inspection and further processing as well as modifications and uploading.

See Download Enquette for details on downloading and / or Upload Enquette on uploading the Enquette. See Excel Enquette for more details on Excel Enquette representation. See Set up Enquette Local for modifying Enquette local and uploading to the site.

The downloaded file

Excel

Supposed the Excel Enquette file was downloaded either with Anonymized votes or Full information option, the first worksheet is named Composed and may look like this.

The row 2 only contains formulas composing information from other worksheets, especially Marks, to readable information record. Initially, rows 4 - 12 contain instructions including a brief schema how to arrange data to Excel Pivot-Table. Following the instruction in the row 4, this part will be overwritten by copies of the row 2. Than, the worksheet becomes your root data source and it is recommended to save the workbook as Excel XLSX format thereafter in order to save place and improve performance.

Evaluation

The header row 1 is configured with AutoFilter, so you can just begin with selecting data by any combination of attributes. The voting information is contained in last two columns, Mark for numeric / date and Text for textual votes.

Following the schema, you can create a next Pivot-Table worksheet. In Excel menu, select Pivot-Tables and Pivot-Chart, select New Worksheet and open the Layout dialogue. From the right columns, move Item to the field Page, move Mark to the field Row, move Schema/Criterion to Column. Then move Mark to Data, which changes to Count of Marks, and move Mark to Data once more, which changes to Count of Marks2. Doubleclick it and select Sum of Mark. Finish the Pivot-Table.

In the new worksheet, you can filter information desired and get the distribution, basic statistics and eventually create charts to selected items.

Note that this processing is meaningful with votes evaluating to integer. For processing textual values (Text field or Text Area), the AutoFilter function of the Composed worksheet is an appropriate tool.