韓文補習班新課程商業分析｜Korean Language School Business Analysis 教學與趨勢

Contents 目錄

介紹 About the data

幫朋友做業務擴展，原始資料為某大學旁韓文補習班，希望開設新系列【初階課程】的分析，主要客群為該大學學生、有興趣的社會、退休人士，問券235份，報名表51份Helping a friend to expand their business. The original data is a Korean language school next to a university in Taichung, Taiwan. The analysis hopes to open a new series of 【beginner courses】. The main customer groups are university students, interested people and retired people. 235 questionnaires, 53 registration forms

一、瞭解【資料內容】、轉換【資料型態】Checking【data content】and converting 【data type】

第一份為學生意願調查，235份問券資料，因為補習班在大學附近，問券是在大學活動設攤收集
The first one is the Student Willingness Survey, with 235 questionnaires. Because the language school is near the university, the questionnaires are collected at the university event booth.

第二份為學生報名資料，51份確定報名的學生資料
The second one is student registration information, 51 confirmed student information.

原始資料從google表單下載，資料型態都是通用，改成文字、數值、日期 first convert the data type

二、資料清理 Data cleaning

第一份學生意願調查

空的格子的都補上「未填寫」Placement without data “unfilled”

第二份學生報名資料

空的格子的都補上「未填寫」Placement without data “unfilled”
【職業】、【單位】欄位，填的人過少，目前先不看

三、資料剖析，整理出會用到的新欄位 Analyze data and sort out new fields that will be used

第一份學生意願調查

複選，把選項拉出來整理，之後做樞紐分析
multiple choice questions,sort things out so that we can do pivot analysis later.
```
=IF(ISNUMBER(SEARCH("校內第二外語課程",B2)),"1","0")
```

第二份學生報名資料

新增欄位，提取生日年份
Add a new field to extract the birthday year
```
=YEAR(D3)
```
算出年紀，防止時間差，使用TODAY
Calculate age and prevent time lag, use TODAY
```
=YEAR(TODAY())-E3
```

分出年齡區間，也可以之後樞紐再群組化
Separate age ranges, and we can also group them later.

=IFERROR(IFS(AND(E4>0,E4<=5),"1~5",AND(E4>5,E4<=10),"6~10",AND(E4>10,E4<=15),"11~15",AND(E4>15,E4<=20),"16~20",AND(E4>20,E4<=25),"21~25",AND(E4>25,E4<=30),"26~30",AND(E4>30,E4<=35),"31~35",AND(E4>35,E4<=40),"36~40",AND(E4>40,E4<=45),"41~45",AND(E4>45,E4<=50),"46~50",AND(E4>50,E4<=55),"51~55",AND(E4>55,E4<=60),"56~60",AND(E4>60,E4<=65),"61~65",AND(E4>65,E4<=70),"66~70",AND(E4>70,E4<=75),"71~75",AND(E4>75,E4<=80),"75~80"),"未填寫")

星座 star sign

