Challenges and Advanced Challenges

[stevebrownlee]

This issue is for brainstorming challenges and advanced challenges on both (a) exercises, and (b) group project features.

[askingalot]

Here's a couple of advanced exercises I gave 29.

1. https://github.com/nss-day-cohort-29/Todos-Class-Example/blob/master/Program.cs
2. https://gist.github.com/askingalot/83ce03c0f050f14027ad48a3c64e8b54

[askingalot]

Some SQL topics...

1. using union
2. insert into with a select
3. using ctes

Some C# topics...

1. enums
2. Queues and Stacks
3. switch statements

[leahhoefling]

A couple of ideas I have so far for Adv. Challenges:

• Building a complex ERD for hospitals, prescriptions, pharmacists, doctors, patients, etc.

• Scrabble Finder: allow the user to input any combination of up to seven letters and find all the available legal Scrabble words. (provide a long list of words (from dictionary of Aa- Ac) to the student to test this on)

[askingalot]

Write your own implementation of string.Join() without using the string.Join() method.

[askingalot]

Calculator Challenge
https://gist.github.com/askingalot/a3a65d43f0513d8277dce3533732e7a6

[askingalot]

Something that demonstrates issues related to floating point representations and/or the difference with the decimal type.

[stevebrownlee]

We need to get these incorporated into the course before cohort 35 starts C#. @askingalot can you take ownership of you and/or some junior instructors adding these to the appropriate chapters, please?