View more the latest threads:

• ISL201 Islamic Studies Assignment No.1 Solution Spring...
• ENG001 Elementary English Assignment No. 2 Solution Spring...
• ENG201 Assignment No.2 Solution Spring Semester 2013
• CS201 Introduction to Programming Assignment No.2 Solution...
• ENG301 Business Communication Assignment No.2 Solution...
• CS101 Introduction to Computing Assignment No.2 Solution...
• ECO402 Microeconomics Assignment No.2 Solution Spring...
• MTH202 Discrete Mathematics Assignment No.2 Solution Spring...
• E-Commerce (IT 430) Semester Spring 2013
• CS001 Computer Proficiency Assignment No.1 Solution Spring...

CS101 Introduction to Computing Assignment No.03 Spring 2012 Due Date 18-6-2012

Assignment No. 03
Semester: Spring 2012
Introduction to Computing-CS101
Total Marks: 15

Due Date: 18-06-2012

Objective: To understand the mathematical and logical functions using MS Excel and Control Structures in JavaScript

Lectures Covered: 22 to 25
Instructions:
Please read the following instructions carefully before solving & submitting assignment:

o Assignment should be done by your own efforts not copied from net, handouts or books.
o You should submit your MS Word File via assignment interface at VULMS.
o Assignment sent via Email will not be replied and accepted/graded in any case.
o The assignment submitted after due date will not be accepted/graded.
o If the submitted assignment does not open or file is corrupt then it will not be accepted/graded.
o If the Student ID is not mentioned in the assignment file then the assignment will not be accepted/graded.

For any query about the assignment, contact at

GOOD LUCK


Question No. 1 : [ 5 * 2 = 10 marks]

Suppose following is a work sheet of MS Excel.



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




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