BTE Jeopardy Questions
Directions: Type the following questions in Microsoft Word. (You can copy the questions, but you will have to find the answers on your own.) Answer the questions as well (within the Word document). These questions will be used on a later assignment.
Word Processing
1. When a line gets too long and the extra words are moved automatically to the next line as you key, this is known as what?
2. Which key backs up over characters and removes them from the document?
3. The way that the text lines up on the page is known as what?
4. The type of line spacing that leaves a blank line between each line keyed is known as what?
5. Give an example of an error that spell check would NOT identify.
6. If you have overused the word, EXCITING, in an essay, what word processing feature can suggest other words with the same meaning?
7. A printed copy of a document is known as a what?
8. Creating a word processing document would accomplish all of the following tasks EXCEPT which one?
a. developing a table of historical events
b. calculating the expenditures for candy sales
c. typing a letter to a friend
d. writing an essay for history class
9. Which of the special function keys would be used to key the sentence: "Today is Tuesday."?
10. For correct keyboarding, what is the recommended placement of fingers on the home row keys?
Spreadsheets
1. Spreadsheets are made up of which of the following
a. rows and fields
b. rows and records
c. records and columns
d. columns and rows
2. Give an example of a cell range.
3. The intersection between a row and column is called what?
4. Differentiate between a label and a value.
5. The best type of chart to show the relationship of each part to the whole is which type?
(Refers to questions 6, 7 & 8)
| | A | B | C | D |
| 1 | Magazine | Number Sold | Subscription Rate for Year | Total Amount |
| 2 | Time | 15 | $53.00 | $795.00 |
| 3 | Newsweek | 7 | $49.25 | $344.75 |
| 4 | TV Guide | 11 | $47.00 | $517.00 |
| 5 | Redbook | 6 | $12.95 | $77.70 |
| 6 | Sports Illustrated | 21 | $24.50 | $514.50 |
| 7 | Sales | |||
6. The most subscriptions were sold for which magazine?
7. The total amount of money received for each magazine is calculated in which column?
8. Where was the total amount for the sales of TV Guide calculated?
(Refers to questions 9 & 10)
| | A | B | C | D |
| 1 | Quantity | Item | Cost/Unit | Total Cost |
| 2 | 137 | Hot Dogs | $.65 | $89.05 |
| 3 | 112 | Hamburgers | $.95 | $106.40 |
| 4 | 258 | Pizza Slices | $1.10 | $283.80 |
| 5 | 39 | Tacos | $.80 | $31.20 |
| 6 | 210 | French Fries | $.50 | $105.00 |
9. If 189 more hot dogs were sold, which cells would change?
10. How could the total cost of food sold in the cafeteria for one day be calculated?
Database
1. Name one advantage of databases over spreadsheets.
2. Name one reason a student might use an electronic database? Which is NOT a benefit of a computerized database?
a. sorts records quickly and accurately.
b. communicates with other computers in remote locations
c. can help keep accurate records of almost any type
d. can find specific records that match certain conditions
3. In a database, all information about one subject is called what?
4. The four parts of a database listed in ascending order are what?
5. If books are organized from the most expensive to the cheapest, what is the sort order?
6. To find out which employee is paid the most per hour, the database would need to be:
a. Searched by experience, is equal to, 7
b. Sorted by Salary, ascending
c. Sorted by Name, descending
d. Sorted by Salary, descending
(Refers to questions 8, 9 & 10)
| Invention | Date | Inventor | Nation |
| balloon | 1783 | Montgotfier | |
| bifocals | 1780 | | US |
| cellophane | 1908 | Brandenberger | |
| dynamite | 1866 | Nobel | |
| telegraph | 1837 | Morse | US |
7. By what fields are these entries sorted?
8. Ned sorted the database and the information for "Nation" appeared as follows:
· US
·
· US
·
·
Ned used which field to sort the database?
9. How could the database be most efficiently searched to find all of the inventions of Samuel Morse?
Ethics
1. Software that can be given away free, but the author owns the copyright is called what?
2. Most commercial software prevents users from making multiple copies because it is what?
3. A virus that is activated at a certain time or date is called what?
4. A person who sneaks into your computer files with bad intentions is known as what?
5. Which is NOT a computer crime?
a. making a copy of the file that contains your social studies report
b. making a copy of your teacher's electronic grade book without permission
c. threatening to put a virus on someone's else's computer
d. changing your grade on the teacher's computer without permission
6. A program that intended to scare a computer users into thinking they have a virus is called a what?
7. Which of the following statements about software programs is considered illegal:
a. Throwing away used software diskettes
b. Using commercial software without paying for it
c. Using shareware on a trial basis
d. Distributing freeware to everyone you know
8. Mark figured out his teacher's password to unlock her electronic grade book. What is the ethically correct thing for him to do?
9. Which of the following is NOT considered unethical behavior on the Internet?
a. downloading software
b. using profanity in a chat room
c. breaking into chat room conversations uninvited
d. uploading a virus to others
10. The standards of good moral conduct or principles is known as what?
Hardware and Software
1. Which of the following will have the LEAST impact on the changing role of technology in our lives?
a. environment
b. health care
c. dangerous job
d. transportation
2. Computers are commonly used in all of the following, EXCEPT:
a. evaluating art
b. medical and health care
c. transportation
d. weather forecasting
3. The most frequently used output device is the:
a. scanner
b. monitor
c. printer
d. digital camera
4. Devices such as the keyboard, trackball, scanner, and microphones are known as:
a. input
b. output
c. processing
d. storage
5. What does the letters RAM stand for?
a. Random Access Memory
b. Read Always Memory
c. Ready Always Memory
d. Routine Access Memory
6. Which software application creates cards, flyers, calendars, and banners?
a. desktop publishing
b. database
c. word processing
d. spreadsheet
7. Which application software organizes data such as names and addresses?
a. spreadsheet
b. word processing
c. desktop publishing
d. database
8. Which of the following is NOT an example of a document?
a. a school report
b. a drawing
c. a spreadsheet
d. system software
9. Which software application calculates numbers such as in a teacher's grade book program?
a. spreadsheet
b. database
c. word processing
d. desktop publishing
10. Which of the following is NOT an output device?
a. speakers
b. monitor
c. scanner
d. disk drive
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.
Mail Merge
Friday, November 17th
You need to create a database with the following fields:
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).
Open a Word document.
Create a
- Your name
- Your address
- Your e-mail address
- A graphic
- A textbox
- A bottom border
(The
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
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.
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.
