Overall Performance

Total Assessments

{data.totalAssessments}

Average Score

{data.averageScore.toFixed(2)}%

Top Performing Subjects

\n {data.topSubjects.map((subject, index) => (\n

{subject.subject}: {subject.avg_score.toFixed(2)}%

\n ))}\n

\n );\n\n case \"regional\":\n return (\n

Regional Performance

\n \n \n \n \n \n \n \n \n \n {data.regionalPerformance.map((region, index) => (\n \n \n \n \n \n ))}\n \n

State	District	Average Score
{region.state}	{region.district}	{region.avg_score.toFixed(2)}%

\n );\n\n case \"subject\":\n return (\n

Subject Performance

\n {data.subjectPerformance.map((subject, index) => (\n \n

{subject.name}

Average Score: {subject.avgScore.toFixed(2)}%

Difficulty Breakdown:

Easy: {subject.difficultyBreakdown.easy.toFixed(2)}%
Medium: {subject.difficultyBreakdown.medium.toFixed(2)}%
Hard: {subject.difficultyBreakdown.hard.toFixed(2)}%

\n ))}\n

\n \n );\n\n default:\n return

Select an analytics type

;\n }\n };\n\n return (\n

Teacher Assessment Analytics

\n\n \n \n \n \n

\n\n {renderAnalytics()}\n

\n \n View Source\n \n

\n \n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"assesment\";\n\n // Seed mock data if no data exists\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_mock_assessments (\n id INTEGER PRIMARY KEY,\n subject TEXT,\n state TEXT,\n district TEXT,\n total_questions INTEGER,\n correct_answers INTEGER\n )\n `);\n\n // Check if mock data exists\n const existingData = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${KEY}_mock_assessments`,\n );\n\n if (existingData.rows[0].count === 0) {\n // Generate mock data\n const subjects = [\"Mathematics\", \"Science\", \"English\", \"Social Studies\"];\n const states = [\"Maharashtra\", \"Karnataka\", \"Tamil Nadu\", \"Delhi\"];\n const districts = [\"Mumbai\", \"Bangalore\", \"Chennai\", \"New Delhi\"];\n\n for (let i = 0; i < 50; i++) {\n await sqlite.execute(\n `INSERT INTO ${KEY}_mock_assessments \n (subject, state, district, total_questions, correct_answers) \n VALUES (?, ?, ?, ?, ?)`,\n [\n subjects[Math.floor(Math.random() * subjects.length)],\n states[Math.floor(Math.random() * states.length)],\n districts[Math.floor(Math.random() * districts.length)],\n 10,\n Math.floor(Math.random() * 10),\n ],\n );\n }\n }\n\n // Get Analytics\n if (request.method === \"GET\" && new URL(request.url).pathname.endsWith(\"/get-analytics\")) {\n try {\n const url = new URL(request.url);\n const type = url.searchParams.get(\"type\");\n\n switch (type) {\n case \"overall\":\n // Overall Performance Analytics\n const totalAssessmentsResult = await sqlite.execute(\n `SELECT COUNT(*) as total FROM ${KEY}_mock_assessments`,\n );\n\n const averageScoreResult = await sqlite.execute(\n `SELECT AVG(correct_answers * 100.0 / total_questions) as avg_score \n FROM ${KEY}_mock_assessments`,\n );\n\n const topSubjectsResult = await sqlite.execute(\n `SELECT subject, \n AVG(correct_answers * 100.0 / total_questions) as avg_score\n FROM ${KEY}_mock_assessments\n GROUP BY subject\n ORDER BY avg_score DESC\n LIMIT 3`,\n );\n\n return new Response(\n JSON.stringify({\n totalAssessments: totalAssessmentsResult.rows[0].total,\n averageScore: averageScoreResult.rows[0].avg_score || 0,\n topSubjects: topSubjectsResult.rows,\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n\n case \"regional\":\n // Regional Performance Analytics\n const regionalPerformanceResult = await sqlite.execute(\n `SELECT state, district, \n AVG(correct_answers * 100.0 / total_questions) as avg_score\n FROM ${KEY}_mock_assessments\n GROUP BY state, district\n ORDER BY avg_score DESC`,\n );\n\n return new Response(\n JSON.stringify({\n regionalPerformance: regionalPerformanceResult.rows,\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n\n case \"subject\":\n // Subject Performance Analytics\n const subjectPerformanceResult = await sqlite.execute(\n `SELECT subject, \n AVG(correct_answers * 100.0 / total_questions) as avg_score,\n AVG(CASE WHEN total_questions <= 5 THEN \n correct_answers * 100.0 / total_questions\n END) as easy_score,\n AVG(CASE WHEN total_questions > 5 AND total_questions <= 8 THEN \n correct_answers * 100.0 / total_questions\n END) as medium_score,\n AVG(CASE WHEN total_questions > 8 THEN \n correct_answers * 100.0 / total_questions\n END) as hard_score\n FROM ${KEY}_mock_assessments\n GROUP BY subject`,\n );\n\n return new Response(\n JSON.stringify({\n subjectPerformance: subjectPerformanceResult.rows.map(subject => ({\n name: subject.subject,\n avgScore: subject.avg_score,\n difficultyBreakdown: {\n easy: subject.easy_score || 0,\n medium: subject.medium_score || 0,\n hard: subject.hard_score || 0,\n },\n })),\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n\n default:\n return new Response(JSON.stringify({ error: \"Invalid analytics type\" }), {\n status: 400,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n } catch (error) {\n return new Response(JSON.stringify({ error: \"Failed to fetch analytics\" }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n\n // Serve the analytics page\n return new Response(\n `\n \n \n Teacher Assessment Analytics\n \n \n \n \n

\n \n \n \n \n `,\n {\n headers: { \"content-type\": \"text/html\" },\n },\n );\n}","deleted","label",[98],"permalink","https://www.val.town/x/atharv175/assesment/code/main.tsx","extension","actionData","errors"]