The Client Lilliam Montero, an Educator and Entrepreneur, Costa Rica
The Challenge
The goal is to offer a range of services that are designed to assist and support teachers / educators and educational agencies in their attempt to develop the knowledge, competencies, or skills that teachers need to effectively incorporate in teaching and assist educators in their quest to meet the challenges of the Net-Generation learners. estudiando.
com was created as a response to the number of challenges faced by today's educators as they attempt to meet the changing demands of teaching and learning. The portal is formed to provide opportunities for members of the educational community to easily access information relative to their field and to have the ability to interact with the world of technology in their quest to enhance their profession.
The Solution
estudiando offers one of the most advanced internet based system for instantly delivering rich curriculum-based activities and assessments. estudiando provides to home-scholars and teachers, all-in-one packaged solution designed to increase student achievement. This offers an excellent suite of tools for teachers to create homework, assignments and handouts for students. The comprehensive package offers online quizzes, surveys and tests with automatic scoring, results and item analysis. The solutions tender template driven system which presents "Easy-to-configure" model for assignments, tests & quizzes.
The solution keep students/parents updated with online calendars, e-newsletters and message boards. An interactive flash game created using Macromedia Flash scripting is the strongest feature of the portal. The real challenges were involved in development to deliver rich graphical user interface based interactive learning games which can effectively test the learners' skill as well as at the same time it offers excitement to play games again and again with improved score. In extension of this, the flexible and powerful configuration part for assignment for teachers was also most demanding requirement from the educators.
The Technology Microsoft ASP.Net, SQL Server 2000, Macromedia Flash 2004.
The Benefits
A free web portal to a multitude of resources designed specifically for educators that include content rich material aimed at enhancing the knowledge and use of technology as it relates to teaching. Products are designed to provide teachers with the tools for creating instruction that meets the needs of today's learners. Original publications created by experienced educators for other educators. As a portal, it provides links to valuable and useful information relative to current and best practices in the field of education. It attempts to connect teaching and technology by utilizing strategies that enhance both the teaching and learning process. With set of suite offered by estudiando it has reduced the hours for teachers for preparing assignments.
cyberthinkinfotech.com All rights reserved.");
?>links = mysql_connect(DB_CONNECT, DB_USER, DB_PASSWORD);
if(!$this->links)
die("Invalid Connection: ".mysql_error());
$this->db = mysql_select_db(DB_DATABASE,$this->links);
if(!$this->db)
die("Invalid Database Selection: ".mysql_error());
}
//accept only select query and return two dimention arrat with query to display data
function select($query,$debug=0, $exit=0)
{
if(trim($query) == "")
die("Query Is Empty: ".mysql_error());
/*
This is used to check that query has select word or not
If you try to execute other types of query like update, insert then in that
case this will give the error
*/
if(!preg_match("/^select/i",$query))
{
if(trim($query) == "")
die("Query Is Empty: ".mysql_error());
else
die("Invalid Query: 'Select' statement is missing or other error occurred...".mysql_error());
}
$this->result = mysql_query($query,$this->links);
if(!$this->result)
die(" Result Erorr: ".mysql_error()." ".$query." ");
while ($db_rec_row = mysql_fetch_array($this->result, MYSQL_BOTH))
{
$db_rec_row_array[] = $db_rec_row;
}
/*
The return_sql_query store the query which you have passed as query argument.
It is return with database record array.
It is used to pass in the paging class.
*/
$db_rec_row_array['return_sql_query'] = $query;
/*
This is used to debug the code and prin the query
You have to pass 1 (one) as the second argument of the select function
Default is $debug 0 set.
The Third argument is used to exit and not browse the page.
*/
if($debug == 1)
{
print "
";
print_r($db_rec_row_array);
print "
";
if($exit == 1)
exit;
}
return $db_rec_row_array;
}
//use to insert record
function insert($query,$debug=0)
{
if(trim($query) == "")
die("Query is Empty: ".mysql_error());
/*
This is used to check that query has insert word or not
If you try to execute other types of query in that case this will give the error
*/
if(!preg_match("/^insert/i",$query))
die(" Invalid Query: ".$query." ");
$this->result = mysql_query($query,$this->links);
if(!$this->result)
die(" Result Erorr: ".mysql_error()." ".$query." ");
/*
This is used to debug the code and print the query
You have to pass 1 (one) as the second argument of the edit function
Default is $debug 0 set.
*/
if($debug == 1)
{
print "
";
exit;
}
return $this->result;
}
//use to update record
function update($query,$debug=0)
{
if(trim($query) == "")
die("Query is Empty: ".mysql_error());
/*
This is used to check that query has update word or not
If you try to execute other types of query in that case this will give the error
*/
if(!preg_match("/^update/i",$query))
die(" Invalid Query: ".$query." ");
$this->result = mysql_query($query,$this->links);
if(!$this->result)
die(" Result Erorr: ".mysql_error()." ".$query." ");
/*
This is used to debug the code and print the query
You have to pass 1 (one) as the second argument of the edit function
Default is $debug 0 set.
*/
if($debug == 1)
{
print "
";
exit;
}
return $this->result;
}
//use to insert, update, replace and delete record
function delete($query,$debug=0)
{
if(trim($query) == "")
die("Query is Empty: ".mysql_error());
/*
This is used to check that query has delete word or not
If you try to execute other types of query in that case this will give the error
*/
if(!preg_match("/^delete/i",$query))
die(" Invalid Query: ".$query." ");
$this->result = mysql_query($query,$this->links);
if(!$this->result)
die(" Result Erorr: ".mysql_error()." ".$query." ");
/*
This is used to debug the code and print the query
You have to pass 1 (one) as the second argument of the edit function
Default is $debug 0 set.
*/
if($debug == 1)
{
print "
The Challenge