×

### Let's log you in.

or

Don't have a StudySoup account? Create one here!

×

or

## Course Notes Week #3 Oct. 5th-9th

by: Megan Hageman

59

0

2

# Course Notes Week #3 Oct. 5th-9th CSE 1111

Megan Hageman
OSU
GPA 3.806
Intro to Computer Problem Solving
Cindy Grimme

These notes were just uploaded, and will be ready to view shortly.

Either way, we'll remind you when they're ready :)

Get a free preview of these Notes, just enter your email below.

×
Unlock Preview

Here are notes from lecture on Thursday, October 8th and from the course notes 1.9 and 1.10. Have a great weekend!
COURSE
Intro to Computer Problem Solving
PROF.
Cindy Grimme
TYPE
Class Notes
PAGES
2
WORDS
KARMA
25 ?

## Popular in Computer Science and Engineering

This 2 page Class Notes was uploaded by Megan Hageman on Thursday October 8, 2015. The Class Notes belongs to CSE 1111 at Ohio State University taught by Cindy Grimme in Summer 2015. Since its upload, it has received 59 views. For similar materials see Intro to Computer Problem Solving in Computer Science and Engineering at Ohio State University.

×

## Reviews for Course Notes Week #3 Oct. 5th-9th

×

×

### What is Karma?

#### You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!

Date Created: 10/08/15
CSE 1111 Lecture Notes Week 3 Oct 5th9th Course Notes Ch 19 Reference Functions LOOKUP Function function designed to look up values from a given list and return a corresponding value Vector form of the LOOKUP function LOOKUPookupvaue ookupvectorresutvector Lookupvaue value that is searched for in the rst vector Lookupvector range of cells used to search for the lookup value must be in ascending order Resultvector range of cells that contain values you wish to return must be the same size as the ookupvector Course Notes Ch 110 Financial Functions nterest borrowers pay for the use of money they have borrowed Rate of interest principalcurrent value of the loaninvestmentinterest fee amount Time value of money what you expect to be paid for use of your money Risk the uncertainty of getting this money back from the borrower Simple interest interest that is paid solely on the original amount invested or lent Simple interest Principalnterest rate per time periodNumber of time periods Compound interest when interest earned each period is added to the principal for purposes of computing interest for the next period when calculating compound interest it is critical that the calculations are broken up into the periods of compounding using the corresponding interest rate per period Using Financial Functions to Calculate Compound Interest 5 different functions Present ValuePV amount of money into or out of a nancial transaction at the beginning of the transaction RateRATE interest rate per period Number of PeriodsNPER the duration of the loan PaymentPMT amount that is paid in equal installments each period Future ValueFV the nal amount into or out of this transaction FVratenperpmtpvtype When cash is received it is POSITIVE When cash is paid out it is considered NEGATIVE Present Value PVrate nper pmt fv type Number of periods NPERrate pmt pv fv type Interest rate per Period RATEnper pmt pv fv type Periodic Payment PMTrate nper pv fv type Lecture Notes Oct 6 CLASS CANCELLED Lecture Notes Oct 8 Reference Functions LOOKUP function Use to look up a value based on speci c criteria LOOKUPookupvaue ookupvector resultvector Lookupvaue the criteria Lookupvector range of the stated criteria Resultvector range with the values you re trying to nd The values can be from a row or a column Algorithm will give you the greatest value that does NOT EXCEED the value searched for Won t work if the look up vector is NOT in ascending order Financial Functions Simple vs Compound interest Simple based on original amount Compound based on latest amount Func ons PV present value FV future value PMT payment each period RATE interest rate per period NPER number of payment periods PVltrategt ltnpergt ltpmtgt ltfvgt Outgoing H Incoming FVltrategt ltnpergt ltpmtgt ltpvgt PMTltrategt ltnpergt ltpvgt ltfvgt RATEltnpergt ltpmtgt ltpvgt ltfvgt NPERltrategt ltpmtgt ltpvgt ltfvgt make sure all units match Type argument at the end of functions 0 if payment made at the end of the period 1 if payment made at the beginning of the period Assume it is at the end unless speci ed

×

×

### BOOM! Enjoy Your Free Notes!

×

Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'

## Why people love StudySoup

Bentley McCaw University of Florida

#### "I was shooting for a perfect 4.0 GPA this semester. Having StudySoup as a study aid was critical to helping me achieve my goal...and I nailed it!"

Anthony Lee UC Santa Barbara

#### "I bought an awesome study guide, which helped me get an A in my Math 34B class this quarter!"

Jim McGreen Ohio University

#### "Knowing I can count on the Elite Notetaker in my class allows me to focus on what the professor is saying instead of just scribbling notes the whole time and falling behind."

Parker Thompson 500 Startups

#### "It's a great way for students to improve their educational experience and it seemed like a product that everybody wants, so all the people participating are winning."

Become an Elite Notetaker and start selling your notes online!
×

### Refund Policy

#### STUDYSOUP CANCELLATION POLICY

All subscriptions to StudySoup are paid in full at the time of subscribing. To change your credit card information or to cancel your subscription, go to "Edit Settings". All credit card information will be available there. If you should decide to cancel your subscription, it will continue to be valid until the next payment period, as all payments for the current period were made in advance. For special circumstances, please email support@studysoup.com

#### STUDYSOUP REFUND POLICY

StudySoup has more than 1 million course-specific study resources to help students study smarter. If you’re having trouble finding what you’re looking for, our customer support team can help you find what you need! Feel free to contact them here: support@studysoup.com

Recurring Subscriptions: If you have canceled your recurring subscription on the day of renewal and have not downloaded any documents, you may request a refund by submitting an email to support@studysoup.com