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 Investigate the Learn the Net Web Site and #13 Other Search Engines)
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)
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: Complete the homework assignment
at the end of the Photoshop
lab.
Week 7 (June 23) Lecture Chapter 7
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
1.
Advanced Spreadsheet Features
Read the
following Problem Solving
Using Excel #4 use the following
files:
Homework
Complete the following problems from the Problem Solving Using Excel document
1. Spotlight Video Rentals
(use file: T4_SpotlightVideo_Data.xls)
Week 8 (June 30) Chapter11
Task: Learn to create your own database.
View the Sound Byte for Chapter 11 Creating an Access Database. This is located on Disc 1 of the Student CDs that came with your book. Open Sound Bytes (NOT Sound Byte Labs) and click on Chapter 11 and then Creating an Access Database. Follow the directions to create a CD Collection database described below
Assignment: Using the procedures outlined in the Sound Byte, create your own CD collection database using Microsoft Access. Perform the following steps: