| Course Type | Elective Course |
|---|
| Course Level | Bachelor's Degree |
|---|
| Year of Study | - |
|---|
| Semester | - |
|---|
| ECTS | 5 |
|---|
| Name of Lecturer(s) |
- |
| Learning Outcomes |
At the end of this course, the students;
- Prepare documents using the advanced features of Word.
- Format data, create tables, and generate charts using the advanced features of Excel.
- Write formulas, work with functions, and perform calculations using the advanced features of Excel.
- Create and use macros in Excel.
- Prepare presentations using the advanced features of PowerPoint.
|
| Mode of Delivery | Face to face |
|---|
| Prerequisites | No |
|---|
| Recommended Optional Programme Components | BTU100 Computer Literacy |
|---|
| Course Description | This course focuses on in-depth learning of word processing, presentation, and spreadsheet programs essential for today?s office environments, ensuring that students gain sufficient knowledge in these areas. This course will cover the practical use of MS Office Word, PowerPoint, and Excel. |
|---|
| Course Contents |
| WEEK |
TOPICS |
|
1st Week |
Introduction to the course: introductions and installations of current application programs |
|
2nd Week |
Introduction to MS Word: tabs, groups, and command buttons; footnotes; labels; sources; citations; bibliography; adding a table of contents |
|
3rd Week |
Creating a new style, using built-in heading styles, reviewing, tracking changes, printing |
|
4th Week |
Creating a custom bullet list, adding checkboxes and text, creating and working with templates |
|
5th Week |
Introduction to MS Excel: concepts of data and tables, entering information accurately and quickly, modifying, conditional formatting of data, special selection and paste techniques, page layout, printer output settings, custom views |
|
6th Week |
Creating charts, modifying options, and working with multiple charts |
|
7th Week |
Relative and absolute references, arithmetic operations, and functions in Excel |
|
8th Week |
Midterm exam |
|
9th Week |
Using logical functions, searching values in a data list, calculating conditional statistics, descriptive statistics, generating random numbers, auditing formulas, and tracking changes |
|
10th Week |
Creating summary tables (pivot table) |
|
11th Week |
Scenario management, goal seeking, and using Solver to define and solve problems |
|
12th Week |
Creating and running macros, introduction to macro programming: variables and definitions |
|
13th Week |
Conditional structures and loops |
|
14th Week |
MS PowerPoint: techniques for professional presentation preparation |
|
| Recommended or Required Reading | Nordell, R. (2021). Microsoft Office 365: In Practice. McGraw-Hill Education. |
|---|
| Planned Learning Activities and Teaching Methods |
- Lecture
- Questions/Answers
- Practice
|
|---|
| Assessment Methods and Criteria |
|
Quantity |
Percentage (%) |
| Mid-term |
1 |
30 |
| Assignment |
1 |
10 |
| Quiz |
4 |
10 |
| 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 |
4 |
13 |
52 |
| Individual or group work |
1 |
10 |
10 |
| Preparation for Final exam |
1 |
10 |
10 |
| Course hours |
14 |
3 |
42 |
| Preparation for Midterm exam |
1 |
10 |
10 |
| Laboratory (including preparation) |
1 |
14 |
14 |
| Final exam |
1 |
1 |
1 |
| Homework |
1 |
10 |
10 |
| Total Work Load | 150 |
| Total Work Load / 30 (h) | 5 |
| ECTS Credit of the Course | 5 |
|
| Language of Instruction | Turkish |
|---|
| Work Placement(s) | No |
|---|
