Get your web license from PBS!

Click here to take the test for your Web License. Answer all the questions. At the end, print out your license (it should have your first name on it).

Computer Technology - Computer Ethics Worksheet

Here are the links for you to use for your worksheet:

Ten Commandments of Computer Ethics

Stanford Computer Ethics

Ergonomics

Internet Research -- Project Based Learning

You have been asked to research information related to Ergonomics and the office environment. Several of the office employees have missed work complaining of eye fatigue, backaches, and wrist pain, during the last six months. The Vice President is interested in making the office environment more ergonomically correct. He would like for you to report back to him tomorrow with the results of your research

Include in your presentation, whatever method you choose, the following areas of concern in the office:

· Workstation—Monitor and Document holder

· Workstation—Chair

· Workstation—Keyboard and Mouse

· Environment—Lighting

Access the Internet:

You will research the Ergonomics link at OSHA’s Web site. Once you have connected to the Ergonomics link, look for information to create a report or a table using MS Word or MS PPT to create a presentation.

Be sure that you cover the subject, but do not copy, plagiarism is as unlawful on the internet as anywhere else.

Mail Merge Holiday Project

Friday, November 17th

You need to create a database with the following fields:

• ID (Autonumber)
• Prefix
• First Name
• Last Name
• Address
• City
• State
• ZIP
• Phone
• Relationship (How do you know this person?)
• Sibling (brother or sister)

Then you are to fill in this information for 10 people. DO NOT use the exact same information that you compiled yesterday. For relationship, put cousin, friend, or however you know that person. For sibling, put the name of one of this person's brothers or sisters (if they do not have any, make up one).

Close this database, saving it if asked.

Open a Word document.

Create a Holiday themed letterhead with the following:

- Your name

- Your address

- Your e-mail address

- A graphic

- A textbox

- A bottom border

