Optometry Notes

Communication and Life Skills, Optometry Notes, Optometry Semester 1

Communication with People with Visual Impairment

/

OPTOMETRY · SEMESTER 1 Communication with People with Visual Impairment Communication and Life Skills START READING NOTES Contents of This Topic Effective communication in interacting wit people with visual disability Objectives 1. Definition Types of visual disabilities Signs of visual impairment 2. Concept of communication in interacting with people with visual disability 2. Concept of communication in interacting with people with visual disability….. 3. Challenges of communication in interacting with people with visual disability 3. Challenges of communication in interacting with people with visual disability….. 4. TECHNIQUES OF COMMUNICATION IN INTERACTING WITH PEOPLE WITH VISUAL DISABILITY 4. TECHNIQUES OF COMMUNICATION IN INTERACTING WITH PEOPLE WITH VISUAL DISABILITY….. Effective communication in interacting wit people with visual disability Session 6 Objectives a) Define the term visual disability b) Explain the concept of communication in interacting with people with visual disability c) Explain challenges of communication in interacting with people with visual disability d) Communicate with people with visual disability 1. Definition Visual disability : Refers to a significant impairment in vision that cannot be fully corrected by glasses, lenses, medication, or surgery, and which interferes with normal daily functioning Types of visual disabilities Visual impairment varies from shadowy vision to total blindness. Categorized by severity ( low, severe and blindness) Low vision/moderate- Reduced vision, person can still see shapes, light or large print Severe visual impairment- very limited perception of light /shapes, requiring aids Total blindness- no light perception Signs of visual impairment Squinting Tilting the head to see better Sensitivity to light Closing one eye to read well Frequently eye rubbing when not sleepy Holding book too close Consistently sitting to close to the TV 2. Concept of communication in interacting with people with visual disability Communicating with visual impairment patients involves using all available senses, emphasizing verbal clarity, touch (when appropriate)and creating a safe and respectful environment. 2. Concept of communication in interacting with people with visual disability….. The key concept are: Communication is more verbal than non-verbal because patient cannot interpret visual cues The provider should announce their presence, introduce themselves, and explain every action The environment should be safe , predictable and well described 2. Concept of communication in interacting with people with visual disability….. Tone of voice, pace and clarity are essential The patient relies heavily on auditory cues and information given orally Encourage patient autonomy(independence) – guide, but do not push or handle them without consent Communication must restore trust and dignity 3. Challenges of communication in interacting with people with visual disability Lack of access to non-verbal cues Patient cannot observe facial expressions, gestures, or body language Misinterpretation of emotional is common Fear, anxiety, or loss of confidence Visual impairment can cause: Fear of unknown Reduced trust in unfamiliar environments Anxiety in navigating new place(e.g., hospital) 3. Challenges of communication in interacting with people with visual disability….. Poor environmental orientation Difficult locating: Seats Doors Health worker Examination rooms Lack of proper orientation leads to confusion 3. Challenges of communication in interacting with people with visual disability….. Overdependence on others Patient may rely heavily on others for physical guidance Without proper guidance, communication become stressful Physical barriers Poor signage Obstacles in pathway Lack of tactile(touch) guidance 3. Challenges of communication in interacting with people with visual disability….. Provider- related challenges Use of unclear instructions Forget to introduce themselves Move objective or the patient without explaining Stigma and discrimination Some people may assume visually impaired patient cannot understand or make decisions 4. TECHNIQUES OF COMMUNICATION IN INTERACTING WITH PEOPLE WITH VISUAL DISABILITY Preparing the environment Ensure the setting is safe, calm, and free of obstacles Do not move the patient belonging without permission If you guide the patient, ask first and allow them to hold your arm 4. TECHNIQUES OF COMMUNICATION IN INTERACTING WITH PEOPLE WITH VISUAL DISABILITY….. B. Start with clear introductions Approach the patient calmly Never touch the patient without without verbal warning 4. TECHNIQUES OF COMMUNICATION IN INTERACTING WITH PEOPLE WITH VISUAL DISABILITY….. C. Use clear and descriptive verbal communication Speak on the normal tone- not too loud unless requested Describe what is happening D. Encourage active participation Ask open ended questions Allow the patient to explain their needs 4. TECHNIQUES OF COMMUNICATION IN INTERACTING WITH PEOPLE WITH VISUAL DISABILITY….. E. Use touch appropriately Touch should be gentle and professional, only after permission Inform the patient before any physical contact F. Maintain respect and dignity Speak direct to the patient not to the caregiver Do not assume they cannot understand medical information Give full informed consent explanations, using simple language 4. TECHNIQUES OF COMMUNICATION IN INTERACTING WITH PEOPLE WITH VISUAL DISABILITY….. G. Provide orientation and mobility assistance Describe the environment Allow the patient to move on their own pace H. Check for understanding Ask if they understood on what you explained I. Closing Summarize the key points Inform the patient when your about to leave ← PREVIOUS TOPICNEXT TOPIC →VIEW MODULE NOTESVIEW SEMESTER NOTESALL OPTOMETRY NOTES Need These Notes as PDF? Request a formatted copy for offline study, printing or revision. GET PDF NOTES ON WHATSAPP

Communication and Life Skills, Optometry Notes, Optometry Semester 1

Effective Communication With Key Population

/

