CAPSTONE PROJECT REPORT

Report 1 – Project Introduction

– DANANG, May 2025 –

Table of Contents
I. Record of Changes 3
II. Project Introduction 4
1. Overview 4
1.1 Project Information 4
1.2 Project Team 4
2. Product Background 4
3. Existing Solutions 4
3.1 System name1 4
3.2 System name2 4
4. Business Opportunity 4
5. Software Product Vision 5
6. Project Scope & Limitations 5
6.1 Major Features 5
6.2 Limitations & Exclusions 6
I. Record of Changes
A*
Date In charge Change Description
M, D
01/05/2025 A HieuND Project Introduction – Overview (II.1)
01/05/2025 A HieuND Project Introduction – Product Background (II.2)
01/05/2025 A HaTC Project Introduction – Existing Solutions (II.3)
01/05/2025 A HaiTC Project Introduction – Business Opportunity (II.4)
02/05/2025 A HieuTT Project Introduction – Software Product Vision (II.5)
02/05/2025 A HieuTT Project Introduction – Project Scope & Limitations (II.6)

*A - Added M - Modified D - Deleted

II. Project Introduction
1. Overview
1.1 Project Information
• Project name: Building a Japanese language online course management website
using React and SQL Server technologies
• Vietnamese name: Xây dựng trang web quản lý hệ thống khóa học trực tuyến ngôn
ngữ Nhật sử dụng công nghệ React, SQL Server
• Project code: SU25.SE17
• Group name: JLCS
• Software type: Website
1.2 Project Team
Full Name Role Email Mobile

Nguyen Vy Rin Mentor RinNV@[Link] 0905988001

Ngo Duy Hieu Leader hieundde160115@[Link] 0824291617

Truong Cong Ha Member hatcde130029@[Link] 0978620150

Tran Thanh Hieu Member hieuttde150177@[Link] 0398557027

Truong Cong Hai Member haitcde150404@[Link] 0975490911

2. Product Background
Japan is currently one of the world's largest economies, ranking third after the US and
China. With its remarkable development in technology, production and trade, Japan not only
has a profound influence on the global economy, but also has a clear impact on countries in
the region, including Vietnam. Japan's influence on the Vietnamese economy is not only
reflected in trade cooperation opportunities, but also opens up many career opportunities
through investment by Japanese enterprises in the Vietnamese market.

With the appearance of a series of Japanese companies in Vietnam, the demand for
recruiting human resources with foreign language skills, especially Japanese, is increasing.
Many Japanese enterprises require employees to be able to communicate and work fluently
in Japanese in order to maintain and develop relationships with partners. This has created
an increasingly strong trend of learning Japanese not only to improve professional skills but
also to expand employment and study abroad opportunities.

However, for many people, attending Japanese courses directly at language academies
is difficult, especially in terms of geography, time and cost. Not everyone has the conditions
to attend direct classes, especially for those who live in remote areas or are busy with work.
This makes it difficult to access quality courses, hindering the learning process and
developing language skills.

In that context, online course platforms are gradually becoming the optimal solution
for those who want to learn Japanese without facing barriers of time, geography or cost.
Online learning helps learners choose courses that suit their needs, personal learning
progress and pay conveniently and quickly without having to worry about travel or high
learning costs. This is also a flexible learning method, helping learners save time and effort in
improving their foreign language proficiency.

Therefore, building an online Japanese language course management system is

extremely necessary in today's era. This system not only helps learners easily access and
choose quality courses but also creates a convenient and flexible learning environment. At
the same time, for language academy owners, this system will support in managing learners,
monitoring learning progress and improving service quality. Thereby, improving the learner
experience, helping them achieve their learning and career goals more effectively.

The development of online learning platforms not only helps solve accessibility issues,
but also contributes to the strong development of foreign language learning in Vietnam,
especially Japanese. This is an important step in building a modern, flexible educational
platform that is suitable for the growing needs of learners in the context of international
integration.
[Link] Solutions

The online Japanese course management system is a modern educational solution

that streamlines the process of teaching, learning, and managing language courses in a
flexible and efficient way. This system shares similarities with existing e-learning platforms
such as KoseiOnline, RikiEdu in offering online language learning features. However, it is
customized to focus specifically on Japanese language education and tailored to the needs
of Vietnamese learners and language centers, supporting both students and administrators
in improving the learning experience and operational efficiency.

