Author

B. Brossette

Librairies Loading 
#clean the environment
rm(list = ls())

#Libraries
library(readr)
library(stringr)
library(plyr)
library(dplyr)
library(tidyverse)
library(lme4)
library(car)
library(emmeans)
library(ggthemes)
library(data.table)
library(corrplot)
library(Hmisc)
library(lavaan)
library(lavaanPlot)
library(semPlot)
library(effectsize)
library(chron)
library(knitr)

0.1 Préparation des données

Code 
#Formatting activity rows data.
activity <- read_delim("../src/home_literacy/2024-02-21_activity_student_record.csv", 
    delim = ";", escape_double = FALSE, trim_ws = TRUE)

activity <- activity %>% mutate(uid = str_sub(user.__ref__,str_locate(user.__ref__, "/")[1]+1))

activity <- activity %>% 
  mutate(day = as.Date( str_sub(date,1, str_locate(date, " ")[1]-1), format="%Y-%m-%d"),
                                hour = times(str_sub(date, str_locate(date, " ")[1]+1)))

activity <- activity %>% mutate(length = (duration/1000)/60) %>% mutate(length = format(length, scientific = FALSE))

activity <- activity %>% select(uid, day, hour, length, activity_type, concentration, difficulty, interaction, perceived_time, pleasure)

#Formatting users rows data. 
users <- read_delim("../src/home_literacy/users_list.csv", 
    delim = ";", escape_double = FALSE, trim_ws = TRUE)

users <- users %>% select(uid,user_category, email, grade, school, teacher_name)

#Jointure
df <- activity %>% left_join(users, by = "uid")

#Delete teacher records AND test records
df <- df %>% filter(school!="TEST_SCHOOL")
df <- df %>% filter(user_category!="T")

1 Statistiques générales

  • Nombre d’activités enregistrées : 762
  • Durée d’une activité (en min) : M = 21.9812088 ; MED = 12.98885 ; SD = 59.6463849
  • Nombre d’utilisateurs actifs : 83
  • Nombre d’utilisateur Martinique 28
  • Nombre d’utilisateur Métropole 55
Code 
describe <- df %>% 
                    group_by(school,grade,uid) %>%  
                    summarise(nb_act = n(), 
                              first_activity = min(day), 
                              last_activity = max(day),
                              period_activity = last_activity - first_activity, 
                              mean_duration = mean(as.numeric(length)),
                              shortest = min(as.numeric(length)), 
                              longest = max(as.numeric(length)))

