Thursday, March 31, 2011

POP quiz

What I have leaned about Google Documents:
  • Google documents does not work well with Microsoft word
    • I did not save my word file as a PDF file so when it appeared in Google Docs it was messy which is not professional at all
  • Does not work at all with Excel.
  • Is easy to store papers on because they are always there and easy to assess.
What I have learned about APA:
  • American Psychological Association
  • Most teachers use
  • Citing is different the MLA
  • Page header on each page
  • Double spaced
  • 1" margin on all sides
Here is a screen cast on how to install an analysis tool pack in Excel.
Finally here is how you use the Tool pack to do a T Test

class on 03/29

Last class period I was absent but I recieved an email about what to copy and past into my reasearch project. This project has been very confusing for me with APA format. I have done previous papers in the APA format but nothing like this. A link that hels cite information in APA is Purdue Owl.

Tuesday, March 8, 2011

EXCEL spreadsheet 3

Today, we took results from a previous research project and learned how to do the following things:
-Formula / Function / Cell / range /Active cell / Column / Row / Handle /Context sensitive cursor
-Count, Countif, % formula, function, syntax
-Copy and paste formulas and/or functions.
-Functions / Function toolbar / Keyword search on function / Syntax / Formulas
This will help us easily get percents and numbers fast.
Also, Google docs does can not load some of the formuallas that Excel uses. Do not load excel spreadsheets to Google Docs, instead email it as an attachment to yourself or save to a jumpdrive.

Tuesday, March 1, 2011

Excel Grades

Today, we learned how to average grades on Excel. Averaging grades is much easier on Excel, you do not have to sit there with a calculate and worry that you missed a grade. Click here to see my spreadsheet.

Skills/Outcomes: Using the average function, copy and pasting text, formulas, using the handle, creating sheets, renaming sheets, formulas between worksheets, sorting.