=IFERROR(IFS(AND(MONTH(D2)=3,DAY(D2)>=21), "白羊座",
   AND(MONTH(D2)=4,DAY(D2)<=20), "白羊座",
   AND(MONTH(D2)=4,DAY(D2)>=21), "金牛座",
   AND(MONTH(D2)=5,DAY(D2)<=20), "金牛座",
   AND(MONTH(D2)=5,DAY(D2)>=21), "雙子座",
   AND(MONTH(D2)=6,DAY(D2)<=21), "雙子座",
   AND(MONTH(D2)=6,DAY(D2)>=22), "巨蟹座",
   AND(MONTH(D2)=7,DAY(D2)<=22), "巨蟹座",
   AND(MONTH(D2)=7,DAY(D2)>=23), "獅子座",
   AND(MONTH(D2)=8,DAY(D2)<=22), "獅子座",
   AND(MONTH(D2)=8,DAY(D2)>=23), "處女座",
   AND(MONTH(D2)=9,DAY(D2)<=22), "處女座",
   AND(MONTH(D2)=9,DAY(D2)>=23), "天秤座",
   AND(MONTH(D2)=10,DAY(D2)<=23), "天秤座",
   AND(MONTH(D2)=10,DAY(D2)>=24), "天蠍座",
   AND(MONTH(D2)=11,DAY(D2)<=22), "天蠍座",
   AND(MONTH(D2)=11,DAY(D2)>=23), "射手座",
   AND(MONTH(D2)=12,DAY(D2)<=21), "射手座",
   AND(MONTH(D2)=12,DAY(D2)>=22), "摩羯座",
   AND(MONTH(D2)=1,DAY(D2)<=19), "摩羯座",
   AND(MONTH(D2)=1,DAY(D2)>=20), "水瓶座",
   AND(MONTH(D2)=2,DAY(D2)<=18), "水瓶座",
   AND(MONTH(D2)=2,DAY(D2)>=19), "雙魚座",
   AND(MONTH(D2)=3,DAY(D2)<=20), "雙魚座"),"未填寫")

提取出區域，後續方便查看，是否因為地緣而報名課程
Extract the area if the student is from Taichung, so we can check later to see if he signed up for the course because of the geographical location.
```
=IF(O2="台中市",MID(N2, 4, FIND("區", N2) - 3),"")
```

四、商業分析 Business Analysis

學生課程意願分析 Student Course Intention Analysis

問券來源、是否為某大學學生分析，因為是在學校做的問券調查，母體不均很正常
Analysis of the source of the questionnaire and whether it is a student of a certain university, because the questionnaire survey was done at a school, it is normal for the mother population to be uneven.
因為只是問卷，沒有地址，建議可以多一個欄位【地區】，如果居住在台中，請選地區
Since it is just a questionnaire without an address, it is recommended that there be an additional field 【Region】”If you live in Taichung, please select the region.”

有興趣參與課程學生，其他選項 (校外、在職中、社團、轉貼…) 有興趣參與的比例，比起無興趣參與的比例高
For students who are interested in participating in the course, other options (off-campus, on-the-job, club, repost…) The proportion of those who are interested in participating is higher than the proportion of those who are not interested in participating. It is recommended to find more samples from outside the university.

受訪者男女比分析，整體女性高達89.79%，對於校內男性 (理工學院傳單、校內活動…) 可以加大宣傳。校外問券收集，建議投放廣告，以填寫問券送學習手冊電子版…為誘因
Analysis of the male-to-female ratio of respondents, the overall female ratio is as high as 89.79%. It is recommended that more publicity be given to males on campus (polytechnic flyers, on-campus activities…). To collect questionnaires outside the university, it is recommended to place advertisements as an inducement to fill in the questionnaires and receive an electronic version of the study manual…

韓文能力分析，93.1% 受訪者未參加過韓文測驗
Korean proficiency analysis, 93.1% of the respondents have not taken the Korean test
所有受訪者，未學習過韓文為79.6% 。有興趣參加課程的學生、未學習過韓文為67.4%，大多數課程可以設計給零基礎，少部分設計給韓文一、二級
Among all respondents, 79.6% have never learned Korean. The number of students who are interested in taking the course and have never studied Korean is 67.4%. It is recommended that most courses be designed for zero basics, and a small number of courses are designed for Korean first and second level.

意願偏好時段，平常日晚上>週末白天>週末晚上開課 Preferred time period, it is recommended that classes start in the evening on weekdays > during the day on weekends > in the evening on weekends
建議增加平日下午、週末下午選項，可考慮分成週六早上、週六下午、週六晚上、週日早上、週日下午、週日晚上；或是直接增加一題: 如果開課為週末，你偏好的時間為?
It is recommended to add weekday afternoon and weekend afternoon options, and consider dividing them into Saturday morning, Saturday afternoon, Saturday evening, Sunday morning, Sunday afternoon, and Sunday evening; or directly add a question: If the class starts on a weekend, what is your preference? The time is?

