Name: Campus France Rouen 2019 Admission
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Campus France Rouen 2019 Admission

Context

Data from Rouen University services. Those data is about campus france application at Rouen for 2019. But identifications features are all anonymize (please check original version to see it)

This dataset (v1.capuse_france_rouen_dataset) base on the original dataset(which is also upload here) collect informations about international students that have applied for campus france admission in 2019. Those data is only about 2019 and the aim is to collect the maximum informations about candidate learning levels and the university commission decision about their application.

Content

What's inside is more than just rows and columns. I've remove ID row because it doesn't have any specific informations.

Libellé formation de la candidature : the field where the candidate apply
Année d'entrée de la candidature : the degree candidate have applied for. 1 for master 1, 2 for Licence 2 and 3 for Licence 3
Avis SCAC: favorable or not
Niveau du dernier diplôme obtenu : last graduate level
Moyenne du dernier diplôme obtenu : note of last graduate
Appréciation SCAC sur cursus : SCAS appreciation about candidate school curriculum
Capacité à se faire comprendre : capacity of candidate to make himself understand
Capacité à comprendre : capacity of candidate to understand
Etat de la candidature : application result

Check this link to better understand SCAS : http://etudier-en-france.fr/avis-scac/

Acknowledgements

Self learning data science i do believe that "the best way to learn is to give".

Inspiration

How far can we how what make Rouen University commision to select or not a future lectures? What are the similarity and the dissimilarity between those selected and those rejected? How well can we predict the future candidate result base on theirs informations?

Feel free to contact me if you have any questions.
my linkedIn : williams AVOCE
mail : canisius.avoce@outlook.com
Or kindly ask Rouen university services
Thanks and good job all.

Tables

Original Campus France Rouen 2019 Dataset

@kaggle.williamscanisius_campus_france_rouen_2019_dataset.original_campus_france_rouen_2019_dataset

431.14 kB
4,024 rows
59 columns

CREATE TABLE original_campus_france_rouen_2019_dataset (
  "num_ro_de_la_candidature" VARCHAR,
  "espace_campusfrance" VARCHAR,
  "nom_de_l_tudiant" VARCHAR  -- Nom De L\u0027étudiant,
  "pr_nom_de_l_tudiant" VARCHAR  -- Prénom De L\u0027étudiant,
  "etat_de_la_candidature" VARCHAR,
  "date_limite_de_traitement" VARCHAR,
  "entretien_ecf" VARCHAR,
  "dossier_de_l_tudiant" VARCHAR  -- Dossier De L\u0027étudiant,
  "adresse_mail" VARCHAR,
  "date_de_naissance" TIMESTAMP,
  "sexe" VARCHAR,
  "t_l_phone_fixe" VARCHAR,
  "t_l_phone_portable" VARCHAR,
  "pays_de_nationalit" VARCHAR  -- Pays De Nationalité,
  "pays_de_naissance" VARCHAR,
  "ville_de_naissance" VARCHAR,
  "adresse_de_r_sidence" VARCHAR,
  "ville_de_r_sidence" VARCHAR,
  "pays_de_r_sidence" VARCHAR,
  "statut_particulier_bac" VARCHAR,
  "statut_particulier_bourse" VARCHAR,
  "statut_particulier_autre" VARCHAR,
  "libell_formation_de_la_candidature" VARCHAR  -- Libellé Formation De La Candidature,
  "etablissement_de_la_candidature" VARCHAR,
  "composante_de_la_candidature" VARCHAR,
  "site_de_la_candidature" VARCHAR,
  "ann_e_d_entr_e_de_la_candidature" BIGINT  -- Année D\u0027entrée De La Candidature,
  "priorit" DOUBLE  -- Priorité,
  "avis_scac" VARCHAR,
  "appr_ciation_scac" VARCHAR,
  "ann_e_scolaire_du_dernier_dipl_me_obtenu" DOUBLE,
  "type_du_dernier_dipl_me_obtenu" VARCHAR,
  "niveau_du_dernier_dipl_me_obtenu" VARCHAR,
  "etablissement_du_dernier_dipl_me_obtenu" VARCHAR,
  "ville_du_dernier_dipl_me_obtenu" VARCHAR,
  "r_gion_du_dernier_dipl_me_obtenu" VARCHAR,
  "pays_du_dernier_dipl_me_obtenu" VARCHAR,
  "moyenne_du_dernier_dipl_me_obtenu" VARCHAR,
  "mention_du_dernier_dipl_me_obtenu" VARCHAR,
  "appr_ciation_scac_sur_cursus" VARCHAR,
  "dernier_test_de_fran_ais_obtenu" VARCHAR,
  "niveau_global_du_dernier_test_obtenu" VARCHAR,
  "score_global_du_dernier_test_obtenu" DOUBLE,
  "date_d_obtention_du_dernier_test_obtenu" TIMESTAMP  -- Date D\u0027obtention Du Dernier Test Obtenu,
  "date_d_expiration_du_dernier_test_obtenu" VARCHAR  -- Date D\u0027expiration Du Dernier Test Obtenu,
  "num_ro_d_attestation_du_dernier_test_obtenu" VARCHAR  -- Numéro D\u0027attestation Du Dernier Test Obtenu,
  "dispens_de_certification_en_fran_ais_par_l_espace_cf" VARCHAR  -- Dispensé De Certification En Français Par L\u0027espace CF,
  "a_pass_une_partie_de_sa_scolarit_en_fran_ais" VARCHAR  -- A Passé Une Partie De Sa Scolarité En Français,
  "a_tudi_le_fran_ais" VARCHAR  -- A Étudié Le Français,
  "etablissement" VARCHAR,
  "ville" VARCHAR,
  "r_gion" VARCHAR,
  "pays" VARCHAR,
  "volume_d_heures" VARCHAR  -- Volume D\u0027heures,
  "dur_e_d_tude" VARCHAR  -- Durée D\u0027étude,
  "niveau_obtenu" VARCHAR,
  "capacit_se_faire_comprendre" VARCHAR  -- Capacité À Se Faire Comprendre,
  "capacit_comprendre" VARCHAR  -- Capacité À Comprendre,
  "exon_ration" VARCHAR
);

V1 Campus France Rouen Dataset

@kaggle.williamscanisius_campus_france_rouen_2019_dataset.v1_campus_france_rouen_dataset

25.53 kB
3,585 rows
9 columns

CREATE TABLE v1_campus_france_rouen_dataset (
  "libell_formation_de_la_candidature" VARCHAR  -- Libellé Formation De La Candidature,
  "ann_e_d_entr_e_de_la_candidature" BIGINT  -- Année D\u0027entrée De La Candidature,
  "avis_scac" VARCHAR,
  "niveau_du_dernier_dipl_me_obtenu" BIGINT,
  "moyenne_du_dernier_dipl_me_obtenu" VARCHAR,
  "appr_ciation_scac_sur_cursus" VARCHAR,
  "capacit_se_faire_comprendre" VARCHAR  -- Capacité À Se Faire Comprendre,
  "capacit_comprendre" VARCHAR  -- Capacité À Comprendre,
  "etat_de_la_candidature" VARCHAR
);