CON2DIS 2.0 Ruo Zhang Dhamma Kimpara Anagha Indic
Spring 2016 Project Objectives ● Utilize CON2DIS GUI from Fall 2015 ● Extend a database aspect to the GUI ● Find the link between Javascript and PHP ● Create a collection of questions that aid a student in learning Nyquist frequency and sampling ● Analyze the user’s learning patterns through the interactive components of CON2DIS
Project Overview ● Continuous-Discrete Sampling Demo (CON2DIS) ○ Program that shows continuous and discrete spectra of input and reconstructed signals during sampling ○ Covers content in Nyquist Theorem and Sampling Theorem ● An extension to this program: implement a database component to CON2DIS
New Layout of CON2DIS
Module 1: Question from Lab - Question Bank - Current Score - Question ID - Total Score to change parameters of the signal.
Module 1: Writing the Questions - In order to write questions, one must understand the user
Module 1: Pulling Question from Lab Table Questions - Question Bank while ($i<= $_SESSION['count2']) { <div align="center" class="question">Question from Lab $row2 = mysqli_fetch_array($result2,MYSQLI_ASSOC); if($_SERVER["REQUEST_METHOD"] == "POST") { $i = $i+1; $sql = "SELECT question,score,id FROM Labs"; } $result2 = mysqli_query($db,$sql); $_SESSION['count2'] = $_SESSION['count2'] + 1; $max2 = mysqli_num_rows($result2); if ($_SESSION['count2']>=$max2) $i = 0; {$_SESSION['count2'] = 0;}
Module 1: Echoing Question from Lab Table - Current Score - Question ID
Module 1: Pulling Total Score from Lab Table - Total Score (More Efficient Way!)
Module 2: Buttons (Submission & Verification) - Next Lab - Submit State - User ID - CheckOff to change parameters of the signal.
Module 2: Submission(html) - Next Lab Question - Submit State - User ID - CheckOff <div align="center" class="question">Question from Lab if($_SERVER["REQUEST_METHOD"] == "POST") { $sql = "SELECT question,score,id FROM Labs"; $result2 = mysqli_query($db,$sql); $max2 = mysqli_num_rows($result2); $i = 0;
Module 2: Submission(javascript) - XMLHttp (Alternative?) - Values to be wrapped & send Fo Fs Phase ID Sec Username
Module 3: Submission & Verification(php) - Receive State - Verify State - Update State in database
Module 3: Submission & Verification(php) - Receive Username - Update User in database - Session (Alternative?)
Code Structure - HTML5 + CSS + Javascript +JSXGraph Library + PHP + MySQL
Code Structure - HTML5 + CSS + Javascript +JSXGraph Library + PHP + MySQL Echo into format Php Code ButtonClick (Post)+ Javascript Return Access Lab Question contain Database Performance
Code Structure Labs (Question) Total Score
Code Structure Performance (Total Score) Original Thought (Join 2 tables) Data structure set up incorrectly Lab Question+ What new data structure? StudentID
Advantages and Disadvantages of PHP and SQL ● Advantages Already used in ITS system ○ ○ Wide array of helpful external resources and documentation Optimized for making web applications quickly and efficiently ○ Disadvantages ● ○ PHP can be extremely difficult to debug Difficult to implement algorithms in PHP ○ ○ SQL tables are difficult to join together
Challenges and Solutions ● Creating question bank Storing Data in the database: ● ○ XMLHttpRequest ○ Attempted to solve with jQuery Recording time spent on webpage ● ○ Looked at timeMe.js which was too involved Simple solution using built-in Javascript functions ○ ● Issues with how page is displayed by different browsers
Learning Outcome Technical Usage of Github to collaborate ● ● Familiarity with Linux System Command Line ● Mastery of Javascript, CSS, JSXGraph, PHP, SQL Team Skills ● Team coordination Accepting and giving suggestions ● Time management ●
Future Work ● Replace existing code connecting to PHP with jQuery Use a more accurate method to measure time spent on a page ● Add more questions into the question bank ● ● Improve GUI functionality ● Joining database tables More efficient way to calculate the total score ● Utilizing the stored state data ● ● Ensure consistency between browsers
Recommend
More recommend