MENTORTCA TECHNOLOGY PVT. LTD.
SHANTI NIKETAN PUBLIC SCHOOL
(Senior Secondary)
Tek Chand Nagar, Dhanwapur Link Road, Gurgaon – 122006
Contact No. - +91-124-6516777, 9811403438
E-mail:- snpsgurgaon104@[Link]
Website: - [Link]
Affiliated to C.B.S.E.
School Holiday – 15 October 2015
Class – Nursery to III Only
Dear Parents,
As you are all aware our Nursery to III class students are
moving on a school trip to Aerospace Dwarka (Delhi) on
15 October 2015. The school declares holiday for the
remaining student of class Nursery to III on 15 October
2015.
Principal
TCA:TRAINING & DEVELOPMENT - 9911459630 1
MENTORTCA TECHNOLOGY PVT. LTD.
OUR FACULTIES
Prince Garg
Amarjeet Singh
Rahul Kumar
Sandeep Rana
Vijay Singh
Ravi Pandey
Gunjan Singh
Upasana Garg
Hema Pawar
Harpal Singh
Sandeep Bindal
Sarita Pathak
Amit Kumar
TCA:TRAINING & DEVELOPMENT - 9911459630 2
MENTORTCA TECHNOLOGY PVT. LTD.
TCA: TRAINING & DEVELOPMENT
Why we are different from others
Job Oriented Courses
One Computer – One Student
Self-Made Books are provided
An ISO (9001-2015) Certified
Govt. of India Recognized Institute
MCA Qualified Faculty
Our Courses
1. MS-Office
2. Advanced Excel
3. VBA Macro
4. DCA/ADCA
5. Tally
6. Web Designing
7. C, C++ & Java
8. Typing & Stenography
9. Spoken English etc.
TCA:TRAINING & DEVELOPMENT - 9911459630 3
MENTORTCA TECHNOLOGY PVT. LTD.
OUR COUNTRY
INDIA STATES
Haryana
Punjab
Rajasthan
Jammu & Kashmir
INDIAN LANGUAGES
1. Marathi
2. Punjabi
3. Gujrati
4. Tamil
5. Hindi
6. Haryanvi
OUR DISTRICT
1. India
a. Haryana
i. Gurugram
TCA:TRAINING & DEVELOPMENT - 9911459630 4
MENTORTCA TECHNOLOGY PVT. LTD.
MS-Word
Assignments
TCA:TRAINING & DEVELOPMENT - 9911459630 5
MENTORTCA TECHNOLOGY PVT. LTD.
THE COMPUTER ACADEMY - 8587039714
Time Table: Class IX – D
Class Teacher: Mrs. S. Prashar
1 2 3 4 5 6 7 8
Mon Hindi Maths Eng. B [Link] Science SUPW
Tue Science [Link]. Eng. R Maths Hindi [Link]
Wed [Link]. Maths Science Eng. E Sc.(Pr.) Hindi Games
Thu FIT Maths Eng. A Hindi Science [Link]. Games
Fri Maths Science Eng. [Link]. Hindi Maths(lab) CTP
K
House
Sat Meditation CTP Activity Bal Sabah
Meeting
10- Columns
8 – Rows
TCA:TRAINING & DEVELOPMENT - 9911459630 6
MENTORTCA TECHNOLOGY PVT. LTD.
ENQUIRY FORM TCA: TRAINING & DEVELOPMENT
BASIC DETAILS
Enquiry No _________ Date ____________________
Student Name………………………………………………………………….. Male Female
Qualification ………………………………………………………………… Sem Year
Stream…………………………………………..College/Univ…………………………………………………………………..
CONTACT DETAILS
Address………………………………………………………..E-mail………………………………………………………………..
Contact No………………………………………………………Alternate No..…………………………………………………
Timing Morning………………….. Afternoon…………………. Evening………………………….
Experience: Company Name……………………………………………..Profile…………………………………………..
Reference any friend or known (Name)…………………………………………Mob…………………………………..
How did you come to know about TCA?
Banner Reference Pamphlet Internet Other
COURSE DETAILS
Which Course are you looking for?
MS-OFFICE JAVA STAAD PRO
ADVANCED EXCEL ANDROID ANSYS
VBA MACRO JAVA FRAMEWORKS HAVC
TALLY .NET SAP
DCA/ADCA WEB DESIGNING SAS
STENOGRAPHY PHP DTP
TYPING AUTOCAD Any Other Give Name
SPOKEN ENGLISH CATIA …………………………………….
C, C++ REVIT
TCA:TRAINING & DEVELOPMENT - 9911459630 7
MENTORTCA TECHNOLOGY PVT. LTD.
SPECIAL
BIRTHDAY
PARTY
Special for Kitty
Parties
GOOD
ARRANGEMENT
TCA:TRAINING & DEVELOPMENT - 9911459630 8
MENTORTCA TECHNOLOGY PVT. LTD.
MS-Excel
Assignments
TCA:TRAINING & DEVELOPMENT - 9911459630 9
MENTORTCA TECHNOLOGY PVT. LTD.
TCA:TRAINING & DEVELOPMENT - 9911459630 10
MENTORTCA TECHNOLOGY PVT. LTD.
Assignment-1
Indian Meterogical Department
Rainfall Analysis for the Year 1998-2001
[All Values in cms]
Sr. No State 1998 1999 2000 2001
1 Assam 325 520 231 411
2 Gujrat 203 221 300 263
3 Karnataka 301 256 211 154
4 Maharashtra 257 268 324 342
5 Goa 389 265 397 265
6 Kerala 398 423 295 389
Find Total Rainfall of Gujrat
If Total Rainfall of Gujrat >1000 Then "Good" otherwise "Bad"
Find Max Rainfall in 1999
Find Min Rainfall in Goa
Find Average Rainfall of Year 2000
Count of all the values above 350 in the period 1999-2000
Instructions:
1. Create a Column chart total rainfall of all state
2. Add a title Rainfall Analysis to the chart.
3. Type the title for the Category (X) axis to State and Value(Y) axis to
Rainfall in cms.
TCA:TRAINING & DEVELOPMENT - 9911459630 11
MENTORTCA TECHNOLOGY PVT. LTD.
Assignment-2
Rhythm House
WEEKLY REPORT SHEET
CASSETTE CD TOTAL
NAME AMOUNT
Quantity Rate Amount Quantity Rate Amount
Arijit Singh 8 35 10 290
Sunidhi
Chahuan
15 40 9 360
Mika Singh 10 45 6 325
Armaan Malik 21 38 3 310
Ankit Tiwari 6 40 7 250
Total Sales
Status
Instructions:
1. Create the Worksheet as given above.
2. Calculate the Amount for Cassette and CD.
3. Calculate the Total Amount.
4. Calculate the Total sales for the week.
5. Find out the Status using the IF condition.
Condition: If the Total Sales >=10000 then Status is Good else Status is Bad.
6. Create a 3-D Pie Chart by selecting Name and Total Amount.
7. Add a title Weekly Sales Report to the chart.
TCA:TRAINING & DEVELOPMENT - 9911459630 12
MENTORTCA TECHNOLOGY PVT. LTD.
Assignment-3
Synergy Computer Supplies Ltd.
Invoice #: 23134 Sales Rep: R0155
Date: 26-01-2001 Rep Name: Mehul
Customer: General Electric 1/54 Phone: 617-555-9876
Avenue Road Fax: 617-555-1234
Banglore E-mail: purcjasingh@[Link]
Category Description Quantity Price Total
Hardware: 19- inch monitor 1 554
Software: Windows 2000 5 89.99
Software: office 2000 5 179.95
Total Invoice Amount:
For office use only - Do not print
Commission payble to sales rep:
Instructions:
1. Create the worksheet as given above.
2. Total is to be calculated as the Product of Quantity and Prices.
3. Total Invoice Amount is the Sum of the Totals.
4. Commission payble to sales rep is to be calculated as 12% of the Total Invoice Amount.
TCA:TRAINING & DEVELOPMENT - 9911459630 13
MENTORTCA TECHNOLOGY PVT. LTD.
Assignment-4
SALARY SHEET OF THE MONTH OF JAN - 2017
Basic Net
Code Dept Grade HRA DA PF
Salary Salary
A001 Sales A 1200
A002 Computer B 1300
B003 Accounting C 3500
C004 Markting A 2400
C002 Publication C 3500
C006 Computer B 4950
D008 Accounting A 2580
D009 Salaes B 6000
Instructions:
1. Create the Worksheet as given above.
2. HRA is to be calculated as 12% of Basic Salary.
3. DA is 15.5% of Basic Salary.
4. PF is 3.2% of Basic Salary.
5. Net Salary is addition of Basic Salary, DA, HRA and deduction of PF.
6. Round the values in the Net Salary column.
TCA:TRAINING & DEVELOPMENT - 9911459630 14
MENTORTCA TECHNOLOGY PVT. LTD.
Assignment-5
Sun Valley Frozen Foods
Daily Production Week Ending: 30-01-2002
Corn Peas Beans Other Total
Monday 4,500 1,580 2,600 3,300
Tuesday 4,750 1,725 2,350 3,150
Wednesday 3,800 1,565 2,975 2,590
Thursday 2,600 1,520 2,845 2,810
Friday 3,375 1,635 2,100 3,050
Total
Last Week's Results 17,145 7,236 10,630 12,500 50,115
Percentage Change
Instructions:
1. Create the Worksheet as given above.
2. Calculate the Total for each of the products as well the Total for each day.
3. Calculate the Grand Total.
4. Last Week's Results are provided.
5. Calculate the Percentage Change in Last week's sales and the Current
week's slaes for each product. Display the result in Percentage format.
TCA:TRAINING & DEVELOPMENT - 9911459630 15
MENTORTCA TECHNOLOGY PVT. LTD.
Assignment-6
TCA PVT. LTD.
Cash Book | Petty Cash
Cashier Work
Sr.
Date Particular Receipt Payment Balance
No
1 02-Apr-17 Cash Received 70000 70000
2 02-Apr-17 Paid Electricity Bill 4500 65500
3 04-Apr-17 Paid Telephone Bill 3500 62000
4 06-Apr-17 Wages paid to Prince 7000 55000
Cheque Received from
5 08-Apr-17 25000 80000
Ram
6 10-Apr-17 Purchased Computer 40000 40000
7 12-Apr-17 Paid to Raman 4900 35100
8 14-Apr-17 Received from Raju 5000 40100
9 16-Apr-17
Total 100000 59900 40100
TCA:TRAINING & DEVELOPMENT - 9911459630 16
MENTORTCA TECHNOLOGY PVT. LTD.
Assignment-7
Sorting, Filter & Subtotal
Sr. No Name Department Grade Basic Salary
1 Gunjan Marketing A 2500
2 Viraj Accounts B 3400
3 Joshi Sales A 1300
4 Amit Computer C 1500
5 Rahul Sales B 4500
6 Dinesh Computer C 4300
7 Arun Marketing A 3200
8 Manju Accounts C 6500
9 Niraj Computer B 7650
10 Pooja Accounts C 6523
11 Manav Accounts A 2541
12 Reetu Marketing C 2563
13 Tannu Computer B 9562
14 Karan Marketing C 3654
15 Mohit Sales A 5874
16 Sonu Computer C 2654
Instructions:
1. Create the worksheet as given above.
2. Sort the whole table in ascending order of Department Name.
3. Find the Average Salary of each Department using Subtotals.
4. Extract all records having Salary more than Rs. 4000
5. Using Auto Filter, find all records having Grade B and
Salary greater or Equal to 4000.
TCA:TRAINING & DEVELOPMENT - 9911459630 17
MENTORTCA TECHNOLOGY PVT. LTD.
6. Extract all records having salary less than or
equal to 2000 or Dept as Sales.
TEXT FUNCTION
FACULTY NAME D-O-J FACULTY INFO.
Sarita Pathak 3-Mar-16 Sarita Pathak Date of joining is 03-03-2016
Rahul Rathi 21-Nov-15 Rahul Rathi Date of joining is 21-11-2015
Rahul Kumar 9-Sep-15 Rahul Kumar Date of joining is 09-09-2015
Sandeep Rana 9-Jun-16 Sandeep Rana Date of joining is 09-06-2016
TCA:TRAINING & DEVELOPMENT - 9911459630 18
MENTORTCA TECHNOLOGY PVT. LTD.
TEXT FUNCTION
FULL NAME FIRST NAME LAST NAME Ctrl + Enter
NEEL NITIN MUKESH Neel Mukesh
VINOD KUMAR GARG Vinod Garg Flash Fill
ANKIT KUMAR TRIPATHI Ankit Tripathi
PRATAP SINGH CHAUHAN Pratap Chauhan
DATA ----->> TEXT TO COLUMNS
FULL NAME FIRST NAME MIDDLE NAME LAST NAME
NEEL NITIN MUKESH NEEL NITIN MUKESH
VINOD KUMAR GARG VINOD KUMAR GARG
ANKIT KUMAR TRIPATHI ANKIT KUMAR TRIPATHI
ROLL NO NAME COURSE
101,ANIL,MCA 101 ANIL MCA
102,SUNIL,MBA 102 SUNIL MBA
103,RAMAN,BCA 103 RAMAN BCA
104,GUNJAN,[Link] 104 GUNJAN [Link]
105,PRINCE,MA 105 PRINCE MA
ROLL NO NAME COURSE
101-ANIL-MCA 101 ANIL MCA
102-SUNIL-MBA 102 SUNIL MBA
103-RAMAN-BCA 103 RAMAN BCA
[Link] 104 GUNJAN [Link]
105-PRINCE-MA 105 PRINCE MA
TCA:TRAINING & DEVELOPMENT - 9911459630 19
MENTORTCA TECHNOLOGY PVT. LTD.
Pivot Table Assignment – 1
SalesRep Region Cars Total Sales
Raman West Renualt $41,107
Gagan West Maruti $72,707
Pooja North Audi $41,676
Raman North BMW $87,858
Gagan South Maruti $45,606
Pooja East Audi $49,017
Gagan West Renualt $57,967
Raman East Renualt $70,702
Pooja East Renualt $77,738
Raman South Renualt $69,496
Raman East BMW $71,439
Pooja West BMW $70,836
Pooja East Audi $70,233
Komal East Audi $69,630
Komal South Audi $69,027
Komal East BMW $68,424
TCA:TRAINING & DEVELOPMENT - 9911459630 20
MENTORTCA TECHNOLOGY PVT. LTD.
OUTPUT-1
Row Labels Audi BMW Maruti Renualt Grand Total
Pooja 160926.3333 70836.33333 77738 309500.6667
Komal 138657.6667 68424.33333 207082
Gagan 118313 57967 176280
Raman 159297.3333 181305 340602.3333
Grand Total 299584 298558 118313 317010 1033465
OUTPUT-2
Row Labels Audi BMW Maruti Renualt Grand Total
East 188880.6667 139863.6667 148440 477184.3333
Pooja 119250.3333 77738 196988.3333
Komal 69630.33333 68424.33333 138054.6667
Raman 71439.33333 70702 142141.3333
North 41676 87858 129534
Pooja 41676 41676
Raman 87858 87858
South 69027.33333 45606 69496 184129.3333
Komal 69027.33333 69027.33333
Gagan 45606 45606
Raman 69496 69496
West 70836.33333 72707 99074 242617.3333
Pooja 70836.33333 70836.33333
Gagan 72707 57967 130674
Raman 41107 41107
TCA:TRAINING & DEVELOPMENT - 9911459630 21
MENTORTCA TECHNOLOGY PVT. LTD.
Grand Total 299584 298558 118313 317010 1033465
Pivot Table Assignment – 2
SalesRep Region # Orders Total Sales
Bill West 217 $41,107
Frank West 268 $72,707
Harry North 224 $41,676
Janet North 286 $87,858
Joe South 226 $45,606
Martha East 228 $49,017
Mary West 234 $57,967
Ralph East 267 $70,702
Sam East 279 $77,738
Tom South 261 $69,496
TCA:TRAINING & DEVELOPMENT - 9911459630 22
MENTORTCA TECHNOLOGY PVT. LTD.
Output-1
Sum of Total Sales Column Labels
Grand
Row Labels East North South West Total
Bill 41107 41107
Frank 72707 72707
Harry 41676 41676
Janet 87858 87858
Joe 45606 45606
Martha 49017 49017
Mary 57967 57967
Ralph 70702 70702
Sam 77738 77738
Tom 69496 69496
Grand Total 197457 129534 115102 171781 613874
Output-2
Sum of Total
Row Labels Sales
Bill 41107
Frank 72707
Harry 41676
Janet 87858
Joe 45606
Martha 49017
Mary 57967
Ralph 70702
Sam 77738
Tom 69496
Grand Total 613874
TCA:TRAINING & DEVELOPMENT - 9911459630 23
MENTORTCA TECHNOLOGY PVT. LTD.
Output-3
Sum of Total
Row Labels Sales
East 197457
North 129534
South 115102
West 171781
Grand Total 613874
TCA:TRAINING & DEVELOPMENT - 9911459630 24
MENTORTCA TECHNOLOGY PVT. LTD.
Dynamic Chart
Order ID Product Category Amount State
P001 Carrots Veg 1238 Haryana
P002 Tomato Fruit 1776 Punjab
P003 Banana Fruit 1138 Asam
P004 Potato Veg 1972 Uttarakhand
P005 Tomato Veg 3456 Haryana
P006 Beans Veg 4298 Punjab
P007 Carrots Fruit 3666 Asam
P008 Carrots Veg 4192 Uttarakhand
P009 Tomato Fruit 3363 Haryana
P010 Banana Fruit 4380 Punjab
P011 Potato Veg 3917 Asam
P012 Tomato Veg 2263 Uttarakhand
P013 Beans Veg 1042 Haryana
P014 Tomato Fruit 4093 Punjab
P015 Carrots Veg 2240 Asam
P007 Carrots Fruit 3666 Haryana
P008 Carrots Veg 4192 Punjab
P009 Tomato Fruit 3363 Haryana
P010 Banana Fruit 4380 Punjab
P011 Potato Veg 3917 Asam
P012 Tomato Veg 2263 Uttarakhand
P013 Beans Veg 1042 Uttarakhand
P014 Tomato Fruit 4093 Asam
P015 Carrots Veg 2240 Haryana
P016 Banana Fruit 1042 Punjab
P017 Potato Veg 4093 Asam
P018 Tomato Veg 2240 Uttarakhand
P019 Beans Veg 3666 Uttarakhand
P020 Tomato Fruit 4192 Asam
P021 Carrots Veg 3363 Haryana
TCA:TRAINING & DEVELOPMENT - 9911459630 25
MENTORTCA TECHNOLOGY PVT. LTD.
Stock Manager’s Work
TCA:TRAINING & DEVELOPMENT - 9911459630 26
MENTORTCA TECHNOLOGY PVT. LTD.
TCA:TRAINING & DEVELOPMENT - 9911459630 27
MENTORTCA TECHNOLOGY PVT. LTD.
TCA:TRAINING & DEVELOPMENT - 9911459630 28
MENTORTCA TECHNOLOGY PVT. LTD.
PowerPoint
Assignments
TCA:TRAINING & DEVELOPMENT - 9911459630 29
MENTORTCA TECHNOLOGY PVT. LTD.
TCA:TRAINING & DEVELOPMENT - 9911459630 30
MENTORTCA TECHNOLOGY PVT. LTD.
TCA:TRAINING & DEVELOPMENT - 9911459630 31
MENTORTCA TECHNOLOGY PVT. LTD.
TCA:TRAINING & DEVELOPMENT - 9911459630 32
MENTORTCA TECHNOLOGY PVT. LTD.
TCA:TRAINING & DEVELOPMENT - 9911459630 33
MENTORTCA TECHNOLOGY PVT. LTD.
TCA:TRAINING & DEVELOPMENT - 9911459630 34