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

▶
con2dis 2 0
SMART_READER_LITE
LIVE PREVIEW

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

Aug 22, 2023 393 likes •665 views

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

slide-1
SLIDE 1

CON2DIS 2.0

Ruo Zhang Dhamma Kimpara Anagha Indic

slide-2
SLIDE 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

slide-3
SLIDE 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

slide-4
SLIDE 4
slide-5
SLIDE 5
slide-6
SLIDE 6

New Layout of CON2DIS

slide-7
SLIDE 7

Module 1: Question from Lab

  • Question Bank - Current Score - Question ID - Total Score

to change parameters of the signal.

slide-8
SLIDE 8

Module 1: Writing the Questions

  • In order to write questions, one must understand the user
slide-9
SLIDE 9
slide-10
SLIDE 10

Module 1: Pulling Question from Lab Table

  • Question Bank

<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; while ($i<=$_SESSION['count2']) { $row2 = mysqli_fetch_array($result2,MYSQLI_ASSOC); $i = $i+1; } $_SESSION['count2'] = $_SESSION['count2'] + 1; if ($_SESSION['count2']>=$max2) {$_SESSION['count2'] = 0;}

Questions

slide-11
SLIDE 11

Module 1: Echoing Question from Lab Table

  • Current Score - Question ID
slide-12
SLIDE 12

Module 1: Pulling Total Score from Lab Table

  • Total Score (More Efficient Way!)
slide-13
SLIDE 13

Module 2: Buttons (Submission & Verification)

  • Next Lab - Submit State - User ID - CheckOff

to change parameters of the signal.

slide-14
SLIDE 14

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;

slide-15
SLIDE 15

Module 2: Submission(javascript)

  • XMLHttp (Alternative?)
  • Values to be wrapped & send

Fo Fs Phase ID Sec Username

slide-16
SLIDE 16

Module 3: Submission & Verification(php)

  • Receive State
  • Verify State
  • Update State

in database

slide-17
SLIDE 17

Module 3: Submission & Verification(php)

  • Receive Username
  • Update User

in database

  • Session (Alternative?)
slide-18
SLIDE 18

Code Structure

  • HTML5 + CSS + Javascript +JSXGraph Library + PHP + MySQL
slide-19
SLIDE 19

Code Structure

  • HTML5 + CSS + Javascript +JSXGraph Library + PHP + MySQL

ButtonClick (Post)+Javascript Database Php Code Access Echo into format contain Lab Question Performance Return

slide-20
SLIDE 20

Code Structure

Labs (Question) Total Score

slide-21
SLIDE 21

Code Structure Original Thought (Join 2 tables) Data structure set up incorrectly What new data structure?

Performance (Total Score) Lab Question+ StudentID

slide-22
SLIDE 22

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

slide-23
SLIDE 23

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
slide-24
SLIDE 24

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
slide-25
SLIDE 25

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