**Learning Excel....**

**Wiki #1 lesson on EXCEL (Jan. 26, 2011):**

**Objective: SWBAT list and define in five words or less (in the ADD COMMENTS section below) the key vocabulary from this **

**beginning study of Microsoft EXCEL spreadsheets. **

**Wiki #2 lesson on EXCEL:**** **

**Objective: Feb. 7, 2011: SWBAT use the SPREADSHEET REVIEW to practice use of EXCEL spreadsheets and then **

** add up (using the "sum icon") the total number of temperature highs (Tues-Sun) at this**

** Baltimore Sun site (http://www.baltimoresun.com/news/weather/). **

** Then SWBAT ****determine ****the average daily high for this time period.**

** **

**Wiki #3 lesson on EXCEL:**** **

**Objective Feb. 8, 2011: SWBAT study the SREADSHEET REVIEW attached here and the instructor demo IOT to prepare to**

** average the sums of the first six ****"irregular quad" shapes in the handout given. **

** (See teacher sample below.)**

** **

**Directions for wiki lesson #1:**

1. Read and study the article copied and pasted from the link.

2. Select the key words.......and keyboard and SAVE them into a Microsoft WORD document that you will later copy and paste into the ADD COMMENTS section below.

3. Each key word should have a definition created by you in five words of less. No long definitions please!

4. Once your key words are correctly copied into the wiki, please comment on what three (3) of your peers have written. Constructive comments only!

5. Your input will be graded by your instructor.

This link (http://spreadsheets.about.com/od/tipsandfaqs/f/excel_use.htm) is copied below to help you begin to study Mircosoft EXCEL spreadsheets:

**Question: **What is Microsoft Excel and When Would I Use it?

**Answer: ****Excel is an Electronic Spreadsheet Program**

Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data.

When you look at the Excel screen (refer to the example on this page) you see a rectangular table or grid of rows and columns. The horizontal rows are identified by numbers (1,2,3) and the vertical columns with letters of the alphabet (A,B,C). For columns beyond 26, columns are identified by two or more letters such as AA, AB, AC.

The intersection point between a column and a row is a small rectangular box known as a cell. A cell is the basic unit for storing data in the spreadsheet. Because an Excel spreadsheet contains thousands of these cells, each is given a cell reference or address to identify it.

The cell reference is a combination of the column letter and the row number such as A3, B6, AA345.

**Data Types, Formulas, and Functions**

The types of data that a cell can hold include numbers, text or formulas. Just as in math class, formulas are used for calculations usually involving data contained in other cells. Excel and other electronic spreadsheets include a number of built in formulas used for common tasks known as functions.

**Excel and Financial Data**

Spreadsheets are often used to store financial data. Formulas and functions that are used on this type of data include:

- Performing basic mathematical operations such as summing columns and rows of figures.
- Finding values such as profit or loss.
- Calculating repayment plans for loans or mortgages.
- Finding the average, maximum, or minimum values in a specified range of data.

**Excel's Other Uses**

Other common operations that Excel can be used for include:

- graphing or charting data to assist users in identifying data trends.
- sorting and filtering data to find specific information.

The information garnered in a spreadsheet can easily be incorporated into electronic presentations, web pages, or printed off in report form.

**The Original "Killer App"**

Spreadsheets were the original *killer apps* for personal computers. Early spreadsheet programs such as VisiCalc and Lotus 1-2-3 were largely responsible for the growth in popularity of computers like the Apple II and the IBM PC as a business tool.

## Comments (23)

## Sherae Richardson said

at 11:59 am on Jan 31, 2011

1. Formulas are used for calculations.(Mostly for data in other cells though.)

2. Excel and other electronic spreadsheets include a number of built in formulas used for common tasks known as Functions.

3. Charting data to assist people in identifying trends in data.

Sherae

## Sherae Richardson said

at 12:02 pm on Jan 31, 2011

4. The point between a column and a row is a small rectangular box known as a Cell

5. Each is given a cell reference or address to identify it.

## Taylor Daniels said

at 12:08 pm on Jan 31, 2011

those are very important words

## Sherae Richardson said

at 12:08 pm on Jan 31, 2011

Thank You! :)

## Taylor Daniels said

at 12:09 pm on Jan 31, 2011

your welcome

## Taylor Daniels said

at 12:04 pm on Jan 31, 2011

Data- information that is stored.

Rows- run horizontally through excel.

Columns- run vertically in a spreadsheet.

Formulas- mathematical equations used to calculate a value.

Functions-begin with the equal sign ( = ) followed by the function's name and its arguments

## Sherae Richardson said

at 12:10 pm on Jan 31, 2011

That is also imortant ,Taylor! You sound very intelligent! =)

