Journal:  Open a new word document and title it, <last name><1st initial> Journal.  Save the document to your desktop.  For today's entry, you will type the date, the question(s) and then the answer(s).

October 26, 2009

What are the colors of the US flag? 

How many stars are on the flag?

 

Excel Test: Remember, if you are talking during the test, you will receive a 0 and will need to schedule a time after school to make it up.

1. Open the Excel test document in the document section to the left.
   
2. You will also need the Excel Test Workbook file.
   
3. Read each question carefully and select the best answer.
   
4. Save the completed test to the hand in folder as <last name><1st initial> excel test
   
5. Save the excel spreadsheet to the handin folder as <last name><1st initial> excel test.
   
6. Since the files have different file extensions (.doc & .xls), you should not have a problem saving the files.

When you are done, you will open the story start document in the download section.

Pick one of the story starters and open a blank WORD document.

Type the story starter and then continue the story.

You will be graded on the following:

 

•     Length of the story (At least 2 full pages)
•     Creativity
  
•     12-point font
  
•     Double-spaced
  
•     A title that creative and centered
  
•     Header with your name and the date
  
•     One piece of clip art inserted into the document.
•     Save as your <last name><1st initial> story to the handin folder.
  

Next class you will be working in the word document unit.

Journal:  Open a new word document and title it, <last name><1st initial> Journal.  Save the document to your desktop.  For today's entry, you will type the date, the question(s) and then the answer(s).

October 26, 2009

What are the colors of the US flag? 

How many stars are on the flag?

 

Excel Test: Remember, if you are talking during the test, you will receive a 0 and will need to schedule a time after school to make it up.

1. Open the Excel test document in the document section to the left.
   
2. You will also need the Excel Test Workbook file.
   
3. Read each question carefully and select the best answer.
   
4. Save the completed test to the hand in folder as <last name><1st initial> excel test
   
5. Save the excel spreadsheet to the handin folder as <last name><1st initial> excel test.
   
6. Since the files have different file extensions (.doc & .xls), you should not have a problem saving the files.

When you are done, you will open the story start document in the download section.

Pick one of the story starters and open a blank WORD document.

Type the story starter and then continue the story.

You will be graded on the following:

 

•     Length of the story (At least 2 full pages)
•     Creativity
  
•     12-point font
  
•     Double-spaced
  
•     A title that creative and centered
  
•     Header with your name and the date
  
•     One piece of clip art inserted into the document.
•     Save as your <last name><1st initial> story to the handin folder.
  

Next class you will be working in the word document unit.

Open your Excel Review workbook (the one you worked on last class) and complete the following Excel it activities:

Activity 21:  Candy Holidays

Activity 22: Astrology

Make sure you:

1. Read the formatting directions
2. Rename the tabs on your spreadsheets
3. Include you lastname in the file name

Open your Excel Review workbook (the one you worked on last class) and complete the following Excel it activities:

Activity 21:  Candy Holidays

Activity 22: Astrology

Make sure you:

1. Read the formatting directions
2. Rename the tabs on your spreadsheets
3. Include you lastname in the file name

Review Activities

Open a new Excel workbook and title it <last name><1st initial> Excel review.  The activities today and next class will help you review what we have learned so far and introduce you to another couple of Excel features.

Activity 45: American Idol
Activity 56: Comic Books

When you are done, you will save the assignment to your Excel folder for next class.
 

Review Activities

Open a new Excel workbook and title it <last name><1st initial> Excel review.  The activities today and next class will help you review what we have learned so far and introduce you to another couple of Excel features.

Activity 45: American Idol
Activity 56: Comic Books

When you are done, you will save the assignment to your Excel folder for next class.
 

Do not forget:  Every formula must begin with an = (equal sign).  Without it, Excel will not know that you are writing a formula.

Sum means that you will be adding a series of cells together

Average means that you will be finding the average of a series of data in cells

Min means that you are looking for the lowest number

Max means that you are looking for the highest number

Layer C:  Function formula and graph workbook

Layer B:  Pick 2 of the following options

1.    Vampire spreadsheet

2.    Excel It! Activity 14

3.    Excel It! Activity 18

Layer A:  Fast Food Project

Do not forget:  Every formula must begin with an = (equal sign).  Without it, Excel will not know that you are writing a formula.

