PHS badge

PHS CyberSchool

Computer Studies SG Grade

Modified  20 October 2005

Grade 11 Project - Excel features

  1. Create a spreadsheet workbook which will be useful to a teacher.
  2. Include functions and formulas and features to enhance the usefulness of the workbook.
  3. Use a command centre as a guide to enter the information source.
  4. In File / Properties add your name as the author.
  Feature Sheet where feature found How/why feature is used
Input data correctly Format cells   currency
Validation    
Import / Get external data    
Name cells/ range    
Custom lists    
Track changes    
Text to columns    
Analysing + processing data Functions / formulas

concatenate, countif, sumif, sum, left, right, upper, lower, vlookup, hlookup
Mathematical - abs, int, ceiling, mod, sum
Statistical - average, count, frequency, max, min, mode
Logical - and, or, not, true, false

    
What if    
Pivot table    
Formatting data meaningfully Fill    
Borders    
Merge cells    
Orientation    
Displaying data Conditional formatting    
Graphs    
Sort    
Copy / Paste    
Properties    
Page setup    
Save as    
Comments    
Background    
Group and outline    
Accessing data Tabs    
Hyperlinks    
Freeze panes    
Protecting data Protect objects    
Protect sheet    
Protect workbook    

 

Return to Computer Studies lesson plan index. This work may be freely copied for non-commercial use only. Copyright © Pam Miller.