Page 1 - Computers and Technology for Science
P. 1

03-SC-Spreadsheet  5/30/07  3:32 PM  Page 87




                                                                                                           |
                                                              Lesson  3


















                   Spreadsheets













                   Activity 1: Caffeine                                Activity 8: Properties of Elements
                         ! Select Cells                                      ! Insert, Delete, Copy, Move, and Rename
                         ! Change Font Formatting                               Worksheets
                                                                             ! Selecting Worksheets
                   Activity 2: Water Usage                                   ! Change the Active Worksheet
                   Activity 3: Energy Efficiency                       Activity 9: Climate Zones
                         ! Enter a Formula                                   ! Fill a Series
                         ! Copy a Formula                                    ! Add Slides to a Presentation
                         ! Apply Number Formats                              ! Work with Placeholders
                         ! Insert a Chart                                    ! Copy an Object from an Excel Workbook to a
                   Activity 4: Blood Circulation                                PowerPoint Slide
                         ! Select a Row or Column                            ! Resize or Position Slide Content
                         ! Insert and Delete Columns and Rows          Activity 10: Electromagnetic Waves
                         ! Merge & Center                                    ! Change Font Formatting to Superscript
                   Activity 5: Disease Statistics                            ! Place a Chart on Its Own Sheet
                         ! Align Data Horizontally                           ! Format a Chart Data Point
                         ! Wrap Text                                         ! Copy and Paste Special
                         ! Change Column Width                               ! Transpose Data
                                                                             ! Delete (Clear) Cell Contents
                   Activity 6: Force and Motion                        Activity 11: The Cell Cycle
                         ! Enter a Formula with a Function
                         ! Insert a Line Chart                               ! Use AutoSum
                         ! Copy Data or an Object                      Activity 12: Tracking Cancer Rates
                         ! Copy a Formula
                   Activity 7: Determining Fossil Age                  Activity 13: Photosynthesis
                         ! Sort Data                                   Activity 14: Force and Acceleration
                         ! Apply Borders to a Word Table               Activity 15: Radioisotope Dating
                         ! Insert Page Breaks in Word
                                                                             ! Download Files
                                                                             ! Recording Source Information
                                                                       Activity 16: Colors of Light




                                                                                                                    87
   1   2   3   4