of systems which developed using INCREMENTAL MODEL
Write FORMULAS ( NOT ANSWERS) FOR THE OPERATIONS ( for a-e) on spread sheet given below along with the relevant cell address
A B C D E F G H
1 sr.no name gender Science math COMPUTER TOTAL Average
2 1 MAX M 34 75 39 ? ?
3 2 Swati F 47 29 33 ? ?
4 3 shruti F 83 51 42 ? ?
5 4 Ram M 63 94 68 ? ?
6 5 Neetu M 51 90 45 ? ?
7 Max ?
8 Total ?
9 Average marks of males M ?
10 Average marks of females F ?
a) To calculate the total marks as sum of science, Maths and computers for each student and display them in column G
b) to calculate the average marks for each student and display them in column H
c) to calculate the highest marks in Computers and display it in cell F7.
d) to calculate the total number of students appearing in science and display it in cell D8
e) to calculate the average marks for male students in cell H9 and for female students in cell cell H10.
Consider the set of 4 processes whose arrival time and burst time are given below:
PROCESS
ARRIVAL TIME
BURST TIME
P1
0ms
2ms
P2
9ms
3ms
P3
1ms
5ms
P4
9ms
6ms
Calculate the average waiting time and average turnaround time, if FCFS Scheduling Algorithm is followed.
Describe the basic elements of an instruction cycle and the role of interrupts
There is a need to design a software for online learning. So that the participants can interact entirely online, teachers can deliver course materials in the online format, teachers can communicate and interact with students with online tools, students can also interact, communicate, and collaborate online and teachers can assess student work online as well.
What is the purpose of data storage management?
Select one:
a. Transforms entered data to conform to required data structures.
b. Creates and manage complex structures required for data storage.
c. Creates a security system that enforces user security and data privacy.
d. Stores definitions of the data elements and their relationships (metadata) in a data dictionary which also automatically records structural changes.
The type of computing based on pay per used model is known as?
Select one:
a. Utility computing
b. Super computing
c. Mini computing
d. Mini computing
Which of the following offer applications that are cost-effective and does not require any maintenance on the end-user side?
Select one:
a. PaaS
b. SaaS
c. IaaS
d. HaaS
When discussing on-premise, which of these is a wrong statement?
Select one:
a. An on-Premise IT resource does not need a network
b. An on-premise IT resource can access and interact with a cloud-based IT resource.
c. An on-premise IT resource can be moved to a cloud, thereby changing it to a cloud-based IT resource.
d. Redundant deployments of an IT resource can exist in both on-premise and cloud-based environments.