Xpert Access

Grade 7 Scheme of Work

Grade 7 Scheme of Work
SY: 2018 - 2019

 

Week  Subject / Unit Name Unit Learning Objectives 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  
8/20/2018 The Internet link1
What is the Internet link1
Why we use it  
URLs link1
DNS link1
HTTP link1
quiz1 
Week 3 Unit 1.  Computer Network Fundamentals and the Internet 1.2. Computer Network Types Computer Network  Types  
 What is a Computer Network?  
Why do we use a Network?  
8/27/2018 Internet  
LAN  
WAN  
MAN  
Week 4 Unit 1.  Computer Network Fundamentals and the Internet 1.3. Computer Network Configuration Network Configurations  
9/3/2018 Star Network  
Ring  
Bus  
Token-Ring  
Week 5 Unit 1.  Computer Network Fundamentals and the Internet 1.4. Computer Network Hardware Network Hardware  
9/10/2018 Hubs and Switches  
Routers and Cables  
Hosts, Clients and Servers  
 
 
Week 6 Unit 2 : Spreadsheet Modelling in MS Excel 2.1. Creating Spreadsheet Models ** Note : Unit 1 Theory Assessment should be given at any 45-minute class this week  
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)  
 
Week 7 Unit 2 : Spreadsheet Modelling in MS Excel 2.2 . Using Basic functions Using Basic Functions  
9/24/2018 SUM, MIN, MAX  
AVERAGE, COUNT, IF  
VLOOK UP  
 
 
Week 8 Unit 2 : Spreadsheet Modelling in MS Excel 2.3. Creating Common and Uncommon Charts Creating the following Charts  
10/1/2018 Column Chart  
Pie Chart  
Line Chart  
 
Doughnut Chart  
Bar Chart  
Combo Chart  
Week 9 Unit 2 : Spreadsheet Modelling in MS Excel 2.4. Modifying Charts and Chart Labelling/Elements  
10/8/2018 Changing the Chart Type  
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 HTML  
10/15/2018 Review about Internet and Webpage (Web)  
What is HTML? (Hyper Text Markup Languange)  
 
 
Basic Tags:  
3.2 HTML Basic Tags <html>, <head>, <title>, <body>, <p>  
 
Week 11 Unit 3 - Introduction to Web Development 3.2 HTML Basic Tags  
10/22/2018 Basic Tags:  
Heading Tags : <h1>, <h2>, <h3>, <h4>, <h5>, <h6>  
Text Formatting Tags: <b>, <i>, <u>, <sub>, <sup>  
Moving Text Tags: <marquee>  
Background Color   
 
 
 
Week 12 Unit 3 - Introduction to Web Development 3.3 HTML Image and Hyperlink Insertions



3.4 Website Creation using MS Expressions 4
 
10/29/2018 Image Insertion  
Video Insertion (using Youtube videos)  
Hyperlink (other webpage)  
 
 
Introduction to MS Expression 4  
Navigating within the software  
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  
Inserting Hyperlinks, Videos and Images using MS Expressions 4  
 
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  
11/12/2018  
** Note : Unit 3  Assessment should be given at  the last 45-minute class of  this week  
Week 15 REVISION WEEK
11/19/2018
Week 16 END OF SEMESTER 1 EXAMS
11/26/2018
Unit 4 - Database Development 4.1. Introduction to Database, Database Management  and Development  
Week 17 Introduction to Database  
12/3/2018 Definition  
Field and Record  
Why do we use them  
Real Life Application of Database  
 
Week 18 Unit 4 - Database Development 4.2 MS Access - Table Creation and Validation Rules Table Creation  
12/10/2018 Using Data Types in creating a Table  
Table Validation Rule  
Common Rules, Operators (Logic and Mathematic)  
<, <=, >, =>  
Between, And, Or  
Like, Not  
Week 19 Unit 4 - Database Development 4.3. MS Access - Creating and Modifying Forms What is a Form?  
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 )  
 
Week 20 CHRISTMAS HOLIDAY
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  
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?  
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  
 
Week 24 Unit 4 - Database Development 4.6. MS Access- Practical Applications  
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  
2/11/2019 Understanding Block Scripts  
Moving a Sprite around the stage  
 
Week 28 Unit 5 - Creating Games using Scratch 5.2. Automation and Animation Moving the Sprites around the stage automatically  
2/18/2019 Animate a Sprite  
 
 
 
Week 29 Unit 5 - Creating Games using Scratch 5.3. Understanding Pen Drawing


5.4. Game Creation Project
Understanding Pen Drawing  
2/25/2019  
 
 
Students  will create their own games using parameters (Simple Games : Pong, Pacman, Chase...)  
 
Week 30 Unit 5 - Creating Games using Scratch 5.4 Game Creation Project  
3/4/2019 Students  will create their own games using parameters (Simple Games : Pong, Pacman, Chase...)  
 
Week 31 Unit 5 - Creating Games using Scratch 5.4 Game Creation Project  
3/11/2019 Students  will create their own games using parameters (Simple Games : Pong, Pacman, Chase...)  
** 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 Introduction to the Software (Turtle, Working Area)  
3/18/2019 Basic Commands (Forward, Back, Right, Left, Home, Clearscreen,Clean, Clear Text)  
Advance Commands (Pen Up/Pen Down, Show, Hide)  
 
Week 33 Unit 6 - Programming in MSW Logo 6.2. Creating Basic Shapes, Advance Shapes Creating Circles, Squares, Polygons (5 sides or more)  
3/25/2019 Understanding the Maths involved (degrees, angle)  
Advanced Shapes (Pallelograms, Hearts, Stars)  
 
Week 34 Unit 6 - Programming in MSW Logo 6.3 Combining Shapes and using REPCOUNT Combining Shapes to make drawings  
4/1/2019 Designing Patterms using REPCOUNT  
 
** Note : Unit 6  Assessment should be given at  the last 45-minute class of  this week  
Week 35 REVISION WEEK
4/8/2019
Week 36 END OF SEMESTER 1 EXAMS
4/15/2019

Access