14


 * Lesson Plan **

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

. ||
 * **Learning Outcomes: **
 * Students will be able to set up the Workspace, document, adding and arranging pages.
 * <span style="font-family: 'Arial Narrow',sans-serif;">Students will develop an understanding of formatting spreadsheets using MSExcel:
 * <span style="font-family: 'Arial Narrow',sans-serif;">Heading (merge & center); center on page,
 * <span style="font-family: 'Arial Narrow',sans-serif;">Borders & shading
 * <span style="font-family: 'Arial Narrow',sans-serif;">Page preview & print
 * <span style="font-family: 'Arial Narrow',sans-serif;">Student will develop auto-calculations using various formulae
 * <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 basic spreadsheets using MSExcel ||
 * **<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 formatting in Excel

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

<span style="font-family: 'Arial Narrow',sans-serif;">Make sure that students set up the print-page

<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.28

<span style="font-family: 'Arial Narrow',sans-serif;">Discuss with students <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;"> ways of planning cells for a document
 * <span style="font-family: 'Arial Narrow',sans-serif;">Headings – merge & center
 * <span style="font-family: 'Arial Narrow',sans-serif;">Borders & shading
 * <span style="font-family: 'Arial Narrow',sans-serif;">Adding a header & student name
 * <span style="font-family: 'Arial Narrow',sans-serif;">Print-preview & center on page

<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 calculations

<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

<span style="font-family: 'Arial Narrow',sans-serif;">Page 147 || * <span style="font-family: 'Arial Narrow',sans-serif;">Check to see that the values are correct
 * <span style="font-family: 'Arial Narrow',sans-serif;">Formatting: bold & centered titles, bold totals, borders
 * <span style="font-family: 'Arial Narrow',sans-serif;">Only one page printed, table is I the center of the page
 * <span style="font-family: 'Arial Narrow',sans-serif;">Student’s name in the header ||