Solution:NIIT/GNIIT Sonugiri0032@gmail.com

Sunday, January 31, 2016

Saturday, January 30, 2016

Wednesday, January 27, 2016

HTML LAB @ HOME 7

 HTML LAB @ HOME 7


1. The home page of the SkyLight University needs to be divided into different sections, as shown in the following figure.    
The following guidelines need to be followed while designing this page: The header section should display the logo and links for the university. When the user clicks a link, the corresponding page should be displayed in the target section. 
===============================================================
===============================================================

2. After designing the Web page for the automobile company, Steve has been assigned the task to enhance the look and feel of the table appearing on the home page. For this, Steve needs to apply styles on the table, as shown in the following figure.  


DOWNLOAD LINK:



Share:

HTML LAB @ HOME6

 HTML LAB @ HOME 6

The SkyLight University has launched some new courses. It wants that the details of these courses, such as the course title, duration, fees, eligibility criteria, total seats available, and colleges offering the courses, should be listed for the students on its website. To enhance readability, the entire data needs to be arranged in a tabular format. In addition, there should be a link that allows students to enroll for the courses. For this, the following tasks need to be performed: Create a Web page named Courses, and a link to this page should be visible along with other links. Design a table with the caption, Course Details, and the columns with the headings, Course Title, Course Duration, Eligibility Criteria, Total Seats Available, Fees, College, and Enroll Yourself, in the Courses page. The Courses page should appear, as shown in the following figure.   
How will you create the Courses page?


DOWNLOAD LINK:

Share:

HTML LAB @ HOME 5

HTML LAB @ HOME 5


After creating the table on the Courses page of the ShowOnWheels website, you need to apply styles as per the following guidelines: The table should have a solid blue border of 2px thickness. The background color for the table header should be navy blue. The table after applying styles should appear, as shown in the following figure.     


DOWNLOAD LINK:


Share:

HTML LAB @ HOME 4

HTML LAB @ HOME 4


1. The home page of the FoodHub website has been created. However, the management finds that the look and feel of the Web page is not appealing to the users. Therefore, the organization has decided to apply style sheets to the Web pages. Now, you have been assigned the task to apply style sheets, as per the following guidelines: The logo should appear at the top of the page. The images should be displayed at the bottom of the page. They should appear as navigation links on the website. A background image needs to be applied horizontally along with the background color, #aacf43. The list of cuisines should appear in the font size, 15, with the font style, Script MT Bold. The heading 'Come with your family or friends to cater brilliant tastes' should appear in the font size, 20, with the font style, Script MT Bold. The text should appear in green color on the home page. The home page should appear, as shown in the following figure.    

========================================================
2. After applying styles on the home page of the FoodHub website, you need to perform the following transformations on the Web page: The links should appear in such a way that they get scaled whenever the user moves the mouse pointer on them. The paragraphs should appear in such a way that they get bold whenever the user moves the mouse pointer to them. The home page should appear, as shown in the following figure.  

   
DOWNLOAD LINK:


Share:

HTML LAB @ HOME 3

HTML LAB @ HOME 3


The home page of the website of the SkyLight University has been created. However, the management does not find the website attractive. Therefore, the development team is informed about the requirement of enhancing the look and feel of the Web page. You have been assigned the task of creating a style sheet that needs to be applied on the Web pages. For this, you have decided to create the following styles in the style sheet: The logo should appear at the top of the Web page. The links should be displayed at the top-right corner of the home page. The text should appear in blue color with the font size, 15 on the home page. A background image needs to be applied on the home page. The list of colleges should appear in the font size, 15, with the font style, Script MT Bold. The heading 'Our College Campus' should appear in the font size, 20, with the font style, Script MT Bold. The home page should appear, as shown in the following figure.    


DOWNLOAD LINK:

Share:

HTML LAB @ HOME 2

HTML LAB @ HOME 2


Foodhub is an emerging name in the food business. As part of customer satisfaction initiative, the management wants to provide various services to its customers at their doorstep. For this, it wants a website to be constructed. The customers should be able to view the menu and order food through the website. You have been assigned the task to create the home page of the website based on the following guidelines: It should display the logo of the organization. It should provide images of the following options:  Call Us At  About Us  Best Deal  Recipes  Menu  What's New  Home              The preceding images should be made as hyperlinks. When a user clicks these links, the corresponding pages should be opened. It should display information about Foodhub. It should display a list of cuisines offered by Foodhub to its customers.  The home page should appear, as shown in the following figure.  
  
