/* 77150 -deposer-un-examen-evaluation-finale-G
- Sujet : Évaluation finale - CREE20058305 - 350-203-FD
- Code permanent/ID tuteur : CREE20058305 / 1801
- Numéro de cours : 350-203-FD-50-4
- Groupe Cours : 100
- Description : 
Svp, déposez le fichier, qui se retrouve en pièce jointe, dans le compte de l'étudiant et transmettez-le dans le compte du tuteur pour correction.

Merci,

Diana
- Pièce jointe : 350-203-FD_50_04_eval_finale_G_reponses.docx


/*
Élève: Crépeau, Elie (CREE20058305)
Cheminement 001-300.A1-2001-0	 	 	Numéro DA 201730377
Inscriptions (CAD)	›	Inscription (CAD)



Cours : 			350-203-FD - Développement de l'enfant et de l'adolescent
Code d'option	50 - Cours dans internet
Version du cours	4
Numéro séquentiel	1
Groupe	000100
 
GÉNÉRAL
Statut de l'inscription	1 - Inscription active
Date de modification	2019-08-12	
No séq. inscription	678352

Dates importantes
Date d'inscription	2019-08-07
Date d'expédition du matériel	2019-08-12
Date de début du cours	2019-08-14
Date limite d'annulation	2019-10-07
Date de confirmation	2019-10-08
Date initiale de fin de cours	
Date de fin du cours	
Date d'annulation


Enseignant						  	1801 - LAQUERRE, NICOLE

Devoirs

Série	
B
	...
Nombre de devoirs reçus	4
Date d'échéance initiale	2020-02-12
Date d'échéance	2020-05-13
Date d'échéance effective	2020-06-13
Motif de prolongation	14 - Fermeture exceptionnelle du Cégep à distance
Demande de prolongation des devoirs	Oui	
Précision

Évaluation	Description	   Note CN	Maximum	 Pondération	 Plagiat	 Niveau plagiat	 Date saisie	 Heure saisie	Date remise dev	
	DEV001	Devoir 1	66.50	100,00	15,00		 	2019-10-03	23:00	2019-10-01
	DEV002	Devoir 2	79.50	100,00	15,00		 	2020-04-19	18:40	2020-04-19
	DEV003	Devoir 3	81.50	100,00	15,00		 	2020-05-06	08:10	2020-05-05
	DEV004	Devoir 4	77.00	100,00	15,00		 	2020-05-14	14:30	2020-05-13


Examens
Série							G
Nombre d'examens reçus			0
Date d'échéance initiale		2020-08-12
Date d'échéance				2020-09-12
Date d'échéance effective	2020-10-13
Demande de prolongation des examens	Oui



Résultats des examens
Description	 Évaluation	 Note CN	 Niveau plagiat	 Maximum	 Plagiat	 Pondération	 Plagiat	 Niveau plagiat	 Date saisie	 Heure saisie	 	 	 	 	 	 	 	 	 
	Examen 1	EXA001	 	 							100,00					40,00	


PASSERELLE AVEC MOODLE	
Date	    Heure	Type de transaction	 		Service WEB	 						Statut transaction	 Date du retour	 	Heure du retour	 	Statut du retour	 Liste des champs	 
	2020-05-14	14:30	01 - Moodle	cad_etudiant_ouvrir_examen	9 - Envoyée	2020-05-14	14:31	200	examen_serie[inc_seq_no]=678352|examen_serie[date_echeance_examen]=2020-08-12|examen_serie[serie_exa
	2019-08-12	11:04	01 - Moodle	cad_etudiant_inscrire	9 - Envoyée	2019-08-12	11:05	200	inscription[codepermanent]=cree20058305|inscription[inc_seq_no]=678352|inscription[crs_seq_no]=0|ins
	2019-10-08	18:48	01 - Moodle	cad_inscription_etudiant_modifier	9 - Envoyée	2019-10-08	18:49	200	inscription[inc_seq_no]=678352|inscription[session]=A|inscription[date_confirmation]=2019-10-08|
	2020-02-10	12:53	01 - Moodle	cad_etudiant_prolonger_cours	9 - Envoyée	2020-02-10	12:53	200	prolongation[inc_seq_no]=678352|prolongation[date_echeance]=2020-04-13|prolongation[type]=1|
	2020-03-17	21:12	01 - Moodle	cad_etudiant_prolonger_cours	9 - Envoyée	2020-03-17	21:13	200	prolongation[inc_seq_no]=678352|prolongation[date_echeance]=2020-05-13|prolongation[type]=1|
	2020-08-11	08:12	01 - Moodle	cad_etudiant_prolonger_cours	9 - Envoyée	2020-08-11	08:12	200	prolongation[inc_seq_no]=678352|prolongation[date_echeance]=2020-09-12|prolongation[type]=2|

*/

