The J2E EEP Science Literacy Class Completes the "Excel Business Management" Micro-Course
國二EEP科學素養班完成「Excel公司經營管理學」微課程

Recently, the J2E EEP Science Literacy class (J2E) successfully completed three engaging sessions of the "Excel Business Management" micro-course, personally taught by Mr. Clark Huang. This course not only led students to a deeper understanding of Excel and business management techniques but also integrated Mr. Huang's extensive practical experience, greatly benefiting the students.

Mr. Huang emphasized the powerful applications of Excel in data analysis, financial reporting, budgeting, sales reporting, human resource management, project management, customer management, and process automation. To make it easier for students to get started, he focused on human resource management and customer management, sparking a strong interest in Excel and business management among the students.

During the course, Mr. Huang shared methods for tracking employee attendance, wages, and performance evaluations, as well as how to create and maintain customer lists and analyze customer data. These practical cases and techniques significantly motivated the students to learn.

The micro-course content is as follows:

##### Human Resource Management

1. **Data Organization**

   - Organizing employee information using tables and filter functions.

2. **Performance Evaluation**

   - Evaluating employee performance through data analysis functions.

3. **Attendance Management**

   - Tracking and analyzing employee attendance.

4. **Payroll Calculation**

   - Automatically calculating payroll using formulas and functions.

5. **Report Generation**

   - Generating and visualizing various HR reports.

##### Customer Management

1. **Customer Database**

   - Creating and maintaining customer information tables.

2. **Sales Analysis**

   - Analyzing sales data using pivot tables.

3. **Contact Tracking**

   - Managing and tracking customer contact records.

4. **Order Management**

   - Managing customer orders and sales records.

5. **Market Segmentation**

   - Segmenting the market based on data to develop marketing strategies.

These course contents not only covered essential skills and professional terminology related to Excel in human resource management and customer management but also improved students' skills and English communication abilities through bilingual instruction, enhancing their scientific and information literacy.

Mr. Huang hopes that these insightful knowledge and skills will have a positive impact on the students' future development, not only academically and technically but also in terms of fostering their technology, information, and media literacy, helping them stand out in the future AI society.
最近，國二EEP科學素養班(國二戊J2E)順利完成了三場精彩的「Excel公司經營管理學」微課程，由黃老師(Clark Huang)親自教授。這門課程不僅帶領學生深入了解Excel與企業經營管理的技巧，還結合了黃老師豐富的實務經驗，使學生們獲益匪淺。

黃老師強調，Excel在數據分析、財務報表、預算編制、銷售報告、人力資源管理、項目管理、客戶管理和流程自動化等方面具有強大的應用功能。為了讓學生們能夠輕鬆上手，他從人力資源管理和客戶管理兩個角度切入，激發了學生們對Excel與企業經營管理的濃厚興趣。

在課程中，黃老師分享了如何追踪員工出勤、工資和績效評估，以及如何建立和維護客戶名單，並分析客戶資料。這些實用的案例和技巧，大大激發了學生們的學習動機。

微課程內容如下：

##### 人力資源管理

1. **資料整理（Data Organization）**

   - 使用表格和篩選功能整理員工信息。

2. **績效評估（Performance Evaluation）**

   - 透過數據分析功能評估員工績效。

3. **出勤管理（Attendance Management）**

   - 追蹤和分析員工出勤狀況。

4. **薪資計算（Payroll Calculation）**

   - 利用公式和函數自動計算薪資。

5. **報表製作（Report Generation）**

   - 生成和視覺化各類HR報表。

##### 客戶管理

1. **客戶資料庫（Customer Database）**

   - 建立和維護客戶信息表。

2. **銷售分析（Sales Analysis）**

   - 使用樞紐分析表分析銷售數據。

3. **聯絡追蹤（Contact Tracking）**

   - 管理和追蹤客戶聯絡記錄。

4. **訂單管理（Order Management）**

   - 管理客戶訂單和銷售記錄。

5. **市場細分（Market Segmentation）**

   - 依據數據進行市場細分，制定行銷策略。

這些課程內容不僅涵蓋了Excel在人力資源管理與客戶管理中的重要技巧和專業術語，還透過中英文交流，提升了學生的技能和英語溝通能力，增強了他們的科學與資訊素養。

黃老師期望這些深入淺出的知識和技能對學生未來發展有積極影響，不僅在學術和技術上，還包括對科技資訊與媒體素養的培養，助力他們在未來的AI社會中脫穎而出。