Martin O'Hanlon
I love technology and creating projects and learning resources for Raspberry Pi. As a child I wanted to be either a computer scientist, astronaut or snowboard instructor.
Location UK
Activity
-
Martin O'Hanlon replied to John Maguire
>Not consciously; but do when using bank cards and online banking so that the connection is secure
Indeed, in recent times most of our interactions online are encrypted.
-
Martin O'Hanlon replied to Collins Tuoyo
Hi, how can I help? Is there something you are struggling with? How can I point you in the right direction?
-
Welcome
-
Martin O'Hanlon replied to amani kayed
> No i do not use encryption.
You will find later on in the course that encryption is a part of modern life but most of the time you are using it passively.
-
Martin O'Hanlon made a comment
Hi, I am Martin, I work as an educator at the Raspberry Pi Foundation and I will be around until the 30th September to help answer any questions and offer support.
-
Martin O'Hanlon replied to Aaryan W
That is a great example.
-
@TinaHagar Hi Tina, as an alternative which may help you here is a video lesson we created for Oak National Academy on number bases which includes a section on converting denary to binary.
https://classroom.thenational.academy/lessons/number-bases-c4rkac
-
Martin O'Hanlon replied to Steph Tsang
@StephTsang @DianeDowling Unfortunately I couldnt find a link to the original paper, but I have updated the course to link to Pam Hook's website and inparticular the section on SOLO taxonomy which includes the same information and resources.
-
Martin O'Hanlon replied to Tina Hagar
I’m here :)
-
Hi Tina, how can I help? Was there something specific you struggled with? The process of converting number bases (e.g. denary to binary) can be a little daunting the first time.
-
Martin O'Hanlon replied to Tina Hagar
Hi Tina, I have fixed the link to the survey form. Apologies.
-
Martin O'Hanlon made a comment
Welcome to the course. Im Martin, an educator from the Raspberry Pi Foundation, and will be joining you until the 16th August to help facilate the course.
-
Martin O'Hanlon replied to Johanna Kambuka
it got me thinking about decisions that have to be made about what tables you will choose to have, and there are different choices you could make.
Indeed. Database design would be a complete course in itself. The database concepts on Isaac Computer Science has some content you might find interesting. https://isaaccomputerscience.org/concepts/data_dbs_concepts
-
my craft supplies e.g sewing patterns, knitting patterns, fabric, wool, threads etc, .
I need a database to store my tools and spare parts. I have lost count of the numbers of time I have purchased something new because I forgot I already had one.
-
Martin O'Hanlon replied to Shaun Miller
Once the sale_id record 1 had been deleted there was no existing primary key with the id of 1 so you were able to use it again. In this particular database the only constraint is that the primary key should be unique.
-
Welcome
-
@RichardNicholls I have finished now, we facilitate courses 1 month in every 3. I keep an eye on notifications though, so if you need support please feel free to @ me.
-
Martin O'Hanlon replied to Asmaa Nouali
Why can’t a primary key be modified once it’s created?
It comes down to the database managing consistency. The primary key identifies an individual row and may also be used in other tables to reference this row.
or re-used in case we deleted the record in which it was used ?
This tends to come down to the DBMS being used. Some do allow primary…
-
Martin O'Hanlon replied to Emma Davison
I find myself pondering “what is the database”? Is it the software you use to access it? Is it the file where the data is stored? Both? Or an abstract concept!
Anyway… enough of that.
Almost all relational databases consist of 2 component parts:
- the data and
- the RDMS (relational database management system)
… you may remember this being…
-
does this mean that if i was buidling a database and i realised i had a field which would end up having repeated information in it that this information should always be stored in a different table?
The process of removing duplicate data is known as “normalisation”. This introductory course doesnt cover normalisation or the complexities of database design…
-
Martin O'Hanlon replied to Emma Davison
Great examples. In practice a RRP (recommended retail price?) would probably use a real rather than an integer so decimal points could be stored.
-
Martin O'Hanlon replied to Rosemary Milsome
Hi Rosemary, Is there anything I can help you with? Did you manage to download and open the database?
-
Martin O'Hanlon replied to Shaun M
For the Manufacturer table you could add whether it’s a publicly traded company or not. You could use an integer as the type.
Is your thinking here that you would use a
1for “it is a publicly traded company” and0for it isnt? If so a boolean could also be used. The benefit of a boolean is that the database would only accept a True or False, whereas… -
Martin O'Hanlon replied to Eduard Gafton
The database does also includes the information which will tell you whether the company is still trading. Have a look at the
manufacturertable. -
Martin O'Hanlon replied to Stuart Gibbs
Great example.
My initial thoughts were “would it have been better expressed as”:
WHERE cores > 0;… but I think this is just the defensive programmer in me. I cant think of a scenario where a computer would have 0 or negative cores!
-
Martin O'Hanlon replied to Priyadarisini Ravi
Hi, I have just downloaded the latest version of DB Browser from https://sqlitebrowser.org/dl/ and installed it without an errors. This issue isnt something I have seen reported before, other than redownloading and trying again, I dont know what else to suggest.
You can of course use https://sqliteonline.com/ if you arent able to install DB Browser.
-
Martin O'Hanlon made a comment
Hi, I am Martin and a member of the Raspberry Pi team. I will be facilitating this course from 4th July 2022 to the 1st August. I hope you enjoy the course and learning about Databases and SQL.
-
Martin O'Hanlon replied to Andy Moxon
Great insights, thank you for sharing.
-
Martin O'Hanlon replied to Andy Moxon
> The question for me is how to excite the teachers to be confident about a subject they have had very little (if any) contact with.
I think exposure is really important, giving teachers an opportunity to see how the subject can be taught and how to engage student.
-
Martin O'Hanlon replied to Werdha Asim
Thank you. We had failed to update the backlink in the course. I have updated it now. We have got your survey. Apologies
-
Martin O'Hanlon replied to Clare Wadsworth
Thank you. We had failed to update the backlink in the course. I have updated it now. We have got your survey. Apologies
-
Great examples, thank you for sharing.
-
Hi Andy, welcome. I would be really interested in hearing more about your work.
-
> to a child who’s not familiar with a certain technology and creates a fear
I think this is important to break down. I have experienced many children who are worried they will "break it".
-
Martin O'Hanlon replied to Werdha Asim
> communication is totally different from 15 years ago
Communication is the big change I recognise
-
> sharing pictures instantly, video calling friends and family all over the globe
great examples which are particularly relevant since the pandemic.
-
Thanks for sharing, great insight.
-
Martin O'Hanlon replied to Anna Clark
Youre welcome.
-
Martin O'Hanlon replied to Laura Lambert
> I think it is brilliant that the children have a free reign of what kind of project that create.
Me too
-
I also think it can be really helpful to draw comparisons between algorithms and coding and the processes in their life.
-
Thanks for sharing. Hopefully we can support you in gaining confidence. Feel free to call out if you feel you need anything.
-
Martin O'Hanlon replied to Sarah Cole
> it can make the maths "come to life".
This is something I have seen many learners struggle with too.
-
Thank you for your insight.
-
I really like your example. It feels like an activity which could be extended for those student who wish to learn more.
-
Martin O'Hanlon replied to Amy Jeffrey
Great examples, thank you
-
Hi Tim.
-
Welcome Sara
-
Welcome Tracey
-
Martin O'Hanlon made a comment
Hi, I am Martin, I will be around to help facilate this course from now until the 1st July. I hope you enjoy the course.
-
Hi Kimberly, this course would definetly increase your knowledge around programming, networking and protocols. If you are looking for a networking fundamentals course I would recommend our “An Introduction to Computer Networking for Teachers” course (https://www.futurelearn.com/courses/introduction-to-networking/11) - you can sign up and take the course now.
-
Martin O'Hanlon replied to Murray Belchamber
Interesting. I just downloaded the PDF and tested the link and was successfully taken to https://isaaccomputerscience.org/concepts/sys_bool_useful_circuits
-
Martin O'Hanlon replied to John Sloman
@MurrayBelchamber John was referring to the draughts board
-
Martin O'Hanlon replied to John Sloman
Was this deliberate to see if anyone was awake?
No, just a mistake. It has never been reported before. Thank you for letting us know. I have updated the content.
-
Thats a great example. Thank you
-
Welcome Mark
-
@MarkWeddell I really like the idea of offering users a choice
-
Martin O'Hanlon replied to Leigh Sinderson
I have found weather examples work quite well too. I find that its important to move onto “digital” examples relatively quickly though to give more concrete examples.
-
Looks great, thank you for sharing
-
Martin O'Hanlon replied to Murray Belchamber
I just followed the link. Yes it goes to the FutureLearn knowledge bank which includes an example.
-
Martin O'Hanlon replied to John Sloman
I quietly talked this through to myself, in the same way I understand that some programmers talk through code to a plastic bath duck!
I think this is a great strategy. How did it work for you?
-
Martin O'Hanlon replied to John Sloman
Thanks for sharing.
-
Martin O'Hanlon replied to John Sloman
You could upload it to a cloud storage site like dropbox, google drive or onedrive and share a link.
-
Martin O'Hanlon replied to Craig Brewer
Welcome Craig.
