Docstoc

ICT mapping of Functional Skills content at KS3 (Excel)

Document Sample
ICT mapping of Functional Skills content at KS3 (Excel) Powered By Docstoc
					Functional skills standards: information and communication technology                                                                                                      Jun-07
                  Entry 1                    Entry 2                    Entry 3                         Level 1                          Level 2
                  1 interact with ICT for a 1 interact with ICT for 1a interact with and use an 1a interact with and use 1a select, interact with and use ICT
                  given purpose             a purpose               ICT system to meet needs ICT systems independently systems independently for a complex
                                                                                                to meet needs            task to meet a variety of needs

                  1.1 use ICT for a given    1.1 use computer           1.1 use correct procedures      1.1 use correct procedures       1.1 use correct procedures to start and
Use ICT Systems




                  purpose                    hardware                   to start and shut down an       to start and shut down an        shut down an ICT system
                                                                        ICT system                      ICT system
                  ICT: computer, touch                                  log in, log out, use shutdown   log in, log out, use shutdown    log in, log out, use shutdown menu
                  screen, cash-point                                    menu                            menu
                  machine, mobile phone,                                1.2 use input and output        1.2 use a communication          1.2 select and use a communication
                  multi-media devices, on-                              devices                         service to access the internet   service to access the internet
                  screen information
                  purpose: find local        keyboard, screen,          keyboard, mouse, touch          broadband, dial up, network,     broadband, dial up, network, mobile
                  community information,     printer, point and click   screen, microphone, printer,    mobile device                    device
                  use learning software      device, headphones,        headphones
                                             microphone

                                             1.2 use software           1.3 select and use software     1.3 select and use software      1.3 select and use software applications
                                             applications for a         applications to meet needs      applications to meet needs       to meet needs and solve problems
                                             purpose                    and solve problems              and solve given problems
                                             text processing,           word processing, graphics,      word processing,                 word processing, spreadsheet, graphics,
                                             graphics, web browser,     internet browser, email,        spreadsheet, graphics,           browser, email, audio and video software
                                             email                      audio or video player           internet browser, email,
                                                                                                        audio and video software
                  1.2 recognise and use      1.3 recognise and use      1.4 recognise and use           1.4 recognise and use            1.4 select and use interface features and
                  interface features         interface features         interface features              interface features effectively   system facilities effectively to meet needs
                                                                                                        to meet needs
                  icon, option button,       icon, option button,  icon, option button, hotspot,        desktop, windows, dialogue       desktop, windows, dialogue box, menu,
                  hotspot                    hotspot, window, menu window, dialogue box ,               box, menu, submenu,              submenu, toolbar, scrollbar, drag and
                                                                   menu, drag and drop                  toolbar, scrollbar , drag and    drop, zoom, template, wizard
                                                                                                        drop, zoom, minimise,
                                                                                                        maximise
                                                            1.5 understand that settings 1.5 adjust system settings as 1.5 select and adjust system settings as
                                                            can be adjusted according to appropriate to individual     appropriate to individual needs
                                                            individual needs             needs
                                                            window size, mouse              window size, mouse              window size, mouse settings, icon size,
                                                            settings, icon size, screen     settings, icon size, screen     screen resolution, desktop contrast,
                                                            resolution, desktop contrast,   resolution, desktop contrast,   volume, date and time
                                                            volume                          volume
Use ICT Systems




                                                                                            1b use ICT to plan work      1b use ICT to effectively plan work and
                                                                                            and evaluate their use of    evaluate the effectiveness of the ICT
                                                                                            ICT systems                  system used
                                                                                            1.6 use ICT to plan and      1.6 use ICT to effectively plan work and
                                                                                            organise work                review the effectiveness of ICT tools to
                                                                                                                         meet needs in order to inform future
                                                                                                                         judgments
                                                                                          time, convenience, cost        time, convenience, cost, quality, range of
                                                                                                                         facilities, versatility
                                                            1b store information          1c manage information          1c manage information storage to
                                                                                          storage                        enable efficient retrieval
                                                            1.6 work with files to enable 1.7 work with files and        1.7 manage files and folder structures to
                                                            storage and retrieval of      folders to organise, store and enable efficient information retrieval
                                                            information                   retrieve information
                                                            create, open, save, print and create, open, save, save       create, open, save, save as, print, close,
                                                            close files, name files       as , print and close files,    delete, view, rename, move and copy
                                                            appropriately                 create folders and             files , create folders and subfolders, name
                                                                                          subfolders , name files and files and folders appropriately
                                                                                          folders appropriately
                                                            1.7 insert and remove media 1.8 insert, remove, label and 1.8 insert, remove, label and store media
                                                                                          store media safely             safely
                                                            CD, DVD, memory stick,        CD, DVD, memory stick,         CD, DVD, memory stick, hard drives
                                                            hard drives                   hard drives
                  2 follow recommended   2 follow and       2 follow and understand       2 follow and understand        2a follow and understand the need for
                  safe practices         understand         the need for safety and       the need for safety and        safety and security practices
                                         recommended safe   security practices            security practices
                                         practices
                  2.1 minimise physical     2.1 minimise physical      2.1 minimise physical stress   2.1 minimise physical stress     2.1 minimise physical stress
                  stress                    stress
                  adjust seating and        adjust seating and         adjust seating and lighting,   adjust seating and lighting,     arrangement of hardware and cables,
                  lighting, avoid hazards   lighting, avoid hazards,   avoid hazards, take breaks,    avoid hazards, take breaks,      wrist rests and other devices
                                            take breaks                arrangement of hardware        arrangement of hardware
                                                                       and cables, wrist rests and    and cables, wrist rests
