MODELING: Using the white board have a selection of 5 or 6 number problems that need to have the symbols correctly placed in their statement (e.g. Alligator can help remember how to draw these signs because he always is hungry and wanting to eat the bigger number. Once the students are comfortable with determining the larger or smaller of two numbers, talk to them about the special signs that can show which number is greater. As you determine the larger number, show the alligator pointing his mouth to the bigger number. Have the rest of the class determine which number is greater. Call on two students to come forward and stand facing the classroom. Pass out cards with numbers on them to each student. The objective also focuses on being able to identify numbers to 100 that are greater or less than another number.ĭiscuss the number line and how the farther the number is from 0, the larger the number will be. The objective of this lesson is to familiarize the students with the less than and greater than symbols. After they select the stack, count out the number of chips orally to see which stack contained the largest number. The show them two stacks of Pringles potato chips (one much larger than the other). Using a stuffed alligator or green oven mitt, tell the students about your friend Mr. Posted Mon Jan 2 17:40: by Kathy Covert ( Oaks Elementary, Duarte, CA,USA Greater than Less Than Mathematics, level: Elementary If neither greater than or equal to 10000 nor greater than or equal to 5000 is TRUE, the function returns the value in G4: 0.#3532. Since 10000 has already been evaluated as FALSE, Sales greater than or equal to 5000 is essentially greater than or equal to 5000 and less than 10000. If it evaluates to FALSE, Sales greater than or equal to 5000 is evaluated next. If it evaluates to TRUE, it returns value in G2, 5%. Sales greater than or equal to 10000 is tested first. This is another example where the order of the formula matters. We then multiply the result by his Sales. If Bob's Sales are greater than or equal to 5000, his Commission is 2%. If Bob's Sales, B2, are greater than or equal to 10000 (the cursor is next to the cell reference I am pressing F4 to make it an absolute cell reference), the Commission is 5%. We want to determine Commissions for our Sales staff.īut the Commission percentage varies depending on how much they have sold. This continues for greater than or equal to 70 and 60. Since B2 greater than or equal to 90 has already been evaluated to FALSE, greater than or equal to 80 is essentially greater than or equal to 80 and less than 90. If it is FALSE, B2 greater than or equal to 80 is evaluated. If B2 greater than or equal to 90 evaluates to TRUE, the formula returns A, and we are done. In this formula, we must test B2 greater than or equal to 90 first, and then, B2 greater than or equal to 80, and so on. We use additional nested IF functions to test for C, D, and F grades. We nest an IF function by setting value_if_false to IF B2 greater than or equal to 80, return B. If Bob's score in B2 is greater than or equal to 90, return an A. We want to determine a student's grade based on their score. Nested IF functions, meaning one IF function inside of another, allows you to test multiple criteria and increases the number of possible outcomes. One IF function has one test and two possible outcomes, TRUE or FALSE.
0 Comments
Leave a Reply. |