reportxy

Skills Assessment

[insert_php]
//print it

//end print instructions
//print it
$relevant=$_GET[’emailid’];
echo “

for $relevant

“;
[/insert_php]

Version 1.0

[insert_php]date_default_timezone_set(‘UK/London’);$date = date(‘m/d/Y h:i:s a’, time());echo $date;[/insert_php]

1.0 Audit configuration

1.1 Participants

[insert_php]
global $wpdb;
$relevant=$_GET[’emailid’];
$fid=$_GET[‘fid’];
echo “This report is for :”.$relevant.PHP_EOL.PHP_EOL;
$current_user = wp_get_current_user();
$fordb=$current_user->user_login;
$uem=$current_user->user_email;
//echo $uem.PHP_EOL;
$experiflaps= $_GET[‘title’];
if (empty($experiflaps)) {
$formid=$current_user->description;}
if (!empty($experiflaps)) {
echo $experiflaps;
$formid= $_GET[‘title’];}

$get_admins = array(
‘role’ => ‘subscriber’,
);
$filterz=’http://’.$fordb;
///experiment begins here
$args = array(
‘search’ => $filterz,
‘search_columns’ => array( ‘user_url’ )
);
$user_query = new WP_User_Query($args);
$users = (array) $user_query->results;
usort( $users, function( $a, $b ) use( $uids ) {
return array_search( $a->ID, $uids) < array_search( $b->ID, $uids ) ? -1 : 1;
} );
// use as usual
foreach ( $users as $user ) {
// echo ‘

‘ . $user->display_name . ‘

‘;
}

//ends here

//$tryout=get_users();
//print_r($tryout);

$current_user = wp_get_current_user();
$fordb=$current_user->user_login;
//$blogusers = get_users($get_admins);
$blogusers=$users;
//echo “So-far, a total of “.count($blogusers).” participants were sent invites to //complete the audit, across a wide set of disciplines, as per the list below: -“;echo PHP_EOL;echo PHP_EOL;
//foreach ($blogusers as $user) {
//echo $user->user_email;echo PHP_EOL;}
$blogusers=$relevant;
[/insert_php]

1.2 Skills questions

[insert_php]
global $wpdb;
$current_user = wp_get_current_user();
$fordb=$current_user->user_login;
$uem=$current_user->user_email;
//echo $uem.PHP_EOL;
$experiflaps= $_GET[‘title’];
if (empty($experiflaps)) {
$formid=$current_user->description;}
if (!empty($experiflaps)) {
echo $experiflaps;
$formid= $_GET[‘title’];}

//begin
if (!empty($fid)) {
$formid=$fid;}

//echo “Form number >”.$formid.PHP_EOL;

$sql=”SELECT layout FROM i5513773_wp1.wp_fsq_form WHERE id=$formid”;
$sqll=”SELECT design FROM i5513773_wp1.wp_fsq_form WHERE id=$formid”;
$fname= $wpdb->get_var($sql);
$testing= $wpdb->get_var($sqll);

$sections=((substr_count($fname, ‘”title”‘))-1);
//echo “Number of sections>”.$sections.PHP_EOL;
$finda='”title”‘;
$findb=”subtitle”;

$headings=array();$totalq=array();

