Dawood Public School

Course Outline for 2023-2024

Computer Science
Grade VII

Computing Student Book 7

(Oxford International Lower Secondary)

Month-wise Distribution of Coursework

August Number and data: Business data table

September Digital Literacy: Staying safe online

October Computational thinking: Programming language

November Revision for Mid-Year Examinations

December Mid-Year Examinations

January The nature of technology: Storing digital data

February Programming: It all adds up ( 4.1, 4.2)

March Programming: It all adds up (till 4.3, 4.4, 4.6)

April Revision for Final-Term Examinations

May Final Examination

August 2023
Chapter 6: Number and data: Business data table Pages 146-171

Contents Learning Objectives

Number and data: Business data table Theory Objectives

● Collect Product Data ● List down data types in Excel

⮚ Internet research ● Differentiate between Data and information
⮚ Choose products ● Identify records and fields
⮚ Choose the facts ● Compare data types between python and excel
⮚ Create table
● Records and Fields Practical Objectives
⮚ Data and information
● Create table in Excel
⮚ Data table
● Insert different data types
⮚ Records and fields
● Organize data into record and fields
⮚ Make a spreadsheet table
● Create key field in a row
⮚ Key Fields
● Select number format
● Data Types and Formats
● Format the table
⮚ Number format
● Add and subtract the numbers
⮚ Data types
● Apply Auto sum option
⮚ Format as a table
● Set the validation rules
● Calculations
● Show Bad Data
⮚ Validation
⮚ Validation rules for stock

Keywords
Data type, Validation, Record, Field, Key Field, Data processing, Auto sum,

Types of Questions
⮚ Create data tables
⮚ Rectification of errors in the given data table
⮚ Identification of data validity
⮚ Choose the correct option
⮚ Differentiate between the terms
⮚ Questions & answers

Practice and Project in the Lab

● Make a data table using product data ( Page no. 143 Activity)
● Format the table and apply currency symbols ( Page no. 157 Activity)
● Calculate the stock value and total stock for each product ( Page no. 161 Activity)
● Set Validation rules and fix the mistakes (Page no. 165 Activity)

Practice Questions
● Create a data table using an atomic field.
● Include a formula and a validation check.
● Include an input message for error detection.

I.T Links:
format data tables
How to Enter Data in to a spreadsheet
Number Formats in Excel
September 2023
Chapter 2: Digital Literacy: Staying safe online Pages 32-58

Contents Learning Objectives

Digital Literacy: Staying safe online Theory Objectives

● Collecting Data Online ● State how data is collected online.

⮚ Online registration ● Define the term cookies.
⮚ Online shopping ● Elucidate four types of cookies.
● Cookies ● Describe ways of cybercrime:
● Types of Cookies ⮚ Identity theft
● Danger Online ⮚ Phishing
⮚ Cybercrime methods ⮚ Scamming
⮚ Malware ⮚ Hacking.
● Protect your Computer ● Describe malware and discuss its types:
⮚ Antivirus ⮚ Virus
⮚ Firewall ⮚ Trojan Horse
⮚ Using computer safely ⮚ Spyware
● Cyberbullying ⮚ Adware
⮚ Method cyberbullies use ⮚ Ransomware
⮚ The effect of cyberbullying ● Identify the risks associated with each malware.
● Use content responsibly ● List down methods to protect against malware and hackers:
⮚ Intellectual property ⮚ Antivirus software
⮚ Software privacy ⮚ Firewall
⮚ Avoid downloads
⮚ Update software
⮚ Password safety
● Identify Intellectual property.
● State the importance of intellectual property rights.
Keywords
Cookies, Cyberbullying, Patent, Copyright, Cybercrime, Phishing, Hacking, Identity theft, Scamming, Malware, Firewall,
Harassment, Exclusion, Dissing, Intellectual Property, Citation, Plagiarism.

Types of Questions
⮚ Research work.
⮚ Identification of online risks.
⮚ Present the ways to protect from malware and hackers.
⮚ Create an information sheet (on how to survive cyberbullying).
⮚ Multiple Choice questions.
⮚ Match the following.
⮚ Question Answer.

Practice and Project in the Class:

