Wednesday, June 19, 2019

Trusted Site

Country Switcher

A- A A+

Grade 7 Scheme of Work

Grade 7 Scheme of Work
SY: 2018 - 2019

 

 ​

Week  Subject / Unit Name Unit Learning Objectives Enrichment
Resources
Week 1  Introduction + Baseline Assessment
8/13/2018
Week 2 Unit 1.  Computer Network Fundamentals and the Internet

1.1  The Internet, Uses and History

presentation

 
8/20/2018 The Internet link1
What is the Internet link1
Why we use it  
URLs link1
DNS link1
HTTP link1
Review 1 | Review 2 
LABACTIVITY
 
Week 3 Unit 1.  Computer Network Fundamentals and the Internet

1.2. Computer Network Types

presentation

Computer Network  Types    link1 
 What is a Computer Network?
Why do we use a Network?
8/27/2018 Internet
LAN   link1 
WAN
MAN
  Review 1 | Review 2 
LABACTIVITY
 
Week 4 Unit 1.  Computer Network Fundamentals and the Internet

1.3. Computer Network Configuration

presentation

Network Configurations link1 
9/3/2018 Star Network     linkbutton2
Ring
Bus
Token-Ring
   LABACTIVITY  
Week 5 Unit 1.  Computer Network Fundamentals and the Internet

1.4. Computer Network Hardware

presentation

Network Hardware  link1
9/10/2018 Hubs and Switches  
Routers and Cables  
Hosts, Clients and Servers  
 LABACTIVITY  
Week 6 Unit 2 : Spreadsheet Modelling in MS Excel

2.1. Creating Spreadsheet Models

presentation

** Note : Unit 1 Theory Assessment should be given at any 45-minute class this week link1 
 9/17/2018 MS Excel Enviroment review   
Different Data Types  ( Whole Numbers, Decimals, Text, Date/Time, Currency, BLANK)  
Cell Formatting (Fill, Font Styles, Borders, Widths, Heights)  
 LABACTIVITY  
Week 7 Unit 2 : Spreadsheet Modelling in MS Excel

2.2 . Using Basic functions

presentation

Using Basic Functions link1 
9/24/2018 SUM, MIN, MAX  
AVERAGE, COUNT, IF  
VLOOK UP  
 LABACTIVITY  
Week 8 Unit 2 : Spreadsheet Modelling in MS Excel

2.3. Creating Common and Uncommon Charts

presentation

Creating the following Charts link1 
10/1/2018 Column Chart  
Pie Chart  
Line Chart  
Doughnut Chart  
Bar Chart  
Combo Chart  
   LABACTIVITY  
  Unit 2 : Spreadsheet Modelling in MS Excel

2.4. Modifying Charts and Chart Labelling/Elements

presentation

 
Week 9 Changing the Chart Type link1 
10/8/2018  Using the Chart Elements (for Labelling)  
Chart Title  
Axes/Axes Titles  
** Note : Unit 2  Assessment should be given at  the last  45-minute class of  this week  
Week 10 Unit 3 - Introduction to Web Development 3.1 Introduction to Web Developement and HTMLpresentation Review about Internet and Webpage (Web)  link1 
10/15/2018 What is HTML? (Hyper Text Markup Languange)  
Basic Tags:  
 <html>, <head>, <title>, <body>, <p>  
 LABACTIVITY  
3.2 HTML Basic Tags    
 
Week 11 Unit 3 - Introduction to Web Development 3.2 HTML Basic Tagspresentation Basic Tags:  link1 
10/22/2018 Heading Tags : <h1>, <h2>, <h3>, <h4>, <h5>, <h6>  
Text Formatting Tags: <b>, <i>, <u>, <sub>, <sup>  
Moving Text Tags: <marquee>  
Background Color   
 LABACTIVITY  
Week 12 Unit 3 - Introduction to Web Development 3.3 HTML Image and Hyperlink Insertions

presentation

3.4 Website Creation using MS Expressions 4
link1 
10/29/2018 Image Insertion  
Video Insertion (using Youtube videos)  
Hyperlink (other webpage)  
Introduction to MS Expression 4  

Navigating within the software
LABACTIVITY

 
Week 13 Unit 3 - Introduction to Web Development 3.4 Website Creation using MS Expressions 4  
11/5/2018 Creating aa basic Webpage using the software link1 
Inserting Hyperlinks, Videos and Images using MS Expressions 4  
LABACTIVITY  
Week 14 Unit 3 - Introduction to Web Development 3.5 Website Creation Project using MS Expressions 4 Students will create their own website based on a rubric that will be handed out by the teacher link1 
11/12/2018 LABACTIVITY  
** Note : Unit 3  Assessment should be given at  the last 45-minute class of  this week  
Week 15 END OF 1ST  SEMESTER EXAMINATION
Revision Notes  linkbutton2    & Practice Test Code : 222532  linkbutton2 Quizlet Revision Notes  linkbutton2
Cambridge End of Semester 1 EXAMS (Please note of the actual exam dates)
11/19/2018
Week 16 SEMESTER 1 EXAMS (Please note of the actual exam dates)
To update/synchronize IT Department Calendar  with GH Calendar
11/26/2018
Unit 4 - Database Development 4.1. Introduction to Database, Database Management  and Development

