Computer Science
Grade 2
20 min
Shared Documents and Spreadsheets: Planning and Organization
Use shared documents and spreadsheets to organize project tasks and track progress.
Tutorial Preview
1
Introduction & Learning Objectives
Learning Objectives
Explain that a shared document is a file everyone on a team can see and change.
Identify a spreadsheet as a tool with boxes for organizing ideas.
Create a simple plan for a coding project in a spreadsheet.
List at least two jobs needed for a simple coding project.
Assign jobs to team members in a shared plan.
Update a plan by marking a job as 'done'.
Have you ever tried to build a big LEGO castle with friends? 🏰 How did you decide who builds what?
We will learn how to make a plan for our coding projects. We will use special shared lists to work together as a team. This helps everyone know their job! 🤝
Real-World Applications
Planning a surprise party 🥳
Making a list for grocery shopping 🛒
Deciding who plays what position on a soccer...
2
Key Concepts & Vocabulary
TermDefinitionExample
Shared Document 📄A computer file that your whole team can look at and write on together.It's like one big piece of paper that everyone can draw on at the same time, even from their own computer!
Spreadsheet 📊A special document with lots of boxes called 'cells' to keep lists organized.We can make a chart for our coding plan. It has a box for the job, a box for the person, and a box for 'Done?'.
Plan 🗺️A list of all the small steps you need to do to finish a big project.Our plan for a 'Dancing Cat' game is: 1. Draw the cat. 2. Code the dance moves. 3. Add music.
Task (or Job) 🔨One small part of a big plan that one person can do.If we are making a game, one task is 'Code the 'Start' button'. Another task is '...
3
Core Syntax & Patterns
One Job, One Friend 🙋
Assign one person to each task in your plan.
This makes sure everyone has a job and two people don't do the same work by accident.
Break It Down 🧩
Turn a big idea into many small tasks.
A big project like 'Make a Game' is hard. Small tasks like 'Add a character' or 'Make a sound' are easier to do.
Mark It Done ✅
When you finish your task, update the spreadsheet.
Change the 'Done?' box from 'No' to 'Yes!'. This tells your team you are finished and ready for a new task.
4 more steps in this tutorial
Sign up free to access the complete tutorial with worked examples and practice.
Sign Up Free to ContinueSample Practice Questions
Challenging
A team is building a Lego house. Their shared plan says: 1. Put on roof. 2. Build walls. 3. Put in windows. They start with step 1. Why is this a 'bug' in their plan? 🐞
A.You can't put the roof on a house that has no walls yet
B.The roof is the wrong color
C.Building with Legos is too hard
D.They forgot to plan for a door
Challenging
A team's shared document has only one goal written at the top: 'Make a cool game.' Why is this a weak plan for starting a project?
A.'Cool' is not a fun word
B.It doesn't say what kind of game or what jobs need to be done
C.Games are not cool
D.The goal should be written at the bottom
Challenging
Your team has 3 people who love to code and 1 person who loves to draw. The shared plan has 10 coding jobs and only 1 drawing job. What problem will the team have?
A.The drawing will be done too fast and the artist will be bored
B.The coders will have to help draw
C.The game will have too much code
D.The artist will quit the team
Want to practice and check your answers?
Sign up to access all questions with instant feedback, explanations, and progress tracking.
Start Practicing Free