for ($x = 2; $x <= $sections; $x++) { $sectiona=strposx($fname,"timer",$x); $sectionb=strposx($fname,"timer",$x+1); $newsection=substr($fname,$sectiona,($sectionb-$sectiona)); $quests=substr_count($newsection,"container"); //echo "Quests>“.$quests;
$totalq[$x-1]=$quests;
$posa=strposx($fname,$finda,$x+1);
$posb=strposx($fname,$findb,$x+1);
$newstring=substr($fname,$posa+10,(($posb-10)-$posa));
$quotestart=strposx($newstring,'”‘,1);
$quoteend=strposx($newstring,'”‘,2);
$newstring=substr($newstring,$quotestart+1,(($quoteend-$quotestart)-1));
//echo $newstring.PHP_EOL;
$headings[$x-1]=$newstring;
}
//print_r($headings);
//print_r($totalq);

//$sql=”SELECT mcq FROM i5513773_wp1.wp_fsq_form WHERE id=’7′”;
//$fname= $wpdb->get_var($sql);
//echo “Number of questions>”.((substr_count($fname, ‘”slider”‘))/2).PHP_EOL;
//$qtot=((substr_count($fname, ‘”slider”‘))/2);

//echo $fname.PHP_EOL.PHP_EOL;

mysqli_close();

function rev ($string, $char)
{
if (false !== strrpos ($string, $char))
{
return strlen ($string) – strrpos ($string, $char) – 1;
}
}

//extract sub questions

$count=0;$qnumber=0;
$subq=array();

foreach($headings as $key => $value) {

for ($x = 1; $x <= $totalq[$key]; $x++) {$finder="Question P".($x+$qnumber); //echo $finder.PHP_EOL; $whereit=strpos($testing,$finder); $keepers=substr($testing ,0,$whereit); $whereit2=rev($keepers,"richtext"); $whereit3=strlen($keepers)-$whereit2; $lengy=$whereit3-$whereit; //echo "HERE ".$whereit." IS IS ".$whereit3." LENG>“.$lengy.PHP_EOL;
$mememe=substr($testing,$whereit3,($whereit-$whereit3));
$gobegin=strposx($mememe,”:”,4);
$goend=strposx($mememe,”:”,5);
$tada=substr($mememe,$gobegin+2,($goend-$gobegin)-5);
$count=$count+1;$subq[$count]=$tada;
//echo $tada.PHP_EOL;
}
$qnumber=$qnumber+$totalq[$key];
}

$len = count($subq);
//echo “Lengbth>”.$len;
$nsq = array_slice($subq,0,$len/2);
//print_r($nsq);

$resulttable=”wp_fsqm_direct_”.$formid;

$sqll=”SELECT count(id) FROM $resulttable”;
$resulter= $wpdb->get_var($sqll);
//echo “THIS IS IT>”.$resulter.PHP_EOL;
//echo $sqll.PHP_EOL;

$sqll=”SELECT pinfo0 FROM $resulttable”;
$namelist=$wpdb->get_results($sqll);
//print_r($namelist);
$namelistfull=array();
foreach ($namelist as $key => $value) {
$namelistfull[$key]=$value->pinfo0;
}
//print_r($namelistfull);

for ($x = 1; $x <= $resulter; $x++) { $offer=$x-1; //PERSONALISATION $sql="SELECT * FROM $resulttable WHERE pinfo1='$relevant' ORDER BY id LIMIT 1 OFFSET $offer"; //echo $sql; $resultz= $wpdb->get_row($sql);
//print_r($resultz);

$userinput=array();$count=0;

foreach ($resultz as $key => $value) {
$subs = substr($key, 0, 3);
if ($subs==”mcq”){$count=$count+1;$userinput[$count]=$value;}
}
//print_r($userinput);
$len = count($userinput);
$r[$x]= array_slice($userinput,0, $len / 2);
$p[$x]=array_slice($userinput, $len / 2);
//print_r($r);
//print_r($p);

}

//print_r($r);//print_r($p);

$len = count($headings);
$newheadings= array_slice($headings,0, $len / 2);
//print_r($newheadings);
$totalqc=count($totalq);
$totalqc=$totalqc-1;
$sublooper = array_slice($totalq, 0, $totalqc / 2);
//echo “Total subqs”.$totalqc.PHP_EOL;
//print_r($sublooper);

$cola=array();$colb=array();$colc=array();$cold=array();$cole=array();

$fruit = array (
“0p0” => array(“0”),
“0p1” => array(“0”),
“0p2” => array(“0”),
“0p3” => array(“0”),
“0p4” => array(“0”),
“0p5” => array(“0”),
“0p6” => array(“0”),
“0p7” => array(“0”),
“0p8” => array(“0”),
“0p9” => array(“0”),
“0p10” => array(“0”),

“1p0” => array(“0”),
“1p1” => array(“0”),
“1p2” => array(“0”),
“1p3” => array(“0”),
“1p4” => array(“0”),
“1p5” => array(“0”),
“1p6” => array(“0”),
“1p7” => array(“0”),
“1p8” => array(“0”),
“1p9” => array(“0”),
“1p10” => array(“0”),

“2p0” => array(“0”),
“2p1” => array(“0”),
“2p2” => array(“0”),
“2p3” => array(“0”),
“2p4” => array(“0”),
“2p5” => array(“0”),
“2p6” => array(“0”),
“2p7” => array(“0”),
“2p8” => array(“0”),
“2p9” => array(“0”),
“2p10” => array(“0”),

“3p0” => array(“0”),
“3p1” => array(“0”),
“3p2” => array(“0”),
“3p3” => array(“0”),
“3p4” => array(“0”),
“3p5” => array(“0”),
“3p6” => array(“0”),
“3p7” => array(“0”),
“3p8” => array(“0”),
“3p9” => array(“0”),
“3p10” => array(“0”),

“4p0” => array(“0”),
“4p1” => array(“0”),
“4p2” => array(“0”),
“4p3” => array(“0”),
“4p4” => array(“0”),
“4p5” => array(“0”),
“4p6” => array(“0”),
“4p7” => array(“0”),
“4p8” => array(“0”),
“4p9” => array(“0”),
“4p10” => array(“0”),

“5p0” => array(“0”),
“5p1” => array(“0”),
“5p2” => array(“0”),
“5p3” => array(“0”),
“5p4” => array(“0”),
“5p5” => array(“0”),
“5p6” => array(“0”),
“5p7” => array(“0”),
“5p8” => array(“0”),
“5p9” => array(“0”),
“5p10” => array(“0”),

“6p0” => array(“0”),
“6p1” => array(“0”),
“6p2” => array(“0”),
“6p3” => array(“0”),
“6p4” => array(“0”),
“6p5” => array(“0”),
“6p6” => array(“0”),
“6p7” => array(“0”),
“6p8” => array(“0”),
“6p9” => array(“0”),
“6p10” => array(“0”),

“7p0” => array(“0”),
“7p1” => array(“0”),
“7p2” => array(“0”),
“7p3” => array(“0”),
“7p4” => array(“0”),
“7p5” => array(“0”),
“7p6” => array(“0”),
“7p7” => array(“0”),
“7p8” => array(“0”),
“7p9” => array(“0”),
“7p10” => array(“0”),

“8p0” => array(“0”),
“8p1” => array(“0”),
“8p2” => array(“0”),
“8p3” => array(“0”),
“8p4” => array(“0”),
“8p5” => array(“0”),
“8p6” => array(“0”),
“8p7” => array(“0”),
“8p8” => array(“0”),
“8p9” => array(“0”),
“8p10” => array(“0”),

“9p0” => array(“0”),
“9p1” => array(“0”),
“9p2” => array(“0”),
“9p3” => array(“0”),
“9p4” => array(“0”),
“9p5” => array(“0”),
“9p6” => array(“0”),
“9p7” => array(“0”),
“9p8” => array(“0”),
“9p9” => array(“0”),
“9p10” => array(“0”),

“10p0” => array(“0”),
“10p1” => array(“0”),
“10p2” => array(“0”),
“10p3” => array(“0”),
“10p4” => array(“0”),
“10p5” => array(“0”),
“10p6” => array(“0”),
“10p7” => array(“0”),
“10p8” => array(“0”),
“10p9” => array(“0”),
“10p10” => array(“0”),);

$allin=array();
for ($x = 1; $x <= $resulter; $x++) { foreach ($p[$x] as $key => $value) {
//echo $key;
$fruitref=$r[$x][$key].”p”.$p[$x][$key];
//echo $fruitref.PHP_EOL;
$fruitnow=$fruit[$fruitref][$x-1];
$fruitnow=$fruitnow+1;
$fruit[$fruitref][$x-1]=$fruitnow;

$datalog=”Null”;$gapo=999;
//relgoeshere
if ($r[$x][$key]>4){
$rscore=$r[$x][$key];
$pscore=$p[$x][$key];
$gapo=(int)($rscore-$pscore);
//echo $rscore.”>”.$pscore.”>”.$gapo.PHP_EOL;

if ($gapo==0){$cola[$key]=$cola[$key]+1;}
if ($gapo==1){$colb[$key]=$colb[$key]+1;}
if ($gapo==2){$colc[$key]=$colc[$key]+1;}
if ($gapo==3){$cold[$key]=$cold[$key]+1;}
if ($gapo>3){$cole[$key]=$cole[$key]+1;}
if ($r[$x][$key]-$p[$x][$key]>1){$datalog=”Medium”;}
if ($r[$x][$key]-$p[$x][$key]>3){$datalog=”Highly”;}
}

$allin[$x][$key]=$r[$x][$key].”,”.$p[$x][$key].”,'”.$datalog.”GAP>”.$gapo.”,”;

}
//print_r($fruit);
}
//print_r($allin);

$googleit=””;

for ($x = 1; $x <= $resulter; $x++) { foreach ($p[$x] as $key => $value) {
$fruitref=$r[$x][$key].”p”.$p[$x][$key];
$allin[$x][$key]=$allin[$x][$key].”,”.$fruit[$fruitref][$x-1];

$googleit=$googleit.”[‘X’,”.$allin[$x][$key].”],”.”
“;
}
}
//print_r($allin);

$googleit=substr($googleit, 0, -5);
$googlemore=substr($googlemore, 0, -5);
//echo $googleit;

//echo “ColumnA”.PHP_EOL;
//print_r($cola);

//echo “ColumnB”.PHP_EOL;
//print_r($colb);

//echo “ColumnC”.PHP_EOL;
//print_r($colc);

//echo “ColumnD”.PHP_EOL;
//print_r($cold);

//echo “ColumnE”.PHP_EOL;
//print_r($cole);

//echo “Results.”.$resulter.PHP_EOL;

[/insert_php]

[insert_php]
//print_r($nsq);
$totalqq=$totalqc/2;
echo “The audit consisted of “.array_sum($sublooper).” questions arranged in “.$totalqq.” themes. These were as follows:-“;
echo “
“;
$cntr=0;
for ($x = 0; $x <= $totalqq-1; $x++) { $themenum=$x+1; echo "

Theme “.$themenum.”: “.$newheadings[$x].”

“;
for ($y = 0; $y <= $sublooper[$x]-1; $y++) { echo "

“;ECHO $nsq[$cntr];echo “

“;
$cntr=$cntr+1;
}echo “
“;}

global $ipt_fsqm_info, $wpdb;
$current_user = wp_get_current_user();
$formid=$current_user->description;
$fordb=$current_user->user_login;
$syntax=’blog_id=1&orderby=nicename&role=subscriber’;
$blogusers = get_users($syntax);
$total=0;
foreach ( $blogusers as $user ) {
$ematch=$user->user_email;
$user = get_user_by( ’email’, $ematch );
$checker=$user->description;
if ($fordb==$checker){
//echo $ematch;
$sql=”SELECT mcq FROM i5513773_wp1.wp_fsq_data WHERE (form_id = $formid AND email=’$ematch’)”;
$myrows = $wpdb->get_var($sql);
if (empty($myrows)){echo ‘>’;$total=$total+1;} else {
$real=$real+1;}
}}
//echo $total.” participants failed to complete the survey in time”.PHP_EOL;
//begin print instructions

//echo “

Submissions in the last year

“;
//$construct=”

No data yet.

“;
//echo do_shortcode($construct);
//$construct=”

No data yet

“;

[/insert_php]

2.0 Breakdown

This section looks at the individual skills and skill themes to determine the overall training priorities for the individual.

[insert_php]

//begin addup
$googlemore=””;
foreach ($fruit as $key => $value) {
$goer=strpos($key,”p”);
$lefter=substr($key,0,$goer);
$righter=substr($key,$goer+1,strlen($key));
//echo “Left”.$lefter.PHP_EOL;
//echo “Right”.$righter.PHP_EOL;
$fruitcount[$key]=array_sum($fruit[$key]);
if ($fruitcount[$key]>0){
$datax=”Irrelevant”;
if ($lefter>4 && $righter<5){$datax="Problem";} if ($lefter>4 && $righter>=5){$datax=”Comfort”;}
$googlemore=$googlemore.”[‘”.$fruitcount[$key].”‘,”.$lefter.”,”.$righter.”,’$datax’,”.$fruitcount[$key].”],”.”
“;}
}

//echo “Total plots>”.count($fruitcount).PHP_EOL;

$googleit=””;

for ($x = 1; $x <= $resulter; $x++) { foreach ($p[$x] as $key => $value) {
$fruitref=$r[$x][$key].”p”.$p[$x][$key];
$allin[$x][$key]=$allin[$x][$key].”,”.$fruit[$fruitref][$x-1];
$legend=$fruit[$fruitref][$x-1];
$googleit=$googleit.”[‘$legend’,”.$allin[$x][$key].”],”.”
“;
}
}
//print_r($allin);
//print_r($fruit);

$googleit=substr($googleit, 0, -5);
$googlemore=substr($googlemore, 0, -5);

$totpeople=count($allin);
$totalqs=count($allin[1]);
$grandtot=$totpeople*$totalqs;
//print_r($fruit);

$peoplefre=0;
for ($x = 5; $x <= 10; $x++) { for ($y = 5; $y <= 10; $y++) { $refbot=$x."p".$y; $peoplefre=$peoplefre+array_sum($fruit[$refbot]); //echo "
“;
//echo $refbot.PHP_EOL;
//echo array_sum($fruit[$refbot]).PHP_EOL;
}}
//echo $peoplefre;
$complianta=”[‘Comfort’,”.$peoplefre.”]”;
$frazzy=$grandtot-$peoplefre;
//echo “Comfort zone where relevance is 5 and above and Proficiency 5 and above”.PHP_EOL;
$noncomp=”[‘Non-compliant’,”.($frazzy).”],”;
//echo “Total number of questions (participants x questions) :”.($frazzy+$peoplefre).PHP_EOL;
//echo $complianta.PHP_EOL;
//echo $noncomp.PHP_EOL;
//echo “

Ratio is: “.round($peoplefre/$frazzy,2).PHP_EOL.”

“;
$mathy=round($peoplefre/($peoplefre+$frazzy),2);
//$mathy=$mathy*100;
$mathy=$peoplefre;
$comfortmath=$mathy;
//echo “

Comfort: “.$mathy.”%”.PHP_EOL.”

“;
//echo “

Of those plots that are relevant…

“.PHP_EOL;
//echo “Peoplefre>”.$peoplefre.PHP_EOL;
$subsa=$peoplefre;

//SECOND CALCULATION
$totpeople=count($allin);
$totalqs=count($allin[1]);
$grandtot=$totpeople*$totalqs;

$peoplefre=0;
//relevant then proficinecy
for ($x = 5; $x <= 10; $x++) { for ($y = 0; $y <= 4; $y++) { $refbot=$x."p".$y; $peoplefre=$peoplefre+array_sum($fruit[$refbot]); //echo "
“;
//echo $refbot.PHP_EOL;
//echo array_sum($fruit[$refbot]).PHP_EOL;
}}
//echo $peoplefre;
$compliantb=”[‘Problem’,”.$peoplefre.”],”;
$frazzy=$grandtot-$peoplefre;
//echo “Comfort zone where relevance is 5 and above and Proficiency 5 and above”.PHP_EOL;
$noncomp=”[‘Non-compliant’,”.($frazzy).”],”;
//echo $compliantb.PHP_EOL;
//echo $noncomp.PHP_EOL;
//echo “

Ratio is: “.round($peoplefre/$frazzy,2).PHP_EOL.”

“;
$subsb=$peoplefre;
$totman=($subsa+$subsb);
//$mathy=round($peoplefre/($peoplefre+$frazzy),2);
$mathy=round($peoplefre/($totman),2);
$mathy=$mathy*100;
$poormath=$mathy;
//echo “Total>”.$totman.PHP_EOL;
//echo “

Problem: “.$mathy.”%”.PHP_EOL.”

“;
$comfortmath=round($comfortmath/$totman,2);$comfortmath=$comfortmath*100;
//echo “

Comfort: “.$comfortmath.”%”.PHP_EOL.”

“;
$diffy=$comfortmath-$poormath;
//echo “

Average Difference: “.$diffy.”%”.PHP_EOL.”

“;

//echo “The pie chart below shows the proportion of the entire sample which had issues compared to those which did not (for all skills which were //deemed as being relevant). “;

//$mathy=100-($comfortmath+$poormath);
//echo “

Irrelevants “.$mathy.”%”.PHP_EOL.”

“;
//$numbz=($mathy/100)*($peoplefre+$frazzy);
//echo “COMF”.$comfortmath;

$compliantb=”[‘Problem’,”.$mathy.”],”;
$mathy=$mathy+$comfortmath;
$less=(100-$mathy);
if ($less<0){$less=0;} $complianta="['Comfort',".$less."]"; //echo $compliantb;echo $irrels;echo $complianta; //PIE echo "

“;
echo “

“;
$keystore=0;
$totalqq=$totalqc/2;
//echo “THIS”.$totalqq;

$megacount=0;
//print_r($p);
for ($x = 0; $x <= $totalqq-1; $x++) { $loopscore=0; echo "

“;

for ($y = 0; $y <= $sublooper[$x]-1; $y++) { $megacount=$megacount+1; //echo "THIS IS mega".$megacount.PHP_EOL; $score=($cola[$keystore]*1)+($colb[$keystore]*2)+($colc[$keystore]*3)+($cold[$keystore]*4)+($cole[$keystore]*5); if (empty($cole[$keystore])){$bin="0";} else {$bin="1";} if (empty($cold[$keystore])){$bin=$bin."0";} else {$bin=$bin."1";} if (empty($colc[$keystore])){$bin=$bin."0";} else {$bin=$bin."1";} if (empty($colb[$keystore])){$bin=$bin."0";} else {$bin=$bin."1";} if (empty($cola[$keystore])){$bin=$bin."0";} else {$bin=$bin."1";} $binlen=strlen($bin); $gap=0;$max=0;$switch=0; for ($piss = 0; $piss <= $binlen; $piss++) { $agg=substr($bin, $piss, 1); //echo $agg.PHP_EOL; if ($agg=="1"){ if ($gap>$max){$max=$gap;
//echo “UPDATE”.PHP_EOL;
}
$gap=0;$switch=1;}

if ($agg==”0″ & $switch==”1″){
$gap=$gap+1;
//echo “GAP”.$gap.PHP_EOL;
}
}
if ($max==”0″){$message=”Negligible”;}
if ($max==”1″){$message=”Low”;}
if ($max==”2″){$message=”[highlight type=’dark’]Medium[/highlight]”;}
if ($max==”3″){$message=”[highlight]High[/highlight]”;}
if ($score==”0″){$message=”Irrelevant”;}

$pctt=round($score/($resulter*5)*100);
$totzeins=$cola[$keystore]+$colb[$keystore]+$colc[$keystore]+$cold[$keystore]+$cole[$keystore];
$pct=round(($totzeins/$resulter)*100);
echo “

“;

$keystore=$keystore+1;

#
}
$loopscore=round($loopscore/$sublooper[$x]);
$mycats[$x]=$loopscore;
//echo “