presentation
 Learning Objectives Enrichmen Resources
Week 17 Introduction to Database link1 
12/3/2018 Definition  
Field and Record  
Why do we use them  
Real Life Application of Database  
LABACTIVITY  
Week 18 Unit 4 - Database Development 4.2 MS Access - Table Creation and Validation Rules Table Creation link1 
12/10/2018 Using Data Types in creating a Table link1 
Table Validation Rule  
Common Rules, Operators (Logic and Mathematic)  
<, <=, >, => link1 
Between, And, Or  
Like, Not  
Week 19 Unit 4 - Database Development 4.3. MS Access - Creating and Modifying Forms What is a Form? link1 
12/17/2018 Creating a Form Using Form Wizard  
Modifying a Form  
Changing Layouts, Colours and Font  
Inserting Command Buttons (Previous Record, Next Record, Add Record, Delete )  
LABACTIVITY  
Week 20 CHRISTMAS HOLIDAY
Please have some time to review about MS Access terms and functionalities
   Click the Quiz button on the right side and enter the CODE: 841403 (Expires on: 1/1/2019)
12/24/2018
Week 21 CHRISTMAS HOLIDAY
12/31/2018
Week 22 Unit 4 - Database Development 4.4. MS Access - Creating Query  What is a Query link1 
1/7/2019 Creating a Query  
Simple  
Complex   
Query Operators  
 
Week 23 Unit 4 - Database Development 4.5. MS Access - Creating Reports


4.6. MS Access - Practical Applications
What is a Report? link1 
1/14/2019 Creating a Report using Report Wizard  
Students will create their own database following data provided in a survey form and wil follow on creating, Tables, Forms, Query and  Report  Practice Quizziz Code: 
806036
Expires on:
January 20, 2019
LABACTIVITY  
Week 24 Unit 4 - Database Development 4.6. MS Access- Practical Applications link1 
1/21/2019 Students will create their own database following data provided in a survey form and wil follow on creating, Tables, Forms, Query and  Report  
 
 
** Note : Unit 4  Assessment should be given at  the last 45-minute class of  this week  
Week 25 TET HOLIDAY
1/28/2019
Week 26 TET HOLIDAY
2/4/2019
Week 27 Unit 5 - Creating Games using Scratch 5.1. Introduction to Scratch Previewing the Interface Scratch CODING Cards
Entire Collectionlink1   
2/11/2019 Understanding Block Scripts
Moving a Sprite around the stage
LABACTIVITY  
Week 28 Unit 5 - Creating Games using Scratch 5.2. Automation and Animation Moving the Sprites around the stage automatically  Scratch CODING Cards
Entire Collectionlink1     
2/18/2019 Animate a Sprite
LABACTIVITY
 
 
Week 29 Unit 5 - Creating Games using Scratch 5.3. Understanding Pen Drawing


5.4. Game Creation Project
Understanding Pen Drawing Scratch CODING Cards
Entire Collectionlink1      
3/11/2019 LABACTIVITY
Students  will create their own games using parameters (Simple Games : Pong, Pacman, Chase...)

FallingSprite Objects Example link1

 
Week 30 Unit 5 - Creating Games using Scratch 5.4 Game Creation Project  
3/18/2019 Students  will create their own games using parameters (Simple Games : Pong, Pacman, Chase...) Jumping Cat Sprite Examplelink1 
Scratch CODING Cards
Entire Collectionlink1

LABACTIVITY  
Week 31 Unit 5 - Creating Games using Scratch 5.4 Game Creation Project  
3/25/2019 Students  will create their own games using parameters (Simple Games : Pong, Pacman, Chase...) Scratch CODING Cards
Entire Collectionlink1    
** Note : Unit 5  Assessment should be given at  the last 45-minute class of  this week  
Week 32 Unit 6 - Programming in MSW Logo 6.1 Introduction to Software, Basic and Advance Commands
presentation

Introduction to the Software (Turtle, Working Area)

 
Basic Commands (Forward, Back, Right, Left, Home, Clearscreen,Clean, Clear Text)  
Advance Commands (Pen Up/Pen Down, Show, Hide)  
LABACTIVITY  
  Unit 6 - Programming in MSW Logo 6.2. Creating Basic Shapes, Advance Shapes
presentation
Creating Circles, Squares, Polygons (5 sides or more)  
Understanding the Maths involved (degrees, angle)  
Advanced Shapes (Pallelograms, Hearts, Stars)  
LABACTIVITY  
Week 33     ** Note : Unit 6  Assessment should be given at  the last 45-minute class of  this week  EOY 2nd 
Semester Assessment / Review
Practice Code:   058006
Expires on: 4/14/2019
11:00 PM
 
 
Think of answers on the review questions below:
  • What is the standard HTML webpage format?
  • What are databases and where can I use it?
  • What are the different types of computer network topologies, how do they work and their advantages or disadvantages.
  • What are the different parts of MS EXCEL and how can I identify spreadsheet information.
EOY 2nd 
Semester Assessment / Review
Practice Code:   323598
Expires on: 4/17/2019
5:00 AM
 
 

Week 34 Cambridge End of Semester Examination

Access

Quiz Assessment