Question

google sheets #9 - used books and multiplication
university and online stores purchase used textbooks from students based on condition. this is
an excellent way to help keep down the cost for college and help others. a student wants to use a
spreadsheet to determine how much money the bookstore will pay for last semester’s books.
in class: enter the following into a google sheet.

book title	original price	condition	used price
insects: delving into entomology	$134.50	2
introduction to king arthur	$39.99	1
wildlife management and conservation	$90.02	3
modern american literature	$129.99	3
farm as ecosystem	$37.99	2
frankenstein	$9.99	5
a christmas carol	$7.99	4

to do:

1. in a new google sheet enter the same headings in row 1. make sure they are bolded and

frozen.

1. find the title of 10 books online and their cost, putting that info in column a and b. amazon

is a great resource for this. fun fact: amazon started as a company that sold only books.

1. save the spreadsheet titling it used books _yourlastname
2. the bookstore buys used textbooks at a percentage of the original price based on their

condition as follows:

condition	percentage
2	50%
3	25%
4	10%
5	5%

1. the used price is calculated by multiplying the original price by the condition percentage as a

decimal. sum=(originalprice*%) - important: make sure you click original price data
cell, don’t just enter the number!

• don’t forget you need to use the percentage as a decimal when creating a formula.
• you cannot autofill the used price because the condition percentages are different.

1. calculate the total for the used books one two lines beneath the tenth book.

Explanation:

To solve the problem of calculating the used price for each book and the total, we follow these steps:

Step 1: Understand the Percentage for Each Condition

First, we convert the condition percentages to decimals:

• Condition 1: \( 75\% = 0.75 \)
• Condition 2: \( 50\% = 0.50 \)
• Condition 3: \( 25\% = 0.25 \)
• Condition 4: \( 10\% = 0.10 \)
• Condition 5: \( 5\% = 0.05 \)

Step 2: Calculate the Used Price for Each Book

We use the formula \( \text{Used Price} = \text{Original Price} \times \text{Condition Percentage (Decimal)} \) for each book.

Let's calculate the used price for each book:

1. The Farm as Ecosystem:

• Original Price: \( \$28.20 \)
• Condition: 5 (Percentage: \( 0.05 \))
• Used Price: \( 28.20 \times 0.05 = 1.41 \)

1. Insects: Delving into Entomology:

• Original Price: \( \$134.50 \)
• Condition: 2 (Percentage: \( 0.50 \))
• Used Price: \( 134.50 \times 0.50 = 67.25 \)

1. Introduction to King Arthur:

• Original Price: \( \$39.99 \)
• Condition: 1 (Percentage: \( 0.75 \))
• Used Price: \( 39.99 \times 0.75 = 29.9925 \approx 29.99 \)

1. Wildlife Management and Conservation:

• Original Price: \( \$90.02 \)
• Condition: 3 (Percentage: \( 0.25 \))
• Used Price: \( 90.02 \times 0.25 = 22.505 \approx 22.51 \)

1. Modern American Literature:

• Original Price: \( \$129.99 \)
• Condition: 3 (Percentage: \( 0.25 \))
• Used Price: \( 129.99 \times 0.25 = 32.4975 \approx 32.50 \)

1. Farm as Ecosystem:

• Original Price: \( \$37.99 \)
• Condition: 2 (Percentage: \( 0.50 \))
• Used Price: \( 37.99 \times 0.50 = 18.995 \approx 19.00 \)

1. Frankenstein:

• Original Price: \( \$9.99 \)
• Condition: 5 (Percentage: \( 0.05 \))
• Used Price: \( 9.99 \times 0.05 = 0.4995 \approx 0.50 \)

1. A Christmas Carol:

• Original Price: \( \$7.99 \)
• Condition: 4 (Percentage: \( 0.10 \))
• Used Price: \( 7.99 \times 0.10 = 0.799 \approx 0.80 \)

Step 3: Sum the Used Prices

Now, we sum up all the used prices:
\[
1.41 + 67.25 + 29.99 + 22.51 + 32.50 + 19.00 + 0.50 + 0.80
\]

Let's calculate the total:
\[
1.41 + 67.25 = 68.66 \\
68.66 + 29.99 = 98.65 \\
98.65 + 22.51 = 121.16 \\
121.16 + 32.50 = 153.66 \\
153.66 + 19.00 = 172.66 \\
172.66 + 0.50 = 173.16 \\
173.16 + 0.80 = 173.96
\]

Final Answer

The total used price for all the books is approximately \(\$173.96\).

Answer:

To solve the problem of calculating the used price for each book and the total, we follow these steps:

Step 1: Understand the Percentage for Each Condition

First, we convert the condition percentages to decimals:

• Condition 1: \( 75\% = 0.75 \)
• Condition 2: \( 50\% = 0.50 \)
• Condition 3: \( 25\% = 0.25 \)
• Condition 4: \( 10\% = 0.10 \)
• Condition 5: \( 5\% = 0.05 \)

Step 2: Calculate the Used Price for Each Book

We use the formula \( \text{Used Price} = \text{Original Price} \times \text{Condition Percentage (Decimal)} \) for each book.

Let's calculate the used price for each book:

1. The Farm as Ecosystem:

• Original Price: \( \$28.20 \)
• Condition: 5 (Percentage: \( 0.05 \))
• Used Price: \( 28.20 \times 0.05 = 1.41 \)

1. Insects: Delving into Entomology:

• Original Price: \( \$134.50 \)
• Condition: 2 (Percentage: \( 0.50 \))
• Used Price: \( 134.50 \times 0.50 = 67.25 \)

1. Introduction to King Arthur:

• Original Price: \( \$39.99 \)
• Condition: 1 (Percentage: \( 0.75 \))
• Used Price: \( 39.99 \times 0.75 = 29.9925 \approx 29.99 \)

1. Wildlife Management and Conservation:

• Original Price: \( \$90.02 \)
• Condition: 3 (Percentage: \( 0.25 \))
• Used Price: \( 90.02 \times 0.25 = 22.505 \approx 22.51 \)

1. Modern American Literature:

• Original Price: \( \$129.99 \)
• Condition: 3 (Percentage: \( 0.25 \))
• Used Price: \( 129.99 \times 0.25 = 32.4975 \approx 32.50 \)

1. Farm as Ecosystem:

• Original Price: \( \$37.99 \)
• Condition: 2 (Percentage: \( 0.50 \))
• Used Price: \( 37.99 \times 0.50 = 18.995 \approx 19.00 \)

1. Frankenstein:

• Original Price: \( \$9.99 \)
• Condition: 5 (Percentage: \( 0.05 \))
• Used Price: \( 9.99 \times 0.05 = 0.4995 \approx 0.50 \)

1. A Christmas Carol:

• Original Price: \( \$7.99 \)
• Condition: 4 (Percentage: \( 0.10 \))
• Used Price: \( 7.99 \times 0.10 = 0.799 \approx 0.80 \)

Step 3: Sum the Used Prices

Now, we sum up all the used prices:
\[
1.41 + 67.25 + 29.99 + 22.51 + 32.50 + 19.00 + 0.50 + 0.80
\]

Let's calculate the total:
\[
1.41 + 67.25 = 68.66 \\
68.66 + 29.99 = 98.65 \\
98.65 + 22.51 = 121.16 \\
121.16 + 32.50 = 153.66 \\
153.66 + 19.00 = 172.66 \\
172.66 + 0.50 = 173.16 \\
173.16 + 0.80 = 173.96
\]

Final Answer

The total used price for all the books is approximately \(\$173.96\).