Sugar Labs

Teacher Reporting: Difference between revisions

← Older edit
Obsolete
 
(57 intermediate revisions by 6 users not shown)
Line 1: Line 1:
{{Obsolete | Not part of 2016 Sugar}}
{{TOCright}}
{{TOCright}}
{{:Teacher_Reporting/status}}
==Description==
==Description==
A custom [http://moodle.org/ Moodle] [http://docs.moodle.org/en/Quiz_module quiz module] which, in addition to the standard Moodle quiz features, analyzes the questions posed to the student for various qualities, such as compliance with [[User:Gdk/4th_Grade_Maths | Curriculum Standards]].
 
A custom [http://moodle.org/ Moodle] [http://docs.moodle.org/en/Quiz_module quiz module] which, in addition to the standard Moodle quiz features, analyzes the questions posed to the student for various qualities, such as compliance with [[Math4Team/Resources/Curriculum Chart | Curriculum Standards]].


The modified Moodle modules will run on a customized XS School Server operating system. Our goal is to allow results and / or grades, from student activities to be readily available to teachers. Based on their wants and needs, the teachers can then generate custom reports on a class or student and have the ability to determine what types of problems students are finding most difficult. In the end we imagine the XS environment running on an XO itself, allowing the teachers the same portability as the students.
The modified Moodle modules will run on a customized XS School Server operating system. Our goal is to allow results and / or grades, from student activities to be readily available to teachers. Based on their wants and needs, the teachers can then generate custom reports on a class or student and have the ability to determine what types of problems students are finding most difficult. In the end we imagine the XS environment running on an XO itself, allowing the teachers the same portability as the students.
==Collaboration==
To help in code contribution of this project, please visit us at our [http://git.sugarlabs.org/projects/teacher-reporting Gitorious project page.]


==Group Members==
==Project Members==
* '''Project Manager:''' [[User:Wwdillingham | Wesley Dillingham]]  
* '''Project Manager:''' [[User:Wwdillingham | Wesley Dillingham]]  
* '''Additional Group Members:''' [[User:jrgreen118 | Jeremiah Green]]
* '''Additional Group Members:''' [[User:jrgreen118 | Jeremiah Green]], [[User:FGrose | Fred Grose]]
<br>
<br>
==Goals==
*Expand upon the PHP of the Moodle Quiz Module to parse questions involving mathematical operations for characteristics contained in the [http://www.doe.mass.edu/frameworks/current.html Massachusetts Curriculum Framework for Mathematics.]
*Run Moodle with the modified quiz module on an XO running [[olpc:School_server | XS]], The '''X'''O school '''S'''erver.
*Have Moodle's latest stable release functioning on an XO running XS using the techniques outlined [[olpc:XS-on-XO | here]].
*Have PHP calls successfully querying mock student results from Moodle's PostgreSQL database running on XS.


==Data Flow Diagram==
==Data Flow Diagram==
Line 14: Line 27:
<br>
<br>


==Curriculum Requirements and Relevant Activities==


==Goals==
See [[Teacher Reporting/Math]].
*Expand upon the PHP of the Moodle Quiz Module to parse questions involving mathematical operations for characteristics contained in the [http://www.doe.mass.edu/frameworks/current.html Massachusetts Curriculum Framework for Mathematics.]
*Parse mathematical-operation-based and tally percentage of success with each individual operation (+,-,/,* etc).
 
*Run Moodle with the modified quiz module on an XO running [[olpc:School_server | XS]], The '''X'''O school '''S'''erver.
*Create Moodle data flow diagram to give an understanding of how the Moodle Server and corresponding database interact with Student and Teachers machines.
*Have [http://download.moodle.org/ Moodle's latest stable release] functioning in an XS School Server [[olpc:XS-on-XO | VirtualBox]] OSE Virtual Machine
*Have Moodle's latest stable release functioning on an XO running XS using the techniques outlined [[olpc:XS-on-XO | here]].
*Have PHP calls successfully querying mock student results from Moodle's MySQL database running on XS.


=="How to Play/Use" for end user==
=="How to Play/Use" for end user==
Line 29: Line 35:
Our project is not intended for a direct use by students. Components (not yet developed) under the scope of our project exist on students computer's in so far as facilitating the data movement from the XO to the XS. Therefore, there are no directions for students on how to use our application, it will be entirely transparent to them. When a student begins an activity which is compatible with our application, it will automatically report information to the API. Our application will then read this information from the API and produce reports to the teacher. We envision this interface to be web based, allowing the teacher to select particular games, and as a subcategory, the particular curriculum requirements in which that game uses.
Our project is not intended for a direct use by students. Components (not yet developed) under the scope of our project exist on students computer's in so far as facilitating the data movement from the XO to the XS. Therefore, there are no directions for students on how to use our application, it will be entirely transparent to them. When a student begins an activity which is compatible with our application, it will automatically report information to the API. Our application will then read this information from the API and produce reports to the teacher. We envision this interface to be web based, allowing the teacher to select particular games, and as a subcategory, the particular curriculum requirements in which that game uses.


At this moment (5/18/2009) we only have a script which analyzes performance on particular mathematical operations and the students ability to understand order of operations.
 


In order to run this script (parser.awk) issue the command, <pre>awk -f parser.awk students.dat</pre>
In order to run this script (parser.awk) issue the command, <pre>awk -f parser.awk students.dat</pre>
Line 75: Line 81:
*Download the image file: [http://xs-dev.laptop.org/xs/other/OLPC-School-Server-0.5.2-dev01-i386.img.gz OLPC-School-Server-0.5.2-dev01-i386.img.gz]
*Download the image file: [http://xs-dev.laptop.org/xs/other/OLPC-School-Server-0.5.2-dev01-i386.img.gz OLPC-School-Server-0.5.2-dev01-i386.img.gz]
*Un-compress the file
*Un-compress the file
**In Windows, [http://www.rarlab.com/download.htm WinRAR] worked for me.
**In Windows, [http://www.rarlab.com/download.htm WinRAR] worked well.
**In Linux, this command works just as well<pre>gzip -d OLPC-School-Server-0.5.2-dev01-i386.img.gz"</pre>
**In Linux, this command works just as well<pre>gzip -d OLPC-School-Server-0.5.2-dev01-i386.img.gz</pre>


=====Setting Up the Environment=====
=====Setting Up the Environment=====
With the SD card connected to the Linux PC:
With the SD card connected to the Linux PC:
*Using a tool of your choice format the SD card to ext2 or ext3 (Linux 83).
*Using a tool of your choice format the SD card to ext2 or ext3 (Linux 83).
**I used gparted and formated the SD card to ext3, but fdisk would also work.
**Gparted was excellent for formating the SD card to ext3, but fdisk would also work.
*Mark the partition with the boot flag
*Mark the partition with the boot flag
**This can be done using gparted, but mine had issues applying the changes. I used fdisk.
**This can be done using gparted, but in several instances errors were experienced. In lieu fdisk works great.
**To enter fdisk, use <pre>fdisk /dev/sd*1</pre>
**To enter fdisk, use  
***where * is the letter associated with the SD device and the 1 is the partition. Once in fdisk, use the help to determine the specific command to mark the boot flag. For me it was "a".
<pre>
*Next ensure the .img file uncompressed previously is accessible by the Linux machines. I used another flash drive.
fdisk /dev/sd*1
*Use the command <pre>dd if=OLPC-School-Server-0.5.2-dev01-i386.img of=/dev/sd*1</pre>
or
fdisk /dev/mmcblk*p1
</pre>
*where * is the letter associated with the SD device and the 1 is the partition. Once in fdisk, use the help to determine the specific command to mark the boot flag. In most instances it will be "a".
*Next ensure the .img file, uncompressed previously, is accessible by the Linux machines.
*Use the command,
<pre>
dd if=OLPC-School-Server-0.5.2-dev01-i386.img of=/dev/sd*1
or
dd if=OLPC-School-Server-0.5.2-dev01-i386.img of=/dev/mmcblk*p1
</pre>
**This will take some time depending on the system performance.
**This will take some time depending on the system performance.
*Use resize2fs to re-size the partition <pre>resize2fs -p /dev/sd*1</pre>
*Use resize2fs to re-size the partition  
<pre>
resize2fs -p /dev/sd*1
or
resize2fs -p /dev/mmcblk*p1
</pre>


=====Getting a Developer Key=====
=====Getting a Developer Key=====
*First the XO must have a [http://wiki.laptop.org/go/Activation_and_Developer_Keys developer's key!!!]
*First the XO must have a [http://wiki.laptop.org/go/Activation_and_Developer_Keys developer's key!!!]
*The easiest way to go about obtaining this is to boot into the XO's Sugar OS. Open the browse application. Near the bottom right of the home page, there will be a like for "Get a Developer Key".
*The easiest way to go about obtaining this is to boot into the XO's Sugar OS. Open the browse application. Near the bottom right of the home page, there will be a link for "Get a Developer Key".
**Click this link and on the next page click the "Submit Query." Go through this process again after 24 hours and the key should be available.
**Click this link and on the next page click the "Submit Query." Go through this process again after 24 hours and the key should be available.
**Upon return follow the directions displayed to download the key.
**Upon return follow the directions displayed to download the key.
Line 104: Line 125:
</pre>
</pre>


====Booting the XO from the SD====
=====Booting the XO from the SD=====
More than likely, this will not work right away, my implementation required some tweaking prior to fully booting.
More than likely, this will not work right away, most implementations require some tweaking prior to properly booting.
*With the SD card inserted in the XO, turn the machine on and press the "Esc" key to interrupt start-up.
*With the SD card inserted in the XO, turn the machine on and press the "Esc" key to interrupt start-up.
*At the prompt type:
*At the prompt type:
Line 133: Line 154:
</pre>
</pre>


==Documentation & Resources==
=====Post XS School Server Installation Configuration:=====
The following are commands that were run after installing XS on a Virtual Machine. Idealy, the newly configured SD card can now act as the operating system for the Virtual Machine allowing further versatility.


'''Post XS School Server Installation Configuration:'''
<pre>
<pre>
yum groupinstall "GNOME Desktop Environment"
yum groupinstall "GNOME Desktop Environment"
Line 169: Line 190:
</pre>
</pre>


'''Installing MySQL:''' <br>
==Documentation & Resources==
[[image:ScreenInstalling.png]]
===Related Projects or Proposals===
 
* [[Karma]]
'''Starting MySQL Database:''' <br>
* [[olpc:Customizing Moodle to include efficient Examination Processes]]
[[image:ScreenStartingMysql.png]]
* [http://wiki.sugarlabs.org/go/Teacher%27s_Tools Teacher's Tools]
 
'''Logging in to MySQL Database:''' <br>
[[image:ScreenLoginSqlServ.png]]
 
'''Creating Database:''' <br>
[[image:ScreenCreateDB.png]]
 
== Code ==
 
Code can be downloaded [http://www.filedropper.com/parser here]
 
<pre>
#Wesley Dillingham
#Filename parser.awk
#Last updated May 17th 2009
 
BEGIN{
printf("%-11s%-8s%-11s%-8s%-11s%-8s%-11s%-8s%-11s%-11s\n", "Student", "Only +", "Contains +", "Only -", "Contains -", "Only
*", "Contains *", "Only /", "Contains /", "Understands OoO?")
}
 
{
#*****Field Reference *************
 
#MAC=$1
#NAME=$2
#OPERATION=$3
#SUCCESS=$4
 
#************************************
 
#Because in the end statement we will have to loop through one of the arrays, which will be localized according
#to specific aritmetic operations (- + / *). We need to account for the fact that some students may not answer a
#question with one of these operations, and if we looped through that particular operation, we would not represent
#that student in any of the logic containted within that loop in the END{} statment. Therefore an associative array
#which absolutely, accounts for any student, contained in the .dat, the CLASS[] array.
CLASS[$2]
 
#any line that has division, but not necessarily just. 
if ( match($3, /\//) )
{
#How many division problem student $2 encounters = divison[$2]
division[$2]++
if ( $4 == "1" )
{
division_correct[$2]++
}
}
#any line with multiplication but not  neccearily just multiplication
if ( match($3, /\*/) )
{
#How many multiplication problem student $2 encounters = multiplication[$2]
multiplication[$2]++
if ( $4 == "1" )
{
multiplication_correct[$2]++
}
 
}
#any line with addition but not necessarily just addition
if ( match($3, /\+/) )
{
#How many addition problem student $2 encounters = addition[$2]
addition[$2]++
if ( $4 == "1" )
{
addition_correct[$2]++
}
}
#contains subtractions, excludes negative numbers, as it only matches expressions with a "-" sandwiched b/w two digits
if ( match($3, /[0-9]\-[0-9]/) ) 
{
#How many subtraction problem student $2 encounters = subtraction[$2]
subtraction[$2]++
if ( $4 == "1" )
{
subtraction_correct[$2]++
}
}
 
 
# Matches operations with ONLY DIVISION
if ( match($3, /\//) && !match($3, /[0-9]\-[0-9]/) && !match($3, /\+/) && !match($3, /\*/) )
{
 
#How many ONLY division problem student $2 encounters = 0_divison[$2]
o_division[$2]++
if ( $4 == "1" )
{
o_division_correct[$2]++
}
 
}
# Matches operations with ONLY SUBTRACTION
if (  !match($3, /\//) && match($3, /[0-9]\-[0-9]/) && !match($3, /\+/) && !match($3, /\*/) )
{
#How many ONLY subtraction problem student $2 encounters = o_subtraction[$2]
o_subtraction[$2]++
if ( $4 == "1" )
{
o_subtraction_correct[$2]++
}
}
# Matches operations with ONLY ADDITION
if (  !match($3, /\//) && !match($3, /[0-9]\-[0-9]/) && match($3, /\+/) && !match($3, /\*/) )
{
#How many ONLY Addition problem student $2 encounters = o_addition[$2]
o_addition[$2]++
if ( $4 == "1" )
{
o_addition_correct[$2]++
}
 
}
# Matches operations with ONLY MULTIPLICATION
if (  !match($3, /\//) && !match($3, /[0-9]\-[0-9]/) && !match($3, /\+/) && match($3, /\*/) )
{
#How many ONLY MULTIPLICATION problem student $2 encounters = o_multiplication[$2]
o_multiplication[$2]++
if ( $4 == "1" )
{
o_multiplication_correct[$2]++
}
}
 
#How many problems an individual student faced: for classwide statistics we simply use the built-in var NR
numproblems[$2]++
 
#Determine if it is a compound operation if so increment by one, this requires 4 if's as we have to check if each of them exists in
# conjuntion with another.
#Keep track of total compounds and compounds correct.
#Else-if structure required because if stringed If's were used each compound match would register twice.
 
if ( match($3, /\//) && ( match($3, /[0-9]\-[0-9]/) || match($3, /\+/) || match($3, /\*/) ) )
{
compound[$2]++
if ($4 == "1") #if correct
{
compound_correct[$2]++
}
}
else if (  match($3, /[0-9]\-[0-9]/) && (match($3, /\//) || match($3, /\+/) || match($3, /\*/) ) )
{
compound[$2]++
if ($4 == "1") #if correct
{
compound_correct[$2]++
}
 
}
else if ( match($3, /\+/) && ( match($3, /[0-9]\-[0-9]/) || match($3, /\//) || match($3, /\*/) ) )
{
compound[$2]++
if ($4 == "1") #if correct
{
compound_correct[$2]++
}
}
else if  ( match($3, /\*/) && ( match($3, /\+/) ||  match($3, /[0-9]\-[0-9]/) || match($3, /\//) ) )
{
compound[$2]++
if ($4 == "1") #if correct
{
compound_correct[$2]++
}
}
else # This allows for easy way to harness non compound statements, instead of going through a whole new slew of logic statements.  
{
 
non_compound[$2]++
if ($4 == "1") #if correct
{
non_compound_correct[$2]++
}
 
}
 
 
if ( $4 == "1" )
{totalcorrect[$2]++}
}#end of AWK_MAIN
END{
 
 
#loops through all of the elements in the array CLASS[]
#Here We will print out the students
 
for (student in CLASS)
{
 
# A student doesnt understand order of operations if their is a greater than 20% difference in between compound
# operations and single operation instructions, but only if lower on the compound instruction side.
 
if ( ( (non_compound_correct[student] / non_compound[student]) - (compound_correct[student] / compound[student]) > .2 ) ||
( (non_compound_correct[student] / non_compound[student]) ) < .7)
{
understands= "no"
}
else
{
understands= "yes"
}
 
 
#need to address divide by 0 issue
printf("%-11s%-8s%-11s%-8s%-11s%-8s%-11s%-8s%-11s%-11s\n", student,
int(o_addition_correct[student]*100/o_addition[student]), int(addition_correct[student]*100/addition[student]),
int(o_subtraction_correct[student]*100/o_addition[student]), int(subtraction_correct[student]*100/subtraction[student]),
int(o_multiplication_correct[student]*100/o_multiplication[student]),
int(multiplication_correct[student]*100/multiplication[student]), int(o_division_correct[student]*100/o_division[student]),
int(division_correct[student]*100/division[student]), understands) 
 
 
}
 
} #end of AWK_END
 
 
</pre>
 
==After Class Plans==
 
Wesley Dillingham will continue this project into the summer as part of RIT's cooperative education program.
 
Jeremiah Green will continue working on this project when time is available to devote.
Retrieved from "https://wiki.sugarlabs.org/go/Teacher_Reporting"