Lesson Plan

Subject: DT
Topic: Excel Spread-sheets: formatting, printing, formulae
Period: 1
Date: 21 May 10
Year: 9
Lesson #
Computer Applications for Year 9/10 – pp.145

Learning Outcomes:
  • Students will be able to set up the Workspace, document, adding and arranging pages.
  • Students will develop an understanding of formatting spreadsheets using MSExcel:
    • Heading (merge & center); center on page,
    • Borders & shading
    • Page preview & print
  • Student will develop auto-calculations using various formulae
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 basic spreadsheets using MSExcel

5 minutes

10 minutes

10 minutes

20 minutes

5 minutes

5 minutes

5 Wrap-up

Touch typing

Introducing formatting in Excel

Practicing Excel

Make sure that students set up the print-page

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

Students practice touch typing – pp.28

Discuss with students
  • ways of planning cells for a document
  • Headings – merge & center
  • Borders & shading
  • Adding a header & student name
Displaying the importance of setting up a document for print
  • Print-preview & center on page

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

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

Page 147
  • Check to see that the values are correct
  • Formatting: bold & centered titles, bold totals, borders
  • Only one page printed, table is I the center of the page
  • Student’s name in the header