Resources > CILC Program Statistics  

CILC Program Statistics

CILC Logo

Why CILC Program Statistics?

CILC is excited to publish 5 Program Statistics reports each fiscal year, July - June. There will be 4 quarterly reports and 1 annual report. We hope the the report will help you in your planning endeavors such as seeking support for your program, providing ideas for developing new programming and give your organization a better understanding of the marketplace.  

CILC Program Statistics Report

 

The Program Statistics Reports should be considered as dynamic, as we will look at the data in various lenses moving forward. The data in the reports is our best guess on what matters most to you. We will be adding new "fields" in the coming reports. Please feel free to let us know if there is some data that you would like to see added to reports. 
 


 

 

What Data is Included: 

  • Types of Members
  • Types of Sites
  • Top 10 programs
  • ​Top consumer states
  • Top consumer sites
  • ​Most popular programs booked by subject area
  • Programs booked by month
  • Total number of programs booked
  • Highest number of programs booked by Senior Adults
  • Free vs. Paid programs 
  • Premium Paid Members average saved 
  • and more.... 

 

CILC Quarterly Report (July - September 2017) $35.00 

 

FY17 (July 2016 - June 2017) Year Report $80.00 

 

CILC Statistics Bundle Includes the 4 quarterly reports & the yearly report $150.00 

     

 

 
 
 
 
 
FOR MORE INFORMATION

 

Contact Tami Moehring, Content Provider Liaison, 507-215-3705.

 


OUR CLIENTS SAY…

“This is awesome and definitely very, very useful.This information is also useful in our conversations with the Ohio Department of Education has they’re always inquiring about the impact and use of video conferencing throughout the state."

Ohio History Connection
Matt Schullek, Distance Learning Coordinator,
School and Teacher Programs

“This is so great! Thank you so much for putting this together. This is just the type of information we have been looking for."

Ann Arbor Hands-On Museum
Corrina Strecker, Distance Learning Manager
 

“I just wanted to let you know how much I appreciate having these stats reports. I now have something official to back up what I say."

 

Royal Botanical Gardens (Canada)
Karin Davidson-Taylor, Education Officer
 
 
FOLLOW US
ADDRESS
Center for Interactive Learning and Collaboration
2075 Lookout Drive
North Mankato, MN 56003
SUPPORT MENU
© 2016 Center for Interactive Learning and Collaboration Privacy Policy
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
1
(SELECT * FROM View_PageInfo WHERE ((NodeSiteID = 1) AND (DocumentUrlPath = N'/Resources/CILC-Program-Statistics') AND (DocumentUrlPath <> NodeAliasPath)))
UNION ALL
(SELECT TOP 2 * FROM View_PageInfo WHERE ((NodeSiteID = 1) AND (NodeAliasPath = N'/Resources/CILC-Program-Statistics') AND ([DocumentCulture] = N'en-US')))
Table (1 [67], 6.8 kB)
 
SimpleHandler`2.StartEvent 0.031
 
2
(cms.document.selectdocuments)
SELECT * FROM View_CMS_Tree_Joined WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/Resources', N'/')) AND [DocumentCulture] = @DocumentCulture ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
188 B
 
Table (2 [172], 12.6 kB)
 
SimpleHandler`2.StartEvent 0.000
 
3
(cms.menuitem.selectdocuments)
SELECT * FROM View_CONTENT_MenuItem_Joined WHERE ([DocumentCulture] = N'en-US') AND (NodeID = 1588)
Table (1 [176], 7.2 kB)
 
SimpleHandler`2.StartEvent 0.016
 
4
(cms.class.selectrequiredroles)
SELECT * FROM CMS_Role WHERE RoleID IN (SELECT RoleID FROM CMS_RolePermission WHERE PermissionID IN (SELECT PermissionID FROM CMS_Permission WHERE ClassID=@ClassID AND PermissionName=@PermissionName)) AND (SiteID=@SiteID OR SiteID IS NULL)
@ClassID (4609)
@PermissionName ("read")
@SiteID (1)
251 B
 
Table (1 [10], 112 B)
 
SimpleHandler`2.StartEvent 0.000
 
