Smarter than a 7th Grader?
The Minimum Computer Literacy Expectations for a 7th Grader - February 4th, 2008

       
Home Page

1.0  Microsoft Word
   1.1 Word Processing
   1.2 Simple Web Pages
   1.3 Drawing Tools
   1.4 Word Activity

2.0  Microsoft PowerPoint
   2.1 Day at School Show
   2.2 Peer Evaluations
   2.3 PowerPoint Activity

3.0  Microsoft Excel
   3.1 Formulas and Formats
   3.2 Graphing
   3.3 Excel Activity

4.0 Internet
   4.1 Internet Moments
   4.2 Research

5.0 Computer Skills Inventory

6.0 Works Cited

    3.1 Excel - Formulas and Formats
Formatting text and cells in Excel is very similar to formatting in any other Microsoft program.  To format text or a cell right click on it and select "Format Cells" from the menu that appears.  Then move through the tabs to make the change you desire.  Try this practice activity.  Make your look like mine.

Being able to do formulas dynamically in Excel is definitely it's most powerful feature.  Instead of constantly re-calculating sums after every change formulas in Excel update themselves automatically whenever there is a change.  Learning how to write simple formulas is therefore essential.

Mathematical Symbols:  Multiplication (*), Division (/), Addition (+), Subtraction (-)

Cell Addresses:  Anyone who has played Battleship before (or is familiar the idea of a Cartesian Plane) should be able to understand that every cell in an Excel worksheet has an address that corresponds to the column and row it is in.  For example the cell in the upper left hand corner of the sheet has the address of A1 (column A, Row 1). 

Writing a Formula:  In the example to the left you can see a simple formula in cell A$ that adds whatever is in cell A2 to whatever is in cell A3.  A more complex formula might start with "=sum"

Excel Formula Tutorial:    http://spreadsheets.about.com/od/excelformulas/ss/formula_begin.htm

     

Next:  3.2 Excel - Graphing

 

© 2008 - 180techtips.com