Coffee Shop Shop Sample Business Plan

Document Sample
Coffee Shop Shop Sample Business Plan 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 some
can get Excel to calculate their possible   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 expenditure
bring information together into a sheet     spreadsheet that records sales and
that shows how things might progress        purchases and indicates monthly profits
throughout a year.                          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 completed        Add data to a ready-made Excel
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 and     Take an existing data sheet and re-work
alternative spreadsheet programmes           it to make it more presentable and/or
Show how default settings can be             user-friendly
changed and how the careful use of           Try out on-line alternatives to Microsoft
colours and lines can make sheets much       products
easier to understand and interpret           Draw some conclusions as to relative
Illustrate the classic printing problems!    advantages and disadvantages of colour
                                             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 managing
handling and explain why some are         data by illustrating a process from data
more appropriate to each type of data     input through to utilisation in various
Link to previous session findings as to   departments
support needs




Illustrate various methods of data        Describe the various ways for managing
handling and explain why some are         data by illustrating a process from data
more appropriate to each type of data     input through to utilisation in various
Link to previous session findings as to   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 problems   would you know? Groups to look at
that can arise if this is not managed       arange of types of data and report on
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 they
and promotion will be illustrated, using    have a genuine interest and investigate
a range of examples and to lead students    the extent to which competitors in that
into describing how they might assess       field currently use the web to trade
whether their choice of activity might
effectively utilise this medium




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




Review                                      Review
half-term                                    half-term




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




More in-depth examination of the stages      Divide stages amongst the group and
in the cycle and how IT can support the      each to look in more detail at what they
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 part
Revisit the cash flow task from earlier      of the process of a selection of goods
sessions                                     from supplier to customer
Illustrate a purchase order and a sales
invoice
Explain how marketing is at the heart of   Groups to consider how they would
all business in one shape or another and   promote an organisation or activity, or
various techniques utilised in promotion   internal marketing such as consistent
the importance of a brand image, logos,    design of a range of department
themes etc.                                stationery and then to act as critics or
How IT supports these aspects and can      users for others' productions
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 in a



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 (especially    and proposed legislation within the EC
any that match current or recent events       that even the most informed student
or are particularly odd or memorable!)        will find challenging to research.
Speaker from TUC H&S Dept.




Selection of masses of data which is in       validation controls for data entry can be
forms that is either 'protected' or able to   included in most databases and they
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 earlier
some real forms for each of the sub-          has many further facilities that could be
groups                                        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 work     Discuss what they understand by       criteria
        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 and
        Ask for which IT systems might be          suggest solutions using IT systems
        effectively utilised.                      to make those links efficient and
        Describe how they might record simple      accurate.
        data like personnel information            Make a simple spreadsheet suitable
                                                   for maintaining data about
                                                   customers or staff




0d6a56aa-c47b-4936-932e-8380aa906237.xls 1/7/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 profitability   price charged.
        - and how to spot obvious errors!             Discuss other features that might
                                                      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 sheet       expenditure spreadsheet that
        that shows how things might progress          records sales and purchases and
        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




0d6a56aa-c47b-4936-932e-8380aa906237.xls 1/7/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 and      mailing
                                                 potential difficulties that might be   Notes for mail merge
                                                 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 and sample real-life departments and
        operational centres, found in typical       investigate their roles 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 and Lead discussion and present
        operational centres, found in typical       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




0d6a56aa-c47b-4936-932e-8380aa906237.xls 1/7/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.




0d6a56aa-c47b-4936-932e-8380aa906237.xls 1/7/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 at    which is in forms that is either
        problems that can arise if this is not     arange of types of data and report   'protected' or able to be changed
        managed properly                           on what may go wrong with it and     with some built-in error warnings
        Promote investigation into the extent      how they might avoid problems        that will appear, depending upon
        to which types of data can be shared                                            how they handle it
        and how processes can be put in place
        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 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
        might assess whether their choice of       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 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
        might assess whether their choice of       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




0d6a56aa-c47b-4936-932e-8380aa906237.xls 1/7/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 examples
        Provide examples in practice              techniques or clear text                of application to something
                                                  explanations.                           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 need      sub-groups
        flow                                      to record their part of the process     sample real forms
        Revisit the cash flow task from earlier   of a selection of goods from
        sessions                                  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 would       scenarios for students to use if
        of all business in one shape or another   promote an organisation or              necessary
        and various techniques utilised in        activity, or internal marketing such    good and bad examples of ICT
        promotion                                 as consistent design of a range of      use in marketing and theming or
        the importance of a brand image,          department stationery and then to       branding
        logos, themes etc.                        act as critics or users for others'
        How IT supports these aspects and can     productions
        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 addresses
        site                                      what their purpose is and how well      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




0d6a56aa-c47b-4936-932e-8380aa906237.xls 1/7/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




0d6a56aa-c47b-4936-932e-8380aa906237.xls 1/7/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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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 or                                                                   Ice breaker              Tutor presentation
                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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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 business              It would be useful to have a check that the Game                             Structural aids
                might go 'into the red' and estimate by how much                total expected annual income is an          Group work                       Tutorial
                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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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 of             satisfy stated criteria                                 Ice breaker              Tutor presentation
                content, noting methods to ensure protection of                                                                        Learner presentation     Video/DVD
                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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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 real-
                                                                                                                                                 Case Study               Q&A
                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 and                  Game                     Structural aids
                Safety Acts at the current time and what the most                  proposed legislation within the EC that                       Group work               Tutorial
                important features are that affect business,                       even the most informed student will find                      Ice breaker              Tutor presentation
                managers, staff and customers and will be able to                  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




0d6a56aa-c47b-4936-932e-8380aa906237.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 is      Buzz Groups              Project
                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 then               Learner presentation     Video/DVD
                                                                               their services could usefully be employed                                           Other
                                                                               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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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 processing,               Ice breaker              Tutor presentation
                produce an comment constructively on samples                   customer research methods and data                       Learner presentation     Video/DVD
                                                                               collection so there should be something                                           Other
                                                                               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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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




0d6a56aa-c47b-4936-932e-8380aa906237.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                 7 January 2011                  19

                Start time                       End time               Notes space to write anything that doesn't already have a box - special factors,
                9:22 AM                                                       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




0d6a56aa-c47b-4936-932e-8380aa906237.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                 7 January 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




0d6a56aa-c47b-4936-932e-8380aa906237.xls sample lesson plan (2)

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:163
posted:1/7/2011
language:English
pages:88
Description: Coffee Shop Shop Sample Business Plan document sample