LMS Update


Brightspace 

What's New in D2L 10.3

Online Rooms (Blackboard Collaborate)

D2L Quickstart (PDF)

D2L FAQ

D2L Goes Mobile

spacer image

Instructional Design & Web Technologies Workshop Schedule

Instructional Design & Web Technologies department offers a wide variety of workshops. Please  let us know if you have a specific topic you would like covered!

REGISTRATION REQUIRED
Register via email at idwt@ship.edu. Please include the name and date of the workshop in your email.

We're available for individual consultations!

Need help? Please call and we will schedule a session with you.

spacer image

Accessing Form Data

By default, the CMS stores all submitted form data. If you want the CMS to store this data, double check that the option is checked. Follow the same steps for email (see above), but make sure Database is checked under the Form Properties tab.

To view submitted form data in the database:

  1. Log in to the CMS and navigate to the form
  2. Select switch to edit, then from the edit menu select Properties
    SelectProperties
  3. Click on the Report button from the top options

    ReportbuttonForms
  4. From the View Forms Report Page you can:
    • Specify the start/end date range. This will only show forms within the dates selected. You can also leave this blank to show all forms
    • Report Display. This will change the way form information is displayed. Depending on your form type, some of these types will not be visible.
  5. Report Display Types
    • Table with Totals (shows the following information for each completed form)
      • a checkbox that lets you delete the response
      • an internal identification number of the response
      • the name of the user who submitted the form, if he signed in to Ektron CMS400.NET beforehand. If the user did not sign in, anonymous appears.
      • date response was submitted
      • The name of each field on the survey - under each field name is the submitted response for the each user
      • the bottom line sums the numerical and percentage totals for each response
    • Summary of Selected Choices
      • This format totals, for choice and select type fields, the number of times each choice was selected. Only choices that were selected at least once appear.
    • Table of Values
      • The table of values shows the following information for each completed form.
      • a checkbox that lets you delete the response
      • an internal identification number of the response
      • the name of the user who submitted the form, if he signed in to Ektron CMS400.NET beforehand. If the user did not sign in, anonymous appears.
      • date response was submitted
      • descriptive name of each form field appears in the column header - the value entered for each field appears below the header                  
      • Table of Values Format 1
        FormsTableofValues
    • List of Submitted Values
      • The List of Submitted Values format provides the same information as the Table of Values, but is formatted vertically rather than horizontally. See Also: Table of Values
      • Sample List of Submitted Values Format

        FormSubmittedValues
    • Submitted Data as XML
      • Displays the results of the form in an XML format. The following information is included:
      • Title - title of the form block
      • Warning! With polls you can create a new poll question to replace an existing poll question. By default the poll still has the same Title, ID, and other properties. You can change the title of a new poll question when you are editing the poll.

      • Description - description of the form
      • SubmittedData - information that was submitted
      • Sample of Submitted Data as XML

        FormXMLData
  6. Exporting a Form’s Raw Data
    • After you run a report, you can export its data to a Microsoft Excel spreadsheet file (.xls) for further analysis. If a form uses an XML structure, each XML tag becomes a column header in the spreadsheet.
    • To export form data, follow these steps.
    • Access the View Form Reports screen for the report you want to export, as described in steps 1-3 above.
      • Click Get Report

        GetReportButton

      • Next scroll to the bottom of the screen and click
          ExportButtonReport
      • Without closing your browser window open excel
      • Return back to your browser window and click the down arrow on the downloaded file

        File Download2
      • Select the Show in folder option
      • Now shrink the window for the excel application so that excel and windows explorer are both visible

        SidebySideWindows
      • With the windows side by side drag the downloaded file to excel
        Explorer to excel2
      • Now you are able to save the file using the Save As option as either .xls or .xlsx
    • A File Download dialog box is displayed. The file will save as HTML.
    • Open Excel and open the downloaded file. After the data is opened in Excel you can analyze, modify and save the file as .xls.