Class- 7th Chaptert -2 Analysing Data with MS Excel Charts

 Class- 7th 

Chapter -2 Analysing Data with MS Excel Charts

Key Vocabulary

Infographics : Presenting information with graphics and lesser text.

Visual : Graphical or pictorial.

Trend : Change in value over a period of time, e.g. population, salary, prices, poverty.

Correlation : How one value affects the other. E.g., height and weight.

Legend : Colorful identification of values in the chart for easier analysis.

Chart Area : Space occupied by entire chart.

Plot Area : Area within the chart in which data values are plotted.

Exercise 

A. Multiple Choice Questions 

1.    a) 

2.    d) All of these 

3.    b) Scatter Chart 

4.    c) Pie Chart

5.    a) Line Chart 

6.    c) Correlation 

7.    b) Legend

8.    c) Both (a) and (b) 

B.    Write the correct type of chart for each scenario.

( Area chart , Pie Chart , Scatter Chart , Bar chart , Area Chart) 

1.     Area chart 

2.    Pie Chart 

3.    Area Chart

4.     Scatter chart

5.     Bar Chart

C.     Answer the following questions in short. 

Q.1    What is chart ?

Ans:-   A chart is a way of showing information using pictures, symbols, or diagrams instead of just text or numbers. 

Q.2    What is data visualisation ? 

Ans:-   Data and Information in graphical or visual form are called data visualisations . 

Q.3    How many types of Chart are there in Excel ? 

Ans:-   There are seven types of common charts in Excel. 

1.    Column Chart 

2.    Line Chart 

3.    Pie Chart 

4.    Bar Chart 

5.    Surface Chart

6.    Doughnut Chart 

7.    Scatter Chart

Q.4    What is the extension of Microsoft Excel? 

Ans:-    " xlsx " or  "xls" is the extension of Microsoft Excel.

D.     Answer the following questions in long. 

Q.1    What is the significance of charts and graphs:

Ans:-    Charts and graphs turn raw numbers into pictures that are quick to read. They help us see trends, compare values, find links between data, and make better decisions faster than looking at long tables.

Q.2  What do you mean by a trend ? Which types of charts are suitable to show trends ? Give and Example of a trend .   

Ans:-    A trend is the general direction in which data changes over time. It may indicate an increase, a decrease, or no change. Line charts and Area charts are suitable for showing trends. For example, the monthly sales of a shop from January to June.

Q.3    How is Pie chart useful in assessing the performance of a player in the whole team?

Ans:-     A Pie chart shows each player's contribution as a part of the whole team's performance. It helps compare the percentage contribution of each player and identify the best-performing player.

Q.4    How will you change the location of a chart to sheet? 

Ans:-   To change the location of a chart to a new sheet in Microsoft Excel:

1. 1. Select the chart.

2. 2. Click the Design tab (Chart Tools).

3. 3. Click Move Chart.

4. 4. Select New Sheet.

5. 5. Type a name for the new sheet (if required).

6. Click OK.

Q.5    Describe any 5 main elements of a column chart very briefly. 

Ans:-     Five main elements of a Column Chart are:

             Chart Title – Displays the name of the chart.

             Category (X) Axis – Shows the names of categories.

             Value (Y) Axis – Shows the numerical values.

             Data Series – Represents the data using vertical columns.

             Legend – Identifies the different data series by their colours or patterns.

 

Class-7th (Chapter- 1 How computers Represent Data ? )

Important Full Forms of Computer Technology

Hardware Components

1.     CPU - Central Processing Unit  

2.     GPU - Graphics Processing Unit  

3.     SSD - Solid State Drive  

4.     HDD - Hard Disk Drive  

5.     NIC - Network Interface Card  

6.     MAC - Media Access Control  

7.     BIOS - Basic Input Output System  

8.     PCB - Printed Circuit Board  

9.     CRT - Cathode Ray Tube  

10.     OLED - Organic Light-Emitting Diode  

11.     VGA - Video Graphics Array  

12.     SVGA - Super Video Graphics Array  

 Networking 

13.     LAN - Local Area Network  

14.     WAN - Wide Area Network  

15.     MAN - Metropolitan Area Network  

16.     PAN - Personal Area Network  

17.     WLAN - Wireless Local Area Network  

