ªF§d¤j¾Ç±Ð®v±Â½Ò­p¹ºªí

Àɮײ£¥Í®É¶¡¡G2019/9/26 ¤U¤È 05:52:09
¥»ªí¦p¦³²§°Ê¡A©ó4¤p®É¤º¦Û°Ê§ó·s
¤@¡B½Òµ{°ò¥»¸ê®Æ Course Information
¬ì¥Ø¦WºÙ Course Title¡G
(¤¤¤å)°]¸g¸ê®Æ®wÀ³¥Î¤ÀªR¡]¢Ï¡^¸ê°T¯à¤O
(­^¤å)APPLICATION AND ANALYSIS OF ECONOMIC ANDFINANCIAL DATABASES (A)
¶}½Ò¾Ç´Á Semester¡G108¾Ç¦~«×²Ä1¾Ç´Á
¶}½Ò¯Z¯Å Class¡G¸g¤T¢Ï
±Â½Ò±Ð®v Instructor¡G³¢¹Å²» GUO, CHIA-HSIANG
¬ì¥Ø¥N½X Course Code¡GBEC34301 ³æ¥þ¾Ç´Á Semester/Year¡G³æ ¤À²Õ²Õ§O Section¡G¸ê°T¯à¤O
¤H¼Æ­­¨î Class Size¡G70 ¥²¿ï­×§O Required/Elective¡G¿ï ¾Ç¤À¼Æ Credit(s)¡G2
¬P´Á¸`¦¸ Day/Session¡G «e¦¸²§°Ê®É¶¡ Time Last Edited¡G108¦~06¤ë13¤é12®É48¤À
¸gÀپǨt°ò¥»¯à¤O«ü¼Ð Basic Ability Index
½s¸¹
Code
«ü¼Ð¦WºÙ
Basic Ability Index
¥»¬ì¥Ø¹ïÀ³¤§«ü¼Ð
Correspondent Index
¹F¦¨¸Ó¶µ°ò¥»¯à¤O¤§¦Òµû¤è¦¡
Methods Of Evaluating This Ability
1¨ã³Æ¸gÀپǮ֤ߪ¾ÃÑ
Core economic knowledge.
  
2¨ã³Æ¸gÀÙÀ³¥Î¤Î¬Fµ¦¤ÀªR¯à¤O
The ability to apply economic theories and conduct policy analysis.
¡´¡n½Ò°ó°Q½×»Pªí²{
¡n§@·~¦¨ÁZ
¡n¹ê§@(§t¤À²Õºt½m/¦X§@µ¥)
¡n¸ê®Æ»`¶°»P¤ÀªR
3¨ã³ÆÅÞ¿è«ä¦Ò¯à¤O
The ability of logical thinking.
¡´¡n½Ò°ó°Q½×»Pªí²{
¡n¸ê®Æ»`¶°»P¤ÀªR
4¨ã³Æ¼Æ²z¤ÀªR¯à¤O
The ability to perform mathematical analysis.
  
5¨ã³Æ²Î­p¤ÀªR¯à¤O
The ability to perform statistical analysis.
¡´¡n½Ò°ó°Q½×»Pªí²{
¡n§@·~¦¨ÁZ
¡n¸ê®Æ»`¶°»P¤ÀªR
6¨ã³Æª÷¿Ä»P°]°È±M·~¯à¤O
Professional skills in money, banking and finance.
¡´¡n½Ò°ó°Q½×»Pªí²{
¡n§@·~¦¨ÁZ
¡n¹ê§@(§t¤À²Õºt½m/¦X§@µ¥)
¡n¸ê®Æ»`¶°»P¤ÀªR
7¨ã³Æ¸ê®Æ¦¬¶°¤Îªí¹F¯à¤O
The ability to gather information and to make presentations.
¡´¡n§@·~¦¨ÁZ
¡n¹ê§@(§t¤À²Õºt½m/¦X§@µ¥)
¡n¸ê®Æ»`¶°»P¤ÀªR
8¨ã³Æ­^¤å¾\Ū¯à¤O
The ability to read English proficiently.
  
¤G¡B«ü©w±Ð¬ì®Ñ¤Î°Ñ¦Ò¸ê®Æ Textbooks and Reference
(½Ð­×½Ò¦P¾Ç¿í¦u´¼¼z°]²£Åv¡A¤£±o«Dªk¼v¦L)
¡´«ü©w±Ð¬ì®Ñ Required Texts
¥»½Òµ{¤W½Ò¤è¦¡¬°¥DÃD¦¡(¸gÀÙ»P°]°È¥DÃD)ªº°Q½×¡A´N³o¨Ç¥DÃD¦Ó¨¥¡A¨ÃµL¯S©w¦X¾Aªº±Ð¬ì®Ñ¡C¦ý´NMicrosoft Excel¥\¯à¦Ó¨¥¡A¥«­±¦³«Ü¦h³oºØ©Ò¿×°Ó·~®M¸Ë³nÅ骺®Ñ¡A¥i§@¬°°Ñ¦Ò¤§¥Î¡C
¡´°Ñ¦Ò®Ñ¸ê®Æº[ºô¸ô¸ê·½ Reference Books and Online Resources
Excel°Ó·~®M¸Ë³nÅ骺®Ñ¡C
¤T¡B±Ð¾Ç¥Ø¼Ð Objectives
¥»½Òµ{¶}³]¥Ø¼Ð¬O¬°À°§U¾Ç¥Í¡A§Q¥Î¸gÀÙ»P°]°È¸ê®Æ®w¡AÀ³¥Î¦b±`¨£ªº»P¹ê°Èªº¸gÀÙ»P°]°È°ÝÃD¤§¸ê®Æ¤ÀªR¡C¤W½Ò¤º®e±N¥]¬A(1)­«­n°]¸g¸ê®Æ®wªº¤¶²Ð»P¨Ï¥Î¡F(2)§Q¥Î²³æªº(²Î­p)¤ÀªR¤èªk¡A°w¹ï¦U¶µ¸gÀÙ»P°]°Èªº¥DÃD¡A¶i¦æ¸ê®Æ¤ÀªR¡F(3)Excel²Î­p¥\¯à»P²³æ²Î­p³nÅ骺¤¶²Ð»P¨Ï¥Î¡C¾ã¾Ç´Áªº¤W½Ò¦aÂI³£¬O¦b¹q¸£±Ð«Ç¡A¦]¦¹»Ý­nú¥æ¹q¸£¹ê²ß¶O¥Î$1,200(¦¹¶O¥Î±NÅã¥Ü¦b¤U¾Ç´Áªºµù¥U¦¬¶O³æùØ)¡C
¥»½Òµ{¦Û99¾Ç¦~¶}©l¡A¤W¾Ç´Áªº½Òµ{(°]¸g¸ê®Æ®wÀ³¥Î¤ÀªRA)±Nª`­«¸ûªì¶¥ªº¤º®e¡A¤U¾Ç´Áªº½Òµ{(°]¸g¸ê®Æ®wÀ³¥Î¤ÀªRB)¤´Ä~Äò¨Ï¥ÎExcel¤ÀªR³nÅé¡A¦ý±Nª`­«¸û¶i¶¥ªº¤º®e¡C
¾Ç´Á¤¤¡A¦b¨C¤@¥DÃD¤¶²Ð¨Ã°Q½×§¹«á¡A±N«ü©w¤@­Ó¹ê§@§@·~¡A§Q¥Î¸ê®Æ®wªº¸ê®Æ¥h¹ê»Úªº¶i¦æ¤ÀªR¡C´Á¤¤»P´Á¥½¡A±Nµ¹¤©¸û¦³¤º®eªº¸gÀ٩ΰ]°ÈijÃD¡AÅý¾Ç¥Í¤@¨B¤@¨B§¹¦¨«ü©wªº¤ÀªR»Pµ²ªG¡C

The course is in effect a computer lab, examining several economic and financial issues by retrieving data from the TEJ databases and then analyzing the data with statistical and quantitative methods. Students will have their class in the computer lab classroom. The will learn four things: (1)various economic and financial issues; (2)the TEJ databases; (3) basic statistical and quantitative methods; and (4) MS Excel's functions for statistical and quantitative analyses.
The course is in effect a computer lab, examining several economic and financial issues by retrieving data from the TEJ databases and then analyzing the data with statistical and quantitative methods. Students will have their class in the computer lab classroom. The will learn four things: (1)various economic and financial issues; (2)the TEJ databases; (3) basic statistical and quantitative methods; and (4) MS Excel's functions for statistical and quantitative analyses.
¥|¡B½Òµ{¤º®e Course Description
¡´¾ãÅé±Ô­z Overall Description
¥»½Òµ{¹w³Æ°Q½×ªº¥DÃD¤À¬°¨â¤jÃþ¡A¤@¬°¸gÀÙijÃD¡A¥t¤@¬°°]°ÈijÃD¡C¨C¤@°Q½×ªº¥DÃD±N»Ý­n±q¦X¾Aªº¸ê®Æ®w§ì¨ú¸ê®Æ¡A¨Ã¥B§Q¥ÎExcel¦X¾Aªº¼Æ¶q¤ÀªR¤u¨ã¶i¦æ¤ÀªR¡C³Ì«á¦A°Q½×¼Æ¶q¤ÀªR«áªºµ²ªG¤Î¨ä·N¸q¡C
¡´¤À¶g±Ô­z Weekly Schedule
¶g¦¸ Wk ¤é´Á Date ½Òµ{¤º®e Content ³Æµù Note

1

9/10 ½Òµ{¤¶²Ð  ¡@

2

9/17 TEJ°]¸g¸ê®Æ®w¤¶²Ð(¤@)¡GÁ`Åé¸gÀÙ¸ê®Æ(¦W¥ØÅܼơB¹ê½èÅܼơB¤Î¦¨ªø²vªº°Q½×)
 ¡@