Sum means that you will be adding a series of cells together

Average means that you will be finding the average of a series of data in cells

Min means that you are looking for the lowest number

Max means that you are looking for the highest number

Layer C:  Function formula and graph workbook

Layer B:  Pick 2 of the following options

1.    Vampire spreadsheet

2.    Excel It! Activity 14

3.    Excel It! Activity 18

Layer A:  Fast Food Project

Layer C:  Function formulas and graphs

Download the function and graph document from the document section

=sum(data range) adds data

=average(data range) finds the average

=max(data range) finds the largest number

=min(data range) Finds the lowest number

You will need your standard tool bar and your formula bar.  You can access both through the VIEW menu.

You will use the CHART WIZARD to create your graphs. The book will give you specific directions on what graph to create and the details that you need.  I will explain in class, how to access the formatting options.

Layer C:  Function formulas and graphs

Download the function and graph document from the document section

=sum(data range) adds data

=average(data range) finds the average

=max(data range) finds the largest number

=min(data range) Finds the lowest number

You will need your standard tool bar and your formula bar.  You can access both through the VIEW menu.

You will use the CHART WIZARD to create your graphs. The book will give you specific directions on what graph to create and the details that you need.  I will explain in class, how to access the formatting options.

Assignment:

You can use the Simple formula workbook or open a new workbook to complete layer B & A 

Layer C: Simple formulas workbooks (last class)

Layer B:  Activity 10 (S.A.T. Scores) from the Excel It! book

Layer A: Activity 11 (S.A.T. Scores 2) from the Excel It! book

Assignment:

You can use the Simple formula workbook or open a new workbook to complete layer B & A 

Layer C: Simple formulas workbooks (last class)

Layer B:  Activity 10 (S.A.T. Scores) from the Excel It! book

Layer A: Activity 11 (S.A.T. Scores 2) from the Excel It! book

1. NOTES:  Copy the following notes into your agenda

Every formula must begin with an = (equal sign).  Without it, Excel will not know that you are writing a formula.

There are no spaces in a formula

Use the + sign for addition

Use the - sign for subtraction

Use the / sign for division (just like a fraction)

Use the * sign for multiplication.

2.  ASSIGNMENT:  Open the spreadsheet titled "Simple formulas, Layer C".  It is in the document sections of this website.  At the top of each spreadsheet, there are page numbers in the book that will help you work through the problems.  Make sure that you read all of the directions.  You are still responsible for the formatting and the formulas.

Make sure you insert your last name at the beginning of the "save as" name.

 

1. NOTES:  Copy the following notes into your agenda

Every formula must begin with an = (equal sign).  Without it, Excel will not know that you are writing a formula.

There are no spaces in a formula

Use the + sign for addition

Use the - sign for subtraction

Use the / sign for division (just like a fraction)

Use the * sign for multiplication.

2.  ASSIGNMENT:  Open the spreadsheet titled "Simple formulas, Layer C".  It is in the document sections of this website.  At the top of each spreadsheet, there are page numbers in the book that will help you work through the problems.  Make sure that you read all of the directions.  You are still responsible for the formatting and the formulas.

Make sure you insert your last name at the beginning of the "save as" name.

 

September 29 & 30

Assignment:

I.  Layer C (40 point)

Brain Pop: History of Computers

1. Go to www.brainpop.com/technology/computersandinternet/computerhistory/preview.weml and login into Brain Pop using the login Username: kingscience, Password: 1999
2. Complete the quiz at the end, make sure your name is on it and then print.

Open a new workbook and save it as <Last name><1st initial>092909.  Complete Excel It! activity #6.

II.  Layer B (5 point): Complete both activities

In your workbook 092909.  Complete Excel It! activity #7 or #8.  Make sure you name your tabs.

IV.  Layer A (5 point): You may also work on completing previous layers.

1. Complete activity #9 in the Excel it! Workbook.  Use the same workbook that you used for layer C & B 
   
   
2. Create a spreadsheet for the vocabulary terms that you are using in science for the measuring unit.  Your spreadsheet should include the word, the units and the tools used for measuring.
3. Create a spreadsheet of books (at least 10) that you would like to read. Record the authors name, the Genre and the cost of the book.  Amazon.com will have the information that you need.

September 22 & 23

Assignment:

