Okay, here's my issue:

My students are receiving scores every week in 5 different categories. The scores are listed as "Expanding", "Competent", "Developing, and "Beginning". I need a formula that searches for these words in specific columns and translates them into a numerical value (ie., Expanding = 4, Competent = 3, etc.)

Then, once a numerical has been ascribe, the formula needs to find the average of all these numbers. This form will be updated repeatedly throughout the school year, so it'll have to account for that.

Can I get some help?

  • What does this have to do with Microsoft Word? – ale Nov 14 at 1:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.