ODEPO

From Creative Commons
Revision as of 00:48, 17 February 2010 by Akozak (talk | contribs)
Jump to: navigation, search

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}}