Embedded Files
Request the deans to list UIC Courses where Coursera will be integrated. Share the following spreadsheet: https://docs.google.com/spreadsheets/d/1RFSwWEH5toZmByTxVBwJ2tWybWyTxoZZ/edit?gid=302654535#gid=302654535
2. For each of the courses identified, generate a CSV file that can be imported to Coursera. Use the following query:
select distinct cr.code, cr.title, CONCAT(s.firstname,' ',s.lastname) as full_name, s.uic_email_address,s.student_number, es.year_level, sc.label
from
lw3_student s
inner join lw3_student_enrolled_course sec on s.student_id=sec.student_id
inner join lw3_enrolled_student es on s.student_id=es.student_id
inner join lw3_class c on sec.class_id=c.class_id
inner join lw3_course cr on c.course_id=cr.course_id
inner join lw3_section_offering so on c.section_offering_id=so.section_offering_id
inner join lw3_section sc on so.section_id=sc.section_id
--if the course code is CPST2.23 and the sections are CNPH56-WP and CLNPH5H-WP
where cr.code like '%CPST2%' AND cr.code like '%.23%'
and (sc.label='CLNPH5G-WP' or sc.label='CLNPH5H-WP')
and sec.statuscode=3500
and c.semester_id=498
3. Copy the full_name, uic_email_address, and student_number columns from the result of the above query and put them into a CSV file.
4. Login to Coursera Administrator and go to the respective learning path, under the Manage Learners tab
5. Click Invite Learners
6. Click Invite Learners by Specific Email Address
7. Click Upload CSV
8. Browse for the CSV file and click Upload
9. If there are errors (ex. ñ in the email address), make sure to correct them in the CSV file before trying to upload again.
Page updated
Report abuse