18.     SAN - Storage Area Network  

19.     CAN - Campus Area Network  

20.     VPN - Virtual Private Network  

21.     VLAN - Virtual Local Area Network  

22.     ISP - Internet Service Provider  

23.     DNS - Domain Name System  

24.     DHCP - Dynamic Host Configuration Protocol  

25.     TCP - Transmission Control Protocol  

26.     UDP - User Datagram Protocol  

27.     SNMP - Simple Network Management Protocol  

28.     ICMP - Internet Control Message Protocol  

29.     NAT - Network Address Translation  

---

Programming & Software

30.     API - Application Programming Interface  

31.     GUI - Graphical User Interface  

32.     CLI - Command Line Interface  

33.     SDK - Software Development Kit  

34.     JVM - Java Virtual Machine  

35.     JRE - Java Runtime Environment  

36.     XML - Extensible Markup Language  

37.     HTML - Hypertext Markup Language  

38.     SQL - Structured Query Language  

39.     OOP - Object-Oriented Programming  

40.     SaaS - Software as a Service  

41.     PaaS - Platform as a Service  

42.     IaaS - Infrastructure as a Service  

 Storage & Data Transfer

43.     RAM - Random Access Memory  

44.     ROM - Read-Only Memory  

45.     USB - Universal Serial Bus  

46.     DPI - Dots Per Inch  

47.     MB - Megabyte  

48.     GB - Gigabyte  

49.     TB - Terabyte  

50.     PB - Petabyte  

51.     EB - Exabyte  

52.     ZB - Zettabyte  

53.     YB - Yottabyte  

54.     KB - Kilobyte  

55.     bps - Bits Per Second  

56.     KBps - Kilobytes Per Second  

57.     MBps - Megabytes Per Second  

58.     GBps - Gigabytes Per Second  

59.     Tbps - Terabits Per Second  

60.     IOPS - Input/Output Operations Per Second  

61.     RPM - Revolutions Per Minute  

Security & Protocols

62.     SSL - Secure Sockets Layer  

63.     TLS - Transport Layer Security  

64.     HTTPS - Hypertext Transfer Protocol Secure  

65.     WEP - Wired Equivalent Privacy  

66.     WPA - Wi-Fi Protected Access  

67.     IDS - Intrusion Detection System  

68.     IPS - Intrusion Prevention System  

Miscellaneous

69.     AI - Artificial Intelligence  

70.     ML - Machine Learning  

71.     IoT - Internet of Things  

72.     ASCII - American Standard Code for Information Interchange  

73.     GSM - Global System for Mobile Communications  

74.     ERP - Enterprise Resource Planning  

75.     CRM - Customer Relationship Management  

76.     OCR - Optical Character Recognition  

77.     MICR - Magnetic Ink Character Recognition  

78.     MIDI - Musical Instrument Digital Interface  

79.     COMPUTER (Common Operating Machine Purposely Used for Technical Education Research) 

80.     IPv6 - Internet Protocol version 6  

81.     CD-ROM - Compact Disc Read-Only Memory  

82.     DVD - Digital Versatile Disc  

83.     FTP - File Transfer Protocol  

84.    HTTP - Hypertext Transfer Protocol  

85.     TFTP - Trivial File Transfer Protocol  

86.     IVR - Interactive Voice Response  

87.     RAID - Redundant Array of Independent Disks  

88.     SCSI - Small Computer System Interface  

89.     UEFI - Unified Extensible Firmware Interface  

90.     VR - Virtual Reality  

91.     WYSIWYG - What You See Is What You Get  

92.     Virus - Vital Information Resources Under Siege

93.     RAT - Remote Access Trojan

94.     WORM - Write Once Read Many

95.     SMTP - Simple Mail Transfer Protocol

96.    FDD - Floppy Disk Drive

97.    FAT - File Allocation Table

98.    FAQ - Frequently Asked Questions

99.    MS - Microsoft 

100.  FIFO - First In First Out

Important Shortcut key for Computer Window

1.    Ctrl + Shift + N: Create a new folder.

2.   Ctrl + C: Copy selected text or item

3.   Ctrl + X: Cut selected text or item

4.   Ctrl + V: Paste copied or cut text or item

