| 當期課號 |
1451 |
Course Number |
1451 |
| 授課教師 |
楊振昇 |
Instructor |
YANG,CHEN SHENG |
| 中文課名 |
資料收集與軟體應用 |
Course Name |
Data collection and software application |
| 開課單位 |
行銷與流通管理系(四日)一B |
Department |
|
| 修習別 |
必修 |
Required/Elective |
Required |
| 學分數 |
3 |
Credits |
3 |
| 課程目標 |
本課程主要讓學生在行銷與流通管理領域的商業模式環境中，學習如何收集與應用學術與產業資料庫、重要圖書館藏、期刊搜尋以及相關資料資源，也從基礎商業軟體的實例演練與進階商業軟體的認識學習且以考取TQC EXCEL 2007 專業級證照為目標。 |
Objectives |
This curriculum mainly makes the student experience marketing and logistics business model environment of managing the realm and learn how to collect and take advantage of academic and industrial database, important library hide and journal resources. Students learn from the solid example of business software practice and advanced business
software of understanding learning and aim to get TQC Excel 2007 licence of level 3. |
| 教材 |
教科書：
1.授課教師整理之資料
2.Excel 2007 實力養成暨評量,財團法人中華民國電腦技能基金會,碁峰資訊,2008/8/22
3.Excel 2003 實力養成暨評量,財團法人中華民國電腦技能基金會,碁峰資訊,2008/10/14
參考書籍
1.Excel 2007實力養成暨評量解題秘笈,楊明玉,碁峰資訊,2009/2/15
2.Excel 2003實力養成暨評量解題秘笈,陳美玲、劉安蓉,碁峰資訊,2008/9/1 |
Teaching Materials |
Textbooks:
1. the teacher's teaching materials
2. Excel 2007, 碁峰資訊
3. Excel 2003, 碁峰資訊
Suggested additional resource books:
1. EXCEL 2007 (knack),碁峰資訊
1. EXCEL 2003 (knack),碁峰資訊 |
| 成績評量方式 |
1. 出席率 10%
2. 上課參與度 10%
3. 期中考試(Excel) 30%
4. 期末考試(Excel)50%。
若於期末考試前通過TQC-EXCEL 專業級證照，可不參加期末考試。
加分
若學期末前通過
1. TQC-EXCEL 實用級證照 5%
2. TQC-EXCEL 進階級證照 10%
3. TQC-EXCEL 專業級證照 15% |
Grading |
1. participation 10%
2. in-class discussion 10%
3. midterm exam 30%
4. final exam 50%
(While you get the TQC Excel licence of level 3,you pass the final exam.)
BONUS:
While you get the TQC Excel licence, you get 5%(Level 1),10% (Level 2),or 15% (Level 3) EXTRA bonus scores. |
| 教師網頁 |
|
| 教學內容 |
1. Excel工作表之格式設定
2. Excel工作表之編修
3. Excel工作表之進階處理
4. Excel工作表之列印設定
5. Excel統計圖表之建立
6. TQC-OA辦公軟體應用類技能測驗題庫
7. TQC-OA辦公軟體應用類技能測驗及評分系統模擬操作 |
Syllabus |
1. Form of the Excel work sheet establishes
2. The Excel work sheet edits
3. The Excel work sheet enters the step to process
4. Series printing of the Excel work sheet establishes
5. The Excel statistical graph establishes
6. TQC-OA work software application class skill testing question bank
7. TQC-OA work software application class skill testing and grading system simulation operation |