CTP291 - Computer Applications for Business I
2012 - 2013 Fall

Department of Computer Technology and Programming
(Last updated: 16/09/2007)   (CWPS ver: 2.0.2)
Instructor:
E-mail: ozsoy@ctp.bilkent.edu.tr
Lecture: Tuesday 08:40-10:30 LAB 2
Lab: Wednesday 08:40-10:30 LAB 2
Grading:    
    Midterm 1: 30%
    Midterm 2: 30%
    Final: 40%

http://www.ctp.bilkent.edu.tr/~ctp291
Detailed Weekly Course Outline:
Week Date
1 13/09/2012
17/09/2012
∑Introduction to WINDOWS - Desktop, Control Panel, Properties, Accessories
∑Windows Explorer - Files and Folders - Creating/Moving/Renaming/Copying/Deleting
Norton Antivirus:System status, Scan for viruses, Reports, Scheduling, Live Update, Rescue.
2 20/09/2012
24/09/2012
Advanced features of WORD -
Creating and modifying Heading Styles.
Applying your own custom heading styles.
Creating and modifying Table of Contents.
3 27/09/2012
01/10/2012
Quick ways to create Letters/Faxes/Memos/Resumes/Reports and other documents.
Using Wizards.
Using and creating templates.
4 04/10/2012
08/10/2012
Tracking Changes, Highlighting changes, Accepting or Rejecting Change.
Versions
Finding files or folders according to: Name & Location, Date, Type
AutoText, Inserting caption/autocaption (Equation-Figure-Table)
5 11/10/2012
15/10/2012
Organization chart
Bookmark, Hyperlink, Word Count, Mail Merge, File Protection,
Comment, Tools:Envelopes and Labels, Letter Wizard
Tools/Options/Spelling & Grammar
6 18/10/2012
22/10/2012
VISIO – Creating business diagrams.
Adding and creating shapes, modifying shapes, arranging shapes, formatting shapes, working with text and shapes.
Working with drawing pages
Creating master shapes, stencils and templates
Using Visio with other applications.
7 25/10/2012
29/10/2012
MIDTERM WEEK
8 01/11/2012
05/11/2012
Exam Solutions --- Holiday
9 08/11/2012
12/11/2012
Advanced features of POWERPOINT
10 15/11/2012
19/11/2012
EXCEL
Spreadsheet applications - Charts
11 22/11/2012
26/11/2012
Excel
∑Formula Entering
∑AutoSum function (difference between : and ,)
∑Common functions (Min, Max)
12 29/11/2012
03/12/2012
Excel
∑Common functions (Average, Count, CountA, Isblank, CountIf, Sumif)
∑Copying Formulas
∑Absolute vs Relative Addressing
13 06/12/2012
10/12/2012
Excel
∑Conditional Formulas (IF, Nested IF)
14 13/12/2012
17/12/2012
Excel
∑Conditional Formulas(VLOOKUP)
15 20/12/2012
24/12/2012
No classes due to following Thursday classes.
Finals

End of CTP291 main page.