<style> .reveal { font-size: 27px; } .reveal div.para { text-align: left; } .reveal ul { display: block; } .reveal ol { display: block; } img[alt=drawing] { width: 200px; } </style> # COMP1010 ## 2.2 Spreadsheets Revisited --- ## Demo 1: Splitting The Bill <img src="https://i.imgur.com/oKaLyN2.jpg" alt="https://i.imgur.com/oKaLyN2.jpg" height="500"/> --- ## Demo 1: Splitting The Bill | | | | -------- | -------- | | <img src="https://i.imgur.com/oKaLyN2.jpg" alt="https://i.imgur.com/oKaLyN2.jpg" width="1000"/> | <ul><li>Try as many things as possible: Sienna, Vivian, Nick, Hayden, Evan, Gabby, Emily, Sandeep</li><li>Vegan: Bart, Luke</li><li>Plain flavours only: Sim, Cliff </li></li> </ul> --- ## A Solution https://docs.google.com/spreadsheets/d/1-7nwzUUU34VRbF6fFHGugzthIU9GQVDEv47ciPLwK4k/edit?usp=sharing --- ## What do we need to know? * Who was in each group * What food each group ate <br> * The size of each group * The cost per person of each group * The amount each person owes based on the group they're in * (Don't forget the surcharge!) Note: all of this comes down to thinking computationally and thinking like a programmer --- ## Steps * Create groups * Allocate each person to a group * Allocate each menu item to a group * Calculate the cost-per-person, of each group based on the amount spent and the number of people in that group * Assign each person an amount to pay based on which group they're in --- ## Reflection * Could we make the same application as a web app using Python and Flask? * What would be some advantages to choosing Python and Flask? * What are some advantages to choosing spreadsheets? --- ## Demo 2: Personal Finance 1. Create a copy for yourself of the provided spreadsheet: [Personal Finance Spreadsheet](https://docs.google.com/spreadsheets/d/1q-JU4XesOWQNsHP4zC64WHQ21T_M4M-xIqJ7lXJsisk/edit?usp=sharing) 2. Create a table with a list of categories. The categories should include: * Internet * Groceries * Medical * Transport * Recreation * Eating Out * Clothes * Phone --- 3. Create an extra column in the table provided called Categories. Fill that column with dropdown menus allowing the user to select a category from the categories list. 4. Fill in the categories column. (Below is a list in case you're unfamiliar with some of the places.) * Internet (Exetel) * Groceries (Coles, Woolworths, Harris Farm, Aldi) * Transport (Ampol, BP, RMS EToll) * Recreation (Aquatic Centre) * Eating Out (Sushi, Kiosk, Fish and Chips, Time for Thai) * Clothes (Kmart, Bonds Online) 5. Select your table and create a Pivot Table to tell you how much money was spent in each category. ---