Tips for Excel Exam

Total Num formula(G2): =(C2*$B$13)+(D2*$B$14)+(E2*$B$15)+(F2*$B$16)

SUM FOR WEIGHING(B17): =SUM(B13:B16) *REMEMBER TO PUT THE HEADING "WEIGHTING" ON A12
MAKE SUR THE WEIGTING NUMBERS ARE LIKE "0.15" EXAMPLE

MAKE VLOOKUP TABLE HEADING AT D12 "VLOOKUP TABLE" UNDERNEATH THAT "GRADE NUMBER/GRADE LETTER" 0=F 60=D 70=C 80=B 90=A (D13) (E13)

FINAL NUM FORMULA(I2): IF(H2="YES",G2+$B$18,G2)

LETTER GRADE FORMULA NEXT TO THAT: VLOOKUP(I2,$D$13:$E$17,2)

COLUMNS ON TOP: A1=FIRST NAME B1=LAST NAME C1=QUIZ 1 D1=QUIZ 2 E1= QUIZ 3 F1=FINAL G1=TOTAL NUM H1=ON TIME I1=FINAL NUM J1=LETTER GRADE

LEFT HAND SIDE COLUMNS: A12=WEIGHTING A13=Q1 A14=Q2 A15=Q3 A16=FINAL A17=TOTAL A18=BONUS

DATABASE-A COLLECTION OF DATA ABOUT SOMETHING OR SOMETHING

ICON- A FIELD ABOUT A PARTICULAR RECORD

CONCATENATE- COMBINE FUNCTION

RANGE OF CELLS- START IN ONE DELL END IN ANOTHER CELL

TO CONCATENATE: INSERT FUNCTION, CATEGORY:TEXT, OK, TEXT 1 L2 TEXT 2 ", SPACE" TEXT 3 M2 TEXT 4 "SPACE" TEXT 5 N2

TO DO RANGE OF CELLS: CLICK ON START CELL, HOLD SHIFT, CURSOR OVER END CELL, LEFT CLICK, HOLD DOWN CTRL AND HIT LETTER D AT THE SMAE TIME.

RELATIVE REFERENCE- IS EVERY CELL THAT CAN CHANGE

ABSOLUTE REFERENCE- TABLE THAT CANNOT CHANGE OR MOVE

Tips for Microsoft Word Test

To center text vertically go to print preview and press center til the text is right in the middle of the page.

For footnotes the cursor has to be by a letter or period where you want to enter the footnote at. Go to insert, reference, footnote, bottom of page.

To indent paragraphs: go to format, paragraph, then set indentation left and right to whatever you need it to be. Or the little triangle on the guided ruler.

To replace words go to edit replace type in what word you want replaced then what word to replace it with.

To do headers click view headers and footers then type in your header the way you want it.

To hide the header and footer on the first page on the header and footer tool bar click the book (page setup) then click on the layout tab. Then click on different first page.

To create a table and set tabs (this is not a table with gridlines) click on the different tabs left, right, center, and decimal tab. upper left corner then put the tabs where you want them.

Heart

This week I learned that to be successful in anything you have to have alot of heart.

I am a Graduate Assistant Coach at my old High School George County High School in Lucedale, Mississippi. I coach the Girl's and Guys Basketball teams ,and this past Friday Night I saw my guys play Pascagoula at our place on Senior Night and absolutely play with no heart and no emotion it made me so upset and mad. You have to have heart in everything that you do if you want it to turn out well.

I am going to use this to make sure that when I am teaching and Coaching that I never not put my heart into what I am doing.

The Constitution

I learned a lot about the Constitution of the United States this week.

I learned that the National Government and State Governments are always in a power struggle. Each does not want to give power to the other. That is the way it has always been in the United States and probably always will be.

I am going to use this information to educate my students about this countries history when I start teaching. Most people have no idea what is going on in the world around them and they need to.

Power Point

This week I learned that Power Point can be used in many different ways to help educate students.

We were talking in class and Dr. Strange was talking about when we are teaching we could use Power Point to teach with. He said we could maybe make slide shows and hopefully it would make it easier for the students to learn the material. I had never really thought about that before and it is an interesting concept.

I am planning on using this information to help me teach History. I think I will make a Power Point on the Civil War when I start teaching because that really interests me. I also may make a slide show of World War II as well. I think it would really be neat.

Welcome To My Blog

Welcome to Patrick Marshall's Blog. I am 20 years old. I am a secondary education major. I want to be a high school history teacher and a high school basketball head coach.