Incident Statistic Report

The Incident Statistics Report summarises your incident data in terms of frequencies, means and standard deviations. You can create a report based on all records in the database, or a subset (e.g. only incidents involving a certain activity, or only incident associated with adverse outcomes).

This information can help you track trends over time and identify when changes to programs or risk management plans are required.

Click here to view a Sample Incident Statistics Report.

 There are two tasks involved in creating an incident statistics report:

  1.  Export the incident statistics into an excel file; and
  2. Use mail merge in Microsoft Word to create the final report as a word document.

The following instructions describe how to complete each of these tasks.

Task 1: Export the incident statistics into an excel file

  1.  Open the database and login with the password provided.
  2.  Select “Incidents” and “Table View”
  3. To create a report based on all incidents, select “Show All” OR To create a report based on a subset of incidents, select “Find” and enter the appropriate criteria (e.g. “Type of incidents = adverse outcomes) and press <enter>. More information on Find requests is available here.
  4. Click on the “File” button located on the top left under DB_program icon.
  5. A drop down box will appear. Click on the “Export Incident Statistics” button. A box will appear telling you the information has been sent to the “Report” folder

Export Incident Statistics

  1. Open the “Report” folder located in the UPLOADS folder.

Report

  1. You will see that datestamped Excel and CSV file have been created – this is a summary of your incident data.

incident stats report

Task 2: use mail merge in Microsoft Word to create the final report as a word document.

  1. In the “Report” folder you will also see that there is a file called “Mail Merge of Incident data.doc”.

mail merge folder

  1. Open the document “Mail merge of Incident data”.  The following box will appear, click No.

Mail merge box 1

  1. Once open, click on the tab “Mailings” and “Start a Mail Merge”. A drop down box will appear. Select “Step by Step Mail Merge Wizard”

Step by step mail merge

  1. A Mail Merge panel will appear on the right hand side of the document. Click through to Step 3 of 6. Select “Browse”.

Mail merge

  1.  Navigate to the folder “Report” and open the Incident Statistics Excel file that you created.

Incident report open excel

  1.  This will bring up a list of “Recipients”. Select only the first recipient, and press OK.

Merge

  1. Click through the mail merge to Step 6.
  2.  The Mail Merge is now complete.
  3.  Check the document has numbers in the tables. This is the data from the Excel Worksheet opened in step 5, which has now merged into the tables. Within the mail merge panel, there is an option provided to print the report.
  4.  Now save the document to a different location, with a different name. Keep the original mail merge document intact for future use.
%d bloggers like this: