Investigation and Reporting

General Info of the course is on this page

Learning goals for the week.

After this week, you should be able to:

• Be able to assess if a blog post or other online material is based on knowledge or belief.
• Understand the basics of reproducible experience, and be able to assess if a blog post has sufficient information to allow reproducibility
• Be able to examine your own software development skills and reflect on what you know and what you believe.

Week overview

This weeks curriculum has tree phases:

• In-class work Monday
• Homework
• Follow-up next Monday

Inclass exercises:

*** Scrapbook page for using in class ***

Exercise A - finding evidence

Which of the following two questions do you expect will be easiest to answer?

• What are the three most important problems with using Scrum
• What are three important problems with using Scrum

Try to find evidence for one problem in using Scrum, and try to assess the validity of the claims.

Exercise B - Assessing a website

The page “Evaluating Blog Credibility” gives some criteria for evaluating the credibility of a blog or webpage. Try to answer the quality criteria for the well-known webpage https://www.tutorialspoint.com.

Exercise C - Assessing a Youtube video

https://www.youtube.com/watch?v=cf2iw6FoKeI vs. https://www.youtube.com/watch?v=Zp96VoNDatc

Exercise D - Brainstorm on homework:

Make a brainstorm session with two others on the exercise of the week - the purpose of which is to find out which topics need to be resolved.

Resources

• Link to slideset used in class - Helge
• Link to slideset used in class - Kasper
• Evaluating Blog Credibility

Further reading

To be able to take responsibility of your own professional career it is necessary to be able to step back on be able to assess your own learning behaviour.

• Chapter 8 from the book “Skills for Success - Personal Development and Employability, 3rd edition by Stella Cottrell”.

Exercise

In order to look at self reflection and to judge your assessment of information, you should solve the programming exercise below.

However - the important thing in this exercise is how you solved it, not the end result.

At the end of the programming exercise you should have:

• A list of all Google queries you made to solve it, and timestamps (just copy it from the browser history)
• A list all pages you visited to solve it (just copy it from the browser history)
• A list of the 3 most biggest stumbling blocks you came across and your reflection on why they were problematic (did you misunderstand something, was some of the info you found wrong, did you miss a detail, …)
• A brief “every 30 min” diary as explained in the slides (this is more frequent than one would normally do, and is just meant as part of the exercise)

Question to be investigated

You have been asked by your project lead if you could investigate the quality of the queries in the .Net entity framework. In particular it is said the technology prevents client side joins. You should find some examples of Linq queries and their translation into SQL which best show how client-side joins are avoided.

You ask one of your coworkers for help, and she says: “I never really tried it, but I believe https://www.linqpad.net is still the easiest way to try this - I was able to connect it to a mySQL database with the classicmodels database”.

help: There is a droplet with mysql with the classic model. It is accessible at the following connection string:

pw: deterentysker#42snapsnap