Docstoc

Starting a Coffee Shop Business

Document Sample
Starting a Coffee Shop Business Powered By Docstoc
					Course          BTEC National Diploma IT Practitioner

Module / unit   Business Information Systems

Tutor           Andrew Hill

Site            Dunstable

Room No.        A404

Group size      16

Start time      1:15pm

End time        2:45pm

Course notes    This unit deals with the different types of business and
                business structure, with the emphasis on a range of IT
                solutions to enhance efficiency of operation and an
                understanding of the various processes involved from
                starting up to getting feedback from customers.


Week No.        Date             Topic

                                 Induction




        1       9/11/2006




                                 Introduction to the unit




       2        9/18/2006
                 Business links




3   9/25/2006




                 The Coffee Shop




4   10/2/2006




                 What profit or loss am I going to make
                 each month?



5   10/9/2006




                 review week




6   10/16/2006




                 half-term




7   10/23/2006
                  The cashflow forecast




8    10/30/2006




                  making Excel look good




9    11/6/2006




                  Using Excel as a database for Word
                  mailshots



10   11/13/2006




                  Departments




11   11/20/2006




                  Departments




12   11/27/2006
                  Data handling and processing




13   12/4/2006




                  Data handling and processing




14   12/11/2006




                  Christmas holiday




15   12/18/2006




                  Christmas holiday




16   12/25/2006




                  Christmas holiday




17   1/1/2007
                 Business system: protection (health
                 and saftey)



18   1/8/2007




                 Business systems: protection (security
                 of data)



19   1/15/2007




                 E-commerce




20   1/22/2007




                 E-commerce




21   1/29/2007




22   2/5/2007



                 Review
                 half-term




23   2/12/2007




                 System life cycle




24   2/19/2007




                 System life cycle




25   2/26/2007




                 Accounts




26   3/5/2007
                 Promotion and marketing




27   3/12/2007




                 Web sites




28   3/19/2007




                 Review




29   3/26/2007




                 Easter holiday




30   4/2/2007
                Easter holiday




31   4/9/2007
Use this sheet to enter all your course and
lesson information.

Whatever you type in the white areas will be
included in the scheme of work and lesson
plans as appropriate. The scheme of work
will print as a portrait document with no
coloured background, showing the essential
information. The lesson plans will print as
single sheet A4 documents with some
highlighted section titles.

There may be additional entries required for
individual lesson plans which can be added
as you wish, including marking the section
to indicate teaching and learning methods
and Key Skills information.

If you print this sheet you'll soon run out of
blue ink!



Tutor activity                                   Student Activity

Range of induction activities                    Follow induction programme




Description of the unit coverage and             View the information provided about
criteria                                         the unit on-line
Provide an example of the type of work           Discuss what they understand by
involved and standards expected                  'business'
Encourage discussion of what 'business'
is all about
Get a discussion going on all the links     Discuss how all the many activities of a
that are involved in a typical business.    typical business are linked and suggest
Ask for which IT systems might be           solutions using IT systems to make
effectively utilised.                       those links efficient and accurate.
Describe how they might record simple       Make a simple spreadsheet suitable for
data like personnel information             maintaining data about customers or
                                            staff




Set the scene: students are to run a        Prepare a spreadhseet that lists
small coffee shop business. Get them to     estimated costs and sale proceeds for
list what they need to buy, think about     the various elements involved in
when their customers might come and         running a coffee shop.
how many. Suggest ways in which they        Consider how changing the cost of
can get Excel to calculate their possible   some elements might change the price
total costs or profitability - and how to   charged.
spot obvious errors!                        Discuss other features that might be
                                            resolved using a spreadsheet



Follow on from the previous tasks by        Create a simple income and
bring information together into a sheet     expenditure spreadsheet that records
that shows how things might progress        sales and purchases and indicates
throughout a year.                          monthly profits or shortfalls.
Provide a simple example and
encourage discussion as to how this can
be made to work in Excel.
Demonstrate an example of a                 Add data to a ready-made Excel
completed cash flow forecast in Excel       workbook and note the effects on that
Indicate how data can be entered and        proposed business plan.
the effect of changes immediately made      Create a monthly distribution table
clear using charts                          which is linked to a graph.
Explain how the input distribution
section works and support students in
creating their own versions




Demonstrate tips and tricks in Excel        Take an existing data sheet and re-
and alternative spreadsheet                 work it to make it more presentable
programmes                                  and/or user-friendly
Show how default settings can be            Try out on-line alternatives to
changed and how the careful use of          Microsoft products
colours and lines can make sheets much      Draw some conclusions as to relative
easier to understand and interpret          advantages and disadvantages of colour
Illustrate the classic printing problems!   schemes and alternative software




Describe the process of merging data        Follow instructions to create a mailshot
stored in a spreadsheet with a text file    to selected 'customers' and note
                                            problems experienced and potential
                                            difficulties that might be experienced in
                                            real life




Describe the main departments, or           Consider different departments and
operational centres, found in typical       investigate their roles and requirements
businesses and encourage discussion of
their IT support needs and staff ICT
skill needs




Describe the main departments, or           Consider different departments and
operational centres, found in typical       investigate their roles and requirements
businesses and encourage discussion of
their IT support needs and staff ICT
skill needs
Illustrate various methods of data        Describe the various ways for
handling and explain why some are         managing data by illustrating a process
more appropriate to each type of data     from data input through to utilisation
Link to previous session findings as to   in various departments
support needs




Illustrate various methods of data        Describe the various ways for
handling and explain why some are         managing data by illustrating a process
more appropriate to each type of data     from data input through to utilisation
Link to previous session findings as to   in various departments
support needs




Christmas holiday                         Christmas holiday




Christmas holiday                         Christmas holiday




Christmas holiday                         Christmas holiday
Explain some of the many 'risks'           Investigate the key features of Health &
inherent in any business and lead          safety legislation and consider how
discussion and research regarding legal    these affect various elements of
requirements and sensible precautions      different types of business, from, for
                                           example a simple office environment to
                                           a fuel transport firm




Describe some of the important issues      How can data get 'damaged'? How
relating to security of data and           would you know? Groups to look at
problems that can arise if this is not     arange of types of data and report on
managed properly                           what may go wrong with it and how
Promote investigation into the extent to   they might avoid problems
which types of data can be shared and
how processes can be put in place to
check that it is accurate




The growing use of web sites for trade     Choose a business activity in which
and promotion will be illustrated, using   they have a genuine interest and
a range of examples and to lead            investigate the extent to which
students into describing how they          competitors in that field currently use
might assess whether their choice of       the web to trade
activity might effectively utilise this
medium




The growing use of web sites for trade     Choose a business activity in which
and promotion will be illustrated, using   they have a genuine interest and
a range of examples and to lead            investigate the extent to which
students into describing how they          competitors in that field currently use
might assess whether their choice of       the web to trade
activity might effectively utilise this
medium




Review                                     Review
half-term                                 half-term




Explain and illustrate what a 'system     Illustrate a system life cycle in their
life cycle is'                            own way, using graphic techniques or
Provide examples in practice              clear text explanations.
                                          Indicate how it might apply to a real
                                          process (other than the one I used!)




More in-depth examination of the          Divide stages amongst the group and
stages in the cycle and how IT can        each to look in more detail at what they
support the processes involved            mean, with reference to a particular
Provide real examples to consider         process or activity
                                          Representatives for each 'stage' to
                                          display or present findings as a sort of
                                          continuous role play




Show how money comes into a business      Group to divide into suppliers, sellers,
and flows through various departments     accountants, tax men and customers
and some of the basic accounting          and draft examples of the paperwork
necessities to manage the flow            they think they need to record their
Revisit the cash flow task from earlier   part of the process of a selection of
sessions                                  goods from supplier to customer
Illustrate a purchase order and a sales
invoice
Explain how marketing is at the heart     Groups to consider how they would
of all business in one shape or another   promote an organisation or activity, or
and various techniques utilised in        internal marketing such as consistent
promotion                                 design of a range of department
the importance of a brand image, logos,   stationery and then to act as critics or
themes etc.                               users for others' productions
How IT supports these aspects and can
also adversely affect them if not well
managed




Identification of the main types of web   rate a given selection of sites as to what
site                                      their purpose is and how well they meet
How well do they do their job?            the needs of users
Explain the IT support relevant to a      Note which aspects of the site would
selected site                             need regular maintenance or updating
                                          / checking and who would be involved
                                          in the process




Review                                    Review




Easter holiday                            Easter holiday
Easter holiday   Easter holiday
Learning outcomes                       Assessment

Students to be aware of course aims
and College procedures and to ensure
that students are on the right course




Students to understand the unit, what
knowldege and practical skills are
required and how it will be assessed.
A simple spreadsheet with appropriate
headings for recording a good range of
staff or customer-type details that could
be utilised for a mailshot or similar
purpose




Students will be able to list the main
costs of a small coffee shop, with some
estimated costs and prices in a sheet
which will update figures when some
elements are changed




A working spreadhseet, correctly saved
and named, that contains correct
formulae for calculating profits or
shortfalls.
Students will be able to recognise when
a business might go 'into the red' and
estimate by how much and when.
They will also be able to amend initial
data and note the effect on a business
finance requirements
Students will be able to design and
create a working spreadsheet that
shows how data is distributed over time



Students will be able to change cell
shades and font styles without losing
existing data and will recognise how
legibility, use of paper and ink and
overall design can be improved




Students should print some sample text
sheets incorporating data from a
spreadsheet, with accurate selection of
customers and positioning of content,
noting methods to ensure protection of
original data




List some of the main IT support needs
and ICT skills expected of staff




List some of the main IT support needs
and ICT skills expected of staff
A report illustrating how data may be
used on multiple occasions throughout
different departments and how cehcks
can be incorporated to ensure its
accuracy




A report illustrating how data may be
used on multiple occasions throughout
different departments and how cehcks
can be incorporated to ensure its
accuracy




Christmas holiday




Christmas holiday




Christmas holiday
Students will be aware of the principal
Health & Safety Acts at the current time
and what the most important features
are that affect business, managers, staff
and customers and will be able to
illustrate examples of potential risks in
real-life, which legislation applies and
what action should be taken by whom




Students will be aware of how easily
data can become corrupted, or
deliberately altered, unless proper
management is in place.




Understand the main features of e-
commerce, its advantages and
disadvantages in a particular business
situation.
Report on their findings and which real-
life organisations have used e-
commerce effectively




Understand the main features of e-
commerce, its advantages and
disadvantages in a particular business
situation.
Report on their findings and which real-
life organisations have used e-
commerce effectively




Review
half-term




Clear demonstration of a basic
understanding of what a system life
cycle is by an annotated illustration or
plain English document




