Friday, 29 June 2018

Microsoft excel 2010 #2

Microsoft excel 2010 shortcut keys


MICROSOFT EXCEL SHORT CUT KEYS
·         F2: Edit the active cell.
·         F5: Displays the Go To box.
·         F7: Open the Spelling dialogue box to check a selected range.
·         F11: Create a chart of data in the current range in a separate sheet.
·         Alt + Shift + F1: Insert a new worksheet.
·         Shift + F3: Opens Insert Function dialogue box.
·         Shift + F5: Opens the Find and Replace dialogue box.
·         Ctrl + Shift + Colon (:): Enter the current time.
·         Ctrl + Semicolon (;): Enter the current date.
·         Ctrl + A: Select all content in the worksheet.
·         Ctrl + B: Bold highlighted selection.
·         Ctrl + I: Italicize highlighted selection.
·         Ctrl + K: Open the Insert hyperlink dialogue box.
·         Ctrl + U: Underline highlighted selection.
·         Ctrl + 5: Apply strikethrough formatting.
·         Ctrl + P: Brings up the print dialog box.
·         Ctrl + Z: Undo.
·         Ctrl + F9: Minimize a workbook window to an icon.
·         Ctrl + F10: Maximize a selected workbook window.
·         Ctrl + F6: Switch to the next workbook window when multiple are open.
·         Ctrl + Page Up: Move to previous sheet in a workbook.
·         Ctrl + Page Down: Move to next sheet in a workbook.
·         Ctrl + Tab: Switch to next tab in dialogue box.
·         Ctrl + Apostrophe ('): Insert the value of the above cell into the cell currently selected.
·         Ctrl + Shift + !: Apply the Number format.
·         Ctrl + Shift + $: Apply the Currency format.
·         Ctrl + Shift + #: Apply the Date format.
·         Ctrl + Shift + %: Apply the Percentage format.
·         Ctrl + Shift + ^: Apply the Exponential format.
·         Ctrl + Shift + @: Apply the Time format.
·         Ctrl + Arrow Key: Move to the edge of the current data region in a worksheet.
·         Ctrl + Space: Select an entire column in a worksheet.
·         Shift + Space: Select an entire row in a worksheet.


Microsoft tutorial

Wednesday, 27 June 2018

Microsoft excel 2010 for beginners #1



We cover the below:
- How to do autosum?
- Headings / Font change / Cell Colour
- Graph
- Relationship of data and graph

Monday, 25 June 2018

how to download a movie from any torrent link.

ROTATOR CUFF



Hi!! There today I am going to share few words about the rotator cuff. So most of them will know what is rotator cuff, it is nothing but the group of muscles and tendons that is covered by or surrounded by the shoulder joints.
Let us see a detail study about the rotator cuff.


Overview:

Today why took this topic is, I was injured while playing and this pain was lasting over 6 to 8 months. So I went to the net and searched for it and I get to know that I was injured in the rotator cuff. I could not raise my hands still and release my hands. So if I write this incident as an article some will get to know when they are in the same situation. Coming back to the overview:
The rotator cuff is a group of muscles and tendons that surround the shoulder joint, keeping the head of your upper arm bone firmly within the shallow socket of the shoulder. A rotator cuff injury can cause a dull ache in the shoulder, which often worsens when you try to sleep on the involved side.
Rotator cuff injuries occur most often in people who repeatedly perform overhead motions in their jobs or sports. Examples include painters, carpenters, and people who play baseball or tennis. The risk of rotator cuff injury also increases with age.
Many people recover from rotator cuff disease with physical therapy exercises that improve flexibility and strength of the muscles surrounding the shoulder joint.
Sometimes, rotator cuff tears may occur as a result of a single injury. In those circumstances, medical care should be provided as soon as possible. Extensive rotator cuff tears may require surgical repair, transfer of alternative tendons or joint replacement.
                           

Symptoms:

The pain associated with a rotator cuff injury may:
·         Be described as a dull ache deep in the shoulder
·         Disturb sleep, particularly if you lie on the affected shoulder
·         Make it difficult to comb your hair or reach behind your back
·         Be accompanied by arm weakness

Risk factors:

The following factors may increase your risk of having a rotator cuff injury:
·         Age:  As you get older, your risk of a rotator cuff injury increases. Rotator cuff tears are most common in people older than 40.
·         Certain sports:  Athletes who regularly use repetitive arm motions, such as baseball pitchers, archers and tennis players, have a greater risk of having a rotator cuff injury.
·         Construction jobs:  Occupations such as carpentry or house painting require repetitive arm motions, often overhead, that can damage the rotator cuff over time.
·         Family history: There may be a genetic component involved with rotator cuff injuries as they appear to occur more commonly in certain families.

Prevention:


Rotator cuff exercises
If you are at risk of rotator cuff injuries or if you've had a rotator cuff injury in the past, daily shoulder stretches and strengthening exercises can help prevent future injury.
Most people exercise the front muscles of the chest, shoulder and upper arm, but it is equally important to strengthen the muscles in the back of the shoulder and around the shoulder blade to optimize shoulder muscle balance. Your doctor or a physical therapist can help you plan an exercise routine.

Conclusion:

    By reading this you could have got an little idea about this so whenever you get the pain please follow these simple exercise given above this can make you feel better

         You can also watch my YouTube video by clicking this .

Thanking you for reading this article please comment bellow…..







Monday, 18 June 2018

Difference between Linked in and the Facebook


FACEBOOK AND THE LINKED IN

Synopsis:
1)    Introduction
2)    Facebook
3)    Linked in
4)    Differences between them
5)    Conclusion
Introduction:
                             There are many social media sites for communicating and buiding our relationship between ourselves. The famous two social media sites are the Facebook and the LinkedIn. In this I am going to say about Facebook and the Linked in. While these both are used to connect people online but differently by their own features and the functionality.


                             All these comes under the social networking sites are services. These social networking sites are used to provide an web based tool to let people build their own profile and interact with others. These  includes Instant messages ,Chart rooms, E-mail or site group discussion. mail, blogs file sharing, video.

