Link to the coursework

https://programming.codeyourfuture.io/onboarding/sprints/2/prep

Why are we doing this?

You might be used to school environments where you attend a lecture or class and then are given homework or tests to show you heard or understood the lecture. We don’t do that at CYF as we have found it doesn’t prepare people well for a good job in tech.

As a tech professional, you won’t be told a series of answers and then asked just to demonstrate your understanding/recollection of them! That will never happen! There’s no business value there at all. As a tech professional, your job will be to ask good questions, research new ideas, and figure out solutions to unsolved problems. So let’s start this now.

The prep work here will introduce you to new concepts for the week. If you already have all these concepts, you need to identify something else in your coursework to bring because everyone is expected to come to class with questions.

Find this week’s blockers thread in your cohort channel and add your question to it.

Maximum time in hours

3

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?

You will do the prep first every week, but we will gradually stop reminding you to do it. Consider scheduling it in to your Google calendar.

Link to the coursework

https://www.youtube.com/watch?v=dTNamL30sDg

Why are we doing this?

To learn how to use Google Sheets to store and query data is very useful. SQL is a powerful tool you will regularly come across when working with databases, either as a programmer or in many other data roles.

Watch the video SQL in Google Sheets. Copy the dataset provided in the video and code along with the queries as you go.

• SQL in Google Sheets
• Here is a link to the data

Do up to the step GROUP BY clause and aggregation.

We can skip PIVOT, LIMIT and OFFSET for now. You won’t need these for the next piece of coursework, but look at them if you’re not short on time.

Acceptance criteria

• I have watched the SQL in Google Sheets video and followed along with the instructions in my own Google Sheet.

Maximum time in hours

2

How to get help

Share your blockers in ITP Slack.

How to submit

1. Combine both of these sheets into one. You can create a new sheet for each piece of work.
2. Share a link to your Google Sheet on your own copy of this ticket. Make sure to give read access to your sheet, you can do this by clicking the “Share” button, then change “Restricted” to “Anyone with the link”.

Coursework content

Depends on #46

Now that you have your spreadsheet, you reviewed it, and you are confident it is a good picture of your availability and commitments on a typical week, we can reflect on it.

An important goal of this exercise is to observe your life from an external perspective.

• Write a statement about your reflection. It should be at least 50 words long.
• Don’t forget to check your text with a grammar tool, such as Grammarly

Read it a few times aloud and ensure you haven’t missed anything. Ask yourself if this is what you had planned or a realistic description of what happens. Make any changes and iterations to it.

Now look at the number of hours you dedicate to each activity per week.

Ensure you include your energy and concentration levels when studying or CYF training.

Read the updated sample and iterate again on it, ensuring it has the expected level of detail.

Share your reflection with your pair. Ask them to ask you questions about the accuracy of it. Get them to help you to refine it.

Estimated time in hours

1

What is the purpose of this assignment?

Observing your week and reflecting on your real availability will be key to ensure you have a clear plan to achieve your ultimate goal, which is a job in tech.

Be transparent in all what you are writing and thinking about, to ensure you have a reliable plan. Remember: the plan doesn’t end when the CYF course ends.

How to submit

Add the following as a comment on this issue:

• If you feel comfortable doing so, link to the updated Google Docs with your statement. You are not required to publish anything private on the internet.
• Add a comment about your discussion with your pair (up to 100 words). Remember to check the grammar and spelling before posting it.

Coursework content

https://applieddigitalskills.withgoogle.com/c/college-and-continuing-education/en/effective-communications-at-work/overview.html

Estimated time in hours

1

What is the purpose of this assignment?

As a professional, you must be able to communicate effectively to succeed at work. You must be comfortable with standard office software and to be able to use this to present your ideas and explain your work.

Do lessons 4 and 5

• 4 Communicate Ideas in a Proposal
• 5 Present Information About Your Job

How to submit

You can do as much of the rest of this course as you like, but you must do 4 and 5. Share the results to the exercises of both lessons on your coursework board.

Link to the coursework

• Evaluate and interpret data with different spreadsheet functions, filters, and charts using Google Sheets.
• Use advanced functions and conditional formatting in Google Sheets.

Why are we doing this?

Being confident and fluent with spreadsheets is necessary knowledge for all workers. Work through these 2 courses, which follow on from the prep work you’ve already done.

Maximum time in hours

3

How to get help

Share your blockers in Slack. We are here to help each other.

How to submit

1. Make your spreadsheet public
2. Attach a link to your copy of this ticket on your own board

Link to the coursework

https://github.com/CodeYourFuture/CYF-Workshops/tree/main/devtools

Why are we doing this?

Before you come to class, you need to make sure you are ready to participate in the workshop.

For this workshop you will need:

• Chrome with Devtools
• A ChatGPT account
• This Devtools Workshop page

Make sure you come to class with Chrome installed, a ChatGPT account, and having looked over what you will be doing.

Maximum time in hours

0.15

How to get help

Share your blockers in your class channel. Practice asking good questions, with links and context.

Coursework content

Watch The power of believing that you can improve | Carol Dweck | TED and Neuroplasticity.

Write your reflections on why it is important to have a growth mindset as a developer and how a growth mindset will positively impact you in your career in the long term. Try to answer the following questions:

• When did I have a closed mindset this week, and why?
• When did I have an open mindset this week, and why?
• What have I learnt about myself, as a result?
• What will I do differently next time?

