con2dis 2 0
play

CON2DIS 2.0 Ruo Zhang Dhamma Kimpara Anagha Indic Spring 2016 - PowerPoint PPT Presentation

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


  1. CON2DIS 2.0 Ruo Zhang Dhamma Kimpara Anagha Indic

  2. 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

  3. 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

  4. New Layout of CON2DIS

  5. Module 1: Question from Lab - Question Bank - Current Score - Question ID - Total Score to change parameters of the signal.

  6. Module 1: Writing the Questions - In order to write questions, one must understand the user

  7. 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;}

  8. Module 1: Echoing Question from Lab Table - Current Score - Question ID

  9. Module 1: Pulling Total Score from Lab Table - Total Score (More Efficient Way!)

  10. Module 2: Buttons (Submission & Verification) - Next Lab - Submit State - User ID - CheckOff to change parameters of the signal.

  11. 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;

  12. Module 2: Submission(javascript) - XMLHttp (Alternative?) - Values to be wrapped & send Fo Fs Phase ID Sec Username

  13. Module 3: Submission & Verification(php) - Receive State - Verify State - Update State in database

  14. Module 3: Submission & Verification(php) - Receive Username - Update User in database - Session (Alternative?)

  15. Code Structure - HTML5 + CSS + Javascript +JSXGraph Library + PHP + MySQL

  16. Code Structure - HTML5 + CSS + Javascript +JSXGraph Library + PHP + MySQL Echo into format Php Code ButtonClick (Post)+ Javascript Return Access Lab Question contain Database Performance

  17. Code Structure Labs (Question) Total Score

  18. Code Structure Performance (Total Score) Original Thought (Join 2 tables) Data structure set up incorrectly Lab Question+ What new data structure? StudentID

  19. 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

  20. 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

  21. 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 ●

  22. 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