ࡱ> _bjbjkk.;\;\;/\\\\\ppp8llpe5n  !>!! 444444469p49\"!!""4\\ 5r+r+r+"\ \ 4r+"4r+r+T01 @[~#6p1"4550e51"9"%9D19\1""%"r+="Q""""448(:"""e5""""9"""""""""h ":The International College of Economics and Finance Syllabus for Programming and Data Processing Lecturer: Sergey G. Efremov Class teacher: Sergey G. Efremov Course description: In the modern, highly technological world computer skills have become essential for specialists in almost all possible areas. Programming in particular has gone beyond its traditional borders of being just an IT prerogative. In the last 10 years languages and tools have evolved significantly, which now enables people even without a solid technical background to successfully master related skills. The present course if offered to 1st year ICEF students and runs in parallel with the basic level Information Computer Systems course. Students wishing to enter the advanced course take a test to verify the required knowledge and skills. In particular, candidates are assumed to have a solid user-level understanding of the Windows (or other desktop) operating system (GUI, file system, running and installing applications, using standard applications: text editor, browser, mail client, etc.) and programming basics (any high-level language). Knowledge of Excel fundamentals is required for the second part of the course. The course is split into two distinct parts. The first part focuses on programming and data processing techniques using the Python language. The second part covers advanced Excel features that can be useful in later ICEF courses and economics-related applications. The course is taught in Russian and is not part of the University of London international programme. Course Objectives The aim of the course is twofold: on the one hand, it provides students with knowledge of fundamental programming principles and the corresponding practical skills. Although based on the particular toolset (Python), the course is intended to give a general view of what can be done using a modern general-purpose programming language. On completing the first part students are expected to know several techniques of automated data acquisition, including web queries, and basic data processing. On the other hand, students will learn several advanced Excel skills that are useful in many practical applications in economics. Methods The course is practice-oriented and requires active student involvement in its activities. The following methods and forms of study are used in the course: practice sessions (4 hours a week, conducted in a computer class) regular homework assignments. Each assignment takes from 2 to 4 hours to complete including the required readings. Code assignments are checked for plagiarism using the Stanford Moss system ( HYPERLINK "https://theory.stanford.edu/~aiken/moss/" https://theory.stanford.edu/~aiken/moss/) The final assignment will be in the form of a small project (2 weeks) online consultations from course instructor(s) (through the Google+ Hangouts on Air) self-study activities: completing homework assignments, studying recommended resources, experimenting with the toolset, solving advanced tasks In total the course comprises 60 hours of practice sessions and 92 hours of self-study activities. Main Reading: The main textbook Think Python [1] is a well-structured introductory resource for beginners in programming. Students can study the book chapter by chapter, as the course closely follows its structure. Special attention should be paid to the glossary at the end of each chapter. Fundamentals of Python my K. Lambert [2] is a more advanced textbook and only selected reading (see course outline) is recommended in the beginning. For Excel-related topics student guides and textbooks [4, 5] written by ICEF staff are the primary recommended resource. Allen B. Downey. Think Python. How to think like a computer scientist. Green Tea Press, 2008. Electronic version available for free download at: http://www.greenteapress.com/thinkpython/ Kenneth A. Lambert. Fundamentals of Python: From First Programs Through Data Structures. Course Technology, 2010. Walkenbach J. Excel 2010 Bible. - Wiley, 2010. :8=H8= .., 5;>CA>20 !.., 5AA>=>20 .. C:>2>4AB2> 4;O ABC45=B>2 ?> :C@AC =D>@<0F8>==K5 :><?LNB5@=K5 A8AB5<K. >A:20: -$, 2014. 68 A. :8=H8= .., 5;>CA>20 !.., 5AA>=>20 .. !?5F80;L=K5 2>7<>6=>AB8 MS Excel 4;O @01>BK A 1>;LH8<8 <0AA820<8 8=D>@<0F88 (2-5 8740=85 8A?@02;5==>5 8 4>?>;=5==>5). >A:20: -$, 2010. 162 A. Supplementary reading CBF . 7CG05< Python, 4-5 8740=85.  5@. A 0=3;.  !1.: !8<2>;-;NA, 2011.  1280 A., 8;. W. McKinney. Python for Data Analysis: Data Wrangling with Pandas, NumPy, and IPython. OReilly Media, 2012. Internet resources Python practice book.  HYPERLINK "http://anandology.com/python-practice-book/index.html" http://anandology.com/python-practice-book/index.html Coursera online course: Interactive Python. https://www.coursera.org/course/interactivepython1 CodeAcademy. Python track.  HYPERLINK "https://www.codecademy.com/tracks/python" https://www.codecademy.com/tracks/python Python 3 installation guides for different OS:  HYPERLINK "https://pragprog.com/book/gwpy2/practical-programming" https://pragprog.com/book/gwpy2/practical-programming Some of the basic differences between Python 2 and Python 3:  HYPERLINK "http://www.cs.carleton.edu/faculty/jgoldfea/cs201/spring11/Python2vs3.pdf" http://www.cs.carleton.edu/faculty/jgoldfea/cs201/spring11/Python2vs3.pdf Python regular expressions tutorial.  HYPERLINK "http://www.tutorialspoint.com/python/python_reg_expressions.htm" http://www.tutorialspoint.com/python/python_reg_expressions.htm Python requests library.  HYPERLINK "http://docs.python-requests.org/en/latest/" http://docs.python-requests.org/en/latest/ NumPy tutorial.  HYPERLINK "http://wiki.scipy.org/Tentative_NumPy_Tutorial" http://wiki.scipy.org/Tentative_NumPy_Tutorial OpenPyXL library.  HYPERLINK "https://openpyxl.readthedocs.org/en/latest/" https://openpyxl.readthedocs.org/en/latest/ RESTful web services:  HYPERLINK "http://www.drdobbs.com/web-development/restful-web-services-a-tutorial/240169069" http://www.drdobbs.com/web-development/restful-web-services-a-tutorial/240169069 Python database access:  HYPERLINK "http://www.tutorialspoint.com/python/python_database_access.htm" http://www.tutorialspoint.com/python/python_database_access.htm Required software The first part of the course is based on Python 3. The default toolset, which can be downloaded from  HYPERLINK "https://www.python.org/downloads/" https://www.python.org/downloads/, is open-source and cross-platform. The second part of the course requires installation of Excel 2010 or higher. Grade determination The course includes regular homework assignments, a mid-term test on Python programming and the final exam. The final course grade is determined by a weighted average of the aggregated grade (60%) and the exam grade (40%). The aggregated grade is calculated as a weighted average of 8 homework assignments (60%, 5 on programming and 3 on Excel) and the mid-term test (40%). Course Outline Part 1. Programming in Python Introduction to programming and the Python language. Purpose of programming. Source code and executable files. Programming languages. Python application areas. Python versions 2 and 3. Overview of resources and development tools. Software installation. Interactive shell [1: P. 1-9], [2: P. 2-29], [12] Python basics Types and variables. Integer, float and string types. Conversion between types. type operator. Arithmetic operators. Console input-output. Formatted output. [1: P. 11-18], [2: P. 342-375] Program flow Boolean expressions. Conditional execution. Code formatting. while loop. Code editor. Debugging programs. [1: P. 41-44, 64-70], [2: P. 75-120] Functions and modules Importing modules. Calling standard functions. Functions and methods. Math and random modules. Defining custom functions. Installing new packages. [1: 19-29], [2: 63-69, 201-210] Data structures Mutable and immutable types. Lists: creating a list, adding and removing elements, retrieving elements, sorting lists, slices. Dictionaries: creating a dictionary, adding and removing items, querying items by key. Tuples. Conversions between data structures. for loop and in operator. The datetime type. Comprehensions. [1: P. 87-132], [2: P. 159-200] Processing text. Regular expressions Specialized methods for string manipulation and processing. Regular expression language: main capabilities and samples. Extracting data to groups. [1:71-86], [2: P. 121-140], [13] File input-output File system. Absolute and relative paths. File access modes. Formats. Standard operations. [1: P. 133-136], [2: P. 141-147] Data acquisition Data formats: txt, csv, xml, json. Integration with the Web: basics of HTTP, extracting data from HTML, downloading files, querying RESTful services. Integration with SQL DBMS. [14, 17, 18] Python for data analysis and visualization Overview of available packages and their features. Integration with Excel. [15, 16] Part 2. Advanced Excel Topic 1. Functions Functions in Excel vs Functions in programming. Excel Functions Syntax. Cell references. Names in formulas. Computational and financial Excel functions. Conditional formatting. [3: P. 213-243, 467-486], [4: P. 30-34] Topic 2. Graphical Data Visualization and Analysis in MS Excel Charts, graphs, and their properties. Customizing charts. Smoothing. Graphical data analysis. Sparklines for visual representation of data. [3: P. 389-422, 487-498] Topic 3. Processing large series of data. Excel database. Sorting, searching and editing. Filtering, AutoFilter. Creating custom filters using Excel Advanced Filter. Database functions. Vertical and horizontal lookup functions. Subtotalling the data. Data Consolidation. Pivot Tables and Charts. Sorting and filtering subtotals. Calculations in pivot tables: additional calculations, calculated fields and objects. Pivot charts. [3: P. 311-328, 665-712], [5: P. 45-91, 95-112, 113-154] Topic 4. MS Excel Add-ins Microsoft Excel add-ins for statistical tasks (Analysis ToolPak) and optimization (Solver). Analysis ToolPak for Microsoft Excel: finance, statistics and engineering functions. Solver Add-In. What-If analysis. Using Solver for solving systems of linear and non-linear equations. Goal Seek. Solving system of equations. [3: P. 727-744], [4: P. 5-30] Topic-wise course plan NoTopicsIn classSelf-studyPart 1. Programming in Python1Introduction to programming, the Python language and IDE242Python basics263Program flow464Functions and modules485Data structures8126Processing text. Regular expressions687File input-output468Data acquisition10149Python for data analysis and visualization44Part 2. Advanced Excel1Built-in functions462Graphical analysis443Working with large series of data484Add-ins for economic tasks46Total:6092 Preliminary course schedule (2015-2016) WeekDatesTopicHWModule 111/09 6/09Introduction to programming. Python basicsHW0 (not graded): install IDE, experiment with Python27/09 13/09Program flowHW1: conditional execution and loops314/09 20/09Functions and modulesHW2: functions and modules421/09 27/09Data structures: lists, tuples528/09 4/10Data structures: dictionaries, datetime, comprehensionsHW3: data structures65/10 11/10Processing text, regular expressions712/10 18/10Regular expressions, file input-outputHW4: processing text and regular expressions819/10 25/10File input-output, web basicsModule 212/11 8/11Downloading files, web queriesProject (HW5)29/11 15/11Python and SQL316/11 22/11@A`ablm~   - 2 5 ? M  / 5 > D E F G Z h ׂ| h#kCJ hcCJ h#kCJ] h!`XCJ] hN]CJ] hCJ] hzKCJ] h$ CJ] h _CJ] hcCJ]h h>*CJ hzK>*CJ h"CJ hCJ h>*CJ h=h1| h=hk? h=hzK h=h.3bcF ();<*Q$ & F *$a$gdc $ *$a$gd$a$$ `a$gdc d`gdgd= *$gd=h k   7 C D E F P m x  5 i * + 4 U V t z } ˷˷ꩰ㛔񰍢բՔ hCJ] hzKCJ] hCJ] h1|CJ] hq6CJ] h _CJ] hN]CJ]hUXhN]CJ]hUXhq6CJ]hUXhCJ] hCJ] hKnCJ] hCJ] hLCJ] h#kCJ] h"CJ]3 ();<T^qryz =)*=DEFhoQcͻͻ͵ǵǵǵǯǵ|h"CJmH sH hCJmH sH hCJmH sH hmH sH h5>*CJmH sH  hCJ h-mCJ hTCJ hCJ hLCJ hq6CJ h"CJh hCJ h#rCJ] h!`XCJ] hCJ] hcCJ]0cdetRS_&'()+7CNOPغάΟά|||rhhX_CJmH sH hCJmH sH h>:CJmH sH h#CJmH sH hZs*h&h0JCJmH sH h&hh&hCJmH sH jh&hCJUmH sH hCJmH sH h"CJmH sH h&hCJmH sH h7 CJmH sH hu&CJmH sH hU CJmH sH hCJmH sH (PDEST|}8$ & F 0*$a$gd _$ & F 0*$a$gd%4 $ !da$  !d $ *$a$gd1 *$$ h*$^ha$gd#$ & F *$a$gdc "6ABETtxy~klm{|}ſ||h%4@CJhO@CJh5@CJ hmCJ hX_CJ h`CJ hKnCJ h. CJ h-mCJ hCJ h7 CJh5>*CJhCJmH sH h!TBCJmH sH h"CJmH sH hU CJmH sH h1|CJmH sH ,78 "sgXgXIX:XIXhhE@CJmH sH hhE@CJmHsHhEhE@CJmHsHhE@CJmHsHh@CJmH sH hmH sH h"XXh@CJmHsHh"XXhl6@CJmHsHhl6hl6@CJmHsHh"XX@CJmHsHh"XXh"XX@CJmHsHh _@CJh _h _@CJhE@CJhOhO@CJh%4h%4@CJ"45HI:b $ & F a$gd7  & F gd7  & F gdX$ & F 0*$a$gdLbC$ & F 0*$a$gdEgd= $ 0*$a$$ & F 0*$a$gdl6$ & F 0*$a$gd"XX"&(*2:@FRT\z|345GHI_`løq_qN hXhX@CJaJmH sH #jhX@CJUaJmH sH hX@CJaJmH sH &hjh5>*@CJaJmH sH hjhaJmH sH hmH sH h'Hah5>*@CJaJh h#r@CJh @CJh hq,@CJh @CJmH sH hEhE@CJmHsHhhE@CJmHsH9:UVb򿮝ueTF4F#jhK H@CJUaJmH sH hK H@CJaJmH sH  hzKh*CJmH sH hmH sH hmH sH  h*CJmH sH hmH sH h=mH sH h7 CJmH sH hCJmH sH hX_CJmH sH %%%%%&& ' '''''jj$ `0I`d *$^``a$gdX_$ `0Id *$a$gdX_$ & F `0Id *$a$gdX_$ `0IId *$^I`a$gdX_gd=$ `0IId *$^I`a$ z&&&&&&&&&&&&&''' ' '''+'h'scSD8h?X@CJmH sH h?Xh?X@CJmH sH h|Nh5@CJmH sH h|Nh?X5@CJmH sH h\hX_@CJmH sH h@CJmH sH hm@CJmH sH h\@CJmH sH h\h\@CJmH sH hGxH@CJmH sH h1Ih@CJmH sH hX<@CJmH sH h|N@CJmH sH h1I@CJmH sH h!TB@CJmH sH h'j'm'n'y'''''''''' (.(O(P(f(t(u(v(((((((tܩdXLhaf@CJmH sH h.84@CJmH sH hch.5@CJmH sH hGxH@CJmH sH hch?X5@CJmH sH hU 5@CJmH sH h@CJmH sH hE@CJmH sH h\@CJmH sH h?Xh?X@CJmH sH h(6@CJmH sH h?X@CJmH sH h.@CJmH sH h|N@CJmH sH ''P(u(v(()?)@)P)****m+++$ `0Id *$`a$gdX_$ `0I`d *$^``a$gdX_$ `0Id *$a$gdX_$ & F `0Id *$a$gdX_((()))?)@)O)P)m))))**$*8*9*R*p*********跨ААМxl]PhzL%5@CJmH sH h|NhX_@CJmH sH h`@CJmH sH hE@CJmH sH h.84@CJmH sH h@CJmH sH hzL%@CJmH sH hch@CJmH sH h?X5@CJmH sH hGxH@CJmH sH h(6@CJmH sH hc@CJmH sH h.@CJmH sH h7 @CJmH sH ****++l+m+x+y++++++++ ,,,/,R,,,,,,,¶’ڪvfZNZªh-m@CJmH sH h7 @CJmH sH h(6h(65@CJmH sH hE@CJmH sH hzL%hzL%5@CJmH sH h=@CJmH sH hGxH@CJmH sH h`@CJmH sH h@CJmH sH h(6@CJmH sH hG@CJmH sH hzL%@CJmH sH h|N@CJmH sH h|N5@CJmH sH +++,,/,,,,-d-m-n---I.q.r...=/V/W/ $d a$gdX_$ `0Id *$a$gdX_$ & F `0Id *$a$gdX_,,,,,-1-K-L-c-d-f-k-l-m-n------дvfVH=Hh"XX5CJmH sH h Ih I5CJmH sH h&hh5@CJmH sH hU h-m5@CJmH sH h/ h$@CJmHsHh$@CJmH sH h-m@CJmH sH h/ @CJmH sH h/ h/ @CJh>:@CJmH sH h1h15@CJmH sH h1@CJmH sH hGxH@CJmH sH h`@CJmH sH hX_@CJmH sH ----..0.1.I.J.K.L.T.d.f.p.q.r......=/@/H/K/M/T/U/V/W/`/j//000;0<0ճ˔zoeeh.|"CJmH sH h5CJmH sH  hXCJhXCJmHsHh#CJmH sH hl6CJmH sH hXCJmH sH hZ5CJmH sH h Ih I5CJmH sH h ICJmH sH hX_CJmH sH h"XXCJmH sH h2CJmH sH h Ih ICJmH sH h&'CJmH sH 'W//0g01>1?1Y112p2222222222 $$Ifa$gdX< $Ifgd( $$Ifa$gd(gd=$a$ $d a$gdX_<0R000111 111"1=1>1?1D1X1Y1]2^2x222222222222222˳Պ}ph`h`XhmH sH h`mH sH h1|mH sH h1|5>*CJmH sH h Ih&'CJmH sH h&'CJmH sH h$ CJmH sH h2CJmH sH hZ5CJmH sH h Ih I5CJmH sH h+[CJmH sH h.|"CJmH sH h1|CJmH sH hl6CJmH sH h Ih ICJmH sH h ICJmH sH !222222222 333 3!3-3@3H3I3J3K3L3O3P3]3^3_3`3a3c3ͶuukaWJah/ h1CJmHsHh/ CJmHsHhcCJmH sH h+[CJmH sH hzL%@CJmH sH hX<@CJmH sH hU h1@CJmH sH hU h1CJmH sH h15@CJmH sH h1CJmH sH hX<5CJaJmH sH hX<h15CJaJmH sH h(5CJmH sH h1h15CJmH sH hCJmH sH 22 3_V $$Ifa$kd$$Ifl4\7"%7n0%4 lalf4ytX< 333I3K3M3y $$Ifa$gdU $$Ifa$gdzL% $$Ifa$gdX<akd$$Ifl%%0%4 lalytX<M3N3P3^3`3b3dXOCX $$Ifa$gdU $$Ifa$ $$Ifa$gdX<kd8$$Ifl\7"%7n0%4 lalytX<b3c3e3r3t3v3dXOCX $$Ifa$gdU $$Ifa$ $$Ifa$gdX<kd$$Ifl\7"%7n0%4 lalytX<c3e3q3r3s3t3u3v3w3y333333333333333333333333333Ǿ䮥Ǿ󛴑{qgZ{ghU hzL%CJmH sH hzL%CJmH sH hu1CJmH sH hzL%@CJmH sH hXCJmH sH hcCJmH sH h/ CJmH sH hX<h1CJ hzL%CJh1CJmH sH hch1CJ hcCJh/ h1CJmHsHh/ CJmHsHhU h1@CJmH sH hU h1CJmH sH #v3w3y3333dX?3X $$Ifa$gdU $ `0I$*$Ifa$gdX< $$Ifa$gdX<kd$$Ifl\7"%7n0%4 lalytX<333333bVMA5 $$Ifa$gdX $$Ifa$gdU $$Ifa$ $$Ifa$gdX<kd3$$Ifl\7"%7n0%4 lalytX<333333dXOCX $$Ifa$gdU $$Ifa$ $$Ifa$gdX<kd$$Ifl\7"%7n0%4 lalytX<333333dXOCX $$Ifa$gdU $$Ifa$ $$Ifa$gdX<kd$$Ifl\7"%7n0%4 lalytX<33334444 4 4 4 4748494:4;4=4T4U4V4j4k4l4m4o4p4q4444444444444ƹߙЏwwoewwh-5CJmH sH h1mH sH hXCJmH sH h1h15CJmH sH hX<CJmH sH h1@CJmH sH h1CJmH sH hcCJmH sH h/ h1CJmHsHh/ CJmHsHhU h1@CJmH sH hU h1CJmH sH hzL%CJmH sH h1|CJmH sH '33344 4dXOC7 $$Ifa$gdc $$Ifa$gdU $$Ifa$ $$Ifa$gdX<kd2$$Ifl\7"%7n0%4 lalytX< 4 4 484:4<4dXOCX $$Ifa$gdU $$Ifa$ $$Ifa$gdX<kd$$Ifl\7"%7n0%4 lalytX<<4=4T4d[ $$Ifa$kd$$Ifl\7"%7n0%4 lalytX<T4U4W4j4l4n4 $$Ifa$gd1 $$Ifa$gdX<akd-$$Ifl%%0%4 lalytX<n4o4q4444dXRXX$If $$Ifa$gdX<kd$$Ifl\7"%7n0%4 lalytX<444444dXOXX $$Ifa$ $$Ifa$gdX<kdU$$Ifl\7"%7n0%4 lalytX<444444dXOXX $$Ifa$ $$Ifa$gdX<kd$$Ifl\7"%7n0%4 lalytX<4444444444444444 5 5 5!5"5+5,5:5d5e555555}66¼۸uj_j_j_jjThLbChZCJaJhLbCh<CJaJhLbChu1CJaJhLbChu15CJaJhLbChLbCCJaJhLbCh<5CJaJhZhZ5>*CJaJh6 hZhZ hZh<h h1|CJh.^Yh1CJ h ICJh1h15CJ h1CJ h-5CJh|h1CJ hX<CJh1CJmH sH  444444d[[OO $$Ifa$gdX< $$Ifa$kd $$Ifl\7"%7n0%4 lalytX<444 5 5555dWRW@@@$ 0$*$Ifa$gdLbCgd= $ 0*$a$gd#kdP $$Ifl\7"%7n0%4 lalytX<5!5"5+56$$ 0$*$Ifa$gdmkd $$Ifl\.I -L&  t0644 lap(ytLbC$ 0$*$Ifa$gdLbC+5,5.5:5e55~~~~$ 0$*$Ifa$gdLbCnkd $$IflL&& t0644 lap ytLbC555555H6666$ 0$*$Ifa$gdLbCkdE $$Ifl\.I -L&  t0644 lap(ytLbC555566H6666$ 0$*$Ifa$gdLbCkd $$Ifl\.I -L&  t0644 lap(ytLbC6 6"606O6P6H6666$ 0$*$Ifa$gdLbCkd $$Ifl\.I -L&  t0644 lap(ytLbCP6Q6S6`666H6666$ 0$*$Ifa$gdLbCkd$$Ifl\.I -L&  t0644 lap(ytLbC666666H6666$ 0$*$Ifa$gdLbCkdm$$Ifl\.I -L&  t0644 lap(ytLbC666y77777777777,-Bٴڴ12cmnopqstvwyz|꺯yhUX5CJOJQJhm0JmHnHu hUX0JjhUX0JUhUXh4jh4UhZh<CJaJhLbChLbCCJaJhLbChZ6CJaJUhLbChq,CJaJhLbChu15CJaJhLbChZCJaJhLbChu1CJaJ.66667H7H6666$ 0$*$Ifa$gdLbCkd7$$Ifl\.I -L&  t0644 lap(ytLbCH7I7K7Y7w7x7H6666$ 0$*$Ifa$gdLbCkd$$Ifl\.I -L&  t0644 lap(ytLbCx7y77H6$ 0$*$Ifa$gdmkd$$Ifl\.I -L&  t0644 lap(ytLbC777777~~~~$ 0$*$Ifa$gdLbCnkd$$IflL&& t0644 lap ytLbC777777H6666$ 0$*$Ifa$gdLbCkd$$Ifl\.I -L&  t0644 lap(ytLbC7777-BCH66666$ 0$*$Ifa$gdLbCkd$$Ifl\.I -L&  t0644 lap(ytLbCPython for data analysis and visualization. Project presentation423/11 29/11Mid-term test (1.5h). Excel: Functions.HW6: Excel functions530/11 6/12Excel: Data visualizationHW7: Excel data visualization67/12 13/12Excel: processing large series of dataHW8: Excel: large series of data714/12 20/12Excel: Add-ins821/12 27/12Exam week      PAGE 6 CDFT|H6666$ 0$*$Ifa$gdLbCkd$$Ifl\.I -L&  t0644 lap(ytLbCٴH6666$ 0$*$Ifa$gdLbCkdu$$Ifl\.I -L&  t0644 lap(ytLbCٴڴܴ1H6666$ 0$*$Ifa$gdLbCkd?$$Ifl\.I -L&  t0644 lap(ytLbC124BQRH6666$ 0$*$Ifa$gdLbCkd $$Ifl\.I -L&  t0644 lap(ytLbCRSUcmnH6666$ 0$*$Ifa$gdLbCkd$$Ifl\.I -L&  t0644 lap(ytLbCnoprsuvH;9999 $ 0*$a$gd`kd$$Ifl\.I -L&  t0644 lap(ytLbCvxy{|}~ $ 0*$a$gd`$a$ ,&P . A!"#n$n%S $$Ifl!vh#v7#v#vn#v:V l40%,5755n54alf4ytX<}$$Ifl!vh#v%:V l0%5%4alytX<$$Ifl!vh#v7#v#vn#v:V l0%5755n54alytX<$$Ifl!vh#v7#v#vn#v:V l0%5755n54alytX<$$Ifl!vh#v7#v#vn#v:V l0%5755n54alytX<$$Ifl!vh#v7#v#vn#v:V l0%5755n54alytX<$$Ifl!vh#v7#v#vn#v:V l0%5755n54alytX<$$Ifl!vh#v7#v#vn#v:V l0%5755n54alytX<$$Ifl!vh#v7#v#vn#v:V l0%5755n54alytX<$$Ifl!vh#v7#v#vn#v:V l0%5755n54alytX<$$Ifl!vh#v7#v#vn#v:V l0%5755n54alytX<}$$Ifl!vh#v%:V l0%5%4alytX<$$Ifl!vh#v7#v#vn#v:V l0%5755n54alytX<$$Ifl!vh#v7#v#vn#v:V l0%5755n54alytX<$$Ifl!vh#v7#v#vn#v:V l0%5755n54alytX<$$Ifl!vh#v7#v#vn#v:V l0%5755n54alytX<$$Ifl!vh#v7#v#vn#v:V l0%5755n54alytX<$$If!vh#v#v#v #v :V l t06555 5 p(ytLbC$$If!vh#v&:V l t065&p ytLbC$$If!vh#v#v#v #v :V l t06555 5 p(ytLbC$$If!vh#v#v#v #v :V l t06555 5 p(ytLbC$$If!vh#v#v#v #v :V l t06555 5 p(ytLbC$$If!vh#v#v#v #v :V l t06555 5 p(ytLbC$$If!vh#v#v#v #v :V l t06555 5 p(ytLbC$$If!vh#v#v#v #v :V l t06555 5 p(ytLbC$$If!vh#v#v#v #v :V l t06555 5 p(ytLbC$$If!vh#v#v#v #v :V l t06555 5 p(ytLbC$$If!vh#v&:V l t065&p ytLbC$$If!vh#v#v#v #v :V l t06555 5 p(ytLbC$$If!vh#v#v#v #v :V l t06555 5 p(ytLbC$$If!vh#v#v#v #v :V l t06555 5 p(ytLbC$$If!vh#v#v#v #v :V l t06555 5 p(ytLbC$$If!vh#v#v#v #v :V l t06555 5 p(ytLbC$$If!vh#v#v#v #v :V l t06555 5 p(ytLbC$$If!vh#v#v#v #v :V l t06555 5 p(ytLbC$$If!vh#v#v#v #v :V l t06555 5 p(ytLbC!s2 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@_HmHnHsHtH:`: 1KG=K9_HmH sH tH F@F = 03>;>2>: 1$*$@&a$5CJJ@J = 03>;>2>: 2 *$@& 5>*CJrr  03>;>2>: 35$$ `00d*$@&^`0a$ 5@CJvv  03>;>2>: 49$$ `00d,l*$@&^`0a$ 5@CJrr  03>;>2>: 5+$$ `0' Y*$@&a$6@CJmH sH uff  03>;>2>: 6$$ d8*$@&a$5@CJmH sH u<<  03>;>2>: 7$@&5@@  03>;>2>: 8$@&5CJB B  03>;>2>: 9 $$@&a$CJBA`B A=>2=>9 H@8DB 0170F0\i@\ 1KG=0O B01;8F0 :V 44 la .k . 5B A?8A:0 L@L 5@E=89 :>;>=B8BC;  !J @J 86=89 :>;>=B8BC;  !4)@4 ><5@ AB@0=8FKLB@"L A=>2=>9 B5:AB@CJmH sH uC2 A=>2=>9 B5:AB A >BABC?><,$ `0d *$^`a$@CJmH sH ujP@Bj A=>2=>9 B5:AB 2$ `0d *$a$@CJmH sH udRRd A=>2=>9 B5:AB A >BABC?>< 2$^a$CJ.Zb. "5:ABOJQJFQrF A=>2=>9 B5:AB 3$a$CJ4U`4 8?5@AAK;:0>*B*PV P @>A<>B@5==0O 38?5@AAK;:0>*B* JJ 'Ha "5:AB 2K=>A:8CJOJQJ^JaJ>' > c=0: ?@8<5G0=8OCJaJ<< c"5:AB ?@8<5G0=8OBB c"5:AB ?@8<5G0=8O =0:@j@ c"5<0 ?@8<5G0=8O5\F/F c"5<0 ?@8<5G0=8O =0:5\pp < !5B:0 B01;8FK7:V 0 PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭VM]D.L=d{}|[E\ ~<ژQqfU?spL٤{f_XuJS4S.OUo9Vj\4/ 5|@ x yRxJ5|l{U@!%Wbd+{ji|jȪMN1b8nEK` )$vlGh J\" qbaP*t e+=u"60Ҭ%O`׆$?2 CjWO|sx_<8sȰn~t7/~asOs;V /xOLжs2sB`2ɛYCDtf<(Fr Ȃka37A&SA,/bXbE94'O:BL'2A*E@ccƖ$Ĉ$pn5$}mT /3AȷNQ۪xD]|S#T沏"do t\ Sts͕֫%"ȋ=[tDK1f;A #qc?;Pȹʄ ;D~b‘Xl=DTh{v훐&3I-$A$ AP+{+,5~5@- l؀5\0',DP)M"*o3GӨW,*`zR;F Z$TdTO!yux\ח)5P4cq\ݪ6XW ;{ RdhpG. [`Dm ?L.ڈijgiŭXA8 +$L2@iFdӏVXU'KK6tឳM5%W2CmP1LȖҘ沫oT5#: Ѽb•gtԧ,ڧ!ZHp{,Tf]#pd}&˞iv3fXXk!M;|*ݫ[_h>!,~{Q[NfPeXj|qەe=: jhTVG%Q۾цS*J%L$6D='Ienb~k3MHýS^P\wr^+j~k~vttkځMxvf X/ h cw 7"#z&h'(*,-<02c3346 "#%&')*+-.013467<AIS%'+W/2 3M3b3v33333 4<4T4n444445+5556P666H7x7777Cٴ1Rnv!$(,/2589:;=>?@BCDEFGHJKLMNOPQRTUVWXY[\]^_`aR ;1h<{D&QcIa+y4dX/XXXXXXXXXXXX!8@0(  B S  ? _Hlt425796370 _Hlt425796371Y/@@Y/HHJ J Y/Q Q Y/8*urn:schemas-microsoft-com:office:smarttagsCity9*urn:schemas-microsoft-com:office:smarttagsplace mtCG!SXQ Y (","$$m't'''[,c,;/=/>/@/A/C/D/F/G/V/Y/*9 A 1 ? xy~.EI0 3 5.;.;/=/>/@/A/C/D/F/G/V/Y/33333333333333333333 },C%i'SK ,hM p I!i!k!}!!!s""""""(#?#@#J###%3%%%\&}&&'$'5'''W(s(%)@)A))))*M*`*g********+3+A+x+z++++<,t,,%-5-U---5.G.\.].....9/;/=/>/@/A/C/D/F/G/V/Y/`a445i *+4 " {++;1={DRc4 i!j!k!k!""""""##'$($A$B$%%&&&&''v(w((((((())H*I*b*c*********w+x+++\.].....9/:/;/;/=/>/>/@/A/C/D/F/G/V/Y/\dm* jޠd$#Jm,2,zvY4F  -'L `?jTP@^ztd` ?v 8RwxTT)}|hh^h`o(. hh^h`o(-\^`\5o(hh^h`5o( 0^`05o(hh^h`o(.hh^h`o(.hh^h`5o(k^`ko(.\^`\5o(hh^h`o(.hh^h`o(.\^`\5o( M^`Mo(m,@^ jTT)}8Rwx -'L$#?jTm2,?vY4Fd`\>: KVk#7n' $ U 7 ^jXc1qOJklN. mL= IldF"q,C5)#I`s!.|"K#zL%u&&'>(,-..-0u12D3*4.84l6(6q6b7+;k?!TBLbC"FBFK HGxH1IOJPtUSWSU?XTXUX"XX!`X.^Y6Z+[v[N]o] _X_e_4a'HaSdaf&h|j. k:lazl-m\n#rTDt;uvxk~2V |vr)dXm.rKr1E!-)?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abdefghijklmnoqrstuvwxyz{|}~Root Entry FnData cg1Tablep=:WordDocument.SummaryInformation(DocumentSummaryInformation8CompObjr  F Microsoft Word 97-2003 MSWordDocWord.Document.89q