Class 8 – Computer Practical (HTML &
MS Excel)
Time: 30
Minutes
Marks: 20
DO ANY ONE👇
Part A: HTML (Advanced Level) – 10 Marks
Question 1 (10 Marks)
Using Notepad, create a structured
webpage.
Requirements:
Basic Structure (Compulsory)
- Use <html>, <head>, <title>, <body>
- Title: School Information Page
Design the Webpage with the following:
- Add a main heading <h1>
→ “ABC School” (center aligned if taught) - Add a subheading <h2>
→ “Student Information” - Write a short paragraph (4–5 lines):
- Use <b> and <i> at least once
- Use <br> for line breaks
- Insert a horizontal line <hr>
Part B: MS Excel (Advanced Level) – 10
Marks
Question 2 (10 Marks)
Open Microsoft Excel and create:
|
Student |
English |
Math |
Science |
|
Ali |
75 |
80 |
70 |
|
Sara |
90 |
95 |
92 |
|
Ahmed |
60 |
65 |
68 |
Tasks:
- Enter data correctly
- Add columns:
- Total → use SUM
- Average → use AVERAGE
- Add a column Result:
- If Average ≥ 70 → “Pass”
- Otherwise → “Fail”
(Use IF formula)
- Find:
- Highest marks → MAX
- Lowest marks → MIN
- Apply formatting:
- Bold headings
- Center alignment
- Add borders to table
Final Step
- Save as: Class8_YourName.xlsx
No comments:
Post a Comment