Skip to content

Mr Ali's ICT Blog

Work for Mr Ali's Classes

  • Home
  • GCSE Computing
    • GCSE Revision Videos
    • Year 10 Linux Tracking
  • Btec ICT
    • Btec U1 Component 2
    • Unit 43 – P1
    • Unit 43 – P5
    • Unit 43 – P6
    • Unit 38 – P1, M1 & D1
    • Task 1 – Interactive multimedia authoring
  • ICTED VLE
  • Personal
    • My Arabic Books
    • Arabic II
    • Calendar
    • Equipment Form
    • ICTED Owncloud
    • Moderation Form
    • My Email
    • School Timetable
    • Timesheet
  • Resources
    • Fireworks Tutorials
    • English padlet
    • Learn English
    • Comped links
      • Pupil Review
      • Year 7 Course
      • Year 8 Course
      • Year 9 Course
      • Comped Online
      • Computing Central
      • Festive Fun
    • Audio Resources
    • E-Safety
    • Examples of OCR Nationals Animation work
    • Pe link1
    • Pe link 2
    • ICT Pupil Voice
    • Kirklees Options
    • Year 8 Homework
    • Cover Mr Ali
Mr Ali's ICT Blog

Tag: spreadsheets

Introduction to Spreadsheets

Lesson Aim

  • Learn spreadsheet vocabulary

  • Create simple formulas

Main

Download the spreadsheet below and complete all the worksheets

Week 1 – 2 Spreadsheet tasks – Skills building

Plenary

8. Basic Formula

Author Mr AliPosted on October 6, 2021Categories Year 7 SpreadsheetsTags Modelling, spreadsheets

Access to HE – Spreadsheet Example Assignment

Example assignment for Spreadsheet Unit

PlanningDownload
Spreadsheet-System2Download
TestingDownload
Proof-of-Resubmission-criteriaDownload
GA33COM12-AssignmentDownload

Author Mr AliPosted on November 6, 2020November 6, 2020Categories Advanced Spreadsheets, SpreadsheetsTags Level 3 Spreadsheets, spreadsheets

Level 1 Spreadsheets

Exercise 4.1Download
Exercise-4.2-1Download
Exercise-4.3-1Download
Exercise-4.4-1Download
Exercise-4.5-1Download
Exercise-4.6-1Download
Exercise-4.7-1Download
Exercise-4.8-1Download

Author Mr AliPosted on November 4, 2020November 4, 2020Categories SpreadsheetsTags Level 1 spreadsheets, spreadsheets

Spreadsheets – IF formulas

Lesson Aim

  • Re-inforce creation of formulas
  • Create IF Formulas
  • Created Nested IF Formulas

Task

Download the worksheets below and complete the tasks

If-Statment-Tasks1Download
If-Statment-Tasks-ExtensionDownload
If-Statment-Tasks-Part-2-New-TaskDownload

Extension

VlookupsDownload
Author Mr AliPosted on October 2, 2020Categories Access to Higher Education, SpreadsheetsTags IF Formula, spreadsheets, Vlookup

Spreadsheet Exercises

Lesson Aim

Introduce Spreadsheet Terminology

Learn to Create Formulas in Spreadsheets

Tasks

Download the files below and work through the exercises

Skills-Lesson-(Part-1)Download
Skills-Lesson-Part-2Download

Extension

If-Statment-Tasks1Download
If-Statment-Tasks-ExtensionDownload
If-Statment-Tasks-Part-2-New-TaskDownload

Author Mr AliPosted on September 25, 2020October 2, 2020Categories UncategorizedTags Complex formula, Level 3 Spreadsheets, spreadsheets

Introduction to Spreadsheets (BUH)

Lesson Aim

  • Learn spreadsheet vocabulary

  • Create simple formulas

Starter

test_your_skills

Main Task 

Download and complete the spreadsheet below:

Week 3 tuckshop – worksheet 17

Week 3 tuckshop with worksheet 17

Plenary

Plenary task

 

Author Mr AliPosted on March 15, 2019March 8, 2019Categories Spreadsheets, Year 7 SpreadsheetsTags Modelling, spreadsheets, Year 7

Spreadsheets plenary

Plenary

Quiz game

Author Mr AliPosted on February 21, 2018May 21, 2018Categories SpreadsheetsTags spreadsheets

Protected: Year 7 – Spreadsheet exercises

This content is password protected. To view it please enter your password below:

Author Mr AliPosted on June 20, 2017June 20, 2017Categories Uncategorized, Year 7, Year 7 SpreadsheetsTags spreadsheets, Year 7

Year 8 – Spreadsheet task

Lesson Aim

  • Reinforce spreadsheet skills
  • Create formulas using functions (sum, count)

You will need to work on the worksheets in Spreadsheet below to revise all the spreadsheet techniques you learnt last year.

Spreadsheet task

Extension

Complete the spreadsheet below

Extension task

 

Author Mr AliPosted on May 9, 2011May 10, 2019Categories Spreadsheets, Year 8Tags Modelling, spreadsheets, Year 8

Time in Huddersfield

  • Home
  • GCSE Computing
    • GCSE Revision Videos
    • Year 10 Linux Tracking
  • Btec ICT
    • Btec U1 Component 2
    • Unit 43 – P1
    • Unit 43 – P5
    • Unit 43 – P6
    • Unit 38 – P1, M1 & D1
    • Task 1 – Interactive multimedia authoring
  • ICTED VLE
  • Personal
    • My Arabic Books
    • Arabic II
    • Calendar
    • Equipment Form
    • ICTED Owncloud
    • Moderation Form
    • My Email
    • School Timetable
    • Timesheet
  • Resources
    • Fireworks Tutorials
    • English padlet
    • Learn English
    • Comped links
      • Pupil Review
      • Year 7 Course
      • Year 8 Course
      • Year 9 Course
      • Comped Online
      • Computing Central
      • Festive Fun
    • Audio Resources
    • E-Safety
    • Examples of OCR Nationals Animation work
    • Pe link1
    • Pe link 2
    • ICT Pupil Voice
    • Kirklees Options
    • Year 8 Homework
    • Cover Mr Ali
Mr Ali's ICT Blog Proudly powered by WordPress