kable(describe[order(describe$nb_act, decreasing=TRUE),])
school grade uid nb_act first_activity last_activity period_activity mean_duration shortest longest
JEAN JAURES CE2 VF1uYRA4D8eugDXoDlMEeTtpUs12 45 2024-02-03 2024-02-20 17 days 30.9619019 4.5285500 127.9359833
NDD CM1 8HfW3nHdBTSldAJF5fg3B797P782 40 2024-01-03 2024-02-19 47 days 40.1640929 15.8550000 71.7508167
JEAN JAURES CE1 piblO0tOeFY5j5lpBNMsqZBYLOF3 30 2024-02-05 2024-02-20 15 days 27.0055072 0.2261500 202.9889667
NDD CP C6Q0SQrleUe92Saf1s2KK2CvEeZ2 29 2023-11-15 2024-02-01 78 days 69.4727494 5.9474000 1446.3055167
NDD CP zZuHqAnYU3VIRiJaM6FWJ7vaK4n2 29 2023-12-24 2024-02-16 54 days 9.8857374 2.1374167 39.4552333
NDD CM1 5HVZpPUmGjS3CA9o9ACSMtQRLlm2 26 2023-12-25 2024-02-20 57 days 11.3287160 2.6684833 44.6011333
NDD CP NNvb2mgNFHdZlngSCTJp1Q1KCfB2 24 2023-12-13 2024-02-11 60 days 21.8310951 5.1437833 49.6521667
NDD CP dQcZcdBz7lPRYo3RiqwvBw2J9Iu1 23 2023-11-15 2024-01-22 68 days 7.7144514 0.6165833 27.6241000
ESTELLO CM2 ljauS9QhkxYdKsKBIvEHgIEtJ9h1 18 2024-02-14 2024-02-21 7 days 20.9180917 2.0297667 50.6701167
JEAN JAURES CE2 XyqnssU4kaczsUqfEV2dG9QiM3Y2 18 2024-02-04 2024-02-20 16 days 3.8421907 1.4099833 9.3455167
JEAN JAURES CE1 5yrU0t50yPNz04aVGpPgH2k0KXr2 16 2024-02-07 2024-02-19 12 days 12.7064542 1.8563000 25.7878167
NDD CE1 x5gBMzUCBRVrxxNbcWoZBVxCkjZ2 16 2023-11-12 2024-01-14 63 days 55.4033073 9.3134833 134.8125667
NDD CM1 j37NtPwaMkfLJDbyhH0vSKCoAiq2 16 2023-11-28 2024-01-16 49 days 15.8528302 3.7416667 120.7004500
JEAN JAURES CE1 rG0RIEJE8FZPy7kVxsbHGaW7MJy1 15 2024-02-10 2024-02-20 10 days 12.0894033 0.7864667 49.2549500
JEAN JAURES CE2 CLYG5UpIHefxKuPVTDCOXZEhEsD2 15 2024-02-09 2024-02-21 12 days 26.8259767 3.4027167 94.1247833
JEAN JAURES CE1 vydAYPaAyBOgzqHBlPUqmeemz1A3 14 2024-02-08 2024-02-20 12 days 16.0695476 4.1911500 53.8937833
NDD CE2 64C4JIfys3SvfYY1LINF3Y1jqHe2 14 2023-11-24 2024-01-01 38 days 11.6549643 2.7558333 25.4438000
JEAN JAURES CE2 Rz8itmcf9PXaTC7hOW8AYBdxYkN2 13 2024-02-06 2024-02-18 12 days 7.6020359 1.0258000 12.1412833
PE CP cKvRUTw97fZCP12KPWDvNPdbTUj2 13 2024-02-14 2024-02-20 6 days 8.8233859 1.4199333 37.5251833
EDOUARD AMALBERT GREASQUE CM1 lBiQglhf6fXGYEtV8QDt06NDgTf2 12 2024-02-17 2024-02-21 4 days 20.6506125 7.8478833 44.0420000
ESTELLO CM2 0ZGHLKFhcfTfT1sUDXakNYjulxd2 12 2024-02-08 2024-02-20 12 days 27.0731875 14.8924833 48.7484833
JEAN JAURES CE2 ptFEMg1AZsPlQUPOYoPv1B1YhKk2 12 2024-02-03 2024-02-19 16 days 12.9921486 0.8530500 34.3743833
NDD CE2 0Fd77PUOxzd2y3fl6hiZufejsV93 12 2023-12-15 2024-02-20 67 days 36.8211194 4.8001500 88.7375000
NDD CE2 bf7S70RAmCUURocI4L4m0Sm9pJ32 12 2023-12-02 2024-01-03 32 days 16.5691556 4.9343500 38.3095333
JEAN JAURES CE2 7wCbkvTHQsPz2ECKR5EtSboF2kY2 11 2024-02-05 2024-02-17 12 days 18.9429182 6.9679500 36.6896000
JEAN JAURES CE2 cEpz3CnP1KbiiDBKYbrmUsCbKGu1 11 2024-02-05 2024-02-18 13 days 13.0102667 4.1033500 20.7576667
NDD CP wwDuUwKbildozbnA5n5fC7V0p0H2 11 2024-01-03 2024-01-25 22 days 11.6017636 5.6251500 15.6006500
EDOUARD AMALBERT GREASQUE CE1 EogcPpqL8zgghuZkggGwU8xYalI3 10 2024-02-17 2024-02-20 3 days 17.0304483 5.5597500 47.5090333
ESTELLO CM2 U1VonLwRUBOFSJpnopn3WdIcaeg2 10 2024-02-11 2024-02-19 8 days 20.8885883 15.2334833 30.3857833
JEAN JAURES CE2 gldSjIhli6X5vZXpItDq1Eu6T523 10 2024-02-05 2024-02-18 13 days 28.6248517 2.6345833 79.7949500
EDOUARD AMALBERT GREASQUE CE2 LinzxI7gsXMPZrYhBWICWyt6V9m1 9 2024-02-17 2024-02-21 4 days 11.9742574 4.2880000 25.8113833
EDOUARD AMALBERT GREASQUE CM2 hUCfqdlasZX1J6EgIls6MEA8JgN2 9 2024-02-18 2024-02-21 3 days 75.0753296 1.6250667 620.7312500
JEAN JAURES CE1 uIBvOXdTZhSodbVfADUY8LblCCS2 9 2024-02-03 2024-02-14 11 days 33.5560833 6.5135167 78.5353000
NDD CE1 dssCPSA4tAaFpbMUmytzzJnqukG3 9 2023-11-12 2023-11-27 15 days 48.6553259 13.9418667 77.9617667
EDOUARD AMALBERT GREASQUE CM2 oP3cPKjC43NcFnZyFMBm30DLaw12 8 2024-02-17 2024-02-20 3 days 15.3626771 1.8407667 39.4745500
ESTELLO CE2 HetOCgqpWJXQrtwvtsSXjFMH1Fi1 8 2024-02-13 2024-02-18 5 days 11.6131583 2.8234833 27.1495833
JEAN JAURES CE1 aNlGF7GT9Gh6U4mfI6tYJ4z9LLZ2 8 2024-02-18 2024-02-21 3 days 11.6919021 0.5563500 35.4859667
JEAN JAURES CE1 vFOyU7EzlPUH9YRX2hQNBzDQJA62 8 2024-02-03 2024-02-19 16 days 19.5924792 3.8414333 48.6246167
NDD CP kBHlFOenyZeVsHtHvbA58rrtnwc2 8 2023-12-28 2024-01-24 27 days 4.0122688 0.2836500 10.3989667
NDD CP sKl6CGYvPyc7TY4z3PA2UXyc0DE2 8 2023-11-18 2023-12-11 23 days 8.7387104 1.0938833 18.1143500
EDOUARD AMALBERT GREASQUE CM1 N1vVSyaru2MJc10CiQ1syvuMlZK2 7 2024-02-17 2024-02-18 1 days 9.7306048 4.3840167 21.2000000
EDOUARD AMALBERT GREASQUE CM2 8ASJCh2cO1bs1L3p3ymraFiQist2 7 2024-02-18 2024-02-19 1 days 6.8981548 2.3994833 10.1465333
ESTELLO CE2 HTKse1nXnzZsNEliAAZ8IPpKbV12 7 2024-02-09 2024-02-18 9 days 13.1086690 5.6140000 37.0719833
NDD CM2 p7fTNPA4MrMplzX9BbWVy90z0nw2 7 2023-12-18 2024-02-16 60 days 19.6143976 7.1778000 51.0792833
JEAN JAURES CE1 evKDdbHRizP5mcqjJOI9OWzoeo13 6 2024-02-05 2024-02-12 7 days 6.4434778 1.8761833 14.4567500
JEAN JAURES CE2 vdRT8VBJPxb10djilGr4XWhYd8I3 6 2024-02-04 2024-02-18 14 days 47.5629778 23.7291833 77.6055167
NDD CM1 N5KAn0UJaLOV502R6bAeyHDdnRH2 6 2023-12-03 2023-12-11 8 days 29.6927333 8.5788667 64.9061667
PE CE1 bBC9DRRGeJZJn7uGGitz8CclNN62 6 2024-02-16 2024-02-20 4 days 9.6812500 1.6394667 22.1480000
JEAN JAURES CE2 KQoSmmz2wAWl831OHv8l5KBREsz1 5 2024-02-07 2024-02-20 13 days 15.9207000 2.6184000 32.8393167
NDD CM2 qtHNvWpxQjOpQVePyxy7p4sbkdo2 5 2023-12-03 2023-12-21 18 days 44.9950267 35.6085333 52.5761500
EDOUARD AMALBERT GREASQUE CE2 DiiWLmxaG2TvmOESbiFI19YtvFi1 4 2024-02-19 2024-02-19 0 days 4.0190500 0.1063000 9.2011667
EDOUARD AMALBERT GREASQUE CM1 rg92mxhRduZGnDc2ADjNehRcVVy1 4 2024-02-18 2024-02-19 1 days 15.3996083 3.3587333 30.6184833
ESTELLO CM2 5tq3VXKiuWTYspEWDd9NcN1baYv1 4 2024-02-11 2024-02-18 7 days 16.5147250 1.4245833 24.1348333
NDD CE1 K3qRIZk7VFXrMQEhC9g9iLHrQes2 4 2023-11-12 2023-12-07 25 days 6.7505667 4.9421833 9.1245167
NDD CE2 FyViaX9J6seW0bb8A8USGsWEcqW2 4 2023-12-15 2023-12-27 12 days 5.0358667 2.1930500 10.1336167
NDD CM1 1sMZyrl7QVR10so2hQRE7E75XMD3 4 2024-01-07 2024-01-31 24 days 4.3709958 0.1230333 13.1639667
NDD CP kY9LzoCXPwPwjl22ypzpozMWiA02 4 2023-12-15 2024-02-18 65 days 7.1790000 1.0541333 11.5278667
AUBERGE NEUVE CM2 0TWsCygEX4gU4mIJAeGgP4oI40x1 3 2024-02-20 2024-02-20 0 days 11.9670000 1.7627833 31.3750667
EDOUARD AMALBERT GREASQUE CM2 7Ypy8begbtfMHr8AgW6vpFdZw2t1 3 2024-02-18 2024-02-20 2 days 22.9973778 12.0059167 30.0349500
EDOUARD AMALBERT GREASQUE CM2 s23dtVrQy4PhIMmlKmQi6IY4Rss2 3 2024-02-18 2024-02-19 1 days 23.6216667 1.1303000 42.1966500
JEAN JAURES CE1 h3hZG6MGkbXSsJKBUEIrvpPJVZ63 3 2024-02-11 2024-02-11 0 days 21.4577222 9.8256000 36.2040500
JEAN JAURES CE2 qIpvrmuWCXd33Tf9qLcdGTNeNYg1 3 2024-02-03 2024-02-05 2 days 12.6340111 9.5800333 16.5109167
NDD CE1 iVckzmD1rzNXMzQzEvzV91tCXWF2 3 2023-12-14 2024-01-09 26 days 9.4513056 6.9427167 12.8328833
NDD CM2 8on40nTmo2gFBxh1Z5sR7nfEuVq2 3 2023-11-28 2024-02-05 69 days 5.7198667 1.4385000 11.0335833
NDD CP Bf3uOkYg0jSztwprxAwzLZjKHLB2 3 2023-12-13 2024-01-14 32 days 6.9338167 3.5307833 12.7487333
PE CE1 0xg06IR4J5h4xkBzDOHcQADi7bO2 3 2024-02-14 2024-02-15 1 days 8.6703556 0.0000000 15.3451833
EDOUARD AMALBERT GREASQUE CE1 QEH030myMhbZFAtvhduqNCRxqSx2 2 2024-02-18 2024-02-19 1 days 13.8177000 12.5127333 15.1226667
EDOUARD AMALBERT GREASQUE CE2 73xaL3mbY3PUJ5vqHDywKjqnAfw1 2 2024-02-17 2024-02-19 2 days 10.8966667 8.7871167 13.0062167
EDOUARD AMALBERT GREASQUE CM1 6tJptP9IDPhzNWs7JiHyQZXH1Ra2 2 2024-02-20 2024-02-20 0 days 6.8829500 3.5404167 10.2254833
EDOUARD AMALBERT GREASQUE CM1 opWEInUxmOaOx08zaYYrJ5b6yst2 2 2024-02-18 2024-02-18 0 days 29.1337750 20.4371333 37.8304167
EDOUARD AMALBERT GREASQUE CM2 WI8es9j3spSgIB1pz8kcLW1xb4B2 2 2024-02-18 2024-02-18 0 days 0.3130500 0.1436833 0.4824167
NDD CE1 YkuMsNO5mmVZ5dFkjHNwXtWHrbf2 2 2023-11-12 2023-11-18 6 days 2.1572083 1.0649667 3.2494500
NDD CP A8BE7vxAXUOG1xuCMpb9KEkJwLI3 2 2023-11-22 2023-11-23 1 days 12.3229333 8.3208000 16.3250667
AUBERGE NEUVE CE1 IkpCSxsmVghCQv39oHMnkHNZ9Pw2 1 2024-02-20 2024-02-20 0 days 13.6231833 13.6231833 13.6231833
AUBERGE NEUVE CE1 VUqNH4jIoyNuD0aFaLk0X0FuY1g2 1 2024-02-20 2024-02-20 0 days 4.8707500 4.8707500 4.8707500
AUBERGE NEUVE CE2 OuA8iKWtJBZ9mbxrN08ihU92fKn2 1 2024-02-21 2024-02-21 0 days 23.6834333 23.6834333 23.6834333
AUBERGE NEUVE CE2 ynDcg5JlsWgagPVwBpJmmyxQiab2 1 2024-02-21 2024-02-21 0 days 4.1192500 4.1192500 4.1192500
EDOUARD AMALBERT GREASQUE CE1 Ucsi0yIy6IclRPzOl5mgVI1N9Q33 1 2024-02-19 2024-02-19 0 days 0.7978167 0.7978167 0.7978167
EDOUARD AMALBERT GREASQUE CE2 HHYOuWYdhMVEFCDyk3l3UNwlUTt1 1 2024-02-19 2024-02-19 0 days 20.9437167 20.9437167 20.9437167
EDOUARD AMALBERT GREASQUE CM2 SuI4jwhzttNl8jgfpnCSe6OWwCJ2 1 2024-02-19 2024-02-19 0 days 7.2197667 7.2197667 7.2197667
EDOUARD AMALBERT GREASQUE CM2 mf6ree2gpWbaqnpSjnx66PUvLy63 1 2024-02-20 2024-02-20 0 days 0.0000000 0.0000000 0.0000000
ESTELLO CM2 p0zYDdmV4IR590RFU8PW0PdK62z2 1 2024-02-20 2024-02-20 0 days 10.6893000 10.6893000 10.6893000
NDD CM1 ybFagbpHHeUn9bYuftz6SlULcDK2 1 2023-12-19 2023-12-19 0 days 7.8393167 7.8393167 7.8393167