Material to be covered
We are going to cover:
Chapters Chapters 1,5,6,7,
8 for computer concepts portion of the course this
August 27th - September 14th
|Syllabus/Introduction - What to expect
from this course.
Chapter 1 - Why Computers Matter to You
- What kind of computer should I
- What can I do with my computer?
- How are they being used at work?
Info and History about the Microprocessor
Chapter 1 Homework: Due 8/31
- #1 Page 36
- #6 Page 36
- #2 Page 37
- #4 Page 37
- Using System Software: the Operating System, Utility Programs, and File
- Operating Systems
- What it does
- How do I add more RAM to my
- 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?
- Using Windows Explorer
- Using the OS Utilities like:
- System Restore
Chapter 5 Homework: Due 9/12
- #1 page 242
- #4 page 242
- #4 page 243
Chapter 6 - Understanding & Assessing Hardware
- Should I upgrade my computer?
- What's the story with all the
- What type of Memory goes in my
- Do I have to buy the best/most
- Other upgrades such as video and
- How about reliability?
- September 26th, Chapter 1, 5, 6
Chapter 6 Homework: Due 9/21
- How does the Intel Core™ Duo
processor differ than an older Intel P4
- for a Dell Optiplex GX 240
- What type of memory will this
- What is the maximum amount of
memory this computer can use?
- How may RAM slots are there?
- #1 Page 283
Download worksheet here
September 17th - October 5th
Chapter 7 - Networking and Security
- Why do we even need networks?
- How does one computer talk to
- How do many computers talk to
- So now I know I need a network
at home, what should I buy and how do I set it up?
- How do wireless networks
- What should I do to secure my
home wireless network?
We'll have a quiz on Chapter 7
on Monday October 8th
- An excellent resource to find out info on current security issues and tips
on how to protect your computer.
Chapter 8 - Mobile Computing: Keeping Your Data on Hand
won't be getting to this, but feel free to ask any questions on the topic. |
Practice Exams: With the new
book these really don't apply any more but at least you can get an idea of
Things to Review:
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.
Make sure you
can get to \\storage1\dfs\webstorage, careful to use backslashes.
Link to download site:
then go to the front page 2003 student data
Front Page Homework for Chapters 1 & 2 of
the Front Page Book
- 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
- 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
This will be different than your 1st
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
Where x123456x is replaced with your login ID.
You can also type this into to the box after clicking on start, then
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
October 8th - October 26th
Front Page Chapter 1
Front Page Chapter 2
Extra if you have time and an
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.
- 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
- Create a site using an existing
- Work with themes
- Import a web page
- Delete a web page
- Publish a web site & just
- Find and replace tool
- Modify the navigational
- How to promote a web site
- Meta tags
Discuss Front Page Extensions and that
they are not enabled on our server.
Chapter 3 Homework -
- Do the hands-on exercises & Practice
Exercise #3 in Chapter 3
Front Page Chapter 4
- Adding Graphics
- 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 -
- Practice exercise #2 on page 245 in chapter 4
- Due November 7th
- Note I did not assign the
hands-on but you should still go through these as it teaches you how to
do the homework.
October 29th - November 16th
Access 2007 has been uninstalled on all the computers, hopefully everything
Front Page Chapter 5
- 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.
Sample take-Home Web page exam
Chapter 5 Homework -
- Practice exercises 1 & 2 page
305 & 306
- These should be combined to one
home web exam due Sunday @ midnight
Start with MS Access -
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 3 - Reports & Queries
Go over making the different kinds of
November 19th - December 7th
Chapter 4 - Relational Databases, Pivot Charts, and the Switchboard user
Chapter 5 - Subforms and Multiple-table Queries
||In-class example of one-to-many relationships
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 Exam Friday December 14th at
8:00am - 10:30 am
Sample Final Exam