Make your own free website on Tripod.com

Mr. Gonzalez's Website
Weslaco East High School

Wildcats

Excel


| Home |BCIS (II) |
| Access | Excel | MicroType | PowerPoint | Word |

Wednesday, May 26 (A)/Friday, May 28 (A)/Tuesday, June 1

SEMESTER EXAM Will Include
ALL 5 Kaplan IT Categories:

  1. Creating and Manipulating Data:  (11 of 11 items)
  2. Formatting Data and Content:  (13 of 13 items)
  3. Creating and Modifying Formulas:  (23 of 23 items)
  4. Presenting Data Visually:  (19 of 19 items)
  5. Collaborating on and Securing Data:  (14 of 14 items)
  • Kaplan IT Learning Center
    Certification Mode - Practice Exam
    • Practice Exam will include the following 5 categories:
      1. Creating and Manipulating Data
      2. Formatting Data and Content
      3. Creating and Modifying Formulas
      4. Presenting Data Visually
      5. Collaborating on and Securing Data
    • Complete test  (Circle 3 best exam results)
    • Print report (DAILY Grade)
    • Note:  You may attempt the test multiple times.  Print/circle your highest score(s)

Monday, May 24 (A)

  • Kaplan IT Learning Center
    Certification Mode - Practice Exam
    • Practice Exam will include the following 5 categories:
      1. Creating and Manipulating Data
      2. Formatting Data and Content
      3. Creating and Modifying Formulas
      4. Presenting Data Visually
      5. Collaborating on and Securing Data
    • Complete test  (Circle 3 best exam results)
    • Print report (DAILY Grade)
    • Note:  You may attempt the test multiple times.  Print/circle your highest score(s)

Thursday, May 20 (A)

  • Kaplan IT Learning Center
    Learning Mode
    • Choose 1 of the following 5 categories:
      1. Creating and Manipulating Data
      2. Formatting Data and Content
      3. Creating and Modifying Formulas
      4. Presenting Data Visually
      5. Collaborating on and Securing Data
    • Complete test
    • Print report (DAILY Grade)
    • Note:  You may attempt the test multiple times.  Print your highest score

Tuesday, May 18 (A)

  • Kaplan IT Learning Center
    Learning Mode
    • Collaborating on and Securing Data
    • 14 of 14 Items
    • Complete test
    • Print report (DAILY Grade)
    • Note:  You may attempt the test multiple times.  Print your highest grade

Wednesday, May 12 (A)/Friday, May 14 (A)

  • STC Grades Due Friday!!!!
  • Don't Forget STC's Project 4 Assignment
  • Kaplan IT Learning Center
    Learning Mode
    • Presenting Data Visually
    • 19 of 19 Items
    • Complete test
    • Print report (DAILY Grade)

Thursday, May 6 (A)/Monday, May 10 (A)

STC - Project 4 Skills Covered - Worth 2 TEST Grades
    
Working with Macros
     Using Templates
     Using Workgroup Features

     Project 4 Instructions:  Right-click here (Open Link in New Tab...)
     Project 4 Data File:  Right-click here (Save Link As...) XL2007Project7Data


Tuesday, May 4 (A)

Exercise 88 (Lesson 12:  Pg. 458 – 461) - Worth 2 DAILY Grades
READ CHAPTER THOROUGHLY AND CAREFULLY...

Skills Covered

  • Lock/Unlock Cells in a Worksheet

  • Protect a Range

  • Protect a Worksheet

  • Protect Workbooks

Software Skills:  If you design worksheets for others to use, or if you share a lot of workbooks, you may wish to protect certain areas of a worksheet from changes.  you can protect any cell you want to prevent it from accepting new data or changes.  You can also protect an entire worksheet or workbook so that others may only view its contents.

Application Skills:  The specialty end of your business is growing at PhotoTown, and you've created an order form that customers can use when ordering t-shirts, mugs, calendars, and cards emblazoned with a photo.  The order form will be available for use through computers set up in a self-serve area.  To prevent customers from changing the prices or ordering something that's no longer available, you want to protect certain areas of the worksheet, while still allowing you and your assistant full access.

