IT Spark Class- 6 Flipbook

2. The Format Axis pane appears on the right of the worksheet. 3. There are two categories: Axis Options and Text Options. By default, Axis Options is selected. In the Axis Options category, click on Axis Options sub-category. 4. In Maximum text box, replace the value by ‘2000000’. 5. Close the pane. See the changes in the Y-axis values in the chart. 2 5 3 4 1 Inserting Picture Pictures or images can be inserted in the worksheet. Like MS Word, you can’t copy and paste an image in the worksheet from other source. The steps to insert an image 2 in the worksheet are: 1 1. Select any cell. For example, A1. 2. On Insert tab, in Illustrations group, click on Pictures tool. The Insert Picture dialog box appears. 101

3. Locate the required image and select it. 3 4 4. Click on Insert button. The selected image is inserted in the worksheet. Note 1. The image can be resized and relocated. 2. When the image is selected, a new tab named ‘Format' appears on the Ribbon, which can be used to format the image. Do it Yourself Open a worksheet in Excel and insert any image of your choice. Using Goal Seek Goal Seek is a tool to get the desired result in a cell by changing a value in another cell. The steps to use Goal Seek are: 1. Create a worksheet and enter data (see the figure for reference). Calculate total in the cell B7. 2. On Data tab, in Data Tools group, click on What-If-Analysis. 2 4 3 5 6 7 1 3. Select Goal Seek in the menu. The Goal Seek dialog box appears. 4. In Set cell text box, define the cell address for which the goal seek is to be applied. Here, refer the cell that contains the formula. For example, B7. 102

5. In To value text box, type the new value (desired 8 result). 8 6. Now, click on the cell, whose value you want to change to get the desired result. For example, B3. The address will appear in By changing cell text box. 7. Click on OK button. The Goal Seek Status dialog box appears displaying the Target value 4275000 and Current value 42,75,000. 8. Click on OK button. See the changes in cell B7 and B3. Do it Yourself In the given data set, in cell B7, average marks are calculated. Use Goal Seek to set the value ‘70’ in the cell B7, by changing marks in cell B6. Glossary Chart : A chart is a pictorial representation of the data. Goal Seek : Goal Seek is a tool to get the desired result in a cell by changing a value in another cell. Quick Review  Some of the types of chart in Excel are Column chart, Line chart, Pie chart, Bar chart, Area chart, XY(Scatter) chart, etc.  The various components of a chart are chart area, X-axis, Y-axis, Axis titles, plot area, data series, legend and chart title.  Chart can be formatted to change its appearance.  Pictures or images can be inserted in the worksheet. 103

A. Choose the correct answer. 1. An _____________ is used to show the correlations between two sets of values. a) Diagram b) Chart c) Image d) Axis 2. The _________________ is the entire chart and all its elements. a) Column chart b) Chart area c) Pie chart d) Bar chart 3. Which of the following is a part of a chart? a) Data series b) Legend c) Chart title d) All of these 4. To resize a chart, put the mouse cursor on the corner of the chart and drag it ______________ . a) Vertically b) Horizontally c) Diagonally d) All of these B. Fill in the blanks. F11, Goal Seek, Bar chart, File, Chart 1. A _________________ displays a series of numeric data in a graphical format. 2. A ___________________________ displays the data in the form of horizontal bars. 3. To take the printout of a chart, select the chart and click on ____________ → Print. 4. _____________________ is a way to get the desired result in a cell. 5. ______________________ shortcut key is used to create a chart on seperate worksheet in a workbook. C. Tick () the correct statement and cross () out the wrong one. 1. In a line chart, data is plotted in a form of line. 2. In a Pie chart, data is displayed in the form of squares. 3. X-axis of a chart is also known as category axis. 4. When we select a chart on a worksheet, chart and style tabs appear on the Ribbon. 104