select ee.*, from_unixtime(ee.date_echeance_devoir), from_unixtime(ee.date_echeance_examen), u.lastname from moodle.mdl_enrol_etudiant ee
join moodle.mdl_user u on u.id = ee.userid
where u.username='CREE20058305';
/*
# id, inc_seq_no, userid, courseid, annee, session, programme, annee_version_pgm, date_inscription, groupe, date_expedition, date_confirmation, date_echeance_devoir, serie_devoir, date_echeance_examen, serie_examen, from_unixtime(ee.date_echeance_devoir), from_unixtime(ee.date_echeance_examen), lastname
88383, 677890, 118184, 232, 2019, A, 300A0, 2001, 1563979089, 108, 1564151889, 1569350052, 1588132800, G, 1600488000, J, 2020-04-29 00:00:00, 2020-09-19 00:00:00, Crépeau
88843, 678351, 118184, 511, 2019, A, 300A0, 2001, 1565190340, 104, 1565622340, 1568468712, 1589342400, C, 1599796800, A, 2020-05-13 00:00:00, 2020-09-11 00:00:00, Crépeau
88844, 678352, 118184, 474, 2019, A, 300A0, 2001, 1565190341, 100, 1565622341, 1570574952, 1589342400, B, 1599883200, G, 2020-05-13 00:00:00, 2020-09-12 00:00:00, Crépeau  ==
89026, 678537, 118184, 461, 2019, A, 300A0, 2001, 1565705253, 102, 1565878053, 1568038865, 1589860800, D, 1600488000, G, 2020-05-19 00:00:00, 2020-09-19 00:00:00, Crépeau

*/

/* requête 3 dans 1 */
select ue.*, from_unixtime(ue.timeend), from_unixtime(ue.timecreated), c.id as course_id, c.fullname from moodle.mdl_user_enrolments ue
join moodle.mdl_user u on u.id = ue.userid
join moodle.mdl_enrol e on e.id = ue.enrolid
join moodle.mdl_course c on c.id = e.courseid
where u.username = 'CREE20058305';
/*
# id, status, enrolid, userid, timestart, timeend, modifierid, timecreated, timemodified, from_unixtime(ue.timeend), from_unixtime(ue.timecreated), course_id, fullname
123343, 0, 1746, 149398, 1589470108, 0, 100049, 1590420508, 1590420508, 1969-12-31 19:00:00, 2020-05-25 11:28:28, 450, 201-337-FD-10-02 • Statistique

*/




/* Le backup de la table  mdl_local_passerelle_transaction  */
select * from moodle.mdl_local_passerelle_transaction WHERE data LIKE '%"idInscriptionEtudiant":"678352",%';
/*
# id, grade_id, status, sge_id, timecreated, timemodified, grade_timemodified, data
'301113', '2060253', 'Transmise', '111', '1570158005', '1570158011', '1570157881', '{\"provenance\":\"M\",\"idInscriptionEtudiant\":\"678352\",\"noTuteur\":\"302561\",\"note\":66.5,\"commentaire\":\"Voir dans le campus.\",\"noEvaluation\":1,\"typeEvaluation\":1,\"penalite\":0,\"indicateurReprise\":0,\"noteSur\":100,\"dateRemise\":\"2019-10-01\"}'
'339716', '2416595', 'Transmise', '111', '1587336002', '1587336004', '1587335844', '{\"provenance\":\"M\",\"idInscriptionEtudiant\":\"678352\",\"noTuteur\":\"1946\",\"note\":79.5,\"commentaire\":\"Voir dans le campus.\",\"noEvaluation\":2,\"typeEvaluation\":1,\"penalite\":0,\"indicateurReprise\":0,\"noteSur\":100,\"dateRemise\":\"2020-04-19\"}'
'343767', '2470386', 'Transmise', '111', '1588767003', '1588767008', '1588766939', '{\"provenance\":\"M\",\"idInscriptionEtudiant\":\"678352\",\"noTuteur\":\"1946\",\"note\":81.5,\"commentaire\":\"Voir dans le campus.\",\"noEvaluation\":3,\"typeEvaluation\":1,\"penalite\":0,\"indicateurReprise\":0,\"noteSur\":100,\"dateRemise\":\"2020-05-05\"}'
'345964', '2488872', 'Transmise', '111', '1589481009', '1589481014', '1589480824', '{\"provenance\":\"M\",\"idInscriptionEtudiant\":\"678352\",\"noTuteur\":\"1946\",\"note\":77,\"commentaire\":\"Voir dans le campus.\",\"noEvaluation\":4,\"typeEvaluation\":1,\"penalite\":0,\"indicateurReprise\":0,\"noteSur\":100,\"dateRemise\":\"2020-05-13\"}'
*/

