Year 11 - Computing
Carrying out a project part I
Using IT in project management
Study Hub
Study Guides
This pupil-friendly study guide includes a unit summary, clear notes, common mistakes, and quick questions with answers.
Unit Summary
Project management has numerous transferable skills for pupils, from simple time management to structured project management techniques. In this unit pupils will have the opportunity to develop invaluable skills in using common software tools and systems used for project management.
Lesson Summary
You will learn to edit the structure of a provided spreadsheet workbook and apply functions and formulas to each sheet.
Key Notes
- Using a single spreadsheet workbook with different sheets can help organise all the data in one place.
- Formulas like SUM and functions like IF help you do calculations quickly and accurately.
- Using the fill handle and absolute cell references can make your formulas more efficient.
- You can use formulas to link cells from one sheet to another, so data updates automatically.
Vocabulary To Learn
- workbook: a file in a spreadsheet package that is made up of multiple worksheets
- worksheet: a single sheet within a workbook made up of cells
- formula: performs calculations in a spreadsheet
- function: a predefined formula that performs a calculation
Common Mistakes To Avoid
- Formulas can only be used on cells within one worksheet in a spreadsheet.
3 Quick Questions (With Answers)
1. Describe the system or process from this lesson in clear steps.
Using a single spreadsheet workbook with different sheets can help organise all the data in one place. Formulas like SUM and functions like IF help you do calculations quickly and accurately.
2. Define this computing term and give one practical example. 'workbook'
a file in a spreadsheet package that is made up of multiple worksheets. Add one real device or system example to prove understanding.
3. Correct this common computing misconception.
Mistake: Formulas can only be used on cells within one worksheet in a spreadsheet. Correction: Formulas can work across multiple worksheets in a spreadsheet.
More Lessons In This Unit
- Carrying out a project part II Study Guide
- Evaluate your project Study Guide
- Evaluating the success of a project Study Guide
- Execute your own project Study Guide
- Interpreting project briefs Study Guide
- Introduction to project management Study Guide
- Setting project aims and objectives Study Guide
- Start your own project Study Guide
- Tools for project planning Study Guide
Browse all guides in the Year 11 Computing guide library.