Course Detail
Course Description
Course | Code | Semester | T+P (Hour) | Credit | ECTS |
---|---|---|---|---|---|
INFORMATION TECHNOLOGY | - | Spring Semester | 2+0 | 2 | 5 |
Course Program |
Prerequisites Courses | |
Recommended Elective Courses |
Language of Course | English |
Course Level | First Cycle (Bachelor's Degree) |
Course Type | Required |
Course Coordinator | Assist.Prof. Recep ÖZSÜRÜNÇ |
Name of Lecturer(s) | Assoc.Prof. Özge DOĞUÇ |
Assistant(s) | |
Aim | To teach student fundamentals of hardware, operating systems, office programs and especially spreadsheet program (excel) in order to have them ability to use them for management and operational levels. |
Course Content | This course contains; History of Computer and Introduction to Office Programs,Creating a Worksheet and Charting Data in Excel,Creating a Worksheet and Charting Data in Excel,Creating a Worksheet and Charting Data in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Creating Documents with Microsoft Word,Creating Documents with Microsoft Word,Creating Cover Letters and Using Tables to Create Resumes,Creating Cover Letters and Using Tables to Create Resumes,Getting Started with Microsoft PowerPoint,Getting Started with Microsoft PowerPoint,Formatting PowerPoint Presentations. |
Dersin Öğrenme Kazanımları | Teaching Methods | Assessment Methods |
5.Will be able to use presentation programs. | 12, 14, 16, 4, 6, 9 | A, E, G |
1. will be able to explains the basic concepts of information technology. | 16, 9 | A, E |
1.1 Explains the general concepts. | ||
1.2 Displays hardware components. | ||
1.3 Explains the concept of software, examples of software types. | ||
2. Will be able to apply computer usage and file management. | 16, 8, 9 | A, E |
2.1 Turns on the computer device. | ||
2.2 Explains the concept of the desktop. | ||
2.3 Describes how to perform file management. | ||
3. Will be able to express how the word processor program is used. | 12, 14, 16, 9 | A, E, G |
3.1. Describes usage of the application. | ||
3.2. Explains Basic Operations. | ||
3.3. Explains formatting methods. | ||
4. Will be able to use a spreadsheet program. | 12, 14, 16, 4, 9 | A, E, G |
4.1. Describes the usage of the application. | ||
4.2. Explains cell concept. | ||
4.3. Describes the concept of the worksheet. | ||
4.4. Uses Formulas and Functions. | ||
4.5. Describes the types of formatting. | ||
4.6. Describes the use of graphics. | ||
5.1. Describes usage of the application. | ||
5.2. Describes creating a presentation. | ||
5.3. opens Text and Views . | ||
5.4. applies the use of Graphics and Drawing Objects (Auto Shape). | ||
5.5. Uses Screen Display Effects. |
Teaching Methods: | 12: Problem Solving Method, 14: Self Study Method, 16: Question - Answer Technique, 4: Inquiry-Based Learning, 6: Experiential Learning, 8: Flipped Classroom Learning, 9: Lecture Method |
Assessment Methods: | A: Traditional Written Exam, E: Homework, G: Quiz |
Course Outline
Order | Subjects | Preliminary Work |
---|---|---|
1 | History of Computer and Introduction to Office Programs | Related chapter in the course book should be read. |
2 | Creating a Worksheet and Charting Data in Excel | Related chapter in the course book should be read. |
3 | Creating a Worksheet and Charting Data in Excel | Related chapter in the course book should be read. |
4 | Creating a Worksheet and Charting Data in Excel | Related chapter in the course book should be read. |
5 | Using Functions, Creating Tables, and Managing Large Workbooks in Excel | Related chapter in the course book should be read. |
6 | Using Functions, Creating Tables, and Managing Large Workbooks in Excel | Related chapter in the course book should be read. |
7 | Using Functions, Creating Tables, and Managing Large Workbooks in Excel | Related chapter in the course book should be read. |
8 | Creating Documents with Microsoft Word | Related chapter in the course book should be read. |
9 | Creating Documents with Microsoft Word | Related chapter in the course book should be read. |
10 | Creating Cover Letters and Using Tables to Create Resumes | Related chapter in the course book should be read. |
11 | Creating Cover Letters and Using Tables to Create Resumes | Related chapter in the course book should be read. |
12 | Getting Started with Microsoft PowerPoint | Related chapter in the course book should be read. |
13 | Getting Started with Microsoft PowerPoint | Related chapter in the course book should be read. |
14 | Formatting PowerPoint Presentations | Related chapter in the course book should be read. |
Resources |
Evans, A., Martin, K., & Poatsy, M. A. (2018). Technology in Action Introductory. Pearson. |
Jelen, B. (2021). Microsoft Excel Inside Out (Office 2021 and Microsoft 365). Microsoft Press. Pearson MyLab Platform |
Course Contribution to Program Qualifications
Course Contribution to Program Qualifications | |||||||
No | Program Qualification | Contribution Level | |||||
1 | 2 | 3 | 4 | 5 | |||
1 | Defines the theoretical issues in the field of information and management. | X | |||||
2 | Describes the necessary mathematical and statistical methods in the field of information and management. | ||||||
3 | Uses at least one computer program in the field of information and management. | X | |||||
4 | Sustains proficiency in a foreign language requiredor information and management studies. | ||||||
5 | Prepares informatics/software projects and work in a team. | ||||||
6 | Constantly updates himself / herself by following developments in science and technology with an understanding of the importance of lifelong learning through critically evaluating the knowledge and skills that s/he has got.7. Uses theoretical and practical expertise in the field of information and management | X | |||||
7 | Follows up-to-date technology using a foreign language at least A1 level, holds verbal / written communication skills. | ||||||
8 | Follows up-to-date technology using a foreign language at least A1 level, holds verbal / written communication. | ||||||
9 | Adopts organizational / institutional and social ethical values. | ||||||
10 | Within the framework of community involvement adopts social responsibility principles and takes initiative when necessary. | ||||||
11 | Uses and analyses basic facts and data in various disciplines (economics, finance, sociology, law, business) in order to conduct interdisciplinary studies. | ||||||
12 | Writes software in different platforms such as desktop, mobile, web on its own and / or in a team. |
Assessment Methods
Contribution Level | Absolute Evaluation | |
Rate of Midterm Exam to Success | 40 | |
Rate of Final Exam to Success | 60 | |
Total | 100 |
ECTS / Workload Table | ||||||
Activities | Number of | Duration(Hour) | Total Workload(Hour) | |||
Course Hours | 14 | 2 | 28 | |||
Guided Problem Solving | 3 | 7 | 21 | |||
Resolution of Homework Problems and Submission as a Report | 2 | 16 | 32 | |||
Term Project | 0 | 0 | 0 | |||
Presentation of Project / Seminar | 7 | 5 | 35 | |||
Quiz | 1 | 3 | 3 | |||
Midterm Exam | 1 | 7 | 7 | |||
General Exam | 1 | 14 | 14 | |||
Performance Task, Maintenance Plan | 0 | 0 | 0 | |||
Total Workload(Hour) | 140 | |||||
Dersin AKTS Kredisi = Toplam İş Yükü (Saat)/30*=(140/30) | 5 | |||||
ECTS of the course: 30 hours of work is counted as 1 ECTS credit. |
Detail Informations of the Course
Course Description
Course | Code | Semester | T+P (Hour) | Credit | ECTS |
---|---|---|---|---|---|
INFORMATION TECHNOLOGY | - | Spring Semester | 2+0 | 2 | 5 |
Course Program |
Prerequisites Courses | |
Recommended Elective Courses |
Language of Course | English |
Course Level | First Cycle (Bachelor's Degree) |
Course Type | Required |
Course Coordinator | Assist.Prof. Recep ÖZSÜRÜNÇ |
Name of Lecturer(s) | Assoc.Prof. Özge DOĞUÇ |
Assistant(s) | |
Aim | To teach student fundamentals of hardware, operating systems, office programs and especially spreadsheet program (excel) in order to have them ability to use them for management and operational levels. |
Course Content | This course contains; History of Computer and Introduction to Office Programs,Creating a Worksheet and Charting Data in Excel,Creating a Worksheet and Charting Data in Excel,Creating a Worksheet and Charting Data in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Using Functions, Creating Tables, and Managing Large Workbooks in Excel,Creating Documents with Microsoft Word,Creating Documents with Microsoft Word,Creating Cover Letters and Using Tables to Create Resumes,Creating Cover Letters and Using Tables to Create Resumes,Getting Started with Microsoft PowerPoint,Getting Started with Microsoft PowerPoint,Formatting PowerPoint Presentations. |
Dersin Öğrenme Kazanımları | Teaching Methods | Assessment Methods |
5.Will be able to use presentation programs. | 12, 14, 16, 4, 6, 9 | A, E, G |
1. will be able to explains the basic concepts of information technology. | 16, 9 | A, E |
1.1 Explains the general concepts. | ||
1.2 Displays hardware components. | ||
1.3 Explains the concept of software, examples of software types. | ||
2. Will be able to apply computer usage and file management. | 16, 8, 9 | A, E |
2.1 Turns on the computer device. | ||
2.2 Explains the concept of the desktop. | ||
2.3 Describes how to perform file management. | ||
3. Will be able to express how the word processor program is used. | 12, 14, 16, 9 | A, E, G |
3.1. Describes usage of the application. | ||
3.2. Explains Basic Operations. | ||
3.3. Explains formatting methods. | ||
4. Will be able to use a spreadsheet program. | 12, 14, 16, 4, 9 | A, E, G |
4.1. Describes the usage of the application. | ||
4.2. Explains cell concept. | ||
4.3. Describes the concept of the worksheet. | ||
4.4. Uses Formulas and Functions. | ||
4.5. Describes the types of formatting. | ||
4.6. Describes the use of graphics. | ||
5.1. Describes usage of the application. | ||
5.2. Describes creating a presentation. | ||
5.3. opens Text and Views . | ||
5.4. applies the use of Graphics and Drawing Objects (Auto Shape). | ||
5.5. Uses Screen Display Effects. |
Teaching Methods: | 12: Problem Solving Method, 14: Self Study Method, 16: Question - Answer Technique, 4: Inquiry-Based Learning, 6: Experiential Learning, 8: Flipped Classroom Learning, 9: Lecture Method |
Assessment Methods: | A: Traditional Written Exam, E: Homework, G: Quiz |
Course Outline
Order | Subjects | Preliminary Work |
---|---|---|
1 | History of Computer and Introduction to Office Programs | Related chapter in the course book should be read. |
2 | Creating a Worksheet and Charting Data in Excel | Related chapter in the course book should be read. |
3 | Creating a Worksheet and Charting Data in Excel | Related chapter in the course book should be read. |
4 | Creating a Worksheet and Charting Data in Excel | Related chapter in the course book should be read. |
5 | Using Functions, Creating Tables, and Managing Large Workbooks in Excel | Related chapter in the course book should be read. |
6 | Using Functions, Creating Tables, and Managing Large Workbooks in Excel | Related chapter in the course book should be read. |
7 | Using Functions, Creating Tables, and Managing Large Workbooks in Excel | Related chapter in the course book should be read. |
8 | Creating Documents with Microsoft Word | Related chapter in the course book should be read. |
9 | Creating Documents with Microsoft Word | Related chapter in the course book should be read. |
10 | Creating Cover Letters and Using Tables to Create Resumes | Related chapter in the course book should be read. |
11 | Creating Cover Letters and Using Tables to Create Resumes | Related chapter in the course book should be read. |
12 | Getting Started with Microsoft PowerPoint | Related chapter in the course book should be read. |
13 | Getting Started with Microsoft PowerPoint | Related chapter in the course book should be read. |
14 | Formatting PowerPoint Presentations | Related chapter in the course book should be read. |
Resources |
Evans, A., Martin, K., & Poatsy, M. A. (2018). Technology in Action Introductory. Pearson. |
Jelen, B. (2021). Microsoft Excel Inside Out (Office 2021 and Microsoft 365). Microsoft Press. Pearson MyLab Platform |
Course Contribution to Program Qualifications
Course Contribution to Program Qualifications | |||||||
No | Program Qualification | Contribution Level | |||||
1 | 2 | 3 | 4 | 5 | |||
1 | Defines the theoretical issues in the field of information and management. | X | |||||
2 | Describes the necessary mathematical and statistical methods in the field of information and management. | ||||||
3 | Uses at least one computer program in the field of information and management. | X | |||||
4 | Sustains proficiency in a foreign language requiredor information and management studies. | ||||||
5 | Prepares informatics/software projects and work in a team. | ||||||
6 | Constantly updates himself / herself by following developments in science and technology with an understanding of the importance of lifelong learning through critically evaluating the knowledge and skills that s/he has got.7. Uses theoretical and practical expertise in the field of information and management | X | |||||
7 | Follows up-to-date technology using a foreign language at least A1 level, holds verbal / written communication skills. | ||||||
8 | Follows up-to-date technology using a foreign language at least A1 level, holds verbal / written communication. | ||||||
9 | Adopts organizational / institutional and social ethical values. | ||||||
10 | Within the framework of community involvement adopts social responsibility principles and takes initiative when necessary. | ||||||
11 | Uses and analyses basic facts and data in various disciplines (economics, finance, sociology, law, business) in order to conduct interdisciplinary studies. | ||||||
12 | Writes software in different platforms such as desktop, mobile, web on its own and / or in a team. |
Assessment Methods
Contribution Level | Absolute Evaluation | |
Rate of Midterm Exam to Success | 40 | |
Rate of Final Exam to Success | 60 | |
Total | 100 |