Scribd Logo
Upload

Welcome to Scribd!

  • 457 views

    Analyzing Information Using Ict

    Uploaded by

    Sandriya Min
    This document discusses analyzing data using spreadsheets and ICT tools for communication and collaboration. It provides instructions on using spreadsheets to analyze inventory data by calculating available stock, determining percentage of remaining stock, and using functions like IF and VLOOKUP. It also lists several web-based collaboration tools that allow parties to view websites simultaneously, write and share documents, watch videos and chat in real time, and share files and manage projects online.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    Analyzing Information Using Ict

    Uploaded by

    Sandriya Min
    457 views18 pages
    This document discusses analyzing data using spreadsheets and ICT tools for communication and collaboration. It provides instructions on using spreadsheets to analyze inventory data by calculating available stock, determining percentage of remaining stock, and using functions like IF and VLOOKUP. It also lists several web-based collaboration tools that allow parties to view websites simultaneously, write and share documents, watch videos and chat in real time, and share files and manage projects online.

    Original Title

    Analyzing information using ict

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses analyzing data using spreadsheets and ICT tools for communication and collaboration. It provides instructions on using spreadsheets to analyze inventory data by calculating available stock, determining percentage of remaining stock, and using functions like IF and VLOOKUP. It also lists several web-based collaboration tools that allow parties to view websites simultaneously, write and share documents, watch videos and chat in real time, and share files and manage projects online.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    457 views18 pages

    Analyzing Information Using Ict

    Uploaded by

    Sandriya Min
    This document discusses analyzing data using spreadsheets and ICT tools for communication and collaboration. It provides instructions on using spreadsheets to analyze inventory data by calculating available stock, determining percentage of remaining stock, and using functions like IF and VLOOKUP. It also lists several web-based collaboration tools that allow parties to view websites simultaneously, write and share documents, watch videos and chat in real time, and share files and manage projects online.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    of 18

    ANALYZING

    INFORMATION
    USING ICT
    •Analyzing data is an important task
    within a business enterprise.
    •It is used to improve products and
    services, to promote and market them
    effectively, and help management make
    important decisions regarding the
    business.
    BOOKKEEPING

    •Bookkeeping is very important


    in operating a business.
    •It shows whether the business
    is profitable or not.
    USING SPREADSHEETS
    •Spreadsheets an help you do basic
    math such as addition, subtraction,
    multiplication, and divisions.
    •You can also do the following:
    •Format the column titles with text;
    •Enter textual information in each cell
    aside from numbers;
    •Delete, add, or merge columns or
    rows;
    •Add or delete sheets; and
    •Select printing options
    •1. Copy the raw materials inventory in
    a new spreadsheet file.
    •2. Compute for the (available stock) by
    deducting the (daily usage) from the
    (start of the week stock).
    •3. To make the inventory more useful to
    you as entreprenuer, it should inform you
    whether there is a need to buy more
    stocks. This information should be included
    under (remarks). To do this, you should
    determine the percentage of (available
    stock). Add a column that will contain the
    information.
    •4. Compute for the (percentage of
    remaining stock).
    •5. Use the (if function) to generate
    automatic comment under (remarks).
    •6. Do the if function for the rest of the
    data in column L.
    •7. Now, add another row
    •8. Use the countif function to automatically
    count the number of items with
    (inaduqaute). Remarks under column L.
    •9. Analyze the entries in the function
    argument box.
    •10. add another column with (supplier) as
    heading.
    •11. This time you need to set a condition
    that will automatically set the supplier’s
    name. to do this, you need to create a
    separate table which will serve as
    reference for the condition.
    •12. The VLOOKUP function will be
    used for this task. Take a look at the
    function argument box.
    •13. Repeat the VLOOKUP formula for
    the rest of the cells under column M.
    •14. Save your work.
    COMMUNICATING
    AND
    COLL ABORATING
    USING ICT
    • Communication is one area in which ICT has
    made huge strides.
    • In the world of business, online communication
    tools have made possible real-time conferences
    and collaborations among business associates
    in different parts of the world.
    SOME OF EXAMPLES
    OF WEB-BASED
    C O L L A B O R AT I O N
    TOOLS
    •Channel.me – allows parties to view a
    website simultaneously while chatting
    online.
    •Entri – for writing and sharing
    documents.
    •Wiggio – for group work
    •My simple surface – online
    whiteboard to share ideas.
    •Hackpad – note-taking and writing
    outlines.
    •Synchtube – watch videos and chat
    in real time
    •Dabbleboard – virtual whiteboard; basic
    version is free
    •Wizehive – share files, manage projects,
    track activity
    •Skype in the classroom – allows online
    sharing of resources among students and
    teachers
    •Thinkbinder – makes possible the
    creation of online study group.
    • Vyew – meet and share content in
    real-time or anytime.
    •Scribblar – a multi-user whiteboard,
    live audio, image collaboration, text
    chat, and more

    You might also like