Student Engagement
Predicting Engagement and Exam Performance
@kaggle.thedevastator_student_engagement_with_tableau_a_data_science_p
Predicting Engagement and Exam Performance
@kaggle.thedevastator_student_engagement_with_tableau_a_data_science_p
CREATE TABLE n_365_course_info (
"course_id" BIGINT,
"course_title" VARCHAR
);
CREATE TABLE n_365_course_ratings (
"course_id" BIGINT,
"student_id" BIGINT,
"course_rating" BIGINT,
"date_rated" TIMESTAMP
);
CREATE TABLE n_365_exam_info (
"exam_id" BIGINT,
"exam_category" BIGINT,
"exam_duration" BIGINT
);
CREATE TABLE n_365_quiz_info (
"quiz_id" BIGINT,
"question_id" BIGINT,
"answer_id" BIGINT,
"answer_correct" VARCHAR
);
CREATE TABLE n_365_student_engagement (
"engagement_id" BIGINT,
"student_id" BIGINT,
"engagement_quizzes" BIGINT,
"engagement_exams" BIGINT,
"engagement_lessons" BIGINT,
"date_engaged" TIMESTAMP
);
CREATE TABLE n_365_student_exams (
"exam_attempt_id" BIGINT,
"student_id" BIGINT,
"exam_id" BIGINT,
"exam_result" BIGINT,
"exam_completion_time" DOUBLE,
"date_exam_completed" TIMESTAMP
);
CREATE TABLE n_365_student_hub_questions (
"hub_question_id" BIGINT,
"student_id" BIGINT,
"date_question_asked" TIMESTAMP
);
CREATE TABLE n_365_student_info (
"student_id" BIGINT,
"student_country" VARCHAR,
"date_registered" TIMESTAMP
);
CREATE TABLE n_365_student_learning (
"student_id" BIGINT,
"course_id" BIGINT,
"minutes_watched" DOUBLE,
"date_watched" TIMESTAMP
);
CREATE TABLE n_365_student_purchases (
"purchase_id" BIGINT,
"student_id" BIGINT,
"purchase_type" VARCHAR,
"date_purchased" TIMESTAMP
);
CREATE TABLE n_365_student_quizzes (
"student_id" BIGINT,
"quiz_id" BIGINT,
"question_id" BIGINT,
"answer_id" DOUBLE
);
Anyone who has the link will be able to view this.