Resources 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

Time

Activity

Content

Assessment

5 minutes

10 minutes

10 minutes

20 minutes

5 minutes

5 minutes

5 Wrap-up

Introduction…

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

Lesson PlanSubject:DTTopic:Excel Spread-sheets: formatting, printing, formulaePeriod:1Date: 21 May 10Year:9Lesson #ResourcesComputer Applications for Year 9/10 – pp.145

Learning Outcomes:Link to the Curriculum:- ‘
- ‘

.Technological Products’ – Students understand that materials/software can be used to form, manipulate and transform…. to enhance….. for a particular purposeTechnological Knowledge’ – Students design prototypes and evaluate themExpected prior knowledge:Students will have already looked at creating and managing basic spreadsheets using MSExcel

TimeActivityContentAssessment10 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

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 printStudents will

Students will

Page 147