BTEC FIRST ICT (Prac)
Unit 10 Spreadsheets

Lesson Notes - Week by Week
Remember the Policy adopted by your tutors is quite simple .... If a document relating to your course of study has been published on THIS WEBSITE, then we ASSUME YOU HAVE READ IT. This means that YOU CANNOT claim to NOT know about any topic that is covered on this website which relates to your course of study.. YOU have already SIGNED an agreement under the college LEARNER CODE OF CONDUCT that clearly states YOU are solely responsible for YOUR OWN LEARNING (with the support of your tutors). So make sure that you download , print and work through ALL the support notes and documents from this website that relate to you and your course. If you do this then your grades will improve dramatically .......kind regards .... Paul Bolger ...... 
Background
Reference Why not visit the EXCEL WORKSHEET LIBRARY if you get stuck or need some practice
  Unit 10 - Scheme of Work (2007/08)
Unit 10 - Spreadsheets - Notes and Tutorials
Worksheets: ALL WORK NOT COMPLETED BY THE END OF EACH CLASS MUST BE COMPLETED DURING TIMETABLED STUDY PERIODS PRIOR TO START OF YOUR NEXT CLASS
  Unit 10 - Syllabus (Spreadsheet Software)
  Unit 10 - Scheme of Work
w/b 22nd Jan Week 1 - Getting started with Excel
Lesson Plan : Week 01 - Plan
Lesson Aims: Week 01 - Aims
  Week 01 - Pre Assessment Task
Class Resources: PowerPoint - Unit 10 overview
  Notes - What is a Spreadsheet
  Activity 01 - Using a Spreadsheet
  Activity 02 - Football League Table
You Tube - Calculating Totals  
You Tube - Cells Flash Video - How to Print an Area
You Tube - Basic Training in Excel Flash Video - How to Print an Area Follow up Test
You Tube - Excel Practice Test Flash Video - How to switch to and from Formula View
  Flash Video - How to switch to and from Formula View follow up test
  On Line Quiz - Basic Level 1 Spreadsheets
  Fun 1 - Word Find 1 - spreadsheets
  Fun 2 - Word Search - Spreadsheets
Recap/Assessment Week 01 - Lesson Recap Assessment - Spreadsheet Layout
  Week 01 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
w/b 29th Jan Week 02 - Simple Mathematical Formulas
Lesson Plan : Week 02 - Plan
Last Weeks Recap: Week 02 - Summary of previous lesson
Lesson Aims: Week 02 - Aims
Class Resources:

Notes - Arithmetic Operators

 

Activity 01 - Arithmetical Operation

  Activity 02 - How a Spreadsheet Calculates
  Activity 03 - (using a spreadsheet 1 )
  Activity 04 - (Differentiation Activity - Using a spreadsheet 2 )
You Tube - Using a Formula PowerPoint - Spreadsheet Formulas
  Flash Video - How to add cell values
  Flash Video - How to add cell values Follow up Test
  Flash Video - How to enter a formula
  Flash Video - How to enter a formula follow up test
  On-Line Tutorial - Functions and Formulas
  On-line Quiz - Starting with Spreadsheets
  Diversity On-line Quiz 2 - Spreadsheet Formulas
Recap/Assessment Week 02 - Lesson Recap Assessment
  Week 02 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
  Further Notes - Maths functions
w/b 5th Feb Week 03 - Complex Functions / Consolidation
Lesson Plan : Week 03 - Plan
Last Weeks Recap: Week 03 - Summary of last lesson
Lesson Aims: Week 03 - Aims
Class Resources: Activity 01 - Complex Functions
  Activity 02 - Deriving Formulae 1 (tile shop)
  Activity 03 - Differentiation Activity - Deriving Formulae 2 ( punch making )
Recap/Assessment Week 03 - Lesson Recap Assessment
  Week 03 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
