Ict Eng 1prp Tr1
Ict Eng 1prp Tr1
Ict Eng 1prp Tr1
supervised by
2
Contents
S Topics Page
3
Lesson 1
(Green Technology)
4
Lesson 1 Green Technology
Objectives:
By the end of the lesson, I will After the lesson, check the correct box:
be able to: I can .....
- Identify what the green Very good Ok Need more work
technology is.
- Conclude that the concept of Very good Ok Need more work
sensor functionality and its
importance in our lives.
- Propose numerous ideas for Very good Ok Need more work
utilizing green technology in our
daily lives.
Engage:
What is the concept of green technology? How does it contribute to
maintaining a clean environment?
Learn
Concept of Green Technology:
It is occasionally referred to as sustainable technology or clean
technology, as green technology is based on technological tools that help
protect the environment, rather than causing harm, and optimize the use of
its resources.
Egypt has shown a recent interest in utilizing electric vehicles as an alternative
to traditional fuel-powered cars. This shift aims to decrease the emission of
harmful substances from car exhausts and minimize fuel consumption. Electric
cars operate using batteries and come with a charging station enabling
connection to an external power source for recharging.
5
Fields of using green technology:
Green technology is used in various aspects of life, such as:
1- Renewable Energy:
Solar energy: Using sunlight to generate electricity through solar panels .
Wind power: Using wind turbines to produce electricity from air
movement.
Hydropower: Using dams to generate electricity from water movement.
Geothermal energy: Using the Earth's internal heat to produce electricity.
Bioenergy: Using organic materials like soybeans and corn for energy
production .
2- Rationalization of energy consumption and responsible utilization:
Green Building: The design and construction of buildings using eco-
friendly, energy-efficient materials while enhancing ventilation and
insulation .
Utilizing energy-efficient appliances and high-efficiency computers .
Smart transportation: utilizing electric vehicles to enhance energy
efficiency within the transportation sector.
6
3- Waste Recycling:
The recycling of materials like paper, plastic, and metals into new
products .
Transforming organic waste into nutrient-rich compost to enhance soil
fertility .
Reducing waste by reusing and repairing products .
4- Water Treatment:
For additional activities and exercises, please turn to the activity booklet
(Activity No. 1)
7
Sensors usages:
Sensors are used in numerous tasks, including:
- regulating temperatures.
- operating the lights through various methods.
- detecting smoke from fires.
For additional activities and exercises, please turn to the activity booklet
(Activity No. 2).
Self-assess
ــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــ
- The Information and Decision Support Center website can be accessed at
https://www.idsc.gov.eg/Article/details/9006
8
Learn by doing
9
10
Lesson 2 Digital transformation and its
importance in our daily lives
Objectives:
By the end of the lesson, I will After the lesson, check the correct box:
be able to: I can .....
- Discuss many digital services Very good Ok Need more work
provided by the Egyptian state.
- Explain digital transformation Very good Ok Need more work
tools.
- Use an online platform.
(The Digital Egypt Platform)
meets my needs. Very good Ok Need more work
Engage
What does digital transformation mean? What digital services does the
Egyptian state offer to facilitate the accomplishment of your daily tasks ?
Learn
The term "digital transformation" is frequently discussed. What does it mean,
and why is it important in our daily lives? How does the Egyptian state
contribute to digital transformation?
Digital Transformation:
The combination of digital technology into all aspects of business to enhance
workflow efficiency, lower costs, and innovate products and services.
It enhances the efficiency of repetitive procedures and tasks, like the "Digital
Egypt" platform, which seeks to enhance government procedure
efficiency and deliver improved services to citizens.
For additional activities and exercises, please turn to the activity booklet
(Activity No. 1-3).
Second- Electronic payment methods such as:
- Electronic payment cards:
Offer convenience by providing easy, fast, and
secure electronic payment methods, simplifying
electronic financial transactions for individuals .
Important Note:
Dear student, in order to access any digital services or products, an email
address is required.
For additional activities and exercises, please turn to the activity booklet
(Activity No. 4-5).
14
Examples of the integration of green technology and digital transformation
applications:
Smart energy grids .
Precision farming .
Smart buildings .
Smart transportation .
Smart cities .
Benefits of integrating green technology with digital transformation:
Self-assess
15
Learn by doing
a. INSTAPAY
b. Google Meet
c. WhatsApp
d. Email
transformation.
16
2- Think and Search:
The Egyptian state has provided many digital services that help citizens
accomplish their tasks. Search the Internet for the most important digital
services that you can use to help you in life.
1-......................................................................................................
2-......................................................................................................
3-......................................................................................................
4-......................................................................................................
A family member has asked you to help him obtain a violation certificate for
his car. Determine the procedures that must be followed to obtain a violation
certificate.
1-......................................................................................................
2-......................................................................................................
3-......................................................................................................
4-......................................................................................................
17
18
Lesson 3 Operating Systems
Objectives:
By the end of the lesson, I will After the lesson, check the correct box: I
be able to: can .....
- Categorize the operating systems Very good Ok Need more work
(computer - cellphones)
Engage
How digital devices such as computers or cellphones operate?
Learn
In previous classes, we studied operating systems and software, and
learned about the importance of the operating system and the hardware
components of the computer.
19
An operating system manages hardware and software components.
For additional activities and exercises, please turn to the activity booklet
(Activity No. 1).
The provided diagram illustrates the key functions of the operating system.
20
Modern electronic devices, smart devices, and operating systems
used in our daily lives:
Operating systems are necessary for the operating and managing a variety of
modern electronic and smart devices.
Here are examples of modern electronic devices and smart devices, along
with the operating systems used:
2- Mobile Devices:
Smartphones and tablets depend on operating
systems like:
- Apple's iOS
- Google's Android operating system.
- Alternative mobile operating systems.
3- Servers:
Servers use operating systems like:
4- Gaming Consoles:
Gaming consoles such as PlayStation, Xbox, and
Nintendo Switch feature exclusive operating systems
tailored for gaming and multimedia purposes.
21
5- Smart TVs:
6- Wearable Devices:
Wearable devices like smartwatches and fitness
trackers use operating systems tailored to their
distinct functions and needs.
7- Network Devices:
Routers, switches, and other network equipment
use operating systems for network management,
settings, and security advantages.
There are various operating systems used in modern cars, vehicles, ATMs,
and factories, such as:
1) Automotive Systems:
Modern cars and vehicles often have operating systems to control various
functions such as infotainment, navigation, and driver assistance technologies
while driving and controlling the vehicle.
2) Embedded Systems:
22
- Point of sale terminals are electronic devices that enable customers to pay for
purchased products by deducting the price from their bank account instead of
using cash.
It is a broad term that includes many industrial control systems and devices
used in industrial facilities to control the performance of machines and
industrial processes. Industrial control systems work on the following:
For additional activities and exercises, please turn to the activity booklet
(Activity No. 2-3).
23
Startup screen of an operating system
Desktop
The operating system startup screen (desktop)
includes a set of symbols called Icons that appear
arranged in a specific order over a background of
an image or color that the user selects.
Note:
- The startup screen varies for different operating systems.
- The startup screen varies for the operating system according to the version of
the operating system.
For additional activities and exercises, please turn to the activity booklet
(Activity No. 4).
Self-assess
24
Learn by doing
- Connect peripheral devices such Very good Ok Need more work
as printers to my personal
computer.
- Discuss the steps of downloading
files (compressed or via the
Very good Ok Need more work
Internet) on my device.
Engage:
How can you add, install, or remove software on your computer or cellphone?
Learn:
While you are preparing and getting ready to apply your project on your
computer or mobile, you will need to use many programs, and you must make
sure that these programs are available on the device. If the operating system
does not have the program you need, you can get the program yourself, either
from a storage unit or by downloading the program online. You can then install
the program on your computer to use it.
27
First: Installing the program from a CD or DVD.
1. Insert the software disc into your computer CD or
DVD drive. The AutoPlay dialog box will appear.
The following screen displays one of the processes
that takes place in Windows 7 .
2. Click Run SETUP.EXE, where SETUP.EXE is
usually the name of the installation program.
3. Follow to the installation instructions provided by
the software .
For additional activities and exercises, please turn to the activity booklet
(Activity No. 1-2-3-4).
28
Remove or uninstall a program
When you plan to stop using a program installed on your computer or
mobile, you must uninstall the program from your device.
Uninstalling a program means that you delete all the files of the program that
you want to remove from your computer.
There are two methods to remove or uninstall the program; to do
this…
- The program does this itself, as many programs come with their
own removal or uninstallation command.
- Or through the Control Panel, where the operating system helps
you uninstall the program.
Note: Removing unused programs saves disk storage space and
speeds up and eases the use of the device.
29
Setting up and Configuring Hardware
Operating systems support many devices attached to the computer such as
printers, webcams, scanners, in a way that varies depending on the type of
operating system, as the operating system automatically detects the new
attached device, and the operating system installs the correct „Driver’ for the
attached device, so that you can use the new attached device with its full
features.
The Setup program automatically copies the driver files and the setup
information file (.inf ) into a dedicated folder.
Second: When the operating system does not include a matching driver for
the new accessory
When the operating system detects that a new device has been connected
with the Plug and Play feature (after connecting it to a USB port, for example),
but the operating system cannot determine the appropriate driver for this new
device, the operating system runs a wizard program to find the driver for the
new peripheral, and you can determine where the driver for the new peripheral
is located, whether this program is on a CD or other storage device, ...
First: Install a local printer (i.e. directly connected to the computer) that
supports the Plug and Play feature
It is connected to the USB port, and the Plug and Play feature will
automatically install it.
31
- Click on "Add a printer".
- We click the printer that I desire is not listed.
32
- Select Add a local printer or network printer with manual settings.
33
- Click „Next’ to choose the appropriate driver.
- From the list of drivers available in the Driver Store you can choose the one
that is compatible with your printer type.
- If you don't have a driver to identify your printer, or if you suspect that a
newer version is available, click Windows Update to update the list of printers.
- After the update is complete, check the list again to see if your printer model is
available.
- The last step in the printer setup process is to give the printer a name. The
default name usually includes the manufacturer and model of the printer; you
can change this value to a more descriptive name now or later.
35
Note: If the printer driver package includes a setup program, run the setup
program and through it you can identify the printer within the operating
system.
For additional activities and exercises, please turn to the activity booklet
(Activity No. 5-6).
Self-assess
36
Learn by doing
1) When you download software from the Internet, the software is in the
form of a/an ........... which is used to install the software.
A- digital fingerprint B- file C- image D- worksheet
2) Removing a program means that you are .....................
A- Copying all the program files to the computer.
B- Deleting all the program files from the computer.
C- Pasting all the program files to the computer.
D- Saving all the program files from the computer.
3) Many programs come with a command ..............
A- Copy their installation B- Uninstall their installation
C- Paste their installation D- Compress their installation
4) Removing unused programs leads to ...............
A- Slowing down the computer B- Saving storage space
C- Difficulty in using the device D- Stopping the computer
5) When the operating system automatically detects a new peripheral
device, it ...............
A- deletes the driver for the peripheral device
B- install the appropriate driver for the peripheral device
C- shut down the computer
D- restart the computer
6) To install a new peripheral device, it is required to provide ............
A- Information and data B- Drivers C- Folder D- Images
7) Modern operating systems include a list of ……...... for many accessory
devices.
A- Malware B- Viruses C- Songs D- Drivers
37
8) The Plug and Play feature is ..............
A- The operating system deletes the correct and appropriate driver for the
new peripheral device
B- The operating system installs the correct and appropriate driver for the
new peripheral device
C- The operating system copies the correct and appropriate driver for the
new peripheral device
D- The operating system shuts down the computer
1) While you are preparing and getting ready to implement your project on
your computer, you must make sure that the required programs are on the
device. ( )
2) Many programs come with their own removal or uninstallation command.( )
3) To uninstall the program, use the Control Panel. ( )
4) The operating system helps you uninstall the program. ( )
5) Removing unused programs increases the storage space on the disk. ( )
6) Operating systems support many devices attached to the computer such as
the printer and webcam. ( )
7) When the operating system automatically detects the new peripheral device,
it installs the appropriate driver for the peripheral device. ( )
8) Modern operating systems do not include a list of drivers for many accessory
devices. ( )
9) A driver is a file or files that the operating system installs to use the new
peripheral device with its full features. ( )
38
3- Write the steps to install the program from a CD or DVD on the
computer:
1-.............................................................................................
2-.............................................................................................
3-..............................................................................................
4- Write the steps to install the program from a file downloaded from
the Internet on the computer:
1-.............................................................................................
2-.............................................................................................
3-.............................................................................................
5- Write the steps to install the program from a compressed file on the
computer:
1-.............................................................................................
2-.............................................................................................
3-.............................................................................................
6- Write one of the ways to remove or uninstall the program to do this:
1-............................................................................................
2-............................................................................................
3-............................................................................................
7- Write the steps to remove a program installed on the device through
the control panel:
1-...........................................................................................
2-...........................................................................................
3-...........................................................................................
8- Write the steps to install a local printer (i.e. directly connected to
the computer) that supports the plug and play feature
1-.................................................................................................
2-..................................................................................................
3-...................................................................................................
39
9-Write the steps to install a printer that does not support the Non–
Plug and Play Printer feature
1- .....................................................................................................
2- .....................................................................................................
3- ………………………………………………………………….
40
41
Lesson 5 E-mail
Objectives:
By the end of the lesson, I will After the lesson, check the correct box:
be able to: I can .....
- Explain the components
Very good Ok Need more work
of an email.
- Practice the steps for
Very good Ok Need more work
composing an email.
- Discuss the services
Very good Ok Need more work
provided by e-mail in
dealing with websites.
Engage
How can you create your personal email account?
Learn
In previous years, you have learned about some email service
providers that provide you with the service of creating an email. In this
lesson, you will create an email through one of the free email service
providers, and use it to send and receive email messages to your teacher or
one of your friends.
Definition of Email
• It is a digital communication system used to send and receive messages
between users over the Internet.
42
Components of E-mail address
An email address consists of three main components:
1- User name:
It is the part that is located at the beginning of the email address, and it is a
name that the user chooses and specifies. The user name is a unique and
distinctive name that is not reserved by anyone else.
2- The @ symbol (at sign):
It is a symbol that separates the user name from the name of the email
server (domain name) used.
3- Domain name:
It is the name of the email server that hosts the email account and is a
place to store your email messages.
43
Providers of Email Services
There are many free email providers available such as:
Gmail
Yahoo Email
Hotmail/Outlook
44
(2) Click Sign in
45
(5) Insert your ‘First name’ and ‘Last name’, then click the ‘Next’ button.
(6) Enter your date of birth and gender, then click ‘Next’.
(7) Type the username you want in the ‘Username’ field and then click ‘Next’.
46
(8) Choose the password you want, and confirm it again, making sure that
it is difficult to guess.
(9) Enter an alternative email address used to recover the account and you
can skip this.
47
(10) Check and confirm your email address.
48
(11) To complete the steps to create your email, review the terms of service
and click ‘I agree’ if you accept them.
49
(12) Now that you have a ‘Google Account’ (username and password), you
can use your ‘Google Account’ to access your email or many of the
services provided by ‘Google’.
50
The interface language can be modified by selecting the settings icon and
then choosing ‘See all settings’.
From the "General" menu, select the Arabic language under "Gmail
display language".
51
When you choose the Arabic language and click the ‘Save Changes’ button, the
Gmail email window interface appears in Arabic as shown below:
For
52
Learn by doing
1) Email is a..............
B- spam
C- fraud
D- viruses
D- text file
53
6) One of the disadvantages of using email is ………....
1- ...................................................................................
2- ..................................................................................
3- ..................................................................................
54
55
Lesson 6 Cloud Computing
Objectives:
By the end of the lesson, I will After the lesson, check the correct box:
be able to: I can .....
- Explain the importance of
Very good Ok Need more work
cloud computing in
accomplishing my tasks.
- Discuss the areas of use of
Very good Ok Need more work
cloud computing in our lives.
- Practice uploading my files
Very good Ok Need more work
to cloud computing and
sharing them with my
colleagues.
Engage
Which digital tools and applications are used for creating and sharing files
with your teacher and classmates?
Learn
Cloud computing
In previous years, I learned about the concept of "Cloud Computing".
56
Cloud computing:
It is a model for providing digital services over the Internet. Such as:
For additional activities and exercises, please turn to the activity booklet
(Activity No. 1)
2- Availability of the service: The user can access his data, files and
applications from anywhere where the Internet service is available.
For additional activities and exercises, please turn to the activity booklet
(Activity No. 2)
57
Areas of using cloud computing applications in daily life:
Some examples of areas of using cloud computing applications in daily life
1-Communication:
• Email: Use cloud email such as Gmail, Outlook, and Yahoo Mail daily to
communicate with family, friends, and colleagues.
• Social networking: We communicate with others and share content on social
media platforms such as Facebook, Twitter, and Instagram
• Messaging services: We use messaging applications such as WhatsApp and
Telegram to communicate and share files and photos.
2-Computer storage:
• File storage services: We use services such as Google Drive and One Drive to
store, share, and access files at anytime and anywhere.
• Data backup: We use cloud backup services to protect our data from loss in
case of any damage happens to our devices.
3-Producing projects by using:
• Word processing programs: We use cloud word processing programs such as
Google Docs, Microsoft Word Online to create, edit and share documents with
others.
• Spreadsheets: We use cloud spreadsheets such as Google Sheets and
Microsoft Excel Online to organize and analyze data and create charts.
4-Education:
• E-learning platforms: We use e-learning platforms to access educational
materials and interact with teachers and students such as the Ministry of
Education platform.
58
• Collaboration tools: We use cloud collaboration tools such as Google
Classroom and Microsoft Teams to work on projects and assignments with
others.
5-Entertainment:
• Video streaming services: We enjoy watching movies, TV shows and
programs on video streaming services such as YouTube.
6-Other areas:
• Online shopping: We shop through e-commerce sites.
• Online banking: We use online banking to transfer money and pay bills.
For additional activities and exercises, please turn to the activity booklet
(Activity No. 2)
59
6- Data access: Data can be accessed by users and applications through the
Internet
3- An internet connection.
• Microsoft Azure
For additional activities and exercises, please turn to the activity booklet
.(Activity No3)
Self-assess
60
Learn by doing
3- The software and application service over the Internet is known as ..........
A- Enabling the use of software and applications over the Internet.
B- Enabling the use of software and applications without the Internet.
C- Sharing and exchanging files locally
D- Email service
61
6- Services for storing, sharing and accessing files at any time and from
anywhere are called ...............
A-Email B-Software and applications.
C- Computing storage D- Google Sheets
10- The most famous cloud computing service providers are ………
A-Google Docs B- Google Sheets
C- Google Classroom D- Google Cloud Platform
62
Think and answer
1- Write 3 benefits of cloud computing:
1-......................................................................................
2-......................................................................................
3-......................................................................................
63
64
Lesson 7 Google Meet and Project
Management
Objectives:
By the end of the lesson, I will After the lesson, check the correct box:
be able to: I can .....
- Follow the correct procedures Very good Ok Need more work
for digital communication with
my colleagues
- Share files with my colleagues Very good Ok Need more work
via the Google meet application
Engage
What digital applications did you were study in previous classes for
communication with colleagues and friends, and how did you use them?
Learn
In the previous lessons, you learned about some digital transformation
tools, including collaboration and direct communication tools between users to
make video calls and online conferences, to exchange data, information and
ideas and to produce projects, as you can use them to communicate with others
face to face. Examples of these include the "Google Meet" application, which is
one of the services provided by Google. In order to access the "Google Meet"
service, you must have a "Google account", which you previously created in
Lesson 4.
65
Google Meet
It is a video conferencing service developed by Google that enables users
to conduct group video calls, share screens, chat, collaborate in real time, and
work together on joint projects among students.
For additional activities and exercises, please turn to the activity booklet
(Activity No. 1)
66
Create a meeting from "Google Meet":
To create a meeting from "Google Meet" there are several options
through which you can hold a meeting.
For additional activities and exercises, please turn to the activity booklet
.(Activity No. 2)
67
Second - Create a meeting for a later time:
The "Google Meet" application also enables you to create a meeting
for a later time, and keep its link until the time you want to meet with
whomever you want to invite to attend:
• Follow the same previous steps to create an instant meeting
• Click on "Create a meeting for a later time".
• A small window will appear with a link to the session.
• Copy the meeting link.
• Send the link to the people you want to hold the meeting with.
Sometimes, you may need to approve the request of invitees to join
the session, in other words, when the invitee tries to access your session, you
will see a notification at the top of the page through which you can accept
or reject the person's joining.
68
Here are some options and features you can use during the meeting:
Click on one of the tabs (entire screen, window or tab) and then click on the
Share button.
69
• Stop sharing presentation
In the Google Meet window, click “Stop sharing.”
For additional activities and exercises, please turn to the activity booklet
(Activity No. 3)
Self-assess
70
Learn by doing
2- Through …...... you can make calls, group video, share screens, and chat.
A- Indirect B- Direct
C- Slow D- Difficult
71
6- To express your opinion in an organized manner during a "Google
Meet" meeting, you can click on ..................
7- One of general rules that must be followed during the meeting is……
8- To invite others to a Google Meet meeting, you must send them ............
9- To create a meeting next week through Google Meet, you choose …….
10- You have been invited to a Google Meet meeting, to join the meeting
you must click on ………….
72
12- When you are invited to a meeting through a link, you must ……......
13- When you finish showing your screen during the meeting, you must
click ................
14- During a "Google Meet" meeting, and to organize the meeting, when
speaking, you must .................
73
74
Lesson 8 Database Design
Objectives:
By the end of the lesson, I will After the lesson, check the correct box:
I can .....
be able to:
- Explain what big data is
Very good Ok Need more work
- Identify the difference between Very good Ok Need more work
creating a table using programs
(Word-Excel -Access).
- Create a simple data table on Very good Ok Need more work
Access.
Engage
How can you establish a database for your class? Which applications will you
use for this purpose?
Learn
In previous classes, we studied the concept of databases and how to use a
spreadsheet program and perform some simple mathematical operations on it,
and the word processor program Word in preparing your CV or writing reports
for your teacher. In this lesson, we will discuss one of the programs in the
Office package (Access) that enables you to create a database.
Databases:
A collection of data and information organized and linked to each other. It
is similar to a library in which books are kept, but instead of books, data and
information are stored. A database is used to store and retrieve information
easily and efficiently. Information is stored and managed digitally using
dedicated programs and applications.
75
The importance of databases in our lives:
1- Saving students' information at school including name, date of birth, home
address, etc.
2- Saving medical records in hospitals including information like the patient's
name, address, attending physician's name, and the date of patient's last visit.
3- Tracking inventory in stores including product name, manufacturer,
manufacturing date, and price.
For additional activities and exercises, please turn to the activity booklet
.(Activity No. 1)
Big Data
- The term Big Data refers to very large and diverse sets of structured,
unstructured and semi-structured data that continue to grow significantly over
time.
- These data sets are so large and complex in terms of size, growth rate and
diversity that traditional data management systems cannot store, process and
analyze them.
- The amount of data is increasing and growing rapidly due to the rapid
development of digital technologies, such as artificial intelligence (AI), and
the Internet of Things (IoT). As data continues to increase, expand, and
spread, new big data tools are emerging to help companies collect, process,
and analyze data at the speed needed to get the most out of it.
For additional activities and exercises, please turn to the activity booklet
.(Activity No. 2)
76
Data Table:
Concept of data table:
A data table is a basic element in building databases and is the only
source of data within the database. A data table consists of rows and columns,
where each row represents a single record of data, and each column represents a
specific field of data.
For additional activities and exercises, please consult the activity booklet
.(Activity No. 3)
77
Microsoft Access:
It is one of the applications used to create
databases. It builds a real database, where you can
build a complex structure for data and manage it
more efficiently.
78
2
79
Steps to create a Table in Access:
You can create a Table in Access by doing the following:
A- Table Design: To write the names of the table fields and specify their data
type.
B- Datasheet View: To enter and display the table data.
A- Table Design:
To choose the "Table Design" style, follow the following steps:
1- Choose "CREATE".
1
2- Choose the "Table Design".
1 2
80
Example of steps to design a "student grades" table:
In the table design window, the table fields are created by typing the field
name, selecting the field statement type.
- Type the following field names and choose their statement type:
• Student number field which is id
• Name
• Arabic grade
• English grade
• Computer grade
1- Type the field name "id" student number
2- Choose the field statement type from the drop-down list "AutoNumber".
3- Write the rest of the field names,
and select the appropriate statement
type for each field.
81
B- Datasheet View
To enter and view the table data.
1- Choose "View"
Primary Key:
82
It is a field in a database table that is used to uniquely identify each
record in that table, and the primary key value is never repeated within the same
table.
Primary Key for the "Student Grades" table: The "id" field was chosen as
the primary key because it is an automatic number given to the student, and
each student has a unique number that is not repeated with any other student.
Make the "id" field the Primary Key for the "Student Grades" table.
Self-assess
83
Learn by doing
1. Databases are a collection of data and information that are not related to each
other. ( )
2. Databases are information stored and managed manually using dedicated
programs and applications. ( )
3. A database is an organized collection of data related to a specific subject. ( )
4. Databases are used to save student data in school. ( )
5. We use databases to track inventory in stores. ( )
6. It is difficult to use databases on websites. ( )
7. A data table is a non-essential element in building databases. ( )
8. A data table is the only source of data within a database. ( )
9. In a data table, each row represents more than one record of data. ( )
10.We use Microsoft Access when we have a large amount of complex data. ( )
11.We use the "Design View" of the table to write the names of the table fields
and determine the type of data. ( )
12.We use the "Data View" of the table to enter and display the table data. ( )
13.We determine the type of data for the student name field as "Text" to perform
calculations on it. ( )
14.We specify the type of the data of the degrees fields as "Number" to perform
a calculation on it. ( )
15.In the database table, we must specify for each column the type of data it
contains. ( )
16.The primary key field is used to uniquely identify each record in the
table. ( )
17.The primary key value can be repeated within the same table. ( )
84
85
Lesson 9 Forms & Queries
Objectives:
By the end of the lesson, I After the lesson, check the correct box:
will be able to: I can .....
- Explain the steps to implement a Very good Ok Need more work
Form in databases.
- Use the operations (add field - Very good Ok Need more work
hide field from the query
result) for the database.
Engage
How can you create a database for your class? Which applications will you use
for this purpose?
Learn
First: Forms in databases:
Form:
It is a graphical interface designed specifically to interact with data stored
in the database. It is a screen that displays specific information from the
database and allows the user to enter, modify or delete this information in an
organized and convenient way.
Create a form:
A new form can be created under the name "Enter Student Grades" using
the Form Wizard.
86
Example: To create a form from the current table "Student Grades"
1-Click on the table name "Student Grades" in the Navigation Pane on the left
of the screen, and the data for the "Student Grades" table will appear on the
right of the screen.
2- Choose the Create tab.
3- Click Form.
The Access program creates the form, and through the form the data for each
student‟s record is displayed individually, as in the following figure:
1- The current window is called Layout view, where the data of the first record
is displayed.
2- Click on the "Next record" icon to display the data of the next record.
3- Click on the "Last record" icon to display the data of the last record.
4- Click on the "First record" icon to display the data of the first record.
87
Note that:
• The form is used to enter and modify data in the "Student Grades" table.
• All data entered through the form appears in the "Student Grades" table.
• Data can be entered through the data table or through the form.
• There are several other ways to create a form in an Access desktop database.
Examples of queries:
• Create a query to display data from a student's record.
• Create a query to display a list of students who scored more than 18 marks in
English.
88
3- The following screen appears:
90
Execute the query:
- On the Design tab
- Click on the Run icon in the Results group
- The query result appears in the form of a table, showing all student data.
91
However, what is required is to create a query that shows the names of all
students and the Arabic score only for each student.
Hide a field or fields from the query result:
- To hide one or more fields from the query result,
- From the "View" menu, choose "Design View"
- The query design window will appear.
- Click on the ✓ sign in the check box in the Show row in the design grid below
the columns Computer score and English score.
- The sign will be removed, which means hiding the field/fields in the query
result.
- When you remove the ✓ sign from the English score and computer score
columns in the Show row in the design grid, this means that these two fields
will not appear when executing the query.
- Click on the Run icon in the Results group and the result will appear as
follows:
92
Result of query execution
93
- Execute the query, the student record or records that meet the criterion or
condition are displayed.
For additional activities and exercises, please turn to the activity booklet
(Activity No. 1)
Self-assess
94
Learn by doing
1. The form is a graphical interface designed to interact with data stored in the
database. ( )
3. A new form can be created under the name "Enter Student Grades" using the
Form Wizard. ( )
4. All data entered through the form does not appear in the "Student Grades"
table. ( )
5. Data can be entered through the data table or through the form. ( )
database. ( )
9. The Query Design window is divided into two parts; the upper part is the
10.The Query Design window is divided into two parts; the lower part is the
95
96
Lesson 10 Your Digital Project
Objectives:
By the end of the lesson, I will After the lesson, check the correct box:
be able to: I can .....
- Explain the stages of designing Very good Ok Need more work
my research project.
- Design one of the projects I am Very good Ok Need more work
looking forward to.
Engage
How can you design your digital project? Which digital applications are
used to express your idea?
Learn
In the previous years, you have learned about creating a digital project through
different tools such as using the PowerPoint presentation program and
designing a poster with consideration for good design principles. Now, we will
learn more about the stages of implementing your digital project.
Stages of Project
Implementation:
1. Stage One: Start the Project
Determine a clear, achievable idea.
Determine specific, measurable, and
achievable goals.
2. Stage Two: plan the project
Develop detailed plans and studies
that include a work plan.
Develop a specific timetable for each
stage of the project.
97
Determine project requirements
Project name proposal: The Great Nile River and the Rivers of the World.
Objectives of the Great Nile River and the Rivers of the World Project:
• Study of natural phenomena: The study of rivers
contributes to understanding natural phenomena related
to the water cycle, such as floods and droughts, and their
impact on climate and the environment.
• History and heritage: Rivers play an important role
in the history and civilizations of peoples, and studying
them helps to understand the development of
civilizations and their interaction with the aquatic
environment.
• Studying the Nile and other rivers is a journey rich in knowledge and benefit,
contributing to a better understanding of the natural world, sustainable
98
management of water resources, economic and social development, and
enhancing human well-being.
Second: Project Planning Stage:
Activity (1):
Dear student, with the help of your teacher and in cooperation with your
colleagues, in your opinion:
- What data and information do you need to collect for the project?
- What tools, devices and applications are required to be prepared and
equipped for this project?
- What is the time period required to implement the project?
.................................................................................................
.................................................................................................
.................................................................................................
Data and information you need to collect for the project:
• Find the five most famous rivers in the world.
• Design a table containing data for the five most famous rivers, including the
name of the river - its length - the name of the source country - the name of the
downstream country - the number of countries it passes through - the name of
the continent in which the river is located.
• Find pictures of this river.
• Find a video that shows information about the river.
• Use reliable websites and reliable sources.
• Use the Egyptian Knowledge Bank.
• Find more information about each of the five rivers.
• Find the length of the Nile River - the name of the source country - the name
of the downstream country - the number of countries it passes through.
• Ask your social studies teacher to verify the data and information you and your
colleagues have collected.
Tools, devices, and applications required to prepare and equip for the
project
• Identify the computer and the required peripherals.
• Prepare and equip the applications and programs used.
• Determine the time period for the project.
99
• Identify direct and indirect communication tools to exchange ideas and
opinions and exchange data and information.
• Identify reliable sources.
Third: Project implementation stage:
• Forming work groups
• Dividing tasks among colleagues
• Determining the tasks of each colleague
• Starting work to implement the project according to the plans set.
101
6- Enter the password then click Next.
Now,
you can open the different cloud applications that appear in front of you in
102
the list, including Google Docs, Google Sheets, Google Slides, and use them
in your project.
Activity (3)
Dear student, with the help of your teacher and in cooperation with your
partners, review the components of the main screen of the Docs application and
write 4 of its components:
1- …………………………………………………………….
2- …………………………………………………………….
3- …………………………………………………………….
4- …………………………………………………………….
103
Activity (4)
Dear student, with the help of your teacher and in cooperation with your
partners, search the Internet for the importance of studying the world's rivers
and write two paragraphs in the application docs:
....…………………………………………………………………………..
....…………………………………………………………………………..
Activity (5)
Dear student, with the help of your teacher and in cooperation with your
partners, search the Internet for a list of the most important rivers in the world,
including 5 rivers, and write them in docs
Activity (6)
Dear student, with the help of your teacher and in cooperation with your
partners, format the paragraphs and lines for what you wrote in docs
Activity (7)
Dear student, with the help of your teacher and in cooperation with your
partners, save the document as “Rivers of the world” in docs
Activity (8)
Dear student, with the help of your teacher and in cooperation with your
partners, open the Sheets application as one of the cloud computing services
applications. It is one of the spreadsheet applications that allow you to create
spreadsheets that contain literal values or Digital and formula equations and
save, print and share them with others.
104
Activity (9)
Dear student, with the help of your teacher and in cooperation with your
partners, review the components of the main screen of the Sheets application
and write 4 of its components:
1- ....…………………………………………………………….
2-....…………………………………………………………….
3-....…………………………………………………………….
4-....……………………………………………………………
.
Activity (10)
Dear student, with the help of your teacher and in cooperation with your
partners, search online for the longest rivers that you wrote in the Docs
application and their geographical location.
Activity (11)
Dear student, with the help of your teacher and in cooperation with your
partners,
- Create a table with the river data you collected.
- Make a schematic diagram of the distribution of the lengths of those rivers in
the Sheets application.
105
Third: Using the Google Slides application in the project:
Activity (12)
Dear student, with the help of your teacher and in cooperation with your
colleagues, open the Slides application as one of the cloud computing services
applications. It is one of the presentation applications that allows you to create
slides that display textual content, images, video, a table, a schematic diagram,
or drawings to an audience in a hall, meeting, or online, and save, print, and
share them with others.
Activity (13)
Dear student, with the help of your teacher and in cooperation with your
partners, review the components of the main screen of the Slides application and
write 4 of its components:
1-....…………………………………………………………….
2-....…………………………………………………………….
3-....…………………………………………………………….
4-....…………………………………………………………….
Activity (14)
Dear student, with the help of your teacher and in cooperation with your
partners, prepare the following slides in the Slides application from the data you
collected through searching the Internet and used in the Docs and Sheets
applications.
1- An introductory slide explaining the goal of the project
2- Two slides for the most important global rivers with illustrative images
3- A slide for distributing the lengths of the main rivers
Self-assess
107