Tuesday, October 15, 2019

Free Databases and Data Visualisations course for kids Weeks 9 to 11 update

It has been quite a while since I have posted about the free databases and data visualisation classes for 9 to 14 year old kids.  So here I am with an update.  In the SQL test that was conduced in week 8, about 10 kids have written taken the test.  All of them have scored more than 80% except for 1 person who scored 70%.  I am pleased with the overall result.

For the last 3 weeks, I have started teaching Power BI to the kids.  Three more kids have joined the Power BI classes. I taught basics of importing data using a csv file.  Also gave an overview of the 3 views in Power BI Desktop, query editor, Applied steps pane, removing columns etc.

I have also covered about new columns and measures  what the main difference is between columns and measures. I have covered various visualisations in the Report View by explaining them what a measure and dimension is.

Next week I have asked everyone to pick a dataset on their own and come up with their data visualisations.  So waiting for their creativity to unveil.




Monday, September 16, 2019

Free Databases and Data Visualisations course for kids Week 8 update

Today I conducted a SQL test for kids to gauge their understanding of what I have taught them so far in SQL.

Altogether 10 kids participated in the SQL test.
This test is online and if any of you want to try the test you can try

The link is below:
SQL Test 

A few photos from the night below




Tuesday, September 10, 2019

Free Databases and Data Visualisations course for kids Week 7 update

Had a great time this week with kids who attended the SQL course yesterday. #sqlfamily #microsoftnz #mvpbuzz

This week they learnt how to import data from a csv file.  After they imported the file, I have asked them to view what they have imported and most of the kids started writing the select queries for all my questions. I again had a short recap of the last week's session covering update, delete and basic SQL functions.

In the next session, I will be organising a test to understand how much they have learnt.








Monday, September 09, 2019

Final Submission for Back to School Power BI Competition

As mentioned in my previous posts, the kids have finally completed their power BI files and I have successfully towards the BAck to School Power BI competition.

The details of the submissions are as follows:

Career Pathways

https://community.powerbi.com/t5/Data-Stories-Gallery/Career-Pathways-Back-to-School/td-p/785700

Historical Events

https://community.powerbi.com/t5/Data-Stories-Gallery/Study-of-Historical-Events-Back-to-School/td-p/786138

Road Safety

https://community.powerbi.com/t5/Data-Stories-Gallery/Road-Safety-Back-to-School/td-p/785683


Climate News

https://community.powerbi.com/t5/Data-Stories-Gallery/Climate-News-Back-to-School/td-p/785721

If you like what the kids did, please like them without any hesitation.  This will boost their confidence levels 

Tuesday, September 03, 2019

Free Databases and Data Visualisations course for kids Week 6 update

Databases and Data Visualisations course for kids aged between 9 to 14 years week 6 update.

Had a great time this week with kids attending the SQL course. #sqlfamily #microsoftnz #mvpbuzz

I had a short recap of the last week's session covering update, delete and basic SQL functions.

This week they learnt how to import data from a csv file.  After they imported the file, I have asked them to view what they have imported and most of the kids started writing the select queries for all my questions.

In the next session I am planning to cover table joins to them. Hopefully this will be the last session on databases after which I will be organising a test

I am looking forward for the session on next Monday.




Friday, August 30, 2019

Participation in Back to School Power BI competition progress

As mentioned in my previous post, all kids have been working hard on their power bi files.

The following are the topics chosen by the kids for the Back to School Power BI competition (4 groups)

Career Pathways
Climate Changes/News
Road Safety
Historical Events

I had a chance to look at the first draft of the power BI files created.  Suggested some changes to improve them further. 

One of the groups were having difficulty in getting the data into Power BI, so helped them with that. 

One of the groups started developing the power BI visualisations directly in the app.powerbi.com as they thought that sharing between them would be easier.  Since you cannot convert the visualisations developed in the app to power bi desktop file, they had to recreate everything in the power b desktop from scratch.  This was a big learning for them.  But they quickly did that.

One of the groups wanted to know how to get data from a website, so pointed them to my webinar on "Top 10 tips" which they could use to create their visualisations.

The Road Safety group created a game that was meant to be interactive.  But when I tried to use it, I didnot find that it was very interactive.  So I have suggested to make some changes.

Some of the photos from this catch up





Wednesday, August 28, 2019

Free Databases and Data Visualisations course for kids Week 5 update

Databases and Data Visualisations course for kids aged between 9 to 14 years week 5 update. Had a great time on Monday with 10 kids and 2 parents attending the SQL course. #sqlfamily #microsoftnz 

There was no class last week as I was away in Melbourne at the #powerplatformsummit.

So there was almost a 2 week gap so I revised all that they have learnt so far in the last 4 weeks by asking them a lot of questions.  Most of the questions some of the kids answered them right but the revision helped them to understand a bit more.

I was pleased to see most of the kids eagerly answering my questions. I felt that now all the kids are able to genuinely understand what I am trying to teach them.

This week they learnt some of the basic SQL functions like Min, Max, Count, AVG, SUM.  String functions like Left and Right.

In the next session I am planning to cover the importing of data from a csv and also will try and explain joins to them.

I am looking forward for the session on next Monday.






Free Databases and Data Visualisations course for kids Weeks 9 to 11 update

It has been quite a while since I have posted about the free databases and data visualisation classes for 9 to 14 year old kids.  So here I...