Name: Effects Of Alcohol On Student Performance.
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

About this Dataset

Effects Of Alcohol On Student Performance.

Aim:
The main aim of this project is to predict students academic performance (grades) using a multilinear regression model built on the predictors mentioned based on 2023 student information.

*Monthly_allowance are amounts are in rands

This is the raw data file, straight from the survey collected. You will see some responses on "what year were you in last year" have been left blank which indicates that the students previous year of study was not in university but rather high school. Since the point of the model is to be based on university students, these observations that have been left blank will be removed so that only students who were in university in 2023 and onwards are taken into consideration. |

Tables

Stats Survey

@kaggle.joshuanaude_effects_of_alcohol_on_student_performance.stats_survey

23.13 kB
406 rows
17 columns

CREATE TABLE stats_survey (
  "timestamp" VARCHAR,
  "your_sex" VARCHAR  -- Your Sex?,
  "your_matric_grade_12_average_gpa_in" DOUBLE  -- Your Matric (grade 12) Average/ GPA (in %),
  "what_year_were_you_in_last_year_2023" VARCHAR  -- What Year Were You In Last Year (2023) ?,
  "what_faculty_does_your_degree_fall_under" VARCHAR  -- What Faculty Does Your Degree Fall Under?,
  "your_2023_academic_year_average_gpa_in_ignore_if_you_a_4a5cfe68" DOUBLE  -- Your 2023 Academic Year Average/GPA In % (Ignore If You Are 2024–1st Year Student),
  "your_accommodation_status_last_year_2023" VARCHAR  -- Your Accommodation Status Last Year (2023),
  "monthly_allowance_in_2023" VARCHAR,
  "were_you_on_scholarship_bursary_in_2023" VARCHAR  -- Were You On Scholarship/bursary In 2023?,
  "additional_amount_of_studying_in_hrs_per_week" VARCHAR  -- Additional Amount Of Studying (in Hrs) Per Week,
  "how_often_do_you_go_out_partying_socialising_during_the_week" VARCHAR  -- How Often Do You Go Out Partying/socialising During The Week?,
  "on_a_night_out_how_many_alcoholic_drinks_do_you_consume" VARCHAR  -- On A Night Out, How Many Alcoholic Drinks Do You Consume?,
  "how_many_classes_do_you_miss_per_week_due_to_alcohol_r_9c6ad762" VARCHAR  -- How Many Classes Do You Miss Per Week Due To Alcohol Reasons, (i.e: Being Hungover Or Too Tired?),
  "how_many_modules_have_you_failed_thus_far_into_your_studies" VARCHAR  -- How Many Modules Have You Failed Thus Far Into Your Studies?,
  "are_you_currently_in_a_romantic_relationship" VARCHAR  -- Are You Currently In A Romantic Relationship?,
  "do_your_parents_approve_alcohol_consumption" VARCHAR  -- Do Your Parents Approve Alcohol Consumption?,
  "how_strong_is_your_relationship_with_your_parent_s" VARCHAR  -- How Strong Is Your Relationship With Your Parent/s?
);