Computer Applications – Mrs. Miñoso

Chapter 8 Lecture Notes

 

Problem #1: Students pass if their grades are above 60%.  In the last column use an if statement to have the computer decide whether the student passed or failed this class. Also use functions to determine what the lowest grade and the highest averages are for this class.

 

A

B

C

D

E

F

1

 

Test

Test

Test

Average

Pass/Fail

2

Amy

98%

98%

88%

95%

 

3

Brian

25%

89%

78%

64%

 

4

Mary

56%

87%

85%

76%

 

5

Benny

88%

84%

65%

79%

 

6

Cindy

78%

85%

77%

80%

 

7

Sophie

95%

96%

44%

78%

 

8

Chris

78%

25%

65%

56%

 

9

David

99%

77%

30%

69%

 

10

 

 

 

 

 

 

11

 

 

 

Lowest Grade

 

 

12

 

 

 

Highest Grade

 

 

 

Problem #2: Use formulas to calculate Gross Pay (Hourly Pay * Hours Worked), Taxes (Gross Pay by the Tax Amount),  Net Pay (Gross Pay – Taxes).  The bonus is determined based on the employees position.  If the employee is a Sales Clerk they will receive 10% of their gross pay in the form of a bonus.  If the employee is a Manager they will receive 20% of their gross pay as a bonus.

 

A

B

C

D

E

F

G

H

1

Tax Amount

12%

 

 

 

 

 

 

2

 

 

 

 

 

 

 

 

 

3

Employee

Hourly Pay

Hours Worked

Position

Gross Pay

Taxes

Net Pay

Bonus

4

Amy

 $               5.50

40
Sales Clerk

 

 

 

 

5

Brian

 $               6.50

35

Sales Clerk

 

 

 

 

6

Mary

 $             10.00

40

Manager

 

 

 

 

7

Benny

 $               9.50

30

Sales Clerk

 

 

 

 

8

Cindy

 $             10.50

45

Manager

 

 

 

 

9

Sophie

 $             11.50

40

Manager

 

 

 

 

10

Chris

 $               6.40

35

Sales Clerk

 

 

 

 

11

David

 $               5.80

30

Sales Clerk

 

 

 

 

12

 

 

 

 

 

 

 

 

13

 

 

 

Total

 

 

 

 

14

 

 

 

 

 

 

 

 

 

Problem #3: Use formulas to calculate the Taxes that must be paid on each of the fruit sales.  Taxes are calculated by  Multiplying the tax amount by the revenue for each fruit.  The profit, is calculated by subtracting the taxes from the revenue.  2003’s price will be calculated by the following: If the quantity sold is greater than 1,700 then the sale price will be increased by 10% if it is less than 1,700 the sale price will remain the same.

 

A

B

C

D

E

F

G

1

Tax Amount

6.50%

 

 

 

 

 

2

 

 

 

 

 

 

 

3

 

Sale Price

Quantity

Revenue

Taxes

Profit

2003 Price

4

Apples

 $           0.50

            1,000

 $           500.00

 

 

 

5

Kiwi

 $           0.65

            2,500

 $        1,625.00

 

 

 

6

Cherries

 $           0.25

            2,000

 $           500.00

 

 

 

7

Mango

 $           0.95

            1,500

 $        1,425.00

 

 

 

8

 

 

Total