D. Answer the following questions. 1. What is a chart in MS Excel? ________________________________________________________________________ ________________________________________________________________________ 2. Write the steps to move a chart on the worksheet. ________________________________________________________________________ ________________________________________________________________________ ________________________________________________________________________ 3. Write the steps to change chart style in a worksheet. ________________________________________________________________________ ________________________________________________________________________ ________________________________________________________________________ ________________________________________________________________________ 4. Write the steps to create a chart on a worksheet. ________________________________________________________________________ ________________________________________________________________________ ________________________________________________________________________ 1. Create a worksheet store percentage marks of 10 students. Then create a 3D Column chart on the data. Format the chart to give it a different look. 2. Change the chart type to Line chart. 3. Create a worksheet to show the marks of 5 students in Computer subject. Then create a Pie chart showing their percentage performance. Teacher's Signature : __________________ Teacher's Remark : WEB http://www.gcflearnfree.org/excel2013/22.2 http://www.timeatlas.com/excel-goal-seek/ LINKS Teacher’s Corner Teachers are advised to emphasise on the significance of charts as to how they facilitate in analysing the data and making decisions. 105

Supplement Google Sheets Google Sheets is a free tool to create and work with spreadsheets online for free. Here is a quick introduction to Goggle Sheets. To work with the Sheets, you need to have a Google account as a Gmail ID. Google Sheets Interface Like any standard spreadsheet program, every Google Sheet is a set of rows and columns. There is a menu bar and a common toolbar with common tools available on it. Anyone who has worked earlier on electronic spreadsheets can easily work with Google Sheets instantly. Creating a sheet Go to your Google drive and click on New > Google Sheets > Blank spreadsheet.The data entered is saved automatically. All basic editing and formatting operations are just like any standard worksheet program like MS-Excel. Sorting and Filtering: These actions can be performed by opening Data menu. Sort Range… option allows sorting data in a selected range of cells. You can specify one or more columns to sort the data alphabetically or in ascending or descending order. 106

Create new filter view… option allows creating various filters on the data range. Data can be filtered by values or on the basis of certain condition like values less than 3000. Sharing and Downloading Sheet These actions can be performed in the sheet using File menu. Sharing sheet: To share the sheet, enter the email IDs of the recipients and specify if they can edit, comment or only view the sheet. You can also get a sharable link and email it to intended recipients. Downloading sheet: Sheet can be downloaded to work offline using Download… option. It provides choices if different file formats to download in. Basic Arithmetic: The basic arithmetic and common formulas in Google Sheets are like any other standard worksheet program.  SUM: adds values in a cell range.  AVERAGE: finds the average of the values in a cell range.  MAX: finds the highest value among the values in a cell range.  MIN: finds the lowest value among the values in a cell range.  COUNT: counts the values in a cell range. Using More functions… options you can access the whole list of functions provided by Google Sheets. You will notice that most of them are similar to those in name and syntax as in other standard spreadsheet programs. Conditional Formatting: Open Format menu and select Conditional Formatting… option to apply formatting on the selected cells depending on the given condition. You can select the condition for formatting from a dropdown list in the Conditional Formatting… panel. Specify any values to be checked and then specify the cell formatting or select default formatting 107

9 Communication Using Internet Dear Teacher, Yes Students, How can we use e-mail Internet is mostly and messaging service used for on internet? communication. We want to learn Let’s learn about e- about them. mail and messaging service in detail. Introduction Internet is mostly used for communication. These days e-mail is at the top of the list amongst all the features used on the Internet. As we know that Internet is one of the best technologies which is widely used by everyone and it has brought the entire world very close. So, it has become very popular, easy, cost effective and sophisticated means of communication. Internet is a network of networks. It connects millions of computers of the world with each other. Internet helps us to access and share information on any topic. Information on Internet ranges from various types such as text files, music files, video clips, software, etc. The most important feature of the Internet is that it is easier for people to communicate with one another. Internet-Based Communication Tool Internet comprises of the different types of communication tools. Some examples of Internet-based communication tools are: • E-mail • Chatting or Instant Messaging • E-greetings • Groups • Blogs • E-Community • Video and Photo Sharing 108

