defter*
defter / katalog / CTIS 186
CTIS 186

Business Computer Applications

CTIS 186 builds the baseline office-software fluency that the rest of the CTIS program quietly assumes you already have: structuring slides that actually communicate, producing a clean Word document with proper styles instead of manual formatting, and getting useful answers out of a spreadsheet through formulas, lookups, and conditional rules. The work is almost entirely hands-on — weekly assignments in PowerPoint, Word, and Excel, a lab exam, and a practical final where you're judged on whether you can do the task, not describe it. It's a freshman-semester requirement with no prerequisite, and the payoff shows up later when reports, presentations, and data tables stop being the bottleneck in your other courses.

Credit3ECTS5BölümInformation Systems and Technologies

Değerlendirme 100% — 5 adım

5%
5%
30%
25%
35%
In-class attendance Attendance 5%
In-class participation Participation 5%
Lab exam Midterm Exam 30%
Assignments Assignment 25%
Final:Practical(skills) Final Exam 35%

Önerilen kaynaklar 1 kitap

📖
Önerilen
Microsoft Office Manual from GCFGlobal (https://edu.gcfglobal.org/en/subjects/office/)

Haftalık müfredat 14 hafta

Hafta 1
PowerPoint (Part I): Open and view a PowerPoint presentation, Type a Speaker Note, Save as a PowerPoint Slide Show, Plan and Prepare a Presentation, Add a Presentation Content, Review the Presentation, Add a Table, Insert Media Objects, Apply Transitions and Animations, Insert a Header or Footer, Navigate a Slide Show, Print in PowerPoint.
Hafta 2
PowerPoint (Part II): Create a Presentation using a Template, Modify a Presentation based on a Template, Create a Presentation in Outline View, Modify an Outline Structure, Print an Outline, Import an Outline, Reuse Slides from an Existing Presentation, Use Sections, Examine Slide Show Design Principles, Modify a Theme, Modify the Slide Master.
Hafta 3
PowerPoint (Part III): Create Shapes, Apply Quick Styles and Customize Shapes, Create SmartArt, Modify SmartArt, Create WordArt and Modify WordArt, Modify Objects, Arrange Objects, Insert a Picture, Transform a Picture, Add a Video, Use Video Tools, Add Audio, Change Audio Settings.
Hafta 4
Word (Part I): Begin and Edit a Document, Customize Word, Use Features that improve Readability, View a Document in Different ways, Modify Document Properties, Prepare a Document for Distribution.
Hafta 5
Word (Part II): Apply Font Attributes, Format a Paragraph, Format a Document, Apply Styles, Insert and Format Objects.
Hafta 6
Word (Part III): Insert a Table, Format a Table, Manage Table Data, Enhance Table Data.
Hafta 7
Review
Hafta 8
Midterm Exam
Hafta 9
Mid-Semester Evaluation
Hafta 10
Excel (Part I): Explore the Excel Window, Enter and Edit Cell Data, Create Formulas, Display Cell Formulas, Manage Columns and Rows, Select, Move, Copy, and Paste Date, Apply Cell Styles, Alignment, and Font Options, Apply Number Formats, Manage Worksheets, Select page Setup Options, Preview and Print a Worksheet.
Hafta 11
Excel (Part II): Use Relative, Absolute and Mixed Cell References in Formulas, Insert a Function, Insert Basic Math and Statistics Functions, Use Date Functions, Determine Results with the IF Function, Use LOOKUP Functions, Calculate Payments with the PMT Function.
Hafta 12
Excel (Part III): Select the Data Source, Choose a Chart Type, Move, Size and Print a Chart, Add, Edit and Format Chart Elements, Apply a Chart Style and Colors, Modify the Data Source, Create and Customize Sparklines.
Hafta 13
Excel (Part IV): Freeze Rows and Columns, Print Large Datasets, Understand the Benefits of Data Tables, Design and Create Tables, Apply a Table Style, Create Structured References in Formulas, Sort Data, Filter Data, Add a Total Row, Apply Conditional Formatting, Create a New Rule.
Hafta 14
Overall Revision

🤖 GenAI politikası

Students may use GenAI for their individual study purposes outside the lecture sessions. As far as homework / case studies / assignments policies are concerned, students are NOT allowed to plagiarize and are required to

Ders notları — henüz yok

CTIS 186 için defter ekibi henüz not yazmadı.

İlk dosyayı sen atarsan — not, slayt, geçmiş sınav, çözüm, cheat-sheet, ne varsa — defter ekibi öğrenci paylaşımlarından bu dersin notlarını yazar. Drive linki / PDF / ZIP, hepsi olur.

← katalog

Geçmiş GPA dağılımı 13 dönem · ort. 2.68

DönemCourse CPA
2025-2026 Fall 2.89 1 sec · 23 öğr
2024-2025 Fall 3.24 1 sec · 16 öğr
2024-2025 Spring 2.58 1 sec · 11 öğr
2023-2024 Fall 2.67 1 sec · 30 öğr
2023-2024 Spring 2.60 1 sec · 7 öğr
2022-2023 Fall 2.70 1 sec · 11 öğr
2022-2023 Spring 2.53 1 sec · 14 öğr
2021-2022 Fall 3.18 2 sec · 18 öğr
2021-2022 Spring 2.68 1 sec · 7 öğr
2020-2021 Spring 2.38 1 sec · 16 öğr

Aggregate course GPA — Bilkent STARS'tan public data. Hoca-bazlı per-section detayı için STARS evaluation report →. Öğrenci anket cevapları KVKK kapsamında defter'de tutulmaz.

⚠️ FZ engelleyen şartlar

- Totaling at least 35.75 / 65 (before Final Exam). - Missing no more than 9 Hours in the whole

Hocalar 1 bu dönem · 2 geçmiş

Bu dönem (2025-2026 Spring) · 1 section
Jamel Ben Chafra
Geçmişte ders veren (2 kişi)
Anthony Burnett Evans, Rabia Üşenmez