5
(cms.user.isauthorizedpernode)
Proc_CMS_User_IsAuthorizedPerNode
@UserID (65)
@NodeID (1588)
@PermissionName ("read")
@GenericRoles ("'_everyone_', '_notauthenticated_'")
@SiteID (1)
@Date (7/19/2018 12:22:08 PM)
91 B
 
SimpleHandler`2.StartEvent 0.000
 
6
(cms.acl.generalselect)
SELECT * FROM CMS_ACL WHERE [ACLID] = @ACLID
@ACLID (1)
48 B
 
Table (1 [6], 56 B)
 
SimpleHandler`2.StartEvent 0.016
 
7
(cms.aclitem.selectaclitemsbyaclidanduserid)
SELECT DISTINCT X.Allowed,X.Denied,X.ValidTo,X.ACLID
FROM (
SELECT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, null AS 'ValidTo',CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
WHERE
--User
(CMS_ACLItem.UserID IN (SELECT CMS_User.UserID FROM CMS_User JOIN CMS_UserSite ON CMS_User.UserID = CMS_UserSite.UserID
WHERE CMS_User.UserID = @UserID AND CMS_UserSite.SiteID = @SiteID )
-- Specific roles
OR CMS_ACLItem.RoleID IN (SELECT RoleID FROM CMS_Role WHERE RoleName IN ('_everyone_','_notauthenticated_'))
)
-- Membership
UNION ALL
SELECT DISTINCT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, UserRole.ValidTo, CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
INNER JOIN [View_CMS_UserRoleMembershipRole] AS UserRole ON UserRole.RoleID = CMS_ACLItem.RoleID
WHERE (UserRole.ValidTo > @Date OR UserRole.ValidTo IS NULL)
AND (UserRole.SiteID = @SiteID OR UserRole.SiteID IS NULL)
AND UserRole.UserID = @UserID
) AS X
WHERE ACLID IN (1)

@UserID (65)
@SiteID (1)
@Date (7/19/2018 12:22:08 PM)
1.2 kB
 
Table (1 [4], 16 B)
 
SimpleHandler`2.StartEvent 0.000
 
8
(cms.document.selectdocuments)
SELECT [ClassName], [DocumentCulture], [DocumentGUID], [DocumentModifiedWhen], [DocumentMenuCaption], [DocumentMenuClass], [DocumentMenuClassHighLighted], [DocumentMenuClassOver], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuItemImage], [DocumentMenuItemImageHighlighted], [DocumentMenuItemImageOver], [DocumentMenuItemInactive], [DocumentMenuItemLeftImage], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemLeftImageOver], [DocumentMenuItemRightImage], [DocumentMenuItemRightImageHighlighted], [DocumentMenuItemRightImageOver], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentMenuRedirectToFirstChild], [DocumentMenuStyle], [DocumentMenuStyleHighlighted], [DocumentMenuStyleOver], [DocumentName], [DocumentUrlPath], [NodeAliasPath], [NodeID], [NodeHasChildren], [NodeClassID], [NodeLevel], [NodeLinkedNodeID], [NodeParentID], [SiteName], [NodeACLID], [NodeSiteID], [NodeOwner], [NodeOrder], [NodeName], [DocumentSitemapSettings] FROM View_CMS_Tree_Joined WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/Resources/CILC-Program-Statistics', N'/Resources', N'/')) AND ([Published] = @Published AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture) ORDER BY NodeAliasPath DESC
@NodeSiteID (1)
@Published (True)
@NodeLevel (2)
@DocumentCulture ("en-US")
1.2 kB
 
Table (3 [42], 505 B)
 
CMSAbstractMenuProperties.OnLoad 0.000
 
  8 queries, 3.4 kB write, 27 kB read   0.062