3.1 KoseiOnline
Website: [Link]

Figure 1. KoseiOnline
 Description: KoseiOnline is a web-based Japanese learning platform that offers
structured video lessons and interactive tests. Learners can ask questions directly to
instructors and access clearly categorized course content. Pricing is transparent, though
enrollment and payment are managed manually through messaging with an admin.

System Users:
- Student: View course, comment to ask.
- Admin: Approve course, manage appointments, promote services, and track
revenue.
Key Features:
- Structured Course Modules: Lessons are organized into clearly defined categories to
support logical progression in learning.
- Interactive Q&A: Learners can ask questions and receive answers directly from
instructors.
- Practice Tests: Offers test features to help students evaluate their understanding and
track improvement.
- Transparent Pricing: Course fees are listed publicly, helping users make informed
decisions.
- Manual Enrollment System: Students must contact an admin to process payment and
activate course access.
Advantages:
- Friendly interface, easy to use for learners.
- Allows learners to interact directly with instructors to ask questions.
- There is a test system to help assess ability.
- Lectures are organized and categorized clearly and logically.
- Transparent information about course prices, displayed publicly on the system.
Disadvantages:
- Does not support online payment.
- Students must manually contact the administrator to pay, then the administrator will
activate the course.
3.2 RikiEdu
Website: [Link]
 Figure 2. RikiEdu
Description: RikiEdu is an online Japanese learning system available on both web and mobile
apps. It features categorized lessons, progress tracking, and integrated tests. Users can
search for courses easily, but pricing details and enrollment require direct contact with an
administrator, as online payment is not yet supported.
System Users:
- Student: View course, comment to ask.
- Admin: Approve course, manage appointments, promote services, and track
revenue.
Key Features:
- Course Search: Users can search for courses by keyword or topic.
- Mobile Learning: Lessons are accessible through both the website and a mobile app
for flexible study on-the-go.
- Progress Tracking: The system tracks learning progress, allowing users to monitor
their advancement.
- Structured Learning Paths: Courses are divided into logical sections to guide learners
through the material.
- Integrated Testing: Quizzes and tests are built into the platform to assess student
performance.
- Manual Payment & Enrollment: Users must message an admin to receive pricing and
activate courses due to lack of online payment support.
Advantages:
- The system supports quick and convenient course searching.
- There is a learning application on the phone, increasing flexibility for learners.
- Lectures are arranged logically by topic.
- There is a function to track students' learning progress.
- Integrated tests to assess students' level.
Disadvantages:
- The course price is not public, students must contact the admin privately for
information.
- There is no online payment feature
- Students must message the admin to pay and activate the course manually.
4. Business Opportunity
In the context of increasingly deep international integration, Japan plays a role as
one of Vietnam's important economic partners. The increase in investment by Japanese
enterprises in Vietnam has created a high demand for human resources capable of using
Japanese. However, access to quality Japanese courses still faces many barriers due to
geographical factors, time and cost.
The development of digital technology opens up great opportunities in providing
flexible, effective and economical online learning solutions. Building an online Japanese
learning platform is not only an inevitable trend but also a potential business opportunity,
serving a wide range of learners from students, working people to people in remote areas.

5. Software Product Vision

The system is developed as a comprehensive online Japanese learning platform,
providing a flexible, modern and personalized learning experience. The product will provide
full functionality from registration, course selection, video learning, exercises, level testing,
to managing user learning progress.
For students, this is a convenient learning tool, helping them learn anytime,
anywhere at their own pace. For academy, this is a powerful support tool in managing
courses, students, and optimizing teaching quality. The product's further vision is to become
the leading platform in Vietnam in the field of online Japanese teaching and learning.

6. Project Scope & Limitations

Project Scope: The project will focus on building an online Japanese learning management
system that includes the following main functions:

- User management: Registration, login, learner and administrator authorization.

- Course management: Create, edit, delete and display course information.
- Online learning: Access learning content (videos, readings, exercises), learning
progress tracking system.
- Assessment & testing: Test system, grading, saving learning results.
- Academy management: Administrators can track student lists, learning progress, and
evaluate teaching effectiveness.
Limitations:
- The online payment function will be simulated simply, not yet integrating real
payment gateways.
- The course content used in the system is sample data, not yet integrating real
content from professional training centers.
- The system does not include the function of teaching directly via video call or
livestream.
- Basic security will be ensured at a level appropriate to the project, not yet applying
advanced security techniques such as two-step authentication or deep data
encryption.
6.1 Major Features
· Register / Login:

