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

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


 * 1) In Class
 * 2) 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.
 * 3) 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.
 * 4) After Class
 * 5) 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.
 * 6) 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.
 * 7) 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.
 * 8) 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.

Introduction

 * Lecture 1: course introduction
 * /Lecture 1

A Graphical Vocabulary for Problem Solving

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

Problem Solving Using Spreadsheets

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

Problem Solving Using Databases

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

Logic

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

Problem Solving Through Algorithms

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

Final Exam Study Guide Fall 2008

 * Final Exam Study Guide
 * /Study Guide

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

 * Lecture 21: BLANK Lecture Template
 * /Lecture 21