There have been a few times now that I have wanted to do something in Google spreadsheets that I know exist in Excel. However, that functionality doesn't exist yet in Google. So my answer....make it yourself.
I have found that there are thousands of people worldwide who are creating cool scripts and formulas to upgrade the functionality and use-ability of Google Spreadsheets - so Google it and find their awesomeness!
Watch the following 'How To' to show you how you can create your own formula for Google Spreadsheets and how I use a particular formular that I love: 'Count Coloured Cells'.
Showing posts with label Google Spreadsheets. Show all posts
Showing posts with label Google Spreadsheets. Show all posts
Thursday, 6 June 2019
Wednesday, 8 May 2019
Google Spreadsheets: Using COUNTA and COUNTIF
There are many times that I need to create a spreadsheet that houses the organisation of school wide events like Fiafia or even a camp. One of these sheets that I create often is a payment sheet to track who has paid, who has handed in their permission/ medical forms and if I have emergency contact details for any child.
What I hate with these types of sheets is not being able to know at a glance - especially when they get large like our year 5&6 camp (around 150 kids) you can't tell easily how many kids you need to follow up. So I use the two formulas to do this for me: COUNTA and COUNTIF.
Check out this screen recording to learn how to do it.
What I hate with these types of sheets is not being able to know at a glance - especially when they get large like our year 5&6 camp (around 150 kids) you can't tell easily how many kids you need to follow up. So I use the two formulas to do this for me: COUNTA and COUNTIF.
Check out this screen recording to learn how to do it.
Wednesday, 20 March 2019
Google Spreadsheets: Data Analysis Using VLOOKUP
I thought it would be worthwhile reposting this as it relates to what I'm working on this year.
A few years ago as part of my inquiry into teaching I had been looking into ways I could better use assessment to inform my next teaching steps, especially to jump on opportunities sooner. However, when ever I got anywhere near formative data it was spread out across a range of different places -
e-asTTle, NZCER, etc. I needed an easy way to collect this data. Aha! Use a spreadsheet someone told me. However this meant doing hours of copy and paste from other spreadsheets to then have it collated in mine!
This lead me to look at using some of the features of spreadsheets. By using a simple VLOOKUP formula I have been able to set up each sheet to go looking for data for me. There is no more need to copy and paste a whole lot of information anymore!
Check out the below screencast of me explaining the setup of a spreadsheet and how this has streamlined my data gathering and analysis.
A few years ago as part of my inquiry into teaching I had been looking into ways I could better use assessment to inform my next teaching steps, especially to jump on opportunities sooner. However, when ever I got anywhere near formative data it was spread out across a range of different places -
e-asTTle, NZCER, etc. I needed an easy way to collect this data. Aha! Use a spreadsheet someone told me. However this meant doing hours of copy and paste from other spreadsheets to then have it collated in mine!
This lead me to look at using some of the features of spreadsheets. By using a simple VLOOKUP formula I have been able to set up each sheet to go looking for data for me. There is no more need to copy and paste a whole lot of information anymore!
Check out the below screencast of me explaining the setup of a spreadsheet and how this has streamlined my data gathering and analysis.
Subscribe to:
Posts (Atom)