Please enable JavaScript.

Coggle requires JavaScript to display documents.

Booking hall system WHV - Coggle Diagram

- - - - input devices
        
        keyboard
        
        for typing numbers,texts,formulas
        
        mouse
        
        for navigating and selecting cells
      - processing hardwares
        
        CPU (Central Processing Unit)
        
        processes calculations and runs excel
        
        RAM (memory)
        
        stores data temporarily while working on large spreadsheets
        
        hard drive/SSD
        
        stores the spreadsheet files and system software
      - output devices
        
        monitor/screen
        
        shows the spreadsheet interface and data
    - - tablet/ipad
      - phone
      - desktop
- - - - miro
        
        to make the flowcharts
      - coggle
        
        to make the mind maps
      - powerpoint
        
        to create the low/high fidelity wirteframes
      - excel
        
        to create the actual spreadsheet of the booking hall system
      - word
        
        evaluation
- - - - font and text
        
        font type
        
        for data + calibri
        
        for text = Arial rounded
        
        font size
        
        heading (Westwood village hall) = 16
        
        subheadings ( eg. menu) = 11
        
        data=11
        
        bold
        
        heading
        
        subheadngs
      - colours
        
        reflecting the WHV logo
        
        cyan/blue
        
        headings, subheadings,buttons
        
        light green
        
        table, subheadings, buttons
        
        dark green
        
        table
        
        black
        
        text
      - layout and structure
        
        logo = top left corner
        
        heading = above the logo
        
        subheading = top right corner
        
        labels =. each sheet labelled with the complementary task
      - number formatting
        
        currency= 2 decimal places
        
        alignment of numeric data = centred in the middle
- - - - type of validation
        
        data type
        
        numbers,texts,data only
        
        range check
        
        e.g. values between 1–100.
        
        list check
        
        drop down options
        
        presence check
        
        cannot leave cell blank
        
        format check
        
        e.g. dd/mm/yyyy for dates.