OPTOMETRY · SEMESTER 1 Effective Communication With Key Population Communication and Life Skills START READING NOTES Contents of This Topic Learning Objectives Communicating With Key Population. The group of key population includes; The group of key population cont… Transgender people Sex workers People who inject drugs(PWID) Effective Communication With Key Population People living with HIV Concept Of Communication In Interacting With Key Populations. Presentations Small Groups BARRIERS AND CHALLENGE OF COMMUNICATING WITH KEY POPULATION BARRIERS cont…….. CHALLENGES OF COMMUNICATING WITH KEY POPULATION Provision of false information . Techniques Of Communication In Interacting With Key Populations Prepare conducive environment. DEMONSTRATE SKILLS OF EFFECTIVE COMMUNICATION IN INTERACTING WITH KEY POPULATIONS Learning Objectives By the end of this session, students are expected to be able to: a) Define the term Key Populations b) Outline groups in the Key Populations c) Explain the concept of communication in interacting with Key Populations d) Explain challenges of communication in interacting with Key Populations e) Apply techniques of communication in interacting with Key Populations Communicating With Key Population. Key population Are groups which are vulnerable and are at high risk of being affected or infected by HIV. Or Are groups who due to specific higher risk behavior are at increased risk of HIV in respect of epidemic type or control context, Also they have legal and social issues related to their behavior that increase their vulnerability to HIV. The group of key population includes; Men who have sex with men Transgender people People who inject drugs Sex workers People living with HIV The group of key population cont… Men who have sex with men These are people who engage in sexual activities with members of the same sex regardless of how they identify themselves; many of these men do not sexually identify as guys, homosexual or bisexual. Transgender people Are people who have gender identity or gender expression that differs from their assigned sex; this may include people who are not exclusively masculine or feminine Sex workers Are those people who are employed in sex industry including those who provide direct sexual services as well as staffs of such industries. These might be female, male or transgender (18 years old or above )who receive money or goods in exchange for sexual services ,either regularly or occasionally People who inject drugs(PWID) These are among the group most vulnerable to HIV infection. HIV prevalence among people who inject drugs is 28 times higher than among the rest of the population. Effective Communication With Key Population Drug use now accounts for an ever-growing proportion of those living with HIV. On average one in ten new HIV infection are caused by sharing needle. The term drug users is often used to refer to a person who illegal consumes psychoactive substance People living with HIV Are people Infected with HIV /AIDS either from birth or other means to life experience . Concept Of Communication In Interacting With Key Populations. Discussion Is the core method, participants reflects on their own experience, share with others, arise issues and plan for action together. All of the sessions are built around discussion. Through discussion people involved can be able to share different ideas. Presentations Are kept to a minimum and used only to summarize sessions or to explain facts, where participants are confused. Small Groups Are used to maximum participation in decisions. Some participants feel shy in large groups and are more comfortable in small groups. Small groups also can be used to do “task groups” Buzz Groups A small group of people that is divided from large groups to talk about ideas, solution to problem. It is hard to remain silent in group of two people. Rotational Brain Storming Is the another form of brain storming done in small groups. Each given a topic and begins by recording ideas in flip chart. BARRIERS AND CHALLENGE OF COMMUNICATING WITH KEY POPULATION Different In Perception When interacting with key population like sex workers information can be interpret in different ways and cause the barriers during communication. BARRIERS cont…….. Different In Language The use of alcohol and drugs can lead to the use of abusing language to others. This lead to misunderstanding during communication. Different In Personalities Most of people in a group of key population are more aggressive and assertive, due to this lead to difficulties during making communication with them. CHALLENGES OF COMMUNICATING WITH KEY POPULATION Closure of information. The client might give wrong information when asking questions and trying to get some information to him or her. Rejection to speak. Due to psychological problems or side effects of drugs that they use, can lead to him or her reject to speak during conversation. Provision of false information . A client may refuse to give true information with the afraid that his or her information can be disclosed. Poor participation in discussions. Due to lack of participation in speaking also lead to poor participation in a topic discussed. Concealed of interest. Failure to reveal one’s interest may lead to poor communication. Techniques Of Communication In Interacting With Key Populations Maintain relationship Through creating good rapport with the key population Accept individual’s attitude decision making of the individual should be supported Self-esteem building The personal must have enough self-confidence while communicating with the key population. Prepare conducive environment. You should prepare the friendly environment for communication. Ensure the presence of the security Person communicating with the key population must ensure the safety of the people communicating with confidentiality. Ensure the presence of the confidentiality so as to encourage the person to express their feelings ← PREVIOUS TOPICNEXT TOPIC →VIEW MODULE NOTESVIEW SEMESTER NOTESALL OPTOMETRY NOTES Need These Notes as PDF? Request a formatted copy for offline study, printing or revision. GET PDF NOTES ON WHATSAPP

Communication and Life Skills, Optometry Notes, Optometry Semester 1

Empathy

/

OPTOMETRY · SEMESTER 1 Empathy Communication and Life Skills START READING NOTES Contents of This Topic Define empathy Explain signs of empathy Explain types of empathy Explain steps of practicing empathy Explain the tips of practicing empathy Demonstrate techniques used to create strong bond to a patient EMPATHY TECHNIQUE IN BUILDING STRONG AND SUPPORTIVE RELATIONSHIP WITH PATIENTS Define empathy Empathy is the ability to understand, share, and resonate with another person's feelings, perspectives, and experiences without judgment. In healthcare, particularly in building relationships with patients, it involves putting oneself in the patient's position to recognize their emotions (e.g., anxiety about vision loss) and respond supportively. Unlike sympathy (feeling sorry for someone), empathy fosters connection by validating emotions and building trust, leading to stronger patient-provider bonds, better compliance, and improved outcomes. Explain signs of empathy Signs of empathy are observable behaviors that show genuine understanding and care: Active Listening: Maintaining eye contact, nodding, and avoiding interruptions. Verbal Affirmations: Phrases like "That sounds really frustrating" or "I can see why you'd feel worried." Non-Verbal Cues: Open body language (leaning forward, uncrossed arms), facial expressions matching the patient's emotion, and appropriate touch (e.g., a reassuring hand on the shoulder). Emotional Reflection: Paraphrasing feelings, e.g., "It seems like this blurred vision is making daily tasks difficult for you." Patience and Presence: Giving full attention, without rushing or checking the clock. These signs reassure patients they are heard and valued, strengthening the therapeutic relationship. Explain types of empathy Empathy is commonly divided into three types: Cognitive Empathy: Understanding a patient's perspective intellectually, without sharing their emotions (e.g., comprehending why a patient fears glasses due to stigma). Useful for clear explanations. Affective (Emotional) Empathy: Feeling and sharing the patient's emotions (e.g., sensing their anxiety during a glaucoma diagnosis). Builds deep emotional connections. Compassionate Empathy: Combines cognitive and affective, leading to action (e.g., not only understanding fear but offering reassurance and tailored support, like extra time for questions). In patient care, balanced use of all types promotes supportive relationships and motivates patients toward better health behaviors. Explain steps of practicing empathy Practicing empathy involves a structured approach: Self-Awareness: Reflect on your own biases and emotions to remain open. Active Observation: Pay attention to verbal and non-verbal cues from the patient. Listen Without Judgment: Fully hear the patient's story before responding. Imagine Their Perspective: Mentally step into their shoes to understand their feelings. Validate Emotions: Acknowledge what they're experiencing (e.g., "It's normal to feel scared about this"). Respond Supportively: Offer help or reassurance aligned with their needs. Reflect and Learn: After interactions, review what worked to improve future empathy. Consistent practice builds stronger, more supportive patient relationships. Explain the tips of practicing empathy Effective tips include: Be Present: Minimize distractions (e.g., put away charts or devices). Use Open-Ended Questions: Encourage sharing, e.g., "How has this affected your daily life?" Mirror Language: Reflect patient words for accuracy. Avoid Minimizing: Don't say "It's not a big deal"; instead, validate. Cultural Sensitivity: Recognize diverse backgrounds influencing emotions. Self-Care: Manage your emotional load to sustain empathy (avoid burnout). Practice Regularly: Role-play scenarios or seek feedback. These tips enhance rapport and patient trust over time. Demonstrate techniques used to create strong bond to a patient Techniques combining empathy for strong bonds: Personalized Greeting: Use the patient's name and ask about their concerns first. Empathetic Statements: "I imagine wearing these new glasses might take some getting used to—how are you feeling about it?" Shared Decision-Making: Involve them in choices (e.g., frame styles or treatment options). Follow-Up: Check in post-visit or remember personal details from prior talks. Reassurance Through Touch/Body Language: Gentle gestures or leaning in to show care. Story Sharing (Judiciously): Relate briefly if it normalizes their experience. Consistency: Be reliable in appointments and promises. For example, with an anxious patient facing cataract surgery: Sit at eye level, maintain eye contact, say "Many patients feel nervous like you—it's okay, and we'll go through this together," then explain steps calmly. This creates trust, reduces fear, and fosters a supportive, long-term relationship. ← PREVIOUS TOPICNEXT TOPIC →VIEW MODULE NOTESVIEW SEMESTER NOTESALL OPTOMETRY NOTES Need These Notes as PDF? Request a formatted copy for offline study, printing or revision. GET PDF NOTES ON WHATSAPP

