Unit 3: Charts & introduction to PowerPoint
Basics of Computer notes · PTU syllabus (BSTD 105-20)
On this page
Unit summary
Charts make numbers visible and PowerPoint presents ideas. This unit covers creating and formatting charts, checking errors, formula auditing and opening a new presentation with layouts.
After this unit you can
- Create and format charts
- Check errors and audit formulas
- Open a presentation and choose a layout
PTU syllabus topics
- Creating and formatting charts
- labels and scaling
- error checking
- formula auditing
- opening a new presentation
- selecting presentation layouts
Column or bar
Comparing categories
Sales by product
Line
Trends over time
Monthly production
Pie
Parts of a whole
Fibre mix in a collection
Scatter
Relationship between two values
Price vs quality
Topic 1
Charts
Column or bar
Comparing categories
Sales by month
Line
Trends over time
Cotton price over years
Pie
Parts of a whole
Share of fabric types
Scatter
Relationship between two numbers
Price against weight
Format a chart by adding a title, axis labels, legend and data labels; scale the axis from zero for bar charts so that heights are fair.
Topic 2
Error checking and formula auditing
| Error | Meaning |
|---|---|
| #DIV/0! | Division by zero |
| #NAME? | Unknown function or name |
| #VALUE! | Wrong type of value |
| #REF! | Deleted or invalid reference |
Use Trace Precedents/Dependents under Formulas to see which cells feed a result, and Error Checking to find mistakes.
Topic 3
Starting PowerPoint
A presentation is a set of slides. The layout (title slide, title and content, two content, blank) decides where text and pictures go. Choose a theme for consistent colours and fonts.
Key terms
- Chart
- Visual of numerical data
- Legend
- Key to chart colours
- Audit
- Check formulas for errors
- Slide
- One page of a presentation
- Layout
- Arrangement of slide placeholders
Quick revision
- Choose chart type by purpose.
- Common errors: #DIV/0!, #NAME?, #VALUE!, #REF!.
- A theme gives consistent look.
Important exam questions
Practice questions written to the PTU exam pattern for this unit's syllabus: short answers (Section A style) and long answers (Sections B and C style).
Short-answer questions
- Q1.When is a pie chart used?
- Q2.What does #REF! mean?
- Q3.What is a slide layout?
- Q4.What is a legend?
Long-answer questions
- Q1.Explain how charts are created and formatted in Excel.
- Q2.Describe formula auditing and common errors.
Stuck on this unit?
Message SBS on WhatsApp for help with Basics of Computer, or to ask about studying B.Sc Textile at Synetic.