Export

Page Contents:

Description

The Open Education Data Dashboard provides access to your data through the Exports Shortcut. There are three different ways to access your data:

Airtable - you can download your data into an Airtable Template which will have several different reports set up for you.
Google Sheets - you can download your data into Google Sheets and use the built-in table formatting to create different reports.
Download - you can download .csv files and build out your own reports with your own specifications.

All export options can help your report on specific metrics including:

Student Savings
Students Impacted
Faculty Using OERs
OER Used in Courses
Program Success
Open Textbook Reviews
Activity Requests
Survey Responses
Tags

Airtable

To get started with Airtable, you'll first need to have and/or create an account.

The Setup Instructions will walk you through how to retrieve and input your access token, base, and access the OEN's template from Airtable Universe.

Note: free Airtable accounts have a limit of 1,000 records across an entire base. Your Dashboard will let you know how many rows your export will contain so you can decide if Airtable is the right export option for you.

Google Sheets

To get started with Google Sheets, you'll first need to have and/or create a Google account. When you press the Export button you'll need to login to your Google account and authorize the OEN Dashboard access to write to your Google Drive.

Once the Export is complete, you can login to Google Sheets in a new tab and find the resulting spreadsheet. You can use Google Sheets' built-in chart maker to create charts and graphs to display your data in meaningful ways for your needs.

Download

In the Download tab you'll be able to access .csv files for all the data within your Dashboard by:

Full Institution Data (for Consortia/Systems)
Faculty Data (by All Faculty, All Groups, and individual Group)
Event Data (by All Events, All Registrations, and individual Events)
Review Data (by All Review Requests, by All Review Request Recipients, and by individual Review Requests)
Adoption Data (by All Courses, by All Textbook Adoptions, by All Enrollments, and by All Terms)
Tag Data (by All Tags, by individual Tags)

You can upload these .csv files to any reporting software you like and create reports and metrics that work for your context.

Page updated

Report abuse