Make your own free website on Tripod.com

Mr. Gonzalez's Website
Weslaco East High School

Wildcats

Excel


| Home | BCIS (I) |
| Access | Excel | How To... | Internet | MicroType |
|
 PowerPoint | 
Word |

TO AVOID LOSING 10 POINTS (EACH PRINTOUT),
BE SURE TO STAPLE ALL OF YOUR WORK TOGETHER
IN ORDER - KEYBOARDING LESSON(S) ON TOP


Friday, December 12 (A)
Monday, December 15 (B)
Tuesday, December 16 (A)
 

  • Grade Check/Update
  • Tech Prep of the Rio Grande Valley, Inc.
  • Video...
  • PowerPoint Presentation...
  • Click here to access the Tech Prep website...
  • Wait for instructions on how to register...
  • Successful registration will count as a 10-POINT BONUS on Semester Exam Grade!!!

 

Semester Exam - Fall 2008

  • Wait for printed instructions
  • Use Microsoft Excel 2007 to create a spreadsheet
  • Complete printed instructions (BOTH SIDES)
    • Print spreadsheet ("Values") = 25 Points
    • Print spreadsheet ("Formulas") = 25 Points
    • Print Column Chart = 25 Points
    • Print Pie Chart = 25 Points

Wednesday, December 10 (A)
Thursday, December 11 (B)
 

  • Click here to download/print the Excel Practice Exam.2...
  • You will need to turn-in TWO (2)  printouts:
    • Print the VALUES (50 points) - Include "Values" in the Footer...
    • Print the FORMULAS (50 points) - Include "Formulas" in the Footer...

Monday, December 08 (A)
Tuesday, December 09 (B)
 

  • Using the COMPLETED spreadsheet (Payroll2.xls) from Guided Activities #2 (Pg. 261 - 262)
    1. Using the Employee Names (A6:A12) and the Net Pay (F6:F12), create a Column Chart on a separate sheet...
    2. Add  a Chart Title:  "Sierra Sporting Goods - Weekly Payroll"
    3. Add Value Data Labels
    4. Include Pg. 262 on your Footer (Center Section)
    5. Include the Sheet Name on your Footer (Center Section)

 

  • Using the spreadsheet from Guided Activities #4 (Pg. 263 - 264)
  • Click here to download/save (College Budget3.xls)
  • Using the Excel spreadsheet above, create two SEPARATE Pie Charts
    1. Using the Expense amounts (A5:B14), create a Pie Chart on a separate sheet...
      • Add a Chart Title:  "College Expenses"
      • Add Value and Percentage Data Labels
      • Include Pg. 264 on your Footer (Center Section)
      • Include the Sheet Name on your Footer (Center Section)
    2. Using the Income amounts (A18:B21), create a Pie Chart on a separate sheet...
      • Add a Chart Title "College Income"
      • Add Value and Percentage Data Labels
      • Include Pg. 264 on your Footer (Center Section)
      • Include the Sheet Name on your Footer (Center Section)

Thursday, December 04 (A)
Friday, December 05 (B)
 

  • Click here to download/print the Excel Practice Exam...
  • You will need to turn-in TWO (2)  printouts:
    • Print the VALUES (50 points) - Include "Values" in the Footer...
    • Print the FORMULAS (50 points) - Include "Formulas" in the Footer...

Monday, December 01 (B)
Tuesday, December 02 (A)
Wednesday, December 03 (B)
 

  • Grades Update...

  • Microsoft Excel 2007:  Wait for Instructor Demonstration...

  • Follow textbook instructions as a general guide only.  Steps will be done together as a class...

  • Unit 2, Lesson 3, Exercise 6 A
    Objective:  Create and Modify Chart and Graph (Bar Chart).

    • Pg. 247 - 248

    • Click here to download/save Sales Charts file...

    • This exercise will include 1 printout

    • Print Bar Chart

      • Include Page 248 A in Custom Footer Center Section

      • Include Tab name in Custom Footer Center Section

  • Unit 2, Lesson 3, Exercise 6 B-C
    Objective:  Create and Modify Chart and Graph (Pie Chart).

    • Pg. 248 - 250

    • Continue working with Sale Charts file from previous exercise...

    • This exercise will include 1 printout

    • Print Pie Chart

      • Include Page 250 B-C in Custom Footer Center Section

      • Include Tab name in Custom Footer Center Section

  • Unit 2, Lesson 3, Exercise 6 D-E
    Objective:  Insert and position a graphic.

    • Pg. 250 - 252

    • Click here to download/save Qtr2 Sales file...

    • This exercise will include 1 printout

    • Print spreadsheet - LANDSCAPE ORIENTATION

      • Include Page 252 D-E in Custom Footer Center Section

      • Include Tab name in Custom Footer Center Section


