Introduction To Computing Lab#1
Introduction To Computing Lab#1
Introduction To Computing Lab#1
Course (Lab):
–Introduction to Computing
Instructor:
Engr. Qazi Salman Khalid
• Course Contents
• CLO’s
• Riddles
• Practice of Excel
HEC Curriculum Guidelines 2017
• Introduction to Computing 3(2, 1)
• Objective:
• To give working knowledge & skills of coding ( MATLAB/ Python etc.),
how to avoid common coding pitfalls, to use and create own functions and
classes. The course will enable students to recognize the advantages of
using pointers and references & to understand the fundamental ideas of
object oriented programming(OOP).
Course Contents
PLOs
Course Learning Assessment Activities & Weight Taxonomy Addressed by
CLO No.
Outcomes (CLOs) Percentage Domain Course (PLO
No.)
Scope
rapid development + large systems
Objects
Integration
hybrid systems
Three kids
Jack: Hey, how are you, man?
Bill: Not bad, got married and I have three kids now.
Jack: That's awesome. How old are they?
Bill: The product of their ages is 72 and the sum of their ages
is the same as your birth date.
Jack: Cool..But I still don't know.
Bill: My eldest kid just started taking piano lessons.
Jack: Oh, now I get it but still in doubt.
• 3,3,8
Lets break it down. The product of their ages is 72. So what
are the possible choices?
2, 2, 18 sum(2, 2, 18) = 22
2, 4, 9 sum(2, 4, 9) = 15
2, 6, 6 sum(2, 6, 6) = 14
2, 3, 12 sum(2, 3, 12) = 17
3, 4, 6 sum(3, 4, 6) = 13
3, 3, 8 sum(3, 3, 8 ) = 14
1, 8, 9 sum(1,8,9) = 18
1, 3, 24 sum(1, 3, 24) = 28
1, 4, 18 sum(1, 4, 18) = 23
1, 2, 36 sum(1, 2, 36) = 39
1, 6, 12 sum(1, 6, 12) = 19
• The sum of their ages is the same as your birth date. That could
be anything from 1 to 31 but the fact that Jack was unable to find
out the ages, it means there are two or more combinations with
the same sum. From the choices above, only two of them are
possible now.
2, 6, 6 sum(2, 6, 6) = 14
3, 3, 8 sum(3, 3, 8 ) = 14
Hint:
Count the letters and try splitting the letters up into
homogeneous groups.
• 'Great Job You Got It'
This type of code is known as a Caesar Box (Julius Caesar
was the first to write codes this way.) To decipher the
message, simply divide the code into four groups of four (you
can also divide them into groups such as 5 groups of 5 or 6
groups of 6 depending on the number of letters in the phrase),
and rearrange them vertically like this...
GTYO
RJOT
EOUI
ABGT
Then you read vertically column by column.
Math's Puzzle
• 888 + 88 + 8 + 8 + 8 = 1000
Problem on Excel # 1
• Students before entering the gymnasium pass Math, English and Russian.
Passing Score is 12. You should get at least 4 points in Mathematics for
admission. Create report on the receipt. It is necessary to compare the total
number of points with a passing grade. And check that math score was not
lower than "4". In the «result» column put "accepted" or "not accepted"
Problem on Excel # 2
• If the product is stored for more than 8 months, the price is reduced 2
times. If it’s more than 5 months, but less than 8, it’s 1.5 times.
• If the value of the goods in the warehouse after the write-down was less
than 300 or the product is stored for longer than 10 months, it is written
off.
• Analyze the cost of cash balances after the devaluation. If the price of the
product after reassessment is below average values, we should write off
the product from the warehouse.
Problem on Excel # 3
• Many retailers and most wholesalers provide customers a price break
based on quantity. For example, a wholesaler may sell 1 to 10 T-shirts for
$10.50 each, and 11 to 25 T-shirts for $8.75 each. Use the following IF
statement formula to determine how much money you can save by
purchasing wholesale products for your company in bulk.
Determine the total invoice amount keeping in view the discounts. Also find
out the average cost of shopping carried out. Moreover, identify the
minimum and maximum cost of the items purchased. If possible, relate it to
the items.