Embedded understanding of the cycle
and knowing what the stages are and to
be able to relate them to something that
they can identify with




Students will have an understanding of
the main features of the forms involved
and essential accounting information
necessary
Students should be able to recognise
the main features of good practice in
using ICT in marketing or promotional
work and both to produce an comment
constructively on samples




Students should be able to recognise
the main types of web site in terms of
purpose and to list those areas of a
business web site that would need
regular attention to ensure currency,
accuracy and authority




Review




Easter holiday
Easter holiday
Resources                            For more advanced learners

Induction programme




On-line unit information
BTEC unit description and criteria
Lots of scope!




More advanced formulae and smart
design of the sheet can make many
parts of this task much easier.




This task has many opportunities for
extension - linking income to
calculations on other sheets, for
example, as well as better formatting of
the sheet itself.
Projector and screen                    It would be useful to have a check that
Excel chart notes                       the total expected annual income is an
Dunn accounts notes                     appropriate figure - students may wish
                                        to consider and apply more advanced
                                        formulae to provide feedback to a user
                                        on this
                                        Those familiar with charts may wish to
                                        create a more interesting or better
                                        designed layout or representation



                                        Linking data on sheets, providing data
                                        input forms and more advanced design
                                        features offer plenty for experts to
                                        experiment with




Customer data                           Use more advanced field techniques to
Standard text for promotional mailing   add paragraphs for certain records that
Notes for mail merge                    satisfy stated criteria




sample real-life departments and        obtain some real information from
organisational structures               organisations to contribute to further
                                        discussion and learning on this topic




                                        Lead discussion and present findings
                                        on real organisations
Up-to-date lists of pertinent legislation,   There is a never-ending list of statutes
including latest EC directives               and proposed legislation within the EC
(especially any that match current or        that even the most informed student
recent events or are particularly odd or     will find challenging to research.
memorable!)
Speaker from TUC H&S Dept.




Selection of masses of data which is in      validation controls for data entry can
forms that is either 'protected' or able     be included in most databases and they
to be changed with some built-in error       may wish to investigate some methods.
warnings that will appear, depending         If there are any 'hackers' in the group
upon how they handle it                      then their services could usefully be
                                             employed for a live demonstration,
                                             perhaps.




                                             Consider areas of activity or types of
                                             business where e-commerce might not
                                             necessarily be effective




                                             Consider areas of activity or types of
                                             business where e-commerce might not
                                             necessarily be effective
Clear illustrations of a system life cycle
and prepared examples of application
to something familiar to students




May need to have a cartoon 'sample' of
how they might consider acting out the
various stages




selection of 'products' to use in role play   The Dunn accounts package used
some real forms for each of the sub-          earlier has many further facilities that
groups                                        could be developed
sample real forms
scenarios for students to use if        This is one of those areas where even
necessary                               the most advanced students can still
good and bad examples of ICT use in     learn something, especially in image
marketing and theming or branding       processing, customer research methods
                                        and data collection so there should be
                                        something for everyone




list of sample web site addresses for   Investigate the potential costs of
evaluation                              establishing a web site
evaluation forms for completion
Notes                                     Risk assessment

Session to be led by Course Manager
Group may be subject to change