“;

}

//REMINDER
//print_r($filtermeagain);
asort($filterme);
asort($filtermeagain);
$revme = array_reverse($filterme);
$revmeagain = array_reverse($filtermeagain);
//print_R($revme);

//sort an array
foreach ($revmeagain as $key => $value){
$labelagain=strval($revmeagain[$key][1]);
$labelagain=str_replace(“‘”, “”, $labelagain);
$labzagain=”.$labelagain.”;
//$labz=”hello”;
if (($revmeagain[$key][0]>=4)){$colkey=”color: green”;}
if (($revmeagain[$key][0]<4)){$colkey="color: red";} $bargraphitagain=$bargraphitagain."['$labzagain',".$revmeagain[$key][0].",'$colkey'],"; } $bargraphitagain=substr($bargraphitagain, 0, -1); $maxeragain=count($revmeagain); $maxeragain=$maxeragain-1; //sort an array foreach ($revme as $key => $value){
$label=strval($revme[$key][1]);
$label=str_replace(“‘”, “”, $label);
$labz=”.$label.”;
//$labz=”hello”;
if (($revme[$key][0]>=4)){$colkey=”color: green”;}
if (($revme[$key][0]<4)){$colkey="color: red";} $bargraphit=$bargraphit."['$labz',".$revme[$key][0].",'$colkey'],"; } $bargraphit=substr($bargraphit, 0, -1); $maxer=count($revme); $maxer=$maxer-1; //sort lower than 4s $looper=0; foreach ($revme as $key => $value){
$currentval=strval($revme[$key][0]);
if ($currentval<=4){ $relevantlowz[$looper]=$relevantlows[$key].strval($revme[$key][1]); $looper=$looper+1; } } [/insert_php]