Use ICT Systems




                                                                       other devices
                  2.2 keep access           2.2 keep access            2.2 keep information secure    2.2 keep information secure      2.2 keep information secure
                  information secure        information secure
                  password, PIN             password, PIN              keep copies safe , keep        keep copies safe, take           keep copies safe, take backups, keep
                                                                       password or PIN secret         backups , keep password or       password or PIN secret
                                                                                                      PIN secret
                                                                                                      2.3 understand the danger of     2.3 understand the danger of computer
                                                                                                      computer viruses, and how        viruses, and how to minimise risk
                                                                                                      to minimise risk
                                                                                                      use virus-checking software,     use virus-checking software, treat files
                                                                                                      treat files from unknown         from unknown sources with caution
                                                                                                      sources with caution
                                            2.3 understand the         2.3 understand the need to     2.4 understand the need to       2.4 understand the need to stay safe and
                                            need to stay safe          stay safe and to respect       stay safe and to respect         to respect others when using ICT-based
                                                                       others when using ICT-         others when using ICT-           communication
                                                                       based communication            based communication
                                            avoid inappropriate        avoid inappropriate            avoid inappropriate disclos-     avoid inappropriate disclosure of
                                            disclosure of personal     disclosure of personal         ure of personal information,     personal information, avoid misuse of
                                            information                information, use appropriate   avoid misuse of images , use     images, use appropriate language,
                                                                       language                       appropriate language,            respect confidentiality, use copy lists with
                                                                                                      respect confidentiality, use     discrimination
                                                                                                      copy lists with discrimination
                                                                                                                                       2b troubleshoot
                                                                                                                                       2.5 identify ICT problems and take
                                                                                                                                       appropriate action
                                                                                                                                       software freeze, respond appropriately to
                                                                                                                                       error dialogue, virus threat, storage full,
                                                                                                                                       paper jam, uninstall software, know when
                                                                                                                                       & whom to ask for help to fix the problem
Functional skills standards: information and communication technology                                                                                                     Jun-07
                              Entry 1                      Entry 2                       Entry 3                       Level 1                        Level 2
                              3 recognise sources of       3 use appropriate sources     3 select and use              3 select and use a variety 3 select and use a variety
                              information                  of information                appropriate sources of        of sources of information  of sources of information
                                                                                         information                   independently to meet      independently for a
                                                                                                                       needs                      complex task
                              3.1 recognise sources of     3.1 recognise and use         3.1 select and use            3.1 select and use         3.1 select and use
                              information                  appropriate sources of ICT-   appropriate sources of ICT-   appropriate sources of ICT-appropriate sources of ICT-
                                                           based and other forms of      based and other forms of      based and other forms of   based and other forms of
                                                           information                   information                   information                information which match
                                                                                                                                                  requirements
                              information point, poster,   information point,            newspaper, book, image,       newspapers, books, images, newspapers, books, images,
Find and Select Information




                              newspaper, conversation,     newspaper, book, picture,     map, conversation, CD,        maps, conversations, CDs,  maps, conversations, CDs,
                              TV, web page, radio, text    map , conversation, CD,       DVD, text message,            DVDs, text messages,       DVDs, text messages,
                              message                      DVD , text message,           website, podcast, web log     podcasts, web logs, web-   podcasts, web logs, web-
                                                           website, podcast, web log                                   based reference sites      based reference sites

                                                                                                                       3.2 recognise copyright        3.2 recognise copyright and
                                                                                                                       constraints on the use of      other constraints on the use
                                                                                                                       information                    of information
                                                                                                                       music downloads,               music downloads,
                                                                                                                       acknowledgement of             acknowledgement of
                                                                                                                       sources, avoiding plagiarism   sources, avoiding
                                                                                                                                                      plagiarism, provisions of the
                                                                                                                                                      Data Protection Act
                              4 find information from an    4 find information from ICT- 4 use ICT to search for and      4 access, search for,           4 access, search for,
                              ICT-based source              based sources                  select information that        select and use ICT-based        select and use ICT-based
                                                                                           matches given                  information and evaluate        information and evaluate
