12


 * Lesson Plan **

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

. ||
 * **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.
 * <span style="font-family: 'Arial Narrow',sans-serif;">Link to the Curriculum: **
 * <span style="font-family: Calibri,sans-serif;">‘**Technological Products**’ – Students understand that materials/software can be used to form, manipulate and transform…. to enhance….. for a particular purpose
 * <span style="font-family: Calibri,sans-serif;"> ‘**Technological Knowledge**’ – Students design prototypes and evaluate them

<span style="font-family: 'Arial Narrow',sans-serif;">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. ||
 * **<span style="font-family: 'Arial Narrow',sans-serif;">Expected prior knowledge: **


 * **<span style="font-family: 'Arial Narrow',sans-serif;">Time ** || **<span style="font-family: 'Arial Narrow',sans-serif;">Activity ** || **<span style="font-family: 'Arial Narrow',sans-serif;">Content ** || **<span style="font-family: 'Arial Narrow',sans-serif;">Assessment ** ||
 * <span style="font-family: 'Arial Narrow',sans-serif;">5 minutes

<span style="font-family: 'Arial Narrow',sans-serif;">10 minutes

<span style="font-family: 'Arial Narrow',sans-serif;">10 minutes

<span style="font-family: 'Arial Narrow',sans-serif;">20 minutes

<span style="font-family: 'Arial Narrow',sans-serif;">5 minutes

<span style="font-family: 'Arial Narrow',sans-serif;">5 minutes

<span style="font-family: 'Arial Narrow',sans-serif;">5 Wrap-up || <span style="font-family: 'Arial Narrow',sans-serif;">Introduction…

<span style="font-family: 'Arial Narrow',sans-serif;">Touch typing

<span style="font-family: 'Arial Narrow',sans-serif;">Introducing Excel

<span style="font-family: 'Arial Narrow',sans-serif;">Practising Excel

<span style="font-family: 'Arial Narrow',sans-serif;">Introducing Print page set up

<span style="font-family: 'Arial Narrow',sans-serif;">Recap/Inspiration for future lessons || <span style="font-family: 'Arial Narrow',sans-serif;">Instructions for the tasks on the board

<span style="font-family: 'Arial Narrow',sans-serif;">Students practice touch typing


 * <span style="font-family: 'Arial Narrow',sans-serif;">Creating a new document
 * <span style="font-family: 'Arial Narrow',sans-serif;">Saving, printing
 * <span style="font-family: 'Arial Narrow',sans-serif;">Adding and arranging pages

<span style="font-family: 'Arial Narrow',sans-serif;">Students will
 * <span style="font-family: 'Arial Narrow',sans-serif;">Set up a document
 * <span style="font-family: 'Arial Narrow',sans-serif;">Enter values in the cells
 * <span style="font-family: 'Arial Narrow',sans-serif;">Format the cells
 * <span style="font-family: 'Arial Narrow',sans-serif;">Do the summing calculations

<span style="font-family: 'Arial Narrow',sans-serif;">Displaying the importance of setting up a document for print

<span style="font-family: 'Arial Narrow',sans-serif;">Students will
 * <span style="font-family: 'Arial Narrow',sans-serif;">Set up a document for print
 * <span style="font-family: 'Arial Narrow',sans-serif;">Print the document ||  ||