(The Holiday can be any holiday you want: (Halloween, Thanksgiving, etc...)

The picture is an example of a letterhead. Click on it to get a better view. A letterhead should be no bigger than about 1.5 inches tall. And should include your name, address, email address, etc as shown in the example.

After you finish the letterhead, you must write a full-block personal business letter.

-You do not need a return address since you have it in the letterhead.

- For the letter address and salutation, just type the following:

First Name Last Name

Address

City, State Zip Code

Dear First Name,

-The body of the letter should have the following:

-Paragraph 1: (2 sentences) Say hello to the person you are writing and ask them how they are. Ask them how their sibling is (by name). Ask them if their phone number is still how you have it (you will put the phone number in the letter).

-Paragraph 2: (3 Sentences) Describe you experience this year in school so far (your classes, your extracurricular events, etc...).

-Paragraph 3: (3 Sentences) Tell about your plans for the holidays.

-Paragraph 4: (3 Sentences) Mention how your family is doing.

While the document is open, go to Tools -> Letters and Mailing -> Mail Merge.

Select Document Type: -> Choose “Letter”

How do you want to set up your letters? -> Choose “Use the current document.”

Go through the rest of the steps of the Mail Merge Wizard.

After you have inserted all of the merge fields, click on “Preview your letters.” Use the Mail Merge toolbar to go back and forth from record to record to ensure you inserted the appropriate fields.

Select “Complete the merge.”

Click on “Edit individual letters...” --> Select “All” under Merge Records. This will create a new document called “Letters1.doc”

Select “Save As” --> Save the file to folder and name it:

HolidayLetterMerge.doc

Get to Know Access

Using this link, go thought the Microsoft Tutorial on Getting to Know Access. Answer the questions that are on your worksheet while reading through the material.

My Own Company

You are to create a company brochure using information you compile (make up). You will think of a company name, product or service to sell, logo (and design it in MSPaint), tagline (a motto), address, phone number, fax, etc.

All brochures should be two pages long and incorporate your logo. You will make this brochure in MSPublisher.

Can I Afford That Car?

Yesterday you calculated your gross annual income, gross biweekly income, federal taxes and social security taxes.

To determine your yearly take home pay, you should subtract your federal taxes and social security taxes from your gross annual income.

This will tell you how much money you will actually have to play with for the year.

Most everyone dreams (or has nightmares) of buying their first car. Your assignment for today is to determine what car you can afford on your income.

The general rule of thumb is to not spend more than 18% of your take home pay per year on a vehicle (this includes the car payment, insurance, cost of up-keep, etc.). For our purposes, we are going to lower that percentage to 15% (because we are not going to include insurance and upkeep).

Take 15% of your annual take home pay. That is how much you should be able to spend on a car per year. Divide that number by 12 and you will then have how much of a monthly payment you can afford.

With that number in mind, go to different car websites and find 2 new vehicles and one used vehicle that you can afford on your salary. I want to know the basic info about the vehicle (make, model, etc)

Put all of this information into the Excel spreadsheet that you made yesterday. Most dealership websites have a loan calculator of their own (you can use 6% as the interest rate if one is not supplied for you). If you cannot find a loan calculator, go to Bankrate and use theirs.

Email this spreadsheet to me. This is due today.

Earlier in the year you completed a Career Interest Inventory and picked a career from the list that was provided for you. Now it is time to do more career research!

This is the information that I want from you:

• Title of Career
• Years of Education Required
• Beginning (Low End) Gross Yearly Salary
• Bi-Weekly Gross Income (take your salary and divide by 26)
• Federal Taxes (go here for tax schedule)
  
• Social Security Taxes (you will pay 7.65% for SS taxes)
  

If you do not remember the career that you chose, ask me. I have a list. You need to go to http://www.salary.com and search for the salary that coincides with your chosen career. You will need to search using the career title and our zip code. These linked websites should tell you all you need to know for this assignment.

Type this in MSExcel and email the assignment to me. Save this as Personal Budget in YOUR FOLDER because you will be using this worksheet again tomorrow.

Get Well Soon, Mr. Hagood!

Mr. Hagood recently underwent an emergency appendectomy and has just gotten out of the hospital.

Using Publisher, make him a Get Well Soon card. I will compile these with the rest of my classes and Ms. Walker will be sending them to him today.

Do not use the pre-printed text that Publisher produces for you. You will need to think up your own message for your card. Remember! These will be printed out on a black and white printer, so you will have to color them with my box of markers!!

And yes, this is for a grade.

Halloween Party Project

You are planning a Halloween party for a group of fifty people.

You are to select at least eight different sandwiches (or main food items to eat), four side items, three drinks, and two desserts for a varied selection of food at the party. BTE - You can make up your own prices, as long as they are reasonable. ICT - You must use a restaurant chain that I can validate the prices for (Subway, Pizza Hut, etc...) ICT must also provide for cups, plates, utensils, and napkins.

You are allowed to spend $400 (including tax!) **(ICT: $450 budget)

You are to develop an Excel spreadsheet to list the items, quantity, price and total. Make your spreadsheet attractive by using borders, shading, clipart, and format all appropriate cells for currency. You must use formulas to add the values!!!

You also need to use Microsoft Word OR Microsoft Publisher to design an invitation to the party. Again, use color, clipart, wordart, etc. to make your invitation attractive.

Make sure that you have enough food for 50 sandwiches and enough sides, drinks and desserts (and for ICT, enough plates, etc.) to feed all 50 people.

You should use 8% as the tax rate!

Your final project should consist of:

§ Spreadsheet for party

§ Invitation

This is due TODAY.

Fortune 500 Project:

In this project you will research the following about a Fortune 500 Company:

• History - tell me about the general history of the company. How did it start?
  
• Organizational structure - who is in charge? Board of Directors? CEO?
  
• Products and/or Services - what does this company sell?
  
• Any new innovations the company has come up with
• Finances - what was this company's income for last year? What is their stock symbol and what value is it currently trading at?
  
• Future - does this company have any new ventures planned?
  

The company you pick to research must be on this list.

You will compose a three page paper minimum (and that does NOT mean two and a half) on the information you have found. The first paragraph of the paper will be telling me why you picked this particular company to research. The remainder of the paper should follow the above guidlines. All information should come from the company's website (or their corporate site) and you MUST list this source within your paper (this does not have to be MLA format).

You will design a cover-page for your paper that includes the name, address, etc of the company, along with their logo.

You will also design a letterhead for this company.

This project is due Wednesday, October 25, 2006.

Your report MUST be in either a 10, 11, or 12 point font and should be double spaced. The title page does not count towards your three page minimum. If you cannot find all the information you need from the company's website, you may use other sources, but you must list them for me.

Anyone caught plagiarizing on this assignment will receive zero credit. This assignment is worth 200 points.

Letterhead example:

Get your web license from PBS!

Click here to take the test for your Web License. Answer all the questions. At the end, print out your license (it should have your first name on it).

Career Interest Inventory: The Color Test

Getting to know your interests and work styles.

• Register with The Princeton Review. You do not have to use your full name, first initial and last name will suffice. You may use the school's address if you do not want to use your own (321 Stanley Drive).
• Take the TPR Career Quiz. (There are only 24 questions)
  
• Print out the results from your color test.

On the left hand side of the margin, careers should appear that match up to your survey results. Pick two that interest you, click onto the career and print out the material hyperlinked for each.

You will then type a paragraph explaining why you chose this career in MSWord.
You will also design an attractive cover sheet to be attached to the front of all of your information.

Staple them in the following order:

1. Cover Sheet
2. Color Test Results
3. Career Materials (2)
4. Explaination Paragraph

You should be able to finish this today - no problem.

Researching Industry Certification
ICT

What is an Industry Certification?
Industry Certification in any computer based is a very impressing Resume addition for anyone looking for a computer related career.
It is not a replacement for a college degree.

What is required?
Most certifications require TESTS, and lots of them.
Each test can range from $20 to over $100.
By the end of the testing process, it is normal to spend anywhere between $150 to $5000.

So what’s the assignment?
Research the following certifications

• CCNA
• Microsoft Office Specialist (formerly MOUS)
• MCSE
• IC³
• A+
• ACE
• MCP
• CIW

What you will tell me...
What is required of EACH certification. List the tests that are required as well as the most appropriate path to take (some certifications such as MOS have different paths. Others, such as IC³, do not).

Most certifications have multiple paths to complete any certain certification. Pick one path and TELL ME WHY you chose this particular path.

What you will use...

• Microsoft PowerPoint
• You will develope a slide show explaining each certification.
  
• This will be ONE SLIDESHOW, not 8. You should have multiple slides per certification topic. Remember, do not put so much information on one slide that it is hard to read.
• You must have images withint this slide show. There is no minimum or maximum, but with a slide show, more images is usually better.
  
• YOU WILL NOT PLAGERISE!
  

THIS IS DUE TOMORROW
No exceptions...so don’t ask...

College Application

http://admissions.uwa.edu/apponline.asp

CNN Technology News Blog Post

You are to go to CNN's Technology Site and choose an article to read. You must them write a summary of the article.

Post this summary to your blog.

This is due TODAY.

Game Questions

That's right. You are going to make a game in PowerPoint. But first, you need the questions and answers for your game, right?

Thursday I will show you how to set up a Jeopardy-style game in PowerPoint. You will need 5 categories, each with 5 questions. That is 25 questions total. You will also need the answers.

Your assignment for today is to come up with those 5 categories, 25 questions and 25 answers. You will also need to find a graphic (picture) to go with each question. You WILL finish this TODAY. You are to type the categories, questions and answers in MSWord. If you can, go ahead and find the pictures you want to use as well and paste them into your Word document. Here are some examples of finished games in PowerPoint:

This will be fun. I promise. :)