Find and Select Information




                                                                                           requirements                   its fitness for purpose         its fitness for purpose
                              4.1 find appropriate          4.1 find information from ICT- 4.1 use internet sources of    4.1 access, navigate and        4.1 access, navigate and
                              information from an ICT-      based sources using            information                    search internet sources of      search internet sources of
                              based source                  appropriate facilities                                        information purposefully and    information purposefully and
                                                                                                                          effectively                     effectively
                              text message, voice mail, on- menu, contents list, index,   enter a web address, use a      enter a web address, use a      enter a web address, use a
                              screen information            follow links, forward and     search engine, use              search engine, browse,          search engine, browse, save
                                                            back                          bookmarks, follow links         save and use bookmarks          and use bookmarks
                                                                                          4.2 use appropriate search      4.2 use appropriate search      4.2 use appropriate search
                                                                                          techniques to find required     techniques to locate and        techniques and design
                                                                                          contents list, index, find or   search criteria, quotation      multiple search criteria,
                                                                                          search tool                     marks, search within results,   quotation marks, search
                                                                                                                          relational operators, find or   within results, relational
                                                                                                                          search tool                     operators, logical operators,
                                                                                                                                                          find or search tool including
                                                                                                                                                          wildcards
                                                                                          4.3 select and use              4.3 use information from a      4.3 use discrimination in
                                                                                          information that matches        variety of sources and          selecting information that
                                                                                          given requirements              evaluate its match to           matches requirements from
                                                                                                                          requirements and fitness for    a variety of sources and
                                                                                                                          purpose                         evaluate fitness for purpose
                                                                                          write down, copy and paste,     recognise intention and         recognise intention and
                                                                                          capture images, download        authority of provider,          authority of provider,
                                                                                          audio or video files            currency of the information,    currency of the information,
                                                                                                                          relevance, bias                 relevance, bias
Functional skills standards: information and communication technology                                                                                                                                        Jun-07
                                               Entry 1            Entry 2                 Entry 3                             Level 1                                Level 2
                                               5 enter and        5 enter and edit        5a enter and develop       5a enter, develop and format                    5a enter, develop and format information
                                               edit single        information for a       information to meet needs, information to suit its meaning                 independently to suit its meaning and
Develop, present and communicate information




                                               items of           simple given            in the form of:            and purpose, including:                         purpose, including:
                                               information        purpose
                                               5.1 enter and      5.1 enter information   5.1 enter and edit                  5.1 enter, organise, develop, refine   5.1 enter, organise, develop, refine and format
                                               edit information   and edit it as          information to achieve the          and format information, applying       information, applying editing techniques to meet
                                                                  necessary               required outcome                    editing techniques to meet needs       needs
                                               name, PIN          information: name,      information: email message,         headings, lists, tables, use of        organise: structure of information, document
                                                                  reference number,       letter, on-line form                templates                              layout , headings, subheadings, lists, tables,
                                                                  diary entry, text       edit: insert, delete, copy,         highlight, drag and drop, find,        use of templates
                                                                  message                 cut, paste, drag and drop,          replace, undo, redo, templates         edit: drag and drop, find, replace, undo, redo
                                                                  edit: insert, delete    undo, redo
                                                                                                                              5.2 use appropriate page layout        5.2 use appropriate page layout
                                                                                                                              margins, header, footer, portrait,     columns, margins, header, footer, portrait,
                                                                                                                              landscape, page breaks, page           landscape, page breaks, page numbering
                                                                                                                              numbering
                                                                                          • text                              • text and tables                      • text and tables
                                                                                          5.2 enter and format text to        5.3 format text to maximise clarity    5.3 enter and format text to maximise clarity and
                                                                                          enhance its effect                  and enhance presentation               enhance presentation
                                                                                          left, centre, right, font, style,   bullets, numbering , alignment,        bullets, numbering, sub-numbering , alignment,
                                                                                          size                                tabs, line spacing, colour, font,      tabs, line spacing, colour, font, style, size
                                                                                                                              style, size, simple tables
                                                                                                                                                                     5.4 create and format tables to maximise clarity
                                                                                                                                                                     and enhance presentation
                                                                                                                                                                     tables: timetable, components list, membership
                                                                                                                                                                     information
                                                                                                                                                                     format: horizontal and vertical text alignment,
                                                                                                                                                                     merge and split cells, gridlines, borders, shading

                                                                                          • images                            • images                               • images
                                               5.3 insert and position        5.4 obtain, insert, size, crop and       5.5 obtain, insert, size, crop and position
                                               images or other digital        position images that are fit for         images that are fit for purpose
                                               content to achieve a purpose   purpose
                                               clip-art, photo, scanned       clip-art, photo, scanned image           clip-art, photo, scanned image, borders
