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, April 23 (B)
Monday, April 26 (A)

  • STUDENT PORTAL - Log-in to your student portal account, and check assignments/class grade
  • Free Typing Games website certificate right-click here...
    • Choose two (2) "Team" Leaders
    • Lesson ?? (5 Minutes)
    • Lesson ?? (5 Minutes)
    • Lesson ?? (5 Minutes)

   Football Friday
 

  • Right-click here and open score sheet...
  • Form 2 Teams (Purple/Black)
  • Select 2 "Team Leaders"
  • Free Typing Games website certificate right-click here...
  • Wait for further instructions...

Monday, April 19 (B)/Wednesday, April 21 (B)
Tuesday, April 20 (A)/Thursday, April 22 (A)

  • Class Surveys (Sort and Graph) Assignment (Worth FOUR Daily Grades)
  • Open the three (3) links below in separate new tabs
  • Additional Instructions/Information:
    • Use the back of the last keyboarding warm-up lesson to record your survey results
    • Using the back of the last keyboarding warm-up lesson printout, write your name at the top right-hand corner
    • Number your sheet from 1 to 15
    • Ask 15 people what cellular service provider they use
    • Write their name on your numbered list.  Next to their name, write their survey response
    • Follow the assignment instructions, and begin creating the Excel spreadsheet
  • Right-click here (Open Link in New Tab...) Class Surveys (Sort and Graph) Assignment - Instructions
    • EXAMPLES
    • Right-click here (Open Link in New Tab...) to view Spreadsheet example
    • Right-click here (Open Link in New Tab...) to view 3D Clustered Column Graph example
      NOTE:  The above are only EXAMPLES - your survey results WILL vary!!!

 

Staple your work in the following order:

  1. Three (3) keyboarding warm-up lessons
  2. Survey instrument (Be sure to write your name in the top left-hand corner of your paper)
  3. Spreadsheet (VALUES)
  4. Spreadsheet (FORMULAS)
  5. 3D Clustered Column Graph

Friday, April 16 (A)

  • STUDENT PORTAL - Log-in to your student portal account, and check assignments/class grade
  • Free Typing Games website certificate right-click here...
    • Lesson ?? (5 Minutes)
    • Lesson ?? (5 Minutes)
    • Lesson ?? (5 Minutes)

   Football Friday
 

  • Form 2-3 Teams (Purple/Black/White)
  • Select 2-3 "Team Leaders"
  • "Team Leaders" right-click here and open score sheet...
  • Free Typing Games website certificate right-click here...
  • Wait for further instructions...

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

  • STUDENT PORTAL - Log-in to your student portal account, and check assignments/class grade

 

  • BONUS EXAM (Wait for instructions...)

 

  • EXCEL FORMULAS ASSIGNMENT (Worth 2 DAILY Grades)
  • Right-click here (Save Link As...) EXCEL FORMULAS ASSIGNMENT
    • Save spreadsheet as Excel Formulas Assignment

Tuesday, April 06 (A)/Thursday, April 08 (A)
Wednesday, April 07(B)/Friday, April 09 (B)

  • STUDENT PORTAL - Log-in to your student portal account, and check assignments/class grade
  • Data File:  Right-click here (Save Link As...), and save file as Excel Review (2010_04)

     
  • Tech-Prep RGV:  Right-click here...
         Log-on, and sign-up for the 2nd Semester BCIS I (DAILY Grade)


     
  • 5th Six-Weeks Exam
    • Part I - Instructions:  Right-click here (Save Link As...), and save file as Exam (Part I)
    • Part II - Instructions:  Right-click here (Save Link As...), and save file as Exam (Part II)

Thursday, April 01 (A)

  • STUDENT PORTAL - Log-in to your student portal account, and check assignments/class grade
  • Use the class time to make-up any missing tests, assignments, and keyboarding warm-up lessons...

