---
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