Find out who is new to or familiar with
the idea of business so that the latter
may be able to help the former
Beware of the temptations of 'surfing'!
Check that they can access the VLE OK
First efforts will look pretty boring but
encourage people to stick with the
defaults until it's working OK and then
copy the sheet before messing about
with colours etc.
There are lots of resources within the
Dunn accounts package - advise
students that they need not be
concerned with accounting sheets!
Some versions of Excel may prompt to
save in different editions - no problem.
Beware that the hackers don't go too
far!
Evaluation
Scheme of Work                                                                                                 Dunstable College
                                                                                                                        2006-07

        Course             BTEC National Diploma IT Practitioner

        Module / unit      Business Information Systems

        Tutor              Andrew Hill

        Site               Dunstable

        Room No.           A404

        Group                                                                      16

        Start time         1:15pm

        End time           2:45pm

        Course notes       This unit deals with the different types of business and business structure, with the
                           emphasis on a range of IT solutions to enhance efficiency of operation and an
                           understanding of the various processes involved from starting up to getting feedback from
                           customers.




        Week No          1 Date         9/11/2006 Topic     Induction
        Tutor activity                             Student activity                     Resources
        Range of induction activities              Follow induction programme           Induction programme




        Week No          2 Date         9/18/2006 Topic     Introduction to the unit
        Tutor activity                             Student activity                     Resources
        Description of the unit coverage and       View the information provided        On-line unit information
        criteria                                   about the unit on-line               BTEC unit description and
        Provide an example of the type of          Discuss what they understand by      criteria
        work involved and standards expected       'business'
        Encourage discussion of what
        'business' is all about




        Week No          3 Date         9/25/2006 Topic     Business links
        Tutor activity                             Student activity                    Resources
        Get a discussion going on all the links    Discuss how all the many activities
        that are involved in a typical business.   of a typical business are linked
        Ask for which IT systems might be          and suggest solutions using IT
        effectively utilised.                      systems to make those links
        Describe how they might record             efficient and accurate.
        simple data like personnel information     Make a simple spreadsheet
                                                   suitable for maintaining data
                                                   about customers or staff




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 8/22/2011                                                                         49 / 88
Scheme of Work                                                                                                 Dunstable College
                                                                                                                        2006-07
        Week No          4 Date      10/2/2006 Topic         The Coffee Shop
        Tutor activity                            Student activity                      Resources
        Set the scene: students are to run a      Prepare a spreadhseet that lists
        small coffee shop business. Get them      estimated costs and sale proceeds
        to list what they need to buy, think      for the various elements involved
        about when their customers might          in running a coffee shop.
        come and how many. Suggest ways in        Consider how changing the cost of
        which they can get Excel to calculate     some elements might change the
        their possible total costs or             price charged.
        profitability - and how to spot obvious   Discuss other features that might
        errors!                                   be resolved using a spreadsheet
        Week No          5 Date      10/9/2006 Topic         What profit or loss am I going to make each month?
        Tutor activity                            Student activity                      Resources
        Follow on from the previous tasks by      Create a simple income and
        bring information together into a         expenditure spreadsheet that
        sheet that shows how things might         records sales and purchases and
        progress throughout a year.               indicates monthly profits or
        Provide a simple example and              shortfalls.
        encourage discussion as to how this
        can be made to work in Excel.



        Week No          6 Date    10/16/2006 Topic          review week
        Tutor activity                            Student activity                      Resources




        Week No          7 Date    10/23/2006 Topic          half-term
        Tutor activity                            Student activity                      Resources




        Week No          8 Date    10/30/2006 Topic          The cashflow forecast
        Tutor activity                            Student activity                      Resources
        Demonstrate an example of a               Add data to a ready-made Excel        Projector and screen
        completed cash flow forecast in Excel     workbook and note the effects on      Excel chart notes
        Indicate how data can be entered and      that proposed business plan.          Dunn accounts notes
        the effect of changes immediately         Create a monthly distribution table
        made clear using charts                   which is linked to a graph.
        Explain how the input distribution
        section works and support students in
        creating their own versions




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 8/22/2011                                                                         50 / 88
Scheme of Work                                                                                                  Dunstable College
                                                                                                                         2006-07
        Week No          9 Date      11/6/2006 Topic         making Excel look good
        Tutor activity                              Student activity                    Resources
        Demonstrate tips and tricks in Excel        Take an existing data sheet and re-
        and alternative spreadsheet                 work it to make it more
        programmes                                  presentable and/or user-friendly
        Show how default settings can be            Try out on-line alternatives to
        changed and how the careful use of          Microsoft products
        colours and lines can make sheets           Draw some conclusions as to
        much easier to understand and               relative advantages and
        interpret                                   disadvantages of colour schemes
        Illustrate the classic printing problems!   and alternative software
        Week No        10 Date      11/13/2006 Topic         Using Excel as a database for Word mailshots
        Tutor activity                           Student activity                       Resources
        Describe the process of merging data     Follow instructions to create a        Customer data
        stored in a spreadsheet with a text file mailshot to selected 'customers'       Standard text for promotional
                                                 and note problems experienced          mailing
                                                 and potential difficulties that        Notes for mail merge
                                                 might be experienced in real life




        Week No        11 Date      11/20/2006 Topic         Departments
        Tutor activity                              Student activity                    Resources
        Describe the main departments, or           Consider different departments      sample real-life departments
        operational centres, found in typical       and investigate their roles and     and organisational structures
        businesses and encourage discussion         requirements
        of their IT support needs and staff ICT
        skill needs




        Week No        12 Date      11/27/2006 Topic         Departments
        Tutor activity                              Student activity                    Resources
        Describe the main departments, or           Consider different departments      Lead discussion and present
        operational centres, found in typical       and investigate their roles and     findings on real organisations
        businesses and encourage discussion         requirements
        of their IT support needs and staff ICT
        skill needs




        Week No        13 Date       12/4/2006 Topic         Data handling and processing
        Tutor activity                              Student activity                   Resources
        Illustrate various methods of data          Describe the various ways for
        handling and explain why some are           managing data by illustrating a
        more appropriate to each type of data       process from data input through to
        Link to previous session findings as to     utilisation in various departments
        support needs




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 8/22/2011                                                                          51 / 88
Scheme of Work                                                                                                  Dunstable College
                                                                                                                         2006-07
        Week No        14 Date      12/11/2006 Topic        Data handling and processing
        Tutor activity                            Student activity                   Resources
        Illustrate various methods of data        Describe the various ways for
        handling and explain why some are         managing data by illustrating a
        more appropriate to each type of data     process from data input through to
        Link to previous session findings as to   utilisation in various departments
        support needs




        Week No        15 Date      12/18/2006 Topic        Christmas holiday
        Tutor activity                            Student activity                      Resources
        Christmas holiday                         Christmas holiday




        Week No        16 Date      12/25/2006 Topic        Christmas holiday
        Tutor activity                            Student activity                      Resources
        Christmas holiday                         Christmas holiday




        Week No        17 Date        1/1/2007 Topic        Christmas holiday
        Tutor activity                            Student activity                      Resources
        Christmas holiday                         Christmas holiday




        Week No        18 Date        1/8/2007 Topic        Business system: protection (health and saftey)
        Tutor activity                            Student activity                      Resources
        Explain some of the many 'risks'          Investigate the key features of       Up-to-date lists of pertinent
        inherent in any business and lead         Health & safety legislation and       legislation, including latest EC
        discussion and research regarding         consider how these affect various     directives (especially any that
        legal requirements and sensible           elements of different types of        match current or recent events
        precautions                               business, from, for example a         or are particularly odd or
                                                  simple office environment to a fuel   memorable!)
                                                  transport firm                        Speaker from TUC H&S Dept.




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 8/22/2011                                                                          52 / 88
Scheme of Work                                                                                                  Dunstable College
                                                                                                                         2006-07
        Week No          19 Date     1/15/2007 Topic         Business systems: protection (security of data)
        Tutor activity                            Student activity                      Resources
        Describe some of the important issues     How can data get 'damaged'? How       Selection of masses of data
        relating to security of data and          would you know? Groups to look        which is in forms that is either
        problems that can arise if this is not    at arange of types of data and        'protected' or able to be
        managed properly                          report on what may go wrong with      changed with some built-in
        Promote investigation into the extent     it and how they might avoid           error warnings that will appear,
        to which types of data can be shared      problems                              depending upon how they
        and how processes can be put in place                                           handle it
        to check that it is accurate


        Week No          20 Date     1/22/2007 Topic         E-commerce
        Tutor activity                            Student activity                      Resources
        The growing use of web sites for trade    Choose a business activity in
        and promotion will be illustrated,        which they have a genuine
        using a range of examples and to lead     interest and investigate the extent
        students into describing how they         to which competitors in that field
        might assess whether their choice of      currently use the web to trade
        activity might effectively utilise this
        medium



        Week No          21 Date     1/29/2007 Topic         E-commerce
        Tutor activity                            Student activity                      Resources
        The growing use of web sites for trade    Choose a business activity in
        and promotion will be illustrated,        which they have a genuine
        using a range of examples and to lead     interest and investigate the extent
        students into describing how they         to which competitors in that field
        might assess whether their choice of      currently use the web to trade
        activity might effectively utilise this
        medium



        Week No          22 Date      2/5/2007 Topic         Review
        Tutor activity                            Student activity                      Resources
        Review                                    Review




        Week No          23 Date     2/12/2007 Topic         half-term
        Tutor activity                            Student activity                      Resources
        half-term                                 half-term




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 8/22/2011                                                                          53 / 88
Scheme of Work                                                                                                     Dunstable College
                                                                                                                            2006-07
        Week No        24 Date       2/19/2007 Topic        System life cycle
        Tutor activity                            Student activity                        Resources
        Explain and illustrate what a 'system     Illustrate a system life cycle in       Clear illustrations of a system
        life cycle is'                            their own way, using graphic            life cycle and prepared
        Provide examples in practice              techniques or clear text                examples of application to
                                                  explanations.                           something familiar to students
                                                  Indicate how it might apply to a
                                                  real process (other than the one I
                                                  used!)



        Week No        25 Date       2/26/2007 Topic        System life cycle
        Tutor activity                            Student activity                        Resources
        More in-depth examination of the          Divide stages amongst the group         May need to have a cartoon
        stages in the cycle and how IT can        and each to look in more detail at      'sample' of how they might
        support the processes involved            what they mean, with reference to       consider acting out the various
        Provide real examples to consider         a particular process or activity        stages
                                                  Representatives for each 'stage' to
                                                  display or present findings as a
                                                  sort of continuous role play



        Week No        26 Date        3/5/2007 Topic        Accounts
        Tutor activity                            Student activity                        Resources
        Show how money comes into a               Group to divide into suppliers,         selection of 'products' to use in
        business and flows through various        sellers, accountants, tax men and       role play
        departments and some of the basic         customers and draft examples of         some real forms for each of the
        accounting necessities to manage the      the paperwork they think they           sub-groups
        flow                                      need to record their part of the        sample real forms
        Revisit the cash flow task from earlier   process of a selection of goods
        sessions                                  from supplier to customer
        Illustrate a purchase order and a sales
        invoice
        Week No        27 Date       3/12/2007 Topic        Promotion and marketing
        Tutor activity                            Student activity                        Resources
        Explain how marketing is at the heart     Groups to consider how they             scenarios for students to use if
        of all business in one shape or another   would promote an organisation or        necessary
        and various techniques utilised in        activity, or internal marketing         good and bad examples of ICT
        promotion                                 such as consistent design of a          use in marketing and theming
        the importance of a brand image,          range of department stationery          or branding
        logos, themes etc.                        and then to act as critics or users
        How IT supports these aspects and         for others' productions
        can also adversely affect them if not
        well managed
        Week No        28 Date       3/19/2007 Topic        Web sites
        Tutor activity                            Student activity                        Resources
        Identification of the main types of web   rate a given selection of sites as to   list of sample web site
        site                                      what their purpose is and how well      addresses for evaluation
        How well do they do their job?            they meet the needs of users            evaluation forms for completion
        Explain the IT support relevant to a      Note which aspects of the site
        selected site                             would need regular maintenance
                                                  or updating / checking and who
                                                  would be involved in the process




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 8/22/2011                                                                             54 / 88
Scheme of Work                                                                          Dunstable College
                                                                                                 2006-07
        Week No          29 Date     3/26/2007 Topic       Review
        Tutor activity                          Student activity            Resources
        Review                                  Review




        Week No          30 Date      4/2/2007 Topic       Easter holiday
        Tutor activity                          Student activity            Resources
        Easter holiday                          Easter holiday




        Week No          31 Date      4/9/2007 Topic       Easter holiday
        Tutor activity                          Student activity            Resources
        Easter holiday                          Easter holiday




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 8/22/2011                                                  55 / 88
Lesson Plan                                                                                                                                                                      Dunstable College
Week 1                                                                                                                                                                                    2006-07

                Course                                                         Module / Unit                                       Tutor
                BTEC National Diploma IT Practitioner                           Business Information Systems                       Andrew Hill

                Site                                                           Room                             Week no.           Date                      Group size
                Dunstable                                                      A404                             1                  9/11/2006                      16

                Start time                         End time                      Notes
                1:15pm                             2:45pm
                Topic                                                                                                            Teaching and learning methods used
                Induction
                Lesson Aims                                                                                                           Assignment               Practical activity
                Students to be aware of course aims and College procedures and to ensure that students are on the right course        Buzz Groups              Project
                                                                                                                                      Case Study               Q&A
                                                                                                                                      Debate                   Quiz
                                                                                                                                      Demonstration            Role Play
                                                                                                                                      Coaching                 Set reading
                Learning outcomes                                 For more advanced learners                                          Discussion               Simulation
                Students to be aware of course aims and College                                                                       Game                     Structural aids
                procedures and to ensure that students are on the                                                                     Group work               Tutorial
                right course                                                                                                          Ice breaker              Tutor presentation
                                                                                                                                      Learner presentation     Video/DVD
                                                                                                                                                               Other




                Resources needed                                                                                                   Notes
                Induction programme




                Basic / Key Skills development

                Communication / Literacy           Appln of Number / Numeracy             ICT                                         Other




                Risk assessment




                Tutor activity
                Range of induction activities




                Student activity
                Follow induction programme




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 1
Lesson Plan                                                                                                                                                                      Dunstable College
Week 2                                                                                                                                                                                    2006-07

                Course                                                          Module / Unit                                      Tutor
                BTEC National Diploma IT Practitioner                           Business Information Systems                       Andrew Hill

                Site                                                            Room                             Week no.          Date                      Group size
                Dunstable                                                       A404                             2                 9/18/2006                      16

                Start time                         End time                      Notes
                1:15pm                             2:45pm
                Topic                                                                                                            Teaching and learning methods used
                Introduction to the unit
                Lesson Aims                                                                                                           Assignment               Practical activity
                Students to understand the unit, what knowldege and practical skills are required and how it will be assessed.        Buzz Groups              Project
                                                                                                                                      Case Study               Q&A
                                                                                                                                      Debate                   Quiz
                                                                                                                                      Demonstration            Role Play
                                                                                                                                      Coaching                 Set reading
                Learning outcomes                                    For more advanced learners                                       Discussion               Simulation
                Students to understand the unit, what knowldege                                                                       Game                     Structural aids
                and practical skills are required and how it will be                                                                  Group work               Tutorial
                assessed.                                                                                                             Ice breaker              Tutor presentation
                                                                                                                                      Learner presentation     Video/DVD
                                                                                                                                                               Other




                Resources needed                                                                                                   Notes
                On-line unit information
                BTEC unit description and criteria




                Basic / Key Skills development

                Communication / Literacy           Appln of Number / Numeracy              ICT                                        Other




                Risk assessment




                Tutor activity
                Description of the unit coverage and criteria
                Provide an example of the type of work involved and standards expected
                Encourage discussion of what 'business' is all about



                Student activity
                View the information provided about the unit on-line
                Discuss what they understand by 'business'




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 2
Lesson Plan                                                                                                                                                                        Dunstable College
Week 3                                                                                                                                                                                      2006-07

                Course                                                          Module / Unit                                        Tutor
                BTEC National Diploma IT Practitioner                           Business Information Systems                         Andrew Hill

                Site                                                            Room                             Week no.            Date                      Group size
                Dunstable                                                       A404                             3                   9/25/2006                      16

                Start time                         End time                      Notes
                1:15pm                             2:45pm
                Topic                                                                                                              Teaching and learning methods used
                Business links
                Lesson Aims                                                                                                             Assignment               Practical activity
                A simple spreadsheet with appropriate headings for recording a good range of staff or customer-type details that        Buzz Groups              Project
                could be utilised for a mailshot or similar purpose
                                                                                                                                        Case Study               Q&A
                                                                                                                                        Debate                   Quiz
                                                                                                                                        Demonstration            Role Play
                                                                                                                                        Coaching                 Set reading
                Learning outcomes                                               For more advanced learners                              Discussion               Simulation
                A simple spreadsheet with appropriate headings                  Lots of scope!                                          Game                     Structural aids
                for recording a good range of staff or customer-                                                                        Group work               Tutorial
                type details that could be utilised for a mailshot                                                                      Ice breaker              Tutor presentation
                or similar purpose                                                                                                      Learner presentation     Video/DVD
                                                                                                                                                                 Other




                Resources needed                                                                                                     Notes




                Basic / Key Skills development

                Communication / Literacy           Appln of Number / Numeracy             ICT                                           Other




                Risk assessment




                Tutor activity
                Get a discussion going on all the links that are involved in a typical business. Ask for which IT systems might be effectively utilised.
                Describe how they might record simple data like personnel information




                Student activity
                Discuss how all the many activities of a typical business are linked and suggest solutions using IT systems to make those links
                efficient and accurate.
                Make a simple spreadsheet suitable for maintaining data about customers or staff




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 3
Lesson Plan                                                                                                                                                                            Dunstable College
Week 4                                                                                                                                                                                          2006-07

                Course                                                            Module / Unit                                          Tutor
                BTEC National Diploma IT Practitioner                             Business Information Systems                           Andrew Hill

                Site                                                              Room                              Week no.             Date                      Group size
                Dunstable                                                         A404                              4                    10/2/2006                      16

                Start time                          End time                       Notes
                1:15pm                              2:45pm
                Topic                                                                                                                  Teaching and learning methods used
                The Coffee Shop
                Lesson Aims                                                                                                                 Assignment               Practical activity
                Students will be able to list the main costs of a small coffee shop, with some estimated costs and prices in a sheet        Buzz Groups              Project
                which will update figures when some elements are changed
                                                                                                                                            Case Study               Q&A
                                                                                                                                            Debate                   Quiz
                                                                                                                                            Demonstration            Role Play
                                                                                                                                            Coaching                 Set reading
                Learning outcomes                                                 For more advanced learners                                Discussion               Simulation
                Students will be able to list the main costs of a                 More advanced formulae and smart                          Game                     Structural aids
                small coffee shop, with some estimated costs and                  design of the sheet can make many parts                   Group work               Tutorial
                prices in a sheet which will update figures when                  of this task much easier.                                 Ice breaker              Tutor presentation
                some elements are changed                                                                                                   Learner presentation     Video/DVD
                                                                                                                                                                     Other




                Resources needed                                                                                                         Notes




                Basic / Key Skills development

                Communication / Literacy            Appln of Number / Numeracy               ICT                                            Other




                Risk assessment




                Tutor activity
                Set the scene: students are to run a small coffee shop business. Get them to list what they need to buy, think about when their
                customers might come and how many. Suggest ways in which they can get Excel to calculate their possible total costs or profitability -
                 and how to spot obvious errors!



                Student activity
                Prepare a spreadhseet that lists estimated costs and sale proceeds for the various elements involved in running a coffee shop.
                Consider how changing the cost of some elements might change the price charged.
                Discuss other features that might be resolved using a spreadsheet




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 4
Lesson Plan                                                                                                                                                                             Dunstable College
Week 5                                                                                                                                                                                           2006-07

                Course                                                           Module / Unit                                            Tutor
                BTEC National Diploma IT Practitioner                            Business Information Systems                             Andrew Hill

                Site                                                             Room                             Week no.                Date                      Group size
                Dunstable                                                        A404                             5                       10/9/2006                      16

                Start time                          End time                      Notes
                1:15pm                              2:45pm
                Topic                                                                                                              Teaching and learning methods used
                What profit or loss am I going to make each month?
                Lesson Aims                                                                                                                  Assignment               Practical activity
                A working spreadhseet, correctly saved and named, that contains correct formulae for calculating profits or shortfalls.      Buzz Groups              Project
                                                                                                                                             Case Study               Q&A
                                                                                                                                             Debate                   Quiz
                                                                                                                                             Demonstration            Role Play
                                                                                                                                             Coaching                 Set reading
                Learning outcomes                                                For more advanced learners                                  Discussion               Simulation
                A working spreadhseet, correctly saved and                       This task has many opportunities for                        Game                     Structural aids
                named, that contains correct formulae for                        extension - linking income to calculations                  Group work               Tutorial
                calculating profits or shortfalls.                               on other sheets, for example, as well as                    Ice breaker              Tutor presentation
                                                                                 better formatting of the sheet itself.                      Learner presentation     Video/DVD
                                                                                                                                                                      Other




                Resources needed                                                                                                          Notes




                Basic / Key Skills development

                Communication / Literacy            Appln of Number / Numeracy             ICT                                               Other




                Risk assessment




                Tutor activity
                Follow on from the previous tasks by bring information together into a sheet that shows how things might progress throughout a
                year.
                Provide a simple example and encourage discussion as to how this can be made to work in Excel.



                Student activity
                Create a simple income and expenditure spreadsheet that records sales and purchases and indicates monthly profits or shortfalls.




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 5
Lesson Plan                                                                                                                                        Dunstable College
Week 6                                                                                                                                                      2006-07

                Course                                             Module / Unit                     Tutor
                BTEC National Diploma IT Practitioner              Business Information Systems      Andrew Hill

                Site                                               Room                 Week no.     Date                      Group size
                Dunstable                                          A404                 6            10/16/2006                     16

                Start time                   End time               Notes
                1:15pm                       2:45pm
                Topic                                                                              Teaching and learning methods used
                review week
                Lesson Aims                                                                             Assignment               Practical activity
                                                                                                        Buzz Groups              Project
                                                                                                        Case Study               Q&A
                                                                                                        Debate                   Quiz
                                                                                                        Demonstration            Role Play
                                                                                                        Coaching                 Set reading
                Learning outcomes                                  For more advanced learners           Discussion               Simulation
                                                                                                        Game                     Structural aids
                                                                                                        Group work               Tutorial
                                                                                                        Ice breaker              Tutor presentation
                                                                                                        Learner presentation     Video/DVD
                                                                                                                                 Other




                Resources needed                                                                     Notes




                Basic / Key Skills development

                Communication / Literacy     Appln of Number / Numeracy     ICT                         Other




                Risk assessment




                Tutor activity




                Student activity




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 6
Lesson Plan                                                                                                                                        Dunstable College
Week 7                                                                                                                                                      2006-07

                Course                                             Module / Unit                     Tutor
                BTEC National Diploma IT Practitioner              Business Information Systems      Andrew Hill

                Site                                               Room                 Week no.     Date                      Group size
                Dunstable                                          A404                 7            10/23/2006                     16

                Start time                   End time               Notes
                1:15pm                       2:45pm
                Topic                                                                              Teaching and learning methods used
                half-term
                Lesson Aims                                                                             Assignment               Practical activity
                                                                                                        Buzz Groups              Project
                                                                                                        Case Study               Q&A
                                                                                                        Debate                   Quiz
                                                                                                        Demonstration            Role Play
                                                                                                        Coaching                 Set reading
                Learning outcomes                                  For more advanced learners           Discussion               Simulation
                                                                                                        Game                     Structural aids
                                                                                                        Group work               Tutorial
                                                                                                        Ice breaker              Tutor presentation
                                                                                                        Learner presentation     Video/DVD
                                                                                                                                 Other




                Resources needed                                                                     Notes




                Basic / Key Skills development

                Communication / Literacy     Appln of Number / Numeracy     ICT                         Other




                Risk assessment




                Tutor activity




                Student activity




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 7
Lesson Plan                                                                                                                                                                    Dunstable College
Week 8                                                                                                                                                                                  2006-07

                Course                                                          Module / Unit                                          Tutor
                BTEC National Diploma IT Practitioner                           Business Information Systems                           Andrew Hill

                Site                                                            Room                             Week no.              Date                Group size
                Dunstable                                                       A404                             8                     10/30/2006               16

                Start time                         End time                      Notes
                1:15pm                             2:45pm
                Topic                                                                                                                Teaching and learning methods used
                The cashflow forecast
                Lesson Aims                                                                                                               Assignment         Practical activity
                Students will be able to recognise when a business might go 'into the red' and estimate by how much and when.             Buzz Groups        Project
                They will also be able to amend initial data and note the effect on a business finance requirements
                                                                                                                                          Case Study         Q&A
                Students will be able to design and create a working spreadsheet that shows how data is distributed over time in a
                chart                                                                                                                     Debate             Quiz
                                                                                                                                          Demonstration      Role Play
                                                                                                                                          Coaching           Set reading
                Learning outcomes                                               For more advanced learners                  Discussion                       Simulation
                Students will be able to recognise when a                       It would be useful to have a check that the Game                             Structural aids
                business might go 'into the red' and estimate by                total expected annual income is an          Group work                       Tutorial
                how much and when.                                              appropriate figure - students may wish to   Ice breaker                      Tutor presentation
                They will also be able to amend initial data and                consider and apply more advanced            Learner presentation             Video/DVD
                note the effect on a business finance requirements              formulae to provide feedback to a user on                                    Other
                Students will be able to design and create a                    this
                working spreadsheet that shows how data is                      Those familiar with charts may wish to
                distributed over time in a chart                                create a more interesting or better
                Resources needed                                                designed layout or representation scheme. Notes
                Projector and screen
                Excel chart notes
                Dunn accounts notes




                Basic / Key Skills development

                Communication / Literacy           Appln of Number / Numeracy              ICT                                            Other




                Risk assessment




                Tutor activity
                Demonstrate an example of a completed cash flow forecast in Excel
                Indicate how data can be entered and the effect of changes immediately made clear using charts
                Explain how the input distribution section works and support students in creating their own versions



                Student activity
                Add data to a ready-made Excel workbook and note the effects on that proposed business plan.
                Create a monthly distribution table which is linked to a graph.




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 8
Lesson Plan                                                                                                                                                                       Dunstable College
Week 9                                                                                                                                                                                     2006-07

                Course                                                           Module / Unit                                      Tutor
                BTEC National Diploma IT Practitioner                            Business Information Systems                       Andrew Hill

                Site                                                             Room                              Week no.         Date                      Group size
                Dunstable                                                        A404                              9                11/6/2006                      16

                Start time                          End time                      Notes
                1:15pm                              2:45pm
                Topic                                                                                                             Teaching and learning methods used
                making Excel look good
                Lesson Aims                                                                                                            Assignment               Practical activity
                Students will be able to change cell shades and font styles without losing existing data and will recognise how        Buzz Groups              Project
                legibility, use of paper and ink and overall design can be improved
                                                                                                                                       Case Study               Q&A
                                                                                                                                       Debate                   Quiz
                                                                                                                                       Demonstration            Role Play
                                                                                                                                       Coaching                 Set reading
                Learning outcomes                                                For more advanced learners                            Discussion               Simulation
                Students will be able to change cell shades and                  Linking data on sheets, providing data                Game                     Structural aids
                font styles without losing existing data and will                input forms and more advanced design                  Group work               Tutorial
                recognise how legibility, use of paper and ink and               features offer plenty for experts to                  Ice breaker              Tutor presentation
                overall design can be improved                                   experiment with                                       Learner presentation     Video/DVD
                                                                                                                                                                Other




                Resources needed                                                                                                    Notes




                Basic / Key Skills development

                Communication / Literacy            Appln of Number / Numeracy              ICT                                        Other




                Risk assessment




                Tutor activity
                Demonstrate tips and tricks in Excel and alternative spreadsheet programmes
                Show how default settings can be changed and how the careful use of colours and lines can make sheets much easier to understand
                and interpret
                Illustrate the classic printing problems!


                Student activity
                Take an existing data sheet and re-work it to make it more presentable and/or user-friendly
                Try out on-line alternatives to Microsoft products
                Draw some conclusions as to relative advantages and disadvantages of colour schemes and alternative software




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 9
Lesson Plan                                                                                                                                                                       Dunstable College
Week 10                                                                                                                                                                                    2006-07

                Course                                                         Module / Unit                                        Tutor
                BTEC National Diploma IT Practitioner                          Business Information Systems                         Andrew Hill

                Site                                                           Room                             Week no.            Date                      Group size
                Dunstable                                                      A404                             10                  11/13/2006                     16

                Start time                         End time                     Notes
                1:15pm                             2:45pm
                Topic                                                                                                             Teaching and learning methods used
                Using Excel as a database for Word mailshots
                Lesson Aims                                                                                                            Assignment               Practical activity
                Students should print some sample text sheets incorporating data from a spreadsheet, with accurate selection of        Buzz Groups              Project
                customers and positioning of content, noting methods to ensure protection of original data
                                                                                                                                       Case Study               Q&A
                                                                                                                                       Debate                   Quiz
                                                                                                                                       Demonstration            Role Play
                                                                                                                                       Coaching                 Set reading
                Learning outcomes                                              For more advanced learners                              Discussion               Simulation
                Students should print some sample text sheets                  Use more advanced field techniques to                   Game                     Structural aids
                incorporating data from a spreadsheet, with                    add paragraphs for certain records that                 Group work               Tutorial
                accurate selection of customers and positioning                satisfy stated criteria                                 Ice breaker              Tutor presentation
                of content, noting methods to ensure protection                                                                        Learner presentation     Video/DVD
                of original data                                                                                                                                Other




                Resources needed                                                                                                    Notes
                Customer data
                Standard text for promotional mailing
                Notes for mail merge




                Basic / Key Skills development

                Communication / Literacy           Appln of Number / Numeracy             ICT                                          Other




                Risk assessment




                Tutor activity
                Describe the process of merging data stored in a spreadsheet with a text file




                Student activity
                Follow instructions to create a mailshot to selected 'customers' and note problems experienced and potential difficulties that might
                be experienced in real life




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 10
Lesson Plan                                                                                                                                                               Dunstable College
Week 11                                                                                                                                                                            2006-07

                Course                                                           Module / Unit                              Tutor
                BTEC National Diploma IT Practitioner                            Business Information Systems               Andrew Hill

                Site                                                             Room                      Week no.         Date                      Group size
                Dunstable                                                        A404                      11               11/20/2006                     16

                Start time                          End time                      Notes
                1:15pm                              2:45pm
                Topic                                                                                                     Teaching and learning methods used
                Departments
                Lesson Aims                                                                                                    Assignment               Practical activity
                List some of the main IT support needs and ICT skills expected of staff                                        Buzz Groups              Project
                                                                                                                               Case Study               Q&A
                                                                                                                               Debate                   Quiz
                                                                                                                               Demonstration            Role Play
                                                                                                                               Coaching                 Set reading
                Learning outcomes                                                For more advanced learners                    Discussion               Simulation
                List some of the main IT support needs and ICT                   obtain some real information from             Game                     Structural aids
                skills expected of staff                                         organisations to contribute to further        Group work               Tutorial
                                                                                 discussion and learning on this topic         Ice breaker              Tutor presentation
                                                                                                                               Learner presentation     Video/DVD
                                                                                                                                                        Other




                Resources needed                                                                                            Notes
                sample real-life departments and organisational structures




                Basic / Key Skills development

                Communication / Literacy           Appln of Number / Numeracy             ICT                                  Other




                Risk assessment




                Tutor activity
                Describe the main departments, or operational centres, found in typical businesses and encourage discussion of their IT support
                needs and staff ICT skill needs




                Student activity
                Consider different departments and investigate their roles and requirements




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 11
Lesson Plan                                                                                                                                                              Dunstable College
Week 12                                                                                                                                                                           2006-07

                Course                                                           Module / Unit                             Tutor
                BTEC National Diploma IT Practitioner                            Business Information Systems              Andrew Hill

                Site                                                             Room                     Week no.         Date                      Group size
                Dunstable                                                        A404                     12               11/27/2006                     16

                Start time                          End time                      Notes
                1:15pm                              2:45pm
                Topic                                                                                                  Teaching and learning methods used
                Departments
                Lesson Aims                                                                                                   Assignment               Practical activity
                List some of the main IT support needs and ICT skills expected of staff                                       Buzz Groups              Project
                                                                                                                              Case Study               Q&A
                                                                                                                              Debate                   Quiz
                                                                                                                              Demonstration            Role Play
                                                                                                                              Coaching                 Set reading
                Learning outcomes                                                For more advanced learners                   Discussion               Simulation
                List some of the main IT support needs and ICT                   Lead discussion and present findings on      Game                     Structural aids
                skills expected of staff                                         real organisations                           Group work               Tutorial
                                                                                                                              Ice breaker              Tutor presentation
                                                                                                                              Learner presentation     Video/DVD
                                                                                                                                                       Other




                Resources needed                                                                                           Notes
                Lead discussion and present findings on real organisations




                Basic / Key Skills development

                Communication / Literacy           Appln of Number / Numeracy             ICT                                 Other




                Risk assessment




                Tutor activity
                Describe the main departments, or operational centres, found in typical businesses and encourage discussion of their IT support
                needs and staff ICT skill needs




                Student activity
                Consider different departments and investigate their roles and requirements




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 12
Lesson Plan                                                                                                                                                                      Dunstable College
Week 13                                                                                                                                                                                   2006-07

                Course                                                        Module / Unit                                        Tutor
                BTEC National Diploma IT Practitioner                         Business Information Systems                         Andrew Hill

                Site                                                          Room                            Week no.             Date                      Group size
                Dunstable                                                     A404                            13                   12/4/2006                      16

                Start time                        End time                     Notes
                1:15pm                            2:45pm
                Topic                                                                                                         Teaching and learning methods used
                Data handling and processing
                Lesson Aims                                                                                                           Assignment               Practical activity
                A report illustrating how data may be used on multiple occasions throughout different departments and how cehcks      Buzz Groups              Project
                can be incorporated to ensure its accuracy
                                                                                                                                      Case Study               Q&A
                                                                                                                                      Debate                   Quiz
                                                                                                                                      Demonstration            Role Play
                                                                                                                                      Coaching                 Set reading
                Learning outcomes                              For more advanced learners                                             Discussion               Simulation
                A report illustrating how data may be used on                                                                         Game                     Structural aids
                multiple occasions throughout different                                                                               Group work               Tutorial
                departments and how cehcks can be incorporated                                                                        Ice breaker              Tutor presentation
                to ensure its accuracy                                                                                                Learner presentation     Video/DVD
                                                                                                                                                               Other




                Resources needed                                                                                                   Notes




                Basic / Key Skills development

                Communication / Literacy          Appln of Number / Numeracy            ICT                                           Other




                Risk assessment




                Tutor activity
                Illustrate various methods of data handling and explain why some are more appropriate to each type of data
                Link to previous session findings as to support needs




                Student activity
                Describe the various ways for managing data by illustrating a process from data input through to utilisation in various departments




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 13
Lesson Plan                                                                                                                                                                      Dunstable College
Week 14                                                                                                                                                                                   2006-07

                Course                                                        Module / Unit                                        Tutor
                BTEC National Diploma IT Practitioner                         Business Information Systems                         Andrew Hill

                Site                                                          Room                            Week no.             Date                      Group size
                Dunstable                                                     A404                            14                   12/11/2006                     16

                Start time                        End time                     Notes
                1:15pm                            2:45pm
                Topic                                                                                                         Teaching and learning methods used
                Data handling and processing
                Lesson Aims                                                                                                           Assignment               Practical activity
                A report illustrating how data may be used on multiple occasions throughout different departments and how cehcks      Buzz Groups              Project
                can be incorporated to ensure its accuracy
                                                                                                                                      Case Study               Q&A
                                                                                                                                      Debate                   Quiz
                                                                                                                                      Demonstration            Role Play
                                                                                                                                      Coaching                 Set reading
                Learning outcomes                              For more advanced learners                                             Discussion               Simulation
                A report illustrating how data may be used on                                                                         Game                     Structural aids
                multiple occasions throughout different                                                                               Group work               Tutorial
                departments and how cehcks can be incorporated                                                                        Ice breaker              Tutor presentation
                to ensure its accuracy                                                                                                Learner presentation     Video/DVD
                                                                                                                                                               Other




                Resources needed                                                                                                   Notes




                Basic / Key Skills development

                Communication / Literacy          Appln of Number / Numeracy            ICT                                           Other




                Risk assessment




                Tutor activity
                Illustrate various methods of data handling and explain why some are more appropriate to each type of data
                Link to previous session findings as to support needs




                Student activity
                Describe the various ways for managing data by illustrating a process from data input through to utilisation in various departments




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 14
Lesson Plan                                                                                                                                         Dunstable College
Week 15                                                                                                                                                      2006-07

                Course                                              Module / Unit                     Tutor
                BTEC National Diploma IT Practitioner               Business Information Systems      Andrew Hill

                Site                                                Room                 Week no.     Date                      Group size
                Dunstable                                           A404                 15           12/18/2006                     16

                Start time                    End time               Notes
                1:15pm                        2:45pm
                Topic                                                                               Teaching and learning methods used
                Christmas holiday
                Lesson Aims                                                                              Assignment               Practical activity
                Christmas holiday                                                                        Buzz Groups              Project
                                                                                                         Case Study               Q&A
                                                                                                         Debate                   Quiz
                                                                                                         Demonstration            Role Play
                                                                                                         Coaching                 Set reading
                Learning outcomes                                   For more advanced learners           Discussion               Simulation
                Christmas holiday                                                                        Game                     Structural aids
                                                                                                         Group work               Tutorial
                                                                                                         Ice breaker              Tutor presentation
                                                                                                         Learner presentation     Video/DVD
                                                                                                                                  Other




                Resources needed                                                                      Notes




                Basic / Key Skills development

                Communication / Literacy      Appln of Number / Numeracy     ICT                         Other




                Risk assessment




                Tutor activity
                Christmas holiday




                Student activity
                Christmas holiday




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 15
Lesson Plan                                                                                                                                         Dunstable College
Week 16                                                                                                                                                      2006-07

                Course                                              Module / Unit                     Tutor
                BTEC National Diploma IT Practitioner               Business Information Systems      Andrew Hill

                Site                                                Room                 Week no.     Date                      Group size
                Dunstable                                           A404                 16           12/25/2006                     16

                Start time                    End time               Notes
                1:15pm                        2:45pm
                Topic                                                                               Teaching and learning methods used
                Christmas holiday
                Lesson Aims                                                                              Assignment               Practical activity
                Christmas holiday                                                                        Buzz Groups              Project
                                                                                                         Case Study               Q&A
                                                                                                         Debate                   Quiz
                                                                                                         Demonstration            Role Play
                                                                                                         Coaching                 Set reading
                Learning outcomes                                   For more advanced learners           Discussion               Simulation
                Christmas holiday                                                                        Game                     Structural aids
                                                                                                         Group work               Tutorial
                                                                                                         Ice breaker              Tutor presentation
                                                                                                         Learner presentation     Video/DVD
                                                                                                                                  Other




                Resources needed                                                                      Notes




                Basic / Key Skills development

                Communication / Literacy      Appln of Number / Numeracy     ICT                         Other




                Risk assessment




                Tutor activity
                Christmas holiday




                Student activity
                Christmas holiday




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 16
Lesson Plan                                                                                                                                         Dunstable College
Week 17                                                                                                                                                      2006-07

                Course                                              Module / Unit                     Tutor
                BTEC National Diploma IT Practitioner               Business Information Systems      Andrew Hill

                Site                                                Room                 Week no.     Date                      Group size
                Dunstable                                           A404                 17           1/1/2007                       16

                Start time                    End time               Notes
                1:15pm                        2:45pm
                Topic                                                                               Teaching and learning methods used
                Christmas holiday
                Lesson Aims                                                                              Assignment               Practical activity
                Christmas holiday                                                                        Buzz Groups              Project
                                                                                                         Case Study               Q&A
                                                                                                         Debate                   Quiz
                                                                                                         Demonstration            Role Play
                                                                                                         Coaching                 Set reading
                Learning outcomes                                   For more advanced learners           Discussion               Simulation
                Christmas holiday                                                                        Game                     Structural aids
                                                                                                         Group work               Tutorial
                                                                                                         Ice breaker              Tutor presentation
                                                                                                         Learner presentation     Video/DVD
                                                                                                                                  Other




                Resources needed                                                                      Notes




                Basic / Key Skills development

                Communication / Literacy      Appln of Number / Numeracy     ICT                         Other




                Risk assessment




                Tutor activity
                Christmas holiday




                Student activity
                Christmas holiday




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 17
Lesson Plan                                                                                                                                                                           Dunstable College
Week 18                                                                                                                                                                                        2006-07

                Course                                                          Module / Unit                                           Tutor
                BTEC National Diploma IT Practitioner                           Business Information Systems                            Andrew Hill

                Site                                                            Room                             Week no.               Date                      Group size
                Dunstable                                                       A404                             18                     1/8/2007                       16

                Start time                         End time                      Notes
                1:15pm                             2:45pm
                Topic                                                                                                             Teaching and learning methods used
                Business system: protection (health and saftey)
                Lesson Aims                                                                                                                Assignment               Practical activity
                Students will be aware of the principal Health & Safety Acts at the current time and what the most important features      Buzz Groups              Project
                are that affect business, managers, staff and customers and will be able to illustrate examples of potential risks in
                                                                                                                                           Case Study               Q&A
                real-life, which legislation applies and what action should be taken by whom
                                                                                                                                           Debate                   Quiz
                                                                                                                                           Demonstration            Role Play
                                                                                                                                           Coaching                 Set reading
                Learning outcomes                                               For more advanced learners                                 Discussion               Simulation
                Students will be aware of the principal Health &                There is a never-ending list of statutes                   Game                     Structural aids
                Safety Acts at the current time and what the most               and proposed legislation within the EC                     Group work               Tutorial
                important features are that affect business,                    that even the most informed student will                   Ice breaker              Tutor presentation
                managers, staff and customers and will be able to               find challenging to research.                              Learner presentation     Video/DVD
                illustrate examples of potential risks in real-life,                                                                                                Other
                which legislation applies and what action should
                be taken by whom

                Resources needed                                                                                                        Notes
                Up-to-date lists of pertinent legislation, including latest EC directives (especially any that
                match current or recent events or are particularly odd or memorable!)
                Speaker from TUC H&S Dept.




                Basic / Key Skills development

                Communication / Literacy           Appln of Number / Numeracy             ICT                                              Other




                Risk assessment




                Tutor activity
                Explain some of the many 'risks' inherent in any business and lead discussion and research regarding legal requirements and
                sensible precautions




                Student activity
                Investigate the key features of Health & safety legislation and consider how these affect various elements of different types of
                business, from, for example a simple office environment to a fuel transport firm




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 18
Lesson Plan                                                                                                                                                                       Dunstable College
Week 19                                                                                                                                                                                    2006-07

                Course                                                         Module / Unit                                        Tutor
                BTEC National Diploma IT Practitioner                          Business Information Systems                         Andrew Hill

                Site                                                           Room                            Week no.             Date                      Group size
                Dunstable                                                      A404                            19                   1/15/2007                      16

                Start time                        End time                      Notes
                1:15pm                            2:45pm
                Topic                                                                                                           Teaching and learning methods used
                Business systems: protection (security of data)
                Lesson Aims                                                                                                            Assignment               Practical activity
                Students will be aware of how easily data can become corrupted, or deliberately altered, unless proper management      Buzz Groups              Project
                is in place.
                                                                                                                                       Case Study               Q&A
                                                                                                                                       Debate                   Quiz
                                                                                                                                       Demonstration            Role Play
                                                                                                                                       Coaching                 Set reading
                Learning outcomes                                              For more advanced learners                              Discussion               Simulation
                Students will be aware of how easily data can                  validation controls for data entry can be               Game                     Structural aids
                become corrupted, or deliberately altered, unless              included in most databases and they may                 Group work               Tutorial
                proper management is in place.                                 wish to investigate some methods.                       Ice breaker              Tutor presentation
                                                                               If there are any 'hackers' in the group                 Learner presentation     Video/DVD
                                                                               then their services could usefully be                                            Other
                                                                               employed for a live demonstration,
                                                                               perhaps.

                Resources needed                                                                                                    Notes
                Selection of masses of data which is in forms that is either 'protected' or able to be changed
                with some built-in error warnings that will appear, depending upon how they handle it




                Basic / Key Skills development

                Communication / Literacy          Appln of Number / Numeracy             ICT                                           Other




                Risk assessment




                Tutor activity
                Describe some of the important issues relating to security of data and problems that can arise if this is not managed properly
                Promote investigation into the extent to which types of data can be shared and how processes can be put in place to check that it is
                accurate



                Student activity
                How can data get 'damaged'? How would you know? Groups to look at arange of types of data and report on what may go wrong with
                it and how they might avoid problems




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 19
Lesson Plan                                                                                                                                                                        Dunstable College
Week 20                                                                                                                                                                                     2006-07

                Course                                                         Module / Unit                                         Tutor
                BTEC National Diploma IT Practitioner                          Business Information Systems                          Andrew Hill

                Site                                                           Room                            Week no.              Date                      Group size
                Dunstable                                                      A404                            20                    1/22/2007                      16

                Start time                         End time                     Notes
                1:15pm                             2:45pm
                Topic                                                                                                              Teaching and learning methods used
                E-commerce
                Lesson Aims                                                                                                             Assignment               Practical activity
                Understand the main features of e-commerce, its advantages and disadvantages in a particular business situation.        Buzz Groups              Project
                Report on their findings and which real-life organisations have used e-commerce effectively
                                                                                                                                        Case Study               Q&A
                                                                                                                                        Debate                   Quiz
                                                                                                                                        Demonstration            Role Play
                                                                                                                                        Coaching                 Set reading
                Learning outcomes                                              For more advanced learners                               Discussion               Simulation
                Understand the main features of e-commerce, its                Consider areas of activity or types of                   Game                     Structural aids
                advantages and disadvantages in a particular                   business where e-commerce might not                      Group work               Tutorial
                business situation.                                            necessarily be effective                                 Ice breaker              Tutor presentation
                Report on their findings and which real-life                                                                            Learner presentation     Video/DVD
                organisations have used e-commerce effectively                                                                                                   Other




                Resources needed                                                                                                     Notes




                Basic / Key Skills development

                Communication / Literacy           Appln of Number / Numeracy            ICT                                            Other




                Risk assessment




                Tutor activity
                The growing use of web sites for trade and promotion will be illustrated, using a range of examples and to lead students into
                describing how they might assess whether their choice of activity might effectively utilise this medium




                Student activity
                Choose a business activity in which they have a genuine interest and investigate the extent to which competitors in that field
                currently use the web to trade




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 20
Lesson Plan                                                                                                                                                                        Dunstable College
Week 21                                                                                                                                                                                     2006-07

                Course                                                         Module / Unit                                         Tutor
                BTEC National Diploma IT Practitioner                          Business Information Systems                          Andrew Hill

                Site                                                           Room                            Week no.              Date                      Group size
                Dunstable                                                      A404                            21                    1/29/2007                      16

                Start time                         End time                     Notes
                1:15pm                             2:45pm
                Topic                                                                                                              Teaching and learning methods used
                E-commerce
                Lesson Aims                                                                                                             Assignment               Practical activity
                Understand the main features of e-commerce, its advantages and disadvantages in a particular business situation.        Buzz Groups              Project
                Report on their findings and which real-life organisations have used e-commerce effectively
                                                                                                                                        Case Study               Q&A
                                                                                                                                        Debate                   Quiz
                                                                                                                                        Demonstration            Role Play
                                                                                                                                        Coaching                 Set reading
                Learning outcomes                                              For more advanced learners                               Discussion               Simulation
                Understand the main features of e-commerce, its                Consider areas of activity or types of                   Game                     Structural aids
                advantages and disadvantages in a particular                   business where e-commerce might not                      Group work               Tutorial
                business situation.                                            necessarily be effective                                 Ice breaker              Tutor presentation
                Report on their findings and which real-life                                                                            Learner presentation     Video/DVD
                organisations have used e-commerce effectively                                                                                                   Other




                Resources needed                                                                                                     Notes




                Basic / Key Skills development

                Communication / Literacy           Appln of Number / Numeracy            ICT                                            Other




                Risk assessment




                Tutor activity
                The growing use of web sites for trade and promotion will be illustrated, using a range of examples and to lead students into
                describing how they might assess whether their choice of activity might effectively utilise this medium




                Student activity
                Choose a business activity in which they have a genuine interest and investigate the extent to which competitors in that field
                currently use the web to trade




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 21
Lesson Plan                                                                                                                                         Dunstable College
Week 22                                                                                                                                                      2006-07

                Course                                              Module / Unit                     Tutor
                BTEC National Diploma IT Practitioner               Business Information Systems      Andrew Hill

                Site                                                Room                 Week no.     Date                      Group size
                Dunstable                                           A404                 22           2/5/2007                       16

                Start time                    End time               Notes
                1:15pm                        2:45pm
                Topic                                                                               Teaching and learning methods used
                Review
                Lesson Aims                                                                              Assignment               Practical activity
                Review                                                                                   Buzz Groups              Project
                                                                                                         Case Study               Q&A
                                                                                                         Debate                   Quiz
                                                                                                         Demonstration            Role Play
                                                                                                         Coaching                 Set reading
                Learning outcomes                                   For more advanced learners           Discussion               Simulation
                Review                                                                                   Game                     Structural aids
                                                                                                         Group work               Tutorial
                                                                                                         Ice breaker              Tutor presentation
                                                                                                         Learner presentation     Video/DVD
                                                                                                                                  Other




                Resources needed                                                                      Notes




                Basic / Key Skills development

                Communication / Literacy      Appln of Number / Numeracy     ICT                         Other




                Risk assessment




                Tutor activity
                Review




                Student activity
                Review




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 22
Lesson Plan                                                                                                                                                      Dunstable College
Week 23                                                                                                                                                                   2006-07

                Course                                                           Module / Unit                     Tutor
                BTEC National Diploma IT Practitioner                            Business Information Systems      Andrew Hill

                Site                                                             Room                 Week no.     Date                      Group size
                Dunstable                                                        A404                 12           2/12/2007                      16

                Start time                          End time                      Notes
                1:15pm                              2:45pm
                Topic                                                                                            Teaching and learning methods used
                Departments
                Lesson Aims                                                                                           Assignment               Practical activity
                List some of the main IT support needs and ICT skills expected of staff                               Buzz Groups              Project
                                                                                                                      Case Study               Q&A
                                                                                                                      Debate                   Quiz
                                                                                                                      Demonstration            Role Play
                                                                                                                      Coaching                 Set reading
                Learning outcomes                                                For more advanced learners           Discussion               Simulation
                List some of the main IT support needs and ICT                                                        Game                     Structural aids
                skills expected of staff                                                                              Group work               Tutorial
                                                                                                                      Ice breaker              Tutor presentation
                                                                                                                      Learner presentation     Video/DVD
                                                                                                                                               Other




                Resources needed                                                                                   Notes
                Lead discussion and present findings on real organisations




                Basic / Key Skills development

                Communication / Literacy           Appln of Number / Numeracy             ICT                         Other




                Risk assessment




                Tutor activity
                Describe the main departments, or operational centres, found in typical businesses and encourage discussion of their IT support
                needs and staff ICT skill needs




                Student activity
                Consider different departments and investigate their roles and requirements




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 23
Lesson Plan                                                                                                                                                      Dunstable College
Week 24                                                                                                                                                                   2006-07

                Course                                                           Module / Unit                     Tutor
                BTEC National Diploma IT Practitioner                            Business Information Systems      Andrew Hill

                Site                                                             Room                 Week no.     Date                      Group size
                Dunstable                                                        A404                 12           2/19/2007                      16

                Start time                          End time                      Notes
                1:15pm                              2:45pm
                Topic                                                                                            Teaching and learning methods used
                Departments
                Lesson Aims                                                                                           Assignment               Practical activity
                List some of the main IT support needs and ICT skills expected of staff                               Buzz Groups              Project
                                                                                                                      Case Study               Q&A
                                                                                                                      Debate                   Quiz
                                                                                                                      Demonstration            Role Play
                                                                                                                      Coaching                 Set reading
                Learning outcomes                                                For more advanced learners           Discussion               Simulation
                List some of the main IT support needs and ICT                                                        Game                     Structural aids
                skills expected of staff                                                                              Group work               Tutorial
                                                                                                                      Ice breaker              Tutor presentation
                                                                                                                      Learner presentation     Video/DVD
                                                                                                                                               Other




                Resources needed                                                                                   Notes
                Lead discussion and present findings on real organisations




                Basic / Key Skills development

                Communication / Literacy           Appln of Number / Numeracy             ICT                         Other




                Risk assessment




                Tutor activity
                Describe the main departments, or operational centres, found in typical businesses and encourage discussion of their IT support
                needs and staff ICT skill needs




                Student activity
                Consider different departments and investigate their roles and requirements




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 24
Lesson Plan                                                                                                                                                                      Dunstable College
Week 25                                                                                                                                                                                   2006-07

                Course                                                        Module / Unit                                        Tutor
                BTEC National Diploma IT Practitioner                         Business Information Systems                         Andrew Hill

                Site                                                          Room                            Week no.             Date                      Group size
                Dunstable                                                     A404                            25                   2/26/2007                      16

                Start time                        End time                     Notes
                1:15pm                            2:45pm
                Topic                                                                                                            Teaching and learning methods used
                System life cycle
                Lesson Aims                                                                                                           Assignment               Practical activity
                Embedded understanding of the cycle and knowing what the stages are and to be able to relate them to something        Buzz Groups              Project
                that they can identify with
                                                                                                                                      Case Study               Q&A
                                                                                                                                      Debate                   Quiz
                                                                                                                                      Demonstration            Role Play
                                                                                                                                      Coaching                 Set reading
                Learning outcomes                                             For more advanced learners                              Discussion               Simulation
                Embedded understanding of the cycle and                                                                               Game                     Structural aids
                knowing what the stages are and to be able to                                                                         Group work               Tutorial
                relate them to something that they can identify                                                                       Ice breaker              Tutor presentation
                with                                                                                                                  Learner presentation     Video/DVD
                                                                                                                                                               Other




                Resources needed                                                                             Notes
                May need to have a cartoon 'sample' of how they might consider acting out the various stages




                Basic / Key Skills development

                Communication / Literacy          Appln of Number / Numeracy            ICT                                           Other




                Risk assessment




                Tutor activity
                More in-depth examination of the stages in the cycle and how IT can support the processes involved
                Provide real examples to consider




                Student activity
                Divide stages amongst the group and each to look in more detail at what they mean, with reference to a particular process or activity
                Representatives for each 'stage' to display or present findings as a sort of continuous role play




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 25
Lesson Plan                                                                                                                                                                         Dunstable College
Week 26                                                                                                                                                                                      2006-07

                Course                                                         Module / Unit                                          Tutor
                BTEC National Diploma IT Practitioner                          Business Information Systems                           Andrew Hill

                Site                                                           Room                             Week no.              Date                      Group size
                Dunstable                                                      A404                             26                    3/5/2007                       16

                Start time                         End time                     Notes
                1:15pm                             2:45pm
                Topic                                                                                                            Teaching and learning methods used
                Accounts
                Lesson Aims                                                                                                              Assignment               Practical activity
                Students will have an understanding of the main features of the forms involved and essential accounting information      Buzz Groups              Project
                necessary
                                                                                                                                         Case Study               Q&A
                                                                                                                                         Debate                   Quiz
                                                                                                                                         Demonstration            Role Play
                                                                                                                                         Coaching                 Set reading
                Learning outcomes                                              For more advanced learners                                Discussion               Simulation
                Students will have an understanding of the main                The Dunn accounts package used earlier                    Game                     Structural aids
                features of the forms involved and essential                   has many further facilities that could be                 Group work               Tutorial
                accounting information necessary                               developed                                                 Ice breaker              Tutor presentation
                                                                                                                                         Learner presentation     Video/DVD
                                                                                                                                                                  Other




                Resources needed                                                                                                      Notes
                selection of 'products' to use in role play
                some real forms for each of the sub-groups
                sample real forms




                Basic / Key Skills development

                Communication / Literacy           Appln of Number / Numeracy            ICT                                             Other




                Risk assessment




                Tutor activity
                Show how money comes into a business and flows through various departments and some of the basic accounting necessities to
                manage the flow
                Revisit the cash flow task from earlier sessions
                Illustrate a purchase order and a sales invoice


                Student activity
                Group to divide into suppliers, sellers, accountants, tax men and customers and draft examples of the paperwork they think they
                need to record their part of the process of a selection of goods from supplier to customer




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 26
Lesson Plan                                                                                                                                                                        Dunstable College
Week 27                                                                                                                                                                                     2006-07

                Course                                                         Module / Unit                                         Tutor
                BTEC National Diploma IT Practitioner                          Business Information Systems                          Andrew Hill

                Site                                                           Room                             Week no.             Date                      Group size
                Dunstable                                                      A404                             27                   3/12/2007                      16

                Start time                         End time                      Notes
                1:15pm                             2:45pm
                Topic                                                                                                              Teaching and learning methods used
                Promotion and marketing
                Lesson Aims                                                                                                             Assignment               Practical activity
                Students should be able to recognise the main features of good practice in using ICT in marketing or promotional        Buzz Groups              Project
                work and both to produce an comment constructively on samples
                                                                                                                                        Case Study               Q&A
                                                                                                                                        Debate                   Quiz
                                                                                                                                        Demonstration            Role Play
                                                                                                                                        Coaching                 Set reading
                Learning outcomes                                              For more advanced learners                               Discussion               Simulation
                Students should be able to recognise the main                  This is one of those areas where even the                Game                     Structural aids
                features of good practice in using ICT in                      most advanced students can still learn                   Group work               Tutorial
                marketing or promotional work and both to                      something, especially in image                           Ice breaker              Tutor presentation
                produce an comment constructively on samples                   processing, customer research methods                    Learner presentation     Video/DVD
                                                                               and data collection so there should be                                            Other
                                                                               something for everyone



                Resources needed                                                                                                     Notes
                scenarios for students to use if necessary
                good and bad examples of ICT use in marketing and theming or branding




                Basic / Key Skills development

                Communication / Literacy           Appln of Number / Numeracy             ICT                                           Other




                Risk assessment




                Tutor activity
                Explain how marketing is at the heart of all business in one shape or another and various techniques utilised in promotion
                the importance of a brand image, logos, themes etc.
                How IT supports these aspects and can also adversely affect them if not well managed



                Student activity
                Groups to consider how they would promote an organisation or activity, or internal marketing such as consistent design of a range of
                department stationery and then to act as critics or users for others' productions




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 27
Lesson Plan                                                                                                                                                                        Dunstable College
Week 28                                                                                                                                                                                     2006-07

                Course                                                            Module / Unit                                      Tutor
                BTEC National Diploma IT Practitioner                             Business Information Systems                       Andrew Hill

                Site                                                              Room                             Week no.          Date                      Group size
                Dunstable                                                         A404                             28                3/19/2007                      16

                Start time                          End time                       Notes
                1:15pm                              2:45pm
                Topic                                                                                                              Teaching and learning methods used
                Web sites
                Lesson Aims                                                                                                             Assignment               Practical activity
                Students should be able to recognise the main types of web site in terms of purpose and to list those areas of a        Buzz Groups              Project
                business web site that would need regular attention to ensure currency, accuracy and authority
                                                                                                                                        Case Study               Q&A
                                                                                                                                        Debate                   Quiz
                                                                                                                                        Demonstration            Role Play
                                                                                                                                        Coaching                 Set reading
                Learning outcomes                                  For more advanced learners                                           Discussion               Simulation
                Students should be able to recognise the main      Investigate the potential costs of                                   Game                     Structural aids
                types of web site in terms of purpose and to list  establishing a web site                                              Group work               Tutorial
                those areas of a business web site that would need                                                                      Ice breaker              Tutor presentation
                regular attention to ensure currency, accuracy                                                                          Learner presentation     Video/DVD
                and authority                                                                                                                                    Other




                Resources needed                                                                                                     Notes
                list of sample web site addresses for evaluation
                evaluation forms for completion




                Basic / Key Skills development

                Communication / Literacy            Appln of Number / Numeracy              ICT                                         Other




                Risk assessment




                Tutor activity
                Identification of the main types of web site
                How well do they do their job?
                Explain the IT support relevant to a selected site



                Student activity
                rate a given selection of sites as to what their purpose is and how well they meet the needs of users
                Note which aspects of the site would need regular maintenance or updating / checking and who would be involved in the process




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 28
Lesson Plan                                                                                                                                         Dunstable College
Week 29                                                                                                                                                      2006-07

                Course                                              Module / Unit                     Tutor
                BTEC National Diploma IT Practitioner               Business Information Systems      Andrew Hill

                Site                                                Room                 Week no.     Date                      Group size
                Dunstable                                           A404                 29           3/26/2007                      16

                Start time                    End time               Notes
                1:15pm                        2:45pm
                Topic                                                                               Teaching and learning methods used
                Review
                Lesson Aims                                                                              Assignment               Practical activity
                Review                                                                                   Buzz Groups              Project
                                                                                                         Case Study               Q&A
                                                                                                         Debate                   Quiz
                                                                                                         Demonstration            Role Play
                                                                                                         Coaching                 Set reading
                Learning outcomes                                   For more advanced learners           Discussion               Simulation
                Review                                                                                   Game                     Structural aids
                                                                                                         Group work               Tutorial
                                                                                                         Ice breaker              Tutor presentation
                                                                                                         Learner presentation     Video/DVD
                                                                                                                                  Other




                Resources needed                                                                      Notes




                Basic / Key Skills development

                Communication / Literacy      Appln of Number / Numeracy     ICT                         Other




                Risk assessment




                Tutor activity
                Review




                Student activity
                Review




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 29
Lesson Plan                                                                                                                                         Dunstable College
Week 30                                                                                                                                                      2006-07

                Course                                              Module / Unit                     Tutor
                BTEC National Diploma IT Practitioner               Business Information Systems      Andrew Hill

                Site                                                Room                 Week no.     Date                      Group size
                Dunstable                                           A404                 30           4/2/2007                       16

                Start time                    End time               Notes
                1:15pm                        2:45pm
                Topic                                                                               Teaching and learning methods used
                Easter holiday
                Lesson Aims                                                                              Assignment               Practical activity
                Easter holiday                                                                           Buzz Groups              Project
                                                                                                         Case Study               Q&A
                                                                                                         Debate                   Quiz
                                                                                                         Demonstration            Role Play
                                                                                                         Coaching                 Set reading
                Learning outcomes                                   For more advanced learners           Discussion               Simulation
                Easter holiday                                                                           Game                     Structural aids
                                                                                                         Group work               Tutorial
                                                                                                         Ice breaker              Tutor presentation
                                                                                                         Learner presentation     Video/DVD
                                                                                                                                  Other




                Resources needed                                                                      Notes




                Basic / Key Skills development

                Communication / Literacy      Appln of Number / Numeracy     ICT                         Other




                Risk assessment




                Tutor activity
                Easter holiday




                Student activity
                Easter holiday




                Assessment




                                   29




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 30
Lesson Plan                                                                                                                                         Dunstable College
Week 31                                                                                                                                                      2006-07

                Course                                              Module / Unit                     Tutor
                BTEC National Diploma IT Practitioner               Business Information Systems      Andrew Hill

                Site                                                Room                 Week no.     Date                      Group size
                Dunstable                                           A404                 31           4/9/2007                       16

                Start time                    End time               Notes
                1:15pm                        2:45pm
                Topic                                                                               Teaching and learning methods used
                Easter holiday
                Lesson Aims                                                                              Assignment               Practical activity
                Easter holiday                                                                           Buzz Groups              Project
                                                                                                         Case Study               Q&A
                                                                                                         Debate                   Quiz
                                                                                                         Demonstration            Role Play
                                                                                                         Coaching                 Set reading
                Learning outcomes                                   For more advanced learners           Discussion               Simulation
                Easter holiday                                                                           Game                     Structural aids
                                                                                                         Group work               Tutorial
                                                                                                         Ice breaker              Tutor presentation
                                                                                                         Learner presentation     Video/DVD
                                                                                                                                  Other




                Resources needed                                                                      Notes




                Basic / Key Skills development

                Communication / Literacy      Appln of Number / Numeracy     ICT                         Other




                Risk assessment




                Tutor activity
                Easter holiday




                Student activity
                Easter holiday




                Assessment




                Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls 31
