CTP193 - Computer Applications
2012 - 2013 Fall

Department of Computer Technology and Programming
(Last updated: 03/03/2008)   (CWPS ver: 2.0.2)
Instructor:
E-mail: ozsoy@ctp.bilkent.edu.tr
Lecture: Sect 02 - Monday 08:40-10:30 / Wednesday 13:40-15:30 - Lab2
Sect 03 - Monday 13:40-15:30 / Thursday 13:40-15:30 - Lab2
Grading:    
    Lab Quiz 1: 10%
    Lab Quiz 2: 10%
    Lab Quiz 3: 10%
    Midterm 1: 30%
    Final: 40%

Detailed Weekly Course Outline:
Week Date Session1 Session2
1 13/09/2012
17/09/2012
Introduction: Objectives of the course
  • Introduction to Microsoft Windows 2000
  • Starting Microsoft Windows
  • Windows basics (Start Button, Taskbar, My Computer, Recycle Bin)
  • Mouse operations (click, double click, drag, right mouse button)
  • Basic parts of a window (title bar, control-menu box, minimize-maximize buttons, Menu bar, scroll bars, border)
  • Arranging windows (sizing windows, moving windows, restoring a window, active window, closing windows)
  • Control Panel
  • Accessories:
  • Calculator
  • Notepad
  • Wordpad
  • Paint
  • Internet - concepts and terms, security
  • Browsers and settings
  • Web Navigation - accessing pages, bookmarks, printing
  • Web Searching - search engines
  • General IT Concepts - Hardware, Software, Types of Computers
  • Hardware - CPU, Memory, Input/Output
  • Software - Types, OS Software, Application Software, GUI, System Development
  • Information Networks - LAN, WAN, Intranet, Extranet Everyday IT
  • Health and Safety - Ergonomics, Health Issues, Precautions, Environment Security - Information Security, Computer Viruses Copyright
  • E-mail  
  • 2 20/09/2012
    24/09/2012
    • My Computer
    • Using Floppy Disks (Formatting, Saving, Deleting and Browsing Files)
    • Hands on exercise on Paint and WordPad: Saving a file on a floppy disk Windows Explorer
    • Managing your files and folders on your floppy and harddisk
    • The Tree Structure and File Operations: create, copy, delete, rename and move
    • Searching
    • Compressing the files
    • Exercises with Windows Explorer
     
    3 27/09/2012
    01/10/2012
    • Introduction to Microsoft WORD
    • Basic of word processing (basic concepts and literacy)
    • Introduction to Word screen
    • Menus
    • Toolbars (standard, formatting, drawing etc.)
    • Ruler
    • Document window
    • Entering text
    • Editing text
    • Moving around in a document
    • Insert and overstrike modes
    • Changing the text
    • Opening a document /Closing a document
    • Saving a document/Save As
    • Printing a document
    • Document Viewing
    • Zooming In and Out
    • Working with Multiple Documents
    • Quiz 1 (10%)
    • Selecting Text (moving and copying), Clipboard concept (cut, copy, paste)
    • Undo-ing
    • Formatting characters (changing fonts and related options, character spacing, animations, drop cap)
     
    4 04/10/2012
    08/10/2012
    • Formatting paragraphs
    • Create Columns
    • Alignment (left, right, centered, justified)
    • Indentation (hanging indent)
    • Borders and shading
    Bayram Holiday  
    5 11/10/2012
    15/10/2012
    • Page Formatting
    • Working with the ruler
    • Setting margins
    • Setting paper size and orientation
    • Header and footer
    • Page numbering
    • Bullted list, Numbering
    • Setting Tabs
    • Insert picture from Clip Art
    • Mail merge
     
    6 18/10/2012
    22/10/2012
    • Tables
    • Creating tables
    • Inserting and deleting row/column
    • Merging/splitting cells
  • PowerPoint
  • Working with Slides
  • Add Text to a Slide (Changing Fonts, Justify Text, Modifying Text Styles and Colors)
  • Adding Drawings to Slides (Using the Drawing toolbar, Apply color, shadow, and pattern to objects, Move, Scale, and Rotate objects, Group and Ungroup objects)
  • Adding Clip Art to Slides (Using the Clip Art Gallery, Resize and Position Clip Art images, Change the color and Shading of Clip Art  
  • 7 25/10/2012
    29/10/2012
    Holiday
    • Viewing Slides (Slide, Outline, Sorter, Notes Pages)
    • Managing Your Slides (Copying, Deleting, Moving )
    • Creating a Slide Show
     
    8 01/11/2012
    05/11/2012
    MIDTERM WEEK
    MIDTERM WEEK
     
    9 08/11/2012
    12/11/2012
    • Working with FrontPage
    • FrontPage Screen and Menus
    • Saving HTML/HTM document
    • Open file from Internet Explorer
    • Formatting Characters
    • Font colors, alignments, sizes
    • Bullets and numbering
    • Background
    • Insert horizontal line and symbol
    • Insert Hyperlink (http, file, mailto)
    • Insert Image
    • Insert Marquee
     
    10 15/11/2012
    19/11/2012
    • Creating Tables
    • Merging and Splitting Cells
    • Insert and delete rows and columns
    • Table and Cell Properties
    • Publishing personal web site using WS-FTP
    • EXCEL
    • The Excel Environment (MS Excel's Screens and Menus)
    • Structure of a worksheet: Cell, Row, Column, Row & Column Heading, Active Cell, Formula Bar
    • Entering and Editing Information
    • Selecting cells
    • Clearing the contents of a cell (Format/Content/All)
    • Naming Cells.
    • Insert Comment.
    • Font Changes, Alignment in Excel
    • Column Width
    • Smarter Fills
    • Page Setup
    • Cut, copy, paste between sheets.
    • Understanding Workbooks
    • Worksheet ranges (Rename, Delete, Hide, Move, Copy))
    • Formula Entering
    • AutoSum function (difference between : and , )
     
    11 22/11/2012
    26/11/2012
    • Quiz 2 (10%)
    • Common Functions (Min, Max)
    • Common functions ( Average, Count, CountA, Isblank, SumIf, CountIf)
     
    12 29/11/2012
    03/12/2012
    • The magic of copying formulas
    • Difference between Absolute and Relative Addresses
    • Formatting Cells - Shading and Borders
    • Insert / Delete rows and columns, Hidden Cells
    • Changing row height, column width
     
    13 06/12/2012
    10/12/2012
    • Quiz 3 - EXCEL(10%)  
    14 13/12/2012
    17/12/2012
    • Exercises with IF and VLOOKUP
    Holiday  
    15 20/12/2012
    24/12/2012
  • Review  

  • Course Related Material
  • How computers work  
  • Computer Dictionary-Webopedia  
    Labworks
  • Labwork 4  
  • Labwork 5  
  • Labwork 16  
  • Labwork 17  
  • Labwork 19  
  • Labwork 20  
  • Labwork 21  
  • Labwork 22  
  • Labwork 23  
  • XL-01  
  • XL-02  
  • XL-03  
  • XL-04  
  • XL-05  
  • XL-06  
  • XL-07  
  • XL-08  
  • XL-09  
  • XL-10  
  • XL-BASICS  
  • XL-Filter  
  • XL-FUNCTIONS  
    End of CTP193 main page.