-- delete  FROM moodle.mdl_local_passerelle_transaction WHERE id=55555;



SELECT
    gg.id, gg.userid as id_etudiant, gg.usermodified as id_tuteur,
    gg.rawgrade as note_non_ponderee, gg.finalgrade, gg.feedback as commentaire,
    gg.feedbackformat as commentaire_format,
    gg.information, gg.informationformat, from_unixtime(gg.timemodified), gg.exported, gg.overridden, gg.locked,
    gi.grademax, gi.courseid, gi.itemtype, gi.iteminstance, gi.idnumber,
    c.id as id_cours,
    u.username
FROM
    moodle.mdl_grade_grades gg
    LEFT JOIN moodle.mdl_grade_items gi ON (gg.itemid = gi.id)
    LEFT JOIN moodle.mdl_course c ON (gi.courseid = c.id)
    LEFT JOIN moodle.mdl_user u ON (gg.userid = u.id)
WHERE
    -- gg.timemodified >= unix_timestamp('2015-11-15') and
    -- gg.timemodified < unix_timestamp('2015-12-19') and
    -- gg.finalgrade is not null and gg.usermodified is not null
    -- and gi.idnumber is not null
    -- and gg.locked = 0;
    gg.userid = 118184
    and courseid = 474
    ORDER BY gg.id;
    
