ELearningData.xlsx

	A	B	C
1	Table	Field	Description
2	Courses	Course ID	Unique ID for each Course
3	Courses	items.name	Name of the course
4	Courses	Course Type	Type of course (self paced, live, test etc)
5	Courses	Course Duration (hrs)	Number of video hours
6	QuizDim	QuizID	Unique ID for each Quiz
7	QuizDim	Quiz Name	Name of Quiz
8	QuizDim	CourseID	ID of course the quiz belongs to
9	Users	Student User ID	Unique ID for each Student
10	Users	items.created_at	When the student account was created
11	Users	items.first_name	Student's First Name
12	Users	items.last_name	Student's Last Name
13	Enrollment	EnrollmentID	Unique ID for each Enrolment record
14	Enrollment	items.created_at	When the student was enrolled
15	Enrollment	items.user_id	User ID of the student
16	Enrollment	items.course_id	ID of the course student enrolled for
17	Enrollment	items.percentage_completed	Student's progress in %
18	Enrollment	items.completed_at	When the student completed the course
19	Enrollment	items.completed	Indicates if the student completed course or not
20	Enrollment	items.started_at	When the student started the course
21	Enrollment	items.activated_at	When the student's account was activated
22	Enrollment	items.updated_at	When the student updated their info/password
23	Quiz Detailed	QuizID	ID of the quiz
24	Quiz Detailed	Student User ID	User ID of the student
25	Quiz Detailed	Date Completed (UTC)	When the student completed the quiz
26	Quiz Detailed	Question No	Quiz question number
27	Quiz Detailed	Question	Quiz main question
28	Quiz Detailed	Selected Answer	Answer the student picked
29	Quiz Detailed	Correct	indicates if the answer the student selected is correct or not
30	Quiz Summary	QuizID	ID of the quiz
31	Quiz Summary	Student User ID	User ID of the student
32	Quiz Summary	Date Completed (UTC)	When the student completed the quiz
33	Quiz Summary	Total Number of Questions	Total number of questions in the quiz
34	Quiz Summary	Total Correct	Total number of questions the student got correctly
35	Quiz Summary	% Score	Student's score in pct
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100