MET 107

Schedule for August & September 2008

Week of

Monday

Wednesday

8/25

 Course Introduction
 MS Word - Basics
     Cut, Paste, Copy Text
     Format Documents
        -Text, Page & Using Styles
        -Tabs
        - Section Breaks
        - Headers & Footers
      Footnotes

 Reading:
      
Word Notes
      
 Homework:
       Homework 1a: 
Formatting

       Homework 1b:  Memo
      
Start Document
      
Truss Figure Document

 MS Word - Inserting
     Inserting and Formatting Tables
     Bulleted and Numbered Lists
     Create and Edit Equations
     Inserting Symbols and Other Objects


In Class Activity (drop box to V:\MET_107\DP_Section_N):  Drop Box Activity



 Reading:
    
Word Notes
    


 Homework:
      Homework 2: 
Tables, Equations and Lists
      File for Insertion: 
Member Force Chart

9/1

    


 No Class; Labor Day
    

    

 



    

 MS Word - Drawing
     Showing Drawing Toolbar
     Create and Format Drawing Objects
     Grid and Snap
     Flip, Rotate and Align Objects
     Group, Order and Wrap Text

PowerPoint
           Overview
           Generating Slides
           Inserting Objects
           Drawing
           Custom Animation

 Reading:    
Drawing Tools
                   
Text Wrapping

                    PowerPoint Hints/Suggestions

    Homework 3:  MS Word Drawing


   Homework 4: 
Slide Show
                     
Boat Figure

9/8

      Problem Solving
     Basics of problem solving
     Algorithms
     Five things a computer can do
     Flowcharts
             

  Reading:  
    
History of Spreadsheets 
    
Spreadsheet Humor 
    
Flowcharts
    
Problem Solving with a Computer
    
 In-Class:
    
Problem Solving Slides
    
General Problem Solving Examples


 Homework:
       Homework 5: 
Algorithm Development

Problem Solving Continued

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Homework 5 continued

 

9/15

Problem Solving continued

 

 

 

 

In-Class:

Problem Solving Slides

 

 

 

 

 

 

Homework:          

               Homework 5a:  Algorithm Development cont.

MS Excel

      Introduction
     Cell Formulas

Reading:

     Cell Formulas 
    
Cell Formula Examples

  

     IMPORTANT:
    
Special Function Instructions
    
Special Function Spreadsheet

     Security Settings in Excel
    
Worksheet Layout Requirements
    

 Homework:
       Homework 6: 
Simple Spreadsheet

9/22

 MS Excel
         Labels, Numbers & Formulas
     Copying and Pasting Cell Formulas
       

      


  Reading:  
        
Distance Formula
    
Creating Text Strings in Excel
    
Logic Functions

 

 

Homework:
       Homework 7: 
Cell Formulas

             

      

Mathcad Introduction

 

 

 

 Reading:

    Concerning doing Engineering Calculations

    Mathcad Document Set 1

    Mathcad Document Set 2

    Mathcad Document Set 3

   

 

 

 

 

 

Homework:

    Homework 8: Drop Box of Current Grades

                          Intro, Check of HW #7

                           Summary Sheet (Word)

 

9/29

MS Excel - Problem Solving with Excel
     Cell Formulas
         Copying and Pasting Cell Formulas 
     Relative, Absolute and Mixed Cell 
            References 
 

  Reading:  
       
Cell References 
      
Cell Formulas 

       Cell Formulas Examples

 
   
  
       
    
 Homework:
 Homework 9: 
Relative, Absolute and
           Mixed Cell References