Lesson Plan

Subject: DT
Topic: Excel Spread-sheets:
Date: 19 May 10
Year: 9
Lesson #
Introduction to Excel pp.

Learning Outcomes:
  • Students will develop an understanding of creating and managing basic spreadsheets using MSExcel.
  • Students will be able to set up the Workspace, document, adding and arranging pages.
Link to the Curriculum:
  • Technological Products’ – Students understand that materials/software can be used to form, manipulate and transform…. to enhance….. for a particular purpose
  • Technological Knowledge’ – Students design prototypes and evaluate them

Expected prior knowledge:
Students will have already looked at creating and managing documents using MS Word and PowerPoint; this lesson could be a refresher at the beginning of a new project.

5 minutes

10 minutes

10 minutes

20 minutes

5 minutes

5 minutes

5 Wrap-up

Touch typing

Introducing Excel

Practising Excel

Introducing Print page set up

Recap/Inspiration for future lessons
Instructions for the tasks on the board

Students practice touch typing

  • Creating a new document
  • Saving, printing
  • Adding and arranging pages

Students will
  • Set up a document
  • Enter values in the cells
  • Format the cells
  • Do the summing calculations

Displaying the importance of setting up a document for print

Students will
  • Set up a document for print
  • Print the document