- Course Code
- TDS219
- Semester
- Third Term (Fall)
- Theory+Practice
- 2 + 1
- ECTS
- 5
| Course Type | Compulsory Course |
|---|
| Course Level | Associate Degree |
|---|
| Year of Study | 2 |
|---|
| Semester | Third Term (Fall) |
|---|
| ECTS | 5 |
|---|
| Name of Lecturer(s) |
|
| Learning Outcomes |
At the end of this course, the students;
- Recognizes the spreadsheet interface and performs basic operations.
- Uses formulas and functions to calculate, edit, and analyze data.
- Visually represents data using charts and tables, and prepares it for printing.
|
| Mode of Delivery | Face to face |
|---|
| Prerequisites | No |
|---|
| Recommended Optional Programme Components | None |
|---|
| Course Description | This course aims to teach the basic use of spreadsheet programs (especially Microsoft Excel). Students will learn applications such as data entry, cell formatting, basic formulas and functions, graph creation, data sorting, and filtering. Additionally, they will gain skills in table formatting, simple data analysis, and report preparation commonly encountered in healthcare institutions. By the end of the course, students are expected to be able to create organized, clear, and professional-looking electronic documents using Excel. |
|---|
| Course Contents |
| WEEK |
TOPICS |
|
1st Week |
Course Introduction and Introduction to Excel |
|
2nd Week |
The Excel Interface and Basic Concepts |
|
3rd Week |
Working with Cells, Rows, and Columns |
|
4th Week |
Number, Text, and Date Formats |
|
5th Week |
Basic Formulas and Operations |
|
6th Week |
Introduction to Functions (SUM, AVERAGE, MAX, etc.) |
|
7th Week |
Conditional Formatting and Data Validation |
|
8th Week |
Midterm Exam |
|
9th Week |
Charts and visual presentation tools |
|
10th Week |
Sorting and filtering operations |
|
11th Week |
Page layout and print settings |
|
12th Week |
Working with multiple sheets, sheet links |
|
13th Week |
Simple data analysis and pivot tables |
|
14th Week |
Creating a practical sample document |
|
| Recommended or Required Reading | İltir, C. (2023). Herkes için Excel. Abaküs Kitap. |
|---|
| Planned Learning Activities and Teaching Methods |
- Lecture
- Questions/Answers
- Case Study
- Practice
|
|---|
| Assessment Methods and Criteria |
|
Quantity |
Percentage (%) |
| Mid-term |
1 |
50 |
| Total(%) |
|
50 |
| Contribution of In-term Studies to Overall Grade(%) |
|
50 |
| Contribution of Final Examination to Overall Grade(%) |
|
50 |
| Total(%) |
|
100 |
|
| ECTS Allocated Based on Student Workload |
| Activities |
Quantity |
Duration (Hour) |
Total Workload (Hour) |
| Midterm exam |
1 |
1 |
1 |
| Preparation for Quiz |
|
|
|
| Individual or group work |
15 |
4 |
60 |
| Preparation for Final exam |
1 |
25 |
25 |
| Course hours |
15 |
2 |
30 |
| Preparation for Midterm exam |
1 |
25 |
25 |
| Laboratory (including preparation) |
15 |
1 |
15 |
| Final exam |
1 |
1 |
1 |
| Homework |
|
|
|
| Total Work Load | 157 |
| Total Work Load / 30 (h) | 5.23 |
| ECTS Credit of the Course | 5 |
|
| Language of Instruction | Turkish |
|---|
| Work Placement(s) | No |
|---|
Programme Qualifications / Learning Outcomes
|
LO1 |
LO2 |
LO3 |
| K1 |
X |
X |
X |
| K2 |
|
|
|
| K3 |
X |
X |
X |
| K4 |
X |
X |
X |
| K5 |
X |
|
|
| K6 |
|
|
|
| K7 |
X |
X |
|
| K8 |
|
|
|
| K9 |
|
|
|
| K10 |
|
|
|
| K11 |
|
|
|
| K12 |
|
|
X |
| K13 |
|
X |
|
| K14 |
X |
|
|
