教學內容 |
第1-3週 建立速食店值班表,銀行招考成績計算,列印產品目錄,分析損益表 第4-6週 資產負債表的製作,折舊的計算,部門費用管理,績效與銷售分析 第7-9週 計算業績獎金,計算員工出缺勤時數,員工考績計算, 第10-12週 企業網路意見調查表,市場調查分析,人事薪資系統, 第13-15週 投資理財計算,購屋貸款計算,規劃求解求算最大利潤, 第16-18週 股市分析, Excel與外部資料庫的結合,巨集鍵製與VBA,用PowerPoint展示分析結果, |
Syllabus |
Weeks 1-3 Establishing the schedule for workers, Caculating the Exam Scores, Printing the product table, Analyzing income statement
Weeks 4-6 Making the balance sheet, Calculating the depreciation, Analyzing the costs of different deparement,
Weeks 7-9 Caculating the reward for outstanding accomplishment, Caculating the worker's merit
Weeks 10-12 Investigating the opponient by internet, Market Survey, Salary systems
Weeks 13-15 Managing Finance, Granting a loan, Linear Programing
Weeks 16-18 Analyzing the Stock Market, Combining with data from Database system |