I.  Layer C, part I (20 point)

Open the Insert, Delete and Sort PowerPoint located in the documents section.

Open the Power Point Worksheet document.

Complete the worksheet as you review the PowerPoint.  Save the worksheet as your <last name><1st initial> answers and turn into the handin folder

II.  Layer C, part II (20 point): Complete both activities

1. Open the Animals (10-2 Project 2) workbook that is located in the documents section and save it to your Excel folder as your <last name><1st initial> 092209
   
   
2. Read pages 372 – 374 to complete and format the spreadsheet in the Keyboarding Connections textbook.
   

III.  Layer B (5 point): Complete both activities

1. On spreadsheet 2 of your Excel Workbook, read the directions on pages 375 – 377 and complete and format the spreadsheet in the Keyboarding Connections textbook.
   
   
2. On spreadsheet 3, type the answers to the Check for Understanding on page 378 in the Keyboarding Connections textbook
   

IV.  Layer A (5 point): You may also work on completing previous layers.

1. Complete activity #5 in the Excel it! Workbook.  You will put this on sheet #4 of your workbook.
   
   
2. Create a spreadsheet for the vocabulary terms that you are using in science for the measuring unit.  Your spreadsheet should include the word, the units and the tools used for measuring.
3. Create a spreadsheet of books (at least 10) that you would like to read. Record the authors name, the Genre and the cost of the book.  Amazon.com will have the information that you need.

---

---

 

September 18 & 21 

Assignment - You must complete at least 40 points today.

Open a new workbook and title it <last name><1st initial> today's date.  You will hand your assignment in at the end of class.  You can complete all three layers within your workbook as long as you do not run out of time.

** Do not forget to name your sheet tabs

Layer C (40 pts.):

A. Keyboarding Connections, pages 370 - 371 (20 pts): Population

B.  Excel It! Activity 2, pages 3 & 4 (20 pts)

Layer B (5 pts.):

Excel It! Activity 3, pages 5 & 6 (40 pts)

Layer A (5 pts.):Pick 1 activity

1. Create a spreadsheet for the vocabulary terms that you are using in science for the measuring unit.  Your spreadsheet should include the word, the units and the tools used for measuring.

2. Create a spreadsheet of books (at least 10) that you would like to read. Record the authors name, the Genre and the cost of the book.  Amazon.com will have the information that you need.

---

---

September 16 & 17

1. Create a new folder on your desktop titled Excel Unit.  If you do not have a teacher reviewed folder on your desktop, create one of those.

Assignment - You must complete at least 40 points today.

Layer C (40 pts.):

1. Open the Excel workbook, Project 1 and save it to your desktop as <last name><1st initial> and today's date.

2. Open you Keyboarding Connections textbook and follow the directions on page 362 to 367.

3. When you are done with the sreadsheets, save your changes to your desktop and then save a copy to the handin folder.

   Layer B (5 pts.):
   

1. Check for Understanding on page 368 in the Keyboarding Connections.  Please type your answers using complete sentences, which paraphrase the question

2. Complete the Excel it! Activity 1, pages 1& 2
   

Layer A (5 pts.):

1. Create a spreadsheet for the vocabulary terms that you are using in science for the measuring unit. 

2. Your spreadsheet should include the word, the units and the tools used for measuring.
   

If you have not finished the Intro modules, take this time to complete them.

 

---

---

September 14 & 15

1. Open the Intro To Excel Modules under the documents
   

2. Read through the instructions
   

3. Make sure that you have a check sheet from the teacher
   

4. When you are done with the assignment, you will turn it into the electronic hand in folder
   

5. If you have any questions, ask your neighbor first, they may know the answer.
   

6. Keep in mind, most of the Command Keys that you have learned, can be used with Excel.

 

 

 

 

September 29 & 30

Assignment:

I.  Layer C (40 point)

Brain Pop: History of Computers

1. Go to www.brainpop.com/technology/computersandinternet/computerhistory/preview.weml and login into Brain Pop using the login Username: kingscience, Password: 1999
2. Complete the quiz at the end, make sure your name is on it and then print.

Open a new workbook and save it as <Last name><1st initial>092909.  Complete Excel It! activity #6.

II.  Layer B (5 point): Complete both activities

In your workbook 092909.  Complete Excel It! activity #7 or #8.  Make sure you name your tabs.

