Lesson Plan

Subject: DT
Topic: Introduction to creating Spread-sheets
Period: 4
Date: 18 May 10
Year: 9
Lesson #
Resources
Introduction to Excel pp. 3 to 15





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.

Time
Activity
Content
Assessment
5 minutes

10 minutes

10 minutes


20 minutes


5 minutes


5 minutes


5 Wrap-up
Introduction…

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