STA Blog

gchoi-07-08

By

Feb 19, Tuesday Finished the first set of quiz files.

  1. All Kanji section
  2. Grammar section
    1. Yookoso Vol. 2 (JPN 412L)
      1. Chpter 4 Review Quiz – particles
      2. Chapter 4 Review Quiz – sentences
      3. Chapter 5 Review Quiz – particles
      4. Chapter 5 Review Quiz – sentences
      5. Chapter 6 Review Quz – particles
      6. Chapter 6 Review Quiz – sentences
      7. Chapter 4, 5, 6 Review Quiz – particles
      8. Chapter 4, 5, 6 Review Quiz – sentences
      9. Chapter 4, 5, 6 Review Quiz – sentence structures (forms)
    2. An Integrated Approach to Intermediate Japanese (JPN 320K – Advanced Reading)
      1. Chapter 1 Particles — Review Quiz
      2. Chapter 1 Grammar — Review Quiz
      3. Chapter 2 Particels — Review Quiz
      4. Chapter 2 Grammar — Review Quiz
      5. Chapter 3 Particles — Reveiw Quiz
      6. Chapter 3 Grammar — Review Quiz
      7. Chapter 4 Particles — Review Quiz
      8. Chapter 4 Grammar — Review Quiz
      9. Chapter 5 Particles — Review Quiz
      10. Chapter 5 Grammar — Review Quiz
      11. Chapter 6 Particles — Review Quiz
      12. Chapter 6 Grammar — Review Quiz

Feb 05, Tuesday

  1. finish the first set of files
    1. login

Jan 29, Tuesday

  1. copying quizzes to Kanji files
    1. login

Nov 18,Monday

  1. started working on actual files
    1. kanji
    2. supposed to meet the professor, Suito today but she did not show up.

Nov 4,11 Monday

  1. Finish admin pages for the Japanse website
    1. http://www.laits.utexas.edu/japanese/joshu/gilok/p_login.html
    2. will email the professor, Suito to talk about the site
    3. started working on the quiz files: kanji
  2. php Quiz site
    1. http://www.laits.utexas.edu/japanese/joshu/gilok/test/quiz_b1/quiz.php
    2. http://www.laits.utexas.edu/japanese/joshu/gilok/test/quiz_b2/quiz.php

Oct 29 Monday

  1. met professor, Naoko and found I was working on the wrong project”
    1. She does not want to use the quiz creator.
    2. She wants to add a submit button for sending students’ scores.
    3. She also wants a display page which shows students’ scores.
  2. http://www.laits.utexas.edu/japanese/joshu/kanji/ijc/ijccompreadquiz/325k/325k_ijcrq_ch1_read.htm
  3. found the directory Kyle was working on for the display of student scores.

Oct 22 Monday

  1. created “professor insertion page”
         http://www.laits.utexas.edu/japanese/joshu/quiz/add_pro.php
  1. created “professor edit page”
         http://www.laits.utexas.edu/japanese/joshu/quiz/edit_pro.php
  1. created a database table for professor insertion and edit pages.

Oct 8, 15 Monday

  1. finished “make a quiz procedure”
  2. almost finished “display quizzes procedure” except displayQuiz.php
  3. created a CSS file (quiz_style.css) and applied it to the whole quiz files
  4. moved the database tables from persian site to the Japanese site, and changed db info in the access file
  5. added a navigatin to the original quiz page
  6. moved whole files to the live server
         http://www.laits.utexas.edu/japanese/joshu/quiz/index.html

Oct 1 Monday

  1. Start working on quiz wizard.

link http://dev.laits.utexas.edu/japanese/joshu/persian_test/makeQuiz.php

Sep 27 Thursday Here is a summary of Kyle’s email.

MySQL tables——————

1. proflogin: This contains the username, password, and actual name of each professor

2. quiz: This contains all the information about a quiz (ID#, subject, class, textbook name, english name, the actual questions and answers, etc.)

Notes:

  1. questions, choices, and answers are serialized PHP arrays, so to retrieve them, you must run unserialize(questions) and unserialize(choices) and unserialize(answers) to get the actual PHP variables after pulling the text from the DB.
  2. Due to an error on my part, you must pull out questions, choices, answers, and instructions without issuing the MySQL query “SET names ‘utf8′”.
  3. The rest of the fields you should pull out via a SELECT query /after/ issuing the query “SET names ‘utf8′”.
  4. I think you can fix this problems by doing pulling out the question/choice/answer/instructions, then issuing SET names ‘utf8’ and then updating with the question/choice/answer/instructions again.
  5. I’d make a backup of the DB before trying this or else all data will be messed up.

3. ID# should automatically fill itself in.

4. type is not fully fleshed out right now.

 1) 0=fill-in-the-blank,  2) 1=a drop-down or something, etc.