Develop, present and communicate information




                                               image, audio file
                                               • numbers                      • numbers                                • numbers
                                               5.4 enter and process          5.5 enter, develop and organise          5.6 enter, develop and organise numerical
                                               numbers to meet needs          numerical information that is fit for    information that is fit for purpose
                                                                              purpose
                                               enter a list of prices and     cell data types, cell ranges,            cell data types, cell ranges, absolute and
                                               generate a total               formulas with a single operator,         relative referencing , formulas, functions,
                                                                              SUM function, structure/layout of        replication , structure and layout of worksheet
                                                                              worksheet
                                                                              5.6 format numerical information         5.7 format numerical information appropriately
                                                                              appropriately
                                                                              currency, per cent, number of            currency, per cent, number of decimal places,
                                                                              decimal places                           date, time, text wrap, row height, column width,
                                                                                                                       gridlines, merged cells, cell borders

                                                                              • graphs
                                                                              5.7 create and develop charts and        5.8 create and develop charts and graphs to
                                                                              graphs to suit requirements, using       suit the numerical information, using suitable
                                                                              suitable labels                          labels
                                                                              pie chart, bar chart, single line        pie chart, bar chart, single line graph,
                                                                              graph, appropriate format, title, axis   scattergram, title, axis titles, legend
                                                                              titles, legend
                                                                              • records                                • records
                                                                              5.8 enter, organise and sort             5.9 enter, organise, select and edit records
                                                                              structured information in ascending      using field names and headings, data types and
                                                                              or descending order                      unique record identifier when appropriate
                                                                              field selection, data sort               spreadsheet or database, use data filtering
                                                                              (alphanumeric), filter
                                                                                                                       5.10 sort records on one or more fields in
                                                                                                                       ascending or descending order
                                                                                                                       table, spreadsheet, database
                                                                                            5b bring together              5b bring together information to          5b bring together information to suit content
                                                                                            information to achieve a       suit content and purpose                  and purpose
                                                                                            purpose
                                                                                            5.5 organise information of    5.9 organise information of different     5.11 bring together and organise components of
                                                                                            different forms to achieve a   forms or from different sources to        images and text
Develop, present and communicate information




                                                                                            purpose                        achieve a purpose
                                                                                            image with text, in a poster   organise: combine images, graphs          image, chart, text alignment, captions, text
                                                                                            or web page                    and tables with text, combine texts,      wrap, use of text boxes, behind, in front,
                                                                                                                           graphics, sound and video footage         grouping
                                                                                                                           purpose: for a poster, newsletter,
                                                                                                                           web page, multimedia presentation


                                                                                                                                                                     5.12 organise information of different forms or
                                                                                                                                                                     from different sources to achieve a purpose
                                                                                                                                                                     poster, newsletter, web page, catalogue,
                                                                                                                                                                     brochure , multimedia presentation
                                               6 submit           6 present                 6 present information and      6a present information in ways            6a present information in ways that are fit for
                                               information to     information that is       review its effectiveness       that are fit for purpose and              purpose and audience
                                               achieve a          fit for a given                                          audience
                                               purpose            purpose
                                               6.1 identify and   6.1 check accuracy        6.1 check meaning,             6.1 work accurately and proofread,        6.1 work accurately and proofread, using
                                               correct simple     and correct errors        accuracy and suitability       using software facilities where           software facilities where appropriate
                                               errors                                                                      appropriate for the task
                                               wrong button       check for missing         ensure meaning is clear,       ensure meaning is clear, seek             ensure meaning is clear, seek views of others,
                                               press, incorrect   words , correct           seek views of others, check    views of others, check spelling,          check spelling, check calculations, ensure
                                               password or        typing errors             spelling, check calculations   check calculations, ensure                consistent layout, print preview
                                               PIN                                                                         consistent layout, print preview

                                               6.2 submit         6.2 present               6.2 present information that   6.2 produce information that is fit for   6.2 produce information that is fit for purpose
                                               information        information that is fit   is fit for purpose             purpose and audience using                and audience using accepted layouts and
                                               correctly          for a purpose                                            accepted layouts as appropriate           conventions as appropriate
                                               confirm choice,    list, diary entry, text   information: email message,    letter, memo, report, newsletter ,        letter, memo, report, newsletter, brochure ,
                                               press enter key    message, email reply      letter, poster, web page       poster, information sheet ,               poster, web page, information sheet
                                                                                            fitness for purpose: impact,   webpage, multi-media presentation
                                                                                            clarity
                                                                                                                      6b evaluate the selection and use     6b evaluate the selection and use of ICT
                                                                                                                      of ICT tools and facilities used to   tools and facilities used to present
                                                                                                                      present information                   information
                                                                                                                      6.3 evaluate the effectiveness of     6.3 evaluate the effectiveness of ICT tools to
                                                                                                                      ICT tools to meet presentation        meet needs
                                                                                                                      needs
                                                                                                                      time taken, quality                  time taken, quality, range of facilities,
                                                                                                                                                           versatility, transferability of information into