FACEBOOK:

                   The Facebook is used to connect with the verity people that are your friends, relatives and friends in school, classmates, and etc.
Facebook is an American online social media and social networking service company based in Menlo Park, California. Its website was launched on February 4, 2004, by Mark Zuckerberg, along with fellow Harvard College students and roommates Eduardo Saverin, Andrew McCollum, Dustin Moskovitz, and Chris Hughes.
When you join Facebook and create a profile, you will enter in key information which can help other people find you on Facebook. This includes; Basic information like name, birthday, hometown, political and religious views. In your profile you can also include contact information, your relationship details (married, single, and so on), and personal details such as your favorite teams, shows, movies, and books. Facebook also provides options for users to include education and work details.

Networks: When you join Facebook you can join a regional network to connect with people in your own area. Other types of networks you can join are based on a company or school.
    Facebook Applications: Applications on Facebook are small programs that users can install to their profile. These can be anything from blog interfaces to games, instant messaging, shopping lists and more. Other can often see notes about your applications and what you are doing in it on your profile. Also, your profile will also include boxes which contain the application.
    Facebook Photos: Facebook users can create online photo albums which can be viewed from their profile.
    Facebook Video: Users can upload and tag videos to share on their Facebook profile.

Linked in:
                             Linked in is also one of the most important social networking sites where we build our profile based upon our curriculum . This linked in is used as a business oriented sites where you create a file which is exactly our current position and your previous experience of the work.
                   These are used to upload the professional information and connect with the collogues On the LinkedIn site you create a network that consists of "connections". Connections on LinkedIn are the people you know, and connections expand to include the people they know and have connected with on LinkedIn.  
1)         Recommendations: You can recommend colleagues, business partners or service providers and share your recommendations on your profile. When others view those profiles they can read the recommendations.
2)      Contacts: You can search and add contacts individually or simply import your Outlook or Web mail contacts from Windows Live Hotmail, Gmail, Yahoo Mail or AOL to search for contacts on LinkedIn.
3)      LinkedIn Search: You can search for people by name, by company or by industry.
4)      LinkedIn Jobs: A job search, powered by Simply Hired enables you to search for jobs. Here, your LinkedIn connections, your profile updates, plus any recommendations can help you when making contact with a person who has listed a job posting you're interested in.

