TÜRKÇE
ENGLISH
Information
| Unit | ADANA VOCATIONAL SCHOOL |
| Code | MVU162 |
| Name | Electronic Spreadsheet |
| Term | 2025-2026 Academic Year |
| Semester | 2. Semester |
| Duration (T+A) | 2-0 (T-A) (17 Week) |
| ECTS | 3 ECTS |
| National Credit | 2 National Credit |
| Teaching Language | Türkçe |
| Level | Ön Lisans Dersi |
| Type | Normal |
| Label | E Elective |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Doç. Dr. MEHMET ESEN |
| Course Instructor |
The current term course schedule has not been prepared yet.
|
Course Goal / Objective
This course aims to teach students how to use Excel effectively in accounting; organize, analyze, and report accounting data; make financial calculations using spreadsheets; and gain the basic digital competencies they will need in business life.
Course Content
n this course, students learn the basic interface of Excel, learn to tabulate accounting transactions with basic and advanced formulas. They gain the ability to analyze data with tools such as graphics, filtering, PivotTable, scenario analysis. They experience creating dynamic tables by getting data from the web, using formulas, and filtering data. At the end of the term, they develop practical accounting files with projects where they apply what they have learned.
Course Precondition
no prerequisites
Resources
Instructor lecture notes, Accounting Audit with Excel Author: İsmail Taşçı, M.Mahmut Yılmaz Publisher: Sinemis Publications - Economy Series
Notes
web sources
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Knows the Excel interface and performs basic data entry operations. |
| LO02 | Applies cell formatting, conditional formatting, and page layout operations. |
| LO03 | Performs calculations using basic and advanced functions (SUM, IF, VLOOKUP, etc.). |
| LO04 | Sorts, filters and creates tables for accounting. |
| LO05 | Visualizes financial data with graphs and tables. |
| LO06 | Uses data from the web, integrates it into Excel and analyzes this data. |
| LO07 | It reports with PivotTable and scenario tools. |
| LO08 | Designs and presents appropriate tables and reports for accounting applications. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | Students have the skill of adopting gained information related to the business and management in decision making, practicing and behaviors. | 2 |
| PLO02 | Bilgi - Kuramsal, Olgusal | Students have basic knowledge in the field of accounting and taxation. | 2 |
| PLO03 | Beceriler - Bilişsel, Uygulamalı | Students have the skill of analysing, commending and evaluating the information related to the field of accounting and taxation. | |
| PLO04 | Beceriler - Bilişsel, Uygulamalı | Students fulfill the tasks assigned and have the skill of managing the full procedures. | |
| PLO05 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Students have the skill of recognizing ang solving the problems related to the field of accounting and taxation. | 3 |
| PLO06 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Students take responsibility as a team member when an expected case occurs in practice. | |
| PLO07 | Yetkinlikler - Alana Özgü Yetkinlik | Students behave according to the organizational, behavioral and social ethics. | |
| PLO08 | Yetkinlikler - Öğrenme Yetkinliği | Students show that they realize the need of constant learning. | |
| PLO09 | Yetkinlikler - Alana Özgü Yetkinlik | Students have the skill of understanding and implementing the vocational laws and regulations. | |
| PLO10 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Students explain the ideas and suggestion in written and oral forms | |
| PLO11 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Students use information and communication technologies and the vocational software programs | 4 |
| PLO12 | Yetkinlikler - Öğrenme Yetkinliği | Students have the vocational self-confidence | |
| PLO13 | Yetkinlikler - Alana Özgü Yetkinlik | Students are conscious about the universality of social rights, social justice, quality, cultural values, environmental protection and labor safety. | |
| PLO14 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Have a level of foreign language knowledge to follow the innovations in the field. |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Introduction to Excel and Interface Introduction; Excel screen, cell, row, column structure, menus, basic data entry. | Researching and reading the topic on the internet and resources. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 2 | Basic Formulas and Functions; Basic functions such as SUM, AVERAGE, COUNT, MAX, MIN. | Researching and reading the topic on the internet and resources. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 3 | Cell Formatting; Number, currency, date formats, cell merging, conditional formatting. | Researching and reading the topic on the internet and resources. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 4 | Data Sorting and Filtering; Automatic sorting, custom filtering and logical filters. | Researching and reading the topic on the internet and resources. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 5 | Data Visualization with Charts; Presentation of financial data with column, pie, and line charts. | Researching and reading the topic on the internet and resources. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 6 | Creating Tables for Accounting; Income-expense, cash book, accounting spreadsheet. | Researching and reading the topic on the internet and resources. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 7 | Advanced Functions; Calculation with functions such as IF, VLOOKUP, IFERROR, ROUND, TEXT. | Researching and reading the topic on the internet and resources. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 8 | Mid-Term Exam | Studying the topics by doing practice. | Ölçme Yöntemleri: Yazılı Sınav |
| 9 | Receiving Data from the Web; Transferring and updating information such as exchange rates and stock market data from the Web to Excel. | Researching and reading the topic on the internet and resources. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 10 | Using PivotTable; Analyze data by grouping, create dynamic summary reports. | Researching and reading the topic on the internet and resources. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 11 | Scenario and Goal Tools; Goal seeker, scenario manager, decision analysis. | Researching and reading the topic on the internet and resources. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 12 | Page Layout and Print Settings Printer-friendly formatting, title fixing, page setup. | Researching and reading the topic on the internet and resources. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 13 | Applied Accounting Tables I; VAT calculation, invoice recording, introduction to payroll calculation. | Researching and reading the topic on the internet and resources. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 14 | Applied Accounting Tables II; Month-end reports, analysis studies with summary tables. | Researching and reading the topic on the internet and resources. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 15 | General Review; Excel general content summary. | Researching and reading the topic on the internet and resources. | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösterip Yaptırma |
| 16 | Term Exams | Studying the topics by doing practice. | Ölçme Yöntemleri: Yazılı Sınav |
| 17 | Term Exams | Studying the topics by doing practice. | Ölçme Yöntemleri: Yazılı Sınav |
Student Workload - ECTS
| Works | Number | Time (Hour) | Workload (Hour) |
|---|---|---|---|
| Course Related Works | |||
| Class Time (Exam weeks are excluded) | 14 | 3 | 42 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 2 | 28 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 0 | 0 | 0 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 5 | 5 |
| Final Exam | 1 | 10 | 10 |
| Total Workload (Hour) | 85 | ||
| Total Workload / 25 (h) | 3,40 | ||
| ECTS | 3 ECTS | ||