Cs101 Assignment 2 Solution Spring 2012

CS101 - Introduction to Computing
Assignment No. 03
Semester: Spring 2012
Solution by Hina Bilal 

Total Marks: 15

Due Date: 18-06-2012
www.vuzs.info 

Objective:
To understand the mathematical and logical functions using MS Excel and Control Structures in JavaScript You must Cover the lectures: 22 to 25

CS101 - Assignment 3 - Question No. 1 : [ 5 * 2 = 10 marks]

Suppose following is a work sheet of MS Excel. www.vuzs.info


Apply the appropriate formulas in MS Excel using the same data given in above diagram, to find the result (same as shown in the diagram) of the below mentioned requirements and just write down the formulas in the solution file ( MS word file).

1. Sum of Marks of all subjects
2. Average of all Marks
3. Highest Marks attained
4. Total number of subjects having Grade A
5. Sum of Marks of those subjects having Grade B

Solution :

formulas are given below: according to the criteria:

  1. Sum of Marks of all subjects: =SUM(B6:B15)
  2. Average of all Marks: =AVERAGE(B6:B15)
  3. Highest Marks attained =MAX(B6:B15)
  4. Total number of subjects having Grade A: =COUNTIF(C6:C15,"A")


CS101 - Assignment 3 - Question No. 2 : [ 5 marks]

Write JavaScript code using “For loop” to display all the odd numbers between 1 and 100 (both inclusive). Each number should be displayed on a separate line as follows:

1
3
5
7
9
11
13
.
.
.
.
.
93
95
97
99

