Hello Carolyn,
The student's responses to each question is stored in the lesson_attempts table
Some fields of this table are simple to understand, but the role of the useranswer field is rather complex because it depends a lot of the question type, for an essay question for instance it is a serialized object
Assuming your prefix table is mdl, you can try to run a query like
SELECT
c.id AS courseid,
t.lessonid,
t.userid,
t.pageid,
u.username AS UserName,
c.shortname AS CourseName,
l.name AS LessonName,
p.title AS PageTitle,
a.answer AS QuestionAnswer,
t.useranswer AS UserAnswer
FROM
mdl_course c,
mdl_lesson l,
mdl_lesson_pages p,
mdl_user u,
mdl_lesson_answers a,
mdl_lesson_attempts t
WHERE
t.lessonid = l.id
AND t.userid = u.id
AND l.course = c.id
AND t.pageid = p.id
AND t.answerid = a.id
to see if it suits your needs or if you need to add some other columns
