EXCEL
This month of February we will concentrate on Excel. You will also learn how to create charts using the Spreadsheet exercises you did in class and also work on some of the Textbook exercises. We will read and study Chapter 7 (Microsoft Office 2010 Textbook) and lean about Charts and how to create them.
A chart is a visual representation of worksheet data. A chart can enhance and simplify the understanding of numerical data in a worksheet because the relationship between data is illustrated.
You will do the "Continents" Exercise on page 269 (two-part exercise). Follow the instructions carefully! You will create a Column Chart for Excel Exercises 1 and 2. Also a Pie Chart for one of the data series (one of the columns with numerical data) for those exercises. Mrs. Feld will explain in class.
You will also complete the "Temperature" Exercise on page 276 (two-part exercise). Also follow the instructions carefully!
On Tuesday, February 5th, you will have an Excel Quiz (Quiz 1) - Excel Exercise. You will have to calculate the totals and the averages for the columns with numbers, and the totals for the rows with numbers, like you did in class. Remember to use the AutoSum function and the AutoFill handle to quickly enter the formulas into the cells. Also remember the Average formula (there are three different ways of entering averages in a spreadsheet).
On Friday, February 8th, you will have another Excel Quiz (Quiz 2) - Excel Exercise similar to Exercise No. 3, to practice multiplication.
Formulas learned to date
Sum (addition): =SUM(range of cells you are adding here). Example: =SUM(B3:B8) or =B3+B4+B5+B6+B7+B8
Multiplication: =PRODUCT(range of cells you are multiplying here). Example: =PRODUCT(B3:C3) or =B3*C3
Average: =AVERAGE(range of cells you are using here - without including the Total). Example: =AVERAGE(B3:B8) or =B9/6 (if your total for B3:B8 is in B9)
Ask Mrs. Feld if you have any questions. You will have an Excel Test on February 26th.
Vocabulary you must know: cell, active cell, cell address (or cell reference), name box, columns, rows, data, worksheet area, AutoSum, AutoCalculate, AutoComplete, AutoFill Handle, AutoCorrect, formula, formula bar, gridlines, range, workbook, worksheet, sheet tab, spreadsheet. You can find these definitions in the textbook, page 199. Also, review the previous entry.
When and why do you see number symbols or pound signs (###) in Excel?
More vocabulary: chart, chart title, the legend, data labels, the plot area, the chart area, bar chart, column chart, pie chart, line chart, category axis, value axis, data series. You can find these definitions on pages 268 and 291 in the textbook and throughout Chapter 7.
A chart is a visual representation of worksheet data. A chart can enhance and simplify the understanding of numerical data in a worksheet because the relationship between data is illustrated.
You will do the "Continents" Exercise on page 269 (two-part exercise). Follow the instructions carefully! You will create a Column Chart for Excel Exercises 1 and 2. Also a Pie Chart for one of the data series (one of the columns with numerical data) for those exercises. Mrs. Feld will explain in class.
You will also complete the "Temperature" Exercise on page 276 (two-part exercise). Also follow the instructions carefully!
On Tuesday, February 5th, you will have an Excel Quiz (Quiz 1) - Excel Exercise. You will have to calculate the totals and the averages for the columns with numbers, and the totals for the rows with numbers, like you did in class. Remember to use the AutoSum function and the AutoFill handle to quickly enter the formulas into the cells. Also remember the Average formula (there are three different ways of entering averages in a spreadsheet).
On Friday, February 8th, you will have another Excel Quiz (Quiz 2) - Excel Exercise similar to Exercise No. 3, to practice multiplication.
Formulas learned to date
Sum (addition): =SUM(range of cells you are adding here). Example: =SUM(B3:B8) or =B3+B4+B5+B6+B7+B8
Multiplication: =PRODUCT(range of cells you are multiplying here). Example: =PRODUCT(B3:C3) or =B3*C3
Average: =AVERAGE(range of cells you are using here - without including the Total). Example: =AVERAGE(B3:B8) or =B9/6 (if your total for B3:B8 is in B9)
Ask Mrs. Feld if you have any questions. You will have an Excel Test on February 26th.
Vocabulary you must know: cell, active cell, cell address (or cell reference), name box, columns, rows, data, worksheet area, AutoSum, AutoCalculate, AutoComplete, AutoFill Handle, AutoCorrect, formula, formula bar, gridlines, range, workbook, worksheet, sheet tab, spreadsheet. You can find these definitions in the textbook, page 199. Also, review the previous entry.
When and why do you see number symbols or pound signs (###) in Excel?
More vocabulary: chart, chart title, the legend, data labels, the plot area, the chart area, bar chart, column chart, pie chart, line chart, category axis, value axis, data series. You can find these definitions on pages 268 and 291 in the textbook and throughout Chapter 7.
posted by Karol B. Feld at
7:47 AM
0 Comments:
Post a Comment
<< Home