Q71. Consider this little bit of logic that describes a tourist's thinking process (taken from the title of a 1970s movie): “if it’s Tuesday, this must be Belgium. Otherwise, I have no idea where we are.” Sketch a flowchart that represents this flow of thought.

This was a good start to modeling.

Q72. Sketch a flowchart that represents this bit of logic: “if you are a woman then if you are over 40 you should have this test no matter what but if either parent had diabetes women should have the test no matter what. Men only need to take the test if they are overweight.”

You can find this solution above.

Q73. Sketch a flowchart that represents this bit of logic: “if cell E\$3 is greater than cell G\$12 then value is G\$12; otherwise, value is G\$12-E\$3.”

Q77. Draw a flow charts that represents "Do A until B" and "While B do A. Then do C".

Q84. If the weather is nice, plant a garden. Otherwise paint the office. For the garden, make a decision between flowers and vegetables. If you go for vegetables, buy compost, seeds, and stakes; till the soil, and hook up the irrigation. If it's flowers this year, go to the garden store and if they have 4 inch plants buy enough for the plot and plant them. If they don't then get flats of smaller plants and bring them home and let them get acclimated for a week and then plant them next week. To till the soil, if the ox is healthy, do it with the animal plow, otherwise get out the rototiller.

Q86. Sort clients into four categories promising, troubling, recalcitrant, hopeless on the basis of two tests which can be passed or failed.

Q88. Convert the following statement to “pseudo-Excel” formulas (follow the example to see what we mean by that).
Example. "If it is Tuesday, this must be Belgium, otherwise it is France" would become something like

= if(day="Tuesday","Belgium","France")

If the calculated payment (CALC_PMT) is less than the alternative monthly minimum payment (ALT_MIN_PMT) then the payment is the alternative monthly payment otherwise it is the calculated payment.

Q89. Convert the following statement to “pseudo-Excel” formulas (follow the example to see what we mean by that).
Example. "If it is Tuesday, this must be Belgium, otherwise it is France" would become something like

= if(day="Tuesday","Belgium","France")

If the current balance (BAL) is less than the calculated payment then pay the balance off, otherwise, pay the calculated payment.

Q90. Convert the following statement to “pseudo-Excel” formulas (follow the example to see what we mean by that).
Example. "If it is Tuesday, this must be Belgium, otherwise it is France" would become something like

= if(day="Tuesday","Belgium","France")

If the calculated payment is less than the alternative minimum monthly payment then pay the alternative monthly minimum unless it is more than the remaining balance in which case just pay the balance off. Otherwise pay the calculated payment.

page revision: 11, last edited: 05 Sep 2012 22:58