CTP105 - Programming Environment
2012 - 2013 Fall

Department of Computer Technology and Programming
(Last updated: 09/11/2007)   (CWPS ver: 2.0.2)
Ceren Aydogmus
Instructors: Ceren Aydogmus
E-mail: aydogmus@ctp.bilkent.edu.tr
Lecture: Monday 08:40-12:30 Lab 7 Wednesday 13:40 - 15:30 Lab 7 Friday 10:40-12:30 Lab 7
Grading:    
    Lab Quiz 1: 10%
    Lab Quiz 2: 10%
    Lab Quiz 3: 10%
    Midterm 1: 30%
    Final: 40%

Textbooks and Other Materials:
  • Required: "ECDL The Complete Coursebook for Microsoft Office 2000", Brendan Munnelly and Paul Holden, 2000
    Detailed Weekly Course Outline:
    Week Date Session 1 Session 2
    1 13/09/2012
    17/09/2012
    • Course introduction and objectives
     
    2 20/09/2012
    24/09/2012
    • Intro to Windows 2000 - Desktop, Control Panel, Properties, Accessories
    • Windows Explorer - Files and Folders - Creating/Moving/Renaming/Copying/Deleting
     
    3 27/09/2012
    01/10/2012
     
    4 04/10/2012
    08/10/2012
    • Basics of Word Processing - Introduction to MS Word (Cut/Copy/Paste) Document Viewing, Print Preview, Save/Save As Page Setup computer.doc
    • Font Formatting (changing fonts and related options, character spacing, animations, drop cap)
    • Bullets and Numbering, Outline Numbered Lists.
    • Lab5.doc
     
    5 11/10/2012
    15/10/2012
    • QUIZ1
    • MS Word Continued: Formatting Paragraphs(Create Columns, Alignment (left, right, centered, justified), Indentation (hanging indent), Borders and shading) Lab6.doc
    • Inserting Tabs
    • MS Word - Graphics and Drawing Objects
    • MS Word: Creating Tables - Inserting Tables, Rows/Columns, Formatting Cells, Merging Cells, Borders and Shading.
     
    6 18/10/2012
    22/10/2012
    • Introduction to 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)
    • present.ppt
    • Viewing Slides (Slide, Outline, Sorter, Notes Pages)
    • Managing Your Slides (Copying, Deleting, Moving )
    • Creating a Slide Show (Animation, Transitions)
     
    7 25/10/2012
    29/10/2012
    Holiday
      Holiday
     
    8 01/11/2012
    05/11/2012
    MIDTERM WEEK
      MIDTERM WEEK
     
    9 08/11/2012
    12/11/2012
      Lab11.xls
    • 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, Comments
    • 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)
    • Formatting Cells Shading and Borders Insert / Delete rows and columns, Hidden Cells
    • Changing row height, column width
    • Formatting cells (font, borders, shading)
     
    10 15/11/2012
    19/11/2012
      Lecture example
    • Common functions (Average, Count, CountA, Isblank, CountIf, Sumif)
    • Copying Formulas
    • Absolute vs Relative Addressing
      Lab13.xls
     
    11 22/11/2012
    26/11/2012
  • Lecture example
  • Sorting and Filtering Lists
    Lab16.xls
  • Charts
  • Review  
  • 12 29/11/2012
    03/12/2012
    QUIZ2
  • Access Database Basics
  • Creating a Table
  • Setting field properties
  • Set the key
  • The table datasheet view  
  • 13 06/12/2012
    10/12/2012
      Lecture example
    • Create a form
    • Modifying a form (calculated control, list box, command buttons, color)
  • Query Basics Creating a query
  • Modifying an Existing Query ( AND and OR conditions in query)  
  • 14 13/12/2012
    17/12/2012
  • Reports, The MS Access report wizard,
    Registration
  • Review  
    15 20/12/2012
    24/12/2012
      QUIZ3
    Review  

    End of CTP105 main page.