Work together on exercise in groups of 4 students
88PhotoOrderForm
file, Right-Click here (Save Link As) to download/save...
PRINT workbook, and demonstrate workbook/worksheet to instructor for 2 DAILY GRADES...
     1 DAILY Grade assigned for individual work done
     1 DAILY Grade assigned for group work done


Wednesday, April 28 (A)

  • Sports Scavenger Hunt (QUIZ GRADE!!!!)
    • Create a new folder named INTERNET in your BCIS I folder...
    • Right-click here (Save Link As...) Sports Scavenger Hunt

Thursday, April 22 (A)/Monday, April 26 (A)/Wednesday, April 28 (A)

Exercise 39 (Lesson 6:  Pg. 207 – 211) - Worth 2 DAILY Grades
READ CHAPTER THOROUGHLY AND CAREFULLY...

Skills Covered

  • Link Documents with Hyperlinks

  • Add a Hyperlink to a Worksheet

Software Skills:  A hyperlink can connect a worksheet to specific locations within any worksheet in any workbook, or to information on the Internet or the company intranet.  Using a hyperlink is a convenient way to provide quick access to related information.  For example, in a sales worksheet, you could provide a hyperlink to an area in the workbook (or in another workbook) that provides product costs or other revenues.

Application Skills:  You've been put in charge of tracking patient services at Wood Hills Animal Clinic.  You've put together a patient worksheet listing the various pets that have recently visited the clinic and a separate worksheet listing the various pets that have recently visited the clinic and a separate worksheet listing owner information.  Before you get too far on your project, you want to test out its usability, adding hyperlinks that connect each pet with its owner's personal data.  Finally, you want to link from a pet's name to its patient history, which is stored in a third worksheet.

Work together on exercise in groups of 4 students
39Patients
file, Right-Click here (Save Link As) to download/save...
39AkemiHistory file, Right-Click here (Save Link As) to download/save...
39Owners
file, Right-Click here (Save Link As) to download/save...
PRINT workbook, and demonstrate spreadsheet/hyperlinks to instructor for 2 DAILY GRADES...
     1 DAILY Grade assigned for individual work done
     1 DAILY Grade assigned for group work done


Exercise 43 (Lesson 6:  Pg. 234 – 239) - Worth 2 DAILY Grades
READ CHAPTER THOROUGHLY AND CAREFULLY...

Skills Covered

  • Save a Workbook in a Different Format

  • Use Compatibility Checker

  • Create a New Folder for Saving Workbooks

  • Enable Macros in a Workbook

  • Create Original Templates

Software Skills:  If you share Excel data, you can easily save that data in a format that's compatible with the program someone else is using, such as an older version of Excel.  Sometimes you want to share not the data, but the format and formulas in a workbook in a reusable format called a template.  With a template, you can create as many similar workbooks as you like, with only a minimum of effort.  Using macros are also easy, since they are designed to save you time by automating repetitive tasks.

Application Skills:  Since you first started keeping records for Holy Habanero, you've learned quite a lot about using Excel, and so you feel pretty confident in using macros and creating reusable templates, so you'd like to give it a try with a new produce log a colleague has developed.  You also need to convert the worksheet to Excel 2003 format, which is being used by the manager of a different restaurant location.

Work together on exercise in groups of 4 students
43HHProduceLog0214
file, Right-Click here (Save Link As) to download/save...
PRINT workbook, and demonstrate spreadsheet/macro to instructor for 2 DAILY GRADES...
     1 DAILY Grade assigned for individual work done
     1 DAILY Grade assigned for group work done


Exercise 54 (Lesson 8:  Pg. 283 – 286) - Worth 2 DAILY Grades
READ CHAPTER THOROUGHLY AND CAREFULLY...

Skills Covered

  • Create Lookup Functions

Software Skills:  With the lookup functions, you can look up information in a table based on a known value.  For example, you can look up the salesperson assigned to a particular client.  At the same time, you can lookup that client's address and phone number.  You can also look up the sales discount for a particular customer or calculate the bonuses for a group of salespeople based on a bonus structure.  If needed, you can nest a function such as SUM within a lookup function in order to lookup a sum total within a table.  For example, you might want to lookup the total cost of the items in an invoice to calculate the cost of delivering them.