優先考量條件，學費為多數人主要考量條件，課程內容為第二考量
Priority Consideration Conditions**, tuition fee is the main consideration condition for most people, and course content is the second consideration.
有興趣參與課程的學生，會比目前沒有規劃、對課程還好，想參與文化體驗活動的學生，更在意老師國籍
Students who are interested in participating in the course will be more concerned about the nationality of the teacher than students who currently have no plans, only want to participate in cultural experience activities.

有興趣參與課程

目前沒有規劃、對課程還好，但會想參加文化體驗活動

預期可接受價位，有意願參加課程，預期可接受價位，前80%受訪者大約為NTD 150~250
Expected acceptable price, those who are willing to take the course, expected acceptable price, the top 80% of respondents are approximately NTD 150~250
因為母體多數為學生，個人認為不太準確，少數在職中受訪者當中，接近60% 可接受價位為NTD 300
Because most of the respondents are students of the university, I personally think it is not accurate. Among the few working respondents, nearly 60% accepted the price of NTD 300.

關心的韓國議題，建議以韓國音樂分享、韓食料理、電視影劇、藝人明星、旅遊觀光去設計課程、粉專貼文、官網文章、體驗活動
Korean issues of concern, it is recommended to design courses, fan posts, official website articles, and experience activities based on Korean music sharing, Korean food, TV movies, celebrities, travel and tourism.
收到活動通知意願，不論是否有興趣參加課程，建議有勾選「是」的受訪者，定期分享新課程、粉專貼文、官網文章、體驗活動電子報
Regarding the willingness to receive event notifications, regardless of whether they are interested in participating in the course, it is recommended that respondents who check “Yes” regularly share new courses, fan posts, official website articles, and experience event e-newsletters.

學習偏好，除了8.79%的正規課程，多數人還是希望從生活中學習、實際應用 (認識朋友 12.82%、飲食文化 11.76%、留遊學 10.49%)
Learning preferences, in addition to 8.79% of formal courses, most people still hope to learn from life and apply it in practice (meeting friends 12.82%, food culture 11.76%, studying abroad 10.49%)

學習目的，有興趣報名課程、參加文化活動的受訪者，學習目的資訊閱讀、文法寫作、職場需求滿平均的。對照前面【關心的韓國議題】及【學習偏好】，建議建議【學習目的】增加聽說相關的選項，並讓受訪者排出順序，後續再加乘分數計算，比例會更明顯
Learning purpose: Respondents who are interested in enrolling in courses and participating in cultural activities have average learning purposes of information reading, grammar writing, and workplace needs. Comparing the previous 【Korea Issues of Concern】 and 【Learning Preferences】, it is recommended to add listening and speaking-related options to 【Learning Purpose】, and let the respondents rank the order, and then multiply the scores to calculate, the proportion will be more obvious.

學生課程意願分析儀表板 Student Course Intention Analysis Dashboard

學生報名分析 Student Enrollment Course Analysis

課程名稱
A: 星期一下午, 初級班, 大學旁
B: 星期三晚上6~9, 初級會話班, 台中市區
C: 星期三晚上6~9, 初級班, 大學旁
D: 星期六早上9~12, 初級班, 線上
Course Title
A: Monday afternoon, junior class, next to the university
B: Wednesday evening 6~9, beginner conversation class, downtown Taichung, Taiwan
C: Wednesday evening from 6 to 9, junior class, next to the university
D: Saturday morning 9~12, beginner class, online