College Research

Research, Word Processing, Presentation

In this lesson, you will research colleges to find their admission requirements, costs, and curriculum.

You will:

1. Research colleges in the U.S. and abroad.
2. Compile information found about colleges into a PowerPoint presentation.
3. Create a table in Word to summarize the information found for colleges.

Activities:

1. Research colleges – 2 in Alabama, 1 in the U.S. but not in Alabama, and 1 outside the U.S. (You will have 4 colleges total)
2. Record admission requirements in a table: High School GPA, ACT/SAT score, & fees,
3. Present information to the class – name and location of each college/university, admission requirements, and tuition/residency charges.
4. Copy table to presentation as a summary of information.
5. Download the application to ONE of the colleges.

Here is a link to a good source for colleges within the United States.


WAR EAGLE!

Resume Writing
Integrated Computer Technology

A resume is much more than a piece of paper. It's a series of moving parts, that when working seamlessly, should move a potential employer to take a serious look at you. Below is a dissection of a traditional resume that provides a brief explanation of each resume element.

Contact Information
Your name, phone number(s) and email address should be prominently positioned at the top of the page. Aim for the right-hand corner, so it's easily found when paging through a stack of paper, and it's not hidden if paper clipped or stapled to other sheets.

Objective
This is your job search mission statement. It identifies to the prospective employer, in concise terms, the exact position you seek. It should include a broad definition of the job title and a mention of the skills that would be utilized in this position. You can and should tailor this to each employer you contact.

Experience/Employment History
Traditionally done in reverse chronological order, your history should be more than a list of job titles and descriptions. It should include quantifiable results like numbers and percentages to demonstrate the impact you had on an organization. –Most high school students are not going to have a plethora of experience or employment history, if any. If you have never worked before, this section could be left off – but don't forget, any employment is better than none at all!

Skills
What computer programs do you know? Are you familiar with both Mac and PC? Are you bilingual? What presentation equipment have you used? This is where you can list any special, job-related skills you may have. You can tailor this list to fit the needs of the position for which you're applying, or simply change the order of the list to present your most valuable skills first.

Education/Training/Certifications/Licenses
The schools you attended. The degrees earned. Your graduation date. Your GPA if a 3.0 or higher. Memberships in related honor societies. Related certifications and professional licenses.

Awards
When others recognize your efforts, it says a lot about you and your work. Awards can be both personal and professional, and should be listed in reverse chronological order.

Affiliations
Being a member of an association speaks volumes about your interest in your field, and can be an instant conversation starter. The same goes for affiliations with non-profit organizations. If you're a volunteer PR rep for a local food pantry, or a member of the Ad Association of Greater Milwaukee, chances are your interviewer is, too.

Here are some examples of resumes of high school students:
High School Resume Examples

Your Assignment:
Using MSWord, you are to produce a resume suitable for use in seeking employment. If you are planning on going to college, this can be in addition to college – seeking a part-time position. *Remember, many college students work. You might be one of them one day.

Safety Flyers

Using the sites I have listed below, design a flyer about safety either in Word or Publisher.

Office Safety Links
OSHA's Ergonomic Solutions

This assignment is due TODAY. You will email me your flyer when you are finished. Have fun!!!