Friday, November 21 (A)
Monday, November 24 (B)
 

  • Refer to PREVIOUS Excel Assignments for assistance!!!
  • Please wait for Class Demonstration (Assignments will be completed as a class)
  • Unit 2, Lesson 3, Guided Activity 1
    Objective:  Filter Data in an Expenses Worksheet.
    • Pg. 261
    • Click here to download/save Expense Summary2 file...
    • This exercise will include 2 printouts
    • Step b:  Apply Filter
    •               PRINT Landscape Orientation (Include Page 261A in Custom Footer)
    •               BEFORE clearing Filter...
    • Step c:  Apply Filter
    •               PRINT Landscape Orientation (Include Page 261B in Custom Footer) - QUIZ Grade
    •               BEFORE clearing Filter...
    • Step d:  Close file without saving
       
  • Unit 2, Lesson 3, Guided Activity 2
    Objective:  Enter Formulas and Functions in a Payroll Worksheet.
    • Pg. 261 - 262
    • Click here to download/save Payroll2 file...
    • This exercise will include 2 printouts
    • Please note assignment continue on Pg. 262!!!
    • PRINTOUT #1 Landscape Orientation - Values (Include Page 262A in Custom Footer)
    • PRINTOUT #2 Landscape Orientation - Formulas (Include Page 262B in Custom Footer) - QUIZ Grade

Wednesday, November 19 (A)
Thursday, November 20 (B)
 

  • Grades Update...

  • Class discussion of Excel Charts & Graphs

  • Wait for Instructor Demonstration...

  • Unit 2, Lesson 3, Exercise 6 A
    Objective:  Create and Modify Chart and Graph (Bar Chart).

    • Pg. 247 - 248

    • Click here to download/save Sales Charts file...

    • This exercise will include 1 printout

    • Print Bar Chart

      • Include Page 248 A in Custom Footer Center Section

      • Include Tab name in Custom Footer Center Section

       

  • Unit 2, Lesson 3, Exercise 6 B-C
    Objective:  Create and Modify Chart and Graph (Pie Chart).

    • Pg. 248 - 250

    • Continue working with Sale Charts file from previous exercise...

    • This exercise will include 1 printout

    • Print Pie Chart

      • Include Page 250 B-C in Custom Footer Center Section

      • Include Tab name in Custom Footer Center Section

  • Unit 2, Lesson 3, Exercise 6 D-E
    Objective:  Insert and position a graphic.

    • Pg. 250 - 252

    • Click here to download/save Qtr2 Sales file...

    • This exercise will include 1 printout

    • Print spreadsheet - LANDSCAPE ORIENTATION

      • Include Page 252 D-E in Custom Footer Center Section

      • Include Tab name in Custom Footer Center Section


Tuesday, November 18 (3B & 4B)
 

  • Grades Update...
  • Internet Scavenger Hunt (Set 1) click here...
    • Download and save file to your Word folder.
    • Add a Normal Document header.
    • Use Google, Yahoo, Ask, or any other Internet search engine to find answers
    • Each question is worth 10 points.
    • Choose and answer up to 10 questions (100 points total)
    • Print completed document

Wednesday, November 12 (B)
Thursday, November 13(A)
 

  • Unit 2, Lesson 3, Exercise 3
    Objective:  Understand Absolute and Relative References.
    • Pg. 232 - 234
    • Click here to download/save Tenant Space file...
    • Resize columns - make sure printout fits on 1 page
    • This exercise will include 2 printouts
      • Printout #1 - Values (Include Page 234A in Custom Footer)
      • Printout #2 - Formulas (Include Page 234B in Custom Footer)
         
  • Unit 2, Lesson 3, Exercise 4
    Objective:  Add Functions to Formulas.
    • Pg. 235 - 238
    • Click here to download/save Qtr1 Sales file...
    • Use LANDSCAPE ORIENTATION
    • Resize columns - make sure printout fits on 1 page
    • This assignment will include 2 printouts
      • Printout #1 - Values (Include Page 238A in Custom Footer)
      • Printout #2 - Formulas (Include Page 238B in Custom Footer)
         
    • Pg. 239 - 241 (QUIZ GRADE!!!)
    • Click here to download/save Loan Comparison file...
    • Use LANDSCAPE ORIENTATION
    • Resize columns - make sure printout fits on 1 page
    • This assignment will include 2 printouts
      • Printout #1 - Values (Include QUIZ - Page 241A in Custom Footer)
      • Printout #2 - Formulas (Include QUIZ - Page 241B in Custom Footer)

Monday, November 10 (B)
Tuesday, November 11(A)
 

  • 2nd Six-Weeks Grades Check
  • Unit 2, Lesson 3, Exercise 1
    Objective:  Analyze a Subset of Data.
    • Pg. 226 - 227
    • Click here to download/save Job Openings file...
    • This exercise will include 2 printouts
    • Step 4:  PRINT Landscape Orientation (Include Page 227A in Custom Footer)
    • Step 6:  PRINT Landscape Orientation (Include Page 227B in Custom Footer)
    • Step 9:  Close file without saving
       
  • Unit 2, Lesson 3, Exercise 2
    Objective:  Create and Revise Formulas.
    • Pg. 229 - 232
    • This exercise will include 2 printouts (1 with values, and 1 with formulas)
    • Click here to download/save Formulas file...
    • PRINTOUT #1 Landscape Orientation - Values (Include Page 232A in Custom Footer)
    • PRINTOUT #2 Landscape Orientation - Formulas (Include Page 232B in Custom Footer - Display Formulas)
    • To Display Spreadsheet Formulas:
      • Click on Tools
      • Select Options
      • Click on View Tab
      • In the Windows Options Section, select "Formulas"
      • Resize columns (1 Page Wide)

