Courses/Computer Science/CPSC 203/CPSC 203 Template/Lecture Template

Jump to: navigation, search

Lecture Study Tips

These tips are "advice" on how to study the lecture material.

  1. In Class
    1. Take careful notes. In each lecture, a great deal of material is conveyed via overheads,diagrams, PowerPoint Slides, Black/WhiteBoard sessions, and through Question/Answsers from the class. This in-class material is not on the Wiki, which constitutes a "skeleton" for each lecture.
    2. Participate -- learning is active. Participate in the class, by actively listening and asking questions. Participate in any in-class exercises -- they are designed to help you practice concepts and skills.
  2. After Class
    1. Download the Wiki page for that class. It contains a "skeleton outline" for that class. Often it also has glossaries of terms you should know, and historical material. It is expected that in addition to your class notes, you have read all the notes on the Wiki.
      1. Download any documents loaded on the Wiki. Often there are specific examples that are used to teach in class. Download these examples, and review them. Make sure you fully understand any document, spreadsheet, or database loaded to the lecture Wiki pages.
    2. Do the required readings. These readings are listed at the top of each lecture's Wiki page. Often they are from the textbook, but they may be also from articles linked to the Wiki.
  3. What is Testable. Materials covered in lecture, placed on the Wiki page for a lecture, and Required Readings are all testable (i.e. questions from them may appear on a mid-term or final).

Lecture Material WINTER 2009

These are the lecture materials for the current semester.

  • Link in PDF with Winter 2009 Lecture Notes here.

Lecture Material FALL 2008

These Lecture Materials are from Fall 2008 session, and are superseded by Lecture Material for Winter 2009.


A Graphical Vocabulary for Problem Solving

  • Lecture 2: history and deep structure of the Internet
  • Lecture 3: design and the Internet
  • Lecture 4: graphs as models for problem solving

Problem Solving Using Spreadsheets

  • Lecture 5: Information Systems, Information Hierarchy, Spreadsheets
  • Lecture 6: From Data to Information -- A Visual Introduction to Statistics
  • Lecture 7: Data Visualization and Perception

Problem Solving Using Databases

  • Lecture 8: Data, Sets, Relations -- An Introduction to Relational Problem Solving
  • Lecture 9: Relational Database Meta-Model
  • Lecture 10: Rules for Relational Thinking -- An Introduction to the Relational Database Query Trace Mechanism
  • Lecture 11: More Relational Thinking -- Further Examples of E-RDs, Query Trace Mechanism, Basic Query Patterns
  • Lecture 12: Data Analysis Via Queries
  • Lecture 13: Database Design Principles
  • Lecture 14: More Problem Solving Concepts.


  • Lecture 15: Introduction to Truth Tables and Boolean Logic
  • Lecture 16: Problem Solving with Truth Tables
  • Lecture 17: Truth Tables to Circuits

Problem Solving Through Algorithms

  • Lecture 18: From Algorithms to the Modern Computer
  • Lecture 19: Functional Problem Solving
  • Lecture 20: Problem Solving Design Techniques, Top Down Design, The Page Rank Algorithm

Final Exam Study Guide Fall 2008

Lecture Template

Lecture Template Format

  • The following is a list of main sections for a lecture:
    • Housekeeping
    • Required Reading
    • Introduction (including bullet list of main concepts)
    • Glossary
    • Concepts
    • Summary
    • Text Readings
    • Resources
    • Homework
    • Questions (link to another page where students can ask questions)

Lecture Template Page