Lesson Plan                                                                                                                                                          Dunstable College
Week sample lesson plan                                                                                                                                                       2005-06

                 Course                                                Module / Unit                                   Tutor
                 name of course                                        which unit or module                            Andrew Hill

                 Site                                                  Room                         Week no.           Date                      Group size
                 Dunstable                                             A107                         22                 22 August 2011                  19

                 Start time                      End time               Notes space to write anything that doesn't already have a box - special factors,
                 4:46 PM                                                      group make-up, possible problems etc
                 Topic                                                                                        Teaching and learning methods used
                 OK, So what are we going to do today
                 Lesson Aims                                                                                              Assignment             x Practical activity
                 Why we're here, how it fits into the curriculum and makes sense for you to learn this as it will         Buzz Groups              Project
                 be valuable in your job or in the real world outside.                                                    Case Study             x Q&A
                 Particular things I want to get across                                                                x Debate                    Quiz
                                                                                                                          Demonstration            Role Play
                                                                                                                          Coaching                 Set reading
                 Learning outcomes                                     For more advanced learners                      x Discussion                Simulation
                 Skills or understanding that I'd expect most to       Suggestions as to how they could have              Game                     Structural aids
                 achieve, evidenced by completed tasks, responses      completed task better                           x Group work                Tutorial
                 etc                                                   Smart ones helping slower ones                     Ice breaker            x Tutor presentation
                                                                       Application of skill to a real-life situation      Learner presentation     Video/DVD
                                                                       if they have one etc etc                                                  x Other
                                                                                                                       Dominoes



                 Resources needed                                                                                      Notes
                 Whatever we need to deliver the session - things I need like equipment, notes, access to the          another space to put stuff that doesn't
                 internet, list of links that I know work and aren't banned, examples of completed tasks and so        appear to go anywhere else - could be
                 on                                                                                                    particular room layout problems or
                                                                                                                       possible concerns about an individual
                                                                                                                       not having done something last time,
                                                                                                                       handing back assignments etc




                 Basic / Key Skills development

                Communication / Literacy         Appln of Number / Numeracy     ICT                                       Other
                 Any opportunities to            ditto                          ditto                                     need to think about this one
                 contribute to portfolios?



                 Risk assessment
                 anticipate problems here and have some solutions ready
                 refer to Room Risk Assessment too maybe




                 Tutor activity
                 Basically, what I'm going to do, ideally set out in some sort of order - times can be added in here too for those that use them
                 11:00 Start with something to wake'em up and get some attention
                 11:10 get going on the middle
                 11:30 something different just to keep them awake
                 12:02 make it pretty clear what you expect them to have achieved before they go

                 Student activity
                 Essential features of what is expected of them in a reasonable order, probably linked to my activity above




                 Assessment
                 How I'm going to figure out whether anything's actually going in or not and how they can tell too




                 Evaluation
                 Can't do this yet and it's space to write in later or maybe can get filled in from typing later into data entry form. May be some action
                 points arising - just thought of that and could be a good idea - use one of 'spare' boxes perhaps




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls sample lesson plan
Lesson Plan                                                                                                                                                           Dunstable College
Week sample lesson plan (2)                                                                                                                                                    2006-07

                 Course                                                 Module / Unit                                   Tutor
                 BTEC national Diploma IT Practitioner                  Business Information Systems                    Andrew Hill

                 Site                                                   Room                         Week no.           Date                      Group size
                 Dunstable                                              A404                         22                 22 August 2011                  8

                 Start time                       End time               Notes
                 1:15 PM                          2:45pm
                 Topic                                                                                              Teaching and learning methods used
                 Budgets and calculations
                 Lesson Aims                                                                                               Assignment             x Practical activity
                 Some practical experience of working to a budget and being able to do calculations and                    Buzz Groups              Project
                 effective planning - this session will help assess those skills and identify any gaps in Key Skills       Case Study             x Q&A
                                                                                                                        x Debate                    Quiz
                                                                                                                           Demonstration            Role Play
                                                                                                                           Coaching                 Set reading
                 Learning outcomes                                      For more advanced learners                      x Discussion                Simulation
                 Skills or understanding that I'd expect most to        Suggestions as to how they could have              Game                     Structural aids
                 achieve, evidenced by completed tasks, responses       completed task better                           x Group work                Tutorial
                 etc - all listed in the task sheet                     Smart ones helping slower ones                     Ice breaker            x Tutor presentation
                                                                        Application of skill to a real-life situation      Learner presentation     Video/DVD
                                                                        if they have one etc etc                                                  x Other
                                                                                                                        Dominoes



                 Resources needed                                                                                       Notes
                 Task sheet (amended!)                                                                                  This assignment is actually identical
                 samples answer sheet                                                                                   to one being given to test Key Skills at
                 notes for doing calculations in Word and charts in Word                                                level1! It is, therefore, something that
                 computer price guide                                                                                   all ND students should breeze
                                                                                                                        through but . . We shall see!




                 Basic / Key Skills development

                 Communication / Literacy         Appln of Number / Numeracy      ICT                                      Other
                                                  Designed specifically to meet
                                                  the full AoN1 requirements



                 Risk assessment
                 Hopefully no-one will notice that it is the same as given to lower level groups!
                 Some initial guidance necessary as not exactly as clear as it could be what is needed
                 Magazine / newspaper references required but may be best to dispense with these or people may wander off and not return.



                 Tutor activity
                 Hand out assignment and set it in context
                 Illustrate a sample answer
                 Suggest how they might start best
                 Show links to Word table / chart notes


                 Student activity
                 Basically do what the task sheet says




                 Assessment
                 By the end of the 1.5hr session they should all have found 7 different computers and presented the information in a simple table.




                 Evaluation




532ed561-36fa-4c7b-88b0-e29d4406cbcb.xls sample lesson plan (2)

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:24
posted:8/22/2011
language:English
pages:88
Description: Starting a Coffee Shop Business document sample