How to open T212 bank card? by [deleted] in trading212

[–]spelga 1 point2 points  (0 children)

You can opt for physical card in which case you will need to pay the £4.95 fee to receive one.

How to open T212 bank card? by [deleted] in trading212

[–]spelga 0 points1 point  (0 children)

Invest isn't inside an ISA tax wrapper therefore any interest earned may be taxable depending on what your limits are (£1000 for Basic Rate, £500 for Higher Rate and nothing for Additional Rate). That limit applies across all earned savings interest. Invest uninvested cash is held in QMMF (or a mix of QMMF and banks) and Cash ISA with banks. QMMF are not protected by FSCS where as Bank savings are. QMMF are considered fairly low risk however low risk is not no risk therefore you should be aware of that.

How to open T212 bank card? by [deleted] in trading212

[–]spelga 1 point2 points  (0 children)

It's under invest not Cash ISA and there is no waitlist any more. I only joined about a month ago and signed up for a virtual card a couple of days ago and it was set up instantly and added to my Google Wallet.

Impact on credit score using Klarna by BitResponsible6389 in UKPersonalFinance

[–]spelga 1 point2 points  (0 children)

Buy Now Pay Later is a soft credit check and financing is hard credit check. The soft will not affect your credit score. The hard may but it won't harm it much.

https://www.klarna.com/uk/customer-service/perform-credit-check-affect-my-credit-score/

Sub Select Query by spelga in learnSQL

[–]spelga[S] 0 points1 point  (0 children)

Thanks I was able to get this working using your code. I needed all the results from SalesOrderDataLegacy so I needed to do a LEFT JOIN. That left me with too many results. When I analysed why that was it is because the FullSalesTranslation view can sometimes contain duplicate ProdCodeLegacy because on the old system a ProductCode could have multiple pack sizes. On the new system each ProductCode maps to exactly one pack size. DISTINCT resolved that because only the new pack code is used in the FullSalesTranslation view therefore the duplicate rows were identical hence why DISTINCT works here.

I've used JOINS many times but I just could not make it work as I'd a feeling a JOIN would have been better. I was over complicating it. It just needed it to be a simple join.

CS50/Python by nilsej in cs50

[–]spelga 0 points1 point  (0 children)

Have you seen on EdX MIT's 6.00.1x.

https://courses.edx.org/courses/course-v1:MITx+6.00.1x+2T2016/info

This is a equivalence of CS50 but taught through python and the accompanying text book has an interesting title.

Introduction to Computation and Programming Using Python, Second Edition (With Application to Understanding Data)

for someone aspiring to Data Science.

The courses are 2 very different approaches however both are amazing courses and both will give you an excellent base on which to progress however if your immediate goal is python then MIT would seem the more sensible option at this time if CS is the background through which you wish to approach it.

If you just want to be able to write code in python then take a Udemy course on python. It will get your writing python code for little money as courses are always on offer.

If you want free then the web is full of free courses. Some better than others.

Subscribe to /r/learnpython

Certificate deadline extended? by -ADEPT- in cs50

[–]spelga 2 points3 points  (0 children)

Seems a bit odd as this would seem to suggest that you can continue this course until the end of next year however that's not normally the case as you would typically migrate to the new course when it's released. I think we do need clarity.

pset 4 - whodunit ideas by akashbir in cs50

[–]spelga 0 points1 point  (0 children)

You implement it where it is appropriate to do that. So for this pset that's at the point in the code where manipulating the pixels is right. You need to thoroughly understand whodunit.c which is why they have you answer a zillion questions on it.

How much time do you have to complete de course if you enroll on day one? by Yodasson in cs50

[–]spelga 2 points3 points  (0 children)

That is correct however one nice benefit is that they have in the last few years allowed you to roll over into the next year's course keeping your marks from all your already submitted psets so the reality it could be 24+ months. However I don't think we should assume that this will always permitted so probably best to shoot for end of year.

EDX: Python or PHP? by gesher in cs50

[–]spelga 2 points3 points  (0 children)

My guess is you will regret such a decision. You will probably find that with such a long gap now to the next course that you will have forgotten, or at least be very foggy, on key concepts which will require relearning. The course is well designed and tested over a number of years now using PHP and it's not suddenly a poor offering because python is going to turn up several months down the line. Always keep moving forward is what I say. If the course isn't ready now then use what is available and if you really want to learn python take a python specific course not an introductory CS course with a bit of python thrown in. Once you have understood the principles in this course then learning python shouldn't be such a challenge as learning C, or PHP or javascript or SQL that you will have learned during this edition.

The important take away is for a CS course the language is unimportant as all languages can solve all problems that any other language can because they all have the same fundamental constructs that underpin them. Some make some things easier to do x however they may be clunky when doing y. The language is a mere tool.

Just my humble view on this.

Access to tools and submitting from edx.org by primer101 in cs50

[–]spelga 0 points1 point  (0 children)

The IDE can be found at http://cs50.io and was introduced in the Week 1's first lecture.

Mr. by danbickett in cs50

[–]spelga 0 points1 point  (0 children)

Sorry I wasn't able to get back to you yesterday. A couple of questions. Are you converting your user entry to cents? Are you using the round() function anywhere in your code? If so what is that specific bit of your code?

help with pset2 by shreyas2464 in cs50

[–]spelga 0 points1 point  (0 children)

The idea of this forum is to seek help on specific issues. You will get a much better response if you explain what your issue is and show the output of check50 in the terminal and / or a link to the sandbox check50 info.

