|
May 13, 2008
FEATURES OF HTML
Click on the link above; read the article, type out the questions and answer them in Microsoft Word.
<hr>
May 14, 2008
CREATING A WEB PAGE(see, EXAMPLE)
<hr>
Assigned March 24, 2008
My First Car
INTRODUCTION
For the past few years you've been wondering what it will be like to be able to own your own car. The moment when you are the one in the driver's seat is here and you need to purchase some wheels. Your parents told you that if you wanted a car, you'd have to 'foot the bill' yourself. You've always said you'd buy a new red Trans Am and now's your chance...well sort of. Let's see if you can afford your car and what you'll need to do!
THE TASK
You will need to gather information on 4 cars that you might like to buy. The first 3 cars are your modest choices - it is your first car after all. However, your 4th car can be your dream car - but be careful, do not choose something that only super rich people can afford. Then, you will have to figure out insurance costs and monthly payments for each of those 4 cars selected. Finally you will create a PowerPoint presentation on your new cars.
THE PROCESS
1) Find 4 cars that you might like to purchase and enter the information as shown bellow into a spreadsheet using Microsoft Excel. Make/model, year, mileage, asking price, down payment and amount to be financed. You can find used cars at autotrader.com or autobytel.com or feel free to go to any other site of your choice that deals cars.
Down payment is $2000.
Amount Financed = Asking Price - Down Payment (MUST BE A FUNCTION WITHIN THE CELL - NOT THE NUMBER!!!)
Car
|
Year
|
Mileage
|
Asking Price
|
Down Payment
|
Amount Financed
|
Toyota Land Cruiser
|
1996
|
36,000
|
$8,200
|
$1,500
|
$6,700
|
2) Add 3 columns to your spreadsheet and title one "Montly Payment" , second "Monthly Insurance Cost", and third "Total Monthly Cost"..
You can obtain monthly payments for a 5 year loan at 11% interest and sales tax 7% at: Yahoo: Loan Calculator
You can get 6 month insurance quotes at: Esurance: Auto Insurance Quote Estimate or Progressive Insurance, or Geico
Note: Your insurance quote will be based on 6 months. To get monthly insurance = (amount for 6 months) / 6
Your Excel should now look something like this:
| Car |
Year |
Mileage |
Asking Price |
Down Payment |
Amount Financed
|
Monthly Payment |
Monthly Insurance Cost
|
Total Monthly Cost
|
| Toyota Land Cruiser |
1996 |
36,000 |
$8,200 |
$1,500 |
$6,700 |
$157 |
$111 |
$268
|
Save your work and do not print. I will come to you to see and evaluate your work.
3) Now, create a 6-8 slide PowerPoint presentation to share with the class your information on your cars and the one you would most likely purchase. Be sure to include reasons why you would purchase this car and how you would go about doing it. Your power point slides should also include your job - what are you planning to become once you are done with your education. Go to:
Salary Calculator
to find out how much is the average salary for the person with the same job title today. Were you able to buy your dream car? Make sure you include your job title, salary, and conclusion on your slides.
CONCLUSION
Were you able to buy your dream car? Even if you weren't, you learned a lot about the process of buying a car. You now have a better idea about the price of new and used cars, financing, and other factors such as insurance that help in determining which car to buy. You have also had to analyze choices before making a decision.
Buying a car is NOT an easy decision for the responsible and savvy consumer, especially in today's economy. In the 1950's there were under 50 different models of cars while today there are over 225. There are many different ways to buy a car now as well. Whatever your choice was, have fun in the driver's seat but...drive safely!
Credit: Scott Bernthisel and all websites mentioned above.
March 3, 2008
(Use Microsoft Word to type the following assignment. Put the proper heading in the upper right hand corner of your document. Center the title of the lesson in your document).
Lesson 8: How Do I Use Spreadsheet Software?
-
Define the following Vocabulary Terms that appear in the box on pg. 119. Check throughout the packet for definitions, including the summary section.
-
cell
-
column
-
formula
-
formula view
-
function
-
label
-
row
-
spreadsheet
-
value
-
What-if-analysis
-
Summary pp. 130-131
-
Multiple Choice Questions (1-5) (Type out questions and correctly answer them.
-
True/False Questions (1-5) Type out questions and indicate if it is true or false.
-
Short Answer Questions (1-5) Type out questions filling in the missing words.
All About Introduction to Computers/Computer Applications - February 14, 2008
You have the option of creating one of the following activities for this class:
-
Brochure
-
Flyer
-
Newsletter
-
PowerPoint Presentation
You will discuss in your project what this class is all about, things you have learned in this class, assignments you have completed such as Microsoft Word, Microsoft PowerPoint, Internet Projects, etc. If you are in need of extra-credit, print out your assignment in color.
PowerPoint Presentations
-
Roses Are Red - December 6, 2007
-
My Own Poem - December 7, 2007
-
The Day I Was Born - December 10, 2007
-
Top 10 Reasons to Live in... - January 8, 2008
-----------------------------------------------------------------------------------------------------------------------------------------
You will create a PowerPoint presentation about 20 of your most favorite things. You will use the following categories:
-
1. color 11. subject
-
2. food 12. actor/actress
-
3. animal 13. singer/group/band
-
4. car 14. teacher
-
5. t.v. show 15. ice-cream
-
6. movie 16. game
-
7. holiday 17. athlete
-
8. song 18. girl name
-
9. sport 19. boy name
-
10. type of music 20. place in the world
Your presentation should include a title slide, table of contents slide, slide designs, slide transitions, animation schemes, sound effects, pictures, WordArt, ClipArt, etc. Each slide should also contain an explanation as to why you chose that particular item as your favorite.
Presidents of the United States (PowerPoint Presentation)-Assigned on Jan. 24, 2008
You will create a PP presentation that contains the following information on all of the men who have been president of the United States of America. Please click on the following link to help you with this assignment: POTUS. Your presentation should contain slide designs, slide transitions, animation schemes, etc. Include the following information for each president:
-
Name of President
-
When in Office
-
Nickname (if any)
-
Born - Died
-
Religion
-
Education
-
Occupation
-
Political Party
-
Other Government positions held (if any)
-
3 things he accomplished while in office
-
On the last slide, tell who you think will be president #44 and include picture of the person.
INTRODUCTION TO COMPUTERS
MID-TERM EXAM STUDY GUIDE
-
A computer is an electronic device that processes information with or without the monitor.
-
The four components essential to modern computing are input, storage, processing, and output.
-
Electronic devices are better than mechanical devices because they rarely break, they are more portable, and they process faster.
-
Hardware is the physical parts of the computer.
-
Software is a set of executable instructions.
-
The computer device that is responsible for all data processing is called microprocessor.
-
The two essential parts of the central processing unit are the Arithmetic Logic Unit and the Control Unit.
-
The ALU is responsible for arithmetic calculations and logic (>, <, =).
-
CU is responsible for storage of data, retrieval of data and translation of instructions.
-
Two basic kinds of storage computers use are temporary and long-term.
-
RAM (or main memory) is temporary storage.
-
ROM is long-term storage.
-
Download means to transfer files between computers.
-
AI is a branch of computer science that tries to simulate human intelligence.
-
The Internet is most definitely the largest network in the world consisting of numerous smaller interconnected networks.
-
A network is two or more interconnected computers that include hardware and software used to connect them including the resources they may share.
-
The most remarkable thing about the Internet is the information it contains.
-
An ISP is Internet Service Provider of the business that provides the connection to the Internet.
-
A link is interactive text within the web page that when clicked on it will take you to another page.
-
URL is Unified Resource Locator, which is just a technical term for web address.
-
Routers are computers that receive info and send it to the right destination at the best pathway at that time.
-
Packets are pieces of electronic messages that are being sent over the Internet.
-
Bandwidth is the amount of data that can pass through a particular connection in a set amount of time.
-
Three possible reasons for slow download of web pages on your computer are large file size, slow microprocessor, and little bandwidth.
-
To be a savvy web user you should pay close attention to the sources you are accessing for needed information and do not rely on only one source of information, but use several.
-
Read Only Memory is memory that cannot be infected by a virus, because nothing can be deleted from it.
-
Random Access Memory allows non-sequential (no need to rewind or fast-forward) access of data.
-
Main Memory stores data only while the program is being executed.
-
Hard disk stores instructions and data that exist permanently unless explicitly deleted.
-
Floppy disk is the smallest unit of storage out of the storage devices covered in the midterm.
-
There is no such thing as a fixed connection between your computer and a server, because information travels in different paths depending on the Internet traffic at the particular time.
-
PowerPoint is a presentation software program.
-
A letter wizard is a tutorial approach in Word for quickly creating properly designed letters.
-
A slide is the basic unit of a PowerPoint presentation.
-
Toolbars consist of buttons that access commonly used Word tools.
-
Microsoft Word is a powerful word processing program that includes many other features such as photo editing.
-
In PowerPoint every slide does not have to have a title.
-
The motherboard is the main circuit board inside of your computer that is mostly green but can be other colors as well.
-
Hard disks are much larger than main memory because of the amount of data they can hold.
-
People that use computers are called computer users.
-
PowerPoint also includes a word processing feature.
-
Binary code math works exactly the same way as our regular decimal math.
-
All computer processing requires some type of data.
-
A numbered list is a software feature that you use to create a list in which each item begins with a number in sequence.
-
People that gain unauthorized access to computer programs are called hackers.
-
A row is a vertical line of data in a spreadsheet.
-
A feature in Microsoft Word that allows you to add information at the top of the document is called a header.
-
The Line-Spacing feature within Microsoft Word allows you to create papers that are double-spaced.
-
There are 8 bits in one byte.
-
Ones and zeros are within the computer’s processing are the actual electrical charges rather than actual ones and zeros.
-
You will need to be able to answer the following:
ROM stands for Read Only Memory
RAM stands for Random Access Memory
CPU stands for Central Processing Unit
Preparing a disk for reading and writing is called formatting.
-
When writing a research paper, the best application to use would be Microsoft Word.
-
To indent your paragraphs within the Word document, you would press the Tab button on the keyboard.
-
To place your Word document title in the middle of your page, you would press the “Center” button.
-
The following items are all features of Microsoft Word: page borders, tables, line spacing, and speech-to-text.
-
Be able to identify the following items on the Microsoft Word toolbar:
· Font style
· Bold
· Center
· Bullets
-----------------------------------------------------------
Create a Business Letter (Oct. 15, 2007)
In this assignment you will use the Internet to research issues associated with homelessness and the Microsoft Word Letter Wizard to create a professional letter related to the topic. You are to write a letter to the U.S. Government expressing your feelings about how we are handling the homeless situation in this country. A good place to begin your resarch on homelessness is by reading the McKinney-Vento Act.
Your letter should include the following information:
The body requirements:
-
The body of your letter should contain a minimum of two paragraphs consisting of at least six sentences.
-
In the first paragraph, you should briefly introduce the issue of homelessness and its effect on society. Don't forget that you are writing a letter to a person, not a research paper.
-
In the second paragraph, you should elaborate on your personal feelings about the homelessness issue and if you think the government is doing enough to solve the problem. If you have any suggestions to solve the problem, discuss it in this paragraph.
| |
