π·οΈ backlog
Module-Databases π
[PD] Following up after an interview π Clone
Coursework content
Suppose youβve applied for a job with a great CV and cover letter, landed the interview, and now have completed the interview, thinking it went well. At the end of the interview, you asked and were told what the next steps are. Now what?
The situation is now largely out of your control. It is better to turn your energy to more productive activities like building your portfolio, networking or searching and applying for other opportunities.
However, there are a few times when it is beneficial to email the hiring manager:
- A brief Thank You note
- A follow-up check if the promised next steps are very overdue,
- Alerting them of changes to your circumstances (such as another job offer)
- Asking for feedback in the event you donβt get an offer
Read this Harvard Review Article to see when and how you might follow up in these circumstances.
Estimated time in hours
1
What is the purpose of this assignment?
Understand when and how to follow up after an interview
How to submit
Write a short paragraph for each of the following scenarios:
- A brief Thank You note
- A follow-up check if the promised next steps are very overdue,
- Alerting them of changes to your circumstances (such as another job offer)
- Asking for feedback in the event you donβt get an offer
Share the doc on this issue, ensuring it is available for comments.
Donβt forget to review it so you donβt have any grammar or spelling mistakes.
- ποΈ Priority Stretch
- π Size Small
- π Databases
- π Week 2
[PD] Review your Development Plan π Clone
Coursework content
When you read and analyse Job Descriptions, you will inevitably find some core or extra requirements you donβt meet perfectly. These missing requirements are good triggers for you to consider adding to your Development Plan.
- Are there some technologies employers keep asking about that you want to learn?
- Are there some skills or experiences that they are looking for that you could plan to develop?
- Might there be opportunities for future projects or portfolio work to incorporate the learning and use of these technologies or skills?
Review your analysis of the Job Descriptions and make changes to the short or long-term goals in your Development Plan accordingly.
Estimated time in hours
0.5
What is the purpose of this assignment?
See missing requirements as learning opportunities.
How to submit
Share your updated Development Plan with your PD Coach or a trusted colleague and ask for their feedback on your changes.
- ποΈ Priority Stretch
- π Size Small
- π Databases
- π Week 2
[PD] Do an interview using AI π Clone
Coursework content
Use an AI to help you prepare for a potential job interview for the position you identified in the previous coursework.
Possible prompts for the AI might be:
- Given my CV and the following Job Description, play the role of an interviewer in a job interview for this position.
- Given my CV and this Job Description, what concerns might the employer have about how good an applicant I am?
Estimated time in hours
0.5
What is the purpose of this assignment?
Prepare for a possible job interview. Use AI to help you determine how well your CV matches an employerβs job description.
Remember not to post personal information on any AI.
How to submit
Copy and paste the discussion with the AI on a doc and share it here.
Make sure it can be commented on by anyone.
- ποΈ Priority Stretch
- π Size Small
- π Databases
- π Week 2
[PD] Analyse another Job Description π Clone
Coursework content
Repeat the prep work to find and analyse another job description that interests you. Use a job search engine to find a position that appeals to you, and then copy this template to perform your analysis on how well you fit the position.
Consider the following factors:
- How well do you meet the Core and extra requirements?
- How do your personal values match the Company values and culture?
- Keywords in the Job Description that might indicate critical factors for the employer
- Red flag warning phrases that might indicate the company or position is not ideal for you.
- Questions you can ask before and during the interview
- A summary of whether you should apply for this position
Estimated time in hours
1
What is the purpose of this assignment?
Exercise the art of identifying the right job you want to apply for before spending time tailoring your CV.
How to submit
- Post your completed analysis to this coursework ticket.
- Make sure it is available for people to comment.
- Donβt forget it should have no grammar or spelling errors.
Anything else
This article provides a useful description of Job Descriptions and how to analyse them.
- π Size Small
- π Priority Key
- π Week 2
[PD] Apply to join Launch Module π Clone
Coursework content
Launch Module is coming up! You need to make sure you are prepared to apply.
Check the Entry Criteria and:
- Make sure you have achieved the criteria
- Review the job description on that document
- Tailor your CV and cover letter to this job description.
- Sign-up using the form.
Estimated time in hours
1
What is the purpose of this assignment?
This assignment asks you to double-check that you are ready to apply to the Launch Module.
How to submit
Your Leaders will talk you through the process and invite you to interview shortly.
- π Size Small
- π Databases
- π Priority Key
- π Week 2
[PD] Positive thinking π Clone
Coursework content
Think about up to 5 negative thoughts you have/used to have about your skills and experience. Give them a positive spin, and write them down.
Estimated time in hours
0.5
What is the purpose of this assignment?
This assignment will help you to practice thinking in positive terms.
How to submit
Share the link to your coursework on ticket on your board.
- π Priority Mandatory
- π Size Small
- π Databases
- π Week 2
[TECH ED] SQL Bolt π Clone
Link to the coursework
Why are we doing this?
You can try out SQL right in your browser with this interactive tutorial. This means you can do it away from your development environment.
Maximum time in hours
0
- π― Topic Programming Fundamentals
- π― Topic Time Management
- ποΈ Priority Stretch
- π Databases
- π Week 2
[TECH ED] Check the prep π Clone
Link to the prep
https://curriculum.codeyourfuture.io/databases/sprints/2/prep/
Why are we doing this?
Are you prepared for the Saturday class? It is essential to start learning new concepts and ideas before Saturday’s session. During the week, we expect you to get stuck and form questions about the new content so you can address misconceptions during Saturday’s session. Double check you’ve done the prep work before continuing with other backlog issues.
Maximum time in hours
3
How to get help
Share your blockers in your class channel
https://curriculum.codeyourfuture.io/guides/asking-questions/
- :brain: Prep work
- π Priority Mandatory
- π Size Medium
- π Databases
- π Week 2
[TECH ED] Codewars π Clone
Link to the coursework
https://www.codewars.com/users/CodeYourFuture/authored_collections
Why are we doing this?
Every week you need to complete at least three kata. Spend at least 20 minutes, three times a week, on your kata workout. To apply for the Launch you need a 5kyu. How will you achieve this? If you are already at 5kyu, you will soon need to reach 4kyu, so don’t slack off.
You may be asked to pair programme at any time and re-do your logged solutions on your Codewars account, so make sure you understand your solutions and can explain them.
Maximum time in hours
1
How to get help
Collaborate with your peers in the #cyf-codewars channel.
How to submit
Your Codewars progress is tracked automatically.
- π― Topic Programming Fundamentals
- π― Topic Problem-Solving
- π Priority Mandatory
- π Size Small
- π Databases
- π Week 2
[TECH ED] Full Stack Product π Clone
Link to the coursework
https://curriculum.codeyourfuture.io/databases/product/
Why are we doing this?
Here is the fabled Full Stack Assessment. This project will help you prepare for Final Projects. Check out the prep for this project and then look at the project views below to see the issues your team will need to work on.
Check out the user stories for this project
Check out the all the required issues for week 3
Maximum time in hours
6
How to get help
Share your blockers in your class channel. Use the opportunity to refine your skill in Asking Questions like a developer.
Anything else?
- π― Topic Delivery
- π― Topic Requirements
- π― Topic Iteration
- π Priority Mandatory
- π Size X-Large
- π Databases
- π Week 2
[TECH ED] Big Spender π Clone
Link to the coursework
https://github.com/CodeYourFuture/Module-Databases/tree/main/Big-Spender
Why are we doing this?
Often at work, people are going to ask you things. It’s a good skill to be able to take natural/human language questions and express them as database queries.
Maximum time in hours
5
How to get help
Share your blockers in your class channel. Use the opportunity to refine your skill in Asking Questions like a developer.
How to submit
- Fork to your Github account.
- Make a branch for this project.
- Make regular small commits in this branch with clear messages.
- When you are ready, open a PR to the CYF repo, following the instructions in the PR template.
There are several projects in this repo. Make a new branch for each project.
How to review
Swap with a colleague and review each other’s answers.
- π― Topic Communication
- π― Topic Requirements
- π― Topic Structuring Data
- π Priority Mandatory
- π¦ Size Large
- π Databases
- π Priority Key
- π Week 2