Communication and Life Skills, Optometry Notes, Optometry Semester 1

Communicating with Drug Abusers and Alcoholics

/

OPTOMETRY · SEMESTER 1 Communicating with Drug Abusers and Alcoholics Communication and Life Skills START READING NOTES Contents of This Topic Objectives 1. Definitions 1. Definitions…….. Phases of Substances Misuse Phases of Substances Misuse….. Phases of Substances Misuse…… Phases of Substances Misuse…. Example of abused substances 2. groups in the alcoholics and drug abusers 2. groups in the alcoholics and drug abusers…. 2. Groups in the alcoholics and drug abusers…. 3. Concept of communication in interacting with alcoholics and drug abusers 3. Concept of communication in interacting with alcoholics and drug abusers…… 3. Concept of communication in interacting with alcoholics and drug abusers…… 3. Concept of communication in interacting with alcoholics and drug abusers……. 4. Challenges of communication in interacting with alcoholics and drug abuse 4. Challenges of communication in interacting with alcoholics and drug abuse….. 5. Techniques of effective communication with alcoholics and drug abusers 5. Techniques of effective communication with alcoholics and drug abusers…… 5. Techniques of effective communication with alcoholics and drug abusers….. 5. Techniques of effective communication with alcoholics and drug abusers….. 5. Techniques of effective communication with alcoholics and drug abusers….. References Effective Communication in Interacting With Alcoholics and Drug Abusers Objectives a) Define the term alcoholics and drug abusers b) Outline groups in the alcoholics and drug abusers c) Explain the concept of communication in interacting with alcoholics and drug abusers d) Explain challenges of communication in interacting with alcoholics and drug abusers e) Communicate with alcoholics and drug abusers 1. Definitions Alcoholics abusers Are individuals who consume alcohol in a harmful or hazardous manner that negatively affects their physical health, mental well-being, behavior, social relationships or daily functioning, but who may not yet meet the criteria for alcohol dependence Drug abusers Are individuals who use drugs in a harmful or non-medical manner, leading to physical, psychological, social, or occupational problems, and who continue using the drugs despite knowing the harmful consequences 1. Definitions…….. Substance use Is the intentional consumption of psychoactive substances such as alcohol, tobacco, prescription medications, or illegal drugs, for the purpose like medical treatment, social use, relaxation, or pleasure, which can affect the brain, behavior, mood, and physical health. Substance misuse Refers to the harmful or improper use of alcohol or drugs, leading to health, social , psychological, or economic problems Phases of Substances Misuse Experimental use First time or occasional use, often due to curiosity, peer pressure or social influence. User believe they are in control No clear negative consequences yet Common among adolescents and young adult Phases of Substances Misuse….. 2. Social/recreational use Substance used in social settings ( parties, cerebrations) Use is intentional but limited Person can still stop without difficulty Early risk behaviors may begin Phases of Substances Misuse…… 3.Regular(Habitual ) use Substance use become s more frequent and predictable Begins to give out a purpose ( relaxation, stress relief, sleep) Tolerance may start to develop Early health, social, or academic problems appears Phases of Substances Misuse…. 4. Abuse / Harmful use Continued use despite of negative consequences Loss of control over amount or frequency Problems at work, school, family or health Risky behaviors ( unsafe sex, violence and accidents) Phases of Substances Misuse….. 5. dependence (Addiction) Strong physical and psychological dependence During this phase, the user uses to feel normal and is always in emotional pain ( although it may not be visible) He/she medicates the pain , and the substance becomes the only true friend Habitual use Withdraw symptoms when substance is stopped Substance becomes the central focus of life Phases of Substances Misuse….. 6. Chronic use/ Relapse phase Severe physical, mental, and social consequences Requires long treatment, rehabilitation and support Example of abused substances Alcohol Cocaine Heroin Petrol Marijuana, including hashish 2. groups in the alcoholics and drug abusers Alcoholic and drug abusers can be grouped in several ways, depending on type of substance used, pattern of use , level of dependence and social context. Understanding these groups helps health workers communicate effectively, plan care, and provide appropriate support 2. groups in the alcoholics and drug abusers…. Group based on type of substance use a) Alcoholic users These individuals mainly consume alcoholic drinks such as beer, wine, or spirits Occasional drinkers- drink socially without harm Heavy drinkers- consume large amounts regularly Alcoholic dependent persons –has loss of control, tolerance and withdraw symptoms 2. groups in the alcoholics and drug abusers…. Group based on type of substance use…….. b) Drug users These individual misuse psychoactive substances other than alcohol, including: Cannabis ( marijuana) users Opioid users ( heroin, morphine) Stimulant users ( e.g., cocaine) Sedative users (e.g., benzodiazepines) Inhalant users (e.g., petrol) 2. groups in the alcoholics and drug abusers…. Group based on pattern of use Experimental users Try alcohol or drug out of curiosity or peer influence Common among adolescents and young adults Usually short-term use b) Recreational users Use substances occasionally for pleasure or relaxation Often believe they can control their use Risk of progressing to harmful use 2. groups in the alcoholics and drug abusers…. Group based pattern of use……. c) Habitual or regular use Use substances frequently Substance use becomes part of daily routine Increased risks of physical and psychological harm d) Dependant or addicted users Have strong craving and loss of control Experience withdraw symptoms when not using Continue use despite harm to health and social life 2. Groups in the alcoholics and drug abusers…. Group based on level of harm low-risk users Use without obvious immediate harm Still at risk of future problems b) Harmful users- substance use causes physical and mental or social problems May not be dependant c) Substance use disorder- Diagnosable condition with significant impairment Require medical and psychosocial intervention 2. Groups in the alcoholics and drug abusers…. Group based on social and demographic factors. Adolescent and youth Influenced by peers and experimental High risk of addiction and risk behavior Adults Use may be linked to stress, unemployment or family problems Pregnant women High risk of fetal complications 3. Concept of communication in interacting