● Find out good and bad uses of cookies using the internet. (Page no. 37 Activity)
● Create a poster that warns about the dangers of cybercrime. ( Page no. 39 Activity)
● Search the internet to find out a major malware attack that has taken place. (Page no. 41 Activity)
● Prepare a presentation for a guide to work safely online and avoid the risk of malware.(Page no. 45 Activity)
● Search for an image of the tiger using common creative sites. Insert the credit provided by the website below
the image. ( Page no 53)
● Search the internet to find out what the legal penalties are for software piracy in any 5 countries including your
own country. (Page no.53 Extra Challenge)

Practice Questions
 ● Why is it important to update the software on your computer regularly?
● Explain why you need to be careful when you open a file attached to an email?
● State how cookies can make websites easier to use.

I.T Links:
What Are Cookies? And How They Work
Different Types of Malware and anti malware
What Is the Difference between Firewall and Antivirus Software?
Intellectual Property

October 2023
Chapter 3: Computational thinking: Programming language Pages 60-86

Contents Learning Objectives

Computational thinking: Programming language Theory Objectives

● Make a simple calculator. ● Compare between Scratch and Python.

● Input and output in Python. ● Describe row and column.
● Make a python program. ● State full form of IDE.
● Add two numbers. ● Describe IDLE.
● Choose a language. ● Differentiate between Machine code and source code.
● Source code and machine code. ● Identify the features of Compiler and interpreter.

Practical objectives

● Enter the values.

● Display result.
● Identify colors of the python syntax.
● Identify errors in a program.
● Change the date type.
● Save commands as a program file.
● Create programs using python shell.
● Run a program.

Keywords
Machine code, Source code, Compiler, Executable file, IDE, Python Shell, Interpreter

Types of Questions
⮚ Identification of functions.
⮚ Code creation in python.
⮚ Error identification and rectification.
⮚ Recognition of components od IDE or IDLE.
⮚ Similarities and differences.
⮚ Questions answers.

Practice and Project in the Lab:

● Make a program to do an addition of two user inputs (Page no. 65 Activity).
● Use the python shell to enter all the commands shown in the lesson. (Page no. 69 Activity).
● Make a python program. Save and run the program. Correct any errors. (Page no. 73 Activity).
● Make a python program to input two integers, add them together and output the total. Check the errors and
fix them. Save the work. (Page no. 77 Activity).

Practice Questions
● Write a python program to draw a line of 35 dashes across the screen.
 ● Explain why programmers do not write programs using machine code?
● Make a python program to calculate area of rectangle and circle.

I.T Links:
Python Program Practice
Syntax, Runtime and Logical Errors in Python
COMPILER| INTERPRETER |Difference between Interpreter and Compiler
What is Source Code and What Does it Do?

November 2023:

Revision for Mid Term Examination

December 2023:

Mid Term Examination

January 2024
Chapter 1: The nature of technology: Storing Digital Data Pages 4-30

Content Learning Objectives

The nature of technology: Storing digital data Theory Objectives

● Digital data ● Describe digital data.

● Reading binary number ● State how digital data is used to store text,
● Addition in binary images and instructions.
● Decimal to binary conversion ● Differentiate between bits and bytes.
● Digital Text and number ● Convert binary into decimal.
● Sound and Vision ● Perform addition of binary numbers.
● Convert decimal to binary.
● State how text and number is stored as digital
data.
● Elucidate how images, sound and videos are
converted into digital data.

Keywords
Digital Device, Bit, Bytes, Pixels, Sampling, Binary, Decimal

Types of Questions
● Identification of number systems.
● Conversion of given numbers from one system to another.
● Differences and similarities.
● Writing binary code of students’ names.
● Addition of binary numbers.
● Research about ASCII codes.
● Question Answer.

Practice and Project in the class:

