Lecture 8 SpreadsheetBasics II, Functions, Data Management

# Lecture 8 SpreadsheetBasics II, Functions, Data Management...

This preview shows pages 1–3. Sign up to view the full content.

1 Lecture # 8 Spreadsheets II: Numeric Functions and Data Management Today Questions : From notes/reading/life? Cool spreadsheet functions you discovered? 1. Introduce : Can spreadsheets help with my credit problems? 2. Explain : Numeric Functions: Logical Functions, Branching Data Management: Indexing, Look-Up, Charts 3. Demo : Spreadsheet Magic – follow along on laptop 4. Practice : Your Group solves a problem with a spreadsheet 5. Evaluate : Share and evaluate your solution 6. Re-practice : Calculate monthly payments with a spreadsheet Understand: What is the “Program” or Algorithm behind the Scenes that makes the function work? Do Homework # 3 Today Questions : From notes/reading/life? Cool spreadsheet functions you discovered? 1. Introduce : Can spreadsheets help with my credit problems? 2. Explain : Numeric Functions: Logical Functions, Branching Data Management: Indexing, Look-Up, Charts 3. Demo : Spreadsheet Magic – follow along on laptop 4. Practice : Your Group solves a problem with a spreadsheet 5. Evaluate : Share and evaluate your solution 6. Re-practice : Calculate monthly payments with a spreadsheet Understand: What is the “Program” or Algorithm behind the Scenes that makes the function work? Do Homework # 3

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Today Questions : From notes/reading/life? Cool spreadsheet functions you discovered? 1. Introduce : Can spreadsheets help with my credit problems? 2. Explain : Numeric Functions: Logical Functions, Branching Data Management: Indexing, Look-Up, Charts 3. Demo : Spreadsheet Magic – follow along on laptop 4. Practice : Your Group solves a problem with a spreadsheet 5. Evaluate : Share and evaluate your solution 6. Re-practice : Calculate monthly payments with a spreadsheet Understand: What is the “Program” or Algorithm behind the Scenes that makes the function work? Do Homework # 3 Today Questions : From notes/reading/life? Cool spreadsheet functions you discovered? 1. Introduce : Can spreadsheets help with my credit problems? 2. Explain : Numeric Functions: Logical Functions, Branching Data Management: Indexing, Look-Up, Charts 3. Demo : Spreadsheet Magic – follow along on laptop 4. Practice : Your Group solves a problem with a spreadsheet 5. Evaluate : Share and evaluate your solution 6. Re-practice : Calculate monthly payments with a spreadsheet Understand: What is the “Program” or Algorithm behind the Scenes that makes the function work? Do
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 22

Lecture 8 SpreadsheetBasics II, Functions, Data Management...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online