2.1 Training priorities by individual skills

The skill of “[insert_php]echo $revme[0][1];[/insert_php]” was rated as having the most relevance across the cohort and the skill of “[insert_php]echo $revme[$maxer][1];[/insert_php]” was rated as having the least relevance across the cohort.

Skills with an average relevance of 4 or lower (suggesting that they are either highly specialised, outsourced, not needed or not applied. ) are: –

[insert_php]
foreach ($relevantlowz as $key => $value){
echo “

“.$relevantlowz[$key].”

“;
}
[/insert_php]

The next graph shows the average relevance score for all skills across the group of participants.

The next graph shows each skill and how they were scored in relation to average proficiency. The skills have been ordered in terms of descending score.

The skill of “[insert_php]echo $revmeagain[0][1];[/insert_php]” was rated as having the most proficiency across the cohort and the skill of “[insert_php]echo $revmeagain[$maxeragain][1];[/insert_php]” was rated as having the least proficiency across the cohort.

[insert_php]
//print_r($relraw);
//print_r($subq);
foreach ($roundydiff as $key => $value){
$result[$key][0]=$subq[$key];
$result[$key][1]=$roundydiff[$key];
$result[$key][2]=$pchecking[$key];
$result[$key][3]=$totcheck[$key];
}
echo “

