Make your own free website on Tripod.com

Mr. Gonzalez's Website
Weslaco East High School

Wildcats

Excel


| Home | BCIS (I) |
| Excel | MicroType | Word |

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


Monday, November 17 (A)
Tuesday, November 18(B)
 

  • Unit 2, Lesson 3, Exercise 6a
    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, and include Page 248 in Custom Footer
       
  • Unit 2, Lesson 3, Exercise 6b,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, and include Page 250 in Custom Footer
       
  •  
    • Unit 2, Lesson 3, Exercise 6d
      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, and include Page 252 in Custom Footer
         
    • Unit 2, Lesson 3, Exercise 7a
      Objective:  Provide Feedback on a Worksheet (Insert and edit comments in a worksheet).
      • Pg. 252 - 254
      • Click here to download/save Loan Comparison2 file...
      • This exercise will include 1 printout
      • Print spreadsheet, and include Page 254 in Custom Footer
         
    • Unit 2, Lesson 3, Exercise 7b
      Objective:  Provide Feedback on a Worksheet (Create and respond to discussion comments).
      • Pg. 254 - 255
      • Click here to download/save Qtr2 Sales file...
      • This exercise will include 1 printout
      • Print spreadsheet, and include Page 255 in Custom Footer
         
    • 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)
      • Step c:  Apply Filter
      •               PRINT Landscape Orientation (Include Page 261B in Custom Footer)
      • 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
      • PRINTOUT #1 Landscape Orientation - Values (Include Page 262A in Custom Footer)
      • PRINTOUT #2 Landscape Orientation - Formulas (Include Page 262B in Custom Footer)
         
    • Unit 2, Lesson 3, Guided Activity 4
      Objective:  Adding Charts and a Comment to a College Budget Worksheet.
      • Pg. 263 - 264
      • Click here to download/save College Budget3 file...
      • This exercise will include 1 printout
      • PRINTOUT #1 Landscape Orientation - Values (Include Page 262A in Custom Footer)
      • PRINTOUT #2 Landscape Orientation - Formulas (Include Page 262B in Custom Footer)
         

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