Scribd
Upload
8 views42 pages

L0excel Methodology

The document outlines a methodology for teaching various skills related to ethics, office automation, laboratory behaviors, and report writing. It includes specific tools and software like LibreOffice Calc and Impress for data representation and analysis, as well as instructions for calculating mean and standard deviation in Excel. Additionally, it emphasizes the importance of clarity and organization in practical work documentation.

Uploaded by

hacizademelahet66
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views42 pages

L0excel Methodology

The document outlines a methodology for teaching various skills related to ethics, office automation, laboratory behaviors, and report writing. It includes specific tools and software like LibreOffice Calc and Impress for data representation and analysis, as well as instructions for calculating mean and standard deviation in Excel. Additionally, it emphasizes the importance of clarity and organization in practical work documentation.

Uploaded by

hacizademelahet66
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

L0 Methodology

Outline (2/2)
Notions and
Associated requiered skills Support Teacher # sessions # week
contents
Ethics / Respect to other
academic 5 8
Engagement
honesty
Represent the graph associated with a series of measurements
LibreOffice Calc
using a spreadsheet
Office Create a presentation LibreOffice Impress
6 10
automation Exploit a series of measurements dependent of a physical
LibreOffice Calc
quantity : histogram, mean and standard deviation
Use scientific calculator
Learn the basic rules of security
Laboratory Learn how to recognize reagents
PW Room 7 12
behaviors The waste management
Learn the basi first aid behaviors in case of accident
How to write an experimental procedure
8 13
Present How to use a notebook with efficiency during a Practical Work
written Practical work of report writing and exam writing PW report tutorial
content Follow basic rules for clarity (write on lines, highlight results, use
during Pws ruler, different colors,…)
Make proper schematic to describe a situation LibreoOffice Draw
Second part
Excel/ calc (formulas/graphs)
• exercise_excel_methodology.xlsx
standard deviation
• The standard deviation tells how much the data is clustered around the mean of the data.
• Suppose that we have the data of 25 employees.
• Now to make the Standard Deviation graph, we will need probability distribution of each number in data.
• To calculate probability distribution in excel, we will need mean and standard deviation.
• Preparing Data For Standard Deviation Chart (Graph) or Bell Curve
• to plot a bell graph or say standard deviation chart of this, we first need to calculated the Mean of data,
and standard deviation in excel.
• To calculate mean, use AVERAGE function
•
To calculate standard deviation of entire population use STDEV.P
• Now, we can calculate Normal distribution.
Use NORM.DIST function.
• Copy the formula
• Use excel charts to get the bell curve.
Modify the standard deviation: reduce and increase …

• If we reduce the standard deviation, the bell


curve will be more lean toward the mean of
data.

You might also like