1

NO SCHOOL

2

Textbook - Excel. Project 3.

Continue Excel Project 3

3

If you're caught up with all of your work, bring some homework to class to keep yourself busy and let those around you get caught up. Thank you.

4

NO SCHOOL

5

NO SCHOOL

8

Textbook - Excel. Project 3.

Learn it online (pg EX 210). Go to the website. Below Excel Project 3, complete tasks 3 & 4

#3 - Turn in a practice test with at least 80% accuracy - that's 16 correct out of 20. It's OK to use your text book.

#4 Play Who Wants to be a Computer Genius. Print out results and turn in.

I was looking at the #2 Flash Cards section. Do you think we should do this one as well? You can email me with your response to this question (blevinsb@outlawnet.com)

9

Textbook - Excel. Project 3.

Complete "Apply Your Knowledge" on pg EX 211. Answer all 9 questions on a piece of paper and turn in. Don't forget your name.

10

11

Textbook - Excel. Project 3.

In the Lab Problem #1 pg EX 212 - Complete "Projected Quarterly Reports " for Encrypt-It Inc.

There are three parts to this problem.
Part one asks for 15 changes to the worksheet. Print out the page in landscape so it fits on one page. Also, print out the formulas version. Staple together and turn in.

Part two asks for you to create a chart from the worksheet. Print out both sheets that it asks for, staple together and turn in.

Part three asks you to print out one worksheet.

12

Textbook - Excel. Project 3.

Cases and Places Problem #1 - EX 221. Print out the worksheet with an embedded pie chart. Don't forget to perform the what-if-analysis at then end of the problem.

15

Textbook

We continue with Excel. Web Feature -. Dynamic and Static Excel Web Pages. EX225 - EX238

You will need Angelino's Pizzera 3rd Quarter Sales to start this project.

I'll be honest, I had no idea you could publish a dynamic excel page that could be manipulated off of the Internet. I know you will be thinking of all of the business and educational applications as you will be too. We will share these ideas next week when I come back.

16

Textbook - Excel Web Feature

In the Lab Problem #1 pg EX 239 (there are two parts to this problem)- Complete "Creating Static and Dynamic Web Pages 1". You will need Scholastic Fund Raising Annual Sales workbook for this problem.

17

Textbook - Excel Web Feature

In the Lab Problem #2 pg EX 240 (there are two parts to this problem)- Complete "Creating Static and Dynamic Web Pages II". You will need Band Uniforms of America Projections workbook for this problem.

DO NOT print out problem #2. Please email me the Dyanmic Web Page at
blevinsb@outlawnet.com
The subject in the email to me should be "dynamic web page" Thank you.

18

Review -

OK, we're going to get in the way way back machine and see how much you remember from our days working with Microsoft Word. I know, I know, you'll miss Excel.

Turn to page WD 135 in your text - Cases and Places. Complete either 2 (GPS) or 3 (respiratory infections) - your choice. You will need to have two references - this will be on your works cited page at the end of the report. And you will need at least one explanatory note - this goes as a footnote at the bottom of the paper. Of course, you can find all of this on page WD 76.

19

Continue Review

22

Review of Relative and Absolute cell references

23

Review of the IF Function. Formerly known as the IF THEN ELSE Function.

24

Review Freezing Panes and Splitting the window

25

Start Microsoft Outlook you will need the following files for this project:

Lab 1-2 Inbox
Rachel's Inbox
Updated Practice Schedule
Central City Schedule
Lab 1-1
Cases 1-2
Cases 1-3

26