● Use the rules of binary addition and find the sum. (Page no. 17 Activity)
● Add the binary values and show the overflow error. (Page no. 21 Activity)
● Search the ASCII table using the internet. Write your first name and age using decimal values.(Page no. 23
Activity)
● Write a short message in ASCII code of 10 characters and give it to the partner to decode. (Page no. 25
Activity
● Decode the binary into decimal numbers. ( Page no. 13 Activity)
 ● Overflow error concepts. ( Page no. 20)
● Write a short message in ASCII and decode it. Work in pairs. ( Page no. 25 Activity)

Practice Questions
● Why is ASCII code limited to 256 characters?
● What is the advantage of using Unicode instead of ASCII code?
● Explain what digital data is?

I.T Links:
Binary Numbers and Base Systems
How do computers store numbers?
Binary to Decimal Conversion

February 2024
Chapter 4: Programming: It All Adds Up Pages 88-101

Contents Learning Objectives

Programming: It All Adds Up Theory Objectives

● Logical tests and choices ● State the Conditional Structure.

⮚ Conditional Structure ● Define Relational Operators.
⮚ Logical test ● Differentiate between Counter Loop and Conditional
⮚ Relational operators Loop.
⮚ Comparing values ● Compare programs using python and Scratch interface.
⮚ If and Else in Python
● Add up a total Practical objectives
⮚ Loops
⮚ Python program with counter loop ● Identify Relational Operators.
⮚ Increase the value of a variable ● Create a program using IF Condition.
⮚ Increase the variable in Python ● Create a program using IF and Else Condition.
● Create the programs using counter and conditional
Loop.
● Save commands as program files.
● Display Output.
● Run a program.
Keywords
Loop, Conditional Structure, Counter Loop, Conditional Loop, Relational Operators

Types of Questions
⮚ Block identification.
⮚ Choose the correct script.
⮚ Logical test solutions.
⮚ Scratch code creation.
⮚ Comparison of two languages.
⮚ Differentiate between the terms
⮚ Questions answers

Practice in the Lab:

● Check the logical test. (Page no. 91 Activity)
● Make a python program that uses if–else. (Page no. 93 Activity)
● Make a python program using a counter loop. (Page no. 95 Activity)
● Make a python program to add 10 numbers to make a total. (Page no. 97 Activity)
● Print a series of even numbers.
● Print a series of values in descending order.

Practice Questions
● A Python Program includes a variable called points. Write the command to increase points by 10.
● Write the first line of a Python Loop that repeats 100 times.

I.T Links:
Python Conditional Statements
Python Conditions and If statements
Python if...else Statement
Python if else

March 2024
Chapter 4: Programming: It all adds up Pages 102-115

Contents Learning Objectives

Programming: It all adds up Theory Objectives

● Conditional Loop ● State the Conditional Loop.

⮚ Adding up a conditional loop ● Define the logical test.
⮚ When to use Conditional loop ● Deduce the syntax error.
⮚ What is a logical test? ● State the purpose of the indent in Python
● A Class Project Programming.
⮚ Counting up ● Infer the importance of adding comments in the
⮚ Program problem Python Programs.
⮚ Syntax error
⮚ Not Using Indent Practical Objectives
● Readable and User Friendly
⮚ Make a user friendly program ● Identify Logical Operators.
⮚ The interface of your program ● Create a program using Condition Loop.
⮚ Make a program readable ● Identify the Syntax and Indent error.
⮚ Comments ● Debug the error in the program.
● Add comments in the program.
● Save commands as program files.
● Display Output.
● Run a program.
Keywords
Conditional loop, Translating , Running, Syntax, Syntax error, Interface

Types of Questions
⮚ Identification of loops
⮚ Selection of appropriate block
⮚ Errors rectification
⮚ Program creation (python)
⮚ Choose the correct option
⮚ Differentiate between the terms
⮚ Question & answers

Practice and Project in the Lab:

● Make a Python Program that adds each number that the user enters to the total until the user enters a value
smaller than 0. (Page no. 99 Activity)
● Create a poster that displays text colors in the python. ( Page no. 105 Activity)
● Make a python program that sets variables total to ‘100’, subtracts numbers until the user enters a value
greater than 99. (Page no. 101 Activity)
● Print a series of odd numbers.
● Calculate the average. ( Page no. 113 Activity)
● Identify the Error and rewrite the given program. ( Page no. 114 Activity)

Practice questions
● Explain when to use conditional loops in your program.
● Explain how Text color can help you find errors in your programs.

I.T Links:
Python While Loops
Python while Loop Statements
Python While Loop/iteration

April 2024:

Revision for Final Term Examination

May 2024:

Final Term Examination