Re: Formula Help in Access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Sorry for the confusion. Keep in mind I did not name these fields. I work
with educators who have been doing this work for a VERY long time (with
Excel). I found out the hard way you cannot just come in and change things
around.

ALGI = the State's test score (number)
AIGR = the grade from the teacher (letter)
GEOMETRY = the State's test score (number)
GEOGR = the grade from the teacher (letter)
ALGII = the State's test score (number)
AIIGR = the grade from the teacher (letter)

Using only Algebra I (the first two columns - ALGI and AIGR) this is what
happens...

John takes an Algebra I class this year and takes the State's mandated test
for the subject. He gets a score of "399" (entered into ALGI), however, he
gets a grade of "B" (entered into AIGR) from the teacher. He would NOT
receive a credit - "399" is not a "passing" score, eventhough "B" is a
"passing" grade - they both need to be "passing" in order for credit to be
granted. He gets a chance to take the Algebra I test again about 4 times
before graduation, but he just cannot get past that "399" (this has
happened). A meeting is held with the School Board and they decide to go
ahead and give him the credit so he can advance with his class. Instead of a
number he receives a "S" in the ALGI (State's score) column. So now he has a
"S" (entered in ALGI) in his score and a letter grade of "B" (entered in
AIGR). He now receives 1 math credit for Algebra I.

=IIf([ALGI]>"399""S" And [AIGR]<"E",1,0) - If "ALGI" is greater than "399"
or "S" AND "AIGR" is better than the letter "E" you get "1" credit -
otherwise you get "0" credits.

I have this formula set up for all of my grades that are required for credit
and graduation. Then for each area of learning (Math, History, English, and
Science) they all add together (i.e. John passed both the State's test (or
was credited by the school board) and the class in all of his math classes by
12th grade so Algebra I, Algebra II, Geometry added together would give him 3
verifieid credits) and that number gets calculated between the three separate
math classes and put into the "MATH" field to show how many total credits he
has to graduate with in "MATH".

The problem I am having is I cannot get it to do it in the "AIGR" for the
letter grade. They just accepted a student who came from a private school
and they let her test out of Algebra I. They gave her a "P" for passing.
They said they cannot post a letter grade since she did not earn it while
with our school district....rules! In any case I tried to put the "P" in
just like the "S" that worked on the other side, but it totally ignores it.
It shows up in the field when I type it, however, it does not add to give me
the credit. She still has a passing State test score. They are REQUIRED to
take these tests no matter how they are schooled unless exempted by the
State. So technically she should have a "420" in "ALGI" (the State's test
score) and a "P" in AIGR (our letter grade for her) and the two should add up
to 1 credit. I tried writing it like this.....

=IIf([ALGI]>"399""S" And [AIGR]<"E""P",1,0)

just like it is on the other side, however, it would not work. I even tried
to move the "P" in front of the <"E" and when I did that it gave me an #Name
error in my "MATH" field where it adds my total credits for this subject.

I hope this was not too long and explained better how it works. It really
does work great for what we use it for. If you need more info or I have
confused you please let me know. I so appreciate any help with this.

=IIf([ALGI]>"399""S" And [AIGR]<"E",1,0)+IIf([GEOMETRY]>"399""S" And
[GEOGR]<"E",1,0)+IIf([ALGII]>"399""S" And [AIIGR]<"E",1,0)

--
Deb


"Lord Kelvan" wrote:

ok so if i get you you are saying if they get a p regardless of the
number they pass so if they have 399 and a p they still pass

i dont understand your fields what data do eachof them contain

ALGI
AIGR
GEOMETRY
GEOGR
ALGII
AIIGR

where is the P stored and the letter grades and the numeric value and
what does each field mean

that and what are you trying to achieve with

[ALGI]>"399""S"

i could just be reading it wrong but it dosnt seem to make sence to me

ill be able to help you if you can give me that info

Regards
Kelvan

.

Relevant Pages

  • Re: Math skills
    ... I had algebra in the 9th grade. ... Since then, the former mandatory home-ec ... BTW, just glancing over at one of the math groups, it is funny that they ...
    (rec.martial-arts)
  • Re: Math Educators
    ... I am curious what how other State's have their Math ... Curriculum Set up. ... 9th grade - Algebra (Solving Linear Equations, Quadratic Equations, ...
    (sci.math)
  • Re: math class from Hell (aka Bantys nightmare)
    ... My daughter is in an advanced math class, and on Back to School ... It depends on what he is calling 9th grade math - Algebra I? ...
    (misc.kids)
  • Re: Math Educators
    ... I am curious what how other State's have their Math ... Curriculum Set up. ... 9th grade - Algebra (Solving Linear Equations, Quadratic Equations, ...
    (sci.math)
  • Re: How to deal with stress?
    ... I was listed as 'the worst child in 40 years of teaching with backwards letters, please have her evaluated' on my 2nd grade report card. ... In a family where everyone had a nose buried in a book, my incentive was strong and the special teacher got me over that lump. ... She can actually do that math. ... Angela used to be in Girl Scouts, but I had a lot of issues with it. ...
    (alt.support.diabetes)