techiereader

Excel Instructional Tool: Excel for Nurses

1.) What is Microsoft Excel?

Microsoft Excel is an electronic spreadsheet application that enables users to store, organize, calculate and manipulate the data with formulas using a spreadsheet system broken up by rows and columns. It also provides the flexibility to use an external database to do analysis, make reports, etc. thus saving lots of time.

2.) What is ribbon?

Ribbon refers to the topmost area of the application that contains menu items and toolbars available in MS-Excel. Ribbon can be shown/hidden using CTRL+F1. The ribbon runs on the top of the application and is the replacement for the toolbars and menus. The ribbons have various tabs on the top, and each tab has its own group of commands.

3.) Explain Spreadsheet and its Basics.

Spreadsheet can be compared to a paper ledger sheet. It consists of rows and columns and their intersection called cells.

4.) How many data formats are available in Excel? Name some of them.

Eleven data formats are available in Microsoft Excel for data Storage. Example:

Number – Stores data as a number
Currency – Stores data in the form of currency
Date – Data is stored as dates
Percentage – Stores numbers as a percentage
Text Formats – Stores data as string of texts

5.) Specify the order of operations used for evaluating formulas in Excel.

The order of operations in Microsoft Excel is same as in standard mathematics. It’s defined by the term “PEMDAS” or “BEDMAS”.

Parentheses or Brackets
Exponent
Multiplication
Division
Addition
Subtraction

6.) What are three report formats that are available in Excel?

Following are the types of report formats

Compact
Report
Tabular

7.) Can we create shortcuts to Excel functions?

Yes. ‘Quick Access Toolbar’ above the home button can be customized to display most frequently used shortcuts.

8.) To move to the previous worksheet and next sheet, what keys will you press?

To move to the previous worksheet, you will use the keys Ctrl + PgUp, and to move to the next sheet you will use keys Ctrl + PgDown.

9.) What is the benefit of using formula in Excel sheet?

Calculating the numbers in Excel sheet, not only help you to give the final ‘sum up’ of the number but, it also calculates automatically the number replaced by another number or digit. Through Excel sheet, the complex calculations become easy like payroll deduction or averaging the student’s result.

10.) What is the use of LOOKUP function in Excel?

In Microsoft Excel, the LOOKUP function returns a value from a range or an array.

11.) Shortcuts in Microsoft Excel

12.) Application of Microsoft Excel for Nurses

Excel is a powerful tool for keeping track of patient appointments, scheduling doctors, and organizing other information, such as contact numbers or insurance data. Many clinics, hospitals and practitioners use Excel for these functions. Anyone seeking a career in medical office administration must take Excel as part of their curriculum. Excel can also be used to keep track of medications, prescriptions and other health information. Some doctors are providing patients with a spreadsheet to keep track of their health records. It’s a very helpful way to ensure that patients who have to take medications on a schedule can follow that plan.

References:

https://www.cogniview.com/blog/when-accurate-data-means-the-difference-between-life-and-death/

https://www.guru99.com/microsoft-excel-interview-questions-answers.html

https://exceljet.net/lessons/how-to-enter-data-in-excel

https://exceljet.net/excel-functions/excel-lookup-function

https://magoosh.com/excel/quick-access-toolbar-excel/

https://support.office.com/en-us/article/create-a-simple-formula-in-excel-11a5f0e5-38a3-4115-85bc-f4a465f64a8a

https://www.howtogeek.com/361582/all-the-best-microsoft-excel-keyboard-shortcuts/

https://www.smartsheet.com/how-to-make-spreadsheets

JUST IN: Filipino in South Korea tests positive for COVID-19 — DOH

A Filipino tested positive for coronavirus disease 2019 (COVID-19) in South Korea, according to the Department of Health (DOH) on Monday.

“Mayroon pong ibinibigay sa aming impormasyon kahapon na mayroon ho tayong nag-positive na case sa South Korea. Pero ‘yung buong detalye po ay hindi pa natin nakukuha,” Health Assistant Secretary Maria Rosario Vergeire said in an interview on GMA News’ Unang Balita.

South Korea raised its virus alert to the highest level on Sunday as the number of confirmed cases within its borders reached over 600—the highest outside China, aside from the virus-hit Diamond Princess cruise ship docked in Japan.

Vergeire added there is also one infected Filipino in Singapore, two in the United Arab Emirates, and one in Hong Kong.

Source: GMA NEWS ONLINE

Italy battles ‘explosion’ of COVID-19 cases as third patient dies

MILAN – Italy raced on Sunday to contain the biggest outbreak of coronavirus (COVID-19) in Europe, sealing off the worst affected towns and banning public events in much of the north as a third patient died of the illness.

Authorities in the wealthy regions of Lombardy and Veneto, which are the focal point of the flare-up, ordered schools and universities to close for at least a week, shut museums and cinemas and called off the last two days of the Venice Carnival.

The civil protection unit said the number of cases of the highly contagious virus totalled 152, all but three of them coming to light since Friday.

“I was surprised by this explosion of cases,” Prime Minister Giuseppe Conte told state broadcaster RAI, warning that the numbers would likely rise in the coming days. “We will do everything we can to contain the contagion,” he said.

The latest death was an elderly woman from the town of Crema, some 45 km (28 miles) east of Italy’s financial capital Milan. Like at least one of the other people who have died, she had been suffering from serious underlying health issues, officials said.

Source: GMA NEWS ONLINE

What Nurses Need to Know