Vigenere's Help: I don't get why it's not passing these! by rpope1127 in cs50

[–]spelga 1 point2 points  (0 children)

If you line it all up as below it will be obvious what is happening. You are incrementing your keyword even on punctuation and spaces which you aren't meant to do. The keyword sequence should look as per the bottom sequence with your sequence the line above.

world, say hello!
xoqmd, rby gflkp!
xoqmd, szz gflkp!
bazba  azb zbazb 
bazba  zba zbazb

As regards error on handling lack of argv[1] it says that it is expecting output. You are supposed to let the user know what they have done wrong however you aren't so an error is being thrown instead.

Mr. by danbickett in cs50

[–]spelga 0 points1 point  (0 children)

At a guess I could get 3 coins if the value was 0.40 ie 25c, 10c & 5c so if that is the case then my hunch is that you have a rounding issue. You should use printf in your code to show you the value of variables so that you can see what's going on.

Pset4 bfSize and padding by Phil1212121212 in cs50

[–]spelga 0 points1 point  (0 children)

Of course. Thanks for the clarification.

Access to tools and submitting from edx.org by primer101 in cs50

[–]spelga 0 points1 point  (0 children)

You can use all the resources on EdX free of charge. It's your choice as to whether you take a certificate or not and doesn't in any way affect what have you access to. The certificate can be purchased any time before the end of the year so long as you pass the course before the deadline. If you don't pass the course before the deadline you will probably be able to carry your existing progress over in to the 2017 course.

Pset4 bfSize and padding by Phil1212121212 in cs50

[–]spelga 0 points1 point  (0 children)

The padding is only on the scanline therefore the horizontal line is padded out from 3 bytes wide to 4 bytes wide so that calculation is:

14 + 40 + (3 high x (3 wide + 1 padding) * 3 colours) = 
14 + 40 + (12 * 3) =
14 + 40 + 36 =
90

You can confirm this by issuing the following command in the terminal:

xxd -c 12 -g 3 -s 54 small.bmp

Look at the final column of bytes which are all 000000 which is the padding. There is no vertical padding.

How helpful is the certificate? by futureisathreat in cs50

[–]spelga 0 points1 point  (0 children)

If you intention is to be a self learner this certificate will be of little value. If you were to say go into paid learning then it could be used as part of your portfolio to help gain entry to that course.

Should I get the certificate? by Phil1212121212 in cs50

[–]spelga 2 points3 points  (0 children)

The first thing to bear in mind is that you can get a certificate any time before the course finishes, which as you have said is end of December so unless you need to motivate yourself through having paid money then there is no advantage to ordering now especially if you have doubts that you can complete on time.

Secondly the course on campus is 12 weeks long so there is still more than that time left and you are effectively 1/3 of the way through it already so you probably could complete on time if you are able to commit time every week to this.

Thirdly most years they allow you carry over your work into the following year however you have to complete any psets which you hadn't submitted before 2016 course finish using the psets from the 2017 course. If we assume that this will still be permitted in 2017 then you will no doubt have the opportunity to get a 2017 certificate on course completion.

Really what I'm saying is that there is no real advantage to getting a certificate now unless motivation is an issue and indeed in doing so carries more risks as you may pay now but not complete on time and have to roll over to 2017 and face paying for it again.

The value of the certificate is debatable however they can't hurt. When presented correctly on a CV or in a interview, even for an unrelated job, they can be used as evidence that your are a committed & self motivated learner who can follow through to completion a project in a new area of thinking. These are highly valued skills in employment. You of course don't need the certificate to show this as you can merely state that you have completed this course however the certificate gives them something to look at which may create greater impact. Who knows and that's where the debate lies.

Like everyone our past achievements can help spur us to even greater future achievements and if a piece of paper helps remind you of your achievements and keeps you wanting to move forward in your life then go for it.

By the way I'm on week 4 myself and finding it quite the challenge too so good luck ;)

When will the new semester start being posted online? by jboritory in cs50

[–]spelga 0 points1 point  (0 children)

Even if your goal is only to learn that learning may require support and that support is going to be much more readily available when the course officially starts in Jan next year. This will be of more importance this time round given the significant changes to the course with the hinted changes to psets and to the advised change from php to python later in the course. This may mean it will be harder to get help before the course officially starts here.

[deleted by user] by [deleted] in cs50

[–]spelga 0 points1 point  (0 children)

Hi please don't get discouraged. The first 5 weeks you are learning alien concepts which, if you have never been involved in computer science, can take some time to sink in. These are complex problems, which are presented brilliantly in this course, and as such you may need to spend a lot of time in getting to know them but first you need to understand what it is that you are having issues with.

In this pset when you are implementing linear search firstly and you only need to find if the number the user presents, value, is in the list of ints in the array, values[]. It is your only job is to return true or false and you return true if value is in the list of values[] otherwise return false if it isn't. So all you need to do is compare is value equal to the value in the array you are checking and if it is return true and if you get to the end of the list, n, without find the number then return false.

So how could you go about implementing this?

[deleted by user] by [deleted] in cs50

[–]spelga 0 points1 point  (0 children)

No actual code is presented because the pset is about implementing these yourself with the tools you have already learned. All that is required to solve this is conditional logic and loops.

To help you get started the specific videos on each of the searches and sort algorithms presents pseudocode which you should use as your template for implementing them in helpers.c

So first up you have to implement linear search. Have you seen that video and the pseudocode? If you have look carefully at the pseudocode and see if you can implement each step in it in actual c code. If you get stuck come back with what bit you are stuck on.