The City School

University Road Campus

ICT - Consolidated
Preparatory Worksheet

Prepared by:

Ms. Rafia Farooq

The City School / Computing / Class 8 Page 1 of 21

 Objective Type
Multiple Choice Questions (MCQs)
1. Why do search engines exist?
a) To gather data
b) To create reports
c) To protect personal information
d) To identify error
2. Why is it important to use keywords when searching on the internet?
a) To confuse search engines
b) To make your search results more colorful
c) To narrow down and specify your search
d) To increase your internet speed
3. Why would you use Boolean operators when conducting an online search?
a) To enhance security
b) To identify fake news
c) To specify your search criteria
d) To protect personal information
4. Why is citing sources ethically important when using information from the internet?
a) To secure search
b) To avoid cyberbullying
c) To understand digital resilience
d) To give credit to the original creators
5. Why should you be cautious about sharing personal information on the internet?
a) To collect data
b) To understand digital resilience
c) To safeguard private data
d) To discern false information.
6.Boolean _________ tells the search engine to retrieve web pages containing all the keywords.
a) NOT
b) AND NOT
c) AND
d) OR

The City School / Computing / Class 8 Page 2 of 21

7. Cyber bullying is bullying that occurs __________________.
a) Digital
b) Facebook
c) Online
d) WhatsApp
8.Clicking on a popup is also called __________________.
a) Phishing
b) Click-Bait
c) Hacking
d) Fake News
9. Live Streaming is the broadcasting of __________________.
a) real-time
b) cricket
c) Instagram Live
d) Internet
10.Posting embarrassing videos and photos is an example of __________________.
a) Hacking
b) Fake News
c) Digital Resilience
d) Cyber Bullying

11.Which of the following is incorrect about a digitally resilient person?

a) Learn from experience
b) Lay low when danger strikes
c)Understand when they are at risk
d)Bounce back when things go wrong
12.You need information on football centrifugal force but don’t want results on centripetal force. What
type of internet search strategy will you apply here?
a) Use specific keywords
b) Use Boolean AND
c) use Boolean AND NOT
The City School / Computing / Class 8 Page 3 of 21
d) simply type centrifugal in the search engine
13.Quoting words and ideas of other authors as your own is termed as ________________.
a) Ethical citation
b) Digital citizenship
c)Plagiarism
d)Privacy
Fill in the Blank: [5]
1. To ___________________information from different websites, you need to search effectively using
keywords.
2. Using _______________and arithmetic operators can help you refine your online searches.
3. It's essential to _______________personal information and maintain privacy when browsing the
internet.
4. Understanding digital _______________involves being aware of online risks and taking precautions.
5. One way to combat cyberbullying is to learn how to _______________it and prevent harm to
yourself and others.
6. _______________try to steal your personal information.
7. The plus sign (+) is the equivalent of _______________
8. _______________is not quoting words and ideas of other authors.
9. The person who communicates through technology is a _______________
10. A password is a secret _______________
11. The broadcasting of real-time, live, video to an audience over the internet is termed as
_______________
12. It occurs online, often through instant messaging, text messages, emails and social network. It is
hurtful and unkind; it’s called ____________________.
13. The purpose of __________________ is to search for information on the World Wide Web by using
specified keywords.

ADVANCE IMAGING – PHOTOSHOP

Q1: John and Wills are working on a graphic design project for a school event poster. They would
use Select and cut out an image of a mascot from its background. Afterward, they blend it to make
the mascot seamlessly with the poster's background.

Part a: How does the use of the "Magic Wand" for selecting objects in graphic design relate to the
concept of image masking?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

The City School / Computing / Class 8 Page 4 of 21

Part b: When utilizing "Layer Blending Methods" in graphic design, how does the selection of blending
mode influence the interaction between various layers?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

Q2: Ahmad has a photo that needs some enhancements for a photography class project. He wants
to adjust the colors to change the photo's color tones. Additionally, he also needs to remove
blemishes and imperfections from the subject's face.

Part a: How does the "Hue and Saturation" adjustment affect the colors in a digital image?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

Part b: When using "Retouch Tools" in photo editing, what ethical considerations should a photographer
or designer keep in mind?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________
Part c: Explain the importance of understanding color theory and color psychology when making
adjustments with the "Hue and Saturation" tool. ?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________
The City School / Computing / Class 8 Page 5 of 21
Part d: In the context of photo enhancement, Discuss the balance between preserving the authenticity of a
photograph and making necessary retouches. ?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