Develop, present and communicate information




                                                                                                                                                           other formats speed of internet connection, time
                                                                                                                                                           constraints of downloading large files
                                                                                                                    6.4 review and modify work as it       6.4 review and modify work as it progresses to
                                                                                                                    progresses to ensure the result is fit ensure the result is fit for purpose and
                                                                                                                    for purpose and audience               audience, and to inform future judgments
                                                                                                                    produce drafts, review against         produce drafts, review against initial plans,
                                                                                                                    initial plans,check with intended      check with intended audience
                                               7 use ICT-       7 use ICT             7 select and use ICT to       audienceand use ICT to
                                                                                                                    7 select                               7 select and use ICT to communicate and
                                               based comm-      appropriately to      communicate                   communicate and exchange               exchange information safely, responsibly
                                               unication        communicate                                         information safely, independ-          and effectively including storage of
                                                                                                                    ently, responsibly & effectively       messages and contacts lists
                                               7.1 receive ICT- 7.1 use ICT to send   7.1 create, access and        7.1 create, access, read and           7.1 create, access, read and respond
                                               based            and receive           respond appropriately to ICT- respond appropriately to email and appropriately to email and other ICT-based
                                               communication information              based communication           other ICT-based communication,         communication, including attachments, and
                                                                                                                    including attachments, and adapt       adapt style to suit audience
                                                                                                                    style to suit audience

                                               receive a text   text messaging,       read, reply, forward, create,   open mailbox, read, reply, forward,   open mailbox, read, reply, forward,
                                               message, view    email, internet       delete                          communicate using from, to, cc,       communicate using from, to, cc, bcc, subject
                                               an email                                                               bcc, subject and content fields,      and content fields, add and open attachments,
                                               message                                                                add and open attachments , use        use instant messaging, contribute to forums,
                                                                                                                      instant messaging , contribute to     web logs or web-based reference sites
                                                                                                                      forums, web logs or web-based
                                                                                                                      reference sites
                                                                                                                      7.2 use a contacts list               7.2 manage efficient storage of ICT-based
                                                                                                                                                            communications, attachments and contact
                                                                                                                                                            addresses
add, amend and delete entries   create and maintain folders , delete redundant
                                messages , add amend & delete contact entries
Functional Skills ICT Level 2: Use ICT Systems
Skill standard          Coverage                         Examples/applications
Learners can:                                            (Level 1 examples should also be referred to)
1a select, interact     1.1 use correct procedures to    log in, log out, use shutdown menu
with and use ICT        start and shut down an ICT
systems                 system
independently for a     1.2 select and use a             broadband, dial up, network, mobile device
complex task to         communication service to
meet a variety of       access the internet
needs                   1.3 select and use software      word processing, spreadsheet, graphics,
                        applications to meet needs       browser, email, audio and video software
                        and solve problems
                        1.4 select and use interface desktop, windows, dialogue box, menu,
                        features and system facilities submenu, toolbar, scrollbar, drag and drop,
                        effectively to meet needs      zoom, template, wizard

                        1.5 select and adjust system     window size, mouse settings, icon size,
                        settings as appropriate to       screen resolution, desktop contrast,
                        individual needs                 volume, date and time
1b use ICT to           1.6 use ICT to effectively       time, convenience, cost, quality, range of
effectively plan work   plan work and review the         facilities, versatility
and evaluate the        effectiveness of ICT tools to
effectiveness of the    meet needs in order to
ICT system used         inform future judgments
1c manage               1.7 manage files and folder      create, open, save, save as, print, close,
information storage     structures to enable efficient   delete, view, rename, move and copy files,
to enable efficient     information retrieval            create folders and subfolders, name files
retrieval                                                and folders appropriately
                        1.8 insert, remove, label and    CD, DVD, memory stick, hard drives
                        store media safely
2a follow and           2.1 minimise physical stress     arrangement of hardware and cables, wrist
understand the need                                      rests and other devices
for safety and      2.2 keep information secure          keep copies safe, take backups, keep
security practices                                       password or PIN secret
                    2.3 understand the danger of         use virus-checking software, treat files from
                    computer viruses, and how to         unknown sources with caution
                    minimise risk
                    2.4 understand the need to        avoid inappropriate disclosure of personal
                    stay safe and to respect          information, avoid misuse of images, use
                    others when using ICT-based       appropriate language, respect
                    communication                     confidentiality, use copy lists with
                                                      discrimination
2b troubleshoot         2.5 identify ICT problems and software freeze, respond appropriately to
                        take appropriate action       error dialogue, virus threat, storage full,
                                                      paper jam, uninstall software, know when
                                                      and whom to ask for help to fix the problem
