def index(request, course_id):
# Request data
course_key = get_course_key(course_id)
course = get_course_module(course_key)
user = request.user
staff_access = has_access(request.user, 'staff', course)
instructor_access = has_access(request.user, 'instructor', course)
masq = setup_masquerade(request, staff_access) # allow staff to toggle masquerade on info page
studio_url = get_studio_url(course, 'course_info')
reverifications = fetch_reverify_banner_info(request, course_key)
#course = get_course_with_access(request.user, action='load', course_key=course_key, depth=None, check_if_enrolled=False)
# Proficiency and pass limit
pass_limit = get_course_grade_cutoff(course)
proficiency_limit = (1 - pass_limit) / 2 + pass_limit
usernames_in = []
for student in CourseEnrollment.users_enrolled_in(course_key):
usernames_in.append(student.username.encode('utf-8'))
# Data for visualization in JSON
user_for_charts = '#average' if (staff_access or instructor_access) else user
kwargs = {
'qualifiers': {'category': 'video', },
}
# This returns video descriptors in the order they appear on the course
video_descriptors = videos_problems_in(course)[0]
video_durations = get_info_videos_descriptors(video_descriptors)[2]
video_ids_str = []
course_video_names = []
for descriptor in video_descriptors:
video_ids_str.append((course_key.make_usage_key('video', descriptor.location.name))._to_string())
course_video_names.append(descriptor.display_name_with_default)
if len(video_descriptors) > 0:
first_video_id = course_key.make_usage_key('video', video_descriptors[0].location.name)
# Video progress visualization. Video percentage seen total and non-overlapped.
video_names, avg_video_time, video_percentages = get_module_consumption(user_for_charts, course_key, 'video', 'video_progress')
if avg_video_time != []:
all_video_time_percent = map(truediv, avg_video_time, video_durations)
all_video_time_percent = [int(round(x*100,0)) for x in all_video_time_percent]
else:
all_video_time_percent = avg_video_time
column_headers = ['Video', 'Different video time', 'Total video time']
video_prog_json = ready_for_arraytodatatable(column_headers, video_names, video_percentages, all_video_time_percent)
video_names, all_video_time = get_module_consumption(user_for_charts, course_key, 'video', 'total_time_vid_prob')[0:2]
# Time spent on every video resource
column_headers = ['Video', 'Time watched']
video_distrib_json = ready_for_arraytodatatable(column_headers, video_names, all_video_time)
# Video events dispersion within video length
scatter_array = get_video_events_info(user_for_charts, first_video_id)
# Repetitions per video intervals
user_for_vid_intervals = '#class_total_times' if user_for_charts == '#average' else user_for_charts
video_intervals_array = get_user_video_intervals(user_for_vid_intervals, first_video_id)
# Case no videos in course
else:
video_names = None
video_prog_json = simplejson.dumps(None)
video_distrib_json = simplejson.dumps(None)
scatter_array = simplejson.dumps(None)
video_intervals_array = simplejson.dumps(None)
# Time spent on every problem resource
problem_names, time_x_problem = get_module_consumption(user_for_charts, course_key, 'problem', 'total_time_vid_prob')[0:2]
column_headers = ['Problem', 'Time on problem']
problem_distrib_json = ready_for_arraytodatatable(column_headers, problem_names, time_x_problem)
# Daily time spent on video and/or problem resources
video_days, video_daily_time = get_daily_consumption(user_for_charts, course_key, 'video')
problem_days, problem_daily_time = get_daily_consumption(user_for_charts, course_key, 'problem')
vid_and_prob_daily_time = join_video_problem_time(video_days, video_daily_time, problem_days, problem_daily_time)
#Analytics visualizations
if staff_access or instructor_access:
# Instructor access
std_sort = get_DB_sort_course_homework(course_key)
# Chapter time
cs, st = get_DB_course_spent_time(course_key, student_id=ALL_STUDENTS)
students_spent_time = chapter_time_to_js(cs, st)
students_grades = get_DB_student_grades(course_key, student_id=ALL_STUDENTS)
cs, sa = course_accesses = get_DB_course_section_accesses(course_key, student_id=ALL_STUDENTS)
students_course_accesses = course_accesses_to_js(cs, sa)
students_prob_vid_progress = get_DB_course_video_problem_progress(course_key, student_id=ALL_STUDENTS)
students_time_schedule = get_DB_time_schedule(course_key, student_id=ALL_STUDENTS)
else:
# Sort homework
# Chapter time
std_sort = None
cs, st = get_DB_course_spent_time(course_key, user.id)
students_spent_time = chapter_time_to_js(cs, st)
students_grades = get_DB_student_grades(course_key, user.id)
cs, sa = course_accesses = get_DB_course_section_accesses(course_key, user.id)
students_course_accesses = course_accesses_to_js(cs, sa)
students_time_schedule = get_DB_time_schedule(course_key, user.id)
students_prob_vid_progress = get_DB_course_video_problem_progress(course_key, user.id)
context = {'course': course,
'request': request,
'user': user,
'user_id': user.id,
'staff_access': staff_access,
'instructor_access': instructor_access,
'masquerade': masq,
'studio_url': studio_url,
'reverifications': reverifications,
'course_id': course_id,
'students': students_to_js(get_course_students(course_key)),
'visualizations_id': VISUALIZATIONS_ID,
'std_grades_dump': dumps(students_grades),
'sort_std_dump': dumps(std_sort),
'time_dump': dumps(students_spent_time),
'accesses_dump': dumps(students_course_accesses),
'std_time_schedule_dumb': dumps(students_time_schedule),
'vid_prob_prog_dump': dumps(students_prob_vid_progress),
'pass_limit': pass_limit,
'prof_limit': proficiency_limit,
'usernames_in' : usernames_in,
'video_names' : course_video_names,
'video_ids' : video_ids_str,
'video_prog_json' : video_prog_json,
'video_distrib_json' : video_distrib_json,
'problem_distrib_json' : problem_distrib_json,
'video_intervals_array' : video_intervals_array,
'vid_and_prob_daily_time' : vid_and_prob_daily_time,
'scatter_array' : scatter_array, }
return render_to_response('learning_analytics/learning_analytics.html', context)
def index(request, course_id):
# Request data
course_key = get_course_key(course_id)
course = get_course_module(course_key)
user = request.user
staff_access = has_access(request.user, 'staff', course)
instructor_access = has_access(request.user, 'instructor', course)
masq = setup_masquerade(
request, staff_access) # allow staff to toggle masquerade on info page
studio_url = get_studio_url(course, 'course_info')
reverifications = fetch_reverify_banner_info(request, course_key)
#course = get_course_with_access(request.user, action='load', course_key=course_key, depth=None, check_if_enrolled=False)
# Proficiency and pass limit
pass_limit = get_course_grade_cutoff(course)
proficiency_limit = (1 - pass_limit) / 2 + pass_limit
usernames_in = []
for student in CourseEnrollment.users_enrolled_in(course_key):
usernames_in.append(student.username.encode('utf-8'))
# Data for visualization in JSON
user_for_charts = '#average' if (staff_access
or instructor_access) else user
kwargs = {
'qualifiers': {
'category': 'video',
},
}
# This returns video descriptors in the order they appear on the course
video_descriptors = videos_problems_in(course)[0]
video_durations = get_info_videos_descriptors(video_descriptors)[2]
video_ids_str = []
course_video_names = []
for descriptor in video_descriptors:
video_ids_str.append(
(course_key.make_usage_key('video',
descriptor.location.name))._to_string())
course_video_names.append(descriptor.display_name_with_default)
if len(video_descriptors) > 0:
first_video_id = course_key.make_usage_key(
'video', video_descriptors[0].location.name)
# Video progress visualization. Video percentage seen total and non-overlapped.
video_names, avg_video_time, video_percentages = get_module_consumption(
user_for_charts, course_key, 'video', 'video_progress')
if avg_video_time != []:
all_video_time_percent = map(truediv, avg_video_time,
video_durations)
all_video_time_percent = [
int(round(x * 100, 0)) for x in all_video_time_percent
]
else:
all_video_time_percent = avg_video_time
column_headers = ['Video', 'Different video time', 'Total video time']
video_prog_json = ready_for_arraytodatatable(column_headers,
video_names,
video_percentages,
all_video_time_percent)
video_names, all_video_time = get_module_consumption(
user_for_charts, course_key, 'video', 'total_time_vid_prob')[0:2]
# Time spent on every video resource
column_headers = ['Video', 'Time watched']
video_distrib_json = ready_for_arraytodatatable(
column_headers, video_names, all_video_time)
# Video events dispersion within video length
scatter_array = get_video_events_info(user_for_charts, first_video_id)
# Repetitions per video intervals
user_for_vid_intervals = '#class_total_times' if user_for_charts == '#average' else user_for_charts
video_intervals_array = get_user_video_intervals(
user_for_vid_intervals, first_video_id)
# Case no videos in course
else:
video_names = None
video_prog_json = simplejson.dumps(None)
video_distrib_json = simplejson.dumps(None)
scatter_array = simplejson.dumps(None)
video_intervals_array = simplejson.dumps(None)
# Time spent on every problem resource
problem_names, time_x_problem = get_module_consumption(
user_for_charts, course_key, 'problem', 'total_time_vid_prob')[0:2]
column_headers = ['Problem', 'Time on problem']
problem_distrib_json = ready_for_arraytodatatable(column_headers,
problem_names,
time_x_problem)
# Daily time spent on video and/or problem resources
video_days, video_daily_time = get_daily_consumption(
user_for_charts, course_key, 'video')
problem_days, problem_daily_time = get_daily_consumption(
user_for_charts, course_key, 'problem')
vid_and_prob_daily_time = join_video_problem_time(video_days,
video_daily_time,
problem_days,
problem_daily_time)
#Analytics visualizations
if staff_access or instructor_access:
# Instructor access
std_sort = get_DB_sort_course_homework(course_key)
# Chapter time
cs, st = get_DB_course_spent_time(course_key, student_id=ALL_STUDENTS)
students_spent_time = chapter_time_to_js(cs, st)
students_grades = get_DB_student_grades(course_key,
student_id=ALL_STUDENTS)
cs, sa = course_accesses = get_DB_course_section_accesses(
course_key, student_id=ALL_STUDENTS)
students_course_accesses = course_accesses_to_js(cs, sa)
students_prob_vid_progress = get_DB_course_video_problem_progress(
course_key, student_id=ALL_STUDENTS)
students_time_schedule = get_DB_time_schedule(course_key,
student_id=ALL_STUDENTS)
else:
# Sort homework
# Chapter time
std_sort = None
cs, st = get_DB_course_spent_time(course_key, user.id)
students_spent_time = chapter_time_to_js(cs, st)
students_grades = get_DB_student_grades(course_key, user.id)
cs, sa = course_accesses = get_DB_course_section_accesses(
course_key, user.id)
students_course_accesses = course_accesses_to_js(cs, sa)
students_time_schedule = get_DB_time_schedule(course_key, user.id)
students_prob_vid_progress = get_DB_course_video_problem_progress(
course_key, user.id)
context = {
'course': course,
'request': request,
'user': user,
'user_id': user.id,
'staff_access': staff_access,
'instructor_access': instructor_access,
'masquerade': masq,
'studio_url': studio_url,
'reverifications': reverifications,
'course_id': course_id,
'students': students_to_js(get_course_students(course_key)),
'visualizations_id': VISUALIZATIONS_ID,
'std_grades_dump': dumps(students_grades),
'sort_std_dump': dumps(std_sort),
'time_dump': dumps(students_spent_time),
'accesses_dump': dumps(students_course_accesses),
'std_time_schedule_dumb': dumps(students_time_schedule),
'vid_prob_prog_dump': dumps(students_prob_vid_progress),
'pass_limit': pass_limit,
'prof_limit': proficiency_limit,
'usernames_in': usernames_in,
'video_names': course_video_names,
'video_ids': video_ids_str,
'video_prog_json': video_prog_json,
'video_distrib_json': video_distrib_json,
'problem_distrib_json': problem_distrib_json,
'video_intervals_array': video_intervals_array,
'vid_and_prob_daily_time': vid_and_prob_daily_time,
'scatter_array': scatter_array,
}
return render_to_response('learning_analytics/learning_analytics.html',
context)
def chart_update(request):
results = {'success' : False}
chart_info_json = dumps(results)
if request.method == u'GET':
GET = request.GET
user_id = GET[u'user_id']
user_id = request.user if user_id == "" else user_id
chart = int(GET[u'chart'])
course_key = get_course_key(GET[u'course_id'])
if chart == VISUALIZATIONS_ID['LA_chapter_time']:
cs, st = get_DB_course_spent_time(course_key, student_id=user_id)
student_spent_time = chapter_time_to_js(cs, st)
chart_info_json = dumps(student_spent_time)
elif chart == VISUALIZATIONS_ID['LA_course_accesses']:
cs, sa = get_DB_course_section_accesses(course_key, student_id=user_id)
student_course_accesses = course_accesses_to_js(cs, sa)
chart_info_json = dumps(student_course_accesses)
elif chart == VISUALIZATIONS_ID['LA_student_grades']:
students_grades = get_DB_student_grades(course_key, student_id=user_id)
chart_info_json = dumps(students_grades)
elif chart == VISUALIZATIONS_ID['LA_time_schedule']:
student_time_schedule = get_DB_time_schedule(course_key, student_id=user_id)
chart_info_json = dumps(student_time_schedule)
elif chart == VISUALIZATIONS_ID['LA_vid_prob_prog']:
student_prob_vid_progress = get_DB_course_video_problem_progress(course_key, student_id=user_id)
chart_info_json = dumps(student_prob_vid_progress)
elif chart == VISUALIZATIONS_ID['LA_video_progress']:
# Video progress visualization. Video percentage seen total and non-overlapped.
course = get_course_with_access(user_id, action='load', course_key=course_key, depth=None, check_if_enrolled=False)
video_descriptors = videos_problems_in(course)[0]
video_durations = get_info_videos_descriptors(video_descriptors)[2]
video_names, avg_video_time, video_percentages = get_module_consumption(user_id, course_key, 'video', 'video_progress')
if avg_video_time != []:
all_video_time_percent = map(truediv, avg_video_time, video_durations)
all_video_time_percent = [int(round(x*100,0)) for x in all_video_time_percent]
else:
all_video_time_percent = avg_video_time
column_headers = ['Video', 'Different video time', 'Total video time']
chart_info_json = ready_for_arraytodatatable(column_headers, video_names, video_percentages, all_video_time_percent)
elif chart == VISUALIZATIONS_ID['LA_video_time']:
# Time spent on every video resource
video_names, all_video_time = get_module_consumption(user_id, course_key, 'video', 'total_time_vid_prob')[0:2]
column_headers = ['Video', 'Time watched']
chart_info_json = ready_for_arraytodatatable(column_headers, video_names, all_video_time)
elif chart == VISUALIZATIONS_ID['LA_problem_time']:
# Time spent on every problem resource
problem_names, time_x_problem = get_module_consumption(user_id, course_key, 'problem', 'total_time_vid_prob')[0:2]
column_headers = ['Problem', 'Time on problem']
chart_info_json = ready_for_arraytodatatable(column_headers, problem_names, time_x_problem)
elif chart == VISUALIZATIONS_ID['LA_repetition_video_interval']:
# Repetitions per video intervals
video_name = GET[u'video']
video_id = BlockUsageLocator._from_string(video_name)
video_id = Location.from_deprecated_string(video_id._to_deprecated_string())
chart_info_json = get_user_video_intervals(user_id, video_id)
elif chart == VISUALIZATIONS_ID['LA_daily_time']:
# Daily time spent on video and/or problem resources
video_days, video_daily_time = get_daily_consumption(user_id, course_key, 'video')
problem_days, problem_daily_time = get_daily_consumption(user_id, course_key, 'problem')
chart_info_json = join_video_problem_time(video_days, video_daily_time, problem_days, problem_daily_time)
elif chart == VISUALIZATIONS_ID['LA_video_events']:
# Video events dispersion within video length
video_name = GET[u'video']
video_id = BlockUsageLocator._from_string(video_name)
video_id = Location.from_deprecated_string(video_id._to_deprecated_string())
chart_info_json = get_video_events_info(user_id, video_id)
return HttpResponse(chart_info_json, mimetype='application/json')
def chart_update(request):
results = {'success': False}
chart_info_json = dumps(results)
if request.method == u'GET':
GET = request.GET
user_id = GET[u'user_id']
user_id = request.user if user_id == "" else user_id
chart = int(GET[u'chart'])
course_key = get_course_key(GET[u'course_id'])
if chart == VISUALIZATIONS_ID['LA_chapter_time']:
cs, st = get_DB_course_spent_time(course_key, student_id=user_id)
student_spent_time = chapter_time_to_js(cs, st)
chart_info_json = dumps(student_spent_time)
elif chart == VISUALIZATIONS_ID['LA_course_accesses']:
cs, sa = get_DB_course_section_accesses(course_key,
student_id=user_id)
student_course_accesses = course_accesses_to_js(cs, sa)
chart_info_json = dumps(student_course_accesses)
elif chart == VISUALIZATIONS_ID['LA_student_grades']:
students_grades = get_DB_student_grades(course_key,
student_id=user_id)
chart_info_json = dumps(students_grades)
elif chart == VISUALIZATIONS_ID['LA_time_schedule']:
student_time_schedule = get_DB_time_schedule(course_key,
student_id=user_id)
chart_info_json = dumps(student_time_schedule)
elif chart == VISUALIZATIONS_ID['LA_vid_prob_prog']:
student_prob_vid_progress = get_DB_course_video_problem_progress(
course_key, student_id=user_id)
chart_info_json = dumps(student_prob_vid_progress)
elif chart == VISUALIZATIONS_ID['LA_video_progress']:
# Video progress visualization. Video percentage seen total and non-overlapped.
course = get_course_with_access(user_id,
action='load',
course_key=course_key,
depth=None,
check_if_enrolled=False)
video_descriptors = videos_problems_in(course)[0]
video_durations = get_info_videos_descriptors(video_descriptors)[2]
video_names, avg_video_time, video_percentages = get_module_consumption(
user_id, course_key, 'video', 'video_progress')
if avg_video_time != []:
all_video_time_percent = map(truediv, avg_video_time,
video_durations)
all_video_time_percent = [
int(round(x * 100, 0)) for x in all_video_time_percent
]
else:
all_video_time_percent = avg_video_time
column_headers = [
'Video', 'Different video time', 'Total video time'
]
chart_info_json = ready_for_arraytodatatable(
column_headers, video_names, video_percentages,
all_video_time_percent)
elif chart == VISUALIZATIONS_ID['LA_video_time']:
# Time spent on every video resource
video_names, all_video_time = get_module_consumption(
user_id, course_key, 'video', 'total_time_vid_prob')[0:2]
column_headers = ['Video', 'Time watched']
chart_info_json = ready_for_arraytodatatable(
column_headers, video_names, all_video_time)
elif chart == VISUALIZATIONS_ID['LA_problem_time']:
# Time spent on every problem resource
problem_names, time_x_problem = get_module_consumption(
user_id, course_key, 'problem', 'total_time_vid_prob')[0:2]
column_headers = ['Problem', 'Time on problem']
chart_info_json = ready_for_arraytodatatable(
column_headers, problem_names, time_x_problem)
elif chart == VISUALIZATIONS_ID['LA_repetition_video_interval']:
# Repetitions per video intervals
video_name = GET[u'video']
video_id = BlockUsageLocator._from_string(video_name)
video_id = Location.from_deprecated_string(
video_id._to_deprecated_string())
chart_info_json = get_user_video_intervals(user_id, video_id)
elif chart == VISUALIZATIONS_ID['LA_daily_time']:
# Daily time spent on video and/or problem resources
video_days, video_daily_time = get_daily_consumption(
user_id, course_key, 'video')
problem_days, problem_daily_time = get_daily_consumption(
user_id, course_key, 'problem')
chart_info_json = join_video_problem_time(video_days,
video_daily_time,
problem_days,
problem_daily_time)
elif chart == VISUALIZATIONS_ID['LA_video_events']:
# Video events dispersion within video length
video_name = GET[u'video']
video_id = BlockUsageLocator._from_string(video_name)
video_id = Location.from_deprecated_string(
video_id._to_deprecated_string())
chart_info_json = get_video_events_info(user_id, video_id)
return HttpResponse(chart_info_json, mimetype='application/json')