Eol Grade Ucursos

Export the students' grades to an excel file (.xlsx)

Install App

docker compose exec lms pip install -e /openedx/requirements/eol_grade_ucursos
docker compose exec lms_worker pip install -e /openedx/requirements/eol_grade_ucursos

Install Theme

To enable export grade button in your theme add next file and/or lines code:

• ../themes/your_theme/lms/templates/instructor/instructor_dashboard_2/data_download.html

  add the script and css

    <link rel="stylesheet" type="text/css" href="${static.url('gradeucursos/css/gradeucursos.css')}"/>
    <script type="text/javascript" src="${static.url('gradeucursos/js/gradeucursos.js')}"></script>
  

  and add html button

      %if 'has_gradeucursos' in section_data and section_data['has_gradeucursos']:
        <div class='gradeucursos-export'>
            <hr>
            <h4 class="hd hd-4">Exportar Notas</h4>
            %if section_data['gradeucursos_grade_cutoff'] is None:
            <div class="gradeucursos-error-msg" style="display: block;">
                <p>El porcentaje de aprobación no se configurado correctamente, contáctese con la mesa de ayuda(eol-ayuda@uchile.cl) para mas información.</p>
            </div>
            %else:
                <p>El porcentaje de aprobación del curso es del: ${section_data['gradeucursos_grade_cutoff']*100} %.</p>
                <p>Seleccione el tipo, escala y el formato de la(s) nota(s), presione el boton Exportar Notas y se generará un archivo Excel.</p>
                <p>NOTA: Al seleccionar el formato "Completo", cada evaluación estará en una escala de 0 - 100 y solamente el promedio final estará con la escala seleccionada.</p>
                <div class="row"> 
                <div class="col-md-1" style="padding-left: 0px;margin-top: 15px;">
                    <label for="gradeucursos_assig_type" style="clear: both; font-style: normal; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif">Tipo de tarea:</label>
                </div>
                <div class="col-md-3" style="padding-left: 0px;margin-top: 15px;">
                    <select class="gradeucursos_select" name='gradeucursos_assig_type' id='gradeucursos_assig_type'>
                    <option value="gradeucursos_total">Nota final del curso</option>
                    %for assig in section_data['gradeucursos_assig_types']:
                        <option value="${assig}">${assig}</option>
                    %endfor
                </select>
                </div>
                </div>
                <div class="row"> 
                <div class="col-md-1" style="padding-left: 0px;margin-top: 15px;">
                    <label for="gradeucursos_grade_type" style="clear: both; font-style: normal; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif">Escala de Nota:</label>
                </div>
                <div class="col-md-3" style="padding-left: 0px;margin-top: 15px;">
                    <select class="gradeucursos_select" name='gradeucursos_grade_type' id='gradeucursos_grade_type'>
                    <option value="seven_scale">1.0 - 7.0</option>
                    <option value="hundred_scale">0 - 100</option>
                    <option value="percent_scale">0.00 - 1.00</option>
                    </select>
                </div>
                </div>
                <div class="row"> 
                <div class="col-md-1" style="padding-left: 0px;margin-top: 15px;">
                    <label for="gradeucursos_is_resumen" style="clear: both; font-style: normal; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif">Formato:</label>
                </div>
                <div class="col-md-3" style="padding-left: 0px;margin-top: 15px;">
                    <select class="gradeucursos_select" name='gradeucursos_is_resumen' id='gradeucursos_is_resumen'>
                    <option value="is_resumen">Completo</option>
                    <option value="gradeucursos_total">Solo Promedio Final</option>
                    </select>
                </div>
                </div>
                <input hidden disabled type="text" name='curso' id="gradeucursos_curso" value="${section_data['gradeucursos_course']}"></input>
                <div class="row">
                <div class="col-md-1"></div>
                <div class="col-md-3" style="padding-left: 0px;margin-top: 15px;">
                    <input id='gradeucursos_data_button' onclick="generate_data_gradeucursos(this)" type="button" name="gradeucursos-data" value="Exportar Notas" data-endpoint="${ section_data['gradeucursos_url_data'] }"/>
                </div>
                </div>
            %endif
            <div class="gradeucursos-success-msg" id="gradeucursos-success-msg"></div>
            <div class="gradeucursos-warning-msg" id="gradeucursos-warning-msg"></div>
            <div class="gradeucursos-error-msg" id="gradeucursos-error-msg"></div>
            <hr>
        </div>
    %endif
  

• In your edx-platform add the following code in the function '_section_data_download' in edx-platform/lms/djangoapps/instructor/views/instructor_dashboard.py

    <try:
        from gradeucursos import views
        section_data['has_gradeucursos'] = True
        section_data['gradeucursos_url_data'] = reverse('gradeucursos-export:data')
        section_data['gradeucursos_course'] = six.text_type(course_key)
        section_data['gradeucursos_grade_cutoff'] = views.Content().get_grade_cutoff(course_key)
        section_data['gradeucursos_assig_types'] = views.Content()._get_assignment_types(course_key)
    except ImportError:
        section_data['has_gradeucursos'] = False
  

TESTS

Prepare tests:

• Install act following the instructions in https://nektosact.com/installation/index.html

Run tests:

• In a terminal at the root of the project

  act -W .github/workflows/pythonapp.yml