Communication and Life Skills, Optometry Notes, Optometry Semester 1

Skills of customer care to improve quality of service

/

OPTOMETRY · SEMESTER 1 Skills of customer care to improve quality of service Communication and Life Skills START READING NOTES Contents of This Topic Session 8: Learning Objectives Define the following terms CUSTOMER CARE CUSTOMER CARE Customer satisfaction Factors for customer satisfaction Characteristics of good customer services Listening & Being Compassionate Key element of customer care Key element of customer care cont.. Basic needs of Client/customer Basic needs of Client/customer cont.. Principles of customer care Principles of customer care cont.. Techniques used in providing quality customer care What is Quality of Care? Components of Quality Health Services Access to Service Technical Competence Equity Efficiency Safety Interpersonal Relations What Is Quality Assurance? Principles of Quality Assurance Meeting the Needs of Our Clients – Principle 1 Use of Data to Improve Quality – Principle 3 Tools for Collecting Data and Use of Information Improving Quality Through Team Work – Principle 4 Effective Communication -Principle 5 Evaluation References Session 8: Demonstrate skills of customer care to improve quality of service Learning Objectives Describe the determinants of service quality Identify characteristics of good customer care Explain the role of customer care in health service delivery Identify the practices needed to provide excellent customer service Explain the significance of service quality assurance in the development of health service sector. Describe the Steps for creating an effective customer service program Define the following terms Customer/client Care Customer care Customer satisfaction CUSTOMER Is someone who receives one or more organization’s (health facility) services or products who has a direct relationship with, or is directly affected by organization. CARE Care: is any activity, work performed by health provider to meet needs and problems of a client CUSTOMER CARE Is the act of meeting clients needs and problems by providing or delivering professional, helpful, high quality service and assistance Customer satisfaction Customer satisfaction measures how well the expectations of a customer concerning a product or service provided by your company have been met. Customer satisfaction is an abstract concept and involves such factors as the quality of the product, the quality of the service provided, the atmosphere of the location where the product or service is purchased, and the price of the product or service. Factors for customer satisfaction quality, performance and efficiency of the product. Customer service provided by the healthcare Type and quality of response provided by the healthcare. Environment – Infrastructure (structure and facilities) Price of the product or services provided Characteristics of good customer services Politeness: Politeness is almost a lost art. Saying 'hello,‘ “welcome” 'good afternoon,' 'sir', and 'thank you very much' are a part of good customer service Responsiveness: Respond promptly to the needs of patients, customers and fellow team members. Problem solving: Be proactive in anticipating and preventing problem before they arise Respect: Treat patients and team members as you would want to be treated Professionalism: All customers/patients should be treated professionally, which means the use of competence or skill expected of the professional. Listening & Being Compassionate Teamwork: Confidential Accountability Promptness Characteristics of good customer services cont.. Key element of customer care Understanding: Understand, identify, and anticipate needs. Customers don’t really buy products or services; they buy solutions to problems. The better we solve those problems, the more appreciative they are, and the better their experiences in dealing with your business. Listening: Keep your ears—and eyes—open. Hear what the market is saying, and be a good listener. Identify customer needs by asking questions and concentrating on what the customer is really saying. Responding: Now you have to respond positively. This is not to say that you have to change your entire business model or product line to suit the demands of various customers. Seek ways to help your customers and give them what they are looking for without compromising your company or products. Key element of customer care cont.. Respect: Respect the fact that customers actually pay our salaries and make our profits for us. Make them feel important and appreciated and treat them as individuals Serving: Essentially this means fulfilling your promises. Trust : Give great customer service, you’re going to have to put a little trust in your customers. Basic needs of Patient/customer Basic needs of Client/customer Friendliness The most basic need of all and is usually associated with being greeted politely and courteously. Fairness All customers want to be treated fairly. Control Control represents the customer’s need to feel as if they have an impact on the way things turn out. Options and Alternatives Provide the customer with other available avenues to get what they want accomplished. Basic needs of Client/customer cont.. Understanding and Empathy Customers need to feel that their circumstances and feelings are appreciated and understood by the service person without criticism or judgment. Information Customers need and want to be informed about products, policies and procedures they encounter when doing business with you. Principles of customer care Reliable: Being honest and trustworthy in all interactions with customers and meeting commitments Relationships: Valuing the role of every family, child, and staff member and working together as a team to achieve positive outcomes Principles of customer care cont.. Responsive: Reacting in a timely manner to meet responsibilities to address identified needs. Respectful: Interacting with customers in a way that makes them feel valued and promotes dignity and self-worth. Recognition: Showing appreciation for the contributions of each team member openly and frequently Techniques used in providing quality customer care Engage in active listening Active listening is essential for effective communication. It allows for a better understanding of the customers’ needs and shows a willingness to help. Allow the customer to talk without interruption, reflect back their main question or concern and ask clarifying questions when necessary. Highlight understanding Ensure that each customer is aware that you understood their needs. By using active listening techniques and asking relevant questions, you will communicate that you understand them and are making an effort to help solve their problem. Techniques used in providing quality customer care Polite Be polite and have

Computer Applications, Optometry Notes, Optometry Semester 1

Introduction to Computers

/

