CS 0131, Software for Personal Computing
Spring 2013, Term 2134

This page lists basic information on the topics we have covered during each lecture. It is meant to help you review what we have learned. For a preview of future topics, check §3.1 of the syllabus.

Lecture Date Topics Files
42 Tue 23 Apr Exam 2, covering PowerPoint and Access. Topics List for Exam 2
41 Fri 19 Apr Access — Grouping and sorting reports; Reports sections.
Review for Exam 2.		 coffee.accdb
40 Wed 17 Apr Lab 10, Forms and Reports. insurance.accdb
39 Mon 15 Apr Access — Form styles; Calculated controls; Report basics; Grouping and sorting reports.
Project 4 released; due Sun 21 Apr, 11:59pm EDT.		 coffee.accdb
38 Fri 12 Apr Access — Advanced queries; Calculated fields; Built-in functions; Form basics; Form layout and design views; Form controls (labels, text boxes, etc.). northwind.accdb
37 Wed 10 Apr Lab 9, Formulating Queries.
36 Mon 8 Apr Access — Relationship types (one-to-one, one-to-many, many-to-many); Single-table queries; Multi-table queries. hotel.accdb
35 Fri 5 Apr Access — Field properties; Database design principles; Linking relational data; Establishing referential integrity.
Bonus Assignment released; due Sun 21 Apr, 11:59pm EDT.
34 Wed 3 Apr Lab 8, Designing Database Tables.
33 Mon 1 Apr Access — Datasheet and design views; Primary keys (single or multiple keys); Foreign keys; Relationship view; One-to-many relationships.
32 Fri 29 Mar Access — What is a database?; Tables, fields, and records review; Relational databases; Objects (tables, queries, forms, reports); Ribbon and basic navigation. northwind.accdb
31 Wed 27 Mar Lab 7, Simple Game Show.
30 Mon 25 Mar PowerPoint — Copyright and the Internet; Content guidelines; Delivery tips; Design principles; How not to use PowerPoint.
29 Fri 22 Mar PowerPoint — Motion paths; Custom paths; Triggers; Slideshow setup (hide slide, kiosk mode, continuous loop); Timings; Rehearsing timings.
28 Wed 20 Mar Lab 6, Slideshow Basics.
Project 3 released; due Tue 26 Mar, 11:59pm EDT.		 demo.pptx
27 Mon 18 Mar PowerPoint — Images review; Inserting audio and video clipart and files; Timing animations.
— Fri 15 Mar
Wed 13 Mar
Mon 11 Mar		 No Class: Spring Recess
26 Fri 8 Mar PowerPoint — Removing a photograph background; Photo corrections, options, and effects; Using a picture as a background; Photo cropping and compression. lighthouse.jpg
25 Wed 6 Mar PowerPoint — Grid positioning and alignment guidelines; Vector vs. raster images; Ungrouping and recoloring vector images.
24 Mon 4 Mar PowerPoint — Outline view; SmartArt; WordArt.
23 Fri 1 Mar PowerPoint — Master views (slide master, handouts master, notes master); Shapes; Aligning objects. shapes.pptx
22 Wed 27 Feb PowerPoint — Layering and grouping objects; Transitions and animations; Presenter view. kitties.pptx
21 Mon 25 Feb PowerPoint — What is a slideshow?; Presentation planning; Templates and themes; Objects and tables; Printing a presentation; Transitions.
20 Fri 22 Feb Exam 1, covering Word and Excel. Topics List for Exam 1
19 Wed 20 Feb Excel — Tables and structured references; Print setup.
Review for Exam 1.		 classes.xlsx
18 Mon 18 Feb Lab 5, Making Sense of Large Datasets.
Project 2 released; due Thu 28 Feb, 11:59pm EST.		 spa.xlsx
17 Fri 15 Feb Excel — Relative and absolute references review; Charts and chart types; Data sources and series; Chart layouts and styles; Chart elements (chart area, plot area, data labels, axes, gridlines, trendlines); Sparklines. loans.xlsx, psych.xlsx
16 Wed 13 Feb Lab 4, Functions and Charts. salaries.xlsx, majors.xlsx
15 Mon 11 Feb Excel — Date functions (how date values are stored); IF() function and logical comparators; PMT() function; Named ranges. grades.xlsx
14 Fri 8 Feb Excel — Relative and absolute references; Circular references; Function basics (input-output relation, arguments/parameters); Range notation; Mathematical and statistical functions; Nesting and chaining functions.
13 Wed 6 Feb Lab 3, Spreadsheet Basics.
12 Mon 4 Feb Excel — What is a spreadsheet?; Inputs and outputs; Navigating and managing worksheets and workbooks; Cell data types; Basic mathematical formulas; Number formats.
11 Fri 1 Feb Word — Table and list styles; Mail merge. donortable.docx, volunteers.xlsx
10 Wed 30 Jan Lab 2, Tables.
9 Mon 28 Jan Word — Footnotes and endnotes, Citations and bibliography, Table of contents and index, Captions, Cross-references. network.docx, table.docx
8 Fri 25 Jan Word — Modfiying and creating styles; Graphics (controlling placement and wrapping); Reviewing comments; Tracking changes.
Project 1 released; due Tue 5 Feb, 11:59pm EST.		 buffalo2.docx
7 Wed 23 Jan Word — Indentation, lists, and columns; Sections and Section formatting; Introduction to styles (separation of responsibility). picnic.docx, buffalo.docx
— Mon 21 Jan No Class: Martin Luther King’s Birthday Observance
6 Fri 18 Jan Word — Formatting (non-breaking punctuation, character spacing/scaling, highlighting); Paragraph features (Alignment, borders, shading); Tabs.
5 Wed 16 Jan Lab 1, Keyboard Shortcuts and Editing Documents. heart.doc
4 Mon 14 Jan Word — Document preparation (headers, footers, cover pages, and watermarks); Document options and properties; Document structure and hierachy; Formatting. ethics.docx, buffalo.docx
3 Fri 11 Jan More keyboard shortcuts; Insert, Review, and Page Layout tab tasks.
Word — What is a word processor?; Document navigation.
2 Wed 9 Jan Screenshots (using Paint and using the Windows 7 Snipping Tool); Office fundamentals (File menu); Keyboard shortcuts; Home tab tasks.
1 Mon 7 Jan Course introduction; Syllabus.
Windows tools (Calculator, Paint, Notepad, WordPad); Managing multiple windows; Start menu, taskbar, and desktop shortcuts.