Computer Applications W2008
Computer Applications 11/01/07
Objective: Use the SUM, AVERAGE, MAX, MIN, and ROUND functions Identify common error values. I. Bellwork A. Page 285 (#9 & #10) Questions and Answers (See pgs 264-265) II. Classwork A. Handout Exercise 1 Chapter 10 Exercise 2 Chapter 10 – Print Exercise 3 Chapter 10
Computer Applications 10/31/07
Objectives Determine how changing data impacts results by asking “What If” questions. Use the SUM, AVERAGE, MAX, MIN, and ROUND functions. I. Bellwork A. Write a formula in good form for each of the following: Find the sum of cells A5, A6, A7, A8, & A9 Find the average of cells B7, B8, and B9 […]
Computer Applications 10/30/07
Objective: Determine how changing data impacts results by asking “What If” questions. Use the SUM, AVERAGE, MAX, MIN, and ROUND functions. I. Bellwork A. Pg 260 Fundraiser Read the directions. Answer questions 2a, b, and c II. Classwork A. Pg 285 Review Questions #1-#6 Questions and Answers B. Print Exercise 2 Chapter 9 – Handout C. […]
Computer Applications 10/29/07
Objective: enter and edit data in worksheet use formulas to perform calculations I. Bellwork A. Pg 243 #40 & #41 Question & Answer (See Pg 230) II. Classwork A. Pg 253 Exercise 10 -Print Landscape with Gridlines and Headings B. Exercise 1 Chapter 9 C. Exercise 2 Chapter 9
Computer Applications 10/26/07
Objective: Review skills introduced and applied in using spreadsheets I. Bellwork A. Pg 243 #22 a, b, c , #23 & #24 (pgs 217, 218, 219) II. Spreadsheet Vocabulary Quiz III. Classwork A. Page 253 Exercise 10
Computer Applications 10/25/07
Objective: enter and edit data in worksheet use formulas to perform calculations apply cell formatting such as cell borders patterns and color I. Bellwork A. Using Excel determine the value for each formula =4+14*5+8 =(4+14)*(10+8) =10+16/2 =(10+16)/2 =10^2+5 II. Classwork A. Exercise 8 Pages 252 B. Micro Type Pro Lesson E III. Turn in Your […]
Computer Applications 10/24/07
Objectives: enter and edit data in worksheet use formulas to perform calculations apply cell formatting such as cell borders patterns and color I. Bellwork A. Pg 243 #26-27 (See Pg 220) II. Classwork A. Handout Excersie 3 & 4 Chapter 8 B. Exercise 2 pg 246 III. Notebook Check Tomorrow
Computer Applications 10/23/07
Objectives: enter and edit data in worksheet use formulas to perform calculations apply cell formatting such as cell borders patterns and color I. Bellwork A. In cell A2 type 12 and in cell B2 type 9. Use excel to type and solve the following formulas: =A2*B2 =B2+A2*2 =A2/(B2+3) =A2+8*B2 =A2+(8*B2) II. Notebook Work A. Reading […]
Computer Applications 10/22/07
Objectives: Create and use templates Save excel data in HTML format I. Bellwork Pg 243 A. #25 a-e II. Classwork A. Pages 233-236 Widget Invoice Part 2 B. Pages 236-237 Widget Order Form III. Late Micro Type Pro A-D -2
Computer Applications 10/19/07
Objectives: Add a picture to a worksheet Creat hyperlinks to a web page and to an e-mail address Apply cell formatting such as cell borders patterns and color I. Bellwork A. Pg 242 #21 a-e 5 minutes (Answers only) II. Classwork A. Pgs 229-230 Widget Invoice Part 1 B. Pgs 231-232 Grades Part 5 C. […]