Tuesday, March 30 (A)
Wednesday, March 31 (B)/Monday, April 05 (B)

  • Excel Exam (March 2010) - Part II
  • NOTE:
    You will need BOTH the instructions and the data file below to complete the Exam.  Open the instructions, and save the data file (Excel spreadsheet file).  Open the instructions (you don't need to save).  You may print the instructions if you want, but you don't have to save them to your folder.

    Part II is a continuation of Monday's exam, but it is separate from Monday's exam.  Even if you were absent on Monday, you will need to complete Part II.  Be sure to staple all four (4) printouts of the exam together and in order.  Monday's "Team Leaders" may help you with today's instructions, but you must do your own work.

     

  • Instructions:  Right-click here (Open Link in New Tab...)
  • Data File:  Right-click here (Save Link As...), and save file as Excel Exam - Part II (2010_03)

Friday, March 26 (A)
Monday, March 29 (B)

  • Class will nominate two (2), three (3), or four (4) "Team Leaders"
  • "Team Leaders" MUST accept their nomination
  • "Team Leaders" will review the exam instructions with instructor (20 minutes total)

     
  • Excel Exam (March 2010)
     
  • Instructions:  Right-click here (Open Link in New Tab...)

Thursday, March 25 (B)

  • STUDENT PORTAL - Log-in to your student portal account, and check assignments/class grade
  • Free Typing Games website certificate right-click here...
    • Lesson 28 (5 Minutes)
    • Lesson 29 (5 Minutes)
    • Lesson 30 (5 Minutes)
    • Lesson 31 (5 Minutes)

Wednesday, March 24 (A)

  • WORTH: FIVE (5) DAILY GRADES
    MicroType Purple Lesson "5", "6", "7", "8", and "9"
    Whole Lesson (All Tabs )
    Print Lesson Reports (Page 1 ONLY)

Monday, March 22 (A)
Tuesday, March 23 (B)

  • Lesson 4, Exercise 25 (Pg. 323 - 325)
  • Read and review Exercise chapter
    • Copy and Paste Special
    • Transpose Data
  • Right-click here (Save Link As...), and save file as 25RHSales
  • Step 18: 
    • PRINT the 25RevAnalysis spreadsheet with Values
    • On the 1st line of the Custom Footer Center Section, key:  "Values"
    • On the 2nd line of the Custom Footer Center Section, key:  Pg. 325, Ex. 25
       
    • PRINT the 25RevAnalysis spreadsheet with Formulas
    • On the 1st line of the Custom Footer Center Section, key:  "Formulas"
    • On the 2nd line of the Custom Footer Center Section, key:  Pg. 325, Ex. 25

Friday, March 12 (B)

  • WORTH: FIVE (5) DAILY GRADES
    MicroType Purple Lesson "5", "6", "7", "8", and "9"
    Whole Lesson (All Tabs )
    Print Lesson Reports (Page 1 ONLY)

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

Check your grades on the Student Portal...

  • QUIZ - Critical Thinking (Pg. 303)
  • Right-click here (Save Link As...), and save file as 21RHSales
  • Right-click here (Save Link As...), and save file as sander.jpg
  • Formulas Overview:
         ROUND Function
         IF
    Function
         SUMIF Function
     
  • Print Spreadsheet with values (Worth 25 Points)
         Include a "Header"
         Include a "Footer" (Pg. 303, Ex. 21) - 1st line
         Include a "Footer" - 2nd line "Values"
         Fit to 1 page
  • Print Spreadsheet with formulas (Worth 25 Points)
         Include a "Header"
         Include a "Footer" (Pg. 303, Ex. 21) - 1st line
         Include a "Footer" - 2nd line "Formulas"
         Fit to 2 pages

    Quarter 3 Revenues Chart (Worth 50 Points)
    • Insert the (Sheet Name) - Column Chart #1 in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section, key:  Quarter 3 Revenues Chart - Pg. 303, Ex. 21

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

  • WORTH:  FOUR (4) DAILY GRADES
  • MicroType Purple Lesson "12", "1", "2", and "3"
  • Whole Lesson (All Tabs )
  • Print Lesson Reports (Page 1 ONLY)

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

  • ON YOUR OWN (Pg. 302)
  • Right-click here (Save Link As...), and save file as 20CDMania
  • PRINT All 3 Charts:
              Make at least 5 formatting changes to the chart
              Include the following on the Custom Footer:

    Step 5:
    1st Chart (Daily Grade #1)

    • Make at least 5 formatting changes to the chart
    • Insert the (Sheet Name) - Bar Chart #1 in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section, key Quarter 1 Sales Chart - Pg. 302, On Your Own

    2nd Chart (Daily Grade #2)

    • Make at least 5 formatting changes to the chart
    • Insert the (Sheet Name) - Column Chart #2 in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section, key Quarter 1 Sales Chart - Pg. 302, On Your Own

    Step 7:
    3rd
    Chart (Daily Grade #3)

    • Make at least 5 formatting changes to the chart
    • Insert the (Sheet Name) - Area Chart #3 in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section, key Average Sales Chart - Pg. 302, On Your Own

 

Monday, March 01 (A)
Tuesday, March 02 (B)

  • Lesson 2, Exercise 20 (Pg. 294 - 301)
  • Read and review Exercise chapter
    • Change Data Series Orientation
    • Format a Chart
    • Resize, Move, or Delete a Chart Object
    • Change Chart Text
    • Enhance Chart Background
    • Format Category and Value Axis
  • Right-click here (Save Link As...), and save file as 20DailyBreadSales
  • Right-click here (Save Link As...), and save file as bread.jpg
  • Step 4: 
    • PRINT the Column Chart (Refer to Illustration A on Page 301)
    • Insert the (Sheet Name) Column Chart #1 in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section, key Pg. 300, Ex. 20

     

  • Step 5: 
    • PRINT the 3-D Pie Chart (Refer to Illustration B on Page 301)
    • Insert the (Sheet Name) 3-D Pie Chart #2 in the Custom Footer Center Section
    • On the 2nd line of the Custom Footer Center Section, key Pg. 300, Ex. 20

 

Thursday, February 25 (A)
Friday, February 26 (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

Tuesday, February 23 (A)
Wednesday, February 24 (B)

  • 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

Monday, February 22 (B)
The following will count as 4 separate DAILY grades for TODAY

    • MicroType Blue Lesson "1"
    • MicroType Blue Lesson "2"
    • MicroType Blue Lesson "3"
    • MicroType Blue Lesson "4"
    • Whole Lesson (ALL TABS)
    • Print Lesson Reports (Page 1 ONLY)

Tuesday, February 16 (B)/Thursday, February 18 (B)
Wednesday, February 17 (A)/Friday, February 19 (A)

4th Six-Weeks Exam

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


Friday, February 05 (B)/Wednesday, February 10 (B)/Friday, February 12 (B)
Tuesday, February 09 (A)/Thursday, February 11 (A)/Monday, February 15 (A)

Super Bowl History Assignment - (2 Daily Grades)

 

QUIZ ASSIGNMENT - (Worth 2 Quiz Grades)

"B" Day Deadline

  • Printout of Assignment Instructions Due:  Friday, February 12, 2010
  • Printout of Spreadsheet Values Printout Due:  Friday, February 12, 2010
  • Printout of Spreadsheet Formulas Printout Due:  Friday, February 12, 2010

"A" Day Deadline

  • Printout of Assignment Instructions Due:  Monday, February 15, 2010
  • Printout of Spreadsheet Values Printout Due:  Monday, February 15, 2010
  • Printout of Spreadsheet Formulas Printout Due:  Monday, February 15, 2010

 

  1. Divide yourselves into two (2) teams
  2. Elect a "team leader"
  3. Right-click here (Save Link As...), and save instructions in your Excel folder.
  4. PRINT instructions
  5. Wait for further instructions...

Wednesday, February 03 (B)
Thursday, February 04 (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: 
    • 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.  To make this possible, you MIGHT have to:
      1. Change to Landscape Orientation
      2. Change Left and Right Margins
      3. Change Bottom Margin
      4. Change the Scaling:  Fit to 1 page
    • 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.  To make this possible, you MIGHT have to:
  1. Change to Landscape Orientation
  2. Change Left and Right Margins
  3. Change Bottom Margin
  4. Change the Scaling:  Fit to 1 page

 

  • 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: 
    • 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.  To make this possible, you MIGHT have to:
    1. Change to Landscape Orientation
    2. Change Left and Right Margins
    3. Change Bottom Margin
    4. Change the Scaling:  Fit to 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.  To make this possible, you MIGHT have to:
      1. Change to Landscape Orientation
      2. Change Left and Right Margins
      3. Change Bottom Margin
      4. Change the Scaling:  Fit to 1 page

Monday, February 01 (B)
Tuesday, February 02 (A)

  • Lesson 2, Exercise 16 (Pg. 270 - 273)
  • 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 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.  To make this possible, you MIGHT have to:
      1. Change to Landscape Orientation
      2. Change Left and Right Margins
      3. Change Bottom Margin
      4. Change the Scaling:  Fit to 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.  To make this possible, you MIGHT have to:
      1. Change to Landscape Orientation
      2. Change Left and Right Margins
      3. Change Bottom Margin
      4. Change the Scaling:  Fit to 1 page

 

  • ON YOUR OWN (Pg. 274)
  • Create a new file in Excel, and save file as OXL16
  • Step 19: 
    • 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.  To make this possible, you MIGHT have to:
    1. Change to Landscape Orientation
    2. Change Left and Right Margins
    3. Change Bottom Margin
    4. Change the Scaling:  Fit to 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.  To make this possible, you MIGHT have to:
      1. Change to Landscape Orientation
      2. Change Left and Right Margins
      3. Change Bottom Margin
      4. Change the Scaling:  Fit to 1 page

Thursday, January 28 (B)
Friday, January 29 (A)

  • 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"
    • Be sure printout "fits" on one 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. Change the Scaling:  Fit to 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. Change the Scaling:  Fit to 1 page

Monday, January 25 (A)
Tuesday, January 26 (B)
Wednesday, January 27 (A)

  • 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. Change the Scaling:  Fit to 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. Change the Scaling:  Fit to 1 page

 

  • QUIZ GRADE
  • 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. Change the Scaling:  Fit to 1 page

Thursday, January 21 (A)
Friday, January 22 (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

 

  • 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"
    • Change Scaling:  Fit to 1 page

Tuesday, January 19 (A)
Wednesday, January 20 (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"

 

  • 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

 

  • 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"
    • You will need to change the top margin to 1" before printing...

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

  • STUDENT PORTAL - Log-in to your student portal account, and check assignments/class grade

 

  • 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 11 (A)
Tuesday, January 12 (B)
 

  • Create a new folder in your "My Documents" folder, and name it 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