def make_effective_growth():
div = \
html.Div(
className="row",
style={'margin-left': 4,
'margin-right': 4,
'margin-top': 10,
'backgroundColor': rc.RMIT_White},
children=[
# Past performance
html.Div(
className="six columns",
style={'width': '50%',
'margin-left': 0,
'margin-right': 0,
'margin-top': 0,
'margin-bottom': 0,
'backgroundColor': rc.RMIT_White},
children=[
html.P(children='Effectiveness (Mean Change in Course GTS)',
style={'text-align': 'center',
'font-size': 16,
'font-family': 'Sans-serif',
'font-weight': 'Bold',
'color': rc.RMIT_Black,
'line-height': '100%',
'margin-left': 0,
'margin-right': 10,
'margin-top': 0,
'margin-bottom': 0,
'backgroundColor': rc.RMIT_White,
},
),
html.Div(
style={'margin-left': 0,
'margin-right': 10,
'margin-top': 0,
'margin-bottom': 0,
'backgroundColor': rc.RMIT_White},
children=[
dcc.Graph(
id='past-ce',
figure=create_ce_comparison_chart(
cur,
373,
268,
show_title=False,
show_annotations=False,
show_ylabel=False,
show_pval=False,
table='vw214_ce_evaluation_reliable'),
)
]
),
]
),
html.Div(
className='six columns',
style={'width': '50%',
'margin-left': 0,
'margin-right': 0,
'margin-top': 0,
'backgroundColor': rc.RMIT_White},
children=[
html.P(children='Growth in Course Enhancement',
style={'text-align': 'center',
'font-size': 16,
'font-family': 'Sans-serif',
'font-weight': 'Bold',
'color': rc.RMIT_Black,
'line-height': '100%',
'margin-left': 10,
'margin-right': 0,
'margin-top': 0,
'margin-bottom': 0,
'backgroundColor': rc.RMIT_White},
),
html.Div(
style={'margin-left': 10,
'margin-right': 0,
'margin-top': 0,
'margin-bottom': 0,
'backgroundColor': rc.RMIT_White},
children=[
dcc.Graph(
id='ce-growth',
figure=create_ce_growth(
cur,
374,
268,
show_title=False,
show_annotations=False,
show_ylabel=False)
)
]
),
],
)
],
)
return div
'font-family': 'Sans-serif',
'font-weight': 'Bold',
'color': rc.RMIT_Black,
'line-height': '100%',
'margin-left': 0,
'margin-right': 0,
'margin-top': 0,
'margin-bottom': 0,
'backgroundColor': rc.RMIT_White,
},
),
dcc.Graph(id='past-ce',
figure=create_ce_comparison_chart(
cur,
381,
180,
show_title=False,
show_annotations=False,
show_ylabel=False,
show_pval=False),
style={
'margin-left': 0,
'margin-right': 0,
'margin-top': 0,
'margin-bottom': 0,
}),
],
),
html.Div(
className='six columns',
style={
'margin-left': 1,
' AND osi_delta IS NOT NULL \n' \
' ORDER BY gts_delta \n'.format(table, ce, year, semester)
df = db_extract_query_to_dataframe(qry, cur)
return df
df_courses = get_ce_courses(year, semester, table='vw214_ce_evaluation_reliable')
print(tabulate(df_courses, headers='keys'))
df_courses_nce = get_ce_courses(year, semester, table='vw214_ce_evaluation_reliable', ce=False)
create_ce_comparison_chart(
cur,
373,
268,
show_title=False,
show_annotations=False,
show_ylabel=False,
show_pval=True,
table='vw214_ce_evaluation_reliable'),
#sns.distplot(df_courses[df_courses.ce != True].gts_delta, hist=False, color=rc.RMIT_Red, rug=True)
#sns.distplot(df_courses[df_courses.ce == True].gts_delta, hist=False, color=rc.RMIT_Black, rug=True)
#plt.show()
#sns.swarmplot(y="gts_delta", x="ce", data=df_courses, size=4)
#plt.show()
'color': rc.RMIT_Black,
'line-height': '100%',
'margin-left': 0,
'margin-right': 0,
'margin-top': 0,
'margin-bottom': 0,
'backgroundColor': rc.RMIT_White,
},
),
dcc.Graph(
id='past-ce',
figure=create_ce_comparison_chart(
cur,
375,
255,
show_title=False,
show_annotations=False,
show_ylabel=False,
show_pval=False,
table='vw214_ce_evaluation_reliable'),
style={'margin-left': 0,
'margin-right': 0,
'margin-top': 0,
'margin-bottom': 0,
}
),
],
),
html.Div(
className='six columns',
style={'margin-left': 10,