CSC-101
Schedule for Laboratories & Assignments
Fall
2010
Notes
and important dates:
Quizzes: Every Monday in Lab except for the weeks of the exams
First Exam: Monday, Sept.27
Second Exam: Monday, Nov. 1
Lab Exam: Monday, Nov. 22 (regular lab time)
Final Project : Due Friday Dec. 3 at 4 pm
Final Exam: Monday, Dec. 13 from 2:30 - 5:30 p.m.
Unless
otherwise noted, labs are due the following Monday. Check this page for updates.
Week 2 (Aug. 30
- Sept. 3) Chapter 13
Lab
1A: Effective
Searching on the World Wide Web
Preparation: Read Principles of Web Searching
(Cornell University Libraries)
In-lab: Experimentation with different
search tools
Nothing to turn in
Assignment: None
Lab 1B:
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
Submit
as Word doc
Week 3 (Sept.
6- 10) Chapter
2 & HTML
Basics and Overview of Dreamweaver
HTML
Demo
Preparation:
Read the following:
Lab :
Web Authoring (Sept. 8)
In-lab (A): Complete the workshop "A Taste of Dreamweaver"
Due:
Your working site must be on the server by noon on Tues, Sept 15
Assignment: Start thinking about your
Final project.
Due:
Friday, Dec. 3(by 4 p.m.)
Week 4 (Sept. 13- 17) Overview
of Spreadsheets
and Under
the Hood
Lab :
More Web Authoring
Preparation: None
In-lab: Complete the handout on Dreamweaver tables,
imagemaps, rollovers and behaviors; post your updated site to the student
server
Due:
Updates on the server by Monday, Sept 20
Assignment: Start work on your Final project.
Due:
Friday, Dec. 3 (by 4 p.m.)
Week 5 (Sept. 20- 24)
Spreadsheets & Chapter 5
Sound Byte labs for Chapter 5 - MULTIPLE CHOICE QUESTIONS ONLY: These do not need to be turned in. However they may be tested on Exam 1
Pivot Tables Pivot
Table Demo
Pivot
Table Problem
Use File: Pivot
TableProblem.xls
Week
6 (Sept. 27- Oct. 1) Friday Oct 1 Exam 1
Decision
analysis with SS demo (Scenario Manager,GoalSeek,Solver)
Goal
Seek1.xls
CoffeeScenarioComplete.xlsx
CoffeeSolverComplete.xls
Lab: Advanced Spreadsheet Features
.
Read the
following Problem Solving
Using Excel #4 use the following
files:
·
T4_LoanAnalysis_Data.xls
·
T4_SpotlightVideo_Data.xls
T4_Scenario_Data.xls
Homework
Assignment:
Complete the following problems
from the Problem Solving Using Excel document
3.
DVD Sales Or 4. Maximizing Profit
5.
Budget Constraints
Save
this work in a folder named <your name>_SS2. Copy this folder to the
IN folder on the server. Also print
out a copy of your spreadsheets and turn them in to me
Week 8 (Oct. 11- Oct. 13)
No
Class on Oct. 15- Fall Break Chapter11
Prior
to lab:
View
Sound Byte Chapter 11 Creating an Access Database
(see below)
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.
Lab :
Data Management with Microsoft Access
Preparation: Read the the handout for this lab activity;
In-lab: Complete the database design
activity in the handout. Show it to me or the lab aid and receive the second
half of the lab activity. Save the file you create as "lastnameDB".
Due:
Oct. 18("lastnameDB" file in the IN folder on file server)
Assignment: QBE homework problems (handout
in class)
Due:
Oct. 22("lastnameHW" file in the IN folder on file server)
Week 9 (Oct
18 & (No class Oct. 20 & No class Oct. 22 - Pres. Smolla's Inauguration) Chapter 11 and Databases continued
lab: Downloading
data from the Web into Excel Choose
one of the problems at the end of the tutorial and submit the solution to
me via email. In addition print your spreadsheet and analysis to me via a
Word doc.
Lab :
Microsoft Access mini - project
Preparation: Read the
notes for this lab;
In-lab: Work on the database design
activity in the lab description.
Save the file you create as "lastnameDBProject" on the desktop.
Before you leave the lab copy your database to a CD.
Assignment: Complete the database design
activity in the lab description
Due:
Nov 1(Turn in on a CD given to me directly)
Week 11 (Nov. 1- Nov. 5)
Chapter
6 and Chapter 10
Lab : Web Programming
Preparation: Read the lab handout prior to coming to
lab.
In-lab: Complete the introductory
Javascript lab.
Due: Mon Nov. 8
Homework: Learn More About How File Compression
Works
Task: Visit How Stuff Works to see how file compression
works.
1. File compression programs work because most types of
computer files have the same information listed over and over again. What
is this repetition called?
2. To shrink files, most compression programs use a variation of which algorithm?
3. What is the expected reduction for a good-sized text file?
4. What file types have very little compression and why?
5. How does lossy compression work?
6. What would lossy compression do to a blue sky?
7. Explain why a lossy compression would not be used with a text file.
Submit your answers in a Word doc.
Week 12 (Nov. 8- Nov. 12)
Chapter 6 continued
Lab :
JavaScript Objects, Events and Actions (Nov. 10)
Preparation: Read the handout
for this lab activity;
In-lab: Complete the JavaScript activity
in the handout. Save the file you create
as "lastname_sample.html".
Due:Friday,
Nov. 19 ("lastname_sample.html" file in the IN folder on file server)
Task: Discover more about RAM and how it works.
1. What does RAM stand for?
2. Which is true? (a) Both RAM and SAM are used in computer systems. (b) Only
RAM is used in computer systems. (c) Only SAM is used in computer systems.
3. A memory chip is an integrated circuit made of millions of what?
4. For dynamic memory to work, either the CPU or the memory controller has
to come along and recharge all of the capacitors holding a 1 before they do
what?
5. Why is static RAM significantly faster than dynamic RAM?
6. Why is static RAM a lot more expensive than dynamic RAM?
7. Where are static RAM and dynamic RAM used in a computer?
8. Identify and describe three types of RAM.
Submit your answers in a Word doc.
Week 13 (Nov.
15 &Nov. 19)
No class Nov, 17
Lecture: - Digital Images and Sound
Helpful Links for Web Design and Photoshop
Lab:
Image Processing with Photoshop
Preparation: Optionally read Chapter
11 ("Light, Sound, Magic") in Fluency with Information Technology.
In-lab: Complete the activities in
the Photoshop lab
Due:
Friday Nov. 19 (copies of all processed images in IN folder in a folder
named lastname firstname Photoshop lab)
Homework: Experiment with Color Codes
Task: Find out more about hexadecimal color codes.
Assignment: Use a hexadecimal color code site to find out
more about colors. Then answer the following questions.
1. Which is a lighter color, EBECF6 or 648DC7?
2. Which is more of an orange color, F1A629 or AED673?
3. What color is 123456 most like?
4. What color is 00FFFF?
5. What color is FFFF00?
6. What color is FF00FF?
7. Do you have a color printer? If so, where have you seen the last three
colors?
Resources
Week 14 (Nov.
22) No class Nov. 24 & 26
Exam 3 (Nov. 22)
Chapter 6, Chapter 10
Lab 11: work on project
Week 15 (Dec.1 & 3) No class Mon. Nov 29 (work in lab on projects) Chapter 9 & Lecture:
- History of Computing
work on projects
Final
Project due Dec. 3 at 4 pm
Week 16 (Dec.6)
Review
for final
Final Exam Monday December 13 @ 2:30
pm
Sound Byte Labs & Web Resource Projects accessed from: http://wps.prenhall.com/bp_evans_techinaction_7/136/35053/8973640.cw/index.html