Wednesday, May 26 (A)/Friday, May 28 (A)/Tuesday,
June 1
SEMESTER EXAM Will
Include
ALL 5 Kaplan IT Categories: |
- Creating and
Manipulating Data: (11 of 11
items)
- Formatting Data and
Content: (13 of 13 items)
- Creating and Modifying Formulas:
(23 of 23 items)
- Presenting Data Visually:
(19 of 19 items)
- 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:
- Creating and Manipulating Data
- Formatting Data and Content
- Creating and Modifying Formulas
- Presenting Data Visually
- 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:
- Creating and Manipulating Data
- Formatting Data and Content
- Creating and Modifying Formulas
- Presenting Data Visually
- 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:
- Creating and Manipulating Data
- Formatting Data and Content
- Creating and Modifying Formulas
- Presenting Data Visually
- 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
|
-
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
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
|
|
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
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. 2
9
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
- Elect a "team leader"
- Right-click
here
(Save Link As...), and save instructions in your
Excel folder.
- PRINT instructions
- Wait for further instructions...
Thursday, February 04 (A)
Exercise 21 (Lesson 4: Pg. 117 - 120)
Skills Covered
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:
- Change to Landscape Orientation
- Change Left and Right Margins
- Change Bottom Margin
- 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:
- Change to Landscape Orientation
- Change Left and Right Margins
- Change Bottom Margin
- Change the Scaling: Fit to 1
page
Tuesday, February 02 (A)
Exercise
20
(Lesson 4: Pg. 112 - 115)
Skills
Covered
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:
- Change to Landscape Orientation
- Change Left and Right Margins
- Change Bottom Margin
- 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:
- Change to Landscape Orientation
- Change Left and Right Margins
- Change Bottom Margin
- 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
|
|
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
|
|
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
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
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
|
-
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)
Exercise 9 (Lesson 2: Pg. 63 – 65)
Skills Covered
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
- Change to Landscape Orientation
- Change Left and Right Margins to 0.25"
- 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
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.
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
|
-
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
|
-
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
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
|
|
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
|
-
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
|
|
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.
|