---
# System prepended metadata

title: 1.4 - Spreadsheets Activities
tags: [COMP1010]

---

---
title: 1.4 - Spreadsheets Activities
tags: COMP1010
slideOptions:
  transition: slide
---

# Spreadsheets Activities

## Activity 0: Grade Book

### Pre-activity (optional set-up):
* **Start:** 0-0-grade-book-pre-start

| #    | Task                                                                                                 | Hints               |
| --- | ---------------------------------------------------------------------------------------------------- | ------------------- |
|0| Create a list of unique student numbers so that each row of grades has an associated student number. | RANDBETWEEN, UNIQUE |


### Activity:
* **Start:** 0-1-grade-book-start

| #   | Task                            | Hints |
| --- | ------------------------------- | ----- |
| 1   | Sum marks (Ctrl-D to fill down) | SUM |
| 2   | Conditional formatting on totals | Format->Conditional Formatting  |
| 3   | Maximum and minimum mark achieved |MAX, MIN|
| 4   | Pass/Fail |IF|
| 5   | Grade: HD, DN, CR, PS, FL |External table, Nested IF|
| 6   | List of failing students |Data->Filter|
| 7   | Chart of students achieving each total |Insert->Chart|
| 8   | Chart of students achieving each grade |External table, COUNTS|

* **End:** 0-2-grade-book-end