• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Stop wasting time looking for files and revisions! Dokkio, a new product from the PBworks team, integrates and organizes your Drive, Dropbox, Box, Slack and Gmail files. Sign up for free.

View
 

Learn Excel Spreadsheets

Page history last edited by Estell Chambers 9 years, 2 months ago

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.