Solution :

  • MGT503 SOLVED MCQS FROM LEC 1 TO 22
    by abdulsaboor » Thu Nov 01, 2012 10:36 am
    0
    1633
    by abdulsaboor
    Thu Nov 01, 2012 10:36 am
  • mth 302 formula file by dr abdul-saboor
    by abdulsaboor » Thu Dec 03, 2009 12:43 pm
    2
    2674
    by abdulsaboor
    Tue Jan 10, 2012 12:10 pm
  • Statistics and probability formulas
    by abdulsaboor » Tue Jan 10, 2012 12:08 pm
    0
    1897
    by abdulsaboor
    Tue Jan 10, 2012 12:08 pm
  • RULES OF DEBIT & CREDIT
    by abdulsaboor » Wed Oct 05, 2011 12:37 pm
    0
    1894
    by abdulsaboor
    Wed Oct 05, 2011 12:37 pm
  • MGT201 FM FORMULAS ENJOY
    by abdulsaboor » Sun Nov 28, 2010 2:26 pm
    1
    2319
    by mimi_mit
    Wed Feb 02, 2011 3:47 pm
  • VU Final projects
    by abdulsaboor » Sat Apr 29, 2017 7:20 pm
    0
    861
    by abdulsaboor
    Sat Apr 29, 2017 7:20 pm
  • ISL fall 2014 solved enjoy
    by abdulsaboor » Sun Nov 30, 2014 3:33 pm
    0
    2552
    by abdulsaboor
    Sun Nov 30, 2014 3:33 pm
  • ENG201 SOLVED ASSIGNMNET ENJOY FALL 2014
    by abdulsaboor » Tue Nov 25, 2014 7:44 pm
    0
    1791
    by abdulsaboor
    Tue Nov 25, 2014 7:44 pm
  • SEMESTER FALL 2014 ADVANCED FINANCIAL ACCOUNTING (FIN711)
    by emran » Mon Nov 24, 2014 9:03 pm
    0
    1725
    by emran
    Mon Nov 24, 2014 9:03 pm
  • Eng 101 solved assignments fall 2014 enjoy
    by abdulsaboor » Sun Nov 23, 2014 10:35 am
    0
    1827
    by abdulsaboor
    Sun Nov 23, 2014 10:35 am
  • FIN711 Advance Financial Accounting GDB.. Help Needed
    by mb130400025 » Sat Nov 16, 2013 11:44 pm
    3
    2509
    by abdulsaboor
    Sat Nov 22, 2014 2:44 pm
  • CS201 Solution of 1 assignment solved enjoy fall 2014
    by abdulsaboor » Wed Nov 19, 2014 11:40 am
    0
    1777
    by abdulsaboor
    Wed Nov 19, 2014 11:40 am
  • CS403 FALL 2014 IDEA SOLUTION
    by abdulsaboor » Wed Nov 19, 2014 11:37 am
    0
    1746
    by abdulsaboor
    Wed Nov 19, 2014 11:37 am
  • CS304: Object Oriented Programming Assignment No. 01 Semeste
    by abdulsaboor » Wed Nov 19, 2014 11:23 am
    0
    1850
    by abdulsaboor
    Wed Nov 19, 2014 11:23 am
  • CS101 Assignment No. 01(Graded)21/11/2014
    by abdulsaboor » Wed Nov 19, 2014 11:11 am
    1
    1620
    by abdulsaboor
    Wed Nov 19, 2014 11:12 am
  • Fin722 solved assignment enjoy
    by abdulsaboor » Wed May 14, 2014 5:09 pm
    0
    1506
    by abdulsaboor
    Wed May 14, 2014 5:09 pm
  • Fin 711 solved assignment enjoy
    by abdulsaboor » Wed May 14, 2014 10:20 am
    0
    1612
    by abdulsaboor
    Wed May 14, 2014 10:20 am
  • MKT711 -Marketing Research assignment 1 question 2 solved
    by abdulsaboor » Sun May 11, 2014 5:13 pm
    0
    1392
    by abdulsaboor
    Sun May 11, 2014 5:13 pm
  • International marketing GDB enjoy
    by abdulsaboor » Sun May 11, 2014 3:22 pm
    0
    1202
    by abdulsaboor
    Sun May 11, 2014 3:22 pm
  • MKT711 -Marketing Research assignment 1 question 1 solved
    by abdulsaboor » Sun May 11, 2014 2:47 pm
    0
    1270
    by abdulsaboor
    Sun May 11, 2014 2:47 pm
  • Performance Management Solved GDB ENJOY
    by abdulsaboor » Thu May 08, 2014 11:19 am
    0
    1140
    by abdulsaboor
    Thu May 08, 2014 11:19 am
  • Leadership and Team Management (MGMT723)GDB 01
    by abdulsaboor » Thu May 08, 2014 11:03 am
    0
    1372
    by abdulsaboor
    Thu May 08, 2014 11:03 am
  • MANAGERIAL ECONOMICS (ECO704) ASSIGNMENT NO. 01
    by abdulsaboor » Wed May 07, 2014 11:18 am
    0
    1571
    by abdulsaboor
    Wed May 07, 2014 11:18 am
  • MGT 705 ADVANCED COST & MANAGEMENT Assignment Discussion
    by Muhammad Amin Ahmad » Sun Dec 08, 2013 7:09 pm
    0
    1309
    by Muhammad Amin Ahmad
    Sun Dec 08, 2013 7:09 pm
  • STA301 Assignment No.1 (Non-Graded) Dec 02, 2013 last date
    by abdulsaboor » Sun Dec 01, 2013 10:23 am
    1
    1562
    by abdulsaboor
    Sun Dec 01, 2013 10:29 am
  • ECO 704 assignment # 01 Discussion
    by Muhammad Amin Ahmad » Wed Nov 27, 2013 7:56 pm
    1
    2205
    by mb130400025
    Sat Nov 30, 2013 8:44 pm
  • MGT 705 GDB # 01 Discussion
    by Muhammad Amin Ahmad » Thu Nov 28, 2013 6:12 pm
    0
    1249
    by Muhammad Amin Ahmad
    Thu Nov 28, 2013 6:12 pm
  • Despite of all the revolutionary measures adopted by US corp
    by abdulsaboor » Thu Nov 21, 2013 2:02 pm
    0
    1219
    by abdulsaboor
    Thu Nov 21, 2013 2:02 pm
  • STA 630 solved gdb enjoy 21-11-2013
    by abdulsaboor » Thu Nov 21, 2013 11:26 am
    0
    1275
    by abdulsaboor
    Thu Nov 21, 2013 11:26 am
  • PRODUCTIONS/OERTIONS MANAGEMENT MGT713 solved assighnmnt enj
    by abdulsaboor » Thu Nov 21, 2013 10:17 am
    0
    1451
    by abdulsaboor
    Thu Nov 21, 2013 10:17 am
  • Organizational Development solved GDB
    by abdulsaboor » Thu Nov 21, 2013 10:08 am
    0
    1268
    by abdulsaboor
    Thu Nov 21, 2013 10:08 am
  • ECO 704 1st GDB discussion
    by Muhammad Amin Ahmad » Thu Nov 14, 2013 10:32 am
    3
    2260
    by abdulsaboor
    Sun Nov 17, 2013 10:24 am
  • Fin722 GDB help enjoy
    by abdulsaboor » Tue Nov 12, 2013 11:21 am
    0
    1426
    by abdulsaboor
    Tue Nov 12, 2013 11:21 am
  • ENG201 SOLVED ASSIGHNMNT ENJOY NOV 2013
    by abdulsaboor » Tue Nov 12, 2013 11:08 am
    0
    1263
    by abdulsaboor
    Tue Nov 12, 2013 11:08 am
  • Entrepreneurship (MGT 602) Fall 2013 GDB No.01
    by abdulsaboor » Sat Nov 09, 2013 10:31 am
    0
    1244
    by abdulsaboor
    Sat Nov 09, 2013 10:31 am
  • MGT703 Strategic Management solved GDB enjoy
    by abdulsaboor » Thu Nov 07, 2013 12:38 pm
    0
    1564
    by abdulsaboor
    Thu Nov 07, 2013 12:38 pm
  • Handouts Available For Sale "discounted" (Chakwal Students)
    by Tehmeena Naseer » Fri Jul 12, 2013 3:34 pm
    0
    1748
    by Tehmeena Naseer
    Fri Jul 12, 2013 3:34 pm
  • Acc311 assignment solution required
    by M habib ur rehman » Wed Jul 10, 2013 10:27 am
    0
    1265
    by M habib ur rehman
    Wed Jul 10, 2013 10:27 am
  • eng 101 2nd assignment solution????
    by M habib ur rehman » Tue May 14, 2013 11:44 am
    1
    2108
    by abdulsaboor
    Wed May 15, 2013 5:11 pm
  • CS504 Assignment 2 Solution spring 2013 ( 15 May 2013)
    by abdulsaboor » Tue May 14, 2013 11:16 am
    0
    1641
    by abdulsaboor
    Tue May 14, 2013 11:16 am
  • Eco402 First assignment solution Required
    by Saad Shehzaib » Wed May 08, 2013 9:29 pm
    2
    3181
    by Saad Shehzaib
    Thu May 09, 2013 11:51 am
  • FIN711 SOLVED ASSIGNMENT ENJOY
    by abdulsaboor » Wed May 08, 2013 1:24 pm
    0
    1596
    by abdulsaboor
    Wed May 08, 2013 1:24 pm
  • CS304 SOLVED ENJOY
    by abdulsaboor » Tue May 07, 2013 7:31 pm
    0
    1455
    by abdulsaboor
    Tue May 07, 2013 7:31 pm
  • ECO401 solved assignment enjoy
    by abdulsaboor » Tue May 07, 2013 2:38 pm
    0
    1355
    by abdulsaboor
    Tue May 07, 2013 2:38 pm
  • kindly solve the probblem
    by Mamoona » Thu May 02, 2013 3:52 pm
    0
    1579
    by Mamoona
    Thu May 02, 2013 3:52 pm
  • MGT 501 HRM SOLVED ASSIGHNMENT ENJOY
    by abdulsaboor » Thu May 02, 2013 10:08 am
    0
    1370
    by abdulsaboor
    Thu May 02, 2013 10:08 am
  • CS501 Assignment No. 02 Solution Spring 2013 (06-05-13)
    by abdulsaboor » Thu May 02, 2013 10:00 am
    0
    1496
    by abdulsaboor
    Thu May 02, 2013 10:00 am
  • MGT610 Assignment no.1 Solution Spring 2013 (2-5-2013)
    by abdulsaboor » Thu May 02, 2013 9:54 am
    0
    1489
    by abdulsaboor
    Thu May 02, 2013 9:54 am
  • CS601 Assignment No 01 Solution Spring 2013 (30/4/2013)
    by abdulsaboor » Tue Apr 30, 2013 1:53 pm
    0
    1441
    by abdulsaboor
    Tue Apr 30, 2013 1:53 pm
  • MGT301 Assignment No 01 Solution Spring 2013(02-05-2013)idia
    by abdulsaboor » Mon Apr 29, 2013 5:46 pm
    0
    1579
    by abdulsaboor
    Mon Apr 29, 2013 5:46 pm

Return to Board index

0 Replies to “Cs101 Assignment 2 Solution Spring 2012”

Lascia un Commento

L'indirizzo email non verrà pubblicato. I campi obbligatori sono contrassegnati *