Student Analytics Dashboard<\/title>\r\n<script src=\"https:\/\/cdn.jsdelivr.net\/npm\/chart.js\"><\/script>\r\n<style>\r\nbody{\r\n margin:0;\r\n font-family: 'Segoe UI', sans-serif;\r\n background: linear-gradient(135deg,#0f2027,#203a43,#2c5364);\r\n color:white;\r\n}\r\nheader{\r\n padding:20px;\r\n text-align:center;\r\n font-size:28px;\r\n font-weight:bold;\r\n letter-spacing:2px;\r\n}\r\n.container{\r\n padding:20px;\r\n}\r\n.card{\r\n background: rgba(255,255,255,0.1);\r\n padding:20px;\r\n border-radius:15px;\r\n backdrop-filter: blur(10px);\r\n margin-bottom:20px;\r\n transition:0.4s;\r\n}\r\n.card:hover{\r\n transform:scale(1.03);\r\n}\r\ninput,select,button{\r\n padding:10px;\r\n margin:5px;\r\n border:none;\r\n border-radius:8px;\r\n}\r\nbutton{\r\n background:#00c6ff;\r\n color:white;\r\n cursor:pointer;\r\n}\r\ntable{\r\n width:100%;\r\n border-collapse:collapse;\r\n}\r\nth,td{\r\n padding:10px;\r\n text-align:center;\r\n}\r\nth{\r\n background:#00c6ff;\r\n}\r\ntr:nth-child(even){\r\n background:rgba(255,255,255,0.05);\r\n}\r\n.flex{\r\n display:flex;\r\n flex-wrap:wrap;\r\n gap:20px;\r\n}\r\n.stat{\r\n flex:1;\r\n min-width:200px;\r\n text-align:center;\r\n font-size:20px;\r\n}\r\ncanvas{\r\n background:white;\r\n border-radius:10px;\r\n}\r\n<\/style>\r\n<\/head>\r\n<body>\r\n\r\n<header>\ud83c\udf93 Modern Student Analytics Dashboard<\/header>\r\n\r\n<div class=\"container\">\r\n\r\n<div class=\"card\">\r\n<h3>Submit Exam Result<\/h3>\r\n<form id=\"examForm\">\r\n<input type=\"text\" name=\"studentId\" placeholder=\"Student ID\" required>\r\n<input type=\"text\" name=\"name\" placeholder=\"Name\" required>\r\n<input type=\"text\" name=\"school\" placeholder=\"School Name\" required>\r\n<input type=\"text\" name=\"subject\" placeholder=\"Subject\" required>\r\n<input type=\"number\" name=\"marks\" placeholder=\"Marks\" required>\r\n<input type=\"number\" name=\"total\" placeholder=\"Total Marks\" required>\r\n<button type=\"submit\">Submit<\/button>\r\n<\/form>\r\n<\/div>\r\n\r\n<div class=\"card flex\">\r\n<div class=\"stat\">Total Students<br><span id=\"totalStudents\">0<\/span><\/div>\r\n<div class=\"stat\">Highest Score<br><span id=\"highestScore\">0<\/span>%<\/div>\r\n<div class=\"stat\">Average Score<br><span id=\"averageScore\">0<\/span>%<\/div>\r\n<\/div>\r\n\r\n<div class=\"card\">\r\n<h3>\ud83c\udfc6 Top 10 Students<\/h3>\r\n<table id=\"topTable\"><\/table>\r\n<\/div>\r\n\r\n<div class=\"card\">\r\n<h3>\ud83d\udcca School Performance<\/h3>\r\n<canvas id=\"schoolChart\"><\/canvas>\r\n<\/div>\r\n\r\n<\/div>\r\n\r\n<script>\r\n\r\nlet sheetURL = \"YOUR_WEB_APP_URL\";\r\n\r\ndocument.getElementById(\"examForm\").addEventListener(\"submit\", function(e){\r\n e.preventDefault();\r\n\r\n fetch(sheetURL,{\r\n method:\"POST\",\r\n body:JSON.stringify({\r\n studentId:this.studentId.value,\r\n name:this.name.value,\r\n school:this.school.value,\r\n subject:this.subject.value,\r\n marks:this.marks.value,\r\n total:this.total.value\r\n })\r\n }).then(res=>res.json())\r\n .then(data=>{\r\n alert(\"Submitted Successfully!\");\r\n loadData();\r\n });\r\n});\r\n\r\nfunction loadData(){\r\nfetch(sheetURL)\r\n.then(res=>res.json())\r\n.then(data=>{\r\n\r\nlet students = data;\r\n\r\nstudents.forEach(s=>{\r\n s.percentage = (s.marks \/ s.total) * 100;\r\n});\r\n\r\nstudents.sort((a,b)=> b.percentage - a.percentage);\r\n\r\ndocument.getElementById(\"totalStudents\").innerText = students.length;\r\ndocument.getElementById(\"highestScore\").innerText = students[0]?.percentage.toFixed(1);\r\n\r\nlet avg = students.reduce((a,b)=> a+b.percentage,0)\/students.length;\r\ndocument.getElementById(\"averageScore\").innerText = avg.toFixed(1);\r\n\r\nlet table = \"<tr><th>Rank<\/th><th>Name<\/th><th>School<\/th><th>%<\/th><\/tr>\";\r\n\r\nstudents.slice(0,10).forEach((s,i)=>{\r\n table += `<tr>\r\n <td>${i+1}<\/td>\r\n <td>${s.name}<\/td>\r\n <td>${s.school}<\/td>\r\n <td>${s.percentage.toFixed(1)}<\/td>\r\n <\/tr>`;\r\n});\r\n\r\ndocument.getElementById(\"topTable\").innerHTML = table;\r\n\r\nlet schoolMap = {};\r\nstudents.forEach(s=>{\r\n schoolMap[s.school] = (schoolMap[s.school] || 0) + 1;\r\n});\r\n\r\nnew Chart(document.getElementById(\"schoolChart\"),{\r\n type:\"bar\",\r\n data:{\r\n labels:Object.keys(schoolMap),\r\n datasets:[{\r\n label:\"Students Count\",\r\n data:Object.values(schoolMap)\r\n }]\r\n }\r\n});\r\n\r\n});\r\n}\r\n\r\nloadData();\r\n\r\n<\/script>\r\n\r\n<\/body>\r\n<\/html>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Student Analytics Dashboard \ud83c\udf93 Modern Student Analytics Dashboard Submit Exam Result Submit Total Students0 Highest Score0% Average Score0% \ud83c\udfc6 Top […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_canvas","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"","ast-site-content-layout":"full-width-container","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-734","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/hithotprodcut.com\/index.php\/wp-json\/wp\/v2\/pages\/734","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hithotprodcut.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/hithotprodcut.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/hithotprodcut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hithotprodcut.com\/index.php\/wp-json\/wp\/v2\/comments?post=734"}],"version-history":[{"count":13,"href":"https:\/\/hithotprodcut.com\/index.php\/wp-json\/wp\/v2\/pages\/734\/revisions"}],"predecessor-version":[{"id":749,"href":"https:\/\/hithotprodcut.com\/index.php\/wp-json\/wp\/v2\/pages\/734\/revisions\/749"}],"wp:attachment":[{"href":"https:\/\/hithotprodcut.com\/index.php\/wp-json\/wp\/v2\/media?parent=734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

