Difference between revisions of "ODEPO"

From Creative Commons
Jump to: navigation, search
Line 31: Line 31:
 
*[[Property:License short name | License short name]]
 
*[[Property:License short name | License short name]]
 
*[[Property:License | License (url)]]
 
*[[Property:License | License (url)]]
 +
 +
==Metrics==
 +
 +
Here you will find various collections of data extracted from ODEPO.
 +
 +
 +
Number of pages with "License short name" as one of the CC licenses: {{#arraydefine: ccsum|{{#expr: {{#ask: [[Category:Organization]][[License short name::CC BY]]|format=count}} + {{#ask: [[Category:Organization]][[License short name::CC BY-NC]]|format=count}} + {{#ask: [[Category:Organization]][[License short name::CC BY-SA]]|format=count}} + {{#ask: [[Category:Organization]][[License short name::CC BY-NC-SA]]|format=count}} + {{#ask: [[Category:Organization]][[License short name::CC BY-NC-ND]]|format=count}} + {{#ask: [[Category:Organization]][[License short name::CC BY-ND]]|format=count}}}}}}{{#arrayprint: ccsum}}
 +
 +
Out of {{#arraydefine: odeposum|{{#ask: [[Category:Organization]]|format=count}}}}{{#arrayprint: odeposum}} sites in ODEPO, {{#arrayprint: ccsum}} are marked as using one of the size CC licenses in the "License short name" field. That is {{#expr: ({{#arrayprint: ccsum}} / {{#arrayprint: odeposum}}) * 100 }}%.
 +
 +
Out of {{#arrayprint: odeposum}} sites in ODEPO, {{#arraydefine: cclpcountorgs|{{#ask: [[Category:Organization]][[License provider::CC]]|format=count}}}}{{#arrayprint: cclpcountorgs}} organizations are marked as using CC as their license provider in the "License provider" field. That is {{#expr: ({{#arrayprint: cclpcountorgs}} / {{#arrayprint: odeposum}}) * 100 }}%.
 +
 +
Out of {{#arrayprint: odeposum}} sites in ODEPO,  '''{{#arraydefine: cclporgs|{{#ask:[[Category:Organization]][[License provider::CC]]|sep =,|link=none}} |,|unique}}{{#arraydefine: ccsnorgs|{{#ask:[[Category:Organization]][[License short name::CC BY]]|link=none|sep=,}},{{#ask:[[Category:Organization]][[License short name::CC BY-NC]]|link=none|sep=,}},{{#ask:[[Category:Organization]][[License short name::CC BY-SA]]|link=none|sep=,}},{{#ask:[[Category:Organization]][[License short name::CC BY-ND]]|link=none|sep=,}},{{#ask:[[Category:Organization]][[License short name::CC BY-ND]]|link=none|sep=,}},{{#ask:[[Category:Organization]][[License short name::CC BY-NC-SA]]|link=none|sep=,}},{{#ask:[[Category:Organization]][[License short name::CC BY-NC-ND]]|link=none|sep=,}} |,|unique}}{{#arraymerge: ccuniqueorgs|cclporgs|ccsnorgs}}{{#arrayunique:ccuniqueorgs}}{{#arraysize: ccuniqueorgs}}''' organizations that are marked as either using one of the six CC licenses in the "License short name" field or using CC as a license provider in the "License provider" field (duplicates removed). That is {{#expr: ({{#arraysize: ccuniqueorgs}} / {{#arrayprint: odeposum}}) * 100 }}%.
 +
 +
<hr />
 +
 +
Number of self-described "open" sites in ODEPO: {{#arraydefine: opensum|{{#ask: [[Category:Organization]][[Open or Free Statement::yes]]|format=count}}}}{{#arrayprint: opensum}}
 +
 +
Out of {{#arrayprint: odeposum}} sites in ODEPO, {{#arrayprint: opensum}} are self-described as "open". That is {{#expr: ({{#arrayprint: opensum}} / {{#arrayprint: odeposum}}) * 100 }}%
 +
 +
=== Semantic MediaWiki Guides ===
 +
 +
[http://semantic-mediawiki.org/wiki/Help:Inline_queries Inline-queries SMW help page]<br>
 +
[http://semantic-mediawiki.org/wiki/Image:SMW_quick_reference.pdf SMW quick reference]
 +
 +
=== License usage  ===
 +
 +
{{#ask: [[Category:LicenseData]][[License count::+]]
 +
| ?License count = Number of Orgs
 +
| mainlabel= License
 +
| format=table
 +
|sort=License count
 +
|order=descending
 +
| link=subject}}
 +
 +
Download: '''{{#ask: [[Category:LicenseData]][[License count::+]]
 +
| ?License count = Number of sites
 +
| mainlabel= License
 +
| format=csv
 +
|sort=License count
 +
|order=descending}}'''
 +
 +
=== License usage by "[[Property:Open_or_Free_Statement |open]]" sites ===
 +
 +
{{#ask: [[Category:LicenseData]][[Open license count::+]]
 +
| mainlabel= License
 +
| ?Open license count = Number of Orgs
 +
| format=table
 +
| sort=Open license count
 +
| order=descending
 +
| link=subject}}
 +
 +
Download:  '''{{#ask: [[Category:LicenseData]][[Open license count::+]]
 +
| mainlabel= License
 +
| ?Open license count = Number of Orgs
 +
| format=csv
 +
| sort=Open license count
 +
| order=descending }}'''
 +
 +
=== CC license usage ===
 +
 +
{{#ask: [[Category:LicenseData]] [[isitcc::yes]]
 +
| mainlabel= License
 +
| ?License count = Number of Orgs
 +
| format=table
 +
|sort=License count
 +
|order=descending
 +
|link=subject}}
 +
 +
'''Total:''' {{#arraydefine: ccsum|{{#expr: {{#ask: [[Category:Organization]][[License short name::CC BY]]|format=count}} + {{#ask: [[Category:Organization]][[License short name::CC BY-NC]]|format=count}} + {{#ask: [[Category:Organization]][[License short name::CC BY-SA]]|format=count}} + {{#ask: [[Category:Organization]][[License short name::CC BY-NC-SA]]|format=count}} + {{#ask: [[Category:Organization]][[License short name::CC BY-NC-ND]]|format=count}} + {{#ask: [[Category:Organization]][[License short name::CC BY-ND]]|format=count}}}}}}{{#arrayprint: ccsum}}
 +
 +
Out of {{#arraydefine: odeposum|{{#ask: [[Category:Organization]]|format=count}}}}{{#arrayprint: odeposum}} sites in ODEPO, {{#arrayprint: ccsum}} are marked as using CC licenses. That is {{#expr: ({{#arrayprint: ccsum}} / {{#arrayprint: odeposum}}) * 100 }}%.
 +
 +
Download: '''{{#ask: [[Category:LicenseData]] [[isitcc::yes]]
 +
| mainlabel= License
 +
| ?License count = Number of Orgs
 +
| format=csv
 +
|sort=License count
 +
|order=descending}}'''
 +
 +
=== CC license usage by "[[Property:Open_or_Free_Statement |open]]" sites ===
 +
 +
{{#ask: [[Category:LicenseData]] [[isitcc::yes]]
 +
| mainlabel= License
 +
| ?Open license count = Number of Orgs
 +
| format=table
 +
|sort=Open license count
 +
|order=descending
 +
|link=subject}}
 +
 +
Download: '''{{#ask: [[Category:LicenseData]] [[isitcc::yes]]
 +
| mainlabel= License
 +
| ?Open license count = Number of Orgs
 +
| format=csv
 +
|sort=Open license count
 +
|order=descending}}'''
 +
 +
=== Data by Org. type ===
 +
'''University'''
 +
{| border=1
 +
!Organization Type
 +
!Total sites
 +
!"Open" sites
 +
!"Open" w/CC license provider
 +
!"Open" w/custom license
 +
!with CC license provider
 +
!with custom license
 +
|-
 +
| university
 +
{{OER_Data|university}}
 +
|-
 +
| college
 +
{{OER_Data|college}}
 +
|-
 +
| university system
 +
{{OER_Data|university system}}
 +
|-
 +
|Public University
 +
{{OER_Data|Public University}}
 +
|-
 +
| Total (minus duplicates)
 +
|{{#ask: [[Category:Organization]][[Organization Type::university]] OR [[Organization Type::college]] OR [[Organization Type::university system]] OR [[Organization Type::Public University]]|format=count}}
 +
|-
 +
<!-- | Totals (minus duplicates)
 +
| | {{#ask: [[Category:Organization]][[Organization Type::university]] OR [[Organization Type::college]] OR [[Organization Type::university system]] OR [[Organization Type::Public University]]|format=count}}
 +
| {{#ask: [[Category:Organization]][[Organization Type::university]][[Open or Free Statement::yes]] OR [[Organization Type::college]][[Open or Free Statement::yes]] OR [[Organization Type::university system]][[Open or Free Statement::yes]] OR [[Organization Type::Public University]][[Open or Free Statement::yes]]|format=count}}
 +
| {{#ask: [[Category:Organization]][[Organization Type::university]][[Open or Free Statement::yes]][[License provider::CC]] OR [[Organization Type::college]][[Open or Free Statement::yes]][[License provider::CC]] OR [[Organization Type::university system]][[Open or Free Statement::yes]][[License provider::CC]] OR [[Organization Type::Public University]][[Open or Free Statement::yes]][[License provider::CC]] OR |format=count}}
 +
| {{#ask: [[Category:Organization]][[Organization Type::university]][[Open or Free Statement::yes]][[License provider::custom]] OR [[Organization Type::college]][[Open or Free Statement::yes]][[License provider::custom]] OR [[Organization Type::university system]][[Open or Free Statement::yes]][[License provider::custom]] OR [[Organization Type::Public University]][[Open or Free Statement::yes]][[License provider::custom]]|format=count}}
 +
| {{#ask: [[Category:Organization]][[Organization Type::university]][[License provider::CC]] OR [[Organization Type::college]][[License provider::CC]] OR [[Organization Type::university system]][[License provider::CC]] OR [[Organization Type::Public University]][[License provider::CC]]|format=count}}
 +
| {{#ask: [[Category:Organization]][[Organization Type::university]][[License provider::custom]] OR [[Organization Type::college]][[License provider::custom]] OR [[Organization Type::university system]][[License provider::custom]] OR [[Organization Type::Public University]][[License provider::custom]]|format=count}} -->
 +
|}
 +
<br>
 +
'''Government'''
 +
{| border=1
 +
!Organization Type
 +
!Total sites
 +
!"Open" sites
 +
!"Open" w/CC license provider
 +
!"Open" w/custom license
 +
!with CC license provider
 +
!with custom license
 +
|-
 +
| US government
 +
{{OER_Data|US government}}
 +
|-
 +
| Total (minus duplicates)
 +
|{{#ask: [[Category:Organization]][[Organization Type::US government]]|format=count}}
 +
|-
 +
|}
 +
<br>
 +
'''Primary/Secondary Education'''
 +
{| border=1
 +
!Organization Type
 +
!Total sites
 +
!"Open" sites
 +
!"Open" w/CC license provider
 +
!"Open" w/custom license
 +
!with CC license provider
 +
!with custom license
 +
|-
 +
| high school
 +
{{OER_Data|high school}}
 +
|-
 +
| school district
 +
{{OER_Data|school district}}
 +
|-
 +
| Total (minus duplicates)
 +
|{{#ask: [[Category:Organization]][[Organization Type::high school]] OR [[Category:Organization]][[Organization Type::school district]] |format=count}}
 +
|-
 +
|}
 +
<br>
 +
'''Non-profit/NGO'''
 +
{| border=1
 +
!Organization Type
 +
!Total sites
 +
!"Open" sites
 +
!"Open" w/CC license provider
 +
!"Open" w/custom license
 +
!with CC license provider
 +
!with custom license
 +
|-
 +
| nonprofit
 +
{{OER_Data|nonprofit}}
 +
|-
 +
| NGO
 +
{{OER_Data|NGO}}
 +
|-
 +
| nonprofit site
 +
{{OER_Data|nonprofit site}}
 +
|-
 +
| consortium
 +
{{OER_Data|consortium}}
 +
|-
 +
| foundation
 +
{{OER_Data|foundation}}
 +
|-
 +
| professional association
 +
{{OER_Data|professional association}}
 +
|-
 +
| professional society
 +
{{OER_Data|professional society}}
 +
|-
 +
| educational organization
 +
{{OER_Data|educational organization}}
 +
|-
 +
| museum
 +
{{OER_Data|museum}}
 +
|-
 +
| Total (minus duplicates)
 +
|{{#ask: [[Category:Organization]][[Organization Type::nonprofit]] OR [[Category:Organization]][[Organization Type::NGO]] OR [[Category:Organization]][[Organization Type::nonprofit site]] OR [[Category:Organization]][[Organization Type::consortium]] OR [[Category:Organization]][[Organization Type::foundation]] OR [[Category:Organization]][[Organization Type::professional association]] OR [[Category:Organization]][[Organization Type::professional society]] OR [[Category:Organization]][[Organization Type::educational organization]]      |format=count}}
 +
|-
 +
|}
 +
<br>
 +
'''Commercial/For Profit'''
 +
{| border=1
 +
!Organization Type
 +
!Total sites
 +
!"Open" sites
 +
!"Open" w/CC license provider
 +
!"Open" w/custom license
 +
!with CC license provider
 +
!with custom license
 +
|-
 +
| commercial
 +
{{OER_Data|commercial}}
 +
|-
 +
| commercial company
 +
{{OER_Data|commercial company}}
 +
|-
 +
| corporation
 +
{{OER_Data|corporation}}
 +
|-
 +
| environmental company
 +
{{OER_Data|environmental company}}
 +
|-
 +
| private company
 +
{{OER_Data|private company}}
 +
|-
 +
| Total (minus duplicates)
 +
|{{#ask: [[Category:Organization]][[Organization Type::commercial]] OR [[Category:Organization]][[Organization Type::commercial company]] OR [[Category:Organization]][[Organization Type::corporation]] OR [[Category:Organization]][[Organization Type::environmental company]] OR [[Category:Organization]][[Organization Type::private company]]    |format=count}}
 +
|-
 +
|}
 +
<br>
 +
'''Rich Media'''
 +
{| border=1
 +
!Organization Type
 +
!Total sites
 +
!"Open" sites
 +
!"Open" w/CC license provider
 +
!"Open" w/custom license
 +
!with CC license provider
 +
!with custom license
 +
|-
 +
| media company
 +
{{OER_Data|media company}}
 +
|-
 +
| Total (minus duplicates)
 +
|{{#ask: [[Category:Organization]][[Organization Type::media company]]|format=count}}
 +
|-
 +
|}
 +
<br>
 +
<br>
 +
 +
=== Org types ===
 +
 +
{{#arraydefine:orgtypes|{{#ask:[[Organization Type::+]][[:+]] |?Organization Type= |mainlabel=- |sep =, |limit=1500}} |,|unique}}
 +
{{#arraysort:orgtypes|asce}}
 +
{{#arrayprint:orgtypes}}
 +
 +
=== License usage by Government sites ===
 +
 +
{{#ask: [[Category:LicenseData]] | mainlabel = License type | ?usgovuse = US Gov.}}
 +
 +
Download: '''{{#ask: [[Category:LicenseData]] | mainlabel = License type | ?usgovuse = US Gov| format=csv}}'''
 +
 +
<!-- === List of URLs ===
 +
 +
{{#ask: [[Category:Organization]][[Mainurl::+]] | ?Mainurl | format=csv | limit=1500}}-->
 +
 +
=== License usage by Org type ===
 +
 +
== Organizations in ODEPO missing Organization types ==
 +
 +
There are currently {{#ask:[[Category:Organization]][[Organization Type count::0]] | format=count}} organizations in ODEPO missing Organization Type values.
 +
 +
{{#ask:[[Category:Organization]][[Organization Type count::0]] | format= ul}}

Revision as of 23:48, 16 February 2010

Open Database of Educational Projects and Organizations

ODEPO (Open Database of Educational Projects and Organizations) is an interactive semantic database for individuals and organizations involved in education. Currently, ODEPO includes more than 1,000 sites affiliated with various organizations, the majority of which were provided to us by educational repositories involved in the creation and expansion of Open Educational Resources (OER). If you find that a project or organization is missing, we invite you to create a wiki account and add your own page.

463px-License-mapping-report-image.jpg

"What status for open? An examination of the licensing policies of open educational organizations and projects," ccLearn's licensing report, and related supplements, were based on data compiled in ODEPO. You can find data related to this data supplement on the OER Data page.



Browse by property

This is a list of the types of information we have for each site, also known as properties.

Metrics

Here you will find various collections of data extracted from ODEPO.


Number of pages with "License short name" as one of the CC licenses: {{#arraydefine: ccsum|{{#expr: {{#ask:License short name::CC BY|format=count}} + {{#ask:License short name::CC BY-NC|format=count}} + {{#ask:License short name::CC BY-SA|format=count}} + {{#ask:License short name::CC BY-NC-SA|format=count}} + {{#ask:License short name::CC BY-NC-ND|format=count}} + {{#ask:License short name::CC BY-ND|format=count}}}}}}{{#arrayprint: ccsum}}

Out of {{#arraydefine: odeposum|{{#ask:|format=count}}}}{{#arrayprint: odeposum}} sites in ODEPO, {{#arrayprint: ccsum}} are marked as using one of the size CC licenses in the "License short name" field. That is {{#expr: ({{#arrayprint: ccsum}} / {{#arrayprint: odeposum}}) * 100 }}%.

Out of {{#arrayprint: odeposum}} sites in ODEPO, {{#arraydefine: cclpcountorgs|{{#ask:License provider::CC|format=count}}}}{{#arrayprint: cclpcountorgs}} organizations are marked as using CC as their license provider in the "License provider" field. That is {{#expr: ({{#arrayprint: cclpcountorgs}} / {{#arrayprint: odeposum}}) * 100 }}%.

Out of {{#arrayprint: odeposum}} sites in ODEPO, {{#arraydefine: cclporgs|{{#ask:License provider::CC|sep =,|link=none}} |,|unique}}{{#arraydefine: ccsnorgs|{{#ask:License short name::CC BY|link=none|sep=,}},{{#ask:License short name::CC BY-NC|link=none|sep=,}},{{#ask:License short name::CC BY-SA|link=none|sep=,}},{{#ask:License short name::CC BY-ND|link=none|sep=,}},{{#ask:License short name::CC BY-ND|link=none|sep=,}},{{#ask:License short name::CC BY-NC-SA|link=none|sep=,}},{{#ask:License short name::CC BY-NC-ND|link=none|sep=,}} |,|unique}}{{#arraymerge: ccuniqueorgs|cclporgs|ccsnorgs}}{{#arrayunique:ccuniqueorgs}}{{#arraysize: ccuniqueorgs}} organizations that are marked as either using one of the six CC licenses in the "License short name" field or using CC as a license provider in the "License provider" field (duplicates removed). That is {{#expr: ({{#arraysize: ccuniqueorgs}} / {{#arrayprint: odeposum}}) * 100 }}%.

Number of self-described "open" sites in ODEPO: {{#arraydefine: opensum|{{#ask:Open or Free Statement::yes|format=count}}}}{{#arrayprint: opensum}}

Out of {{#arrayprint: odeposum}} sites in ODEPO, {{#arrayprint: opensum}} are self-described as "open". That is {{#expr: ({{#arrayprint: opensum}} / {{#arrayprint: odeposum}}) * 100 }}%

Semantic MediaWiki Guides

Inline-queries SMW help page
SMW quick reference

License usage

{{#ask:License count::+ | ?License count = Number of Orgs | mainlabel= License | format=table |sort=License count |order=descending | link=subject}}

Download: {{#ask:License count::+ | ?License count = Number of sites | mainlabel= License | format=csv |sort=License count |order=descending}}

License usage by "open" sites

{{#ask:Open license count::+ | mainlabel= License | ?Open license count = Number of Orgs | format=table | sort=Open license count | order=descending | link=subject}}

Download: {{#ask:Open license count::+ | mainlabel= License | ?Open license count = Number of Orgs | format=csv | sort=Open license count | order=descending }}

CC license usage

{{#ask: isitcc::yes | mainlabel= License | ?License count = Number of Orgs | format=table |sort=License count |order=descending |link=subject}}

Total: {{#arraydefine: ccsum|{{#expr: {{#ask:License short name::CC BY|format=count}} + {{#ask:License short name::CC BY-NC|format=count}} + {{#ask:License short name::CC BY-SA|format=count}} + {{#ask:License short name::CC BY-NC-SA|format=count}} + {{#ask:License short name::CC BY-NC-ND|format=count}} + {{#ask:License short name::CC BY-ND|format=count}}}}}}{{#arrayprint: ccsum}}

Out of {{#arraydefine: odeposum|{{#ask:|format=count}}}}{{#arrayprint: odeposum}} sites in ODEPO, {{#arrayprint: ccsum}} are marked as using CC licenses. That is {{#expr: ({{#arrayprint: ccsum}} / {{#arrayprint: odeposum}}) * 100 }}%.

Download: {{#ask: isitcc::yes | mainlabel= License | ?License count = Number of Orgs | format=csv |sort=License count |order=descending}}

CC license usage by "open" sites

{{#ask: isitcc::yes | mainlabel= License | ?Open license count = Number of Orgs | format=table |sort=Open license count |order=descending |link=subject}}

Download: {{#ask: isitcc::yes | mainlabel= License | ?Open license count = Number of Orgs | format=csv |sort=Open license count |order=descending}}

Data by Org. type

University

Organization Type Total sites "Open" sites "Open" w/CC license provider "Open" w/custom license with CC license provider with custom license
university

Template:OER Data
college

Template:OER Data
university system

Template:OER Data
Public University

Template:OER Data
Total (minus duplicates) {{#ask:Organization Type::university OR Organization Type::college OR Organization Type::university system OR Organization Type::Public University|format=count}}


Government

Organization Type Total sites "Open" sites "Open" w/CC license provider "Open" w/custom license with CC license provider with custom license
US government

Template:OER Data
Total (minus duplicates) {{#ask:Organization Type::US government|format=count}}


Primary/Secondary Education

Organization Type Total sites "Open" sites "Open" w/CC license provider "Open" w/custom license with CC license provider with custom license
high school

Template:OER Data
school district

Template:OER Data
Total (minus duplicates) {{#ask:Organization Type::high school OROrganization Type::school district |format=count}}


Non-profit/NGO

Organization Type Total sites "Open" sites "Open" w/CC license provider "Open" w/custom license with CC license provider with custom license
nonprofit

Template:OER Data
NGO

Template:OER Data
nonprofit site

Template:OER Data
consortium

Template:OER Data
foundation

Template:OER Data
professional association

Template:OER Data
professional society

Template:OER Data
educational organization

Template:OER Data
museum

Template:OER Data
Total (minus duplicates) {{#ask:Organization Type::nonprofit OROrganization Type::NGO OROrganization Type::nonprofit site OROrganization Type::consortium OROrganization Type::foundation OROrganization Type::professional association OROrganization Type::professional society OROrganization Type::educational organization |format=count}}


Commercial/For Profit

Organization Type Total sites "Open" sites "Open" w/CC license provider "Open" w/custom license with CC license provider with custom license
commercial

Template:OER Data
commercial company

Template:OER Data
corporation

Template:OER Data
environmental company

Template:OER Data
private company

Template:OER Data
Total (minus duplicates) {{#ask:Organization Type::commercial OROrganization Type::commercial company OROrganization Type::corporation OROrganization Type::environmental company OROrganization Type::private company |format=count}}


Rich Media

Organization Type Total sites "Open" sites "Open" w/CC license provider "Open" w/custom license with CC license provider with custom license
media company

Template:OER Data
Total (minus duplicates) {{#ask:Organization Type::media company|format=count}}



Org types

{{#arraydefine:orgtypes|{{#ask:Organization Type::++ |?Organization Type= |mainlabel=- |sep =, |limit=1500}} |,|unique}} {{#arraysort:orgtypes|asce}} {{#arrayprint:orgtypes}}

License usage by Government sites

{{#ask: | mainlabel = License type | ?usgovuse = US Gov.}}

Download: {{#ask: | mainlabel = License type | ?usgovuse = US Gov| format=csv}}


License usage by Org type

Organizations in ODEPO missing Organization types

There are currently {{#ask:Organization Type count::0 | format=count}} organizations in ODEPO missing Organization Type values.

{{#ask:Organization Type count::0 | format= ul}}

Retrieved from "https://wiki.creativecommons.org/index.php?title=ODEPO&oldid=31099"