CTE103 - Information Technologies in Education I
2012 - 2013 Fall

Department of Computer and Instructional Technology Teacher Education
(Last updated: 12/11/2007)   (CWPS ver: 2.0.2)
Instructor:
E-mail: russell@bilkent.edu.tr
Lecture: Sec01: Mon 8:40-10:30 / Wed 8:40-10:30 Lab3
Sec02: Tues 8:40-10:30/Thurs 10:40-12:30 Lab7
Sec03: Tues 10:40-12:30/Thurs 13:40-15:30 Lab7
Sec04: Tues 10:40-12:30/Thurs 8:40-10:30 Lab8
Grading:    
    Lab Quiz 1: 10%
    Lab Quiz 2: 10%
    Lab Quiz 3: 10%
    Midterm 1: 30%
    Final: 40%

Detailed Weekly Course Outline:
Week Date Session 1 Session 2
1 13/09/2012
17/09/2012
Basics of IT
  • General Course Information and Overview
  • General IT Concepts - Hardware, Software, Types of Computers
  • Hardware - CPU, Memory, Input/Output
  • Software - Types, OS Software, Application Software, GUI, System Development
Basics of IT
  • Information Networks - LAN, WAN, Intranet, Extranet
  • Everyday IT
  • Health and Safety - Ergonomics, Health Issues, Precautions, Environment
  • Security - Information Security, Computer Viruses
  • Copyright
 
2 20/09/2012
24/09/2012
Using the Computer and Managing Files
  • Computer Environment - First Steps, Basic Operations
  • Desktop - work with Icons, work with Windows
  • Managing Files - concepts, directories and folders, files, copy/move, delete/restore
Using the Computer and Managing Files
  • Managing Files - Searching, Compressed Files
  • Viruses - concepts, handling viruses
  • Print Management - Setup, Outputs
  • Labwork 1
 
3 27/09/2012
01/10/2012
Information and Communication
  • Internet - concepts and terms, security, browsers and settings
  • Web Navigation - accessing pages, bookmarks, printing
  • Web Searching - search engines
  • Labwork 2
Information and Communication
  • Email - concepts and terms, security, settings
  • Email - reading, replying, forwarding
  • Email Management - Address Book, organizing messages
 
4 04/10/2012
08/10/2012
Word Processing
  • First steps, Adjusting Settings
  • Main Operations - inserting, deleting, selecting, editing
  • Main Operations - copy, move, search, replace
  • Formatting - text formatting
Word Processing
  • Paragraph Formatting
  • Document Formatting
  • Labwork 3

NOTE: BAYRAM HOLIDAY - No Classes Oct 11/12  
5 11/10/2012
15/10/2012
Word Processing
  • Paragraph Formatting
  • Document Formatting
  • Labwork 4
Quiz 1 - In Class

 
6 18/10/2012
22/10/2012
Word Processing
  • Objects - Tables, Pictures, Images, Charts
  • Labwork 5
Word Processing
  • Mail Merge - Concepts and Practice
  • Mail Merge - preparing outputs
  • Labwork 6
 
7 25/10/2012
29/10/2012
Spreadsheets
  • First steps, adjust settings
  • Cells - insert/select data, rows, columns, edit data, copy/move/delete, search/replace, sort
  • Worksheets - copy, move, insert, delete, rename
Spreadsheets - Formatting
  • Numbers and Dates
  • Contents
  • Alignment, Border, Effects
  • Conditional Formats
  • Labwork 7
NOTE: REPUBLIC HOLIDAY - No Classes Oct 29
Spreadsheets - Formulas and Functions
  • Basic formulas - arithmetic formulas
Spreadsheets - Formulas and Functions
  • Arithmetic functions - SUM, SUMIF, COUNT, COUNTA, COUNTIF, AVERAGE, MIN, MAX
  • Labwork 8
 
8 01/11/2012
05/11/2012
MIDTERM WEEK
MIDTERM DATE: Sunday, November 11th, 10:40 - 12:30
MIDTERM WEEK
MIDTERM DATE: Sunday, November 11th, 10:40 - 12:30  
9 08/11/2012
12/11/2012
Formulas and Functions Continued
  • Cell Referencing - absolute vs. relative
  • Labwork 9
 
10 15/11/2012
19/11/2012
    Spreadsheets - Formulas and Functions
  • Logical functions - IF, nested IF
  • Labwork 10
Spreadsheets
  • Charts and Graphs
  • Printing spreadsheets
  • Labwork 11
 
11 22/11/2012
26/11/2012
Databases
  • Database concepts
  • Using databases, settings
  • Tables - Main operations, defining keys, table design/layout
Databases
  • Tables - design/layout continued
  • Table Relationships
 
12 29/11/2012
03/12/2012
Databases
  • Forms - creating, modifying
Databases
  • Queries
  • Sorting/Filtering Records
 
13 06/12/2012
10/12/2012
Databases
  • Reports - creating, modifying
  • Preparing outputs
Presentations
  • Presentations - first steps
  • Adjust settings
  • Developing presentations - views, slides, templates
Presentations
  • Master Slides
  • Text and Images - formatting text, pictures, images
  • Slides - duplicate, move, delete
 
14 13/12/2012
17/12/2012
Presentations
  • Charts and Graphs
  • Organization Charts
  • Drawing Objects
NOTE: BAYRAM HOLIDAY - No Classes Dec 19/20/21  
15 20/12/2012
24/12/2012
Presentations
  • Preset Animations
  • Transitions
  • Preparing Outputs - printing, delivering presentations
  • Practice and Review
NOTE: NO CLASSES Dec 31 - Jan 2  

End of CTE103 main page.