Make your own free website on Tripod.com

Mr. Gonzalez's Website
Weslaco East High School

Wildcats

Excel


| Home | BIM (I) |
| Access | Excel | 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


Tuesday, April 19 (A)
Wednesday, April 20 (B)

  • ON YOUR OWN (Pg. 293)
  • Right-click here (Save Link As...), and save file as 19CDMania
  • Print All 4 Charts: 
  • PRINT All 4 Charts, and include the following on the Custom Footer:

    1st Chart (Daily Grade #1)

    • Insert the (Sheet Name) - Chart #1 in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section, key Qtr 1 Chart - Pg. 293, On Your Own

    2nd Chart (Daily Grade #2)

    • Insert the (Sheet Name) - Chart #2 in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section, key Qtr 2 Chart - Pg. 293, On Your Own

    3rd Chart (Daily Grade #3)

    • Insert the (Sheet Name) - Chart #3 in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section, key Qtr 1 Chart - Pg. 293, On Your Own

    4th Chart (Daily Grade #4)

    • Insert the (Sheet Name) - Chart #4 in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section, key Average Sales Chart - Pg. 293, On Your Own

Friday, April 15 (A)
Monday, April 18 (B)

CLASS SURVEY/CHARTS:   Worth 4 DAILY GRADES

  • 1st Grade is your Completed SURVEY
  • 2nd Grade is your Excel SURVEY PRINTOUT
  • 3rd Grade is your 3-D PIE CHART PRINTOUT
  • 4th Grade is your CLUSTERED COLUMN CHART PRINTOUT

Cell Phone Service Provider Survey:   Right-click here (Open Link in New Tab...)

  • Download/print the survey (above).  You will ask 12 students in class which cellular service provider they and/or their family prefer.  The survey grid will include a column for the student name, and a column for each possible cellular service provider (in alphabetical order).  Write the name of each cellular service provider at the top of the survey.  As the student answers your survey, mark their response with an “X” in the appropriate column.   

  • Once the survey is completed, type your survey results in a new spreadsheet.  Type an appropriate title in A1, and then center and merge the title across the survey columns in Row 1.  Use the Excel spreadsheet to create a 3-D Pie Chart on a separate sheet (name the new sheet 3-D Survey Pie Chart).  Use the Excel spreadsheet to create a Clustered Column Chart on a separate sheet (name the new sheet Column Chart).

  • Rename the sheet name (use an appropriate name), and be sure to include the sheet name on the survey chart printout footer.


Wednesday, April 13 (A)
Thursday, April 14 (B)

5th Six-Weeks Exam (Post-Exam Review)
Printouts will count as a 2nd 5th Six-Weeks Exam Grade

  • Exam Instructions (READ AND FOLLOW CAREFULLY!!!)
  • Right-click here (Save Link As...), and save file as Spring 2011 - Clothing Store Sales (II)
    • NOTE:  For step 10, use the following sales amounts (highlighted in RED) for March

          
      Dresses 30100
      Pants 30200
      Shirts 30300
      Shorts 30400
      Skirts 30500

Monday, April 11 (A)
Tuesday, April 12 (B)

5th Six-Weeks Exam

Exam Instructions (READ AND FOLLOW CAREFULLY!!!)
Right-click here (Save Link As...), and save file as Spring 2011 - Clothing Store Sales


Wednesday, April 06 (B)
Thursday, April 07 (A)

  • Lesson 2, Exercise 19 (Pg. 287 - 292)
  • Read and review Exercise chapter
    • Chart Basics
    • Select Chart Data
    • Chart Elements
    • Create Charts
    • Change Chart Types
    • Select a Chart
    • Resize, Copy, Move, or Delete a Chart
  • Right-click here (Save Link As...), and save file as 19DailyBreadSales
  • Step 5: 
    • PRINT the 3-D Pie Chart
    • Insert the (Sheet Name) 3-D Pie Chart in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section, key Pg. 292, Ex. 19

     

  • Step 6: 
    • PRINT the Clustered Column Chart
    • Insert the (Sheet Name) Column Chart in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section, key Pg. 292, Ex. 19

Wednesday, March 23 (B)/Friday, March 25 (B), Tuesday, March 29 (B)/Thursday, March 31 (B)
Monday, April 04 (B)
Thursday, March 24 (A)/Monday, March 28 (A), Wednesday, March 30 (A)/Friday, April 01 (A)
Tuesday, April 05 (A)

 

QUIZ ASSIGNMENT/PROJECT:
(Worth 2 QUIZ Grades
)

"B" Day Deadline (Monday, April 04, 2011)

  • Printout of Assignment Instructions Due:  Tuesday, March 29, 2011
  • Printout of Spreadsheet Values Printout Due:  Tuesday, March 29, 2011
  • Printout of Spreadsheet Formulas Printout Due:  Tuesday, March 29, 2011

 

"A" Day Deadline (Friday, April 01, 2011)

  • Printout of Assignment Instructions Due:  Wednesday, March 30, 2011
  • Printout of Spreadsheet Values Printout Due:  Wednesday, March 30, 2011
  • Printout of Spreadsheet Formulas Printout Due:  Wednesday, March 30, 2011

 

  1. Right-click HERE (Save Link As...), and save instructions in your Excel folder.
  2. PRINT instructions
  3. Choose a project partner CAREFULLY
  4. You need to create your own Excel assignment in Word.
  5. Your parnter will help you by following your written directions, and completing the assignment in Excel.
  6. Your partner will help you by letting you know if there is a problem with your instructions, or if the instructions are too confusing.
  7. In return, your parnter will create his/her own Excel assignment; and you will complete that assignment as well
  8. Please keep in mind that all 5 printouts need to be turned-in together and at the same time.  Using your assignment directions, you need to turn-in the following:
    1. Assignment Directions (MS-Word)
    2. Excel Values Printout
    3. Excel Formulas Printout
    4. Excel Values Printout (Completed by your partner)
    5. Excel Formulas Printout (Completed by your partner)

Thursday, March 10 (B)/Monday, March 21 (B)
Friday, March 11 (A)/Tuesday, March 22 (A)

  • Lesson 2, Exercise 17 (Pg. 275 - 278)
  • Read and review Exercise chapter
    • Named Ranges
  • Right-click here (Save Link As...), and save file as 17BidAnalysis
  • PRINT 17BidAnalysis spreadsheet with "Header", "Gridlines", and "Row/Column Headings"
  • Step 12: 
    • PRINTOUT #1:  PRINT the spreadsheet - with values
    • Insert the (sheet name) in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section key "Values"
    • Use Page Break Preview, and ensure that printout fits on 1 page.  You MIGHT have to:
      1. Change to Landscape Orientation
      2. Change Left and Right Margins
      3. Change Bottom Margin
    • PRINTOUT #2:  PRINT the spreadsheet - with formulas
    • Insert the (sheet name) in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section key "Formulas"
    • Use Page Break Preview, and ensure that printout fits on 1 page.  You MIGHT have to:
  1. Change to Landscape Orientation
  2. Change Left and Right Margins
  3. Change Bottom Margin

 

  • ON YOUR OWN (Pg. 279)
  • Right-click here (Save Link As...), and save file as 17CDMania
  • Save file as OXL17
  • Step 7: 
    • Select the QtrOne range
    • Print Preview the range
    • Select the QtrTwo range
    • Print Preview the range
    • Do NOT print the ranges...
       
  • Step 12: 
    • PRINTOUT #3:  PRINT the spreadsheet - with values
    • Insert the (sheet name) in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section key "Values"
    • Use Page Break Preview, and ensure that printout fits on 1 page.  You MIGHT have to:
      1. Change to Landscape Orientation
      2. Change Left and Right Margins
      3. Change Bottom Margin
    • PRINTOUT #4:  PRINT the spreadsheet - with formulas
    • Insert the (sheet name) in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section key "Formulas"
    • Use Page Break
    • Preview, and ensure that printout fits on 1 page.  You MIGHT have to:
      1. Change to Landscape Orientation
      2. Change Left and Right Margins
      3. Change Bottom Margin

Monday, February 21 (B)/Wednesday, February 23 (B)
Tuesday, February 22 (A)/Thursday, February 24 (A)

Lesson 2, Exercise 16 (Pg. 270 - 273):  Assignment #1

  • Read and review Exercise chapter
    • Excel Tables
    • Comments
  • Right-click here (Save Link As...), and save file as 16RHSales
  • PRINT 16RHSales spreadsheet with "Header", "Gridlines", and "Row/Column Headings"
  • Step 16: 
    • PRINT # 1:  Spreadsheet - With Values
    • Insert the (sheet name) in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section key "Values"
    • Use Page Break Preview, and ensure that printout fits on 1 page.  You MIGHT have to:
      1. Change to Landscape Orientation
      2. Change Left and Right Margins
      3. Change Bottom Margin

       

    • PRINT #2:  Spreadsheet - With Formulas
    • Insert the (sheet name) in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section key "Formulas"
    • Use Page Break Preview, and ensure that printout fits on 1 page.  You MIGHT have to:
      1. Change to Landscape Orientation
      2. Change Left and Right Margins
      3. Change Bottom Margin

 

ON YOUR OWN (Pg. 274):  Assignment #2

  • Create a new file in Excel, and save file as OXL16
  • Step 19: 
    • PRINT#3:  Spreadsheet - With Values
    • Insert the (sheet name) in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section key "Values"
    • Use Page Break Preview, and ensure that printout fits on 1 page.  You MIGHT have to:
    1. Change to Landscape Orientation
    2. Change Left and Right Margins
    3. Change Bottom Margin
    • PRINT #4:  Spreadsheet - With Formulas
    • Insert the (sheet name) in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section key "Formulas"
    • Use Page Break Preview, and ensure that printout fits on 1 page.  You MIGHT have to:
      1. Change to Landscape Orientation
      2. Change Left and Right Margins
      3. Change Bottom Margin

Wednesday, February 16 (A)
Thursday, February 17 (B)

  • QUIZ GRADES - 2
    Review previous day's 15BidAnalysis file...
    Save file posted on website (REPLACE IF FILE ALREADY EXISTS)
    Review ALL spreadsheet formulas
    Review "VALUES" and "FORMULAS" printout
    Review How To Print spreadsheet with FORMULAS

 

  • QUIZ GRADES - 2
    Key the spreadsheet information on HANDOUT #1
    Format the spreadsheet to reflect the informaion on HANDOUT #1
    Follow the instructions on HANDOUT #2

Monday, February 14 (A)
Tuesday, February 15 (B)

  • Lesson 2, Exercise 12 (Pg. 251 - 254)
  • Read and review Exercise chapter
    • Insert, Delete, Copy, Move, and Rename Worksheets
    • Change the Color of a Worksheet Tab
    • Hide Sheets
    • Group Sheets
  • Right-click here (Save Link As...), and save file as 12SpaServices
  • PRINT 12SpaServices spreadsheet with "Header", "Gridlines", and "Row/Column Headings"
  • Step 13:  PRINT only the Saturday worksheet
    • Insert the sheet name in the Custom Footer Center Section
    • Print Landscape Orientation
    • Change Left/Right Margins to 0.25"
    • Change Bottom Margin to 0.5"
    • Use Page Break Preview, and ensure that printout fits on 1 page

 

  • Lesson 3, Exercise 15 (Pg. 262 - 268)
  • Read and review Exercise chapter
    • Use Functions
    • Common Functions
    • Insert a Function
    • AutoCalculate
  • Right-click here (Save Link As...), and save file as 15BidAnalysis
  • Step 12: 
    • PRINT the spreadsheet with values
    • Insert the sheet name in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section key "values"
    • Be sure printout "fits" on one page.  Use the following to make this possible.
    1. Print Portrait Orientation
    2. Change Left and Right Margin to 0.25"
    3. Change Bottom Margin to 0.5"
    4. Select Page Break Preview, and ensure that printout fits on 1 page
    • PRINT the spreadsheet with formulas
    • Insert the sheet name in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section key "formulas"
    • Be sure printout "fits" on one page.  Use the following to make this possible.
      1. Print Landscape Orientation
      2. Change Left and Right Margin to 0.25"
      3. Change Bottom Margin to 0.75"
      4. Select Page Break Preview, and ensure that printout fits on 1 page

Thursday, February 10 (A)
Friday, February 11 (B)

  • EXAM GRADE/DAILY GRADE:
  • Step-by-Step Assignment EXAM (Excel Handout)
    Review of Excel Exam will count as a 2nd Exam grade, and Daily grade...

Tuesday, February 08 (A)
Wednesday, February 09 (B)

  • EXAM GRADE:
  • Step-by-Step Assignment EXAM (Excel Handout)
    Be sure to read BOTH pages of the Handout...

Wednesday, February 02 (B)
Thursday, February 03 (A)

  • DAILY GRADE:
  • Step-by-Step Assignment (Excel Handout)

Tuesday, February 01 (A)
Friday, February 04 (B)

  • QUIZ GRADE
    Wait for additional instructions before beginning...
     
  • Lesson 2, Exercise 11 (Pg. 246 - 249)
  • Read and review Exercise chapter
    • Insert and Delete Columns and Rows
    • Move Data (Cut/Paste)
    • Drag-and-Drop Editing
  • Right-click here (Save Link As...), and save file as 11Payroll
  • Step 17:  PRINT Payroll worksheet
    • Insert the sheet name in the Custom Footer Center Section
    • On the printout, WRITE the formula from H36
    • Be sure printout "fits" on one page.  Use the following to make this possible.
    1. Change to Landscape Orientation
    2. Change Left and Right Margin to 0.25"
    3. Change Bottom Margin to 0.5"
    4. Select Page Break Preview, and ensure that printout fits on 1 page

Wednesday, January 26 (A)
Monday, January 31 (B)

  • Lesson 2, Exercise 9 (Pg. 234 - 239)
  • Read and review Exercise chapter
    • Choose a Theme
    • Apply Cell Styles (Quick Styles)
    • Apply Font Formats
    • Apply Number Formats
  • Right-click here (Save Link As...), and save file as 09Inventory
  • PRINT 09Inventory spreadsheet with "Header", "Gridlines", and "Row/Column Headings"
    • Change to Landscape Orientation
    • Change Bottom Margin to 0.5"
    • Select Page Break Preview, and ensure that printout fits on 1 page

  • Lesson 2, Exercise 10 (Pg. 241 - 244)
  • Read and review Exercise chapter
    • Copy and Paste Data
    • Copy Formats
    • Relative Reference
    • Absolute Reference
    • Preview and Print a Worksheet
  • Right-click here (Save Link As...), and save file as 10TripBudget
  • PRINT 10TripBudget spreadsheet with "Header", "Gridlines", and "Row/Column Headings"
  • Step 4:  Copy/Paste the formula using the following Absolute Reference:      =(C11*D11)/$I$14
  • Step 12:  PRINT the Trip Budget worksheet
    • Insert the sheet name in the Custom Footer Center Section
    • On the printout, WRITE the formula copied to E31
    • Be sure printout "fits" on one page.  Use the following to make this possible.
  1. Change Left and Right Margin to 0.25"
  2. Select Page Break Preview, and ensure that printout fits on 1 page
  • Step 12:  PRINT the Cost Analysis worksheet
    • Insert the sheet name in the Custom Footer Center Section
    • On the printout, WRITE the formulas copied to E31, G31, and H31
    • Be sure printout "fits" on one page.  Use the following to make this possible.
  1. Change Left and Right Margin to 0.25"
  2. Select Page Break Preview, and ensure that printout fits on 1 page

Monday, January 24 (A)
Tuesday, January 25 (B)

  • Lesson 1, On Your Own (Pg. 224)
  • Right-click here (Save Link As...), and save file as 05TimeSheet
  • PRINT 05TimeSheet spreadsheet with "Header", "Gridlines", and "Row/Column Headings"
    1. Step 6:  Use =SUM( ) function for the formula in K18.
    2. Switch to Page Break Preview
    3. Include Column K, Column L, and Column M in the printout
    4. Change to Landscape Orientation
    5. Change Left and Right Margin to 0.25"
    6. Change Top Margin to 1"
    7. Change the Scaling:  Fit to 1 page

 

  • Lesson 2, Exercise 8 (Pg. 230 - 232)
  • Read and review Exercise chapter
    • Select Ranges
    • Range Entry Using Collapse Button
  • Right-click here (Save Link As...), and save file as 08Inventory
  • PRINT 08Inventory spreadsheet with "Header", "Gridlines", and "Row/Column Headings"
    • Change to Landscape Orientation

Thursday, January 20 (A)
Friday, January 21 (B)

  • Lesson 1, On Your Own (Pg. 220)
  • Printing a spreadsheet, and include a "Header":
    • Student Name
    • Class Period
    • Date
    • File Name
  • Right-click here (Save Link As...), and save file as 04Homework
  • Right-click here (Open Link in New Tab...), to show how to add a "Header"
  • PRINT 04Homework spreadsheet with "Header", "Gridlines", and "Row/Column Headings"
    1. Use Print Preview before printing
    2. Change to Landscape Orientation

 

  • Lesson 1, Exercise 5 (Pg. 221 - 223)
  • Read and review Exercise chapter
    • Enter a Formula
    • Edit a Formula
  • Right-click here (Save Link As...), and save file as 05Balance Sheet
  • PRINT 05Balance Sheet spreadsheet with "Header", "Gridlines", and "Row/Column Headings"
    1. Change to Landscape Orientation
    2. Change Left and Right Margins to 0.25"
    3. Fit printout to 1 page wide by 1 page tall

Tuesday, January 18 (A)
Wednesday, January 19 (B)

  • QUIZ GRADE:
  • Need one student to volunteer...
  • Student volunteer will log-on to Computer #27...
  • Review previous assignments with class...

Wednesday, January 12 (A)
Monday, January 17 (B)

  • BE SURE TO READ ALL THE CHAPTER PAGES
    Review the Procedures Section...
    Follow all the Exercise Directions...
    Check the Web Site for Additional Instructions...
  • Quiz Grade:
    • Lesson 1, On Your Own (Pg. 205)
    • Create file from template, save as 0XL02
    • Complete assignment - Do NOT Print
    • GoTo B19, and type your name
    • GoTo B20, and type "0XL02"
    • GoTo B21, and type Class Period
    • GoTo J20, and type Current Date
    • Print Preview, and Print 0XL02

 

  • Lesson 1, Exercise 3 (Pg. 206 - 211)
  • Read and review Exercise chapter
    • Open Workbooks
    • Change from Workbook to Workbook
    • Compare Workbooks
    • AutoComplete
    • Pick From List
    • Spell Check
  • Right-click here (Save Link As...), and save file as 03Bakery Schedule 7-21
  • Right-click here (Save Link As...), and save file as 03Bakery Schedule 7-20
  • Complete assignment - Do NOT Print

 

  • Lesson 1, Exercise 4 (Pg. 213 - 219)
  • Read and review Exercise chapter
    • Enter Numeric Labels and Values
    • Enter Dates
    • Create a Series
    • Change Data Alignment
    • Change Column Width
  • Right-click here (Save Link As...), and save file as 04MAAC Invoice
  • Complete assignment - Do NOT Print

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

  • Be sure you have a new folder in your "My Documents" folder named EXCEL
  • Discussion of Excel Worksheets, Rows, and Columns
     
  • Lesson 1, Exercise 1 (Pg. 192 - 197)
  • Read and review Exercise chapter
    • Start Excel
    • The Excel Window
    • Excel Interface
    • Navigate the Worksheet
    • Change Between Worksheets
    • Worksheet Views
    • Exit Excel
  • Complete assignment - Do NOT Print

 

  • Lesson 1, On Your Own (Pg. 198)
  • Open Excel, and complete assignment - Do NOT Print

 

  • Lesson 1, Exercise 2 (Pg. 199 - 204)
  • Read and review Exercise chapter
    • Create a New (Blank) Workbook
    • Create a Workbook from a Template or Another Workbook
    • Enter Labels
    • Make Simple Corrections
    • Undo and Redo
    • Delete (Clear) Cell Contents
    • Save a Workbook
    • Close a Workbook
  • Create file from template, save as 02MAAC Invoice
  • Complete assignment - Do NOT Print

Thursday, January 6 (A)
Friday, January 7 (B)

  • QUIZ!!! 
  • Do NOT Log-on...
  • Do NOT Begin...
  • Wait for Further Instructions...
  1. Set Printer Default
  2. Set Econo Mode On - Default Printer
  3. Locate MicroType Pro program, and place shortcut icon on Start Menu
  4. Locate Mozilla Firefox program, and place shortcut icon on Start Menu
  5. Locate student "Network Folder"
    Open "My Documents"
    Open BIM I folder
    Create a new folder and name it Excel
  6. Open Firefox
  7. Enter Mr. Gonzalez's website
  8. Set Firefox Home Page
  9. Modify the Header options to include the Class Period, and your name on each Firefox printout
  10. Complete quiz, save in Excel folder, add a "Normal Header", and print...