DIFFERENCE BETWEEN THEM:


The main difference between them is Linked in is used for a professional issues, but while rest other can be given in the Facebook.
             LinkedIn is designed more for business and professional networking and offers a profile and options to network in a business sense. Facebook, on the other hand is designed more to connect family and friends. When you want to know where an old colleague is working now, you use LinkedIn. When you want to find out if that same colleague is married and if they have kids, you use Facebook.



Conclusion:
                       Here by I conclude that , the usage of time in Facebook is more than the usage in the linked in  but for the carrier purpose the linked in will the the best one for us. So please consider the linked as the very important one it can change even your life style also.






Wednesday, 13 June 2018

CS6659 ARTIFICIAL INTELLIGENCE

General info:  CS6659
ARTIFICIAL INTELLIGENCE
University – Anna university,

Tamil Nadu, India

Marks: UNIT 1 to 5 – 9+3 each unit 

Period - TOTAL (L:45+T:15): 60 PERIODS 

OBJECTIVES:
The student should be made to:
1)  Study the concepts of Artificial Intelligence.
2)  Learn the methods of solving problems using Artificial Intelligence.
3)  Introduce the concepts of Expert Systems and machine learning.

UNIT I - INTRODUCTION TO Al AND PRODUCTION SYSTEMS
 Introduction to AI-Problem formulation, Problem Definition -Production systems, Control strategies, Search strategies. Problem characteristics, Production system characteristics -Specialized production system- Problem solving methods - Problem graphs, Matching, Indexing and Heuristic functions -Hill Climbing-Depth first and Breath first, Constraints satisfaction - Related algorithms, Measure of performance and analysis of search algorithms.

UNIT II - REPRESENTATION OF KNOWLEDGE
Game playing - Knowledge representation, Knowledge representation using Predicate logic, Introduction to predicate calculus, Resolution, Use of predicate calculus, Knowledge representation using other logic-Structured representation of knowledge.

UNIT III - KNOWLEDGE INFERENCE
Knowledge representation -Production based system, Frame based system. Inference - Backward chaining, Forward chaining, Rule value approach, Fuzzy reasoning - Certainty factors, Bayesian Theory-Bayesian Network-Dempster - Shafer theory.
UNIT IV - PLANNING AND MACHINE LEARNING
Basic plan generation systems - Strips -Advanced plan generation systems – K strips -Strategic explanations -Why, Why not and how explanations. Learning- Machine learning, adaptive Learning.

UNIT V - EXPERT SYSTEMS 
Expert systems - Architecture of expert systems, Roles of expert systems - Knowledge Acquisition – Meta knowledge, Heuristics. Typical expert systems - MYCIN, DART, XOON, Expert systems shells.

OUTCOMES: At the end of the course, the student should be able to:
1)  Identify problems that are amenable to solution by AI methods.
2)  Identify appropriate AI methods to solve a given problem.
3)  Formalise a given problem in the language/framework of different AI    methods.
4)   Implement basic AI algorithms.
5)  Design and carry out an empirical evaluation of different algorithms on a problem formalisation, and state the conclusions that the evaluation supports.

TEXT BOOKS: 1. Kevin Night and Elaine Rich, Nair B., “Artificial Intelligence (SIE)”, Mc Graw Hill- 2008.  (Units-I,II,VI & V) 2. Dan W. Patterson, “Introduction to AI and ES”, Pearson Education, 2007. (Unit-III).

REFERENCES: 1. Peter Jackson, “Introduction to Expert Systems”, 3rd Edition, Pearson Education, 2007.
2. Stuart Russel and Peter Norvig “AI – A Modern Approach”, 2nd Edition, Pearson Education 2007.
 3. Deepak Khemani “Artificial Intelligence”, Tata Mc Graw Hill Education 2013. 4. http://nptel.ac.in 

Notes from studentfocus.com: Unit-1,Unit-2, Unit-3, Unit-4, Unit-5



Active Employee Report

 Active Employee Report SELECT  PPPMF.PRIORITY, "PER_ALL_PEOPLE_F_1"."PERSON_NUMBER"             AS "PERSON_NUMBER...