Class Lectures

      Instructor: Irfan Ahmed Ilyas

Lecture Slides   

 Serial  Topic(s) Covered  Week
 Lecture 01- Introductory Session (new) -Discussion about  Course  syllabus & Learning strategies  

  Lecture 2 Slides  (new)

 Chapter 1: Information Technology, the Internet, and You
  -Basic Computing Concepts
  -Basic Working of a Computer System
  -Introducing a Problem
  -Analogy: Human & Computer
   - Information Processing Cycle
  -Introducing Information Systems
  -Five Parts of An Information System
 -   Details of 'People'

Lecture 3 Slides (new)
Chapter 1:Information Technology, the Internet, and You
Five parts of an information system
  -Details of Procedure
  -Details of Hardware 
Clips: (Available on WebCT)
           1.Use of PDA              2.Different types of mouse

  -Details of Software   
       -How does a 'Web Based Application' work? ( Flash Animation)

  -Details of Data

Connectivity Feature
Lecture 4 Slides (new)


What is Open Source Software?  


 A brief history of Spreadsheet Software

Chapter 1 & 3- Basic Application Software

Details about Software Component
Software Classification
System Software Details
Types of System Software                  ....More on Open Source   Who is behind OSS?

World of Application Software      
  -Features offered by all application programs
  -Features specific to a class of application programs
 - Specialized Application Software (not included in the course)

Features specific to
  -Word Processing Application
       - When should I use MS Word? (Flash - Speakers are needed) 

  -Spreadsheet Application
      - When should I use MS Excel? (Flash - Speakers are needed)

Other Basic Applications
    Presentation Graphics
            - What makes a Presentation? (Flash - Speakers are needed)
            - How does MS Power Point work? (Flash - Speakers are needed)

    Database Management Systems
- When should I use MS Access? (Flash - Speakers are needed)

Personal Organizer
          - When should I use MS Outlook? (Flash - Speakers are needed)

 Lecture 5 Slides (new)

Chapter 3: Spreadsheet Features

More Spreadsheet Features
What if Analysis/ Goal Seek
Types of data entry
Cell Referencing
Formula Entry Details
Precedence Rule / Parenthesis Rule
    How does Excel Work? (Flash - Speakers are needed)

    What are workbook & worksheets? (Flash - Speakers are needed)

 Lecture 6 Slides (new) Chapter 3: Spreadsheet Features

Formula Copying Details in Spreadsheets

Formatting Techniques in Spreadsheets
Available Number Formatting Schemes in Excel

Advanced Formatting Techniques
  Auto Format
  Conditional Format
    What is conditional formatting? (Flash - Speakers are needed)

Internet Features in Spreadsheets
  Converting sheet to a Web Document Format
  Getting sheet data from the web (Web Query)

 Lecture 7 Slides (new) Chapter 3: Spreadsheet Features

Explaining Spreadsheet Functions
Use of Function Wizard
Use of Cell/ Range Naming in Spreadsheet Functions
Function Examples in Microsoft Excel
Financial Functions
Logical Functions
Math/ Statistical Function
Lookup & Reference Functions
Data/ Time Functions
     Using formula and functions in MS Excel. (video - Speakers are needed) [Available on webCT]

 Lecture 08 Slides (new) Chapter 3: Spreadsheet Features
Charts Overview
Charting Example: Student Performance Charts
Common Spreadsheet Charts
Column/ Bar Chart
Pie Chart
Line Chart

    What types of charts I can create in Excel? (Flash - Speakers are needed)


 Lecture 09 Slides (new)  Chapter 1: Information Technology, the Internet, and You

Computer Hardware Details
4 Types of Computers
Computer Networks
Network Classifications

  Video Clip: How to build a PC? (available on WebCT)

  Who owns the fastest super computer?

 Lecture 10 Slides(new) Chapter 6 (Publisher Slides)
Internal Data Representations
Numbers/ Characters/ Instructions
Coding Schemes

Class Demos:
 Decimal Vs Binary Conversion Methods & Significance of Coding lengths in Character Coding
 Lecture 11 Slides (new)

Types of Processors

Chapter 6
System unit components

Microprocessor Details
  -Microprocessor main parts
  -Main Types (CISC/ RISC)
  -Word Size

-How does  'a computer restart process' work? ( Flash Animation)

- Understanding 64-bit processors

 Lecture 12 Slides (new) Chapter 6
Details of Memory Classification
  -RAM  Vs   Sequential Memory
  -ROM Vs Read/Write
  -Vloatile Vs Non-Volatile
  -Cache Memory
  -Virtual Memory

-How does  'Virtual Memory' work? ( Flash Animation)


 Lecture 13 Slides (new) Chapter 6
System Clock
Interface Cards
Configuring an adapter card
Plug-n-play technology
Example Interface Cards
Bus lines
Ports & Cables

-How does a 'a TV Tuner Card' work? ( Flash Animation)

 Lecture 14 Slides (new) Chapter 3/ 12
Database Concepts

 Database Management Systems
- When should I use MS Access? (Flash - Speakers are needed)

Data Organization in databases
Key Field
Main activities in Database Maintenance
  -Defining data
  -Creating data
  -Manipulating data

Database Applications

Database Implementation Approaches
  -Flat file approach
  -Integrated file approach

Lecture 15 Slides (new) Chapter 3/ 12
Integrated File Approach for saving data
  -Benefits/ Drawback

Database Accessing Approach
  -File based Programs
  -DBMS based access


Lecture 16 Slides (new) Chapter 3/ 12- Database Management Systems
Introducing DBMS
Working of a basic DBMS
Main DBMS Features
Users in a DBMS Environment
Lecture 17-18 Slides (new) Chapter 3/ 12- Table Object

DBMS Main Modules
Some example DBMS packages
Introducing Microsoft Access
Details of Access Interface Objects
Table Object Functionalities
 - Data Definition
 - Data Manipulation
 - Data Type Details
  -Character/ Number/ DateTime/ YesNo etc.

Lecture 19 Slides (new)

Chapter 3/ 12-Databases

Databases Advantages
Types of Databases
Databases Uses and Issues

Writing Queries in DBMS

Types of Queries
  -Data Manipulation Queries
  -Data Definition Queries

Creating Queries in Microsoft Access
  -QBE (Query By Example)
  -SQL (Structured Query Language)

Working with SELECT Queries
  -Using Single Table
  -Multiple table
  -Parametric (Runtime Criteria) Query

Lecture 20 Slides (new) Chapter 3/ 12-Queries in DBMSes

Working with SELECT Queries
  -Field Computation Queries
  -Summary Queries

Use of Groups in Summary Queries

2. Update Queries
3. Delete Queries
4. Append Queries
5. Make Table Queries
6. Cross Tab Queries

Lecture 21 Slides (new) Chapter 3/ 12- Data Integrity in DBMSes
Data Integrity Constraints FOR Accurate Data Entry
  -Single Table Integrity Constraints
  -Referential Integrity Constraints

Significance of Table Relationships
  -Controlling Referential Integrity
  -Building Queries

Referential Integrity Maintenance Approaches
  -One-to-One Relationship Maintenance 
  -One-to-Many Relationship Maintenance


Lecture 22 Slides

Chapter 4
Interface Cards
Configuring an adapter card
Plug-n-play technology
Example Interface Cards
Bus lines
Lecture 23 Slides Chapter 2: The Internet, the Web and Electronic Commerce
Introducing Internet   Internet History
What is available on the Internet?
How to get connected with Internet?
Main Internet Facilities
   -World Wide Web
   -Electronic Mailing
Basic Working Model of Internet Services
   -Client Program
   -Server Program
  -Transaction Mechanism

Lecture 24 Slides

Chapter 2: The Internet, the Web and Electronic Commerce
Internet Backbone
Internet Administration   About Internet Society

Details of World Wide Web
  -Web Standards
  -Web Document Format
  -Web Addressing

Details of Emailing
  -Email Structure
  -Mechanism used
  -Domain Name Addressing (DNS)

Lecture 25 Slides Chapter 2: The Internet, the Web and Electronic Commerce
Internet Email
  Offline (Ordinary Email)
  Online (Instant Emailing- Chat)

Group Mailing
Mailing List
News Groups
Chat Groups
Discussion Group Terminology
Spam Mail

Introducing Web Search Engines
  -Web Search Index (directories)
  -Web Search Engines
  -Web Meta Search Engines

Lecture 26 Slides Chapter 2: The Internet, the Web and Electronic Commerce
Introducing Electronic Commerce
Ecommerce main areas
Types of ecommerce sites
  -Web Storefronts
  -Web Auctions

Methods of Ecommerce Payments
  -Credit cards

Browser Utilities
  -Helper Applications
  -Java applets

Web Portals
Types of internet

Lecture 27 Slides Chapter 14: Programming
Phases in Software Development Cycle
-Phase1: Program Specifications
-Phase2: Program Design (Documentation Techniques)
  -Psuedo code
  -Flow charting
Lecture 28 Slides Chapter 14: Programming
Phase 3: Program Coding
Phase 4: Program Testing
Phase 5: Installing the Program
Phase 6: Program Documentation
Phase 7: Program Maintenance
Lecture 29 Slides Chapter 7: Input and Output  Publisher Slides
Input/ Output (Translators)
Input device classification
  -Key board entry
  -Direct entry devices

Lecture 30