Sections

Expectations Day 1

https://stat-tech-analytics.shinyapps.io/Expectations_Excel

The conscious competent model

1️⃣ Unconscious Incompetence

  • “I don’t know what I don’t know.”
  • The individual is unaware of their lack of skill.
  • They might underestimate the complexity of the task.
  • Learning hasn’t started yet.

Example: A person doesn’t realize that managing lab data accurately requires strict data entry protocols.

2️⃣ Conscious Incompetence

  • “I know that I don’t know.”
  • The individual becomes aware of their skill gap.
  • They recognize mistakes and the need for improvement.
  • This is often a frustrating but crucial phase.

Example: After receiving feedback, a lab technician realizes they are inconsistent in documenting experiment results.

3️⃣ Conscious Competence

  • “I know how, but I have to think about it.”
  • The person can perform the task correctly but must focus deliberately.
  • Processes are followed carefully, often with step-by-step thinking.

Example: The technician correctly applies data entry standards but must follow a checklist consciously.

4️⃣ Unconscious Competence

  • “I can do it without thinking.”
  • The skill becomes second nature and automatic.
  • Performance is smooth and instinctive, often allowing the person to teach others.

Example: After months of practice, the technician naturally adheres to data accuracy protocols without needing reminders.

Day 1 : Excel 101

Keypad shortcuts

Formulas and Functions

https://docs.google.com/spreadsheets/d/17mC-uKaszxDLxQB5cS7ZoaaYyHT0sHtJ/edit?usp=sharing&ouid=114321043224196873955&rtpof=true&sd=true

A formula in Excel is used to do mathematical calculations. Formulas always start with the equal sign (=) typed in the cell, followed by your calculation.

It can also be used to calculate values using cells as input.

Practical example: BODMAS

Introducing functions ( autosum)

Absolute and relative referencing

Excel has two types of references:

Relative references Absolute references

Cells in Excel have unique references, which is its location.

References are used in formulas to do calculations, and the fill function can be used to continue formulas sidewards, downwards and upwards.

Functions

Formating

Freeze panes

Conditional Formating