Final Exam 25 Solution

Student Information

Name: محمد نضال محمد خضرة

University ID: 120222325

XX: 25

1) Google Form

Form Title: Training Course 25

Required fields

1. Full Name — Required
2. Email — Required — Email type
3. Age — Required — Number
4. Experience Hours — Required — Number
5. Level — Beginner / Intermediate / Advanced

Notes to match the instructions

• Change the form color/theme.
• Add a header image.
• Enter at least 3 responses.
• Link the form to Google Sheets.

3 sample responses

2) Google Sheets

Sheet Name: 25_Data

Suggested columns

Category formula

=IF(E2<20,"Beginner","Experienced")

Basic calculations

Assume labels are in I2:I6 and formulas are in J2:J6.

Expected values using the sample data

• Average Age = 23.67
• Max Age = 27
• Min Age = 20
• Total Experience Hours = 75
• Number of Registrants = 3

Formatting requirements

• Color the first row with a different background.
• Make column headers Bold.
• Center all text in the table.
• Apply conditional formatting on Category:
  • Experienced = Green
  • Beginner = Orange

Chart

Create a chart showing the distribution of students by Level with a clear title, for example:

Students Distribution by Level - Training Course 25

Final organization

• Sort Age from smallest to largest.
• Ensure the data is clear and organized.

3) HTML & CSS

File Name: course25.html

Included items in the file

• Header with title containing 25
• Dark blue title color
• Different header background from body
• Horizontal navigation menu with 3 YouTube links
• Hover effect on links
• About section with Arial font
• One image with width and border
• Table section
• Registration form with text/email/number inputs and submit button
• Footer containing student name and university ID

4) Google Docs

Document Name: Final_Exam_25

Content to place in the document

Name: محمد نضال محمد خضرة

University ID: 120222325

Form Link: [ضع رابط الفورم هنا]

Sheets Link: [ضع رابط الشيت هنا]

You can paste this exactly inside Google Docs

Final_Exam_25

Name: محمد نضال محمد خضرة
University ID: 120222325
Form Link: [Paste Google Form link here]
Sheets Link: [Paste Google Sheets link here]
      

5) Submission Folder

Drive Folder Name: Final_Exam_25

Put inside it:

1. Google Form link / related files
2. Google Sheets link / related files
3. course25.html
4. Google Docs file Final_Exam_25

Then submit the folder link on Classroom.

Important note