How will you create the desired home page?

DOWNLOAD LINK


Share:

HTML LAB @ HOME 1

HTML LAB @ HOME 1

You are working as a Web page designer with WebDesigners Ltd. You have been assigned the task to create the home page for the SkyLight University website. The home page should be based on the following guidelines: It should display the logo of the university. It should display some text that provides information about the SkyLight University.  It should provide link to other pages, such as About Us, Contact Us, and Careers. It should display the images of the colleges affiliated to the SkyLight University. It should display a list of colleges affiliated to the university. The list should expand when the user clicks the Colleges affiliated text.  The home page should appear, as shown in the following figure.  
How will you create the desired home page?

DOWNLOAD LINK:


Share:

ADVANCED EXCEL LAB @ HOME 6

ADVANCED EXCEL LAB @ HOME 6



1.
Consider a scenario of Ideas Bookstore, which is a popular book store in Mississippi.
The sales details of the previous month are recorded in a Microsoft Excel worksheet. As
it was the fifth anniversary month of the store, Kathy, the Store Owner, decides to give a
discount voucher to all the customers who purchased books in the anniversary month on
their next purchase. Each customer will be given a discount voucher of 15% of their bill,
if they have purchased books worth $ 1800 or above in the previous month, otherwise, a
voucher of 5% of their bill. You are required to help Kathy to decide the amount of discount
voucher that should be given to the customers.


DOWNLOAD LINK:


==================================================================
==================================================================


2.

To expand the business, the managementof Alpha Supermart decides to open a new branch.
Before opening the branch, themanagement wants to create business plans to decide the
location where the newbranch should be opened. To create the strategic plans and to make
theimportant business decisions, the management needs to compare the month wiserevenues
of the last two years. Therefore, the management asks Alvin, the SalesExecutive, to create a
report that graphically depicts the sales data of thelast two years. To accomplish this task,
Alvin decides to insert a chart in thereport. Alvin wants to make this report understandable
by adding the following
features to the chart:
The chart title at the center, atthe top of the report
The title for the horizontaland vertical axes
The data table beneath thechart
The data labels at the top ofeach bar in the chart
Help Alvin accomplish the desiredtasks.


DOWNLOAD LINK:


==================================================================
==================================================================



3.
Harry asks Alvin tocreate a report containing the product wise revenue distribution of the
totalrevenue generated in 2011. To accomplish this task, Alvin creates a textualreport and
submits the same to Harry. When Harry analyzes this report, he failsto understand the
individual contribution of each product in the total revenue.Therefore, he asks Alvin to generate
a meaningful graphical report. Help Alvinaccomplish the desired task.




DOWNLOAD LINK:


==================================================================
==================================================================


4.
Alvin sends the report containing themonth wise revenue details of the last two years to Peter,
the Senior SalesManager. After reviewing this report, Peter asks Alvin to create a report thatonly
contains the chart and its components. In addition, he asks Alvin that thereport should not
contain the details of the data sets. Further, he asks Alvinto use the similar formatting style and
layout in all the graphical reports infuture. Help Alvin accomplish the desired tasks.




DOWNLOAD LINK:


==================================================================
==================================================================

5.
At the beginning of 2011, Harry has asked Alvin to create a report on the sales of 2010
depicting:
The total sales made against each client.
The total sales made against all the clients.
The percentage of the total sales generated from each client.
The total number of transactions made against each client.
The total number of transactions made against all the clients.
Therefore, Alvin has created the following sales report.





Similarly, at the beginning of 2012, Harry has asked Alvin to create the similar report for the
sales of 2011. Help Alvin create this report.



DOWNLOAD LINK:


==================================================================
==================================================================

6.
Consider the scenario of Paul Furnishers Inc. While generating the sales report for the last
week at the end of each month, Alvin needs to insert a chart in the report to illustrate the
comparison among the total sales of all the weeks in the month. To avoid repetition of steps
performed to insert a chart in the last weekly sales report created each month, Alvin decides
to automate the task of inserting the chart in the worksheet. Help Alvin in accomplishing the
required task.


DOWNLOAD LINK:


==================================================================
==================================================================
Share:
GNIITSOLUTION GNIIT SOLUTION. Powered by Blogger.

Translate

Blog Archive

Unordered List