“;
aasort($result,”1”);
$result=array_reverse($result);

//echo “

Question	Relevance avg	Proficiency avg	Difference”; echo “
“.$newheadings[$x].”
“.($keystore+1).”.”.$nsq[$keystore].”	“; $colbar=”style=’background-color: #5fb341′”; if ($pct>33){$colbar=”style=’background-color: #abc'”;} if ($pct>66){$colbar=””;} $totur=0;$totup=0; for ($people = 1; $people <= $resulter; $people++) { $totur=$totur+$r[$people][($megacount-1)]; $totup=$totup+$p[$people][($megacount-1)]; } $totur=$totur/$resulter; $totup=$totup/$resulter; $totround=round($totur,1); $totroundy=round($totup,1); echo $totround; $totcheck[$megacount]=$totzeins; $pchecking[$megacount]=$totround; $filterme[$megacount][0]=$totround; $filterme[$megacount][1]=$nsq[$megacount-1]; $filtermeagain[$megacount][0]=$totroundy; $filtermeagain[$megacount][1]=$nsq[$megacount-1]; echo "	“; echo $totroundy; echo “	“; $priority=round(($pct*$pctt)/100); $colbar=”style=’background-color: #5fb341′”; if ($priority>33){$colbar=”style=’background-color: #abc'”;} if ($priority>66){$colbar=””;} $loopscore=$loopscore+$priority; $roundydiff[$megacount]=$totround-$totroundy; echo $roundydiff[$megacount]; echo “
“.$loopscore.”

“;echo “

“;
//foreach ($result as $key => $value){
//echo “

“;
//echo “

“;
//}
//echo “

R-P difference	Skill
“;echo $result[$key][1];echo “	“;echo $result[$key][0];echo “

“;

//rminusptable

//sort an array
$learn=0;
foreach ($result as $key => $value){
$labelrp=strval($result[$key][0]);
$labelrp=str_replace(“‘”, “”, $labelrp);
$labzrp=”.$labelrp.”;
//echo $result[$key][1].”
“;
if (($result[$key][1]>=1)){$colkey=”color: orange”;$learnit[$learn]=$labzrp;}
if (($result[$key][1]>=2)){$colkey=”color: red”;$learnit[$learn]=$labzrp;}
if (($result[$key][1]<1)){$colkey="color: green";} $learn=$learn+1; $rminusp=$rminusp."['$labzrp',".$result[$key][1].",'$colkey'],"; } $rminusp=substr($rminusp, 0, -1); //funtion function aasort (&$array, $key) { $sorter=array(); $ret=array(); reset($array); foreach ($array as $ii => $va) {
$sorter[$ii]=$va[$key];
}
asort($sorter);
foreach ($sorter as $ii => $va) {
$ret[$ii]=$array[$ii];
}
$array=$ret;
}

[/insert_php]

The next graph shows the difference between average relevance and average proficiency. The skills are then arranged in descending order of score. Consequently, those skills which appear near the top of the graph (where relevance is greater than proficiency) are most significant in terms of an overarching training need whereas the skills near the bottom (where proficiency is greater than relevance) are least significant in terms of an overarching training need.

2.2 Summary table : average score breakdown across entire sample per question

[gap size=”20″]

[insert_php]
//echo “

Low to high avg.difference by skill where r>4 and gap>1

“;
echo “

“;echo “

“;
foreach ($result as $key => $value){
if (($result[$key][2])>4 && ($result[$key][1])>1){
echo “

“;
echo “

“;
}
}
echo “

Gap	Affected	Skill	Avg rel
“;echo $result[$key][1];echo “	“;echo $result[$key][3];echo “	“;echo $result[$key][0];echo “	“;echo $result[$key][2];echo “

