Class 9 Notes (notes are in progress and are subject to change)

<Log On>

Discourse
Minimize Discourse

Please evaluate Benjamin's presentation:
http://lib.trinity.edu/feedback/evalstud.asp

Copy 9spread from Class folder to your Groups (shared) folder.

Open a new blank Excel workbook. Call it practice and save it in 9spread.

Excel Basics - cells, rows, and data types

Formula bar

My Dear Aunt Sally

Entering and moving information

Autofill & Format Painter

Tools Menu & Custom Lists

Using the Print Preview and Page Setup menu

Spreadsheets:

• Guesstimates
• KRTU Fundraiser
• 

   

• Freeze
• GPA
• DANCE

Homework:

Reading: Text: Chapter 5: Using a Spreadsheet, pp 185-242

Hands-On:

• Practice: Grades - Parts 1-5 (beginning on p. 188 and continuing through the chapter.) Use the file named grades.xlsx in the 9spread folder. See finished example, below (this is for illustration purposes only - the numbers themselves might be different)

\\

• Practice: Examples p. 200-202 (Use the file named examples.xlsx in 9spread folder.)

  

  

  

  

  

  Note - you do not need to print out the worksheets as instructed in the book, but make sure they are completed and saved in the correct folder

• Microsoft Excel 2007 Training
  http://office.microsoft.com/training/training.aspx?AssetID=RC100766511033

  
  <Log Off>