---
title: Week 1 Tutorial
tags: COMP1010-22T1

---

# COMP1010: Week 1 Tutorial

## Introductions

Go around the class, share:
* Your name
* What year of uni you're in
* Either:
* A hobby/sport/activity you enjoy
* Your favourite Disney song

## The Importance of Order

Just like a recipe, the sequence in which we tell a computer to execute instructions is important.

<Tutor's choice of activity>

## Spreadsheets

### Spreadsheet Scenarios

* [H12A - Ellie](https://hackmd.io/1cIbnDyATe-3eLBh7KxmnA)
* [H12B - Will](https://hackmd.io/HcwAbl-TQlC08X1aqBdABQ)
* [H15B - Krishne](https://hackmd.io/npbqIo8xSOWSB-41rosVJQ)
* [W14B - Will](https://hackmd.io/SSeng0y_SRS0YK5i-XRc_w)

### Heights For Rides

**Background**
At a theme park, one needs to be tall enough to go on certain rides.

If you are 85cm-105cm tall, you are considered a "Red Rider" and may go on 9 rides. If you are 106cm-131cm tall, you are considered a "Green Rider" and may go on 21 rides. If you are 132cm or taller, you are considered a "Yellow Rider" and may go on 27 rides.

**Task**
Consider a spreadsheet application which allows a user to enter their height and tells the user which rider type they are and how many rides they can go on.

**Steps**
1. As a class, design at least 2 options for an interface for the application. Discuss the pros and cons of each design and choose one to implement.
2. Implement your spreadsheet application.

### Course Prerequisites and Exclusions

**Background**
At university, courses often have prerequisites and exclusions.

A prerequisite for a course is a course you must complete before you're allowed to enroll in the chosen course. This is usually because you need knowledge from the prerequisite in order to understand the content for the chosen course.

An exclusion for a course is a course that if you have completed the course, you're not allowed to enroll in the chosen course. This is usually because the two courses have very similar content, or the chosen course has simpler content than the exclusion course.

**Examples**

Course: MATH2121: Theory and Applications of Differential Equations
Prerequisites: MATH1231 or DPST1014 or MATH1241 or MATH1251 (first year maths courses that provide a foundation for MATH2121)
Exclusions: MATH2018, MATH2019, MATH2221 (courses with similar content to MATH2121)

Course: ARTS1451: Introductory Chinese B for Non-Background Students
Prerequisites: ARTS1450
Exclusions: ARTS1453

**Task**
Consider an application in which the user indicates which courses they've taken and indicates whether or not the user can enroll in specified courses.

**Steps**
1. Using the template provided [here](https://docs.google.com/spreadsheets/d/1FKIFHoPByJ0mWGEulTRGxzdYnHiOaeweHR6gctQKbi4/edit?usp=sharing), implement the spreadsheet to display "TRUE" or "FALSE" (you can do this using only `AND`, `OR`, and `NOT` functions) to indicate if a course is allowed to be taken or not.
2. Improve your application to display "Allowed" if it's allowed, and display nothing if it's not allowed (using the `IF` function).