13


 * Lesson Plan **

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

. ||
 * **Learning Outcomes: **
 * Students will develop an understanding of creating and managing basic spreadsheets using MSExcel.
 * <span style="font-family: 'Arial Narrow',sans-serif;">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 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 auto sum

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

<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 – pp.27 & 28

<span style="font-family: 'Arial Narrow',sans-serif;">Displaying how auto-sum can be performed:
 * <span style="font-family: 'Arial Narrow',sans-serif;">Summing up values in a column
 * <span style="font-family: 'Arial Narrow',sans-serif;">Summing up values in a row
 * <span style="font-family: 'Arial Narrow',sans-serif;">Adding values to check the grand total

<span style="font-family: 'Arial Narrow',sans-serif;">Students will <span style="font-family: 'Arial Narrow',sans-serif;">perform auto-sum, format cells, put borders ||
 * <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;">Check to see the Students have been able to -