|
| Course Description |
|
| Course Name |
: |
Introduction To Computers II |
|
| Course Code |
: |
EA 204 |
|
| Course Type |
: |
Compulsory |
|
| Level of Course |
: |
First Cycle |
|
| Year of Study |
: |
2 |
|
| Course Semester |
: |
Spring (16 Weeks) |
|
| ECTS |
: |
4 |
|
| Name of Lecturer(s) |
: |
Asst.Prof.Dr. SEMİN PAKSOY
|
|
| Learning Outcomes of the Course |
: |
With Microsoft Excel to perform data management functions.
Carry out basic statistical analysis with Excel
Microsoft Access to create and edit forms with
Prepare presentations with Microsoft Powerpoint
|
|
| Mode of Delivery |
: |
Face-to-Face |
|
| Prerequisites and Co-Prerequisites |
: |
None |
|
| Recommended Optional Programme Components |
: |
None |
|
| Aim(s) of Course |
: |
informs students abaout Microsoft Excel, Access and PowerPoint programs and data management, visualization, and database management. |
|
| Course Contents |
: |
Use of the content of the course is located in the Office programs. |
|
| Language of Instruction |
: |
Turkish |
|
| Work Place |
: |
Classroom |
|
|
Course Outline /Schedule (Weekly) Planned Learning Activities |
| Week | Subject | Student's Preliminary Work | Learning Activities and Teaching Methods |
|
1 |
Creating a Work Sheet |
work at home |
interactive Presentation |
|
2 |
Working with Data and Data Tables |
work at home |
interactive Presentation |
|
3 |
Verilere Formül Uygulanması |
work at home |
interactive Presentation |
|
4 |
filtering |
work at home |
interactive Presentation |
|
5 |
Reorganization and summarizing data |
work at home |
interactive Presentation |
|
6 |
To combine data from different sources |
work at home |
interactive Presentation |
|
7 |
Analysis of Alternative Data Sets |
work at home |
interactive Presentation |
|
8 |
Midterm exam |
work at home |
20 Pcs Multiple Choice Question |
|
9 |
Basic Statistical Analysis with Microsoft Excel |
work at home |
interactive Presentation |
|
10 |
Basic Statistical Analysis with Microsoft Excel II |
work at home |
interactive Presentation |
|
11 |
Creating and Using Microsoft Access Form |
work at home |
interactive Presentation |
|
12 |
Working with Form Controls |
work at home |
interactive Presentation |
|
13 |
Editing forms |
work at home |
interactive Presentation |
|
14 |
Microsoft Access: Examples |
work at home |
interactive Presentation |
|
15 |
Basic Microsoft Powerpoint: Presentation Preparation and Editing |
work at home |
interactive Presentation |
|
16/17 |
Final Exam |
work at home |
20 Pcs Multiple Choice Question |
|
|
|
Required Course Resources |
| Resource Type | Resource Name |
| Recommended Course Material(s) |
 Microsoft Corporation (2003), Microsoft Office 2003 Product Guide, New York: Microsoft Corporation.
|
| |
| Required Course Material(s) | |
|
|
|
Assessment Methods and Assessment Criteria |
|
Semester/Year Assessments |
Number |
Contribution Percentage |
|
Mid-term Exams (Written, Oral, etc.) |
1 |
60 |
|
Homeworks/Projects/Others |
0 |
40 |
|
Total |
100 |
|
Rate of Semester/Year Assessments to Success |
40 |
| |
|
Final Assessments
|
100 |
|
Rate of Final Assessments to Success
|
60 |
|
Total |
100 |
|
|
| Contribution of the Course to Key Learning Outcomes |
| # | Key Learning Outcome | Contribution* |
|
1 |
uses modern communication tools, methods and processes, collects and interprets data from different sources using |
4 |
|
2 |
understands and explains the role of the public and private sector in the economy, the market economy and the function of the public sector |
1 |
|
3 |
uses the information of profesional field about basic computer knowledge and skills |
5 |
|
4 |
Collect quantitative and statistical data, makes analysis and interpretation |
4 |
|
5 |
understands and interprets corecctly the feelenings, thoughts and behaviors of other people, express Themselves in written and oral form. |
3 |
|
6 |
Aware of the social, scientific and ethical values ??and acts accordingly |
3 |
|
7 |
Questions the traditional approach and methods of application,and he to develops and implements new ways of working if he considers it is necesaary |
3 |
|
8 |
Individually and / or in a team, take responsibility, leadership, and effectively works |
4 |
|
9 |
In recognition of the need for lifelong learning and constantly renews itself keeps track of the latest developments. |
4 |
|
10 |
|
3 |
|
11 |
UseTurkish in academic life and work in accordance with the requirements of the uses of life. |
4 |
|
12 |
Use different resources in accordance with the academic rules, synthesize the information gathered, and present them effectively in an area which has not been studied |
1 |
|
13 |
Use Turkish and at least one foreign language in accordance with the prerequisities of academic and business context |
2 |
|
14 |
Develop scientific and ethical values in the fields of statistics-and scientific data collection |
4 |
| * Contribution levels are between 0 (not) and 5 (maximum). |
|
|
| Student Workload - ECTS |
| Works | Number | Time (Hour) | Total Workload (Hour) |
| Course Related Works |
|
Class Time (Exam weeks are excluded) |
14 |
3 |
42 |
|
Out of Class Study (Preliminary Work, Practice) |
14 |
3 |
42 |
| Assesment Related Works |
|
Homeworks, Projects, Others |
0 |
0 |
0 |
|
Mid-term Exams (Written, Oral, etc.) |
1 |
10 |
10 |
|
Final Exam |
1 |
10 |
10 |
|
Total Workload: | 104 |
| Total Workload / 25 (h): | 4.16 |
| ECTS Credit: | 4 |
|
|
|