E-mail (Electronic Mail) The most widely used Internet-based communication tool is an e-mail. The term e-mail refers to Electronic Mail. E-mail is a communication system that sends and receives messages through the internet by using specific e-mail addresses or e-mail IDs. It identifies the receiver with an address similar to the postal mailing system. [email protected] is an example of an e-mail address. E-mail system is managed by Mail Servers. There are so many mail servers available on the internet, such as Yahoo mail, Gmail, Hotmail, Rediffmail and so on. Through e-mail we can send any type of information such as text messages, music files, video files, images, etc. It stores the mails in the inbox and allows the user to read them at any time and any place or location. Advantages of e-mail E-mail offers many advantages over traditional mailing system. Some of the advantages are as follows: 1. Sending and receiving e-mail is very fast. It is received and delivered within seconds across the world. 2. E-mail is an affordable means of communication Note as compared to other systems. An e-mail account is required 3. Sending and receiving e-mail is very easy and to send or receive e-mails. convenient. Any type of files can be sent as an attachment through e-mail. To create an e-mail account 1. Open any browser.(Internet Explorer or Firefox or Chrome. 2. Type any e-mail service provider’s URL in the address bar. E.g. http://www.gmail.com. 3. Now click on Create account option. 3 Note An e-mail address has username and domain name separated by an ‘at-the-rate’ (@) sign. 109

4. A registration form will appear. Fill the registration form carefully and submit it. 5. A congratulation message will appear. Now go to your email account and login. 6. Your email account window appears (containing three mails from Gmail Team). Creating an email account on Gmail.com Sign in page of gmail.com Using an e-mail account After creating an e-mail account, you can use it to send and receive e-mails. To use the e-mail account, you must login or sign in using your e-mail id/user name and password. The login/sign in system of different e-mail accounts may differ, but they all offer some of the common features which are explained in following sections: Important Components of Gmail Window Inbox The Inbox consists of all received e-mails. Each e-mail has its message header which shows you who has sent the mail, subject line, time and date when the mail was sent. By clicking it, the contents will appear. Check your Inbox 110

Compose Mail The compose mail option enables us to create a new mail which we want to send to someone. The steps to create a new mail and send to someone, are: 1. Click on Compose button located on the left side pane. A Compose mail frame appears. 2. Type the e-mail address in the To box. 3. Type the subject name in the Subject box to send it with message. 1 4. Type your message in the 2 message box. 3 5. Click on the Attachment if 4 you wish to attach any file. 65 (The File Upload dialog box appears after clicking on Attachment option to select the attachments). 6. Click on Send button. Send a Mail with attachment Note If you don’t want to send the e-mail then you can save it and send it later. The saved e-mail is stored in the Drafts. To save the message and store it in drafts, click on Save Now button. This button is available near the Send button. Reply Mail Reply Mail is used to reply to the mail at the time when you receive and read it. Steps to reply the mail are: 1. Click on mail, which you want to reply. 2. Now, click on Reply 2 option. 3 3. A new frame appears 4 below the mail details, to type your reply . Reply to a mail 4. Click on Send button. Your message will be sent. 111

Forward Mail You can send a copy of the received mail to other people by forwarding it. Steps to forward the mail are: 1. Click on mail, which you want to forward. 2. Now, click on 2 arrow next to 3 the Reply option. A menu appears. 3. Select Forward option. 4. A new frame appears below the mail details, to forward the message. 5 5. Type the email address of the recipient in To 6 text box. Forwarding a mail Note: you can add the text in the message. 6. Click on Send button. Your message will be forwarded. Note You can send mail, reply to the mail, forward mail to multiple people at once. To do this, you just need to type multiple email IDs separated by a comma ‘ ,’. Delete Mail 2 You can delete one or more e-mail 1 messages at once by selecting the e-mail in the inbox. After selecting the e-mail by clicking on check box in the inbox, just click on Delete button. All the selected e- mails will be deleted. Delete a mail 112

Sign Out After using an e-mail account, you must logout it properly so that nobody else can access your mail. To close your mail account properly, you need to sign out or logout. Steps to sign out from the account are: 1. Click on the drop- 1 down arrow, next to the your email 2 account name (on 3 the top-right of the window). 2. A drop-down dialog box appears. 3. Click on Sign out button. Sign out from account Chatting or Instant Messaging Chatting or Instant Messaging is another online communication tool that is commonly used. It allows two or more people to send and receive messages at the same time. This facility comes along with the e-mail account. Yahoo, Gmail, Facebook, Skype provide this facility on different interfaces. The given images show the instant messaging tools. 1. Click on Search button to search and send the chatting request to someone, who is online. 2. Type the name or email address of the person and press Enter key. 3. If the person or email address is found, the name and profile image appear on the left pane. Click on the name of the person and begin chatting in the chat popup window. Note You can also do voice and video chatting from here. Text chatting 113

Advantages of instant messaging 1. Using instant messaging, user can send and receive messages and files quickly. 2. Instant messaging allows the user to even see and talk through webcams and microphones. Working with Gmail on Mobile Device Gmail is a free and one of the most popular email services on the Web by Google. Downloading Gmail App Gmail generally comes preinstalled on your Android phone. However, it can be downloaded by going to Goggle Play Store with simple search  Open your apps menu and go to Play Store (Android Marketplace) from your android phone. Search the latest version of Gmail.  Click Install and then open the Gmail app. Creating an Email Account on Mobile Gmail  Touch the menu on the top left Hamburger Menu Icon  At the top, touch the down arrow to the right of your existing username.  Touch Add account. and then touch Google option.  Follow the steps on the screen to add your account and choose the new Gmail username email with a password that you want to add in this phone. Composing and Sending Mail  In the Gmail app, at bottom right, tap Compose.  In the To field add recipients.  Add a subject.  Write your message.  At the top of the screen, tap Send. Attaching Files while Sending Mail 1. Tap Attach. 2. Tap Attach file or Insert from Drive. 3. Choose the file you want to attach. 114

Replying and Forwarding Mails There are 2 modes to respond to any email message - i. Reply: sends back reply to only the actual sender, ii. Reply all: replies to all the persons who have received the message as well as the sender. You can also forward the message to new recipients.  In your inbox, open the message.  On the right side of the message click on the dropdown and select the desired choice.  Type your response and send the mail as usual. Online Interaction Platforms Today we can get in touch online with others easily. Social web sites allow us to meet others online. Various ways of interaction are given here. Blog: It allows a person to post his/ her views on a particular topic or issue in the form of an online article. Readers can post their comments on the article. Blog is an excellent way to showcase your talents. A person who writes and maintains a blog is called blogger. Some popular blog sites are Wordpress, Blogadda, Blogger, Tumblr etc. Facebook Facebook is free and the most popular social website that allows people to register for free and interact with each other. You can send the friend requests to other people to become online friends. Some importanct features of Facebook are given here. Timeline/Wall: Your own profile page is called Timeline or Wall. What ever you post, goes to your wall. Other people can also post at your wall or comment on your posts. Pages: You can create pages on various topics and invite people to visit. Events: You can create events and send invites to people. 115



Glossary Internet : A network of networks. E-mail : Electronic Mail Chatting : Using this two or more people can exchange messages online in real time. Whatsapp : Free messaging and video chat mobile app. Quick Review  Communication over Internet is very popular now-a-days because it is very fast and easily accessible.  Internet is a network of networks that connect millions of computers of the world with each other.  Internet comprises many types of communication tools.  E-mail is the most widely used Internet-based communication tool.  To send e-mail to anyone you need an e-mail account.  E-mail is very fast, cheap and easy to use communication tool through Internet. A. Choose the correct answer. 1. ____________ helps us to access and share information on any topic. a) network b) LAN c) Internet d) All of these 2. The ___________ consists of all received e-mails in an e-mail account. a) Inbox b) Sent c) Trash d) Drafts 3. An e-mail address always contains _________ sign in it. a) # b) $ c) & d) @ 4. ____________ mail option is used to reply to the mail at the time of receiving it. a) Reply b) Forward c) Delete d) None of these 5. _______________ allows two or more people to send and recieve messages at the same time. a) E-mail b) Chatting c) E-Greatings d) Blogs 117

