University of the Punjab
BA/BSc. Part I Computer Science Practical
Group 1 – 2018 Solution
Download Original Papers From:
https://educationhub.pk/pu-ba-bsc-practical-papers-third-year/
Question No 01:
MS Excel
Procedure:
1. I clicked on Start Button and point to the All Programs. All installed programs list appeared.
2. I pointed to the MS Office Folder and click on MS Excel. MS Excel Program opened.
3. I click on Office Button and take new Sheet.
4. I pressed Ctrl + S to save the sheet and give the file name “Result”.
5. Entered data into sheet as given in the question.
6. I clicked on home tab and home ribbon appeared.
7. I selected the data cells and point to the Sort & Filter icon in Editing group.
8. In options list I clicked on sort Z to A to sort data in descending order.
9. I wrote a formula to display status as Pass or Fail.
Formula: = IF(B2>=50,”Pass”,”Fail”)
10. I wrote a formula to count no of Pass Students
Formula: =COUNTIF(C2:C6,”Pass”)
11. I wrote a formula to count no of Fail Students3.
Formula: =COUNTIF(C2:C6,”Fail”)
12. I Press Ctrl +S To save file
Question No 02:
Program:
Private Sub Command1_click()
Dim no As Integer
no = InputBox(“Enter a Number from 1 to 4”)
If no = 1 Then
Print “Winter”
Elseif no = 2 Then
Print “Spring”
Elseif no = 1 Then
Print “Summer”
Elseif no = 1 Then
Print “Autumn”
Else
Print “Invalid Number”
End If
End Sub
Please Visit: www.risingeducation.com for more educational stuff.
ENGL3127 Psycho-Linguistics BS English Education University Past Papers
Past Papers ENGL3127 Psycho-Linguistics BS English Past Papers Psycho-Linguistics is
ENGL3126 Semantics and Pragmatics BS English Education University Past Papers
Past Papers ENGL3126 Semantics and Pragmatics BS English Past Papers
ENGL3125 Literary Theory BS English Education University Past Papers
Past Papers ENGL3125 Literary Theory BS English Past Papers Literary
ENGL3124 Comedy and Manners BS English Education University Past Papers
Past Papers ENGL3124 Comedy and Manners BS English Past Papers
ENGL3123 English Poetry 18th-19th Century BS English Education University Past Papers
Past Papers ENGL3123 English Poetry 18th-19th Century BS English Past
ENGL4111 Twentieth Century English Novel BS English Education University Past Papers
Past Papers ENGL4111 Twentieth Century English Novel BS English Past
ENGL3122 Socio-Linguistics BS English Education University Past Papers
Past Papers ENGL1112 Introduction to Poetry and Drama BS English
ENGL3120 Literary Criticism BS English Education University Past Papers
Past Papers ENGL3120 Literary Criticism BS English Past Papers Literary
ENGL1117 Introduction and Fiction and Non-Fiction Prose BS English Education University Past Papers
Past Papers ENGL1117 Introduction and Fiction and Non-Fiction Prose BS
ENGL3113 Greek and Elizabethan Drama BS English Education University Past Papers
Past Papers ENGL3113 Greek and Elizabethan Drama BS English Past
ENGL3112 English Poetry 14th-17th Century BS English Education University Past Papers
Past Papers ENGL3112 English Poetry 14th-17th Century BS English Past
ENGL2118 History of English Literature(Romantic Age) BS English Education University Past Papers
Past Papers ENGL2118 History of English Literature(Romantic Age) BS English
ENGL2119 Morphology and Syntax BS English Education University Past Papers
Past Papers ENGL2119 Morphology and Syntax BS English Past Papers
EDUC2118 Curriculum Design and Instruction BS English Education University Past Papers
Past Papers EDUC2118 Curriculum Design and Instruction BS English Past
ENGL2117 Language Culture and Identity BS English Education University Past Papers
Past Papers ENGL2117 Language Culture and Identity BS English Past
ENGL1119 Communication Skills BS English Education University Past Papers
Past Papers ENGL1119 Communication Skills BS English Past Papers Communication