CTP192 - Introduction to Computer Applications
2012 - 2013 Fall

Department of Computer Technology and Programming
(Last updated: 26/02/2008)   (CWPS ver: 2.0.2)
Instructors: Murat Özsoy
E-mail:
Lecture:
Lab: Lab 1 - Tue 8:40-10:30 / Wed 10:40-12:30
Grading:    
    Lab Quiz 1: 10%
    Lab Quiz 2: 10%
    Midterm 1: 35%
    Final: 45%

Detailed Weekly Course Outline:
Week Date Session 1 Session 2
1 13/09/2012
17/09/2012
  • Introduction: Objectives of the course.
  • 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.
 
2 20/09/2012
24/09/2012
  • Font Changes, Alignment in Excel
  • Column Width
  • Smarter Fills
  • Using Excel 97 's cut, copy, paste between sheets.
  • Understanding Workbooks
  • Worksheet ranges (Rename, Delete, Hide, Move, Copy)
  • Page Setup
  • Formula Entering
  • AutoSum function (difference between : and , )
  • Common functions (Min, Max)
 
3 27/09/2012
01/10/2012
  • Common functions (Average, Count, CountA, Isblank,CountBlank, CountIf,SumIf)
  • The magic of copying formulas
 
4 04/10/2012
08/10/2012
  • Difference between Absolute and Relative Addresses
  • Formatting Cells
  • Shading and Borders
  • Insert / Delete rows and columns, Hidden Cells
  • Changing row height, column width
 
5 11/10/2012
15/10/2012
  • Review
  • QUIZ-1
  • If and VLOOKUP functions
 
6 18/10/2012
22/10/2012
  • Exercises related with IF and VLOOKUP functions
  • PMT function, Goal Seek
  • Sorting a List
  • Filtering a List
 
7 25/10/2012
29/10/2012
  • Working with Multiple Sheets§ Charts in Excel
  • Charts in Excel
 
8 01/11/2012
05/11/2012
MIDTERM WEEK
MIDTERM WEEK
 
9 08/11/2012
12/11/2012
  • ACCESS Database Basics
  • Creating a Table§ Setting field properties
  • Set the key
  • The table datasheet view
  • Modifying table structures
  • Adding/Delete fields
  • Add/Delete records
 
10 15/11/2012
19/11/2012
  • 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)
 
11 22/11/2012
26/11/2012
MID-SEMESTER BREAK
MID-SEMESTER BREAK
 
12 29/11/2012
03/12/2012
  • Access report wizard
  • Exercises with Access
 
13 06/12/2012
10/12/2012
  • QUIZ-2
  • Getting acquainted with POWERPOINT
  • Working with Slides
  • Add Text to a Slide (Changing Fonts, Justify Text, Modifying Text Styles and Colors)
 
14 13/12/2012
17/12/2012
  • 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)
  • Inserting Word Tables, Excel Worksheets and Charts
 
15 20/12/2012
24/12/2012
  • Viewing Slides (Slide, Outline, Sorter, Notes Pages)
  • Managing Your Slides (Copying, Deleting, Moving )
  • Creating a Slide Show
Review
 

End of CTP192 main page.