B. Tick () the correct statement and cross () out the wrong one. 1. E-mail is not widely used as communication tool. 2. We cannot forward the received mail. 3. The compose mail option enables us to create a new mail. 4. If we don't want to send an email then we can save it and send it later. 5. We can send an email message to many people at the same time. 6. Video and photo sharing is Internet based communication tool. 7. Internet is a network of computer networks. C. Fill in the blanks. E-mail A/c, Compose, Internet, Forward mail, Yahoo mail/Gmail 1. _______________ is a network of networks that connects millions of computers of the world each other. 2. _______________ option is used to send a copy of received mail to other people. 3. An ___________________ is used to send and receive mails. 4. ______________________ are the mail servers available on the internet. 5. ___________________ option enables us to create a new mail which we want to send to someone. D. Answer the following questions. 1. What is Internet? ________________________________________________________________________ ________________________________________________________________________ ________________________________________________________________________ ________________________________________________________________________ 2. What is an e-mail? What are its uses? ________________________________________________________________________ ________________________________________________________________________ ________________________________________________________________________ ________________________________________________________________________ 3. Name the types of communication tools available on internet. ________________________________________________________________________ ________________________________________________________________________ ________________________________________________________________________ ________________________________________________________________________ ________________________________________________________________________ 118

4. Write few words about ‘Chatting’ (on internet). ________________________________________________________________________ ________________________________________________________________________ ________________________________________________________________________ ________________________________________________________________________ A. Create an e-mail account in www.gmail.com. 1. Share your e-mail ID with your friends. 2. Ask your computer teacher’s e-mail id. 3. Ask your friends’ e-mail id. 4. Send e-mails to all of them one by one. 5. Read the mails received from them. 6. Reply to the received mails. 7. Forward the received e-mails to someone else. 8. Select e-mails which you want to delete. 9. Sign out properly to close the e-mail account. B. Compose a mail to greet all your friends on the eve of New Year/Diwali/Christmas. Attach a greeting card to the mail created using MS Paint. Teacher's Signature : __________________ Teacher's Remark : WEB http://digitalunite.com/guides/email/how-create-gmail-account http://fcit.usf.edu/internet/chap4/chap4.htm LINKS Teacher’s Corner Teachers must point out the pros and cons of Internet communication and how to use them responsibly and safely. 119