IV.  Layer A (5 point): You may also work on completing previous layers.

1. Complete activity #9 in the Excel it! Workbook.  Use the same workbook that you used for layer C & B 
   
   
2. Create a spreadsheet for the vocabulary terms that you are using in science for the measuring unit.  Your spreadsheet should include the word, the units and the tools used for measuring.
3. Create a spreadsheet of books (at least 10) that you would like to read. Record the authors name, the Genre and the cost of the book.  Amazon.com will have the information that you need.

September 22 & 23

Assignment:

I.  Layer C, part I (20 point)

Open the Insert, Delete and Sort PowerPoint located in the documents section.

Open the Power Point Worksheet document.

Complete the worksheet as you review the PowerPoint.  Save the worksheet as your <last name><1st initial> answers and turn into the handin folder

II.  Layer C, part II (20 point): Complete both activities

1. Open the Animals (10-2 Project 2) workbook that is located in the documents section and save it to your Excel folder as your <last name><1st initial> 092209
   
   
2. Read pages 372 – 374 to complete and format the spreadsheet in the Keyboarding Connections textbook.
   

III.  Layer B (5 point): Complete both activities

1. On spreadsheet 2 of your Excel Workbook, read the directions on pages 375 – 377 and complete and format the spreadsheet in the Keyboarding Connections textbook.
   
   
2. On spreadsheet 3, type the answers to the Check for Understanding on page 378 in the Keyboarding Connections textbook
   

IV.  Layer A (5 point): You may also work on completing previous layers.

1. Complete activity #5 in the Excel it! Workbook.  You will put this on sheet #4 of your workbook.
   
   
2. Create a spreadsheet for the vocabulary terms that you are using in science for the measuring unit.  Your spreadsheet should include the word, the units and the tools used for measuring.
3. Create a spreadsheet of books (at least 10) that you would like to read. Record the authors name, the Genre and the cost of the book.  Amazon.com will have the information that you need.

---

---

 

September 18 & 21 

Assignment - You must complete at least 40 points today.

Open a new workbook and title it <last name><1st initial> today's date.  You will hand your assignment in at the end of class.  You can complete all three layers within your workbook as long as you do not run out of time.

** Do not forget to name your sheet tabs

Layer C (40 pts.):

A. Keyboarding Connections, pages 370 - 371 (20 pts): Population

B.  Excel It! Activity 2, pages 3 & 4 (20 pts)

Layer B (5 pts.):

Excel It! Activity 3, pages 5 & 6 (40 pts)

Layer A (5 pts.):Pick 1 activity

1. Create a spreadsheet for the vocabulary terms that you are using in science for the measuring unit.  Your spreadsheet should include the word, the units and the tools used for measuring.

2. Create a spreadsheet of books (at least 10) that you would like to read. Record the authors name, the Genre and the cost of the book.  Amazon.com will have the information that you need.

---

---

September 16 & 17

1. Create a new folder on your desktop titled Excel Unit.  If you do not have a teacher reviewed folder on your desktop, create one of those.

Assignment - You must complete at least 40 points today.

Layer C (40 pts.):

1. Open the Excel workbook, Project 1 and save it to your desktop as <last name><1st initial> and today's date.

2. Open you Keyboarding Connections textbook and follow the directions on page 362 to 367.

3. When you are done with the sreadsheets, save your changes to your desktop and then save a copy to the handin folder.

   Layer B (5 pts.):
   

1. Check for Understanding on page 368 in the Keyboarding Connections.  Please type your answers using complete sentences, which paraphrase the question

2. Complete the Excel it! Activity 1, pages 1& 2
   

Layer A (5 pts.):

1. Create a spreadsheet for the vocabulary terms that you are using in science for the measuring unit. 

2. Your spreadsheet should include the word, the units and the tools used for measuring.
   

If you have not finished the Intro modules, take this time to complete them.

 

---

---

September 14 & 15

1. Open the Intro To Excel Modules under the documents
   

2. Read through the instructions
   

3. Make sure that you have a check sheet from the teacher
   

4. When you are done with the assignment, you will turn it into the electronic hand in folder
   

5. If you have any questions, ask your neighbor first, they may know the answer.
   

6. Keep in mind, most of the Command Keys that you have learned, can be used with Excel.