學生男女比分析，總體班級、多數班級男生比例<20%，線上男生比例卻高達40% PS 資料筆數太少，繼續觀察
Analysis of the male-to-female ratio of students, the proportion of men in overall classes and most classes is < 20%, but the proportion of men online is as high as 40%. PS The number of data is too small, continue to observe
但以校內外來看，校外男性參加線上課程，比例高達44.44%，建議投放線上課程廣告時，全台皆投、男女皆選
However, looking at both inside and outside the school, 44.44% of men outside the school participate in online courses. It is recommended that when advertising online courses, all in Taiwan and both men and women choose to do so.
【課程D】線上課程

學生星座比，參考~ 假設星盤比例中，土象比較高的人，更喜歡報名課程學習
Just for reference~ Assuming that in the horoscope ratio, people with higher earth signs prefer to sign up for courses.
我的土象近40% : )

課程年齡分析，主要客群為16 ~ 30年輕人，及41 ~ 50較有經濟基礎，大多數孩子也成長的族群
Course age analysis, the main customer groups are young people between 16 to 30 years old, and those between 41 to 50 years old who have a better financial foundation and most of their children are growing up.
年紀較小 1 ~ 15、部分41 ~ 50、較大61 ~ 65，會傾向報名線上課程，投放廣告時可以下相關文案，強調年齡、時間友好
Younger ones (1 to 15 years old, some 41 t0 50 years old, and older people 61 tp 65 years old) will tend to sign up for online courses. It is recommended to place relevant marketing copy when placing advertisements, emphasizing age and time friendliness.
沒有年齡層特別傾向會話班，可能原因為: 市區選擇多、多數人還是報名A、B 班級，判斷台灣人還是喜歡先學習文法打好基礎，建議會話班可以強調零基礎OK、基礎紮實、短時間能會話、旅遊友善…
There is no age group that is particularly inclined to conversation classes. The possible reasons are: there are many choices in urban areas, and most people still sign up for A or B class. I judge that Taiwanese people still like to learn grammar first to lay a solid foundation. It is recommended that conversation classes can emphasize that zero basics are OK, a solid foundation, and short Time is conversational, travel friendly…
- A星期一下午班級，報名比例最高、學生年齡層分布很廣，建議表單【職業】欄位 (目前全部人幾乎都是空白)，用選項列出一些常見職業，學生、老師、服務業、製造業、軟體業、公務員…部分服務業星期一休，會更清楚判斷為何他們不需要上班，有時間來上課?
  A class, Monday afternoon class has the highest registration rate and a wide range of student age groups. It is recommended that the 【Occupation】 column of the form (currently almost all people are blank), use options to list some common occupations, students, teachers, service industry, manufacturing Industry, software industry, civil servants… Some service industries are closed on Mondays. Will it be easier to judge why they don’t need to go to work and have time to attend classes?

學歷教材分析，大學生比較會買習題本，希望促進其他年齡層購買，可以另外提醒自我練習重要性
Analysis of academic textbooks. College students are more likely to buy exercise books. If we hope to encourage other age groups to purchase them, it is recommended to remind them of the importance of self-practice.

接觸過韓文比例，投放廣告時，因為都是初階班，可以搭配學生課程意願調查的【學習目的】下關鍵字
Proportion of people who have been exposed to Korean. When placing advertisements, since they are all beginner classes, it is recommended to use the keyword 【Learning Purpose】 in the student’s course intention survey.
查詢詳細資料

是否為某大學學生，校內 (校內活動、各系系網、line群、校內擺攤…) 可以加大宣傳，配合投放廣告
Whether you are a student of a certain university, we can increase publicity and cooperate with advertising on campus (on-campus activities, department networks, line groups, on-campus stalls…)
【學生類別】欄位，除了校內、校外，建議增加校友、學校職員家屬選項，未來的新課程，會更方便查看要宣傳、投放廣告的群體
In the 【Student Category】 field, in addition to on-campus and off-campus options, it is recommended that that add options like alumni and family members of school staff. In future new courses, it will be more convenient to check the groups to be promoted and advertised.
原始資料中，【職業】、【單位】欄位，填的人過少，建議之後一併統整成【職業】，未來的新課程，會更方便查看要宣傳、投放廣告的群體
In the original data, there are too few people filling in the 【Occupation】 and 【Unit】 fields. It is recommended that they be unified into 【Occupation】 later. In future new courses, it will be more convenient to check the groups to be promoted and advertised.