Q3. Jonathan is designing a digital banner for a club event. Explain how he would create and format
text and to add a drop shadow and bevel & emboss effect to make the text pop. He also wants to
create a colorful background, and apply a border around important elements.

Part a: How does the use of layer styles, such as drop shadow and bevel enhance the visual appeal of text
________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________
Part b: How can layer styles, gradients, and stroke borders be used to establish visual hierarchy and guide
the viewer's attention within a composition?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

Part d: Explain how designers can effectively use text and visual effects to convey a narrative.

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

The City School / Computing / Class 8 Page 6 of 21

Q4) Sarah wants to correct the brightness of this underexposed image. Which option would you
prefer to her? And how it can be applied?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

Q5) How to apply Gradient fill in Adobe Photoshop?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

Q6) Alice wants to make some changes to this image and decides to take your help.
Which tools do you suggest to get the desired effect? Elaborate.

 Add another up of coffee on the table

 Change it from grayscale to a colour
 Remove the cell phone.

___________________________________________________________________
___________________________________________________________________
___________________________________________________________________
___________________________________________________________________

The City School / Computing / Class 8 Page 7 of 21

Q7) Name and explain any three selection tools in PHOTOSHOP. Which one do you prefer to use
and why?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

Q8) You are tasked with creating a poster for your school's annual science fair. The poster
dimensions are 12 inches by 18 inches. Explain, with reasons, whether you would choose a
resolution of 150 dpi or 300 dpi for printing this poster.

Discuss the impact of your choice on both the quality of the printed poster and the file size.

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

Q9: You are creating a webpage to share photos from a recent school field trip on the school's
website. The dimensions of the images you plan to use are 1200 pixels by 800 pixels. Discuss why
you would use a resolution of 72 dpi for these web images.
Explain the significance of this resolution choice in terms of web performance and whether
choosing a higher resolution would be necessary in this context.

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

Q10.The filter gallery provides preview of many of the special effects and filters. Elaborate the
segregation given in the GUI .

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

The City School / Computing / Class 8 Page 8 of 21

 A. B.
C. D.
E. F.
G. H.
I. J.
Q11) The Gradient tool creates a gradual transition between multiple colours. You can choose from
pre-set gradient fills or create your own. Write the name of specific gradient in front on the picture.
LINEAR
GRADIENT

RADICAL
GRADIANT

ANGULAR

The City School / Computing / Class 8 Page 9 of 21

 REFLECTED

DIAMOND

Q12) Brief about all the mentioned numbers of the brochure.

The City School / Computing / Class 8 Page 10 of

21
Q13) Here's a photo I've opened in Photoshop that has some issues with perspective. Because the
photo was shot from the right side and looking at the picture, the board seems to be leaning on the
left side, I want to make it like it was captured from the front? Which tool I can use? And how it
can be applied (4)

HANDLING DATABASE AND RESEARCH – MS ACCESS

Q1: Dina has installed Ms Access on her computer but she has no idea what to do with it. Convince
her to use it by highlighting any three of its rich functions.

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

The City School / Computing / Class 8 Page 11 of

21
Q2: In Ms Access, what is the purpose of a primary key? What are the two rules applied to it by
default?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

Q3: A query is a special question you apply to the database to find specific data and get the
information you want. Can you help, Mark AND Alex recall the four steps to plan a query?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

Q4: Define the following.

Primary Key:

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

Foreign Key:

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________
The City School / Computing / Class 8 Page 12 of
21
 Q5: Analyse the given data and write what data type will be used for each field?

Field Data Type

Name
PKR (Rupees)
Address
Contact Number
Performance Remarks
Phone Type
Unit Price
Date Allocated
Q6: Ali has joined a new company as junior data analyst & he has been given two different tables
on MS Access in which different records are there. Ali has to link both the tables and make
separate forms of each employee. How will he link the tables and how will he create form of each
employee?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

Q7: Ahmed is making a database of students on MS Access. He mistakenly selects “Number” data
type in “Name” field. Explain from where he can change the data type and how?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

The City School / Computing / Class 8 Page 13 of

21
Q8)
a. John is working on creating a database for a car rental company. He wants to ensure that
each vehicle in the database can be uniquely identified. How can he use a primary key to
achieve this?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

b. Why is it important to have a primary key in a database table?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

c. What role does a foreign key play in establishing relationships between tables in a
database?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

Q9)
a. Sarah is designing a database for a school, where students are associated with specific
courses. She wants to ensure that each student's enrolment is properly linked to the
corresponding course. How can she use foreign keys to achieve this?

________________

