PHS CyberSchool

Computer Studies SG Grade 11 - 2006

Modified 26 August 2006


Term 3 - Software and spreadsheets

Textbook
  • Chapters on the System Software in Computer Studies 2005 Grade 11 Theory by Sandra Jacobs.
  • Glossary of PC Acronymns & Computer terms obtainable from Pam Buttle.
  • The textbook and glossary do not contain all the required information. 
Grade 11 project
  • Database project due 27 July
  • Spreadsheet project due 20 September

All work in BOLD counts for CASS marks

Week year

All work to be completed and handed in by Thursday so it can be marked on Friday

Completed - in Portfolio
17 Jul-21 Jul    
Discussion of Grade 11 database project due 27 July  
  Task - Questions 1-3 on page 33  in textbook  
24 Jul-28 Jul  
Task - Questions 1-11 on page 38-39 in textbook  
31 July-4 Aug  
Task - Questions 1-7 on pages 48-49 in textbook  
7 Aug-11 Aug    
  Database project  
14 Aug-18 Aug    
  Database project due 27 July (came in 17 Aug)  
21 Aug-25 Aug No tasks this week - X-Curricula Week  
     
28 Aug-1 Sep    
Database test
Fixed up CV due in by 4 September
4 Sep-8 Sep  
  Work on Grade 11 spreadsheet project due 20 September  
* Test - Huge test on Software, similar to the one given here - 7 September
  Task - Creation of networking test using the IF function - Excel  
Task - Creation of labels for networking firms - Excel  
11 Sep-15 Sep    
Work on Grade 11 spreadsheet project due 20 September
  Test - Excel similar to Telephone test, Spreadsheet test and marking rubric and solution or an old exam paper  
Task - Mouse Computer School - Excel or Access, and Word  
18 Sep-22 Sep    
Grade 11 spreadsheet project due 20 September
Check electronic and print portfolio  
So behind Test - Excel spreadsheet quiz 1  
  Test - Excel spreadsheet quiz 2  
  Test - Excel spreadsheet quiz (using check boxes and combo boxes)  
  Test - Computer Architecture based on Chapter 1 (Grade 11) and Chapters 1 and 2 (Grade 10) similar to the one given here - 26 July  
Task - Email addresses of all your teachers - Excel  
Task - Stock (Inventory) costs of a computer store - Excel  
Task - Stock (Inventory) counts of a computer store - Excel  
Task - Pinelands High School Tuckshop - Excel  
Task - School Bazaar - Excel  
Task - Salaries of forestry workers - Excel  
  Task - Software quiz 1  
Task - Operating systems and how the operating system is loaded  
  Task - Bond repayments - Excel  
  Task - Buying a second hand car - Excel  
  Task - School marks - Excel  
  Task - School telephone costs - Excel - not done  
  Task - Advertising for a shop  
Task - Shop staff personal details  
Task - Shop staff name details  
  Task - Financial functions, spinners and two-variable data tables - for advanced learners - not done  
  Task - Operating system quiz (Easy)  
Task - Application software quiz (Easy)  
Task - Software test 4 (Revision)  
* Task - Creation of a test on Housekeeping OR Viruses OR Configuring a system - Create rubric in class (Look at rubric making software www.rubricate.co.za) - 31 August
Task - Pivot table of software reported in Word - Excel and Word - not done  
Task - Frequency distribution graph of software - Excel and Word - not done  

Term 3


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