Cambridge International Schools

Computing Practical Exercises

Stage 8

2023/2024
 1) Create a new folder on the desktop and name it (Your name G8A) for example if
you are in Grade 8A.
The answer is:

2) A/ Record the below information on an excel file:

Argentina Buenos Aires 42,000,000 Spanish 2,000,000 sq km South America

Liberia Monrovia 3,000,000 English 96,000 sq km Africa

Angola Luanda 18,000,000 Portuguese 1,000,000 sq km Africa

Uzbekistan Tashkent 28,000,000 Uzbek 425,000 sq km Asia

Japan Tokyo 127,000,000 Japanese 394,000 sq km Asia

Senegal Dakar 12,000,000 French 191,000 sq km Africa

Brazil Brasilia 205,000,000 Portuguese 8, 000,000 sq km South America

Malaysia Kuala Lumpur 29,000,000 Malay 328,000 sq km Asia

United States Washington 313,000,000 English 9,000,000 sq km North America

Finland Helsinki 5,000,000 Finnish 305,000 sq km Europe

1. Insert a new row above the records and type titles in the columns that describe the content of the
field. (Hint: First column: country , second:Capital,…)
2. In the title of the fifth column type the corresponding unit of measurement and delete it from the
column’s cells. (Hint: use the function of “Find and Replace” and replace the “sq km” with “ “
(space).)
3. Apply a table style.

• Once you have finished, save your file on the desktop inside your folder (Ahmad
Burhan G8A) and name it ‘Question 2.
B) In the previous question you had created a database table and saved it. Open it and by using
filtering and sorting find the answers for the below questions:
Hint: Each time you apply a filter or a sort click the” Undo” button to restore the table to its
original condition. Also, don’t save your work until you apply the last sort or filter.

1. Display the records that are in Africa and answer the following questions:

a. How many records appeared?

b. The third-largest country in population is
c. The smallest country in land area is

2. Display the records that aren’t in Asia and answer the following questions:

a. How many records appeared?

b. Apply sorting from A to Z in the country column and mention the name of the fourth
country that appears in the column:
c. Apply sorting from A to Z in the language column and mention the name of the last
country that appears in the column:

3. Display the records where the official language is English from all over the world and answer
the following questions:

a. How many records appeared?

b. The largest country in population is

4. Make the appropriate sorting to find which country is the third largest by population. Note the
country you found:
5. Make the appropriate sorting to find which country is the sixth-smallest in land area. Note the
country you found:
6. Make the appropriate sorting to find the language in the country that is first in alphabetical
order. Note the language you found:
7. Display the records where the land area is between 425,000 sq and 1,000,000 sq miles.

a. How many records appeared?

b. Note the official languages that are spoken in these countries:
 3) Divide the below table into two separate tables. The first table (Authors) contains the authors (4
records) and the second table (Books) contains the book titles (6 records).
Then in Microsoft Access make a proper relationship between these tables:

Hint: Make two excel files and insert the information of the below two tables there,
then go to access and import both excel files and finally make a relationship there

Author name Book Title

Dickens Great Expectations
Dostoevsky Crime and Punishment
Dostoevsky The Idiot
Andersen Fairy tales
Dickens The Battle of Life
Hemingway The Old Man and the Sea

Authors Books
Book_ID Book title Author_ID
Author_ID Author name
1
1 2
2 3
4
3
5
4 6

The final result should look like the below picture:

• Once you have finished, save your file on the desktop inside your folder (Ahmad
Burhan G8A) and name it ‘Question 3.
 4) Open Microsoft Word and answer the following questions below:
1. Create a document and add a Blank (three columns) Header, 0.9 cm from the Top. Edit the Header:
• In the first field type your City.
• In the second field type the phrase “Our Restaurant”.
• In the third field type the Date.
• Close the Header.
Then, add an Alphabet Footer 0.9 cm from the Bottom. Edit the Footer:
• Type the text “There are No Strangers Here, Only Friends we haven’t met Yet.”. Format it as you like.
• Format the page Numbering as you want.

• Once you have finished, save your file on the desktop inside your folder (Ahmad
Burhan G8A) and name it ‘Question 4.
 5) Make a Microsoft Word Blank document and make 5 pages by page break then:

a. Add today’s date on the heading and page number on the footer
b. Differentiate odd and even pages
c. Change the background color and set the color as Red: 248, Green: 201 and Blue: 166 from the
RGB Color model.
d. Then add the Gradient effect with two colors. Leave the first color as it is and set the second
color as Red: 226, Green: 212 and Blue: 228 from the RGB Color model.
e. Add a shading style of your choice.
f. Add the pattern “Large checker board”.
g. Finally save the file as PDF format.

Once you have finished, save your file on the desktop inside your folder (Ahmad
Burhan G8A) and name it ‘Question 5.

6) Open Microsoft Word and type the below message. Insert the proper symbols in the correct
places! Use the Wingdings font in the Symbol window.

Hello Mike!

How are you? I’m ☺! I bought a new  and I am able to work from my home now.
Tomorrow I will  to Paris for my summer vacation! I  you 2 days ago but I couldn’t
get a hold of you. So I’m sending you a . I hope you are fine!
Mary!

• Once you have finished, save your file on the desktop inside your folder (Ahmad
Burhan G8A) and name it ‘Question 6.

7) Open Microsoft Word and type the following mathematical formulas

𝑎 𝑐 𝜋
𝑋2 = + +
𝑏 𝑑 2
3
𝑦 = √𝑎 + √𝑎2 + 𝑏 2

𝑥 = √(3 − 𝑘)2 + (13 − 𝑙)2

• Once you have finished, save your file on the desktop inside your folder (Ahmad
Burhan G8A) and name it ‘Question 7.
 8) Open Microsoft Word and type the below message.
Insert the citations and the footnotes.

Albert Einstein1 was a German-born theoretical physicist who developed the general theory of relativity, one
of the two pillars2 of modern physics - alongside quantum mechanics (Elie, Poncare's Philosophy, 2001).
While best known for his mass–energy equivalence formula E = mc2 (which has been dubbed "the world's
most famous equation" (Bodanis, 2000)), he received the 1921 Nobel Prize3 in Physics "for his services to
theoretical physics, and especially for his discovery of the law of the photoelectric effect." The latter was
pivotal in establishing quantum theory.

1
March 14th 1879 – April 18th 1955
2
a tall vertical structure
3
awards given for intellectual
 9) Open Microsoft Word and insert a table first and type the below Symbols.

→  ➔  ☺  ©

• Once you have finished, save your file on the desktop inside your folder (Ahmad
Burhan G8A) and name it ‘Question 9.

10) Create the spreadsheet below as follows:

1. Create a new “blank workbook” and enter the spreadsheet row titles and column titles and data as
shown.

Answer the following questions:

• Make the title font size 20 and apply bold, underline, and colour it red.
• Add the formula in the ‘Final Average’ column to find the average for all subjects.
• Align and centre all columns.
• Add shading colour for the titles.
• Once you have finished, save your file on the desktop inside your folder
(Ahmad Burhan G8A) and name it ‘Question 10.