\n\t\t\t\t

\n\t\t\t\t\t

\n\t\t\t\t

\n\t\t\t\t\t\r\n\r\n\r\n\r\nStudent Analytics Dashboard<\/title>\r\n<script src=\"https:\/\/cdn.jsdelivr.net\/npm\/chart.js\"><\/script>\r\n<style>\r\nbody{\r\n margin:0;\r\n font-family: 'Segoe UI', sans-serif;\r\n background: linear-gradient(135deg,#0f2027,#203a43,#2c5364);\r\n color:white;\r\n}\r\nheader{\r\n padding:20px;\r\n text-align:center;\r\n font-size:28px;\r\n font-weight:bold;\r\n letter-spacing:2px;\r\n}\r\n.container{\r\n padding:20px;\r\n}\r\n.card{\r\n background: rgba(255,255,255,0.1);\r\n padding:20px;\r\n border-radius:15px;\r\n backdrop-filter: blur(10px);\r\n margin-bottom:20px;\r\n transition:0.4s;\r\n}\r\n.card:hover{\r\n transform:scale(1.03);\r\n}\r\ninput,select,button{\r\n padding:10px;\r\n margin:5px;\r\n border:none;\r\n border-radius:8px;\r\n}\r\nbutton{\r\n background:#00c6ff;\r\n color:white;\r\n cursor:pointer;\r\n}\r\ntable{\r\n width:100%;\r\n border-collapse:collapse;\r\n}\r\nth,td{\r\n padding:10px;\r\n text-align:center;\r\n}\r\nth{\r\n background:#00c6ff;\r\n}\r\ntr:nth-child(even){\r\n background:rgba(255,255,255,0.05);\r\n}\r\n.flex{\r\n display:flex;\r\n flex-wrap:wrap;\r\n gap:20px;\r\n}\r\n.stat{\r\n flex:1;\r\n min-width:200px;\r\n text-align:center;\r\n font-size:20px;\r\n}\r\ncanvas{\r\n background:white;\r\n border-radius:10px;\r\n}\r\n<\/style>\r\n<\/head>\r\n<body>\r\n\r\n<header>\ud83c\udf93 Modern Student Analytics Dashboard<\/header>\r\n\r\n<div class=\"container\">\r\n\r\n<div class=\"card\">\r\n<h3>Submit Exam Result<\/h3>\r\n<form id=\"examForm\">\r\n<input type=\"text\" name=\"studentId\" placeholder=\"Student ID\" required>\r\n<input type=\"text\" name=\"name\" placeholder=\"Name\" required>\r\n<input type=\"text\" name=\"school\" placeholder=\"School Name\" required>\r\n<input type=\"text\" name=\"subject\" placeholder=\"Subject\" required>\r\n<input type=\"number\" name=\"marks\" placeholder=\"Marks\" required>\r\n<input type=\"number\" name=\"total\" placeholder=\"Total Marks\" required>\r\n<button type=\"submit\">Submit<\/button>\r\n<\/form>\r\n<\/div>\r\n\r\n<div class=\"card flex\">\r\n<div class=\"stat\">Total Students<br><span id=\"totalStudents\">0<\/span><\/div>\r\n<div class=\"stat\">Highest Score<br><span id=\"highestScore\">0<\/span>%<\/div>\r\n<div class=\"stat\">Average Score<br><span id=\"averageScore\">0<\/span>%<\/div>\r\n<\/div>\r\n\r\n<div class=\"card\">\r\n<h3>\ud83c\udfc6 Top 10 Students<\/h3>\r\n<table id=\"topTable\"><\/table>\r\n<\/div>\r\n\r\n<div class=\"card\">\r\n<h3>\ud83d\udcca School Performance<\/h3>\r\n<canvas id=\"schoolChart\"><\/canvas>\r\n<\/div>\r\n\r\n<\/div>\r\n\r\n<script>\r\n\r\nlet sheetURL = \"YOUR_WEB_APP_URL\";\r\n\r\ndocument.getElementById(\"examForm\").addEventListener(\"submit\", function(e){\r\n e.preventDefault();\r\n\r\n fetch(sheetURL,{\r\n method:\"POST\",\r\n body:JSON.stringify({\r\n studentId:this.studentId.value,\r\n name:this.name.value,\r\n school:this.school.value,\r\n subject:this.subject.value,\r\n marks:this.marks.value,\r\n total:this.total.value\r\n })\r\n }).then(res=>res.json())\r\n .then(data=>{\r\n alert(\"Submitted Successfully!\");\r\n loadData();\r\n });\r\n});\r\n\r\nfunction loadData(){\r\nfetch(sheetURL)\r\n.then(res=>res.json())\r\n.then(data=>{\r\n\r\nlet students = data;\r\n\r\nstudents.forEach(s=>{\r\n s.percentage = (s.marks \/ s.total) * 100;\r\n});\r\n\r\nstudents.sort((a,b)=> b.percentage - a.percentage);\r\n\r\ndocument.getElementById(\"totalStudents\").innerText = students.length;\r\ndocument.getElementById(\"highestScore\").innerText = students[0]?.percentage.toFixed(1);\r\n\r\nlet avg = students.reduce((a,b)=> a+b.percentage,0)\/students.length;\r\ndocument.getElementById(\"averageScore\").innerText = avg.toFixed(1);\r\n\r\nlet table = \"<tr><th>Rank<\/th><th>Name<\/th><th>School<\/th><th>%<\/th><\/tr>\";\r\n\r\nstudents.slice(0,10).forEach((s,i)=>{\r\n table += `<tr>\r\n <td>${i+1}<\/td>\r\n <td>${s.name}<\/td>\r\n <td>${s.school}<\/td>\r\n <td>${s.percentage.toFixed(1)}<\/td>\r\n <\/tr>`;\r\n});\r\n\r\ndocument.getElementById(\"topTable\").innerHTML = table;\r\n\r\nlet schoolMap = {};\r\nstudents.forEach(s=>{\r\n schoolMap[s.school] = (schoolMap[s.school] || 0) + 1;\r\n});\r\n\r\nnew Chart(document.getElementById(\"schoolChart\"),{\r\n type:\"bar\",\r\n data:{\r\n labels:Object.keys(schoolMap),\r\n datasets:[{\r\n label:\"Students Count\",\r\n data:Object.values(schoolMap)\r\n }]\r\n }\r\n});\r\n\r\n});\r\n}\r\n\r\nloadData();\r\n\r\n<\/script>\r\n\r\n<\/body>\r\n<\/html>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Student Analytics Dashboard \ud83c\udf93 Modern Student Analytics Dashboard Submit Exam Result Submit Total Students0 Highest Score0% Average Score0% \ud83c\udfc6 Top […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_canvas","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"","ast-site-content-layout":"full-width-container","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-734","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/hithotprodcut.com\/index.php\/wp-json\/wp\/v2\/pages\/734","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hithotprodcut.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/hithotprodcut.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/hithotprodcut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hithotprodcut.com\/index.php\/wp-json\/wp\/v2\/comments?post=734"}],"version-history":[{"count":13,"href":"https:\/\/hithotprodcut.com\/index.php\/wp-json\/wp\/v2\/pages\/734\/revisions"}],"predecessor-version":[{"id":749,"href":"https:\/\/hithotprodcut.com\/index.php\/wp-json\/wp\/v2\/pages\/734\/revisions\/749"}],"wp:attachment":[{"href":"https:\/\/hithotprodcut.com\/index.php\/wp-json\/wp\/v2\/media?parent=734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}