“;
//print_r($learnit);
[/insert_php]

2.3 Distribution by skills theme

This section contains a number of bubble graphs which show the frequency and distribution results plotted across all participants (anonymised). These can be used as a visual aid to understand if there are underutilised skills as well as monitor trends over time. The size of each circle on the graph is proportional to the frequency at which the particular relevance and proficiency co-ordinate was given across the participants.

[insert_php]

//could break ghere

$totpeople=count($allin);
$totalqs=count($allin[1]);
$grandtot=$totpeople*$totalqs;
//print_r($fruit);

$peoplefre=0;
for ($x = 5; $x <= 10; $x++) { for ($y = 5; $y <= 10; $y++) { $refbot=$x."p".$y; $peoplefre=$peoplefre+array_sum($fruit[$refbot]); //echo "
“;
//echo $refbot.PHP_EOL;
//echo array_sum($fruit[$refbot]).PHP_EOL;
}}
//echo $peoplefre;
$complianta=”[‘Comfort’,”.$peoplefre.”]”;
$frazzy=$grandtot-$peoplefre;
echo “Comfort zone where relevance is 5 and above and Proficiency 5 and above”.PHP_EOL;
$noncomp=”[‘Non-compliant’,”.($frazzy).”],”;
echo “Total number of answers analysed (participants x questions) :”.($frazzy+$peoplefre).PHP_EOL;
//echo $complianta.PHP_EOL;
//echo $noncomp.PHP_EOL;
//echo “

Ratio is: “.round($peoplefre/$frazzy,2).PHP_EOL.”

“;
$mathy=round($peoplefre/($peoplefre+$frazzy),2);
//$mathy=$mathy*100;
$mathy=$peoplefre;
$comfortmath=$mathy;
//echo “

Comfort: “.$mathy.”%”.PHP_EOL.”

“;
//echo “

Of those plots that are relevant…

“.PHP_EOL;
//echo “Peoplefre>”.$peoplefre.PHP_EOL;
$subsa=$peoplefre;

//SECOND CALCULATION
$totpeople=count($allin);
$totalqs=count($allin[1]);
$grandtot=$totpeople*$totalqs;

$peoplefre=0;
//relevant then proficinecy
for ($x = 5; $x <= 10; $x++) { for ($y = 0; $y <= 4; $y++) { $refbot=$x."p".$y; $peoplefre=$peoplefre+array_sum($fruit[$refbot]); }} $compliantb="['Problem',".$peoplefre."],"; $frazzy=$grandtot-$peoplefre; //echo "Comfort zone where relevance is 5 and above and Proficiency 5 and above".PHP_EOL; $noncomp="['Non-compliant',".($frazzy)."],"; $subsb=$peoplefre; $totman=($subsa+$subsb); //$mathy=round($peoplefre/($peoplefre+$frazzy),2); $mathy=round($peoplefre/($totman),2); $mathy=$mathy*100; $poormath=$mathy; echo "

“;
echo “

“;
$leveltot=(count($newheadings))-1;

for ($level = 0; $level <= $leveltot; $level++) { //echo "

Level”.$level.”

“.PHP_EOL;
//$level=0;

//complex

for ($x = 1; $x <= $resulter; $x++) { $offer=$x-1; $sql="SELECT * FROM $resulttable WHERE pinfo1='$relevant' ORDER BY id LIMIT 1 OFFSET $offer"; //echo $sql; $resultz= $wpdb->get_row($sql);
//print_r($resultz);

$userinput=array();$count=0;

foreach ($resultz as $key => $value) {
if($key==”pinfo0″){$numnum[$hyperloop]=$value;$hyperloop=$hyperloop+1;}
$subs = substr($key, 0, 3);
if ($subs==”mcq”){$count=$count+1;$userinput[$count]=$value;}
}
//print_r($userinput);
$len = count($userinput);
$r[$x]= array_slice($userinput,0, $len / 2);
$p[$x]=array_slice($userinput, $len / 2);
//print_r($r);//print_r($p);

}
//echo “The r’s original”.PHP_EOL;
//print_r($r);
//echo “The p’s original”.PHP_EOL;
//print_r($p);

$len = count($headings);
$newheadings= array_slice($headings,0, $len / 2);
//print_r($newheadings);

//slice and dice time
$sliceme=$totalq[$level+1];
//echo “slicing by “.$sliceme.PHP_EOL;
$elance = count($r);
$elance=intval($elance);
//echO “Elance is “.$elance.PHP_EOL;

$onyourmarks=0;

if ($level>0){
for ($x = 1; $x <= $level;$x++) { $onyourmarks=$onyourmarks+$totalq[$x]; } } for ($x = 1; $x <= $elance;$x++) { $outputr[$x] = array_slice($r[$x],$onyourmarks,$sliceme); $outputp[$x]= array_slice($p[$x],$onyourmarks,$sliceme); } $r=$outputr; $p=$outputp; $fruit = array ( "0p0" => array(“0”),
“0p1” => array(“0”),
“0p2” => array(“0”),
“0p3” => array(“0”),
“0p4” => array(“0”),
“0p5” => array(“0”),
“0p6” => array(“0”),
“0p7” => array(“0”),
“0p8” => array(“0”),
“0p9” => array(“0”),
“0p10” => array(“0”),

$allin=array();
for ($x = 1; $x <= $resulter; $x++) { foreach ($p[$x] as $key => $value) {
//echo $key;
$fruitref=$r[$x][$key].”p”.$p[$x][$key];
$fruitnow=$fruit[$fruitref][$x-1];
$fruitnow=$fruitnow+1;
$fruit[$fruitref][$x-1]=$fruitnow;

$allin[$x][$key]=$r[$x][$key].”,”.$p[$x][$key].”,'”.$numnum[$x-1].”‘”;

}
//print_r($fruit);

}

//print_r($fruit);
//begin addup
$googlemore=””;
foreach ($fruit as $key => $value) {
$goer=strpos($key,”p”);
$lefter=substr($key,0,$goer);
$righter=substr($key,$goer+1,strlen($key));
//echo “Left”.$lefter.PHP_EOL;
//echo “Right”.$righter.PHP_EOL;
$fruitcount[$key]=array_sum($fruit[$key]);
if ($fruitcount[$key]>0){
$datax=”Irrelevant”;
if ($lefter>4 && $righter<5){$datax="Problem";} if ($lefter>4 && $righter>=5){$datax=”Comfort”;}
$googlemore=$googlemore.”[‘”.$fruitcount[$key].”‘,”.$lefter.”,”.$righter.”,’$datax’,”.$fruitcount[$key].”],”.”
“;}
}

//echo “Total plots>”.count($fruitcount).PHP_EOL;
//print_r($fruit);
//$fruitcount=array_sum($fruit[$fruitref]);
//echo $fruitref.PHP_EOL;
//echo “COUNT>”.$fruitcount.PHP_EOL;

//print_r($allin);

$googleit=””;

$googleit=substr($googleit, 0, -5);
$googlemore=substr($googlemore, 0, -5);
//echo $googlemore;
//echo $googleit;
//APPLE
//$describer=$headings[$level+1].’Problem =’.$mathy.’%’;

//do comfort maths

$totpeople=count($allin);
$totalqs=count($allin[1]);
$grandtot=$totpeople*$totalqs;
//print_r($fruit);

Ratio is: “.round($peoplefre/$frazzy,2).PHP_EOL.”

“;
$mathy=round($peoplefre/($peoplefre+$frazzy),2);
//$mathy=$mathy*100;
$mathy=$peoplefre;
$comfortmath=$mathy;
//$describer=$headings[$level+1].’Problem =’.$mathy;
//echo “

Comfort: “.$mathy.”%”.PHP_EOL.”

“;
//echo “

Of those plots that are relevant…

“.PHP_EOL;
//echo “Peoplefre>”.$peoplefre.PHP_EOL;
$subsa=$peoplefre;

//SECOND CALCULATION
$totpeople=count($allin);
$totalqs=count($allin[1]);
$grandtot=$totpeople*$totalqs;

$peoplefre=0;
//relevant then proficinecy
for ($x = 5; $x <= 10; $x++) { for ($y = 0; $y <= 4; $y++) { $refbot=$x."p".$y; $peoplefre=$peoplefre+array_sum($fruit[$refbot]); //echo "
“;
//echo $refbot.PHP_EOL;
//echo array_sum($fruit[$refbot]).PHP_EOL;
}}
//echo “PEOPLEFRE”.$peoplefre.PHP_EOL;
$compliantb=”[‘Problem’,”.$peoplefre.”],”;
$frazzy=$grandtot-$peoplefre;
//echo “Comfort zone where relevance is 5 and above and Proficiency 5 and above”.PHP_EOL;
$noncomp=”[‘Non-compliant’,”.($frazzy).”],”;
//echo $compliantb.PHP_EOL;
//echo $noncomp.PHP_EOL;
//echo “

Ratio is: “.round($peoplefre/$frazzy,2).PHP_EOL.”

Problem: “.$mathy.”%”.PHP_EOL.”

“;
$comfortmath=round($comfortmath/$totman,2);$comfortmath=$comfortmath*100;
//echo “

Comfort: “.$comfortmath.”%”.PHP_EOL.”

“;
$diffy=$comfortmath-$poormath;
//echo “

Difference: “.$diffy.”%”.PHP_EOL.”

“;

//end maths FRASER
//$comfortmath=round($comfortmath/$totman,2);$comfortmath=$comfortmath*100;
//echo “

Scatter

Proportions“;
echo “

“;
echo “

Across the full range of skills

“.PHP_EOL;
$titlez=’Of the plots that are relevant, Problem zone = Appox ‘.$mathy.’% . Comfort zone= Appox ‘.$comfortmath.’% ‘;
//mods
[/insert_php]

[insert_php]
$comfortmath=round($comfortmath/$totman,2);$comfortmath=$comfortmath*100;
//echo “

Comfort: “.$comfortmath.”%”.PHP_EOL.”

“;
$diffy=$comfortmath-$poormath;
$mathy=100-($comfortmath+$poormath);
//echo “

Irrelevants “.$mathy.”%”.PHP_EOL.”

“;
$numbz=($mathy/100)*($peoplefre+$frazzy);
$irrels=”[‘Irrelevant’,”.($numbz).”],”;
echo “

“;
//echo “

“;
echo “

“;echo “

“;
echo “

“;
}
echo “

Scatter

Proportions“;
//echo “

“;
echo “

“;echo $headings[$level+1].PHP_EOL;echo “

“;
$describer= ‘Of the plots that are relevant, Problem zone = Appox ‘.$mathy.’% . Comfort zone= Appox ‘.$comfortmath.’% ‘;
$vax=’Proficiency’;
$yax=’Relevance’;
$varone=”{title: ‘Proficiency’}”;
echo “

“;
//echo “

Of the plots that are relevant..

“.PHP_EOL;
//echo “

Problem: “.$mathy.”%”.PHP_EOL.”

“;

$problemarray[$level]=$mathy;
$comfortmarray[$level]=$comfortmath;
//echo “

Comfort: “.$comfortmath.”%”.PHP_EOL.”

“;

echo “

“;
[/insert_php]

2.5 Confidence per theme

The following graph is a summary of the previous information whereby cohort confidence percentages have been plotted against each skill theme (confidence = percent comfort minus percent problem)

[insert_php]
$leveltot=count($newheadings);

for ($level = 1; $level <= $leveltot; $level++) { $diffx=$comfortmarray[$level-1]-$problemarray[$level-1]; $headbit=$newheadings[$level-1]; $colkey="color: green"; if ($diffx<=66){$colkey="color: orange";} if ($diffx<=33){$colkey="color: red";} $confgraph=$confgraph."['$headbit',".$diffx.",'$colkey'],"; } $confgraph=substr($confgraph, 0, -1); //print_r($confgraph); asort($confgraph); [/insert_php] [barChart width="1200px" height="500px" stacked="1" fontSize="10" legend="{ position: 'top', maxLines: 2 }" haxis="{title: 'Skill', titleTextStyle: {color: 'blue'}}" haxis="{title: 'Confidence (%) per skill theme', titleTextStyle: {color: 'blue'}}"] ['Skill', 'Comfort % minus Problem %',{ role: 'style' }], [insert_php] $message=$confgraph; echo "$message"; [/insert_php] [/barChart]

3.0 Recommendations

3.1 Personalised Training Report

[insert_php]
if (count($learnit)==0) {echo “Congratulations, you do not need to embark on any training at this time.”.PHP_EOL;}
foreach($learnit as $key => $value) {
echo ““.$learnit[$key].”“.PHP_EOL;
if ($learnit[$key]==”Developing, appraising and shortlisting options in a systematic way”) {echo “

Ask about our online option appraisal software

Book onto the preparing for consultation course

Ask about our services to run an options scoring workshop”.”

“.PHP_EOL;}

if ($learnit[$key]==”Preparing and publishing pre-consultation (issue) papers to elicit stakeholder views prior to options development”) {echo “

Book onto the Co-Production in Public Engagement and Consultation course”.”

“.PHP_EOL;}

if ($learnit[$key]==”Determining the precise scope for a consultation exercise and drafting a suitable mandate”) {echo “

Book onto the preparing for consultation course

Ask us about running a risk workshop”.”

“.PHP_EOL;}

if ($learnit[$key]==”Calculating and agreeing a realistic budget for a consultation exercise”) {echo “

“.”Call us for help. You may also want to ask us about participatory budgeting”.”

“.PHP_EOL;}

if ($learnit[$key]==”Forming and managing multi-disciplinary teams to undertake a consultation”) {echo “

“.”Call us for help”.”

“.PHP_EOL;}

if ($learnit[$key]==”Creating a pre-consultation business case or case for change”) {echo “

“.”Book onto the preparing for consultation course”.”

“.PHP_EOL;}

if ($learnit[$key]==”Familiarity with the relevant legal concepts around public consultation and knowing when to seek specialist legal advice”) {echo “

Book onto the law of consultation course

Ask us about running a risk workshop”.”

“.PHP_EOL;}

//NEXT

if ($learnit[$key]==”Stakeholder relationship management”) {echo “

“.”Book onto the best practice online consultation course”.”

“.PHP_EOL;}

if ($learnit[$key]==”Conducting a stakeholder mapping exercise for a specific consultation – using approved techniques (e.g. Interest / influence grid)”) {echo “

Book onto the preparing for consultation course

Book onto the best practice online consultation course to learn about digital influencers

View our eLearning module on stakeholder mapping”.”

“.PHP_EOL;}

if ($learnit[$key]==”Awareness of equalities duties and accessibility requirements for stakeholders with protected characteristics”) {echo “

Book onto the Equality Law for Public Engagement and Consultation course

Book onto the Equality and Health Inequality for Health and Social Care course”.”

“.PHP_EOL;}

if ($learnit[$key]==”Using digital engagement and digital tools to enhance the consultation outreach”) {echo “

“.”Book onto the best practice online consultation course and/or ask about our social media courses”.”

“.PHP_EOL;}

//NEXT

if ($learnit[$key]==”Providing advice on the range of dialogue methods to be used in a specific consultation”) {echo “

Book onto the conducting a public consultation course

Book onto the co-production in public engagement and consultation course

Book onto the making community engagement meaningful course”.”

“.PHP_EOL;}

if ($learnit[$key]==”Observing Plain English standards in all consultation communications”) {echo “

“.”Ask us about our document review service”.”

“.PHP_EOL;}

if ($learnit[$key]==”Designing a questionnaire that is straightforward to complete with clear and meaningful questions that are relevant to informing decision making”) {echo “

“.”Book onto the better surveys and questionnaires course

Try our eLearning course on surveys and questionnaires”.”

“.PHP_EOL;}

if ($learnit[$key]==”Designing and organising Focus Groups or similar discussions”) {echo “

“.”Try our eLearning course on focus groups”.”

“.PHP_EOL;}

if ($learnit[$key]==”Ability to facilitate small or large groups to consider issues as part of a consultation”) {echo “

“.”Try our eLearning course on focus groups and/or ask about our register of recommended facilitators”.”

“.PHP_EOL;}

if ($learnit[$key]==”Designing and organising deliberative events”) {echo “

“.”Book onto the conducting a public consultation course

Try our eLearning course on consultation and public events”.”

“.PHP_EOL;}

if ($learnit[$key]==”Preparing and delivering presentations for engagement or consultation meetings (e.g. Seminars or public meetings)”) {echo “

“.”Book onto the conducting a public consultation course”.”

“.PHP_EOL;}

if ($learnit[$key]==”Drafting a consultation paper”) {echo “

“.”Book onto the preparing for a public consultation course

Ask about our document review service

Try our eLearning course ‘collecting information, data and sampling’

Try our eLearning course ‘surveys and questionnaires'”.”

“.PHP_EOL;}

if ($learnit[$key]==”Developing and publishing appropriate content in support of a consultation, to enable consultees to give a considered response”) {echo “

“.”Book onto the preparing for a public consultation course”.”

“.PHP_EOL;}

if ($learnit[$key]==”Designing and managing a public meeting or equivalent”) {echo “

“.”Book onto the conducting a public consultation course

Use our eLearning module entitled ‘consultation and public events'”.”

“.PHP_EOL;}

if ($learnit[$key]==”Designing and organising co-production exercises”) {echo “

“.”Book onto the Co-Production in Public Engagement and Consultation course “.”

“.PHP_EOL;}

if ($learnit[$key]==”Using social media in the support of consultation & engagement activity”) {echo “

“.”Ask us about our social media basic and advanced courses”.”

“.PHP_EOL;}

//FINALE

if ($learnit[$key]==”Preparing a comprehensive analysis plan (e.g. setting research questions and specifying how feedback should be interpreted)”) {echo “