Functional Skills ICT Level 2: Find and Select Information
 3 select and use a     3.1 select and use               newspapers, books, images, maps,
variety of sources of   appropriate sources of ICT-      conversations, CDs, DVDs, text messages,
information             based and other forms of         podcasts, web logs, web-based reference
independently for a     information which match          sites
complex task            requirements
                        3.2 recognise copyright and      music downloads, acknowledgement of
                        other constraints on the use     sources, avoiding plagiarism, provisions of
                        of information                   the Data Protection Act
 4 access, search       4.1 access, navigate and         enter a web address, use a search engine,
for, select and use     search internet sources of       browse, save and use bookmarks
ICT-based               information purposefully and
information and         effectively
evaluate its fitness    4.2 use appropriate search       multiple search criteria, quotation marks,
for purpose             techniques and design            search within results, relational operators,
                        queries to locate and select     logical operators, find or search tool
                        relevant information             including wildcards

                        4.3 use discrimination in        recognise intention and authority of
                        selecting information that       provider, currency of the information,
                        matches requirements from        relevance, bias
                        a variety of sources and
                        evaluate fitness for purpose

Functional Skills ICT L2: Develop, present and communicate
 5a enter, develop      5.1 enter, organise, develop,    organise: structure of information,
and format              refine and format                document layout, headings, subheadings,
information             information, applying editing    lists, tables, use of templates edit: drag and
independently to suit   techniques to meet needs         drop, find, replace, undo, redo
its meaning and
                        5.2 use appropriate page         columns, margins, header, footer, portrait,
purpose, including:
                        layout                           landscape, page breaks, page numbering
• text and tables       5.3 enter and format text to      bullets, numbering, sub-numbering,
                        maximise clarity and             alignment, tabs, line spacing, colour, font,
                        enhance presentation             style, size
                        5.4 create and format tables     tables: timetable, components list,
                        to maximise clarity and          membership information format: horizontal
                        enhance presentation             and vertical text alignment, merge and split
                                                         cells, gridlines, borders, shading
• images                5.5 obtain, insert, size, crop   clip-art, photo, scanned image, borders
                        and position images that are
                        fit for purpose
• numbers               5.6 enter, develop and           cell data types, cell ranges, absolute and
                        organise numerical               relative referencing, formulas, functions,
                        information that is fit for      replication, structure and layout of
                        purpose                          worksheet
                        5.7 format numerical             currency, %, number of decimal places,
                        information appropriately        date, time, text wrap, row height, column
                                                         width, gridlines, merged cells, cell borders
                     5.8 create and develop            pie chart, bar chart, single line graph,
                     charts and graphs to suit the     scattergram, title, axis titles,legend
                     numerical information, using
                     suitable labels
 • records           5.9 enter, organise, select       spreadsheet or database, use data filtering
                     and edit records using field
                     names and headings, data
                     types and unique record
                     identifier when appropriate
                     5.10 sort records on one or       table, spreadsheet, database
                     more fields in ascending or
                     descending order
 5b bring together   5.11 bring together and           image, chart, text alignment, captions, text
information to suit  organise components of            wrap, use of text boxes, behind, in front,
content and purpose images and text                    grouping
                     5.12 organise information of
                     different forms or from
                     different sources to achieve
                     a purpose
 6a present          6.1 work accurately and           ensure meaning is clear, seek views of
information in ways proofread, using software          others, check spelling, check calculations,
that are fit for     facilities where appropriate      ensure consistent layout, print preview
purpose and
audience             6.2 produce information that      letter, memo, report, newsletter, brochure,
                     is fit for purpose and            poster, web page, information sheet
                     audience using accepted
                     layouts and conventions as
                     appropriate
 6b evaluate the     6.3 evaluate the                  time taken, quality, range of facilities,
selection and use of effectiveness of ICT tools to     versatility, transferability of information into
ICT tools and        meet needs                        other formats speed of internet connection,
facilities used to                                     time constraints of downloading large files
present information
                     6.4 review and modify work        produce drafts, review against initial plans,
                     as it progresses to ensure        check with intended audience
                     the result is fit for purpose
                     and audience, and to inform
                     future judgments

 7 select and use       7.1 create, access, read and   open mailbox, read, reply, forward,
ICT to communicate      respond appropriately to       communicate using from, to,cc, bcc,
and exchange            email and other ICT-based      subject and content fields, add and open
information safely,     communication, including       attachments, use instant messaging,
responsibly and         attachments, and adapt style   contribute to forums, web logs or web-
effectively including   to suit audience               based reference sites
storage of              7.2 manage efficient storage   create and maintain folders, delete
messages and            of ICT-based                   redundant messages, add, amend and
contacts lists          communications,                delete contact entries
                        attachments and contact
                        addresses
