Course Calendar - Summer 2007
Changing as we go

Date

Material to be covered

Homework Assignments:


Week of July 16th


Official Calendar

Syllabus/Introduction - What to expect from this course.

Chapter 1 - Why Computers Matter to You

We'll discuss:

  • What kind of computer should I buy?
  • What can I do with my computer?
  • How are they being used at work?
Chapter 1 Homework:
  1. #1 Page 36
  2. #6 Page 36
  3. #2 Page 37
  4. #4 Page 37
Chapter 2 - Looking at Computers: Understanding the parts

We'll discuss:

  • Input devices
  • Output devices
  • The System Unit
Chapter 2 Homework:
  1. How do Flash drives store data? You'll probably have to search the answer on-line
  2. #3 Page 73
  3. #4 Page 75

 

Chapter 5 - Using System Software: the Operating System, Utility Programs, and File Management

We'll discuss:

  • Operating Systems
  • What it does
  • Booting

Also:

  • How do I add more RAM to my computer?
  • What else can I do to increase the speed of my computer?
  • How can I put a larger or 2nd hard drive in my computer?

Even Better:

  • Using Windows Explorer
  • Using the OS Utilities like:
    • System Restore
    • Backup
    • Defrag

 

Chapter 5 Homework:
  1. #1 page 242
  2. #4 page 242
  3. #4 page 243
Week of July 23rd

Chapter 6 - Understanding & Assessing Hardware

We'll discuss:

  • Should I upgrade my computer?
  • What's the story with all the different CPUs
  • What type of Memory goes in my computer?
  • Do I have to buy the best/most expensive computer?
  • Other upgrades such as video and sound cards
  • reliability

 

Chapter 6 Homework:
  1. How does the Intel Core™ Duo processor differ than an older Intel P4
  2. for a Hewlett-Packard - Pavilion 4800+ Desktop computer
    1. What type of memory will this computer take?
    2. What is the maximum amount of memory this computer can use?
    3. How may RAM slots are there?
  3. #1 Page 283 Download worksheet here

 

Info and History about the Microprocessor

Chapter 3: Internet

We'll discuss:

  • Different Uses
  • How it works
  • Little History

Chapter 3 Homework:

  1. #3 Page 135
  2. #4 Page 136
  3. What is TCP/IP & how does it work?

 

CERT - An excellent resource to find out info on current security issues and tips on how to protect your computer.

Practice Exams:  With the new book these really don't apply any more but at least you can get an idea of the format.

Things to Review:

 

 


Computing Concepts Exam - This will be about 10 -12 short answer questions

From now on bring your Front Page book to class


We'll start with Chapter 1 in the front page book.

 

 

Front Page Homework for Chapters 1 & 2 of the Front Page Book - Due Friday

  • Read chapter 1 & 2, Please note that reading these chapters is more important than in the previous course.  Most of you will not be familiar with the material.
  • Be careful not to forget to copy the student files to a location of your choice.
  • Do the hands-on exercises in chapter 1 & chapter 2
  • And the practice exercise in chapter 2
  • You do not have to follow the text exactly, you can change the practice file by choosing your own topics for the web site but you must have all the same features.
  • I'll look at this on your web space

This will be different than your 1st Computer Course:
As you are doing the hands-on exercises, save all your work to your web space, to do this open windows explorer and type in the following in the address box:

\\storage1\dfs\webstorage\x123456x 
Where x123456x is replaced with your login ID. 

You can also type this into to the box after clicking on start, then run..

I show in class how to save to this directory for your 1st page.  After that you can right click on the  the file name in windows explorer.


Link to the Tech and Comm. page describing how to edit your personal web page

Week of July 30th

 

Continue with Front Page Chapter 1
Front Page Chapter 2

Extra if you have time and an interest:

Add some JavaScript to your web site:  The programming assignment will be to add some JavaScript to your existing webpage.

Sample page of java script.  To see code, click on the view tab, then click on source.

The radio button example, again view source to see or copy the code.

You add this by editing using the code view of the page you want to put this on.  You can experiment by just cutting and pasting the examples above in your web page.

Chapter 2:
  • Good Web Page Design
  • Create a web page in page view & look at other views
  • Editing in code view
  • Add a page to an existing site
  • Edit and format a web page
  • spell check
  • hyperlinks and lists
  • Preview, save and print
  • Navigation

Chapter 3

  • Create a site using an existing template
  • Work with themes
  • Import a web page
  • Delete a web page
  • Publish a web site & just changes
  • Find and replace tool
  • Modify the navigational structure
  • How to promote a web site
  • Meta tags
Discuss Front Page Extensions and that they are not enabled on our server.

Chapter 3 Homework - Due July 31st

  • Do the hands-on exercises & Practice Exercise #3 in Chapter 3
Front Page Chapter 4

Look at the following:

  • Adding Graphics
  • resize
  • crop
  • change format
  • hyperlink that is an image
  • image map
  • Autoshapes (same as Word)
  • Insert an audio file
  • Web Components (remember some won't work on our server)
  • Link Bars

 

Chapter 4 Homework - Due August 3rd
  • Practice exercise #2 on page 245 in chapter 4
  • Due March 23rd.
  • Note I did not assign the hands-on but you should still go through these as it teaches you how to do the homework.
Week of August 6th
Front Page Chapter 5
  • Tables
  • Frames
     

Exam II August 6th -  There will be two parts.  1st is a take home you'll do over the weekend, then a smaller in-class quiz you'll do Monday 1st thing.  For the quiz you'll have to post a simple 2 page web site with required features.

Take-Home Web page exam  This points to a practice exam

Actual Take Home web exam mail me the URL by Monday @ 6:00pm
 

Chapter 5 Homework -  Due August 6th
  • Practice exercises 1 & 2 page 305 & 306
  • These should be combined to one site.

 

 

Start with MS Access - Chapter 1

Chapter 2 - Design, Properties, Views, and Wizards

Access Exercise Files
To get the Access files, run it  by double clicking on it  The program will ask you where to save the files.  Save them on your USB drive.  Then you can start to use them.

Do Hands on-exercises 1,2, & 3 in Chapter 1

Access Assignment

Chapter 3 - Reports & Queries Access Assignment

Go over making the different kinds of queries.

Week of

August 13th

Chapter 4 - Relational Databases, Pivot Charts, and the Switchboard user interface  
Chapter 5 - Subforms and Multiple-table Queries In-class example of one-to-many relationships
Discuss subforms

Apartment Rentals Example p. 262 (page 271 in the revised edition)

Chapter 6 - Using many-to-many relationships Go over example of a database that uses many-to-many relationships & cascading modifications
  Final Review

Sample Final Exam

Last Semester's Final