## Ebere Onyingechi said

at 12:06 pm on Jan 31, 2011

1. vaunted-boasted

2. euphuism

3. plumb

4. curfew

5. unanimous

6. belie

7. pupil

8. stupendous

9. voyage

10. tangible

11. rollicking

12. archive

13. cantankerous

14. centrifugal force

15. taut

16. simulate

17. gauche

18. slalom

19. rigor

20. clavicle

21. odd

22. mien

23. veteran

24. protocol

25. travesty

## Sherae Richardson said

at 12:11 pm on Jan 31, 2011

Onyi, thats the wrong thing. =(

## Taylor Daniels said

at 12:11 pm on Jan 31, 2011

You put the words in the wrong place but yhu worked yhur hardest.

## Aliyah Williams said

at 8:50 pm on Jan 31, 2011

you spelled you wrong but thats okay........

## Aliyah Williams said

at 8:54 pm on Jan 31, 2011

there are only supposed to be 15 words not 25 but that must be extra credit

## Ebere Onyingechi said

at 11:41 am on Feb 2, 2011

i know i did the wrong thing at the incorrect time and place

## Jacqueline Rich said

at 12:09 pm on Jan 31, 2011

Key Words

1) Spreadsheet- a table to store data.

2) Data- Info stored in spreadsheet programs

3) Rows- lines run horizontally in an Excel sheet

4) Column- a fundamental part of a spreadsheet.

5) Cell- a cell or group of cells in a spreadsheet.

6) Cell Reference- identifies locations of cells or group of cells.

7) Formula- an equation to find the value.

8) Function- a preset formula

9) Charting- graph of worksheet data

## Sherae Richardson said

at 12:12 pm on Jan 31, 2011

Great words, Jaqueline! :)

## Angeli Stokes said

at 12:11 pm on Jan 31, 2011

Angeli Stokes January 31, 2011

Data: information that can be stored

Formula: a mathematical equation used to calculate a value

Function: a preset formula

Charting: a type of graph

Row: horizontal lines

## Kayla Kelly said

at 12:11 pm on Jan 31, 2011

Spreadsheet: A work sheet arranged in the manner or information

Data: Individual Facts

Row: Number of items in a line

Columns: A group

Cell: Small room

Cell Reference: A string identifying a particular cell in a spreadsheet

## Aliyah Williams said

at 11:44 am on Feb 4, 2011

you forgot charting, functions, and formula

## Jacqueline Rich said

at 12:12 pm on Jan 31, 2011

1.) spreadsheet – table used to store data

2.) data – information stored in a spreadsheet

3.) rows - lines that run horizontally in an Excel sheet

4.) column – a part of a spreadsheet

5.) cell – unit for storing data

6.) cell reference - a cell or group of cells in a spreadsheet

7.) formula – equation used to calculate a value.]

8.) functions – a preset formula

9.) charting – graphs

Taijae Fong

## Camryn Mack said

at 11:41 am on Feb 3, 2011

Key Words

1) Data - information in a spreadsheet

2) Spreadsheet- table used to store data

3) Rows - lines that are horizontal in a Excel sheet

4) Cell - unit for storing data

5) Cell Refrence - a cell or cells in a spreadsheet

6)Column- a part of a spreadsheet

7)Formula- equation used to calculate a variable

8) charting - graphs

9) functions - a present formula

## Esther Eze said

at 11:36 am on Feb 4, 2011

Esther Eze Jan.31, 2011

Data-information that is stored in a computer

Rows- run horizontally, they are identified in numbers

Columns- are a fundamental part of the spreadsheet, they run vertically and horizontally to locate the data.

Formulas-a mathematical equation used to calculate a value

Functions- a preset formula

## Esther Eze said

at 11:41 am on Feb 4, 2011

Trash or Treasure

Trash refers to inappropriate websites

Treasure refers to .Appropriate websites

These will help you in evaluating whether a web site is trash or treasure:

A-Stands for whether the article has accurate info; that is whether to info is correct.

A-Stands for whether or not a organization, a commercial, or an agency is reliable or not

O- The factual data and the lack of personal prejudice

C- How current the website is

U- How easily the website allows you to info

## Estell Chambers said

at 7:24 am on Feb 7, 2011

Teacher sample for Feb. 17, 2011 objective:

The sum of the areas of the 8 quads is 800 (which I determined by using the "sum" icon in EXCEL) and then dividing by "8" = 100 average sum.

You don't have permission to comment on this page.