Please enable JavaScript.

Coggle requires JavaScript to display documents.

Year 10 Revision (Content Creation tools (Coggle (free mindmap creator…

- - - - advantages
        
        You can create mindmaps for free
        
        you can add as much text as you want
        
        you can add branches to link text
      - disadvantages
        
        you can only have 3 private mindmaps
        
        You have to pay to have more private mindmaps
- - - - Word documents (.doc)
      - Web text pages (.htm or .html)
      - Web page images (.gif and .jpg)
      - Microsoft (Access) Database (.mdb)
      - Portable document format file (.pdf)
      - Microsoft excel (.xls)
      - Multimedia files (.mp3 and others)
      - Powerpoint (.pptx)
  - - - Applications typically provide way to open files d save them in a specific folder on a storage device
        
        The Save As dialog box of most Windows applications uses the operating system’s file management utility, so you can carry out a wide variety of file and folder tasks such as creating, renaming, and deleting files.
    - - File management utilities show you the files stored on your disks and help you work with them
        
        [http://w.sunybroome.edu/basic-computer-skills/functions/file_management/4file_management_utilities.html]
    - - Storage metaphors help you visualize and mentally organize the files on your disks
- - - - Column: A vertical devision of a page
        Cell: An intersection between a row and column
        Row: A range of cells that go across
        Formula: An expression which calculates value
        Data: Info that is stored in a spreadsheet
        Validation: Allows you to control what is entered
        
        SUM: Adds all of the numbers in a range of cells
        Label: a heading that names something
        Sort: The process of arranging things
        Cell reference: A reference to a cell or a range of cells
        Absolute cell reference: When a cell reference is locked with $ signs
        Chart: Visually display data
        
        Fill handle: A feature that allows you to extend a set of data
        Formatting: Changing the appearance of a cell without changing the data in the cell
        IF statement: Checks whether a condition is met or not
        Auto-SUM: A functions that inserts a formula in the selected cells that adds the numbers in the column above.
      - Example spreadsheet with tasks
    - - Formulas for excel
        
        How to write a basic formula
        
        Find and click on the cell where you would like to write the formula
        Type in the equal sign=
        Click on the cells you would like to include the formula
        Type in the operator
        Click of the other cell you would like to use in the formula
        Press enter
        
        Example formulas
        
        =C3D2= It multiples the number in C3 and the number in D2
        = SUM(E8:E15) = It finds the sum of the numbers in the cells range of E8 to E15
        =A1+B2= It adds the numbers in A1 to B2
        = AVERAGE(D1:D6) = It finds the average for the numbers in D1 to D16
        =(D2B4)/2= It multiples the numbers in D2 and B4 and then divides by 2
        
        Example of using the formulas
        
        1 more item...
      - Average: Returns the average of the numbers provided
        Minimum: Returns the smallest value from the numbers provided
        Maximum: Returns the largest value of numbers.
        
        https://gemselearning-my.sharepoint.com/:w:/r/personal/zainab_a2_wso_gemselearning_com/_layouts/15/Doc.aspx?sourcedoc=%7B5AAD209C-936F-4CA4-B1B1-BB32D791227B%7D&file=Spreadsheets%20recap.docx&action=default&mobileredirect=true
- - - - link for mainframes https://en.wikipedia.org/wiki/Mainframe_computer or in My learning:http://wso.ae.gems-fusion.com/index.php?name=FileManager&fid=4L24272829232929