A class about spreadsheets and their usage. Intended audience: beginners who are new to spreadsheets. Only basic concep

1. Two very useful features of spreadsheets are: 1. Ability to replicate formulas for each row (e.g., student) and each column (e.g., assignment, lunch money, etc.) without having to retype the formula or enter the column or row of numbers in a calculator. 2. Ability to predict (and manipulate) a total project cost, year-end earnings, final course grades, total field trip cost, etc. by changing individual numbers in the chart. For example, what will happen to my ant farm project�s final cost if each group gets two containers of live ants but only half a bushel of soil? (Sound like a story problem? It is! Just type in the new numbers and watch the bottom line change.) have copies of OO available for hand out? The Open Cd?Two very useful features of spreadsheets are: 1. Ability to replicate formulas for each row (e.g., student) and each column (e.g., assignment, lunch money, etc.) without having to retype the formula or enter the column or row of numbers in a calculator. 2. Ability to predict (and manipulate) a total project cost, year-end earnings, final course grades, total field trip cost, etc. by changing individual numbers in the chart. For example, what will happen to my ant farm project�s final cost if each group gets two containers of live ants but only half a bushel of soil? (Sound like a story problem? It is! Just type in the new numbers and watch the bottom line change.) have copies of OO available for hand out? The Open Cd?

2. example of accountants paychecks � different deductions and totals example of accountants paychecks � different deductions and totals

3. 2. Components of a Spreadsheet

4. Columns Are vertical areas labeled by letters at the top. To highlight an entire column, click on the letter at the top of the column. In Excel, the number of columns is limited to 256. In Open Office, the maximum amount of columns is 245.In Open Office, the maximum amount of columns is 245.

5. Rows Are horizontal areas labeled by numbers To highlight an entire row, click on the number at the start of the row. In Excel, each spreadsheet can have a maximum of 65,536 rows. In both Excel and Open Office, each spreadsheet can have a maximum of 65,536 rows.In both Excel and Open Office, each spreadsheet can have a maximum of 65,536 rows.

6. Cell Intersection of a column and a row Labeled by joining the column letter followed by the row number May contain numbers, words or a combination of the two (e.g. An address) Cell C8 has 127 as its contents and the name box displays the cell's name. Use the teaching program to run a spreadsheet as the class watches? Use the teaching program to run a spreadsheet as the class watches?

7. Cell from another sheet You may call a cell from another sheet and display it on the current one. In Excel, the syntax is: =sheetname!cellname To display a cell from another sheet: either type in the name of the cell and sheet or type �=� then click on the sheet's tab, click on the desired cell then press enter. Show example on screen... Use the teaching program to run a spreadsheet as the class watches? Have presentation refer to Open Office or Excel? If separated, then have handout have equivalents for the other. In Open Office, the syntax is: sheetname.cellname To display a cell from another sheet: either type in the name of the cell and sheet or type �=� then click on the sheet's tab, click on the desired cell then press enter. Show example on screen... Use the teaching program to run a spreadsheet as the class watches? Have presentation refer to Open Office or Excel? If separated, then have handout have equivalents for the other. In Open Office, the syntax is: sheetname.cellname

8. Show example in Excel. Show example in Excel.

9. A formula is an equation that performs operations on worksheet data. Formulas can perform mathematical operations, such as addition and multiplication, or they can compare worksheet values or join text. Formulas can refer to other cells on the same worksheet, cells on other sheets in the same workbook, or cells on sheets in other workbooks. The following example adds 25 to the value in cell B4 and then divides the result by the sum of the values in cells D5, E5, and F5. Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. For example, the SUM function adds values or ranges of cells A formula is an equation that performs operations on worksheet data. Formulas can perform mathematical operations, such as addition and multiplication, or they can compare worksheet values or join text. Formulas can refer to other cells on the same worksheet, cells on other sheets in the same workbook, or cells on sheets in other workbooks. The following example adds 25 to the value in cell B4 and then divides the result by the sum of the values in cells D5, E5, and F5. Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. For example, the SUM function adds values or ranges of cells

10. * =average(A1:A3) enters the average of the values in cells A1 through A3 * =choose(A1,"A","B","C") enters an A if the value in cell A1 is 1, enters a B if the value in cell A1 is 2, enters C if the value in cell A1 is 3 * =count(A1:A3) enters the number of values in cells A1 through A3 * =if(A1=2,"True","False") enters True if the value in cell A1 is 2, enters False if the value in A1 is not 2 * =max(A1:A3) enters the maximum value in cells A1 through A3 * =min(A1:A3) enters the minimum value in cells A1 through A3 * =round(A1,2) rounds value in cell A1 to two decimal places * =sum(A1:A3) adds the values in cells A1 through A3 * =vlookup(A1,A10:B14,2) looks up the value in cell A1 on a chart located in cells A10 through B14 and enters the value from the second column of the chart * =int(rand()*10)+1 creates random numbers with a range of 10 and a minimal value of 1 * =average(A1:A3) enters the average of the values in cells A1 through A3 * =choose(A1,"A","B","C") enters an A if the value in cell A1 is 1, enters a B if the value in cell A1 is 2, enters C if the value in cell A1 is 3 * =count(A1:A3) enters the number of values in cells A1 through A3 * =if(A1=2,"True","False") enters True if the value in cell A1 is 2, enters False if the value in A1 is not 2 * =max(A1:A3) enters the maximum value in cells A1 through A3 * =min(A1:A3) enters the minimum value in cells A1 through A3 * =round(A1,2) rounds value in cell A1 to two decimal places * =sum(A1:A3) adds the values in cells A1 through A3 * =vlookup(A1,A10:B14,2) looks up the value in cell A1 on a chart located in cells A10 through B14 and enters the value from the second column of the chart * =int(rand()*10)+1 creates random numbers with a range of 10 and a minimal value of 1



A class about spreadsheets and their usage. Intended audience: beginners who are new to spreadsheets. Only basic concep

A class about spreadsheets and their usage. Intended audience: beginners who are new to spreadsheets. Only basic concep

Presentation Transcript

Excel Spreadsheets

Data and Spreadsheet

Slides 2c: Using Spreadsheets for Modeling - Excel Concepts (Updated 1/19/2005)

Chapter 10: Spreadsheets

Managerial Decision Modeling with Spreadsheets

Spreadsheets and Business

Spreadsheets

Internet Spreadsheets

Understanding Spreadsheets

From Spreadsheets to Web Pages

Creating Spreadsheets

Docs & Spreadsheets in the Classroom

Spreadsheets: The dark matter of IT Felienne Hermans (@felienne)

E Q: What formatting options are used in spreadsheets and why?

Spreadsheets: The Good Parts

Using Spreadsheets in Management Science Models

Internet Spreadsheets

Managerial Decision Modeling with Spreadsheets

Kentucky’s School Report Card and Spreadsheets

Excel Features That Would Help You Prepare Class Result

The Importance and Criticality of Spreadsheets in the City of London

Computerized Spreadsheets

A class about spreadsheets and their usage. Intended audience: beginners who are new to spreadsheets. Only basic concep