Application Skills:  After learning about the power of Excel's lookup functions, you've decided to use them to make tax time a bit easier.  So in this exercise, you'll add several lookup functions to your income tax worksheets.

Work together on exercise in groups of 4 students
54IncomeTax
file, Right-Click here (Save Link As) to download/save...
54TaxWS file, Right-Click here (Save Link As) to download/save...
Please note:  Step 10c should read F50, and not F42...

PRINT both workbooks for 3 DAILY GRADES...
     (1040 Worksheet - with "Values" and "Formulas")
     (Student Loan Worksheet - with "Values" and "Formulas")
     2 DAILY Grades assigned for individual work done
     2 DAILY Grades assigned for group work done


Tuesday, April 20 (A)

  • Kaplan IT Learning Center
    Learning Mode
    • Creating and Modifying Formulas
    • 23 of 23 Items
    • Continue saved test
    • Print report (DAILY Grade)

 

PRINTOUT IS DUE AT THE END OF CLASS...


Friday, April 16 (A)

5th Six-Weeks Exam
     Kaplan IT Learning Center
     Certification Mode (50 Minute Time Limit)

     PRINT TWO (2) BEST EXAM RESULTS  (WILL GRADE THE BEST OF TWO)
         
Creating and Manipulating Data
         
Formatting Data and Content


Wednesday, April 14 (A)

NOTE:  5th Six-Weeks Exam (Friday, April 16, 2010)!!!

  • Part I:  Creating and Manipulating Data
  • Part II:  Formatting Data and Content

Monday, April 12 (A)

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

     
  • Kaplan IT Learning Center
    Learning Mode
    • Formatting Data and Content
    • 13 of 13 Items
    • Print report (EXAM Grade)

Thursday, April 08 (A)

  • Set-up Kaplan IT Learning Center
     Username/Password
     
  • Learning Mode
    • Creating and Manipulating Data
    • 11 of 11 Items
    • Print report (DAILY Grade)

Thursday, April 01 (A)/Tuesday, April 06 (A)

Excel Exam (Part I & II)

     Excel Review - Excel Review (2010_04)
     Exam Instructions: 
Right-click here (Save Link As...) Excel Exam (2010_04)


Friday, March 26 (A)/Tuesday, March 30 (A)

STC - Project 3 Skills Covered
    
Building Charts
     Inserting Shapes
     Using Images and SmartArt Graphics

     Project 3 Instructions:  Right-click here (Open Link in New Tab...)
     SmartArt Diagram Example:
  Right-click here (Open Link in New Tab...)


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)

Exercise 29 (Lesson 5:  Pg. 165 - 167)

Skills Covered

  • Copy and Paste Special

  • Transpose Data

Software Skills:  You can control how to paste data after you copy it to the Clipboard.  For example, you may copy cells that contain formulas to the Clipboard but only want to paste the results.  Use the time-saving Copy and Paste Special commands for this type of editing.

Application Skills:  As the CFO of Restoration Architecture, you need to create a separate revenue analysis report using the data in the 3rd Quarter Revenue report that you prepared last week.  In this exercise, you'll use Paste Special to get the job done quickly.

Right-click here (Save Link As...), and save file as 29RHSales
Step 18:
 

  • PRINT the 29RevAnalysis 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. 167, Ex. 29
     
  • PRINT the 29RevAnalysis 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. 167, Ex. 29

Thursday, March 11 (A)

Check your grades on the Student Portal...

  • QUIZ - Critical Thinking (Pg. 145)
  • Right-click here (Save Link As...), and save file as 25RHSales
  • 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. 145, Ex. 25) - 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. 145, Ex. 25) - 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. 145, Ex. 25

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)

Monday, March 01 (A)/Friday, March 05 (A)

IF Function Demonstration...

STC - Project 2 Skills Covered
    
Exploring Formula Basics
     Working with Functions
     Using Logical and Financial Functions
     Rounding and Nesting Functions

     Project 2 Instructions:  Right-click here (Save Link As...), and save file as XL2007Project2
     Project 2 Data File:  Right-click here (Save Link As...), and save file as XL2007Section2Data


Tuesday, February 23 (A)/Thursday, February 25 (A)

STC - Project 1 Skills Covered
     Getting Started With Excel
     Creating a Workbook
     Using Editing and Style Tools
     Exploring Home Tab Commands

     Project 1 Instructions:  Right-click here (Save Link As...), and save file as XL2007Project1

 

STC - Project 2 Skills Covered
    
Exploring Formula Basics
     Working with Functions
     Using Logical and Financial Functions
     Rounding and Nesting Functions


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


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)

  • 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. Elect a "team leader"
  2. Right-click here (Save Link As...), and save instructions in your Excel folder.
  3. PRINT instructions
  4. Wait for further instructions...

Thursday, February 04 (A)

Exercise 21 (Lesson 4:  Pg. 117 - 120)

Skills Covered

  • Named Ranged

Software Skills:  At times it may be easier to reference a cell or range of cells with a descriptive name.  For example, a range name can make the formulas in your worksheet easier to understand, and the formatting and printing easier to accomplish.

Application Skills:  As the owner of Restoration Architecture, you're naturally very busy.  So when you learned about range names and how they can make certain tasks easier to understand and complete, you were eager to add them to your worksheets as soon as possible.  In this exercise, you'll modify a recent bid analysis worksheet so you can try out range names.

21BidAnalysis file, Right-Click here (Save Link As) to download/save...
Once you enter ALL the formulas,
verify your results against the completed spreadsheet in Illustration A & B

PRINT BOTH SPREADSHEET Ranges with values before closing
PRINT BOTH SPREADSHEET Ranges with formulas before closing
Add A46:G49 to the Bid Analysis Print Area
with "Normal" Header
with Footer (Pg. 120, Exercise 21) - line 1
with Footer ("Bid Results") - line 2 on 1st spreadsheet range printout
with Footer ("Bid Analysis") - line 2 on 2nd spreadsheet range printout
with Gridlines and Row and Column Headings


ON YOUR OWN (Pg. 121)
Right-click here (Save Link As...), and save file as 21CDMania
Save file as OXL21

  • 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

Tuesday, February 02 (A)

Exercise 20 (Lesson 4:  Pg. 112 - 115)

Skills Covered

  • Create and Use Excel Tables

  • Use Comments

Software Skills:  Format a range as an Excel table to enable structured references and add comments to your worksheet to help you read the formulas or remember why you included certain information in your worksheet.

Application Skills:  You are the CFO (Chief Financial Officer) of Restoration Architecture, and it's time for the quarterly revenue recap.  This time, however, you want to make some modifications that will make the formulas easier to follow.  This will help you in future quarters, when you use this workbook as a template for new workbooks.

20RHSales file, Right-Click here (Save Link As) to download/save...
Once you enter ALL the formulas,
verify your results against the completed spreadsheet in Illustration A

PRINT SPREADSHEET with values
PRINT SPREADSHEET with formulas
Change to LANDSCAPE Orientation
Change Left and Right Margin to 0.25", and Bottom Margin to 0.5"
"Fit to 1 Page" to make sure spreadsheet fits on one page
with "Normal" Header
with Footer (Pg. 115, Exercise 20)
with Gridlines and Row and Column Headings


ON YOUR OWN (Pg. 116)
Create a new file in Excel, and save file as OXL20
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

Friday, January 29 (A)

Exercise 16 (Lesson 3:  Pg. 93 – 96)

Skills Covered

  • Insert, Delete, Copy, Move, and Rename Worksheets

  • Change the Color of a Worksheet Tab

  • Hide Sheets

  • Group Sheets

Software Skills:  Use workbook sheets to organize your reports.  For example, instead of entering the data for an entire year on one worksheet, use multiple worksheets to represent each month's data.  Excel gives you the freedom to add, delete, move, and even rename your worksheets so you can keep a complex workbook organized.  In addition, you can group multiple sheets and work on them simultaneously and quickly format an entire worksheet in one step.

Application Skills:  As the Manager of Spa Services at the Michigan Avenue Athletic Club, you were just not satisfied with the spa invoicing worksheet you created earlier.  After using it for awhile, you've reworked it a bit and now it seems easier to use, so now you're ready to make copies of it for tracking each day's services.

16SpaServices file, Right-Click here (Save Link As) to download/save...
Verify your formatting results against the completed spreadsheet in Illustration A


Click on Friday's Tab, and PRINT SPREADSHEET
with "Normal" Header
with Footer (Pg. 96, Exercise 16) - line 1
with Footer (sheet name) - line 2
with Gridlines and Row and Column Headings


Exercise 19 (Lesson 4:  Pg. 104 – 109)

Skills Covered

  • Use Functions

  • Common Functions

  • Insert a Function

  • AutoCalculate

Software Skills:  Use an Excel function to help you write a formula to perform specific calculations in your worksheet.  Excel's Insert Function feature provides a list of available functions with a wizard to assist you in "filling i the blanks" to complete a formula.

Application Skills:  You're the owner of Restoration Architecture, a large design and construction firm specializing in the remodeling, redesign, and restoration of existing properties.  The bid results are in for a project involving the restoration of several homes in an historic downtown neighborhood.  The homes were recently purchased by the Save Downtown Phoenix Committee, who asked for the bids.  Unfortunately your company didn't get the bid, so you want to analyze the results and determine how far off the mark you were.

Pop Quiz Grade
19BidAnalysis
file, Right-Click here (Save Link As) to download/save...
Once you enter ALL the formulas, enter the following Regular and Overtime Hours
Verify your results against the completed spreadsheet in Illustration A & B

PRINT BOTH SPREADSHEET Ranges with values before closing
PRINT BOTH SPREADSHEET Ranges with formulas before closing
with "Normal" Header
with Footer (Pg. 109, Exercise 19) - line 1
with Footer ("Bid Results") - line 2 on 1st spreadsheet range printout
with Footer ("Bid Analysis") - line 2 on 2nd spreadsheet range printout
with Gridlines and Row and Column Headings


Monday, January 25 (A)
Wednesday, January 27 (A)

Exercise 14 (Lesson 3:  Pg. 83 – 86)

Skills Covered

  • Copy and Paste Data

  • Copy Formats

  • Relative Reference

  • Absolute Reference

  • Preview and Print a Worksheet

Software Skills:  Excel provides many shortcuts to save you time as you enter data and write formulas in your worksheets.  For example, you can use the copy and paste features to reuse data and formulas in the same worksheet, in another worksheet, or in another workbook.  The AutoFill handle bypasses the copy and paste features and allows you to copy data to adjacent cells quickly and easily.  After copying data and completing a report, you can preview and print a hard copy.

Application Skills:  As an Adventure Coordinator for Voyager Travel Adventures, it's your job to make all the arrangements needed to create a unique and thrilling adventure vacation for your clients.  Today, the Tell City Thrill Seekers Club has asked for an estimate of expenses per person for a special trip that combines white water rafting, backcountry hiking, rock climbing, and all-terrain skating.  You've completed a budget for them, which can be adjusted easily as more of their club members sign up for the trip.  You've also created a profit analysis for the company, computing the total profit for the booking (upon which your commission is based).  To complete the two worksheets, you need to create some formulas and copy them.

14TripBudget file, Right-Click here (Save Link As) to download/save...

PRINT BOTH SPREADSHEETS with values before closing
PRINT BOTH SPREADSHEETS with formulas before closing
with "Normal" Header
with Footer (Pg. 86, Exercise 14) - values or formulas:  line 1
with Footer (sheet name):  line 2
with Gridlines and Row and Column Headings


QUIZ GRADE
Exercise 15 (Lesson 3:  Pg. 88 – 91)

Skills Covered

  • Insert and Delete Columns and Rows

  • Move Data (Cut/Paste)

  • Drag-and-Drop Editing

Software Skills:  After you create a worksheet, you may want to rearrange data or add additional information.  For example, you may need to insert additional rows to a section of your worksheet because new employees have joined a department.  With Excel's editing features, you can easily add, delete, and rearrange entire rows and columns.  You can also move or drag and drop sections of the worksheet with ease.

Application Skills:  You are the Payroll Manager at Whole Grains Bread.  The conversion to an in-house payroll system is next week, and you want to test a payroll worksheet the staff will use to collect and enter payroll data into the computer system.  You're about ready to test out the worksheet using the home office data, but you need to modify it slightly first.

15Payroll file, Right-Click here (Save Link As) to download/save...
Be sure your copy the formulas in H12:K12 to I25:L25
Once you enter ALL the formulas, enter the following Regular and Overtime Hours
Verify your results against the completed spreadsheet in Illustration A

Employee
Name
Regular
Hours
Overtime
Hours
  Thomas Cortese 10    0    
  Javier Cortez 20    0    
  Rocio Cortez 30    0    
  Allen Gaines 40    0    
  Freda Gage 40    0    
  Vickie Helms 40    0    
  Isiah Herron 40    0    
  Thomas Kaminski 40    0    
  Jalaine Kane 40    0    
  Sami Kafawy 40    0    
  Akihiko Nakamura 40    5    
  Chris Nakao 40    10    

PRINT SPREADSHEETS with values before closing
PRINT SPREADSHEETS with formulas before closing
with "Normal" Header
with Footer (Pg. 91, Exercise 16) - values or formulas
with Gridlines and Row and Column Headings


Thursday, January 21 (A)

Exercise 11 (Lesson 2:  Pg. 69 – 70)

Application Skills:  Your social studies class is learning about the stock market.  Each student will be given $20,000 in pretend money to invest in up to five stocks.  You’ll make your selection from a list of stocks provided for you.  Each week on Monday, you’ll update your worksheet with each stock’s current value.  At the end of three months, each student’s portfolio will be compared, and the one with the highest current value will win.  In this exercise, you’ll create a worksheet to track each stock you select and its current value.

11StockChoices file, Right-Click here (Save Link As) to download/save...

Format all "money" fields as Currency
PRINT SPREADSHEET with values before closing (Landscape Orientation)
PRINT SPREADSHEET with formulas before closing (Landscape Orientation)
with "Normal" Header
with "Normal" Footer (Pg. 69, Exercise 11)
with Gridlines and Row and Column Headings
Change to Landscape Orientation


Exercise 12 (Lesson 3:  Pg. 72 – 74)

Skills Covered

  • Select Ranges

  • Range Entry Using Collapse Button

Software Skills:  Select a group of cells (a range) to copy, move, or erase them in one step, or to quickly apply the same formatting throughout the range.  You can also perform calculations on cell ranges--creating sums and averages, for example.

Application Skills:  You're the Inventory Manager of the Voyager Travel Adventure retail store, and it's time to organize the monthly inventory.  To help you and your crew take inventory, you've created a new inventory workbook.  You have some adjustments to make before inventory day tomorrow, but they are only minor ones so you should have the workbook ready to go by the end of the day.

12Inventory file, Right-Click here (Save Link As) to download/save...

PRINT SPREADSHEET with values before closing
with "Normal" Header
with Footer (Pg. 74, Exercise 12)
with Gridlines and Row and Column Headings


Exercise 13 (Lesson 3:  Pg. 76 – 81)

Skills Covered

  • Choose a Theme

  • Apply Cell Styles (Quick Styles)

  • Apply Font Formats

  • Apply Number Format

Software Skills:  When you change the appearance of worksheet data by applying various formats, you also make that data more attractive and readable.

Application Skills:  The inventory worksheet is almost completed, but as the Inventory Manager of the Voyager Travel Adventures retail store, you expect more from yourself.  Since you have the time before inventory day tomorrow, you want to spruce up the worksheet prior to printing by adding some formatting.

13Inventory file, Right-Click here (Save Link As) to download/save...

  • Change to Landscape Orientation
  • Change Bottom Margin to 0.5"
  • Change Scaling:  Fit to 1 page

Tuesday, January 19 (A)

  • Right-click here (Open Link in New Tab...), to show how to add a "Normal" Header

Exercise 9 (Lesson 2:  Pg. 63 – 65)

Skills Covered

  • Enter a formula

  • Edit a formula

Software Skills:  One of the benefits of Excel is its ability to create formulas within a worksheet that perform calculations.  When you make a change to a cell that is referenced in a formula, Excel performs the recalculation, and the formula result is automatically updated to reflect the change.

Application Skills:  HelpNow MedCenter is seeking to expand its operations in nearby cities, and a balance sheet must be prepared for prospective franchisees.  Most of the information has already been compiled by accounting, but there are some calculations you need to add to complete it.  As the new Franchise Director, you also have some ratio comparisons you want to add to attract potential investors.

09Balance Sheet file, Right-Click here (Save Link As) to download/save...

PRINT SPREADSHEET with values before closing
PRINT SPREADSHEET with formulas before closing
with "Normal" Header
with "Normal" Footer (Pg. 65, Exercise 9)
with Gridlines and Row and 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

 


Exercise 10 (Lesson 2:  Pg. 67 – 68)

Application Skills:  As the Manager of Spa Services at the Michigan Avenue Athletic Club, you’ve decided to create a worksheet to be used to track the clients using the spa so that they can be properly billed.  After creating the worksheet, you’ll enter the last of today’s clients on the Invoice Worksheet you prepare each day for the Accounting Department.

10InvoiceWS file, Right-Click here (Save Link As) to download/save...

PRINT BOTH SPREADSHEETS with values before closing
PRINT BOTH SPREADSHEETS with formulas before closing
with "Normal" Header
with "Normal" Footer (Pg. 67, Exercise 10)
with Gridlines and Row and Column Headings


Wednesday, January 13 (A)
 

Explain "Header," Gridlines, and Row & Column Headings Printout...

Exercise 6 (Lesson 2:  Pg. 41 – 47)

Skills Covered

  • 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

Software Skills:  To create your first worksheet, you begin by entering the column and row titles (the labels that appear to the right of each row of data and above each data column).  Next, you enter the numeric data, using the row and column labels to help you enter each amount into the correct cell.  As you enter data, you may make a few mistakes and need to correct them.  Finally, you save your workbook before exiting Excel so that the entries are not lost.

Application Skills:  In this exercise, you are the Accounts Receivable Supervisor at the Michigan Avenue Athletic Club, and a member has changed several services and has not paid for them.  You need to create an invoice detailing the charges, with a special reminder that the balance must be paid soon or club privileges will be suspended.  You’ll begin the invoice and complete it in a later exercise.

  • Enter your name in B29

  • Enter class period in B30

PRINT SPREADSHEET before closing WITHOUT a "Normal" Header
and WITHOUT Gridlines and Row and Column Headings


Exercise 7 (Lesson 2:  Pg. 48 – 54)

Skills Covered

  • Open Workbooks

  • Change from Workbook to Workbook

  • Compare Workbooks

  • AutoComplete

  • Pick From List

  • AutoCorrect

  • Spell Check

Software Skills:  After you have saved and closed a workbook, you can open it to view it again or make changes.  After opening several workbooks, you may want to arrange them on-screen so you can view their contents at the same time.  When entering data, take advantage of the many time-saving features Excel offers.  Excel’s AutoComplete feature, for example, automatically completes certain entries based on your previous entries.  AutoCorrect automatically corrects common spelling errors as you type, while the spelling checker proofs your worksheet for any additional errors.

Application Skills:  You’re the Head Chef at Whole Grains Bread, and you need to complete the baking schedule for tomorrow.  You want to compare today’s schedule with yesterday’s, in order to compile a list of any items that were not completed on time.  Those items will be given the highest priority.

07Bakery Schedule 7-21 file, Right-Click here (Save Link As) to download/save...
07Bakery Schedule 7-20 file, Right-Click here (Save Link As) to download/save...

PRINT 07Bakery Schedule 7-21 SPREADSHEET before closing
with "Normal" Header
with Gridlines and Row and Column Headings


Exercise 8 (Lesson 2:  Pg. 55 – 62)

Skills Covered

  • Enter Numeric labels and Values

  • Enter Dates

  • Create a Series

  • Change Data Alignment

  • Change Column Width