Half Term - Winter Holiday
w/b 19th Feb Week 04 - Simple Spreadsheets / Consolidation
Lesson Plan : Week 03 - Plan
Last Weeks Recap: Week 03 - Summary of last lesson
Lesson Aims: Week 03 - Aims
Class Resources: Activity 01 - Pocket Money
  Activity 02 - CD Sales
  Activity 03 - Video Store
  Activity 04 - Cothing Companye
  On-Line Notes - Spreadsheet Safari
  Activity 05 - Differentiation - Cash Flow Spreadsheet
Recap/Assessment Week 03 - Lesson Recap Assessment
  Week 03 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
w/b 26th Feb Week 05 - Imroving Efficiency & File Handling
Lesson Plan : Week 05 - Plan
Last Weeks Recap: Week 05 - Summary of last lesson
Lesson Aims: Week 05 - Aims
Class Resources: Notes - Unit 10 -
  Micro Teach 01 -
  Micro Teach 02 -
Recap/Assessment Week 05 - Lesson Recap Assessment
  Week 05 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
w/b 5th March Week 06 - Consolidation
Lesson Plan : Week 06 - Plan
Last Weeks Recap: Week 06 - Summary of last lesson
Lesson Aims: Week 06 - Aims
Class Resources: Notes - Unit 10 -
  Micro Teach 01 -
  Micro Teach 02 -
Recap/Assessment Week 06 - Lesson Recap Assessment
  Week 06 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
w/b 12th March Week 07 - Logical Functions / IF Functions
Lesson Plan : Week 07 - Plan
Last Weeks Recap: Week 07 - Summary of last lesson
Lesson Aims: Week 07 - Aims
Class Resources: Notes - Unit 10 - IF Function
  Flash Video - IF Functions
  Flash Video - Test on the above IF function movie
  See How it Works 1 - Can you afford to live away from Home ? ( get the sample file here )
  See How it Works 2 - Intial Letters ( get the sample file here )
  See How it Works 3 - Count the Shapes (get the sample file here )
  See How it Works 4 - If what makes TEN ( get sample file here )
  Activity 01 - Sales Bonus
 

Activity 02 - Van Sales (IF Function) exercise (sample file vansales.txt)

(image file icecone.jpg) Activity 03 - ICE Sales - (If Function) ( sample file ice sales)
  Activity 04 - Quadratic Equations
Recap/Assessment Week 07 - Lesson Recap Assessment - IF statements
  Week 07 - Assessment Tasks relating to IF statements
  Week 07 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
w/b 19th March Week 08 - Uses of Spreadsheheets / Assessment 1
Lesson Plan : Week 08 - Plan
Last Weeks Recap: Week 08 - Summary of last lesson
Lesson Aims: Week 08 - Aims
Class Resources: Notes - Unit 10 -
  Micro Teach 01 -
  Micro Teach 02 -
Recap/Assessment Week 08 - Lesson Recap Assessment
  Week 08 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
w/b 26th March Week 09 - Assessment 2
Lesson Plan : Week 09 - Plan
Last Weeks Recap: Week 09 - Summary of last lesson
Lesson Aims: Week 09 - Aims
Class Resources: Notes - Unit 10 -
  Micro Teach 01 -
  On-Line Articel - Wikipeadia / Spreadsheets
Recap/Assessment Week 09 - Lesson Recap Assessment
  Week 09 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
Easter Holiday Break
w/b 16th April Week 10 - Simple Functions and Complex Formulae
Lesson Plan : Week 10 - Plan
Last Weeks Recap: Week 10 - Summary of last lesson
Lesson Aims: Week 10 - Aims
  Week 10 - Pre Assessment Task
Class Resources: PowerPoint - Useful Spreadsheet Functions
  Notes - Simple Functions
  Activity 01 - Groupwork simple functions
  Activity 02 - Automated Functions
  Additional Activity 04 - Sandwich Shop
 

Additional Activity 05 - Settees calculations

  Additional Activity 06 - Simple Calculations 2 (differentiation)
  On-line Tutor - Spreadsheets (differentiation)
  On-Line Quiz - Spreadsheet Functions (differentiation)
  On Line Quiz - Basic Level 2 Spreadsheets
Recap/Assessment

Week 10 - Lesson Recap Assessment (word search)

  Week 10 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
