Before you read the passage, talk about these questions.

1) What kind of information do you find in databases?

2) What do you use spreadsheets for?

Reading

Read the email from the IT department of T.B. Brown Inc. Then, read the paraphrase of the email Fill in the blanks with the correct words from the word bank.

Word bank

tables profits database calculationsclients

Employees often use databases and spreadsheets incorrectly. Use а 1________ organize large amounts of information about 2 _________. A database makes it easy to search multiple 3________ for client information. Use a spreadsheet

to perform 4_______ about sales data. Spreadsheets are also able to create graphs and charts showing 5 _________.

Vocabulary

Match the words (1-5) with the definitions (A-E).

1 _worksheet                     4 _field

2 _database           5 _formula

3 _sort

A to arrange the information in a database

В a large group of data organized in a computer

С a mathematical instruction that performs spreadsheet calculations

D a single page of a spreadsheet

E a database category that holds a type of information

Choose the word that is closest in meaning to the underlined part.

1 Sue types in a(n) symbol that performs a specific calculation

on the line.

A cell        В operator                 С worksheet

2 Please arrange the client addresses in a single collection of information in a database,

A table       В field                      С query

3 Dave adds up the values with a mathematical spreadsheet calculation.

A worksheet   В formula            С database

4 Jim organizes records in a computer program that organizes information and performs calculations.

A function      В query               С spreadsheet

5 Martha finds clients who live nearby with a search that locates all information of a specific tvoe.

A query        В field                   С operator

6 Some information in one unit of a spreadsheet that holds a piece of information is incorrect.

A table       В function                С cell

Listen and read the email from the IT Department of Т.B. Brown Inc. again.

What exactly is a spreadsheet?

Listening

Listen to a conversation between two co-workers at T.B. Brown Inc. Mark the following statements as true (T) or false (F).

1_ Sam is using a database program.

2 _ Rachel tells Sam to perform a query,

3 _Sam enters a formula that calculates profits.

Listen again and complete the conversation.

Employee 1: Rachel, I need help. I don’t understand this 1_______ program.

Employee 2: Sure. What are you trying to do?

Employee 1: I need to 2 __________ our estimated profits fornext month. But I don’t know how to do that.

Employee 2: Well, is all the 3_______ in the 4 _________ correct?

Employee 1: Yes, I’m sure it is.

Employee 2: Okay. Then just type this 5 ________ into the top cell.

Employee 1: Really? That’s all?

Employee 2: Yes. The formula calculates the estimated 6 _________ and shows them at the at the bottom of the spreadsheet.

Speaking

With a partner, act out the roles below based on Task 7. Then, switch roles.

USE LANGUAGE SUCH AS:

I don't understand this spreadsheet program.

Is the data in the ceils correct?

Type this formula into the top cell

Student A: You are a worker at ТВ. Brown Inc. Student В needs help using a spreadsheet. Talk about:

• what the problem is

• possible mistakes

• solutions

Student B: You are Student A's co-worker. You need help using a spreadsheet, Answer Student A's questions.

Make up a name for your co-worker.

Writing

6. Use the conversation from Task 8 to complete the page.

T.B. BROWN Inc. Spreadsheet Help Guide.

Question: How do I ______________________________?

1 Make sure ______________________.

2 Enter __________________________.

3 The formula calculates the customer orders and ______________________________.

 

Web design vs. web development.

1 web design

2 web development

3 navigation

4 CSS

5 Visibility

6 coding

Spring Professional Development Courses

Website Review SOLUTIONS

Website Review Solutions now offers two spring classes. These classes focus on creating websites. Web Development: Learn how to make a simple website. Create coding to build sites. Explore ways to expand functionality. Discuss improving navigation and usability Learn ways to increase a websites visibility. Web Design: Learn how to change a website's appearance. Use CSS to change a websites style. Compare the effect of different fonts and colors. Create attractive content to catch a user's attention.

E-mail Mary Shelton at [e-mail] to register for classes.

Get ready!