110 likes | 247 Views
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
E N D
CPSC 203-Week3 Lab1 SaharJazebi 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 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.
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).
Sorting • Sorting names (string) • Sorting numbers • Sorting more than one column
Filtering • Simple Filtering • Customized Filtering • Filtering for unique values
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)
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
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
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