WMG has not given any reason for blocking the video in the North American/
Submit the following to the Case Problem Assignment 9 Excel Tutorial 3 Drop Box:
There seems to be a need for further explanation on this assignment.
First of all, note that Steps 5-8 each use a function - COUNT, MEDIAN, MAX, MIN. Step 9 uses a formula.
Step 3 requires the use of a formula as well as absolute (or mixed) reference so you can successfully copy the formula to other rows. The Overall score is to be a weighted average. That means the formula should assign different weight to the exams rather than calculate a simple average of the scores. (You are not using the AVERAGE function.) Currently the weights are 20% for exams 1, 2, and 3 and 40% for the final exam. The instructor might choose to change those weights to something else - 10%, 20%, 25%, and 45%, for example. Should the weights change, the weighted averages should update to reflect this. The weighted average formula in cells F17:F52 formula should allow for a change in the weights in cells C8:C11. For the student in row 17, the Exam 1 grade in B17 should be multiplied by the weight in cell C8(B17*C8), Exam 2 in cell C17 should be multiplied by the weight in cell C9 (C17*C9), and so on. In order to copy the formula to the other rows for the remaining students, absolute (or mixed) reference must be used to lock the reference to cell C8, C9, C10, and C11. This is done by placing a $ before the row number so it will not change when the formula is copied to other rows. The formula will begin =B17*C$8+C17*C$9 The $ before the row reference will lock the row reference when the formula is copied. No matter what row the formula is in, Exam 1 will be multiplied by the weight in C8 and Exam 2 will be multiplied by the weight in C9. (In row 50, for example, the copied formula will begin =B50*C$8+C50*C$9 See the beginning of Excel Tutorial 3 for more information on absolute (as well as relative and mixed) reference.
the red clay of grief,
the black clay of stubbornness going on after.
Clay that tastes of care or carelessness,
clay that smells of the bottoms of rivers or dust.
Each thought is a life you have lived or failed to live,
each word is a dish you have eaten or left on the table,
There are honeys so bitter
no one would willingly choose to take them.
The clay takes them: honey of weariness, honey of vanity,
honey of cruelty, fear.
This rebus -- slip and stubbornness,
bottom of river, my own consumed life --
when will I learn to read it
plainly, slowly, uncolored by hope or desire?
Not to understand it, only to see.
As water given sugar sweetens, given salt grows salty,
we become our choices.
Each yes, each no continues,
this one a ladder, that one an anvil or cup.
The ladder leans into its darkness.
The anvil leans into its silence.
The cup sits empty.
How can I enter this question the clay has asked?
Farm in Pine Island, Minnesota - James Wright
Over my head, I see the bronze butterfly,
Asleep on the black trunk,
blowing like a leaf in green shadow.
Down the ravine behind the empty house,
The cowbells follow one another
Into the distances of the afternoon.
To my right,
In a field of sunlight between two pines,
The droppings of last year's horses
Blaze up into golden stones.
I lean back, as the evening darkens and comes on.
A chicken hawk floats over, looking for home.
I have wasted my life.
Your result for The Which Chemical Element Am I Test...
- Mike Adams, the Health Ranger, July 2008 -
Found in countless species of plants, your power is vast, quick, and powerful. Entire armies have been defeated once you've laced their drinking water. Your calling card is most violent, usually causing painful convulsions that affect the entire body which can last for days until you finally tire of your victim. Death is long and drawn out as you walk away leaving them breathless and gasping.
Truth is what is; and the seeing of what is, the realization of truth. To express what we see honestly and without subterfuge: this is morality as well as art.