dos commands

Q .1 Write the syntaxes and example of following DOS Commands:-
a) Date

b) Time

c) Ver.

d) Clear Screen

e) Tree

Q.2 Write the syntaxes and examples of the following DOS Commands
a) Make a Directory
The syntax of a “Make a Directory” is:-mkdir

b) Change a Directory
The syntax of a “Change a Directory” is:-cd

c) Creating a file and saving it
The syntax of a “Create a File” is:-copy con

d) Listing of directories and files
The syntax of a “Listing of directories and file” is:-dir

e) List the files which start with A and have the extension of .CPP.
The syntax of a “List the files which start with A and have the extension of .CPP” is:- dir Q.3 Create a web page on “My Self” which includes the following tags:
a) Font
b) Marquee
c) Paragraph
d) Table
e) Image
f) Background
g) Ordered and unordered list

Solution:

Q.4 Create your own web page on “EMERGING TECHNOLOGIES” making the maximum use of tags.

Q.5 Accept the marks of 5 students in 5 different subjects in MS-EXCEL. Calculate the average and total.(Using Functions)
Total

Q.6 Prepare a chart in MS- EXCEL on the recorded date of last 10 days of stock analysis/temperature.

Q.7 Create a table employee with the following attributes:- Name-Character, Designation-Character, Department-Character, Age-Integer, Salary-Integer, DOJ-Date
Perform the following queries on the above table.

a) Insert the records of 10 employees
Insert into employee1 values(‘Ram’,’Sr. Manager’,’Marketing’,38,55000,’11/2/2005’);
Insert into employee1 values(‘Sham’,’Manager’,’Marketing’,33,50000,’5/10/2006’);
Insert into employee1 values(‘Rishabh’,’Analyst’,’Finance’,30,26000,’6/1/2013’);
Insert into employee1 values(‘Shivanshu’,’Sr.Analyst’,’Finance’,34,30000,’8/6/2000’);
Insert into employee1 values(‘Sourabh’,’Manager’,’Marketing’,36,32000,’2/5/1999’);
Insert into employee1