Development and Operation of Jeonnam Office of Education Survey Website

💡 Project Overview

This project was commissioned by the Jeollanam-do Office of Education, aimed at creating an integrated platform for conducting and managing democracy-related surveys across schools.
The platform was developed and operated using Django as the backend framework.

Service Link: http://jndedu-school-democracy.kr/ (Hosting terminated)


🌟 Key Features

👩‍🏫 Users (Students, Parents, Faculty)

  • Participate in customized surveys according to user type (student, parent, or faculty)
  • Access announcements and download attachments from the resources section
  • View educational resources related to school democracy

🧑‍💻 Administrators (School / Regional Office / Main Office)

  • Role-based admin accounts with tiered access (school, regional office, headquarters)
  • Create and manage announcements or resources with file uploads
  • Real-time statistics by school, region, and education level
  • Visualize and export statistics by question or category

⚙️ Tech Stack

  • Language: Python 3.11.9
  • Framework: Django
  • Database: MySQL
  • Server: Ubuntu + Nginx
  • Deployment: Gunicorn, crontab (automatic reboot scheduling)

🧠 Key Learnings

  • High-Traffic Management: Gained hands-on experience handling sudden traffic spikes in a live environment by optimizing Nginx and Gunicorn configurations.
  • Database Optimization: Solved Django ORM N+1 query problems using select_related and prefetch_related, and minimized DB load for complex queries with annotate and aggregate.
  • Server Operations: Learned to maintain stable Ubuntu-based servers using scheduled crontab tasks for automatic reboots and monitoring.

👉 Detailed Learnings on Site Operation


🔗 GitHub Repository

https://github.com/Ddaaan/EduWebCode

Daeun Choi
Daeun Choi
Backend Developer

A backend developer majoring in IT Information Engineering at Jeonbuk National University.