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.3 Excel Activity
Try this:  Copy and paste the data below into a blank Excel worksheet. 
Student Activity 1 (20) Quiz 1 (10) Activity 2 (20) Quiz 2 (10) Total Points Average
Mike Douglas 5 6 18 2    
Maureen Welch 19 8 15 8    
Sally Struthers 18 10 15 7    
Adrian Monk 20 10 20 10    

Try formatting the text and writing a formula to calculate the total points and the averages.  Then format the text and adjust the columns and rows so it looks like this:

Using the data create a chart that looks like this one:

     

Next:  4.0 Internet

 

© 2008 - 180techtips.com