· FE-01: Register as a student or teacher.

· FE-02: Login/Logout using email and password (JWT token).

· FE-03: Email verification after registration.

· FE-04: Reset password via email.

· FE-05: Change password (for logged-in users).

· Language Settings:

· FE-06: Switch interface language between Vietnamese and Japanese.

· Personal Profile:

· FE-07: Update personal information (name, email, phone number).

· FE-08: Upload profile avatar (Cloudinary).

· FE-09: View account status (activated, locked, etc.).

· Tutor Profile:

· FE-10: Add/edit teaching experience.

· FE-11: Add/edit education background.

· FE-12: Manage work experience.

· FE-13: Upload and manage certificates.

· Course Creation & Management (Tutor):

· FE-14: Create and edit course info: title, description, price, level (N1–N5).

· FE-15: Design course structure: modules → lessons → attachments.

 · FE-16: Upload course thumbnail image.

· FE-17: Manage course status (Draft → Pending → Approved/Rejected).

· FE-18: Drag & drop module and lesson order.

· FE-19: Attach documents (PDF, DOC, XLS, etc.) to lessons.

· Lesson Content:

· FE-20: Create and update lesson content (text, video, duration).

· FE-21: Add vocabulary lists with examples.

· FE-22: Add grammar points with explanations.

· Exercises & Question Types:

· FE-23: Create exercises: multiple-choice, fill-in-the-blank, matching.

· FE-24: Create listening exercises (upload audio).

· FE-25: Create speaking exercises with pronunciation check.

· FE-26: Create writing exercises.

· FE-27: AI-based question generation via Gemini API.

· FE-28: Attach questions to specific lessons for tracking.

· Speaking Practice (Student):

· FE-29: Practice vocabulary, sentences, and conversation.

· FE-30: Speech recognition (Web Speech API).

· FE-31: Pronunciation scoring and instant feedback.

· FE-32: Record and store student voice for review.

· FE-33: View speaking progress statistics.

· Course Enrollment:

· FE-34: Search and preview available courses by name or level.

· FE-35: Enroll in a course.

· FE-36: Track course progress and lesson completion.

· FE-37: Generate certificate upon course completion.

· Learning Progress:

· FE-38: View completion percentage, scores, and test results.

· FE-39: View time spent learning and exercise performance.

· Student–Teacher Interaction:

· FE-40: Ask questions and discuss in each lesson.

· FE-41: Receive feedback from instructors.

· FE-42: Receive notifications on new updates.

· Payment:

· FE-43: Online payment integration with VNPay.

· FE-44: Handle payment callback and display payment status.

· FE-45: View payment history and status (Pending, Completed, Failed).

· Promotions & Course Combos:

· FE-46: Admin creates discount vouchers (percentage/fixed).

· FE-47: Set voucher conditions (minimum spend, valid dates, usage limit).

· FE-48: Apply vouchers to specific courses or combos.

· FE-49: Create and manage course combos with discounted pricing.

· Admin Dashboard:

· FE-50: Overview: student, tutor, course statistics.

· FE-51: Track enrollments and pending tutor/course approvals.

· Revenue & Reports:

· FE-52: View revenue by time (daily/monthly/yearly).

· FE-53: Revenue breakdown by course and tutor.

· FE-54: Filter by payment method.

· Admin Management Tools:

· FE-55: Manage user list (students and tutors).

· FE-56: Enable/Disable or Block/Unblock accounts.

 · FE-57: Approve or reject tutor accounts.

· FE-58: Approve or reject submitted courses.

· FE-59: Send feedback to tutors.

· System Configuration:

· FE-61: Email templates (verification, password reset).

· FE-62: File upload system (Cloudinary integration).

· FE-63: AI service setup (Gemini API).

· FE-64: Payment configuration (VNPay setup).

6.2 Limitations & Exclusions

· LI-1: The system currently supports only Japanese language learning.

· LI-2: No integration with external CRM or accounting systems unless explicitly requested
by stakeholders.

· LI-3: The interface is not fully optimized for mobile usage; no official mobile app is available
at this time.

· LI-4: The platform does not support the sale or shipment of physical books or learning
materials.

· LI-5: Customer support is limited to Zalo and Messenger; there is no phone or online chat
support.