OPTOMETRY · SEMESTER 1 Introduction to Computers Computer Applications START READING NOTES Contents of This Topic INTRODUCTION TO BASIC COMPUTERS LEARNING OBJECTIVES – What is a Computer? The history of Computer The History of Computer cont.… The History of Computer cont… CHARACTERISTICS OF A COMPUTER Other Characteristics are: CLASSIFICATION OR TYPES OF COMPUTERS TYPES OF COMPUTER BASED ON SIZE Types of computer based on size cont.….. Picture of a Supercomputer 1.Types of computer based on size cont.… Picture of a Mainframe computer. 1.Types of computer based on size cont.…. 2. Types of computer based on Generation 3.Types of computer based on Purposes 4. Types of computer based on Technology The Parts of a Computer System HARDWARE SOFTWARE DATA Types of Hardware The CPU (PROCESSOR) Memory How Memory is Measured Input and Output Devices Storage Devices What is Software? System Software Application Software Differences between System software and application software Computer device connections Computer Booting Management of Folders and Files Any question INTRODUCTION TO BASIC COMPUTERS SESSION 1 1 LEARNING OBJECTIVES By the end of this session, you should be able to: Define computer Explain the history of computer Outline characteristics of computer Identify types of computers according to size, generation, purpose/function, technology Identify structure/anatomy of computer (input, CPU, and output) Identify components of a computer (Hardware and Software) Explain types of computer software Explain types of computer hardware (processing, input, output storage Perform computer device connections Perform computer booting (cold and warm booting) Manage folders and files (create, rename, delete, restore, copy, move, search, organize and transfer from computer to removable storage devices) 2 – What is a Computer? Computer is an electronic device used to process data. Computer can convert data into information that is useful to people. OR Computer: is an electronic device that takes data, stores it, processes that data and produces information. Computer: is a machine or device which accepts data in one form and processes it to produce an output of information. Data: can be defined as unprocessed facts/Raw facts . 3 The history of Computer Mechanical era: In the 19th century, Charles Babbage designed the analytical engine, a programmable mechanical computer, and Ada Lovelace wrote the first algorithm for it. First electronic computers: The ENIAC, considered the first programmable electronic computer, was completed in the 1940s. 4 The History of Computer cont.… 1. First Generation (1940–1956) – Vacuum Tubes: Used vacuum tubes for processing. Very large, consumed a lot of power, and produced much heat. Programming was done in machine language. Example: ENIAC, UNIVAC I. 2. Second Generation (1956–1963) – Transistors: Replaced vacuum tubes with transistors Smaller, more reliable, and faster. Used assembly language. Example: IBM 1401. 5 The History of Computer cont… 3. Third Generation (1964–1971) – Integrated Circuits (ICs): Used ICs (multiple transistors on a chip). Increased processing speed and efficiency. Used high-level languages like COBOL, FORTRAN. Computers became more accessible to businesses. 4. Fourth Generation (1971–1980) – Microprocessors: Introduced the microprocessor (entire CPU on a single chip). Rise of personal computers (PCs). Increased power, speed, and storage. Example: Intel 4004, Apple I, IBM PC. 6 The History of Computer cont… 5. Fifth Generation (1980-Present) – AI & Advanced Technologies: This era is characterized by the rise of personal computers, the internet, and the integration of artificial intelligence and other advanced technologies. In this Modern era: Computers have become smaller and more powerful, evolving into laptops, smartphones, and wearable devices. 7 CHARACTERISTICS OF A COMPUTER THE TWO PRINCIPAL CHARACTERISTICS OF COMPUTER ARE:- A computer responds to a specific set of instructions in a well-defined manner. A computer can execute a pre-recorded list of instructions (a program). 8 Other Characteristics are: SPEED : Computer can perform millions of instructions per second.. ACCURACY : Since Computer is programmed, so what ever input we give it gives accurate results. STORAGE : Computer can store mass storage of data with appropriate format. DILIGENCE : Computer Doesn’t get tired or lose concentration. VERSATILITY : Computer can perform different types of tasks at the same time. NO IQ : Computer does not work without instruction. NO FEELING : Computer does not have emotions, knowledge, experience AUTOMATION: Computer Works automatically after programming. 9 CLASSIFICATION OR TYPES OF COMPUTERS We can classify types of computers based on the following criteria:- Types of computer Based on size Types of computer Based on generation Types of computer Based on purposes/function Types of computer Based on Technology 10 TYPES OF COMPUTER BASED ON SIZE Supercomputer Mainframe Minicomputer Workstation Microcomputer 11 Types of computer based on size cont.….. 1. Supercomputer It is Extremely fast, used for scientific simulations, weather forecasting and space exploration. It is Very accurate It has High processing speed Can tackle complex tasks such as breaking codes and modeling worldwide weather system. An example of supercomputer: IBM Deep Blue 12 Picture of a Supercomputer 13 1.Types of computer based on size cont.… 2. Mainframe These are the very largest computers; they can occupy more than one room. For example: IBM 370, S/390. A powerful multi-user computer capable of supporting many hundreds or thousands of users simultaneously like ATM Transactions. They are: Large in size Expensive due to high cost of production High storage capacity and high processing speed Used in organization to process a bulk of information Generally used by large businesses to provide centralized storage, Processing and management for large amounts of data. 14 Picture of a Mainframe computer. 15 1.Types of computer based on size cont.…. 3. Minicomputer A multi-user computer: Smaller than mainframe but more powerful than Micro-computer. computers that are capable of supporting from 10 to hundreds of users simultaneously. These are large powerful machines typically serving a network of simple terminals. Example of minicomputer; Digital Alpha, Sun Ultra, HP 3000 series, IBM AS/400,PDP series. Very powerful and expensive Used in medium scale organizations where it is too expensive to use mainframe computers 16 1.Types of computer based on size cont.… 4. Workstation Powerful desktop computers designed for specialized tasks such as medical imaging. Such tasks

Computer Applications, Optometry Notes, Optometry Semester 1

Computer System Components

/

OPTOMETRY · SEMESTER 1 Computer System Components Computer Applications START READING NOTES Contents of This Topic SESSION 02 The System Unit Inside the System Unit? Motherboard Power supply Central processing unit(CPU) Random access memory (RAM) Hard disk drive Adapter cards Optical drives Fan Ports Physical components of Computer System(Hardware) can be categorized into four types: Computer System Components Input devices Some of the popular input devices are: The commonly used Input devices are: Mouse has three parts namely Operations/skills/techniques of using mouse A standard computer Keyboard has 101,105,107 or 108 keys Most keyboards have keys arranged in five groups: Output devices Some of the popular output devices are: Common output devices are: Processing devices CPU Storage devices Examples of Storage Devices: Factors that Impact a Computer’s Performance SESSION 02 UTILIZE BASIC CONCEPTS OF COMPUTER SYSTEM IN OPERATING A COMPUTER The System Unit This is a container that houses most of the electronic components that make a computer system. System unit act as a Computer case Alternatively called a box, main unit, and system box, a system unit is the case containing all the main parts of a computer. Inside the System Unit? Motherboard Power Supply Central Processing Unit (CPU) Random-access Memory (RAM) Hard Disk Drive / Solid State Drive Adapter Cards(Sound card, Video card(Graphic card),Network card Optical Drives Fan Ports Bus (Address bus, I/O bus, Memory bus and CPU bus) Motherboard A motherboard is the main circuit board inside a computer that connects the different parts of a computer together. Power supply A power supply is a component that supplies power inside the computer. Central processing unit(CPU) Is the brain of the computer. Or is the part of the computer that handles all operation on the computer system. Random access memory (RAM) Is a computer's primary(temporary) memory, where the data that the processor is currently using is stored. Store data when computer is ON and loose data when computer is OFF. Hard disk drive Is a computer's long-term memory(permanent memory), where the data are stored. Adapter cards Is a type of computer hardware used to add more functions and capabilities to a computer. Video card Sound card Network card Optical drives Is a computer disk drive that uses laser beam technology to read and write data on optical disks like CDs, DVDs, and BDs (Blu-ray discs) Fan A fan is a hardware device that keeps the overall computer or a computer device cool by circulating air to or from the computer or component Ports A port is a connection or a jack provided on a computer to connect external or peripheral devices to the computer Bus A bus is a communication system that transfers data between components inside a computer, or between computers. Physical components of Computer System(Hardware) can be categorized into four types: Input devices Output devices Processing devices and Storage devices Types of Computer Hardware Computer System Components Remember: All types of computers follow the same basic logical structure and perform the basic operations for converting raw input data into information useful to their users. Input Devices Processing Devices Output Devices Storage Devices Input devices Definition- Are devices that are used to enter data in a computer. Functionality. -To translate data from human understanding form to computer understanding form (Computer Readable form) Some of the popular input devices are: Keyboard Mouse Scanner Joystick Light Pen Digitizer Microphone Magnetic Ink Character Recognition (MICR) Optical Character Reader (OCR) Digital Camera Paddle Steering Wheel Gesture recognition devices Light Gun Touch Pad Remote Touch screen VR Webcam Biometric Devices The commonly used Input devices are: Keyboard Mouse Mouse has three parts namely Left click Right click Scroll Types of the mouse Wired mouse Wireless mouse Optical mouse Operations/skills/techniques of using mouse Point: When you’re told to “point the mouse,” you move the mouse on the desktop, which moves the mouse pointer on the screen to point at something interesting (or not). Click: A click is a press of the mouse button — one press and release of the main button, the one on the left. Clicking is often done to select something or to identify a specific location on the screen. Right-click: This action is the same as a click, although the right mouse button is used to get more commands. Double-click: This one works just like the single click, although you click twice in the same spot — usually, rather rapidly. Drag: The drag operation is done to graphically pick up something on the screen and move it. A standard computer Keyboard has 101,105,107 or 108 keys The layout/Features of the Keyboard Most keyboards have keys arranged in five groups: Function keys Numbering keys Alphabetic keys Symbols/Commanding keys Special keys Output devices Definition – Are devices that are used to give results of the processed information. Functionality Translates data from computer understanding form to human understanding form Some of the popular output devices are: Monitor Printer Headphones Computer Speakers Projector GPS Sound Card Video Card Braille Reader Speech-Generating Device Common output devices are: Printer Monitor Speaker Projector Which are Input Devices and which are Output Devices? Processing devices Definition – Are devices that are used to process data and handle all computer operations. Functionality It handles all operations on the computer system Some of the popular processing devices are: CPU (central processing unit) GPU (graphics processing unit) CPU Function of CPU 1. Fetch: gets an instruction from memory 2. Decode: decides/interpret what the instruction means 3. Execute: performs the instruction Storage devices Definition – Are devices that are used to store data and all programs. This devices act as Computer Memory Types of Computer Memory: Primary Memory (Main memory) Is the memory that holds data, programs and instructions that are currently in use. Secondary Memory Computer memory that stores data and programs permanent. Examples of Storage Devices: One that act as Primary memory: Read only memory (ROM) Random access memory (RAM) One that act as Secondary memory: Magnetic Tape Hard Disk drive Optical Storage i.e CD and DVD Solid State

Computer Applications, Optometry Notes, Optometry Semester 1

Computer Memory and Operating Systems

/

OPTOMETRY · SEMESTER 1 Computer Memory and Operating Systems Computer Applications START READING NOTES Contents of This Topic Session 3 Session Objectives Session Objectives [Contd…] Archie, please return My $1000 Computer Memory Visualisation of Computer Memory Dictionary of Bits and Bytes Dictionary of Bits and Bytes contd… Dictionary of Bits and Bytes contd… Introduction To Operating System Introduction To Operating System contd… Definition of OS Functions of Operating System Functions of Operating System [Contd…] Therefore EDP CYCLE Components of the CPU CPU Registers ALU Control Unit (CU) Classification Of Operating Systems Classification Of Operating Systems [Contd…] OTHER CLASSIFICATION OF OS By Functionality Modern ExamplesOF OS Graphical User Interface Systems Components Of GUI System Components Of GUI System [Contd…] Components Of GUI System [Contd…] Session Summary Session 3 Memory and Operating System Session Objectives Explain the concept of computer memory Describe the logical structure of computer memory List the different units for measurement of computer memory Explain the concept of operating system Describe EDP cycle in detail Session Objectives [Contd…] Describe the CPU Architecture. Describe about the CPU registers Name the categories of operating system Explain the features of GUI systems List the features of an OS Archie, please return My $1000 Which money Tom, I can’t remember!!! Need for Memory Computer Memory The capacity of the computer to store data at an instant and its ability to retrieve the same data at another point of time is termed as the computer memory. Memory is used to store both data and information Computer’s memory can be visualized as a contiguous block of rectangular holes. Visualisation of Computer Memory Look at the Shelf Tom, Cell Block of Memory Contents(Data or Information) Dictionary of Bits and Bytes Data given by the user is either decimal numbers or alphabets. So, a step of conversion is necessary before the inputs get accepted by the computer. Hey!!! I can understand only 0s and 1s Dictionary of Bits and Bytes contd… 2 Numbers and alphabets get converted into binary numbers 0 1 0 Bit(Binary Digit) Conversion program Dictionary of Bits and Bytes contd… 8 Bits= 1 Byte 1 TB 1024MB=1GB 1024 KB=1MB 1024 Bytes= 1KB Tera Byte Introduction To Operating System Office Environment I want the Year End financial report !! Yes Sir, Introduction To Operating System contd… User Take these numbers and give me their sum. OS Ok Sir, It will be done Computer Environment Definition of OS OS is a system software which acts as an interface between the user and the computer hardware. Functions of Operating System Booting loads the user program into the computer memory The data required by the program is also loaded into the memory. Gives instruction to the computer to display the result on the monitor Functions of Operating System [Contd…] Provides the means for the proper use of the resources like input,output and storage devices. Thus it acts as a manager of various computer resources. Functions of Operating System [Contd…] The operating system software controls the computer hardware. It co-ordinates the flow of data from the storage unit to the processor and vice versa. Therefore An OS is responsible for forwarding the inputs to the processor, get the computation done, and display the result This process is popularly also known as the EDP cycle. EDP CYCLE INPUT DEVICES CPU BUFFER OUTPUT DEVICES PRIMARY MEMORY Components of the CPU CPU Registers CU ALU CPU Registers This unit is for storing any data that comes into the CPU while processing. ALU The Arithmetic and Logic Unit or the ALU takes care of all the mathematical and logical Operations to be done during calculations. Control Unit (CU) This unit controls the whole process of data transfer from one place to the other while computations are going on Classification Of Operating Systems Operating Systems can be categorized into two types. Single User Operating System Example: MS DOS User Processor Classification Of Operating Systems [Contd…] Multi – User Operating System A computer system, when acts as an interface for more than one user, it becomes a multi user environment system Example: Windows -NT Classification Of Operating Systems [Contd…] 4 OS is carrying User1’s Work to the processor I have some work for you Mr. OS The OS puts User2’s work in queue I have some work for you Mr. OS 1 USER1 USER2 3 5 User’s 1 job can be collected back and hence User2’s work is taken up 6 Processor OS 2 OTHER CLASSIFICATION OF OS By Device & Use Case Desktop/Laptop OS: Windows, macOS, Linux (Ubuntu, Fedora), ChromeOS. Mobile OS: Android, iOS (for iPhones/iPads). Server OS: Linux distributions (Ubuntu Server, Red Hat), Windows Server. Embedded OS: For specialized devices like smart TVs, cars, ATMs (often proprietary or stripped-down Linux/RTOS). Real-Time OS (RTOS): Critical for precise timing, used in medical devices, robotics, automotive systems (e.g., VxWorks, QNX). By Functionality Multi-Tasking: Runs multiple applications at once (Windows, macOS, Linux). Multi-User: Allows multiple users to access the system simultaneously (Linux, Windows Server). Time-Sharing: Divides CPU time among users for quick response (modern multitasking OS). Distributed: Manages multiple computers as one system over a network. Network OS (NOS): Manages network resources and communication. Batch OS: Processes jobs in batches without direct user interaction (older systems). Modern ExamplesOF OS Windows: Most popular on desktops, known for broad software compatibility. macOS: Apple's OS for Macs, known for user experience and ecosystem integration. Linux: Open-source, dominant in servers and supercomputers, many variations (distributions). Android: Open-source, highly customizable, powers most smartphones. iOS: Apple's mobile OS, known for security and simplicity on iPhones/iPads. Graphical User Interface Systems OS which use pictures on its interface to abstract functionalities are GUI(Graphical user Interface) OS Hence the user can just point and select appropriate pictures to invoke the required functionality of the OS Example : Windows OS : Win ’95 and Win NT. Components Of GUI System Desktop This is an area on the screen, which displays the various components of a GUI. It is always the starting screen to the OS environment.

Computer Applications, Optometry Notes, Optometry Semester 1

PowerPoint Presentation Skills

/

OPTOMETRY · SEMESTER 1 PowerPoint Presentation Skills Computer Applications START READING NOTES Contents of This Topic Apply presentation skills in information dissemination Define PowerPoint PowerPoint versions Launch/start PowerPoint in Windows 7 Launch/start PowerPoint in Windows 8, 10, 11 A. Office Button F. Slide Area K. Outline tab Create PowerPoint presentation I. Create a PowerPoint Presentation from blank slides II. Create a PowerPoint Presentation using a template III. Create a PowerPoint Presentation from word outline PowerPoint presentation views Home work Adding new slide to a presentation Delete slide Save your presentation Format text of a PowerPoint presentation Add clipart and picture in presentation Add SmartArt Add charts, diagrams and tables in presentation Add charts, diagrams and tables You can change table styles and also insert and delete rows and columns Add AutoShape, WordArt and Hyperlinks Add WordArt Add Hyperlinks and action button If you use text for the hyperlink, the Text to display field will appear active in the dialog box. PowerPoint Presentation Skills Insert the shape onto the slide. The Actions Setting dialog box will appear. Add footer, slide number and date Add transition to a presentation(2013-2021) Click the Transitions tab. You can modify transition by changing the following properties Add transition to a presentation(2007) Add animation to a presentation Add animation to a presentation (2007) Add animation to a presentation (2013-2021) Select the Animation tab and options in the ribbon appear. Print a PowerPoint presentation (2007) Decide what you want to print: slides, handouts, notes pages, or an outline. Print a PowerPoint presentation (2013-2021) Choose which slides you want to print: Under Settings, click the first rectangle's down arrow and choose an option: Power Point Presentation Apply presentation skills in information dissemination Learning Objectives Define PowerPoint program Launch/start PowerPoint program Create PowerPoint presentation Format text of a PowerPoint presentation Add clip art and pictures in PowerPoint presentation Add charts, diagrams and tables in presentation Add AutoShapes, WordArt and hyperlinks in presentation Create animate slides Add transitions to a presentation Print a PowerPoint presentation Define PowerPoint PowerPoint is a software package designed to create electronic presentations consisting of a series of separate pages or slides. Sometimes abbreviated as PP or PPT This program developed by Microsoft Corporation It is a standard component of the company's Microsoft Office suite software, and is bundled together with Word, Excel and other Office productivity tools. PowerPoint versions PowerPoint 2003 (version 11) (Office 2003) PowerPoint 2007 (version 12) (Office 2007) PowerPoint 2010 (version 14) (Office 2010) PowerPoint 2013 (version 15) (Office 2013) PowerPoint 2016 (version 16) (Office 2016) PowerPoint 2019 (version 16) (Office 2019) PowerPoint 2021 (version 16) (Office 2021) Launch/start PowerPoint in Windows 7 You may use one of the following methods: Click the Start button on the Windows taskbar, then select All Programs, Microsoft Office, PowerPoint. If PowerPoint has recently been used on the computer or has been pinned to the Start Menu, it will appear on the first Start menu list. If so, click the shortcut to start the program. If PowerPoint has been pinned to the taskbar, the PowerPoint icon will be displayed after the Start button on the taskbar. Click the PowerPoint icon to start the program. If available, you may also double-click the PowerPoint shortcut on the Windows Desktop. Launch/start PowerPoint in Windows 8, 10, 11 From the Start screen, click or tap the PowerPoint tile. You will then switch to the Desktop, where PowerPoint runs. From the All Apps screen, click or tap the PowerPoint icon. You will then switch to the Desktop, where PowerPoint runs. On the Desktop, click the PowerPoint Quick Launch icon in the taskbar. 6 PowerPoint window elements (2007) A. Office Button Used to open a new presentation, save the presentation, and access PowerPoint options. B. Quick Access Toolbar Also known as the QAT, this is a customizable toolbar placed by default next to the Office Button, you can add icons for your often used commands to this toolbar C. Title bar This shows the title/name of your presentation and program that you are using D. Close button Used to close the current presentation E. Ribbon The Ribbon has tabs which in turn contain groups of buttons for various options, some groups also contain galleries (for example galleries for Themes and Theme Colors) F. Slide Area Used to display the active slide G. Notes pane Is where you input speaker notes for the current slide. None of this content is visible on the actual slide while presenting, although it is visible in both Notes Page view and Presenter view. H. Zoom button This shows the title/name of your presentation I. View button Used to view presentation in different views (normal view, slide sorter view and slideshow) J. Status bar Shows messages and information about the view, such as the slide number and the current theme template used. K. Outline tab Used to view presentation text and edit it L. Slide tab Used in normal view to navigate from one slide to another PowerPoint window (2013 – 2021) Create PowerPoint presentation To begin working with PowerPoint, you will need either to open an existing presentation or create a new one. They are 3 ways of creating PowerPoint presentations Create a PowerPoint Presentation Using a Template Create a PowerPoint Presentation from Blank Slides Create a PowerPoint Presentation from a Word Outline I. Create a PowerPoint Presentation from blank slides Step 1.From the File menu, select New. (In Microsoft 2007, select the Microsoft Office button and click New.) Step 2. Double Click Blank Presentation or (Select blank presentation and click create button) II. Create a PowerPoint Presentation using a template Step 1. From the File menu, select New. (In Microsoft 2007, select the Microsoft Office button and click New.) Step 2. Double Click one of the templates or (Select template you want and click create button III. Create a PowerPoint Presentation from word outline In Word 2007-2022, you will need to add the “Slide from outline" option to the "Quick Access Toolbar." Click the arrow at

Computer Applications, Optometry Notes, Optometry Semester 1

Microsoft Excel

/

OPTOMETRY · SEMESTER 1 Microsoft Excel Computer Applications START READING NOTES Contents of This Topic Related tasks Advantages of MS EXCEL Disadvantages of MS EXCEL MS General Features Outlines Microsoft Excel Introduction MS Excel General overview There are various ways to navigate through a worksheet: Selecting Cells, Rows, and Columns Editing & Formatting Worksheets Formatting Numbers Inserting Rows and Columns Deleting Rows and Columns Changing Column Widths Changing Row Heights Hiding Rows and Columns Unhiding Rows and Columns Selecting Worksheets Navigating Between Worksheets Renaming Worksheets Inserting Worksheets Deleting Worksheets Moving Worksheets Copying Worksheets MS Excel Views -The Normal View MS Excel Views – Page Layout View MS Excel Views – Page Break Preview View MS Excel Views – Custom Views Allows you to save a set of display and print settings as a custom view, and then apply it. Freezing and Unfreezing Panes Using Templates MICROSOFT EXCEL Related tasks Meaning of MS excel Advantages and Disadvantages of MS EXCEL MS General Features General overview of MS Excel Advantages and Disadvantages of MS EXCEL Advantages of MS EXCEL i. The Best Way to Store Data ii. It perform calculations iii. It has all the tools for data analysis iv. Easy to make data visualizations with charts v. You can print reports easily vi. It has So many free templates to use vii. You can save the document in different formats viii. It Store data with millions of rows Disadvantages of MS EXCEL Difficult to Learn ii. Difficult Formulas application iii. No Quick Autofill features iv. Calculation Errors MS General Features title bar quick access tool bar Menu bar standard toolbar Formatting toolbar active cell columns header rows header document view worksheet MS General Features MS General Features Outlines Introduction MS Excel General overview Moving Around Worksheets Selecting Cells, Rows, and Columns Editing & Formatting Worksheets Formatting Numbers Inserting Rows and Columns Deleting Rows and Columns Changing Row Heights Changing Column Widths Hiding and Unhiding Rows and Columns Selecting Worksheets Navigating Between Worksheets Renaming Worksheets Inserting Worksheets Deleting Worksheets Moving Worksheets Copying Worksheets MS Excel Views The Normal View Page Layout View Page Break Preview View Custom Views Full Screen View Freezing Panes Using Templates Microsoft Excel A spreadsheet: is a table of values arranged in rows and columns; the intersection of a Row & Column is called a Cell. Each cell can have a predefined relationship to the other cells. If you change the value of one cell, the values in the other cells may also be changed according to their relationships with that cell. Introduction Introduction Excel is the MS-Office Application program used for creating spreadsheets. You can use Excel to enter all sorts of data and perform financial, mathematical, or statistical calculations. Excel operates like other MS Office programs and has many of the same functions and shortcuts as MS Word & MS PowerPoint. Excel is more widespread, quick, and easy. MS Excel General overview An Excel file or a workbook: is composed of a number of worksheets (could be more than 200) MS Excel General overview An Excel file or a workbook: is composed of a number of worksheets (could be more than 200) Sheet tabs: each tab represents a different worksheet in the workbook. MS Excel General overview An Excel file or a workbook: is composed of a number of worksheets (could be more than 200) Sheet tabs: each tab represents a different worksheet in the workbook. Active Worksheet MS Excel General overview An Excel file or a workbook: is composed of a number of worksheets (could be more than 200) Sheet tabs: each tab represents a different worksheet in the workbook. Active Worksheet Row headers MS Excel General overview An Excel file or a workbook: is composed of a number of worksheets (could be more than 200) Sheet tabs: each tab represents a different worksheet in the workbook. Active Worksheet Row headers Column headers MS Excel General overview An Excel file or a workbook: is composed of a number of worksheets (could be more than 200) Sheet tabs: each tab represents a different worksheet in the workbook. The Active Cell: is the selected cell, and has a thicker black border around it. Active Worksheet Row headers Column headers MS Excel General overview The Name Box: displays the active cell address or the name of the selected cell, range, or object. An Excel file or a workbook: is composed of a number of worksheets (could be more than 200) Sheet tabs: each tab represents a different worksheet in the workbook. Active Worksheet The Active Cell: is the selected cell, and has a thicker black border around it. Row headers Column headers MS Excel General overview The Name Box: displays the active cell address or the name of the selected cell, range, or object. Formula Bar: displays the data or formula stored in the active cell. An Excel file or a workbook: is composed of a number of worksheets (could be more than 200) Sheet tabs: each tab represents a different worksheet in the workbook. Active Worksheet The Active Cell: is the selected cell, and has a thicker black border around it. Row headers Column headers There are various ways to navigate through a worksheet: Use the mouse and the scroll bars to scroll through the worksheet in any direction. Use the navigational keys on the keyboard: Down arrow or Enter: for moving the active cell one cell down. Up arrow or Shift+ Enter: for moving the active cell one cell up. Right arrow or Tab: for moving the active cell one cell to the right. Left arrow or Shift+Tab: for moving the active cell one cell to the left. Page Down for moving the active cell down one page. Page Up: for moving the active cell up one page. Alt+Page Down: for moving the active cell right one page. Alt+Page Up: for moving the active cell left one page. Ctrl+Home: for moving the active cell to cell A1. Ctrl+End: for moving the active cell to the

banner
Scroll to Top