Course Learning Outcomes (CLOs) are those describing the knowledge, skills and competencies that students are expected to achieve upon successful completion of the course. In this context, Course Learning Outcomes defined for this course unit are as follows:
Week |
Subject |
Materials Sharing * |
|
Related Preparation |
Further Study |
1) |
Introduction to the course and information about the processing
Explanation of lesson plan and grade evaluation
(Orientation)
Basic concepts of Information Technologies
Microsoft Office - Introduction to Word
• Introducing the Word Interface
• Using the Quick Access Toolbar
Working with Document View Modes
• Opening a New Document |
|
|
2) |
Microsoft Office Word– Text Formatting Operations
• Editing Paragraph Settings
• Editing Borders and Shading Options
• Adding Bullets and Numbering |
|
|
3) |
Microsoft Office Word– Text Formatting Operations
• Dividing the Text into Columns
• Enlarging the Beginning
Change Capital / Lower Case
• Finding and Replacing Text
• Adding Date and Time
• Adding Page Number |
|
|
4) |
Microsoft Office Word - Working with Tables - Using Advanced Word Tools
• Creating Tables
• Adding and Deleting Rows, Columns
• Applying Style to the Table
• Convert Table to Text
• Adding Page Break
• Adding End of Section
• Adding Hyperlink to Text |
|
|
5) |
Microsoft Office Excel- Data Entry / Cell and Table Formatting
• Introduction of the Interface
• Data input
• Moving and Copying
• Adding Comments
• Cell Forming |
|
|
6) |
Microsoft Office Excel- Functions and Calculations
• Conditional formatting
• Formula Entry
• Mathematical Functions |
|
|
7) |
Microsoft Office Excel- Functions and Calculations
• Statistical Functions
• Textual Functions
• Sorting, Filtering |
|
|
8) |
midterm exam week |
|
|
9) |
Microsoft Office Excel- Data Processing
• Pivot Table - Pivot Chart (Pivot Chart)
• Data Validation
• Removing Duplicate Data |
|
|
10) |
Microsoft Office Excel- Page Layout and Print Settings / Appearance Properties
• Paper Size Selection
• Setting Margins
• Vertical / Horizontal Page Usage
• Header / Footer Settings
• Page Break Operations
• Print Options
• Appearance Settings |
|
|
11) |
Microsoft Office - Introduction to Powerpoint / Creating a New Presentation
• Introduction of the Interface
• Presentation and Slide Concepts
Document View Modes
• Creating a Presentation Using a Template
• Adding and Editing Text
• Saving Options
Microsoft Office Powerpoint- Working with Slide Structure and Text Based Components
• Choosing a Design Theme
• Selecting Slide Layout
• Working with Text Boxes
• Formatting Text
• Using Bullets and Numbering |
|
|
12) |
Microsoft Office Powerpoint- Slide Arrangements
• Changing Slide Layouts
• Copying and Deleting Slides
• Hiding and Viewing Slides
• Adding Slide Transition Effects
• Adding Slides from Other Presentations
Using the Find and Replace Tool |
|
|
13) |
Microsoft Office Powerpoint- Working with Pictures, Tables, Graphics
• Adding Pictures to Slides
• Grouping Objects
• Adding Tables
• Editing the Table Design
• Adding and Deleting Cells, Rows, Columns
• Aligning Text in Tables
• Adding Graphics
Formatting and Resizing the Chart |
|
|
14) |
Microsoft Office Powerpoint- Animations
• Using the Animation Tab
• Adding Input and Output Animations
• Adding Emphasis
• Using Motion Paths
• Editing Animation Effects
• Using Saved Templates |
|
|
15) |
Working with Microsoft Office Outlook Messages
• Introduction of the Interface
• Creating an Email Message
• Reading and Deleting Emails
• Replying, Forwarding and Printing Emails
• Filtering Emails
• Creating Signatures and Adding Signatures to Emails
Microsoft Office Calendar and Contacts
• Making an Appointment to the Calendar
• Managing and Organizing Appointments
• Planning and Managing Meetings
• Sharing the Calendar
• Customizing the Calendar
• Adding and Updating People
• Using the To Do Bar |
|
|
16) |
Final exam |
|
|
(KPLOs and SPLOs are the abbreviations for Key & Sub- Programme Learning Outcomes, respectively. )
|
Programme Learning Outcomes |
Contribution Level (from 1 to 5) |
1) |
Explains the basic, theoretical and practical knowledge related to the field of computer programming. |
|
|
1.1 Knows the basic concepts in the field of information technologies. |
|
|
1.2 Defines the problems that s/he may face in the field of computer programming. |
|
|
1.3 Have the analytical thinking skills required by computer programming. |
|
|
1.4 Defines the fundamentals of programming and algorithm information. |
|
|
1.5 Defines the basics of web design. |
|
|
1.6 Have knowledge about the basic concepts and management of computer networks. |
|
2) |
Knows the techniques, tools and information technologies necessary to develop applications related to the field. |
|
|
2.1 Knows the technical and modern tools necessary for applications related to computer programming. |
|
|
2.2 Knows the editors, compilers and platforms used in program development. |
|
|
2.3 Have the necessary program information to edit the visuality of the web page and to develop the web page. |
|
|
2.4 Have knowledge about tools used for database design and management. |
|
|
2.5 Knows game and mobile application development platforms. |
|
|
2.6 Follows technological innovations in software and hardware. |
|
3) |
Produces solutions by using the theoretical knowledge learned. |
|
|
3.1 Develops programs using analytical thinking skills by using software languages. |
|
|
3.2 Performs the installation and management of computer networks. |
|
|
3.3 Performs coding using game development platforms. |
|
|
3.4 Gains the ability to analyze and design information systems. |
|
|
3.5 Makes graphic design and animation applications. |
|
|
3.6 Realizes web design, software and programming. |
|
|
3.7 Installs and manages operating systems. |
|
|
3.8 Develops database applications. |
|
|
3.9 Learns visual and object-oriented programming. |
|
|
3.10 Produces solutions to problems encountered in computer programming and develops methods to solve the problems encountered. |
|
4) |
Applies the theoretical knowledge learned in business life for a semester. |
|
|
4.1 Experiences all processes in business life. |
|
|
4.2 Takes part in activities related to the field of education in a business operating in the field. |
|
|
4.3 Questions the application with theoretical knowledge. |
|
|
4.4 Compiles the knowledge and experience gained in the field. |
|
5) |
Acquires the competencies defined as the institutional outcomes of Beykoz University on the basic level, inline with the expectations of business world and the society. |
|
|
5.1 Acquires competency of analyzing and solving the problems. |
|
|
5.2 Has awareness for ethical and social responsibility. |
|
|
5.3 Takes responsibility as a team member in works and operations of his/her field. |
|
|
5.4 Is aware of written, verbal communication and interaction. |
|
|
5.5 Follows the developments of advanced technology and digital transformation. |
|
|
5.6 Acquires the awareness for lifelong learning. |
|
|
5.7 Has awareness about citizenship competency. |
|
|
5.8 Evaluates the developments of his/her field with the understanding of an entrepreneur. |
|
|
5.9 Acquires communication in a Foreign Language (English) competence defined on the level of at least A2 in European Language Portfolio. (In programs whose medium of instruction is English, on the level of B1). |
|
|
|
|
WORKLOAD OF TEACHING & LEARNING ACTIVITIES |
Teaching & Learning Activities |
# of Activities per semester |
Duration (hour) |
Total Workload |
Course |
14 |
3 |
42 |
Laboratory |
0 |
0 |
0 |
Application |
0 |
0 |
0 |
Special Course Internship (Work Placement) |
0 |
0 |
0 |
Field Work |
0 |
0 |
0 |
Study Hours Out of Class |
0 |
0 |
0 |
Presentations / Seminar |
0 |
0 |
0 |
Project |
0 |
0 |
0 |
Homework Assignments |
1 |
5 |
5 |
Total Workload of Teaching & Learning Activities |
- |
- |
47 |
WORKLOAD OF ASSESMENT & EVALUATION ACTIVITIES |
Assesment & Evaluation Activities |
# of Activities per semester |
Duration (hour) |
Total Workload |
Quizzes |
2 |
10 |
20 |
Midterms |
1 |
5 |
5 |
Semester Final Exam |
1 |
10 |
10 |
Total Workload of Assesment & Evaluation Activities |
- |
- |
35 |
TOTAL WORKLOAD (Teaching & Learning + Assesment & Evaluation Activities) |
82 |
ECTS CREDITS OF THE COURSE (Total Workload/25.5 h) |
3 |