ImpactNetwork

A Data Collection and Formatting Project To Extract Insight From The Perceived Impact Network Of A Graduating Secondary School Class And Its Corralation To Key Variables (Java, SQL, JDBC, Google SheetAPI, Gephi)

Dynamic.SIMPLE.mp4

PROJECT OUTLINE:

OUTLINE (1,2):

Project Description(1,2).pdf

Conversion And Matching From GoogleSheets to SQL Database (3):

https://github.com/lduncan1712/BridgeApplication3

Database Schema (4):

Weighting/Scaling Edges (5):

The Debatably Most Important Portion Of This Process Is Correctly Scaling The Edges Using The Data Given

To This End, I Have Formulated 4 Possible Weighting Calculations (That Each Emphasize A Certain Aspect, But Possess A Respective Downside)

Goals And Axioms That Form The Basis Of This Relatively Intuitive Logic

  Axioms.pdf

Weights (1-4) (Simplest To Most Complex)

   S₁ = s₁ + s₂ (simple sum)

   S₂ = s₁ + s₂ (simple product)

  (the following weights have different cases, case1 = both nodes participate, case 2 = only one)

   S₃ = (s₁/et₁) + (s₂/et₂)   (gives each participating node an influence of 1)

     = (s₁/et₁)

   S₄ = (s₁/et₁)(s₂/et₂)(s₁*s₂)   (scaled product: combining exponential reciprocity with relative importance)

     = (s₁/et₁)*(s₁)*2

(where s_n refers to directed outward strength of node n on this edge, and et_n refers to the sum of node n's directed outward strength among all its outward edges

GEPHI (6,7)

File https://github.com/lduncan1712/ImpactNetwork/blob/main/impact_network_(4)_CREATE_CSV.sql provides various oportunities to create visualizations, allowing choice to preconstructved weight, directed/undirected, and dynamic/undynamic

TAKEAWAYS

MAIN TAKEAWAYS (QUANTATATIVE)

(Coloured By Previous) (Coloured By Modularity Class (0.75)

(Coloured By Modularity Class (2.5)

(Time Of First Reference (Inclusion)) (Sized By Degree)

REPLICATION AND MODIFICATION

Anyone interested in modifying or replicating this project follow these steps

1) Replicate "impact_network" Database (or Modify) using impact_network_(1)_CREATE_DB.sql

2) Insert starting entries to it using starting entries, as well as adding file containing all participant names as "nodes"

3) Create Stored Procedures Required By "BridgeApplication3" To impact_network Using

Procedure1 and Procedure2

4) Convert Survey Responses (and Match) using BridgeApplication3

5) Complete Post Conversion Final Formatting (to differentiate neglected vs non participant) using SetUnreferencedTo-1

6) Set overall Edge Strength using SetFinalEdgeStrength

7) Create CSV file to be used by Gephi for visualization MakeCSV

8) Run Additional Calculations (Optional)