ECO231 Computer Applications I

Course Name

Code

Semester

Theory
(hours/week)

Application(hours/week)

Laboratory(hours/week)

National
Credit
 

ECTS

 

ECO231

Autumn

3

 

3

3

3

Perquisites’

--

Course language

English

Course type

Required

Mode of Delivery

 

Learning and teaching strategies

Lecture, Drill and Practice, Homework

Instructor (s)

Nilgün Çokça

Course objective

The aim of this course is to teach to use different type of statistic, economic and econometrics applications.

Learning outcomes

At the end of the lesson, the students will ;

  • solve statistical and economic problems on applications.

Course Content

  • Mathematical Functions and Formulas

  • Matrix

  • Linear Equations and Their Solution

  • Pivot Tables, Statistical and Logical Functions

  • IF and VLOOKUP Functions

  • Economic Functions and Analysis

  • R Basics

  • Why R, and R Paradigm

  • References, Tutorials and links

  • R Overview

  • R Interface

  • R Workspace

  • Help

  • R Packages

  • Input/Output

  • Reusing Results

  • Data Input

  • Data Types

  • Importing Data

  • Keyboard Input

  • Database Input

  • Exporting Data

  • Viewing Data

  • Variable Labels

  • Value Labels

  • Missing Data

  • Date Values

  • Data Manipulation

  • Creating New Variable

  • Operators

  • Built-in functions

  • Control Structures

  • User Defined Functions

  • Sorting Data

  • Merging Data

  • Aggregating Data

  • Reshaping Data

  • Sub-setting Data

  • Data Type Conversions

References

Ders Notları 2. Bölüm, Nilgün Çokça, 2012

Windows 7 Inside Out, Ed Bott, Carl Siechert, Craig Stinson, Microsoft Press, 2010

Exploring Microsoft Office Excel 2010 Comprehensive (Custom Phit: The Pearson Custom Program for Cis) by Robert Grauer, Mary Anne Poatsy, Keith Mulbery and Lynn Hogan (Nov 22, 2010)

Using Excel for Undergraduate Econometrics, R. Carter Hill-William E.Griffiths-George G. Judge

Computing Skills for Economists, Guy Judge,

The R Book, Michael J. Crawley, Wiley, 2007

Practical Regression and Anova using R, Julian J. Faraway, December 2000