Code | Name of the Course Unit | Semester | In-Class Hours (T+P) | Credit | ECTS Credit |
---|---|---|---|---|---|
BGT153 | INTEGRATED OFFICE APPLICATIONS | 1 | 2 | 2 | 3 |
GENERAL INFORMATION |
|
---|---|
Language of Instruction : | Turkish |
Level of the Course Unit : | ASSOCIATE DEGREE, TYY: + 5.Level, EQF-LLL: 5.Level, QF-EHEA: Short Cycle |
Type of the Course : | Compulsory |
Mode of Delivery of the Course Unit | - |
Coordinator of the Course Unit | Lecturer ÇİSEM YAŞAR |
Instructor(s) of the Course Unit | |
Course Prerequisite | No |
OBJECTIVES AND CONTENTS |
|
---|---|
Objectives of the Course Unit: | This course aims to develop the skills of students with useful tools that they can use in daily life, office life, and software teams. |
Contents of the Course Unit: | In this course, various applications that can be used in daily life such as e-mail, calendar, meeting, document editing, table preparation, and presentation preparation will be facilitated in a computer environment by using Microsoft Office and Google tools. |
KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to) |
---|
Can send individual or multiple e-mails |
Can create scheduled or instant online meetings. |
Can store using cloud systems. |
Can prepare online or offline electronic documents. |
Can prepare online or offline spreadsheets. |
Can prepare online or offline electronic presentations. |
WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY |
|||
---|---|---|---|
Week | Preparatory | Topics(Subjects) | Method |
1 | - | Introduction, internet services, internet browsers and settings. | Explanation |
2 | Research | Google Forms, calendar | Explanation, application |
3 | Research | Drive, spreadsheets, documents, slides | Explanation, application |
4 | Research | MS Word MS Word screen, Toolbars and features, Save, Security options | Explanation, application |
5 | Research | MS WORD Page Structure, Writing in Word, Font Properties, Format Painter, Paragraph Properties, Tabs, Borders and Shading, Columns, Bullets and Numbering | Explanation, application |
6 | Research | MS Word Inserting a table and table toolbar, Inserting a drawing object, Templates, Automatic correction options, Paste special, Find-Change-Go, Inserting clip art and pictures, using the picture toolbar | Explanation, application |
7 | Research | MS Excel - Introduction to Excel, Page and Cell Concept, Cursor Types, Page Tabs, Cut-Copy-Paste, Row and Column Operations, Formatting | Explanation, application |
8 | - | MID-TERM EXAM | - |
9 | Research | MS Excel - Getting to Know the Toolbars, Working with Files, Navigating the Worksheet, MS Excel - Operators, Creating Formulas, Formatting Cells | Explanation, application |
10 | Research | Creating Drawing Objects, Graphics | Explanation, application |
11 | Research | MS Powerpoint - Creating slides, Slide layout, Slide Design | Explanation, application |
12 | Research | Adding custom animations, sounds and starting slides | Explanation, application |
13 | Research | Master slide editing, slide view tools | Explanation, application |
14 | Research | New presentation preparation tools | Explanation, application |
15 | Research | Office application | Explanation, application |
16 | - | FINAL EXAM | - |
17 | - | FINAL EXAM | - |
SOURCE MATERIALS & RECOMMENDED READING |
---|
Şen Bilişim. (2024). Microsoft Office 365 Professional 2024. |
Yandım, H. (2024). Applied Microsoft Office Programs Training from A to Z. |
Teknoteleskop Publications. (2024). Excellence in Excel, Word, and Official Correspondence. |
Microsoft Office Official Guides: ◦ Official documentation and user guides for Microsoft Word, Excel, and PowerPoint. Microsoft Office Guides |
Google Workspace Training Resources: ◦ Official training content for Google Drive, Docs, Sheets, Slides, and Forms. Google Workspace Learning Center |
Mastering Microsoft Office - Gini Courter |
Google Workspace for Beginners - Paul McFedries |
ASSESSMENT |
||||
---|---|---|---|---|
Assessment & Grading of In-Term Activities | Number of Activities | Degree of Contribution (%) | Description | Examination Method |
Mid-Term Exam | 1 | 50 | ||
Final Exam | 1 | 50 | ||
TOTAL | 2 | 100 |
Level of Contribution | |||||
---|---|---|---|---|---|
0 | 1 | 2 | 3 | 4 | 5 |
WORKLOAD & ECTS CREDITS OF THE COURSE UNIT |
|||
---|---|---|---|
Workload for Learning & Teaching Activities |
|||
Type of the Learning Activites | Learning Activities (# of week) | Duration (hours, h) | Workload (h) |
Lecture & In-Class Activities | 14 | 2 | 28 |
Preliminary & Further Study | 14 | 2 | 28 |
Land Surveying | 0 | 0 | 0 |
Group Work | 0 | 0 | 0 |
Laboratory | 0 | 0 | 0 |
Reading | 0 | 0 | 0 |
Assignment (Homework) | 0 | 0 | 0 |
Project Work | 0 | 0 | 0 |
Seminar | 0 | 0 | 0 |
Internship | 0 | 0 | 0 |
Technical Visit | 0 | 0 | 0 |
Web Based Learning | 0 | 0 | 0 |
Implementation/Application/Practice | 0 | 0 | 0 |
Practice at a workplace | 0 | 0 | 0 |
Occupational Activity | 0 | 0 | 0 |
Social Activity | 0 | 0 | 0 |
Thesis Work | 0 | 0 | 0 |
Field Study | 0 | 0 | 0 |
Report Writing | 0 | 0 | 0 |
Final Exam | 1 | 1 | 1 |
Preparation for the Final Exam | 14 | 1 | 14 |
Mid-Term Exam | 1 | 1 | 1 |
Preparation for the Mid-Term Exam | 7 | 1 | 7 |
Short Exam | 0 | 0 | 0 |
Preparation for the Short Exam | 0 | 0 | 0 |
TOTAL | 51 | 0 | 79 |
Total Workload of the Course Unit | 79 | ||
Workload (h) / 25.5 | 3,1 | ||
ECTS Credits allocated for the Course Unit | 3,0 |