CS131: Software for
Personal Computing
(Summer 2008)
Instructor: Michael Moeng
Email: moeng@cs.pitt.edu
Office: 5802 Sennott Square
Class Times: Monday and Wednesday 2:30pm – 4:15pm
Class Room: 5502 Sennott Square
Office Hours: Tuesday and Thursday 4:00pm - 6:00pm
Announcements
07/28: Last Announcements:
·
You can still turn in work you’ve missed, up until
Wednesday
·
Test format will be:
1.
Written, 20 questions from the review sheet—closed notes/computer,
followed by
2.
Hands on, I’ll give this to you once you hand in the
written portion—this is done on a lab computer
·
The Hands on portion
o
This will be a printed Word Document—the objective is to create
a close approximation and then email me your version
o
This will cover the objectives in the book, labs and homeworks for Word—these are your best study aid.
o
Don’t exactly duplicate—where I have my name, I expect
yours; where I have my Pitt username, I expect yours.
o
Anything I specifically mention you should definitely
duplicate
o
Use the features we’ve covered; for example, a page number
should use the page number feature, not a text box.
07/25: The Review
Sheet is up, good luck studying.
07/25:
The hands on part of the final will cover Word, so be sure to review the labs
and homework for those chapters.
Course Schedule
Day |
Topic |
Slides |
Activities |
Homework |
May 12 |
·
Introductions ·
Campus Computing Services (Accounts, Computing
Labs, &others) ·
Free
software for Pitt students ·
Using Pitt
wireless and ·
Finish introductory materials ·
Windows Intro |
·
Book Introduction: ·
Taking Screenshots ·
Compressing Files ·
Overview of email+attachments |
·
Homework assignments will be listed here when assigned
and on the due date. |
|
May 14 |
·
Some Basic Keyboard shortcuts ·
Working with AFS ·
Common
problems when using AFS client |
·
Lab 1:
AFS. Hand in by end of
class. ·
Download a copy of the AFS
Client if you plan to work on a laptop or at home. |
·
HW1: |
|
May 19 |
Email Clients ·
Getting started with Outlook ·
Thunderbird setup: ·
Gmail |
·
Lab 2:
Outlook. Hand in by end of
class |
·
HW 1 Due ·
Start Homework
2. Use the right subject
header in the assignment! |
|
May 21 |
Web Browsers ·
Internet Explorer ·
Firefox ·
Tabbed Browsing |
·
Lab 3:
Web Browsing. Hand in by
the end of class. |
·
HW 2 Due ·
Start Homework
3. Due 05/28. |
|
May 26 |
·
Memorial Day, no class |
·
None |
·
None |
·
None |
May 28 |
·
Intro to Microsoft
Word |
·
Word Slides, |
·
HW 3 Due. ·
Start Homework
4. Due 06/02 |
|
June 02 |
·
More Word |
·
Word Slides, Chapters 6-7 |
·
Lab 5:
Word2, |
·
HW 4 Due. ·
Start Homework
5. Due 06/04 |
June 04 |
·
Forwarding mail: accounts.pitt.edu ·
More Word |
·
Word Slides, |
·
HW 5 Due. ·
Start Homework 6. Due 06/09 |
|
June 09 |
·
Intro to MS Excel |
·
Excel Slides, |
·
HW 6 Due ·
Start
Homework 7. Due 06/11 |
|
June 11 |
·
More Excel |
·
Excel Slides, |
·
Homework 7 Due. ·
Start Homework 8. Due 06/16 |
|
June 16 |
·
More Excel |
·
Excel Slides, |
·
Homework 8 Due. ·
Start Homework 9/ Due 06/18 |
|
June 18 |
·
Review |
·
NONE |
·
None |
|
June 23 |
·
Midterm |
·
Covers All material for the first six weeks, emphasis on
Word and Excel ·
Short Answer |
·
Closed book/note/ ·
All questions (roughly 40-50) will be drawn from the
review sheet |
If it is brought to my attention that a question is too
vague or unclear, I will pull it from the test, and post the reworded
question and answer under announcements |
June 25 |
·
Unix |
·
Start Homework
10: Unix.
Due 06/30. |
||
June 30 |
·
FTP |
·
Homework 10 Due. ·
Start Homework
11. Due 07/09. |
||
July 02 |
·
Class Cancelled |
·
None |
·
None |
·
None |
July 07 |
·
Intro to MS Powerpoint |
·
Start
Homework 12. Due 07/09, |
||
July 09 |
·
More Powerpoint |
·
Homework 11 Due, ·
Homework 12 Due |
||
July 14 |
·
More Powerpoint |
·
Homework 13 Due ·
Start
Homework 14, due 07/16 |
||
July 16 |
·
Intro to MS Access |
·
Homework 14 pushed to 07/21 ·
Homework
15, Due 07/21 |
||
July 21 |
·
More Access |
·
Homework 14 Due ·
Homework 15 Due ·
Homework
16, due 07/23 |
||
July 23 |
·
More Access |
·
Homework 16 Due ·
Homework 17 is optional: |
||
July 28 |
·
Review |
·
TBA |
·
TBA |
|
July 30 |
·
Final |
·
TBA |
·
TBA |
·
TBA |
Old
Announcements
07/15:
I messed up a link for Homework 14 (it’s fixed now)—because of this, the
homework is postponed until next Monday.
Homework 15 will also be due Monday as we move back to the regular
schedule.
07/04:
I’m pushing back the deadline for Homework 11 to July 9th so you all
have more time to work on it. The first Powerpoint chapter is pretty light on material so it should
not interfere much.
06/23:
Midterm review clarifications (will not show up)
91: A(n) __________ format changes the appearance of a cell range based on
certain criteria.
The intent was to get you to
think of the conditional formatting we did in Excel. Since I forgot to put down Excel, and also
worded it a bit strangely, it isn’t all that clear.
06/04:
If you run into an error while zipping your files, make sure you aren’t trying
to compress a temporary file. Office
files create temporary files when they are open (they look like ~$name). To get rid of this temp file, just close
office.
05/29:
The office has gotten more crowded and isn’t suitable for office hours. The new office hour policy will be for me to
wait in the office, but move to the regular classroom lab if someone shows up.
05/28:
The file type issue seems to be due to internet explorer. I will try and get this fixed but in the
meantime using firefox seems to work fine. *Update* This issue should now be resolved.
05/19:
If the slides open up as a .zip file, save the file to disk. Then change the file extention
from .zip to .pptx
For example, rename blah.zip to
blah.pptx. For documents, save it as
blah.docx
05/12:
Welcome to class, grab the Course
Syllabus if you missed it in class.