Functional Skills ICT Level 1: Use ICT Systems
Skill standard       Coverage                     Examples/applications
Learners can:                                                                                  Y7   Y8   Y9 Actions
1a interact with     1.1 use correct              log in, log out, use shutdown menu
and use ICT          procedures to start and
systems              shut down an ICT system
independently to     1.2 use a communication      broadband, dial up, network, mobile
meet need            service to access the        device
                     internet
                     1.3 select and use           word processing, spreadsheet,
                     software applications to     graphics, browser, email, audio and
                     meet needs and solve         video software
                     problems
                     1.4 recognise and use        desktop, windows, dialogue box, menu,
                     interface features           submenu, toolbar, scrollbar, drag and
                     effectively to meet needs    drop, zoom, template, wizard

                   1.5 adjust system settings     window size, mouse settings, icon size,
                   as appropriate to              screen resolution, desktop contrast,
                   individual needs               volume
1b use ICT to plan 1.6 use ICT to plan and        time, convenience, cost
work and evaluate organise work
their of the ICT
system used

1c manage            1.7 work with files and      create, open, save, save as, print and
information          folders to organise, store   close files, create folders and
storage1b use ICT    and retrieve information     subfolders, name files and folders
to plan work and                                  appropriately
evaluate their use   1.8 insert, remove, label    CD, DVD, memory stick, hard drives
of ICT systems       and store media safely
2a follow and        2.1 minimise physical     adjust seating and lighting, avoid
understand the       stress                    hazards, take breaks, arrangement of
need for safety                                hardware and cables, wrist rests
and security         2.2 keep information      keep copies safe, take backups, keep
practices            secure                    password or PIN secret
                     2.3 understand the danger use virus-checking software, treat files
                     of computer viruses, and  from unknown sources with caution
                     how to minimise risk

                     2.4 understand the need     avoid inappropriate disclosure of
                     to stay safe and to respect personal information, avoid misuse of
                     others when using ICT-      images, use appropriate language
                     based communication


Functional Skills ICT Level 1: Find and Select Information
3 select and use a   3.1 select and use           newspapers, books, images, maps,
variety of sources   appropriate sources of       conversations, CDs, DVDs, text
of information       ICT-based and other          messages, podcasts, web logs, web-
independently to     forms of information         based reference sites
meet needs           3.2 recognise copyright      music downloads, acknowledgement of
                     and other constraints on     sources, avoiding plagiarism
                     the use of information
4 access, search 4.1 access, navigate and         enter a web address, use a search
for, select and use search internet sources of    engine, browse, save and use
ICT-based            information purposefully     bookmarks
information and      and effectively
evaluate its fitness
for purpose          4.2 use appropriate          search criteria, quotation marks, search
                     search techniques to         within results, relational operators, find
                     locate and select relevant   or search tool
                     information
                     4.3 use discrimination in    recognise intention and authority of
                     selecting information that   provider, currency of the information,
                     matches requirements         relevance, bias
                     from a variety of sources
                     and evaluate fitness for
                     purpose
Functional Skills ICT L1: Develop, present & communicate
Skill standard         Coverage                   Examples/applications                          Y7   Y8   Y9 Actions
5a enter, develop     5.1 enter, organise,       headings, lists, tables, use of
and format            develop, refine and format templates; highlight, drag and drop,
information to suit   information, applying      find, replace, undo, redo, templates
its meaning and       editing techniques to meet
purpose, including:   needs

                      5.2 use appropriate page      margins, header, footer, portrait,
                      layout                        landscape, page breaks, page
                                                    numbering
• text and tables     5.3 format text to            bullets, numbering, alignment, tabs, line
                      maximise clarity and          spacing, colour, font, style, size, simple
                      enhance presentation          tables
• images              5.4 obtain, insert, size,      clip-art, photo, scanned image
                      crop and position images
                      that are fit for purpose

• numbers             5.5 enter, develop and        cell data types, cell ranges, formulas
                      organise numerical            with a single operator, SUM function,
                      information that is fit for   structure/layout of worksheet
                      purpose
                      5.6 format numerical          currency, per cent, number of decimal
                      information appropriately     places
• graphs              5.7 create and develop        pie chart, bar chart, single line graph,
                      charts and graphs to suit     appropriate format, title, axis titles,
                      requirements, using           legend
                      suitable labels
• records             5.8 enter, organise and       field selection, data sort
                      sort structured information   (alphanumeric), filter
                      in ascending or
                      descending order
5b bring together     5.9 organise information      organise: combine images, graphs and
information to suit   of different forms or from    tables with text, combine texts,
content and           different sources to          graphics, sound and video footage;
purpose               achieve a purpose             purpose: for a poster, newsletter, web
                                                    page, multimedia presentation
