New User Special Price Expires in

Let's log you in.

Sign in with Facebook


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


Create a StudySoup account

Be part of our community, it's free to join!

Sign up with Facebook


Create your account
By creating an account you agree to StudySoup's terms and conditions and privacy policy

Already have a StudySoup account? Login here

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

by: Megan Hageman

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

Megan Hageman
GPA 3.806
Intro to Computer Problem Solving
Cindy Grimme

Almost Ready


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

Purchase these notes here, or revisit this page.

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

Preview These Notes for FREE

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

Unlock Preview
Unlock Preview

Preview these materials now for free

Why put in your email? Get access to more of this material and other relevant free materials for your school

View Preview

About this Document

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




Popular in Intro to Computer Problem Solving

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.

Popular in Computer Science and Engineering


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


Report this Material


What is Karma?


Karma is the currency of StudySoup.

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


Buy Material

Are you sure you want to buy this material for

25 Karma

Buy Material

BOOM! Enjoy Your Free Notes!

We've added these Notes to your profile, click here to view them now.


You're already Subscribed!

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


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


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:

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

Satisfaction Guarantee: If you’re not satisfied with your subscription, you can contact us for further help. Contact must be made within 3 business days of your subscription purchase and your refund request will be subject for review.

Please Note: Refunds can never be provided more than 30 days after the initial purchase date regardless of your activity on the site.