Software Skills:  Because Excel allows you to work with numbers so easily, numeric values are one of the most common Excel types.  After typing numbers and labels into a worksheet, you can improve its appearance by changing the alignment of data and widths of columns.  If entering a series of labels (such as Monday, Tuesday, Wednesday) or values (such as 1, 2, 3), use Excel’s AutoFill feature to save data-entry time and reduce errors.

Application Skills:  You are the Accounts Receivable Supervisor at the Michigan Avenue Athletic Club, and a member has charged several services and has not paid them.  You started to create an invoice detailing the charges, but you needed to learn a bit more about Excel before you were ready to continue.  In the meantime, your boss has customized the worksheet and asked you to complete it.  In this exercise, you’ll enter in quantity and price amounts, and on another worksheet you will enter member information for tracking the overdue amount.

08MAAC Invoice file, Right-Click here (Save Link As) to download/save...

PRINT BOTH SPREADSHEETS before closing
with "Normal" Header (including tab name)


Monday, January 12 (A)
 

Lesson 1 (Exercise 1:  Pg. 2 – 10)

Skills Covered

  • About Business Technology

  • About Microsoft Office 2007

  • Use the Mouse

  • Use the Keyboard

  • Start Windows Program

  • Conventions used in This Book

Software Skills:  Microsoft, Office 2007 contains a suite of programs that may be used independently or together to create letters, memos, sales presentations, and budget analyses.  Microsoft Excel, 2007 is one of the main programs in the Microsoft Office 2007 suite.

Application Skills:  You have just been hired as the assistant to the president of Restoration Architecture, a firm that specializes in remodeling, redesign, and restoration of existing properties.  He has asked you to become familiar with Microsoft Office Excel 2007, since the company uses it throughout its business operations.  In this exercise, you’ll start at the beginning, learning how to use a computer and the basic skills that apply to all Windows programs.


Lesson 1 (Exercise 2:  Pg. 11 – 19)

Skills Covered

  • About Commands

  • About the Ribbon

  • Use the Ribbon

  • Use Access Keys

  • Use the Office Button

  • Use the Quick Access Toolbar

  • Use a Mini Toolbar

  • Use Shortcut menus

  • Use Task Panes

Software Skills:  To accomplish a task in any program, you must execute a command.  You select the commands using buttons, menus, and in the case of Office 2007 programs, the Ribbon and the Office Button menu.  Once you learn to use these tools, you will be able to access the features you need to create documents in any Microsoft Office 2007 program, such as Excel 2007.

Application Skills:  To get up to speed using Excel 2007, you want to spend more time exploring the Office 2007 user interface so that you know how to locate and use commands when you need them.  In this exercise, you will practice using the Ribbon, the Office Button, and toolbars, selecting menu commands, and choosing options in dialog boxes.  The techniques you learn here can also be applied to any Office 2007 program you may use.


Lesson 1 (Exercise 3:  Pg. 20 – 26)

Skills Covered

  • Use Window Controls

  • Zoom

  • Scroll

  • Use Multiple Windows

Software Skills:  Controlling the way Microsoft Office 2007 programs and documents are displayed on your computer monitor is a vital part of using the programs successfully.  For example, you can control the size and position of the program window on-screen, and you can control the size a document is displayed.  In addition, you can open more than one window on-screen at the same time, so that you can work with multiple documents and even multiple programs at once.

Application Skills:  As you spend more time working with Microsoft Office 2007 programs, you’ll find that there are many tools that help you do your job more efficiently.  In this exercise, you will learn how to maximize, minimize, and restore windows on your screen, and you will experiment with the zoom level.  You’ll also practice scrolling through a document and opening more than one window at the same time.


Lesson 1 (Exercise 4:  Pg. 27 – 32)

Skills Covered

  • Use the Help Program

  • Search for Help

  • Use the Help Table of Contents

  • Recover a File

Software Skills:  Excel comes with Help information that you can access and display in a window while you work.  You can search for help on a particular topic, or browse through the Help Table of Contents to find the information you need.  The Help program is linked to the Microsoft Office Web site, making it easy to locate and access the most current information available.

Application Skills:  As a new employee at Restoration Architecture, it’s important to learn how to solve programs on your own.  In this exercise, you will learn how to use the Help system to answer the questions you may have while working with Excel.