CSC-101 Schedule for Laboratories &
Assignments
Summer
2010
Course materials can be downloaded from http://wps.prenhall.com/bp_evans_techinaction_7/136/35053/8973640.cw/index.html
Sound Byte Labs & Web Resource Projects accessed from: http://wps.prenhall.com/bp_evans_techinaction_7/136/35053/8973640.cw/index.html
PowerPoint slides
may be downloaded as a zipped file. Click here to download
Notes and important dates:
First Exam: June 9
Second Exam: July 14
Final Project: Due August 4
Final Exam: August 11
Laboratory and
assignment dates are tentative. Check this page for updates.
Week 1 (May 12)
Chapter 1 and Chapter 3
Homework:
1.
Sound Byte Labs (Chapter 3):
·
Finding
Information on the Web (#12) Submit via Word Document
2.
Chapter
3 Web Research Project (Web Project 3: File Transfer Protocol (FTP)
Submit via Word Document
3.
Effective
Searching on the World Wide Web
Preparation: Read Principles of Web Searching (Cornell University Libraries)
and Chapter 5 in the textbook
4.
Evaluating Web Sites
Preparation: Read over the tutorial for the lab, including the Widener College links;
look over the examples at Web Pages That Suck
Assignment: Complete the tutorial activity
Assignment: Start thinking about your
Final project. Due Aug 4
Week 2 (May 19) Chapter
13 and HTML Basics
HTML Demo
Homework:
1.
Sound Byte Labs
·
Where
Does Binary Show Up? (#12) Submit via Word Document
2.
Read the following Problem Solving Using Excel
#3 use the following files
· T3_TshirtProduction_Data.xls
3.
Complete the
following problems from the Problem
Solving Using Excel document
3. Filtering
SecureIT Data (use file:
T3_Employee_Data.xls)
4. Filtering RedRocks Consulting Contributions (use
file: T3_RedRocks_Data.xls)
Week 3 (May 26) Chapter 2 and Overview
of Dreamweaver
In-lab (A): Complete the workshop "A Taste of Dreamweaver"
2.
Sound Byte Labs (Chapter 2):
Binary
Numbers Interactive (11 & 12)
Submit via Word Document
Week 4 (June 2) Chapter 4
Class Demo: Importing Data from the Internet
Homework:
1.
View information on managing Web queries.
Assignment: Visit www.microsoft.com,
and use the Search feature to find information on how to manage Web queries.
Read one article, and summarize your findings. Submit via Word document
2.
Complete one of the problems
at the end of Importing Data from the Internet
3.
See if data imported from a
Web site can be updated.
Assignment: Use Excel’s Web query feature by going to CNN’s Market Web site,
money.cnn.com/data/markets.
Select the table showing the Dow, NASDAQ, S&P, and so on, import it into
Excel, and print the spreadsheet. Note the time indicated in cell B1. After
waiting a few minutes, click the Refresh All button located in the Connections
group on the Data toolbar. The time will change, and the values in Columns
C, D, and E might change as well. Once again, print the spreadsheet, and compare
the two printouts
Week 5 (June
9) Chapter 5 and Exam 1
Homework:
1.
Sound Byte Labs (Chapter 5)
· Letting Your Computer Clean Up After Itself (1-10) Submit via email
·
File
Management (1-10) Submit via email
Week 6 (June 16) Chapter 6
Image
Processing with Photoshop
Preparation:
In-lab: Complete the activities in
the Photoshop lab
Assignment: Two image process projects
included in the lab handout.
Week 7 (June 23) Lecture Databases Chapter 11
More Spread Sheet
Features
Class Demo:Demo on Spreadsheet functions Use file: ABC.xlsx
Decision analysis with SS demo (Scenario Manager,GoalSeek,Solver)
DEMO on Databases (Access)
Database Demo uses file:Sales Database
Homework:
1.
Advanced Spreadsheet Features
Read the following Problem Solving
Using Excel #4 use the following
files:
Assignment:
Complete the following problems from the Problem Solving Using Excel document
1. Spotlight Video Rentals
(use file: T4_SpotlightVideo_Data.xls)
5. Budget Constraints
Week 8 (June 30) Chapter11 continued
More database demos
1. Preparation: Read the following: Basic Skills & Tools Using Access 2007