Judithosaro/UNIVERSITY-OF-BENIN-Technostress-dashboard-
Record type:
software
Creator:
Jud
Host:
# Technostress Data Analytics System
Final year project system for: **Development of a Data Analytics System for
Assessing the Impact of Technological Advancement on Technostress: A Case
Study of University of Benin.**
## What's in here
Four pages, as planned in Chapter 3:
1. **Questionnaire** (`/`) — embeds your actual Google Form inline, so
students fill it out without leaving your site. Responses go straight to
your Google Sheet, same as always.
2. **Thank-you page** (`/thank-you`) — kept in the codebase but unused for
now since the Google Form shows its own confirmation after submitting.
3. **Admin login** (`/admin/login`) — protects the dashboard.
4. **Admin dashboard** (`/admin/dashboard`) — Chart.js visualizations:
average score per dimension, overall stress distribution, responses by
level of study, and daily device usage breakdown. Data comes from CSV
imports (see below).
Built with **Flask + SQLite + Chart.js**, matching the tech stack in your
Chapter 3.
## Getting responses into the dashboard
You have two options — pick whichever's easier.
### Option A: Auto-sync (recommended, one click after setup)
1. Open the Google Sheet linked to your Form's Responses tab.
2. **File → Share → Publish to web.** Choose your responses sheet in the
first dropdown, and **Comma-separated values (.csv)** in the second.
Click **Publish**, confirm. This gives you a public link — copy it.
(Publishing makes the sheet viewable via that link, not editable —
fine for an anonymous survey, but know that before you do it.)
3. On the dashboard, click **🔗 Connect Google Sheet**, paste the link.
4. Match your columns once (same idea as below) — make sure you map the
**Timestamp** column, since that's what prevents duplicate imports.
5. From then on, just click **⟳ Sync Now** on the dashboard whenever you
want the latest responses. It only pulls in rows it hasn't seen before.
### Option B: Manual CSV export
1. Open the Sheet, **File → Download → Comma Separated Values (.csv)**. …