w/b 23rd April Week 11 - Charts and Graphs
Lesson Plan : Week 11 - Plan
Last Weeks Recap: Week 11 - Summary of last lesson
Lesson Aims: Week 11 - Aims
Class Resources: Notes - Unit 10 -
You Tube - Renaming Sheets Micro Teach 01 -
You Tube - Working with the Formula Bar  
You Tube - Excel budgeting  
  Micro Teach 02 -
Recap/Assessment Week 11 - Lesson Recap Assessment
  Week 11 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
w/b 30th April Week 12 - Analysing Data
Lesson Plan : Week 11 - Plan
Last Weeks Recap: Week 11 - Summary of last lesson
Lesson Aims: Week 11 - Aims
Class Resources: Notes - Unit 10 -
  Micro Teach 01 -
  Micro Teach 02 -
Recap/Assessment Week 11 - Lesson Recap Assessment
  Week 11 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
w/b 7th May Week 13 - Documentation
Lesson Plan : Week 11 - Plan
Last Weeks Recap: Week 11 - Summary of last lesson
Lesson Aims: Week 11 - Aims
Class Resources: Notes - Unit 10 -
  Micro Teach 01 -
  Micro Teach 02 -
Recap/Assessment Week 11 - Lesson Recap Assessment
  Week 11 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
w/b 14th May Week 14 - Evaluation
Lesson Plan : Week 11 - Plan
Last Weeks Recap: Week 11 - Summary of last lesson
Lesson Aims: Week 11 - Aims
Class Resources: Notes - Unit 10 -
  Micro Teach 01 -
  Micro Teach 02 -
Recap/Assessment Week 11 - Lesson Recap Assessment
  Week 11 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
w/b 21st May Week 15 - Assessment Consolidation
Lesson Plan : Week 11 - Plan
Last Weeks Recap: Week 11 - Summary of last lesson
Lesson Aims: Week 11 - Aims
Class Resources: Notes - Unit 10 -
  Micro Teach 01 -
  Micro Teach 02 -
Recap/Assessment Week 11 - Lesson Recap Assessment
  Week 11 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
w/b 4th June Week 16 - Assessment Consolidation
Lesson Plan : Week 11 - Plan
Last Weeks Recap: Week 11 - Summary of last lesson
Lesson Aims: Week 11 - Aims
Class Resources: Notes - Unit 10 -
  Micro Teach 01 -
  Micro Teach 02 -
Recap/Assessment Week 11 - Lesson Recap Assessment
  Week 11 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
w/b 11th June Week 17 - Assessment Consolidation
Lesson Plan : Week 11 - Plan
Last Weeks Recap: Week 11 - Summary of last lesson
Lesson Aims: Week 11 - Aims
Class Resources: Notes - Unit 10 -
  Micro Teach 01 -
  Micro Teach 02 -
Recap/Assessment Week 11 - Lesson Recap Assessment
  Week 11 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
w/b 18th June Week 18 - Assessment Consolidation
Lesson Plan : Week 11 - Plan
Last Weeks Recap: Week 11 - Summary of last lesson
Lesson Aims: Week 11 - Aims
Class Resources: Notes - Unit 10 -
  Micro Teach 01 -
  Micro Teach 02 -
Recap/Assessment Week 11 - Lesson Recap Assessment
  Week 11 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck
Additional Tasks Tasks and Data Files
Lesson Plan : Week xx - Plan
Last Weeks Recap: Week xx - Summary of last lesson
Lesson Aims: Week xx - Aims
Class Resources: Activity 01- melody sales datafile icesales graphic image icecream
  Activity 02 - melody sales 02 datafile van sales VLOOKUP (hint)
  Activity 03 - xtreme adventure datafile rebates
  Activity 04 - KIAN IT supplies datafile invoice
  Activity 05 - Cars 4 U datafile data2
  Activity 06 - Games Sales datafile gamesale
  Activity 07 - Look UP
  Activity 08 - IF function
Recap/Assessment Week 11 - Lesson Recap Assessment
  Week 11 - Reflective Diary
Further Resources / Reading: Library - Excel Worksheet Library more places to go if you get stuck