ICS 101 Final Exam Questions and
Answers21
Different levels of health informatics such as consumer level - ANSWERS -Engaging the public in
managing their own health
Ex: webmd.com, "HEALTHe Dubai"
Examples of telemedicine - ANSWERS -1.) Real-time (Synchronous)
2.) Store-and-forward (Asynchronous)
Ex: HMSA Online Care, STAN (State of Hawaii Telehealth Access Network) and Inter-Island Eye
Telesurgery on the Big Island, Teleradiology (Radiology Digital Archiving)
Change blindness - ANSWERS -Humans don't see very well
How does IF work? - ANSWERS --Identify conditions and determine actions
-Ex: IF it is hot, I will wear beach attire to school. Otherwise, I will wear business casual attire.
-Ex: =IF(A1>=B26,"ICS101B",IF(A8>=B27,"ICS101", 101))
How does COUNTIF work? - ANSWERS -Count a range if criteria is met
How does SUMIF work? - ANSWERS -Sum a range if criteria is met
How does AVERAGEIF work? - ANSWERS -Average of a range if criteria is met
How does AND work? - ANSWERS --Identify all conditions being true
,-Ex: If it is sunny AND hot, I will wear beach attire to school. Otherwise, I will wear business
casual attire to school.
How does NOT work? - ANSWERS --Identify conditions not being true
-Ex: If it is NOT cold, I will wear beach attire to school. Otherwise, I will wear business casual
attire to school.
How does OR work? - ANSWERS --Identifies any condition being true (Single conditions is true)
-Ex: If it is sunny OR hot, I will wear beach attire to school. Otherwise, I will wear business casual
attire to school.
Excel syntax - ANSWERS -
Amortization schedules - ANSWERS --Table detailing payments on a loan
-Essentially calculates how much of each of your payments goes toward the principal (loan) and
the amount that is interest
-Typically used with mortgages, car loans, and business loans
Includes Loan Amount, Period, Term, Interest Rate, Payment
-
Amortization Schedule Concepts - ANSWERS -Loan (Present Value): Loan Amount
Rate: Interest rate; Calculated per periodic payment
Term: Length of the loan (typically in years)
Payments Per Year: # of payments each year (i.e. monthly, quarterly)
Periodic Payment: Payment amount for each recurring payment (includes interest and principal
portion of the payment)
Period: Recurring payment
, Comparing loans - ANSWERS --Create 2 amortization schedules and compare them
-Identify when the loans would cost an equal amount based on APR and cash back
-Determine when you can pay off the loan to see which case is better
-Use logic statements to help you with your decision
Arguments/lists - ANSWERS -PER, NPER, RATE, PV
PER - ANSWERS -
NPER - ANSWERS -Number of Periods
-Total number of periods (7 year loan with monthly payments, has 84 periods)
RATE (APR) - ANSWERS -
PV - ANSWERS -PV = Loan Amount
Functions - ANSWERS -PMT, PPMT, IPMT
PMT - ANSWERS -PMT = PPMT + IPMT
PPMT - ANSWERS -Principal Payment
-Amount of each periodic payment that goes toward the loan
IPMT - ANSWERS -Interest Payment
-Amount of each periodic payment that is interest
Answers21
Different levels of health informatics such as consumer level - ANSWERS -Engaging the public in
managing their own health
Ex: webmd.com, "HEALTHe Dubai"
Examples of telemedicine - ANSWERS -1.) Real-time (Synchronous)
2.) Store-and-forward (Asynchronous)
Ex: HMSA Online Care, STAN (State of Hawaii Telehealth Access Network) and Inter-Island Eye
Telesurgery on the Big Island, Teleradiology (Radiology Digital Archiving)
Change blindness - ANSWERS -Humans don't see very well
How does IF work? - ANSWERS --Identify conditions and determine actions
-Ex: IF it is hot, I will wear beach attire to school. Otherwise, I will wear business casual attire.
-Ex: =IF(A1>=B26,"ICS101B",IF(A8>=B27,"ICS101", 101))
How does COUNTIF work? - ANSWERS -Count a range if criteria is met
How does SUMIF work? - ANSWERS -Sum a range if criteria is met
How does AVERAGEIF work? - ANSWERS -Average of a range if criteria is met
How does AND work? - ANSWERS --Identify all conditions being true
,-Ex: If it is sunny AND hot, I will wear beach attire to school. Otherwise, I will wear business
casual attire to school.
How does NOT work? - ANSWERS --Identify conditions not being true
-Ex: If it is NOT cold, I will wear beach attire to school. Otherwise, I will wear business casual
attire to school.
How does OR work? - ANSWERS --Identifies any condition being true (Single conditions is true)
-Ex: If it is sunny OR hot, I will wear beach attire to school. Otherwise, I will wear business casual
attire to school.
Excel syntax - ANSWERS -
Amortization schedules - ANSWERS --Table detailing payments on a loan
-Essentially calculates how much of each of your payments goes toward the principal (loan) and
the amount that is interest
-Typically used with mortgages, car loans, and business loans
Includes Loan Amount, Period, Term, Interest Rate, Payment
-
Amortization Schedule Concepts - ANSWERS -Loan (Present Value): Loan Amount
Rate: Interest rate; Calculated per periodic payment
Term: Length of the loan (typically in years)
Payments Per Year: # of payments each year (i.e. monthly, quarterly)
Periodic Payment: Payment amount for each recurring payment (includes interest and principal
portion of the payment)
Period: Recurring payment
, Comparing loans - ANSWERS --Create 2 amortization schedules and compare them
-Identify when the loans would cost an equal amount based on APR and cash back
-Determine when you can pay off the loan to see which case is better
-Use logic statements to help you with your decision
Arguments/lists - ANSWERS -PER, NPER, RATE, PV
PER - ANSWERS -
NPER - ANSWERS -Number of Periods
-Total number of periods (7 year loan with monthly payments, has 84 periods)
RATE (APR) - ANSWERS -
PV - ANSWERS -PV = Loan Amount
Functions - ANSWERS -PMT, PPMT, IPMT
PMT - ANSWERS -PMT = PPMT + IPMT
PPMT - ANSWERS -Principal Payment
-Amount of each periodic payment that goes toward the loan
IPMT - ANSWERS -Interest Payment
-Amount of each periodic payment that is interest