Tuesday, November 4 (B)/Thursday, November 6 (B)
Wednesday, November 5 (A)/Friday, November 7 (A)
 

2nd Six-Weeks Exam (Choose 5 from the following 6)

  1. Part I (Format a Profit and Loss Worksheet)
    • Pg 217 - 218
    • Click here to download/save Profit and Loss file...
    • Type "Part I" in the Footer (Center Section)
    • PRINT Worksheet (20 points)

     

  2. Part II (Apply an AutoFormat and Print a Worksheet)
    • Pg. 218 - 219
    • Click here to download/save Expense Summary file...
    • Type "Part II" in the Footer (Center Section)
    • PRINT Worksheet (20 points)

     

  3. Part III (Modify and Format a College Budget Worksheet)
    • Pg. 219 - 220
    • Click here to download/save College Budget2 file...
    • Type "Part III" in the Footer (Center Section)
    • PRINT Worksheet - LANDSCAPE ORIENTATION (20 points)

     

  4. Part IV (Apply an AutoFormat to a Class Schedule)
    • Pg. 220
    • Click here to download/save My Schedule2 file...
    • Type "Part IV" in the Footer (Center Section)
    • PRINT Worksheet - LANDSCAPE ORIENTATION (20 points)

     

  5. Part V (Create and Format a CD Inventory Worksheet)
    • Pg. 221
    • Create a new, blank workbook, save it as Inventory...
    • Type "Part V" in the Footer (Center Section)
    • PRINT Worksheet - LANDSCAPE ORIENTATION (20 points)

     

  6. Part VI (Format and Print a Balance Sheet
    • Pg. 222
    • Click here to download/save Balance Sheet file...
    • Type "Part VI" in the Footer (Center Section)
    • PRINT Worksheet (20 points)

Friday, October 31 (B)
Monday, November 3(A)
 

  • Unit 2, Lesson 2, Exercise 3
    Objective:  Apply Styles and AutoFormats.
    • Pg. 203 - 205
    • Click here to download/save Facts and Figures file...
    • PRINT (NORMAL HEADER, GRIDLINES, and ROW AND COLUMN HEADINGS)
       
  • Unit 2, Lesson 2, Exercise 4
    Objective:  Modify the Page Setup.
    • Pg. 206 - 208
    • Click here to download/save Employee Info file...
    • Pg. 207:  Ignore Step 2; Instead...
      • Type "Confidential" in the Header Center Section
      • Insert Page Number in the Header Center Section
    • Save file, Do NOT Print (yet)
       
  • Unit 2, Lesson 2, Exercise 5
    Objective:  Preview and Print Worksheets.
    • Pg. 210 - 213
    • Continue working with the Employee Info file...
    • Pg. 211:  Ignore Steps 1 - 6
    • Pg. 212:  Ignore Steps 1 - 3
    • PRINT - LANDSCAPE ORIENTATION
      (NORMAL HEADER, GRIDLINES, and ROW AND COLUMN HEADINGS)

Wednesday, October 29 (B)
Thursday, October 30 (A)
 

  • Unit 2, Lesson 1, Exercise 4
    Objective:  Check and Correct Cell Data and Formats.
    • Pg. 174 - 177
    • Click here to download/save Final Facts file...
    • PRINT (NORMAL HEADER, GRIDLINES, and ROW AND COLUMN HEADINGS)
       
  • Unit 2, Lesson 2, Exercise 1
    Objective:  Manipulates Row and Columns.
    • Pg. 190 - 197
    • Click here to download/save Mall Employees file...
    • DO NOT PRINT
       
  • Unit 2, Lesson 2, Exercise 2
    Objective:  Apply and Modify Cell Formats.
    • Pg. 200 - 202
    • Continue working with the Mall Employees file...
    • PRINT - LANDSCAPE ORIENTATION
      (NORMAL HEADER, GRIDLINES, and ROW AND COLUMN HEADINGS)

Monday, October 27 (B)
Tuesday, October 28 (A)
 

  • Create a new folder in your "My Documents" folder, and name it EXCEL
  • Discussion of Excel Worksheets, Rows, and Columns
     
  • Unit 2, Lesson 1, Exercise 2
    Objective:  Navigate and Edit a Worksheet.
    • Pg. 164 - 167
    • Click here to download/save Facts file...
    • Continue working with Facts file...
    • Save, but DO NOT PRINT
    • Unit 2, Lesson 1, Exercise 2
       
  • Unit 2, Lesson 1, Exercise 3
    Objective:  Change Number Formats and Copy and Move Data.
    • Pg. 170 - 172
    • Continue working with Facts file...
    • Click Setup
      • Click Header/Footer (Add a NORMAL HEADER)
      • Click Sheet (Include GRIDLINES and ROW AND COLUMN HEADINGS )
      • PRINT