Skip to content

tool for creating edx course offline using import/export function utilizing python script and excel sheet

Notifications You must be signed in to change notification settings

TokyoTechX-TAs/edx-coursebuilder

Repository files navigation

edx-coursebuilder

This tool is developed to provide an alternative approach for designing course outlines and adding course materials offline. The output (modified course) can be easily used to upload full-content course instance back to edx.studio with import function.

This tool consists of 4 parts

  1. a Python script which was developed based on EdX Open Learning XML(OLX) format. It consists of 3 functions.
  • create course outline.
  • add course contents.
  • upload videos to a YouTube channel. Detail available here
  1. an macro-excel file where information about course outline (Section, Subsection, and Unit), and course contents (text, quiz, and video) are contained. User requires to fill these information as a mean to design a course before running the code
  2. source files of course contents (text file, image file, video files, subtitle file, excel file)
  3. exmpty edX course instance exported from edx-studio

In a nutshell, this tool creates the course offline according to course information input into an Excel sheet which can be uploaded to the Open edX Studio using the export and then the import function. For example there are four sheets in an Excel file: course outline, text content blocks, assessment items, and videos. The names of course sections are typed in the order they appear in the course outline, HTML version of the text blocks and Excel cells containing the text and assessments respectively are input into the separate sheets, and a list of video files are input into a sheet consisting of YouTube video links and a list of closed captions .srt files that will be imported into the Open edX Studio course instance.

Please see the pptx or pdf file or youtube video https://youtu.be/5GWbH5eypvk for further information.

dependencies

  • xlrd, xlwt, pysrt

test environment

Python 3 run on Windows 10

About

tool for creating edx course offline using import/export function utilizing python script and excel sheet

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages