Title: Tantárgyleírás
Author: groma
Company: PPKE JÁK

Course description
IT for economics

Optional course related to topics specifically grouped under „International Economics”

Code of the subject: JOIT405xA0
Complete designation (abridged): IT for economics
Intefration within the sample curriculum: third semester and onwards
Number of lectures per week: 2 classes
Method of assessment: reporting
Credit points: 2 
Language of training: Hungarian
Professor in charge/Lecturer: GROMA Sarolt
Prior obligatory lectures: -  
Parallel obligatory lectures: -  

Course objectives: 
In order to acquire general knowledge, ability in understanding and planning economics, it is indispensable to gain skills about the array of possible ways in managing and analyzing vast amounts of data. As of our century, these methods have exclusively encompassed and been performed by PC-based processing. Our aim is to provide an insight into various methods for bulk data handling and to disseminate knowledge and skills about the constituents of such data handling. We also target familiarizing certain software applications at user level competence, practical application of basic statistical and analyzing devices. Students should be able to analyze and break down to constituents the most frequent problems of business, data handling, processing a.s.o. Relevant logical relations, methods ands solutions, algorithms are to be set up, tested and the results should be interpreted by spreadsheets and applications as skills acquired in this course.

Contents of the course: 

Week 1: Basics of data management: databases, check lists, data management basic principles, bulk data spreadsheet
Week 2: Data types, converting different types of data, data formatting and masking, calculations performed in the spreadsheet, operations, designation of cells
Week 3: Use of functions, references, error-handling, function types, certain elementary functions
Week 4: Application of functions: I. : textual functions, date and time functions, mathematical functions
Week 5: Elementary logics, logical functions, applications of functions, II.: logical functions
Week 6: Application of functions: III., statistical functions, financial functions, (NPV, IRR calculation), error calculation 
Week 7: test
Week 8: Application of data lists: How to create data lists, importing data, exporting these, generating random data, derived and calculated columns, handling missing values, shared use of multiple spreadsheets, search functions, 
Week 9: Use of data lists II., rendering and screening these (auto and directed, criteria tables) partial aggregate function, functions of database management
Week 10: reporting, report wizard
Compiling diagrams I: overview on diagrams, drafting diagrams
Week 11: compiling diagrams II.
Week 12: Descriptive statistics, basic concepts in statistics, calculating mean, calculating range and deviation, distribution rate 
Week 13: Application I: Calculating actual cases
Week 14: test

Teaching material: 
Ms Excel latest version
Ms Access latest version
SPSS statistical software