3

9/24 TEJ°]¸g¸ê®Æ®w¤¶²Ð(¤G)¡GªÑ²¼«ü¼Æ»P´º®ð»â¥ý«ü¼Ð  ¡@

4

10/1 TEJ°]¸g¸ê®Æ®w¤¶²Ð(¤T)¡G­ÓÅé¸gÀÙ¸ê®Æ(­·ÀI¦]¤l»PªÑ²¼³ø¹S²v)  ¡@

5

10/8 (1)Excel±Ô­z²Î­p¥\¯à (2)ªÑ²¼³ø¹S²vªº±`ºA¤À°t©Ê°Q½× - ®p«×¡B·¥ºÝ­È¾÷²v¡B¬Û¹ï¦¸¼Æ¤À°t¹Ï®ÑÀ]  ¡@

6

10/15 ªÑ²¼³ø¹S²vªº±`ºA¤À°t©Ê°Q½× - Stable Distribution °Ñ¼Æªº¦ô­p  ¡@

7

10/22 ·L¤À»P¿n¤À  ¡@

8

10/29 ²Ö¿n¶WÃB³ø¹S²v(CAR)»P¨Æ¥ó¬ã¨sªk(Event Study)(¥H­«¤j°]°È¨Æ¥ó¬°¨Ò)(§tExcel®É¶¡§Ç¦C¸ê®Æø¹Ï¥\¯àªº¤¶²Ð)  ¡@

9

11/5 ´Á¤¤¹ê§@  ¡@

10

11/12 ¸ê²£²Õ¦X§ë¸êÁZ®Äªº¿Å¶q¡G(1)CAR method  ¡@

11

11/19 ¸ê²£²Õ¦X§ë¸êÁZ®Äªº¿Å¶q¡G(2)¸ê²£²Õ¦XÅܰʪk  ¡@

12

11/26 §Þ³N¤ÀªR - ²¾°Ê¥­§¡ªk  ¡@

13

12/3 §Þ³N¤ÀªR - ¥¬ªL®æ³q¹D (³æ¤@¸ê²£)  ¡@

14

12/10 §Þ³N¤ÀªR - ¥¬ªL®æ³q¹D (´Á³f»P²{³fªº®M§Q)  ¡@

15

12/17 Excel¹Bºâ¦Cªí¥\¯à»P2D¹Ï§ÎªºÃ¸»s
¨Ò¡G(1)³æÅܼƱ`ºA¾÷²v±K«×¨ç¼Æ(2)Black-Scholes¶R¡B½æÅv¬°¨Ò
 ¡@

16

12/24 Excel¹Bºâ¦Cªí¥\¯à»P3D¹Ï§ÎªºÃ¸»s
¨Ò¡G(1)ÂùÅܼƱ`ºA¾÷²v±K«×¨ç¼Æ(2)CES®Ä¥Î¨ç¼Æ(3)Black-Scholes¶R¡B½æÅv
 ¡@

17

12/31 (1)ÀH¾÷©â¼Ë (2)¨t²Î­·ÀI»P¿W¯S©Ê­·ÀI  ¡@

18

1/7 ´Á¥½¹ê§@  ¡@
¤­¡B¦Òµû¤Î¦¨ÁZ®Öºâ¤è¦¡ Grading
°t¤À¶µ¥Ø Items ¦¸¼Æ Times °t¤À¤ñ²v Percentage °t¤À¼Ð·Ç»¡©ú Grading Description
¥­®É§@·~1030%´Á¤¤¦Ò»P´Á¥½¦Òªº§Î¦¡¬O¥H¹ê§@ªº¤è¦¡¶i¦æ¡C
´Á¤¤¦Ò130% 
¾Ç´Á¦Ò140% 
°t¤À¤ñ²v¥[Á` 100%  
¤»¡B±Â½Ò±Ð®v½Ò·~»²¾É®É¶¡©MÁpµ¸¤è¦¡ Office Hours And Contact Info
¡´½Ò·~»²¾É®É¶¡ Office Hour
¬P´Á¤T 13:30 ~ 15:30
¬P´Á¥| 15:30 ~ 17:30

¡´Ápµ¸¤è¦¡ Contact Info
¬ã¨s«Ç¦aÂI Office¡GR3407 EMAIL¡Gchguo@scu.edu.tw
Ápµ¸¹q¸Ü Tel¡G3439 ¨ä¥L Others¡G
¤C¡B±Ð¾Ç§U²zÁpµ¸¤è¦¡ TA¡¦s Contact Info
±Ð¾Ç§U²z©m¦W Name ³sµ¸¹q¸Ü Tel EMAIL ¨ä¥L Others
µL   
¤K¡B«Øij¥ý­×½Òµ{ Suggested Prerequisite Course
ªìµ¥²Î­p¾Ç¡B¸gÀپǭì²z¡B»P°]°È½Òµ{
¤E¡B½Òµ{¨ä¥L­n¨D Other Requirements
¥»½Òµ{¾ã¾Ç´Áªº¤W½Ò¦aÂI³£¬O¦b¹q¸£±Ð«Ç¡A¦]¦¹»Ý­nú¥æ¹q¸£¹ê²ß¶O¥Î$1,200(¦¹¶O¥Î±NÅã¥Ü¦b¤U¾Ç´Áªºµù¥U¦¬¶O³æùØ)¡C
¤Q¡B¾Ç®Õ±Ð§÷¤Wºô¤Î±Ð®v­Ó¤Hºô§} University¡¦s Web Portal And Teacher's Website
¾Ç®Õ±Ð§÷¤Wºôºô§} University¡¦s Teaching Material Portal¡G
ªF§d¤j¾ÇMoodle¼Æ¦ì¥­¥x¡Ghttp://isee.scu.edu.tw
±Ð®v­Ó¤Hºô§} Teacher's Website¡Gchguo@scu.edu.tw
¨ä¥L Others¡G
¤Q¤@¡B­pµeªí¤½¥¬«á²§°Ê»¡©ú Changes Made After Posting Syllabus