Spread sheet and Modelling

• Technology
• Secondary Education

3.8.3 developing and using Modes and Simulations

What is a spreadsheet?

1. A an application software.
2. A sheet that is spread out.
3. A type of paper.
4. A google app.

What is a spreadsheet used for?

1. It is used to spread things.
2. Spreadsheets are used to organize your food.
3. They are used to edit data.
4. Used to process and perform calculations of raw data.

What is a formula in Spreadsheets?

1. Data
2. An expression which calculates the value of the cell
3. Value
4. Information

What is a Format?

1. Alphabetical or numeric text that will not be used in calculations.
2. ells the software what to do with operands in a formula.
3. Numeric characters that can be calculated in a spreadsheet.
4. Arranging the shape, size, type, and general makeup of a cell or document.

What is a column?

1. Data arranged vertically in a spreadsheet.
2. Data arranged horizontally in a sreadsheet.
3. It is a google format.
4. Data arranged horizontally in a spreadsheet.

How spreadsheets are used in different application?(use strand2)

What are the Social and ethical issues are there with spreadsheet

Activity

Medical centre budgets

Dr Schultz is the head doctor and manager at the Okavango Medical Center, Botswana. This medical centre is located eight hours away from the capital city, Gaborone. The medical centre is able to cope with routine cases, but when the doctors at the centre encounter an unusual case they have to communicate with specialists at the main hospital in Gaborone using either a

telephone or voice over internet protocol (VOIP). Currently the Okavango Medical Center does not have any medical equipment connected to the IT systems at the hospital in Gaborone in real time. When there are unexpected changes in a patient’s condition, this makes it hard to give the necessary information to specialists in Gaborone. Because of this, at times Dr Schultz has to ask a specialist doctor from Gaborone to come to Okavango Medical Center to carry out treatment. The area is becoming popular with tourists, and Dr Schultz is concerned that the doctors and nurses at Okavango Medical Center will be unable to treat the increasing number of patients. He believes Okavango Medical Center needs better equipment in order to improve patient care. Dr Schultz created a spreadsheet of the treatments carried out by the centre over a week.

A small part of the spreadsheet is shown below in Figure 1.

Figure 1: Part of Dr Schultz’s treatment record spreadsheet

Identify the steps that Dr Schultz must follow to list only the surgeries carried out by Dr Tirbau using the spreadsheet software.

Identify two reasons why Dr Schultz would use a spreadsheet instead of a database for record keeping.

Different type of charts

How was the class

😒🙁😐🙂😃