Lab record ifs(Section) 2 Semester ( 1) Introduction to ict skills

First Name	Last Name	Mark
Subject
IT	Management
Jones	Kivell	75
Central	Jones	45		X
West	Andrews	77	X
East	Jones	89	X	X
Smith	Kivell	86	X	X
Gill	Morgan	64		X
Parent	Howard	78	X	X

1. 
   Replicate the following table above and explain how to add tables and merge cells in table.
   
2. 
   Explain step by step how to create a smart art and create a smart art as shown below.
   

PRACTICAL 4.

Replicate the following. Create a sample CV document.

PRACTICAL 5. Insert simple image in your word file and apply the following image formatting.

Lab Practical Tasks №6 for MS PowerPoint

Please explain each step to perform the following tasks and provide screenshots where necessary in your lab file. Submit the cover page from above and attach your lab file along with it. No need to submit the questions in your lab file.

PRACTICAL 1.

1. 
   Create an Excel file and recreate the following image below. Please use formulas such as MAX, MIN and AVERAGE in order to calculate max, min and average marks of students.
   

2. 
   Sort the student marks using Sort & Filter command in Editing group of Home tab.
   

After doing this task you should have marks in ascending order.

3. 
   Using the same data insert bar chart
   

PRACTICAL 2.

Imagine that you are managing a small company and employees working in it. There are 10 people working. You want to analyze and monitor the salary of each worker. For this purpose, you have decided to use MS Excel worksheet.

1. 
   Open empty MS Excel Worksheet and create a list of 10 employees. (column A)
   
2. 
   Create the column B you identify employee salary for each worker.
   
3. 
   Create the column C where you insert the number of hours employee worked this week. The range should be between 20 to 80. Also, use conditional formatting to highlight cell with different color if hours worked exceed 40.
   
4. 
   Create the column D where using formula, you need to find the number of extra hours worked by employee. Example: if an employee worked for 76 hours then, anything above 40 hours will be considered as extra hours. In this case, 36 are extra hours. Using IF formula provide extra hours in column D, if no extra hours indicate as 0.
   
5. 
   In column E, calculate how much an employee should receive the salary with condition that any extra hour/hours worked employees should receive 1.5 more of the set salaries from column B. Example: if someone worked for 48 hours and has the salary of $18 per hour, then that person should receive 40 hours *$18 + 8 hours *$18*1.5. If person worked for less than 40 hours, then the standard salary (from column B) rate should be awarded.
   

PRACTICAL 3.

Imagine you are getting loans from a bank. Bank is charging its interest rates and indicating the number of month by which you should return the loan amount and bank’s interest rate. Your task is to create a worksheet in MS Excel to calculate how much money you should give to bank each month from your monthly budget.

1. 
   Open empty MS Excel Worksheet and create a list of 5 types of loans that can be obtained from financial banks (column A).
   
2. 
   In column B type the loan amount.
   
3. 
   In column C type the bank’s interest rates in %.
   
4. 
   In column D type the number of months by which you should return the loan amount and interest rate to your bank.
   
5. 
   In column E, using formulas calculate the total amount of loan and interest rate to be returned to bank
   
6. 
   In column F, using formulas calculate the amount of money you should return monthly to the bank including loan amount and bank’s interest rate.
   
7. 
   Lastly insert bar graph. The bar graph should illustrate the type of loan and the amount of money to be returned monthly to the bank in order to close the loan by certain time.
   
8. 
   (Column A and F).
   

Lab Practical Tasks №6 for MS PowerPoint

Create a PowerPoint presentation on one of the following topics:

• Interesting historical facts

• Learning center

• Museums of Uzbekistan

• Theatres of Uzbekistan

• Cultural heritage of Uzbekistan

• Shopping centers in Tashkent

• National cuisine

• Catalogue of movies released in 2021

• Sport

• Health care

• Animals

• Fashion

• Dancing styles

• Personal Development

• Board games

• Video Games

• Cinema

1. 
   There should be at least 15 slides.
   
2. 
   First slide should be as cover page containing the topic of the presentation and enrollment number of a student.
   
3. 
   Second slide should contain agenda of the presentation outlining the points to be covered in the presentation.
   
4. 
   It is preferred that format of all slides should be consistent with one another.
   
5. 
   Print out the PPT and submit it with cover page.
   
6. 
   Cover page is the page number 1 of this current document
   

Lab Practical Tasks № 7 for Creating Facebook Pages and account

Steps to create a Facebook profile and YouTube channel

You can open Facebook web page or download application from play store for creating the account.

Lab Practical Tasks № 8 for Creating basic HTML Pages

Using HTML, complete the following tasks. Write HTML code to recreate the images below.

Refer to text formatting tags in html.

Practical 1

Create the following table in HTML

1 ©
Привет Hello Salom		Add the URL and you're done! URL stands for Uniform Resource Locator. That's a big fancy phrase that the computer people came up with.
www.google.ru

Print out the source code (HTML code) along with result output (browser) and submit it with cover page.

Cover page is the page number 1 of this current document. Do not forget to fill your data in cover page.

Lab Practical Tasks № 9 for Linking web documents, inserting images: