CAMBRIDGE NATIONALS CREATIVE IMEDIA ICT RESOURCES WILL BE REMOVED ON 1/9/2018 PLEASE SAVE ANY YOU STILL WISH TO ACCESS.
  • Home
    • Welcome
  • Unit 1: R081
    • Unit Overview
    • Lesson Resources
  • Unit 2: R082
    • Unit Overview
    • Investigating Digital Graphics
    • Planning your digital graphic
    • Creating Digital Graphics
    • Feedback & Evaluation

INTRODUCTION TO SPREADSHEETS

Lesson 1: The Big Picture:
You are required to learn and apply a range of spreadsheet related skills and produce a professional Business style spreadsheet. 

Learning Objectives:
What are the common features of a spreadsheet?
Know how to use them?
What features does it have that allows us to model and modify information?

Learning Outcomes:
Complete a self audit of skills and progress.
Practice skills
Re audit skills to show learning


Success Criteria:
  1. Complete audit each lesson
  2. Learn 4 new skills
  3. Learn 8 new skills
  4. Learn 12 new skills
  5. Complete all Practice activities using only 3B4ME.
Resources
Introduction to Spreadsheets
Introduction
File Size: 806 kb
File Type: pptx
Download File

2. Self Audit
File Size: 14 kb
File Type: xlsx
Download File

3. Autopsy
File Size: 161 kb
File Type: pdf
Download File

4. Practice Skills
File Size: 2362 kb
File Type: xls
Download File

Lesson 2: The Big Picture:
You are required to learn and apply a range of spreadsheet Formula and Functions. 

Learning Objectives:
• Demonstrate an understanding of the main formulas and functions required to complete the set task
• Apply the formulas and functions with little input from staff extra help
• Use all formulas etc, on your own, with no further teacher input

Learning Outcomes:
Complete advanced Formulas and Functions tasks

Success Criteria:
  1. Improve understanding by at least 10%
  2. Complete Advanced skills practice with some help
  3. Complete Advanced skills practice with little teacher help


Resources
Formulas and Functions
Lesson Starter
Picture
Picture
Lesson 2
File Size: 1749 kb
File Type: pptx
Download File

2. Practice
File Size: 154 kb
File Type: xlsx
Download File

3 Homework
File Size: 122 kb
File Type: xls
Download File

www.camnat.co.uk
  • Home
    • Welcome
  • Unit 1: R081
    • Unit Overview
    • Lesson Resources
  • Unit 2: R082
    • Unit Overview
    • Investigating Digital Graphics
    • Planning your digital graphic
    • Creating Digital Graphics
    • Feedback & Evaluation