Consult Emileigh Foots' Blog for Spreadsheet Hints

Emileigh Foot's Blog

Consult Emileigh Foots' Blog for Spreadsheet Hints

Emileigh Foot's Blog

Some Reminders About Spreadsheets

Quick Strange Spread Sheet Rules

1. Select a Range using the Shift/Click Technique (Click in start cell; Hold SHIFT key down; click in end cell)
2. Fill Either Down or Right (CONTROL D or CONTROL R) YOU figure out which is R and which is D
3. The function you use to combine text (Insert Function) is Text/Concatenate
4. Sort arranges things
5. Filter turns on arrows which allow you to select a subset of data
6. IF the cell reference STAYS the same, it is an ABSOLUTE REFERENCE and must have a $ before the letter and a $ sign before the number, e.g. $A$24

Important Note About Tabs

1. Set the TABS up BEFORE you type anything!
2. Select the entire tab table before adjusting the tabs.

Footnote Suggestions

1. ALWAYS insert a footnote immediately adjacent to a letter or a punctuation mark. Do not have a space to the left of your cursor when you insert the footnote.

2. Let the computer worry about numbering your footnotes. It will do it accurately.

Strange Rules for Header and Footer

Follow these steps after going to the View menu and clicking on Print Layout:

1. Click on the title page
2. From the View menu, select Header and Footer
3. In the header, type what you want and format and arrange properly.
4. In the footer (BE SURE YOU STAY ON THE TITLE PAGE!), click the center alignment button. From the floating menu, click the # on the left (insert page number). NEVER ignore this step.
5. IF you want the first full page of text to be numbered 1, then click the third # from the left (format page number). Start numbering with 0. Otherwise ignore this step.
6. Click on the book (Page Setup). Click Layout Tab. Check different first page. This is necessary to hide the header and the footer on the title page.
7. From the View menu, once again click on Header and Footer. This will enable you to demonstrate that you have accomplished your objectives.

IF YOU DID NOT CREATE YOUR TITLE PAGE BEFORE YOUR TEXT:
1. Click in front of the first word of the first paragraph you typed.
2. Under Insert Break Select Page Break
3. Click on the new page and type your title page information.
4. Be sure to hit return after the last character you type on that page.
5. Also, after finishing with the header and footer, go to the first full page of text. Click in the first paragraph on that page. Left justify the text. (It will have changed to Center because of what you have done in steps 1-4 above).

Instructions for Class Blog

My requirements have changed. The revised requirements are that:
1. You must make on trial post to the Class Blog in January. I will comment on whether I think you are correctly addressing the assignment and make suggestions if necessary.
2. You must make two posts in February, March and April.
3. You must make at least two comments on at least two other students' posts in January.
4. You must comment on at least four other posts (by other students) during each month: February, March and April.
5. Where appropriate, you must include links to useful web sites.
6. Where appropriate you must include a picture. For example, if you are talking about a specific technology or a specific product, include a picture.
7. You should think of this assignment in this way: I am engaged in a conversation with other students and my professor about how technology can be used in classrooms in general and specifically in MY classroom (the ones you are in now or that you will be teaching in 2 years). You will have to some research as part of this process. You will also have to THINK about the issues that are involved.

Here are some posts made by my students in this "conversation" I held last semester. They may give you some ideas.
Education Today and Blogs
Teaching Breakthrough
I Wasn't Able To Read Everyone's Posts
Blogs
Technology From Dawn Til Dusk

In addition, you might want to read more from last semester's blog Using Technology in Education

There are other ways you might participate. Just remember: It is an electronic conversation!

Instructions For Personal Blogs

• You must make at least one post every week beginning in Week 3-January 23 through the last week of classes
• Every post must consist of 3 parts:
a. A statement identifying something of significance that you learned during the previous week
b. One or two paragraphs describing how you learned what you learned
c. One or two sentences describing how you will use your new knowledge
• You must check the spelling and grammar for all posts. There should be no errors.
• You should include a picture or pictures where appropriate

Example 1:
This week I learned that Cezanne not only painted landscapes but he also painted portraits.

I learned this from my friend, Dr. Michael Hanna. He is taking an art course in which the assignment is to emulate a famous artist and to try and produce a work that even experts would attribute to the artist. He chose Cezanne and Cezanne’s portraits. He showed me several from an art book he had checked out of the library.

I will look for Cezanne’s portraits so that I can learn more about them. I also want to see how successful Mike is (in my opinion) with his assignment.



Paul Cezanne
Portrait of Caillebote

IMPORTANT Pen Drive Instructions

To remove a pen drive:

1. Close all applications!
2. At the bttom right of your screen, locate the icon of a green arrow on top of something. Click. Click Remove Pen Drive. You should then get an OK to remove the pen (USB) drive. ONLY then remove it. If nothing works, shut down the computer. You can then safely remove the pen drive.

Three Important Things About Scanning

1. When you scan, be sure you are only scanning the picture, not the entire bed of the scanner. The picture should be selected (have "running mice" or a selection box around it).

2. You MUST save your picture as a JPEG (file type) and you MUST add .jpg after the name you give the picture. Example: boy.jpg

3. NAME your picture using only lowercase letters and numbers. DO NOT USE SPACES.