Check my code and compare it with the original JOSHU site to see what these are supposed to be in order to verify.

5. subject will eventually be “grammar” “conjugation” or whatever it should be, as taken from the tabs at the top of the JOSHU site.

6. Class only applies in certain situations, such as 412K chapter review quizzes and such (in which case, the class field would be set to “412K”.

quizresults

This contains the results of each student’s quiz results after submitting them to the prof.

1. name is the student’s name.

2. quizID is equal to the id field in the quiz table.

3. profname should ideally be populated only by values that are usernames in the “proflogin” table.

4. score is the score (a float, I think)

5. answers is the list of student answers

6. class is the class of the student.

  1. Hopefully this can become a drop-down as well, but you might want to ask Suito if she even needs this field to be used at all.
  2. I intended it to be populated by values such as “330” “320K” “412L” etc. These are the 3-number or 3-number-and-one-letter codes for the classes (such as JPN 330) in the course catalog.
  3. To retrieve this data, you must first issue the MySQL query “SET names ‘utf8′”. This allows us to use unicode properly. Also make sure when you insert data, you preface the INSERT or UPDATE with this query as well!

TODO list

1. Create a method for the professor to create quizzes and have it automatically store the quiz stuff in the database.

2. Create a way for Suito (as the “administrator professor”) to add other professors and allow them to use the database technology

3. Create a way for, at the end of the semester, each professor to,say,generate a PDF of records of their students’ scores or whatever and then remove the records from the database

4. Create a way for a professor to change their username and password.

5. Change the quiz.php code at the bottom, so instead of the student having to type in the prof’s name, have them choose from a drop-down list. This way, typos won’t create problems for our code. This can easily be done by querying the “proflogin” table and getting the names/usernames from there.

6. Right now, when a student submits a quiz via quiz.php, the password is “suito”. Perhaps add a way for the admin prof (Suito here) to change this via a form or something.

You can see what I’ve done so far with this in studentSubmit.php, which submits the data given to it from quiz.php and stores it in the MySQL table “quizresults”.

7. Finish going through all the quizzes on JOSHU and adding them to the “quiz” MySQL table.

I’ve done a lot of them, and I’ve included a PHP file in my testing folder within JOSHU so you can see what quizzes have been completed.

8. Along with #7, there needs to be methods written to display the quiz types other than fill-in-the-blank types (such as drop-down selection type quizzes). You can view the HTML source code for this type of quiz on JOSHU and just use the HTML/CSS from those pages. I did that for other types.

Minimum TODO

  1. Make the professor-Logout.php do something better than just sending the prof to the JOSHU main page. Perhaps have a page that says “you are now logged out.” or something.
  2. Make a better way for professors to access their admin pages (e.g.,professor-Login.php, professor-GradeView.php, etc.).
  3. Talk to Suito about professor-GradeView.php (can only be accessed after logging in via professor-Login) and see if she needs any other statistical data. Perhaps some sort of way to list quizzes only taken after a certain month, so even if suito doesn’t want to remove the data from previous semesters for data purposes, she can still avoid having them obstruct her view of current students’ performance.
  4. Make professor-Login.html not so ugly?

quiz.php, which generates any quiz for a student to take

list.php, which will hopefully eventually be cleaned up and made to look like a spruced-up regular JOSHU select-your-quiz page that fits in with the rest of the site.

insert.php Don’t mess with this. I’m not sure if it’s still on the JOSHU site or if I deleted it.

fix.php:Just delete it.

displayQuiz.php Just a quick and dirty way of making sure the quiz questions and answers were stored properly.

add.php Same as fix.php and insert.php

Sep 21 Friday

  1. The javascript function was almost working but…..
  2. Emily changed her mind about the menu and brought a new staff
  3. He (new staff) just wanted me to change the css and I did.
  4. At this point, I do not have something to work on.
  5. persian_online website

Sep 13 Thursday

  1. met with Emily
  2. started working on javascript main menu

link university of texas