Estimated time in hours

1

What is the purpose of this assignment?

This assignment supports developing a growth mindset while learning new skills and facing barriers.

How to submit

Write in your cohort’s Slack channel what actions you will take in order to overcome your barriers to participating in coding and write a supportive message to one of your peers who has shared their barriers in the channel.

Link to the coursework

https://github.com/CodeYourFuture/Project-Record-A-Goose

Why are we doing this?

A mission of discovery for you.

1. Go to https://github.com/CodeYourFuture/CYF-Record-A-Goose-Project
2. Using Devtools, Lighthouse, and the WAVE accessibility plugin, find all the ways this app is broken
3. How would you fix the problems? Discuss in a thread in your channel.

This is also a fun in-person workshop, so you could choose to do it in a class or coworking space together.

https://record-a-goose.onrender.com/

Maximum time in hours

2

How to get help

You could choose to do this in class together during independent study time.

How to submit

Write up your findings in a thread in your class channel.

Don’t make a new post each. Discuss in a thread.

How to review

It is a review! ;)

Anything else?

• https://developer.chrome.com/docs/lighthouse/overview/
• https://wave.webaim.org/extension/
• https://accessibilityinsights.io/docs/web/overview/
• https://design-system.service.gov.uk/

Link to the coursework

https://docs.google.com/spreadsheets/d/1zPeHxhKkYmdiqXNhMwhfC1A0o1wI0zNiD5Gsks2SYoc/template/preview

Why are we doing this?

To practice how to use Google Sheets to store and query data. This should make sure we understand the basics of SQL and how to use it to query data.

We’re going to practice extracting data from a database, using SQL. We will use the same data set we used in the Learn about Google Sheets coursework.

Please complete the following tasks:

1. Emily Smith would like to be able to quickly see how many deals she’s made. She only cares about Deal Value and Expected Close date to see when she’ll be paid. Create a query that will give only this information.
2. As the accountant working for this business, I need to work out the total sales we’ve made in each country to pay our taxes. Write a query to return a list of each closed deal (they have status of "Closed Won") and sort them by country so we can work this out easily.
3. As the accountant for this business, I need to find out how much we’ve sold in each country to pay our taxes. Deals are only complete when they have the status “Closed Won”, so we should only include those deals. To make the data easier to work with, we can sort them by country. Can you write a query to get this information?

Acceptance criteria

• I have completed all three tasks.
• I have added them to a new sheet in my Google sheet I created in the “Learn about Google Sheets” coursework.

Maximum time in hours

1

How to get help

Share your blockers in the ITP Slack.

How to submit

1. The work should be in the same Google Sheet as the “Learn about Google Sheets” coursework.
2. Share a link to your Google Sheet. Make sure to give read access to your sheet, you can do this by clicking the “Share” button, then change “Restricted” to “Anyone with the link”.

Link to the coursework

https://application-process.codeyourfuture.io/

Learning Objectives

Why are we doing this?

Enroll as a trainee to:

• claim course expenses to support your studies
• access unlimited Udemy for Business courses
• access GitHub Student Developer Pack
• access any further CYF courses

1. Complete your step submission

This is the same as in ITD. Everyone should do this, even if you are not eligible to enrol as a Trainee. You will do this every module:

1. Go to https://programming.codeyourfuture.io/onboarding/success/
2. Check off the learning objectives
3. Make an issue on your Coursework Planner: https://github.com/YOURGITHUB/My-Coursework-Planner/issues
4. Put links to all the evidence asked for on the module success page
5. Submit your step on the CYF Course Platform (sometimes called “the dashboard” by volunteers)

2. For this onboarding module only:

1. Complete this enrollment form.
2. If you hit a blocker write to pastoral@codeyourfuture.io if it’s private, or post on Slack if it’s not private

Maximum time in hours

.5

How to get help

If you hit a blocker and it’s something private, write to pastoral@codeyourfuture.io Otherwise, post on Slack. Encourage and support each other to complete onboarding!

How to review

You will receive your enrolment by email.

Link to the coursework

https://www.codewars.com/join

Why are we doing this?

When you begin programming you will also begin Codewars, if you have not done so already. Prepare now by signing up to Codewars.

You will complete at least three kata a week for the rest of the course. A kata is a short coding workout and you should aim to spend twenty minutes, three times a week, doing kata.

1. Link your account with GitHub, and join the CodeYourFuture clan, so we can find you on the clan board here: https://www.codewars.com/users/CodeYourFuture/following
2. Join the #cyf-codewars channel

By the end of the next module, you need to have completed nine kata. Codewars is not just to practice JavaScript, it’s to practice time management and study skills.

All the CYF collections are on the CYF account. Here’s a beginner collection of kata to practice on for now: https://www.codewars.com/collections/cyf-user-focused-data

This task has to be completed by the end of this module.

Maximum time in hours

0.5

How to submit

Add your Codewars username to your Slack profile

Link to the coursework

https://codeinplace.stanford.edu/

Why are we doing this?

Code in Place is a free introductory programming course using the Python language, based on material from the first half of Stanford University’s established intro course, CS106A. It assumes no prior programming experience.

Stanford offers a free, good quality programme to learn the basics of coding. It has a scheduled course, which you should sign up for if it’s open. If the scheduled course is not running, work through the course materials in your CYF study group. The videos and problems are the same either way.

You will learn Python, which we will use later for handling data.

Maximum time in hours

.10