學生地區分析，校外學生，參加實體課程，不只來自台中，可能原因為: 畢業校友、單純選取家鄉，建議之後表單中地區要標註「居住地，非戶籍地」
Student Region Analysis, off-campus students participating in physical courses are not only from Taichung. The possible reasons are: graduate alumni, simply select hometown. It is recommended that the region in the form be marked “residence, not household registration” in the future.

校外學生

校內外學生，參加【D】，為線上課程，分布一些縣市，不只限於台中，如同前面建議投放線上課程廣告時，全台皆投、男女皆選
Students on and off campus can participate in 【D class】, which is an online course distributed in some counties and cities, not just in Taichung. As previously suggested when advertising online courses, all Taiwan can apply, and both men and women can apply.

校內外學生，參加【課程名稱 D】

校內學生，不論實體、線上課程，女生比例高出很多，女生佔比92.31%，對於校內男性 (理工學院傳單、校內活動…) 可以加大宣傳
Among on-campus students, regardless of physical or online courses, the proportion of girls is much higher, with girls accounting for 92.31%. For the men on campus (polytechnic flyers, on-campus activities…), more publicity can be

校內學生

多數人還是因為地緣關係而參與課程，投放實體課程廣告時，可以圈選範圍(1A、2A: 沙鹿區外擴 ? km) (1B: 台中市區上課地點外擴 ? km)
Most people still participate in the course because of the geographical relationship. It is recommended that when advertising physical courses, you can circle the range (A, B: Shalu District extension ? km) (D: downtown Taichung class location extension ? km)

學生報名分析儀表板
Student Enrollment Course Analysis Dashboard

五、表單、網站更改建議 Forms, website change suggestions

表單更改彙總
Summary of suggested form changes

網站網址，網站為http，容易被偵測為不安全網站，建議申請網域
Website URL, the website is http, it is easily detected as an unsafe website, it is recommended to apply for a domain.

流量 : 搜尋關鍵字，網站可以增加【韓語學習】目錄，類似部落格概念，參考【關心的韓國議題】，細分音樂、飲食文化、演藝圈、美妝、旅遊、文法、發音… 並依照主題比例產出，寫文章、製作貼文、影片…，參考搜尋前三頁用什麼關鍵字，訂出適合的短尾、長尾關鍵字，埋進文章
Traffic: Search keywords, it is recommended that the website add a 【Korean language learning】 directory, similar to the concept of a blog, refer to 【Korean issues of concern】, segmented into music, food culture, entertainment industry, beauty, travel, grammar, and pronunciation …and output according to the theme proportion, write articles, make posts, videos…, refer to the keywords used in the first three pages of the search, determine the appropriate short-tail and long-tail keywords, and bury them in the article.

流量 : 文章、廣告關鍵字，可以多寫旅遊美食、常見用語教學翻譯相關文章，增加網站流量
Traffic: Articles, Advertising Keywords, it is recommended to write more articles related to travel, food, common expressions, teaching and translation, to increase website traffic.

流量 : 安裝軟體，網站埋入ga4、google search console，方便查看入站來源、之後做優化，並做fb、google 廣告ab test
Traffic: Install software. It is recommended that the website be embedded in ga4 and google search console to facilitate viewing of inbound sources, optimization later, and FB and google advertising ab test.

流量 : 研究競爭對手，研究競爭對手，可以寫幾篇介紹、比較韓語學習網站文章，讓搜索對手關鍵字的使用者，也有可能搜尋到網站
Traffic: Research competitors. To research competitors, we can write a few introductions and compare Korean learning website articles, so that users who search for competitor keywords may also search for our website.