PROJ EC T MS PowerPoint Create a presentation of 5 slides, on MISSION CHANDRAYAAN - 2. Slide 1: Animated title slide Slide 2: Brief introduction to space missions of India Slide 3: About mission Chandrayaan -2 Slide 4: Challenges of the mission Slide 5: Interesting facts about mission Chandrayaan-2 Add relevant images and apply slide design, transitions, animations and some sound effects. On first slide give attribution to the images and content used from Internet. Scratch Create a simple game in Scratch by the title: GHOST HUNTER. Add a ghost sprite to your game and program it to appear and disappear repeatedly forever at 1 second’s interval on the stage. It should also appear randomly on the stage in different places. Take a jungle backgdrop from Backdrop library. When user is able to successfully click on the ghost, hide it and increase the score of the user by one. Set up a timer for a minute. When one minute’s time is over, display the score and stop the game. You can add sound effects creatively too. MS Excel A book store deals in different types of books (fiction, academic, non-fiction etc.). Book store offers discount on each type like 10% on fiction, 20% on academic etc. Create a worksheet to display the list of books sold in a week for each day. Along with the above book details, show their actual price and percentage discount allowed. Calculate discount and amount payable after discount. Also take grand total to show how much amount is collected. Also create a graph for each book type and total sales amount. 120