6a present            6.1 work accurately and       ensure meaning is clear, seek views of
information in        proofread, using software     others, check spelling, check
ways that are fit     facilities where              calculations, ensure consistent layout,
for purpose and       appropriate for the task      print preview
audience               6.2 produce information      letter, memo, report, newsletter, poster,
                      that is fit for purpose and   information sheet, webpage, multi-
                      audience using accepted       media presentation
                      layouts and conventions
                      as appropriate

 6b evaluate the    6.3 evaluate the                time taken, quality
selection and use   effectiveness of ICT tools
of ICT tools and    to meet presentation
facilities used to  needs
present information 6.4 review and modify           produce drafts, review against initial
                    work as it progresses to        plans, check with intended audience
                    ensure the result is fit for
                    purpose and audience
 7 select and use 7.1 create, access, read          open mailbox, read, reply, forward,
ICT to              and respond appropriately       communicate using from, to, cc, bcc,
communicate and to email and other ICT-             subject and content fields, add and
exchange            based communication,            open attachments, use instant
information safely, including attachments,          messaging, contribute to forums, web
responsibly and     and adapt style to suit         logs or web-based reference sites
effectively         audience

                      7.2 use a contacts list       add, amend and delete entries
Functional Skills ICT Level 2: Use ICT Systems
Skill standard                   Coverage
Learners can:
1a select, interact with and     1.1 use correct procedures to start and shut down an
use ICT systems                  ICT system
independently for a complex      1.2 select and use a communication service to access
task to meet a variety of        the internet
needs                            1.3 select and use software applications to meet needs
                                 and solve problems
                                 1.4 select and use interface features and system
                                 facilities effectively to meet needs
                                 1.5 select and adjust system settings as appropriate to
                                 individual needs
1b use ICT to effectively        1.6 use ICT to effectively plan work and review the
plan work and evaluate the       effectiveness of ICT tools to meet needs in order to
effectiveness of the ICT         inform future judgments
system used
1c manage information            1.7 manage files and folder structures to enable
storage to enable efficient      efficient information retrieval
retrieval                        1.8 insert, remove, label and store media safely
2a follow and understand         2.1 minimise physical stress
the need for safety and          2.2 keep information secure
security practices               2.3 understand the danger of computer viruses, and
                                 how to minimise risk
                                 2.4 understand the need to stay safe and to respect
                                 others when using ICT-based communication
2b troubleshoot                  2.5 identify ICT problems and take appropriate action


Functional Skills ICT Level 2: Find and Select Information
Skill standard                 Coverage
 3 select and use a variety of3.1 select and use appropriate sources of ICT-based
sources of information        and other forms of information which match
independently for a complex   requirements
task                          3.2 recognise copyright and other constraints on the
                              use of information
 4 access, search for, select 4.1 access, navigate and search internet sources of
and use ICT-based             information purposefully and effectively
information and evaluate its 4.2 use appropriate search techniques and design
fitness for purpose           queries to locate and select relevant information
                              4.3 use discrimination in selecting information that
                              matches requirements from a variety of sources and
                              evaluate fitness for purpose



Functional Skills ICT L2: Develop, present and communicate
Skill standard                 Coverage
 5a enter, develop and        5.1 enter, organise, develop, refine and format
format information            information, applying editing techniques to meet needs
independently to suit its
meaning and purpose,          5.2 use appropriate page layout
 • text and tables            5.3 enter and format text to maximise clarity and
                              enhance presentation
                              5.4 create and format tables to maximise clarity and
                              enhance presentation
 • images                     5.5 obtain, insert, size, crop and position images that
                              are fit for purpose
 • numbers                    5.6 enter, develop and organise numerical information
                              that is fit for purpose
                              5.7 format numerical information appropriately
                              5.8 create and develop charts and graphs to suit the
                              numerical information, using suitable labels
 • records                    5.9 enter, organise, select and edit records using field
                              names and headings, data types and unique record
                              identifier when appropriate
                              5.10 sort records on one or more fields in ascending or
                              descending order
 5b bring together            5.11 bring together and organise components of
information to suit content   images and text
and purpose                   5.12 organise information of different forms or from
                              different sources to achieve a purpose
 6a present information in    6.1 work accurately and proofread, using software
ways that are fit for purpose facilities where appropriate
and audience                  6.2 produce information that is fit for purpose and
                              audience using accepted layouts and conventions as
                              appropriate
 6b evaluate the selection    6.3 evaluate the effectiveness of ICT tools to meet
and use of ICT tools and      needs
facilities used to present    6.4 review and modify work as it progresses to ensure
information                   the result is fit for purpose and audience, and to inform
                              future judgments
 7 select and use ICT to      7.1 create, access, read and respond appropriately to
communicate and exchange email and other ICT-based communication, including
information safely,           attachments, and adapt style to suit audience
responsibly and effectively
including storage of          7.2 manage efficient storage of ICT-based
messages and contacts lists communications, attachments and contact addresses

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:32
posted:8/11/2011
language:English
pages:20