/*
# id, id_etudiant, id_tuteur, note_non_ponderee, finalgrade, commentaire, commentaire_format, information, informationformat, from_unixtime(gg.timemodified), exported, overridden, locked, grademax, courseid, itemtype, iteminstance, idnumber, id_cours, username
1964497, 118184, 118184, 0.00000, 0.00000, , 0, , 0, 2019-08-12 17:18:44, 0, 0, 0, 100.00000, 474, mod, 3292, , 474, cree20058305
1964498, 118184, , , 100.00000, , 0, , 0, 2019-09-28 15:07:17, 0, 0, 0, 100.00000, 474, category, 2023, , 474, cree20058305
1964499, 118184, 118184, 0.00000, 0.00000, , 0, , 0, 2019-08-12 17:22:34, 0, 0, 0, 100.00000, 474, mod, 3293, , 474, cree20058305
1964500, 118184, 118184, 0.00000, 0.00000, , 0, , 0, 2019-08-13 23:17:19, 0, 0, 0, 100.00000, 474, mod, 3294, , 474, cree20058305
1964501, 118184, 118184, 0.00000, 0.00000, , 0, , 0, 2020-04-12 17:56:41, 0, 0, 0, 100.00000, 474, mod, 3295, , 474, cree20058305
1964502, 118184, 118184, 0.00000, 0.00000, , 0, , 0, 2020-04-13 17:06:16, 0, 0, 0, 100.00000, 474, mod, 3296, , 474, cree20058305
1964503, 118184, 118184, 0.00000, 0.00000, , 0, , 0, 2020-05-01 10:56:57, 0, 0, 0, 100.00000, 474, mod, 3297, , 474, cree20058305
1964504, 118184, 118184, 0.00000, 0.00000, , 0, , 0, 2020-05-01 10:57:46, 0, 0, 0, 100.00000, 474, mod, 3298, , 474, cree20058305
1964505, 118184, 118184, 0.00000, 0.00000, , 0, , 0, 2020-04-13 23:03:58, 0, 0, 0, 100.00000, 474, mod, 3299, , 474, cree20058305
1964506, 118184, 118184, 0.00000, 0.00000, , 0, , 0, 2020-05-05 21:22:29, 0, 0, 0, 100.00000, 474, mod, 3300, , 474, cree20058305
1964507, 118184, 118184, 0.00000, 0.00000, , 0, , 0, 2020-05-11 19:23:43, 0, 0, 0, 100.00000, 474, mod, 3301, , 474, cree20058305
1964508, 118184, 118184, 0.00000, 0.00000, , 0, , 0, 2019-08-13 23:22:30, 0, 0, 0, 100.00000, 474, mod, 3302, , 474, cree20058305
1964509, 118184, 118184, 100.00000, 100.00000, , 0, , 0, 2020-09-05 11:36:41, 0, 0, 0, 100.00000, 474, mod, 513, , 474, cree20058305
1964510, 118184, 118184, 0.00000, 0.00000, , 0, , 0, 2020-04-11 16:30:22, 0, 0, 0, 100.00000, 474, mod, 514, , 474, cree20058305
1964511, 118184, 118184, 100.00000, 100.00000, , 0, , 0, 2020-04-11 18:43:39, 0, 0, 0, 100.00000, 474, mod, 515, , 474, cree20058305
1964512, 118184, 118184, 100.00000, 100.00000, , 0, , 0, 2020-09-05 13:12:14, 0, 0, 0, 100.00000, 474, mod, 516, , 474, cree20058305
1964513, 118184, 118184, 0.00000, 0.00000, , 0, , 0, 2020-04-11 18:53:53, 0, 0, 0, 100.00000, 474, mod, 517, , 474, cree20058305
1964514, 118184, 118184, 100.00000, 100.00000, , 0, , 0, 2020-09-05 15:04:06, 0, 0, 0, 100.00000, 474, mod, 518, , 474, cree20058305
1964515, 118184, 118184, 100.00000, 100.00000, , 0, , 0, 2020-09-05 15:14:07, 0, 0, 0, 100.00000, 474, mod, 519, , 474, cree20058305
1964516, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 520, , 474, cree20058305
1964517, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 521, , 474, cree20058305
1964518, 118184, 118184, 100.00000, 100.00000, , 0, , 0, 2020-09-07 13:27:36, 0, 0, 0, 100.00000, 474, mod, 522, , 474, cree20058305
1964519, 118184, 118184, 0.00000, 0.00000, , 0, , 0, 2020-09-07 12:55:06, 0, 0, 0, 100.00000, 474, mod, 523, , 474, cree20058305
1964520, 118184, 118184, 100.00000, 100.00000, , 0, , 0, 2020-09-07 15:16:41, 0, 0, 0, 100.00000, 474, mod, 524, , 474, cree20058305
1964521, 118184, 118184, 100.00000, 100.00000, , 0, , 0, 2020-09-07 15:34:07, 0, 0, 0, 100.00000, 474, mod, 525, , 474, cree20058305
1964522, 118184, 118184, 0.00000, 0.00000, , 0, , 0, 2020-09-07 15:37:31, 0, 0, 0, 100.00000, 474, mod, 526, , 474, cree20058305
1964523, 118184, 118184, 100.00000, 100.00000, , 0, , 0, 2020-05-04 15:39:22, 0, 0, 0, 100.00000, 474, mod, 527, , 474, cree20058305
1964524, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 528, , 474, cree20058305
1964525, 118184, 118184, 0.00000, 0.00000, , 0, , 0, 2020-05-04 15:29:43, 0, 0, 0, 100.00000, 474, mod, 529, , 474, cree20058305
1964526, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 530, , 474, cree20058305
1964527, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 531, , 474, cree20058305
1964528, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 532, , 474, cree20058305
1964529, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 533, , 474, cree20058305
1964530, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 534, , 474, cree20058305
1964531, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 535, , 474, cree20058305
1964532, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 536, , 474, cree20058305
1964533, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 537, , 474, cree20058305
1964534, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 538, , 474, cree20058305
1964535, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 539, , 474, cree20058305
1964536, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 540, , 474, cree20058305
1964537, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 541, , 474, cree20058305
1964538, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 542, , 474, cree20058305
1964539, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 543, , 474, cree20058305
1964540, 118184, , , , , 0, , 0, , 0, 0, 0, 100.00000, 474, mod, 544, , 474, cree20058305
2060253, 118184, 131372, 66.50000, 66.50000, , 0, , 0, 2019-10-03 22:58:01, 1570158005, 0, 1570158005, 100.00000, 474, mod, 2773, D1B, 474, cree20058305
2060254, 118184, , , 9.97500, , 0, , 0, 2019-10-03 22:58:01, 0, 0, 0, 100.00000, 474, category, 2024, D1, 474, cree20058305
2060255, 118184, , , 45.67500, , 0, , 0, 2020-05-14 14:27:04, 0, 0, 0, 100.00000, 474, course, 2021, , 474, cree20058305
2416595, 118184, 121, 79.50000, 79.50000, , 0, , 0, 2020-04-19 18:37:24, 1587336002, 0, 1590519389, 100.00000, 474, mod, 2774, D2B, 474, cree20058305
2416596, 118184, , , 11.92500, , 0, , 0, 2020-04-19 18:37:24, 0, 0, 0, 100.00000, 474, category, 2026, D2, 474, cree20058305
2470386, 118184, 121, 81.50000, 81.50000, , 0, , 0, 2020-05-06 08:08:59, 1588767003, 0, 1591940160, 100.00000, 474, mod, 2775, D3B, 474, cree20058305
2470387, 118184, , , 12.22500, , 0, , 0, 2020-05-06 08:08:59, 0, 0, 0, 100.00000, 474, category, 2022, D3, 474, cree20058305
2477593, 118184, , , 11.55000, , 0, , 0, 2020-05-14 14:27:04, 0, 0, 0, 100.00000, 474, category, 2025, D4, 474, cree20058305
2477650, 118184, , , 0.00000, , 0, , 0, 2020-09-12 21:41:18, 0, 0, 0, 100.00000, 474, category, 2027, E1, 474, cree20058305
2488872, 118184, 121, 77.00000, 77.00000, <p><p><span lang="FR-CA">Félicitations pour votre persévérance. Le Cégep à distance
vous enverra sous peu toutes les informations pour passer l’examen qui se fera
en ligne (mesures de confinement) et nous devrons ensuite prendre un
rendez-vous téléphonique. </span></p><br></p>, 1, , 0, 2020-05-14 14:27:04, 1589481009, 0, 1591940160, 100.00000, 474, mod, 2776, D4B, 474, cree20058305
2789196, 118184, 118184, 0.00000, 0.00000, , 0, , 0, 2020-09-12 21:41:18, 0, 0, 0, 100.00000, 474, mod, 633, E1G, 474, cree20058305  ==


*/

/* Je prend le backup de la note qui doit être supprimée */
SELECT * FROM moodle.mdl_grade_grades WHERE id IN (2789196);
/*
# id, itemid, userid, rawgrade, rawgrademax, rawgrademin, rawscaleid, usermodified, finalgrade, hidden, locked, locktime, exported, overridden, excluded, feedback, feedbackformat, information, informationformat, timecreated, timemodified, aggregationstatus, aggregationweight
'2789196', '12593', '118184', NULL, '100.00000', '0.00000', NULL, '118277', NULL, '0', '0', '0', '0', '0', '0', NULL, '0', NULL, '0', NULL, NULL, 'unknown', NULL
*/

 -- delete from moodle.mdl_grade_grades WHERE id  IN (2789196);



/*
Salut Diana,
J'ai supprimé l’ancienne tentative de dépôt  Examen Évaluation finale G
et déposé le fichier par imitation de compte, 
Sous le nom de l’étudiante Crépeau Elie (CREE20058305)pour son  cours 
350-203-FD-50-04 • Développement de l’enfant et de l’adolescent.
La tutrice 1801 - LAQUERRE NICOLE a accès directement pour sa correction.
Merci et bonne journée
Mamadou Kane    

*/