--:-- --

↓ Scroll for more

Unit 3.2

Formulas and Functions I

PRC 110: Software Skills Practicum

Learning Objectives

Write formulas starting with `=`.
Use SUM, AVERAGE, MAX, MIN, COUNT.
Use basic Text & Date functions.

Anatomy of a Formula

All formulas start with `=`.

    `+` `-` `*` `/` `^`
Example: `=(A1+B1)*0.1`

Check: Formula Basics

Ask a student or group first — then click to check.

Essential Functions

`=SUM(A1:A10)`
`=AVERAGE(A1:A10)`
`=MAX` / `=MIN`
`=COUNT(A1:A10)`

Text & Date

`UPPER` / `LOWER` / `PROPER`
`CONCAT` or `&`
`TODAY()` / `DATEDIF`

Check: Which Function?

Ask a student or group first — then click to check.

Practicum 3.2

Grade calculation

Use student_grades.csv:

SUM total marks; AVERAGE; MAX; MIN.
Optional: PROPER on names; TODAY() in a header cell.