5.   Ctrl + Z: Undo previous action

6.   Ctrl + A: Select all text or items

7.   Ctrl + F: Find a specific word.

8.  Ctrl + S: Save document or file

9.  Ctrl + N: Open a new document or file

10.  Ctrl + O: Open an existing document or file

11. Ctrl + P: Print the current document or file

12. Alt + Tab: Switch between open windows or applications

13.  Windows key + L: Lock the computer

14.  Windows key + D: Show or hide the desktop

15.  Windows key + E: Open File Explorer

16.  Windows key + R: Open the Run dialog box

17.  F1: Open help Window

18.  F5: Refresh the current webpage 

19.  Ctrl + Alt + Delete: Open Task Manager

20.  Alt + F4 : Closed running program 

Chapter- 1 How computers Represent Data ? 

Key Vocabulary

Bit :             Smallest unit of representing data in computers.

Byte :          Set of 8 bits.

ASCII :         American Standard Code for Information Interchange

EBCDIC :     Extended Binary Coded Decimal Interchange Code ()

UNICODE : Universal Character Set Code

UTF :             Unicode Transformation Format

Base :     Number of digits used in a number system.    

Exercise ( Page- 16-17) 

A. Multiple choice questions

1. c) Both a) and b) 

2.   b) 8

3. d) Unicode

4. d) g

5.  a) Fifth bit

6.  c) 10

7. c) F

8. b) 255 

B. Fill in the blanks 

1. bit

2.  2

3. Bytes 

4. MSB

5. Base

A.    Answer the following questions in short.

Q.1      How many types of number system are there in computer. 

Ans:-     There are four types of number system:-    

            Number System                                         Base 

 1.     Binary Number System                                  2

2.     Octal Number System                                      8

3.     Decimal Number System                              10

4.     Hexadecimal Number System                    16        

Q.2    What is stands for ASCII & UNICODE ?

Ans:-    ASCII :- American Standard Code for Information Interchange.

UNICODE :-  Universal Character Set 

Q.3          Solve this binary addition 

    i)    (1 0 0 0)  + (0 1 1 1)

                Ans :-    1 0 0 0                            

                           + 0 1 1 1 

                              1 1 1  1

ii)     (1 1 1 1 1)     +   (0 1 0 1 1)

Ans:-               1    1    1    1        ------- carry over 

                         1   1    1    1    1

                    +   0    1    0    1    1

                      1 0    1    0    1    0

Q.4    What do you understand by number system? 

Ans:-    A number system can be defined as a way of counting. We humans use numbers 0 to 9 for counting. These are 10 unique number, Ten means deca .

B.    Answer the following questions in long.

Q.1    What do you mean by the terms bit, byte, and nibble?  

Ans:-    Bit:- The smallest unit of data in a computer. It can have a value of either 0 or 1.

Byte: A group of 8 bits. It is used to represent one character like A or 5.

Nibble: A group of 4 bits. It is half of a byte.

Q.2        What is the use of character encoding system?

Ans:-    A character encoding system is used to convert text characters like letters, numbers, and symbols into a format that computers can understand, which is binary code. It helps computers store and display text.

Q.3    Name 3 character-encoding systems and describe Universal character set code system briefly.  

Ans:-    Three character-encoding systems are:  

1. ASCII - American Standard Code for Information Interchange  

2. ISCII - Indian Script Code for Information Interchange  

3. Unicode- Universal Character Set  

Universal Character Set (Unicode): Unicode is a universal encoding system that can represent characters from almost all languages in the world. It assigns a unique number to every character, so computers can display text in any language.

Q.4    What do you mean by the bases of number system?

Ans:-     The base of a number system means the total number of digits or symbols used to represent numbers in that system. It is also called radix.

Binary has base 2 → uses 0, 1  

Decimal has base 10 → uses 0 to 9  

Octal has base 8 → uses 0 to 7  

Hexadecimal has base 16 → uses 0 to 9 and A to F  

Q.5    Perform the following conversions ? 

Ans:-     (110101)2 - (53)10 - (65)8 - (35)16

                (23)8    -  (19)10 - (10011)2 -(13)16

                (253)10 - (11111101)2= (375)8 = (FD)16

               (20)16 = (32)10 = (00100000)2 = (40)8