b. What is the purpose of using forms in a database? How can forms simplify data entry for
users?

________________

The City School / Computing / Class 8 Page 14 of

21
 c. What are reports, and why are they useful in a database?

________________

Q10

a. Why is a database useful in organizing information?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

b. Explain the difference between a table, a record, and a field in a database.

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

Q11: a - Imagine you are a manager at a company, and you have a database table with
information about all the employees. The table has millions of records. Explain why it's
essential to create a query when you want to find specific information about an employee.
Provide an example of a situation where you might use a query to get the information you need.

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

The City School / Computing / Class 8 Page 15 of

21
________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

Q11: b - Pretend you are a data analyst tasked with managing the Employee table. Explain why
creating queries is necessary when dealing with databases with millions or billions of records.
Discuss one challenge you might face when working with such large databases and how using
queries helps overcome that challenge. (4 marks)

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

The City School / Computing / Class 8 Page 16 of

21
 Q12: A garden centre sells garden tools and stores details of these in a database table named TOOLS.
Code is the primary key in the TOOLS table.

Code Description Price ($) Quantity Stock Quantity Ordered

GFLG Garden Fork 50.00 1 50
GSLG Garden Spade 50.00 11 0
GHLG Garden Hoe 45.00 8 0
HFSM Hand Fork 9.99 42 0
HSSM Hand Spade 9.99 40 0
HWSM Hand Weeder 9.99 11 0
HS20 Hose (20 metres) 45.00 10 0
HS35 Hose (35 metres) 60.00 2 0
HS50 Hose (50 metres) 75.00 20 60
YBLG Yard Brush 24.99 100 0
LMHD Lawn Mower 99.99 5 0
LMBT Lawn Mower (Battery) 249.99 7 0
LMPT Lawn Mower (Petrol) 349.99 10 25
TRBT Edge Trimmer (Battery) 79.99 15 0
TRPT Edge Trimmer (Petrol) 59.99 20 0
SHSM Shears 40.00 40 0
HCSM Hedge Clippers 40.00 45 0

(a) State the purpose of the primary key in the TOOLS table.

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________
(b) List the output from the data shown in the table TOOLS that would be given by this query-by-
example.

Field: Code Description Price ($) Quantity_Stock Quantity_Ordered

Table: TOOLS TOOLS TOOLS TOOLS TOOLS
Sort: Descending
Show:

Criteria: >40 >0 >0

Or:

The City School / Computing / Class 8 Page 17 of

21
________________________________________________________________________

________________________________________________________________________

________________________________________________________________________
(c) Complete the query-by-example grid to output the tools where the quantity in stock is
below 25. Only show the Code, Description, and Quantity Stock fields in ascending order of
Code.

Field: Code Description Price ($) Quantity_Stock Quantity_Ordered

Table: TOOLS TOOLS TOOLS TOOLS TOOLS
Sort: Ascending
Show:
Criteria: >40 >0 >0
Or:

________________________________________________________________________
Q13: A database, PROPERTY, was set up to show the prices of properties for sale and the features of
each property. Part of the database is shown below.

Brochure Number of Number of Price

Property Type Garden Garage in $
No Bedrooms Bathrooms

Bungalow B17 7 4 Yes Yes 750,000

Apartment A09 2 1 No No 100,000

House H10 4 2 Yes No 450,000

House H13 3 2 Yes No 399,000

Apartment A01 2 2 No Yes 95,000

Apartment A16 1 1 No No 150,000

House H23 3 1 No Yes 250,000

House H46 2 1 Yes Yes 175,000

(a) Give the number of fields that are in each record.

________________________________________________________________________

________________________________________________________________________
The City School / Computing / Class 8 Page 18 of
21
________________________________________________________________________
(b) State which field you would choose for the primary key. Give reason .

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________
(c) State the data type you would choose for each of the following fields.

Garage

Nuber of Bedrooms

Price in $

Q14: You are a student working on a group project, and you need to gather opinions from your
classmates about the project topic.

a. Explain how using Microsoft Forms could help you collect this information efficiently.

b. Provide one example question you might include in your survey, and discuss how the real-
time results feature of Microsoft Forms could benefit you.

Q15: Imagine you are a teacher who wants to check how well your students understood a recent
lesson.

a. Explain how Microsoft Forms could be used to create a quiz for your students.

The City School / Computing / Class 8 Page 19 of

21
 b. Provide an example of a quiz question, and discuss how the inbuilt statistics and data export
features of Microsoft Forms could assist you in evaluating your students' performance.

The City School / Computing / Class 8 Page 20 of

21