Preparedness, Early Identification, and Notification
Develop and educate all staff on a preparedness plan that provides infection control procedures and protocols used within your healthcare facility for the early identification, containment, and care of patients with symptoms associated with Coronavirus Disease (COVID-19) to prevent spread within your healthcare facility.
Develop inpatient, ambulatory, and home care policies and procedures that are in line with current CDC guidelines for COVID-19
- Provide training to all personnel on screening and isolation procedures
- Provide updated training and guidelines on the use of Personal Protective Equipment (PPE), such as the use of gloves, gowns, masks, eye protection, and a face shield
- Display clear signage with instructions for the use of PPE
- Ensure consistent use of proper hand hygiene, standard precautions, contact precautions, and airborne precautions, along with the proper use of a National Institute for Occupational Safety and Health (NIOSH)-Approved N-95 respirator or higher
- Clearly display signage for patients that lists symptoms and instructions to wear a face mask before entering the healthcare facility if symptoms are present.
- Incorporate assessment questions to document a detailed travel history when patients present with fever, cough, or respiratory illness. Consider COVID-19 if the patient traveled to China within the last 14 days.
- Identify, in advance, airborne infection isolation rooms (AIIR) or negative pressure rooms, for quarantine and screening
- Outline staffing protocols to facilitate care of patients with COVID-19 and to minimize patient-to-patient transmission
- Have available for immediate notification of Patient’s Under Investigation (PUI) the infection control personnel at your facility and the local and state health department. Click here for additional Recommendations for Reporting, Testing, and Specimen Collection and the fillable COVID-19 PUI case investigation form
- For Patients Under Investigation (PUI), follow the Criteria to Guide Evaluation of PUI for COVID-19
Isolation, Quarantine, Monitoring, and Hospitalization
The CDC recommends several steps for identification and maintenance of COVID-19 along with detailed guidelines for isolation precautions to prevent transmission. Have clearly displayed a flowchart for early identification and assessment of COVID-19 At this time, the exact mode(s) of transmission remain undetermined, but person-to-person transmission has been identified.
Have masks available for PUI to don before entering the healthcare facility
1. Once identified, isolate the patient to airborne infection isolation rooms (AIIR) or negative pressure room and keep the door closed. Conduct the assessment in this room.
2. Healthcare personnel entering the room should use standard precautions, contact precautions, airborne precautions, and eye protection (goggles or a face shield)
3. Don Personal Protective Equipment (PPE) before entering the room
4. Have guidelines for the proper use of PPE displayed throughout the healthcare facility
5. Notify your infection control personnel and the local and state health department of suspected cases
How to Educate Your Patients and Minimize Spread within the Community
Per the CDC, it is known that coronavirus is part of a large family of viruses that can cause illness in people and animals. While the mode(s) of transmission of COVID-19 remain under investigation, the CDC provides the following interim guidance to help prevent COVID-19 from spreading among people in homes and communities:
- Stay home except to get medical care, do not use public transportation or taxis
- Call first before visiting your healthcare provider to notify of the need for evaluation for COVID-19. Follow the instructions provided by your healthcare team.
- Separate yourself from other people in your home, utilize a separate bathroom
- Wear a facemask
- Cover your coughs and sneezes
- Wash your hands frequently with soap and water for at least 20 seconds
- Avoid sharing household items
- Monitor your symptoms

Source: American Nurses Association

COVID-19: What’s new?

COVID-19: Cases Begin to Mount

Centers for Disease Control and Prevention (CDC): Development of a new laboratory test kit

CDC has developed a new laboratory test kit for use in testing patient specimens for severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2), the virus that causes COVID-19. The test kit is called the “Centers for Disease Control and Prevention (CDC) 2019-Novel Coronavirus (2019-nCoV) Real-Time Reverse Transcriptase (RT)-PCR Diagnostic Panel.” It is intended for use with the Applied Biosystems 7500 Fast DX Real-Time PCR Instrument with SDS 1.4 software. This test is intended for use with upper and lower respiratory specimens collected from persons who meet CDC criteria for COVID-19 testing. CDC’s test kit is intended for use by laboratories designated by CDC as qualified, and in the United States, certified under the Clinical Laboratory Improvement Amendments (CLIA) to perform high complexity tests. The test kits also will be shipped to qualified international laboratories, such as World Health Organization (WHO) Global Influenza Surveillance Response System (GISRS) laboratories. The test will not be available in U.S. hospitals or other primary care settings. The kits will be distributed through the International Reagent Resourceexternal (IRR)

This is a picture of CDC’s laboratory test kit for the coronavirus disease 2019 (COVID-19).

Source: Centers for Disease Control and Prevention

COVID-19: What to look for?

UPDATE: Number of Global Cases now stands at more than 77,000

There are 77,809 confirmed cases of novel coronavirus and 2,372 deaths worldwide, according to the latest figures. The vast majority of these infections are in mainland China but outside its borders there are 1,521 cases in 31 different places. Here’s the tally:

Japan: 738 cases, 3 deaths

South Korea: 433 cases, 2 deaths

Singapore: 86 cases

Hong Kong: 68 cases, 2 deaths

Thailand and United States: 35 cases each

Iran: 28 cases, 5 deaths

Taiwan: 26 cases, 1 death

Malaysia: 22 cases

Australia: 21 cases

Italy: 17 cases, 2 deaths

Vietnam and Germany: 16 cases each

France: 12 cases, 1 death