1 / 11

CPSC 203-Week3 Lab1

CPSC 203-Week3 Lab1. Sahar Jazebi sjazebi@ucalgary.ca. Perform Compound Interest Calculation. The compound interest is the amount of money earned on a deposit during a period of time. It can be calculated using the following formula: P= C (1 + r/n)^ nt where: P = future value

vince
Download Presentation

CPSC 203-Week3 Lab1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CPSC 203-Week3 Lab1 SaharJazebi sjazebi@ucalgary.ca

  2. Perform Compound Interest Calculation • The compound interest is the amount of money earned on a deposit during a period of time. • It can be calculated using the following formula: P= C (1 + r/n)^nt where: P = future value C = initial deposit r = interest rate (expressed as a fraction e.g. 0.06 = 6%) n = # of times per year interest is compounded t = number of years invested.

  3. Continuous Compounding Interest • P = C e^(rt) • e is a mathematical constant that is used for this formula, to which you can refer in calculation using EXP(1).

  4. Sorting • Sorting names (string) • Sorting numbers • Sorting more than one column

  5. Filtering • Simple Filtering • Customized Filtering • Filtering for unique values

  6. Quiz 1 • Come at least 5 minutes early • Present your photo ID • You should write your name and sign the handout sheet • You should return back the handout at the end of the exam • Open book, open note (printed wiki material & office help)

  7. Quiz I • No internet, cellphones or PDA's • 45 minutes • Submit to Blackboard • Email to me in case something happens • http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Labs_Template/Week_3_-_Lab_2:_Lab_Quiz_on_Spreadsheets

  8. Quiz 1 Skills • Type in some basic data – used for rest of the quiz • Autofill a field(s) • Set up appropriate Field formats (Currency, Numbers, Text, etc.) • Calculate Basic Statistics (Min, Max, Average, Stdev, Median) • Use Chart Wizard to do a chart on a data set. • Customize a chart according to good chart design principles

  9. Quiz I Skills • Custom calculation using a formula • Nested If ... • Lookup table • Summarize data in a Pivot table. • Some basic text functions (examples are concatenation, count-if, etc.) • Spreadsheets design rules

More Related