| DECEMBER 2017 (555) | |
| I. | FILL IN THE BLANKS: |
| 1. | Graphical User Interface |
| 2. | Central processing unit (CPU) |
| 3. | Ctrl+A |
| 4. | MS Access |
| 5. | Cd |
| 6. | Calc |
| 7. | Power Point |
| 8. | Whatsapi |
| 9. | Consolidate |
| 10. | Wi-Fi |
| I. | MATCH THE FOLLOWING: |
| 1. | h |
| 2. | d |
| 3. | e |
| 4. | f |
| 5. | C |
| 6. | j |
| 7. | a |
| 8. | i |
| 9. | b |
| 10. | g |
| III. | CHOOSE THE BEST ANSWER: |
| 1. | c |
| 2. | b |
| 3. | b |
| 4. | d |
| 5. | b |
| 6. | d |
| 7. | b |
| 8. | d |
| 9. | c |
| 10. | a |
| IV. | SAY TRUE OR FALSE: |
| 1. | True |
| 2. | True |
| 3. | False |
| 4. | False |
| 5. | True |
| 6. | True |
| 7. | False |
| 8. | False |
| 9. | True |
| 10. | False |
| V. | WRITE SHORT ANSWERS FOR THE FOLLOWING: |
| 1. | A real-time operating system (RTOS) is an operating system that guarantees a certain capability within a specified time constraint. |
| 2. | DVDs can store about 4.7 GB of data. Blu-ray- Single layer Blu-ray discs store approximately 25 GB of data. |
| 3. | Click Start Button. Right click on Computer. Click Properties. Now we can view the Computer configuration. |
| 4. | Threads are used for small tasks, whereasprocesses are used for more 'heavyweight' tasks – basically the execution of applications. Anotherdifference between a thread and a process is that threads within the same process share the same address space, whereas different processes do not. |
| 5. | It is a costly package. Less flexibility and customisation. |
| 6. | If we publish a book having 500 pages, for example, we need not type the Book Name at the top and author name in the bottom in all the pages manually |
| 7. | Cells are referred using the Column name and Row number. For example, A column and 10th row cell is called A10. |
| 8. | Open Office Impress is equivalent to MS-Power Point used to create slides. Impress file extention is .odp. |
| 9. | Database is useful to store the collected information in an organised method. |
| 10. | Now() function, Month functiion. |
| 11. | A set of related web pages located under a single domain name is called a Website. And URL stands for Unicode Resource Locator. |
| 12. | Tablets are kept at home, or brought out only on long trips.Smartphones, on the other hand, are taken everywhere and used constantly. |
| 13. | A PowerPoint template is a pattern or blueprint of a slide or group of slides that you save as a .potx file. Templates can contain layouts, theme colors, theme fonts, theme effects |
| 14. | Easy to design a report. Data presentation like Counts, Subtotals, etc is easy. |
| 15. | Serial Port, Parallel Port, PS/2 Port, USB Port, VGA Port, Power Connector, Firewire Port, Modem Port, Ethernet Port, Game Port, Digital Video Interface, DVI port, Sockets |
| VI. | WRITE ANSWERS IN DETAIL: |
| 1a. |
A computer can store and process data, pictures, sound and graphics. They can solve highly complicated problems quickly and accurately. A computer is an electronic machine that processes information—in other words, an information processor: it takes in raw information (or data) at one end, stores it until it's ready to work on it, chews and crunches it for a bit, then spits out the results at the other end. All these processes have a name. Taking in information is called input, storing information is better known as memory (or storage), chewing information is also known as processing, and spitting out results is called output. Input: Your keyboard and mouse, for example, are just input units—ways of getting information into your computer that it can process. If you use a microphone and voice recognition software, that's another form of input. Memory/storage: Your computer probably stores all your documents and files on a hard drive: a huge magnetic memory. But smaller, computer-based devices like digital cameras and cellphones use other kinds of storage such as flash memory cards. Processing: Your computer's processor (sometimes known as the central processing unit) is a microchip buried deep inside. It works amazingly hard and gets incredibly hot in the process. That's why your computer has a little fan blowing away—to stop its brain from overheating! Output: Your computer probably has an LCD screen capable of displaying high-resolution (very detailed) graphics, and probably also stereo loudspeakers. You may have an inkjet printer on your desk too to make a more permanent form of output. INSERT A BLOCK DIAGRAM HERE |
| 1b. |
Data communications (DC) is the process of using computing and communication technologies to transfer data from one place to another, and vice versa. It enables the movement of electronic or digital data between two or more nodes, regardless of geographical location, technological medium or data contents.
There are several different types of computer networks. Computer networks can be characterized by their size as well as their purpose. The size of a network can be expressed by the geographic area they occupy and the number of computers that are part of the network. Some of the different networks based on size are: ~ Personal area network, or PAN ~ Local area network, or LAN ~ Metropolitan area network, or MAN ~ Wide area network, or WAN Some of the different networks based on their main purpose are: ~ Storage area network, or SAN ~ Enterprise private network, or EPN ~ Virtual private network, or VPN |
| 2a. |
WINDOWS FEATURES 1. Desktop 2. Task Bar 3. System Tray 4. Quick Launch 5. Icon 6. Start button 7. Start up Menu 8. Title Bar 9. Ribbon 10. Menu Bar 11. Standard Tool Bar 12. Formatting Tool Bar 13. Close Button 14. Minimise Button 15. imise Button 16. Restore Button 17. Ruler 18. Srcoll Bars 19. Status Bar 20. Mouse Pointer 21. Cursor 22. Run Box (WinKey+R) 23. 23. Help and Support 24. Control Panel 25. Windows Media Player 26. Clock 27. Devices and Printers 28. Computer 29. Pictures 30. Music WINDOWS TOOLS 1. Paint 2. Word Pad 3. Note Pad 4. Calculator 5. Desktop Background 6. Screen Saver 7. Search |
| 2b. |
Linux Operating System has primarily three components Kernel − Kernel is the core part of Linux. It is responsible for all major activities of this operating system. It consists of various modules and it interacts directly with the underlying hardware. Kernel provides the required abstraction to hide low level hardware details to system or application programs. System Library − System libraries are special functions or programs using which application programs or system utilities accesses Kernel's features. These libraries implement most of the functionalities of the operating system and do not requires kernel module's code access rights. System Utility − System Utility programs are responsible to do specialized, individual level tasks. Following are some of the important features of Linux Operating System. Portable − Portability means software can works on different types of hardware in same way. Linux kernel and application programs supports their installation on any kind of hardware platform. Open Source − Linux source code is freely available and it is community based development project. Multiple teams work in collaboration to enhance the capability of Linux operating system and it is continuously evolving. Multi-User − Linux is a multiuser system means multiple users can access system resources like memory/ ram/ application programs at same time. Multiprogramming − Linux is a multiprogramming system means multiple applications can run at same time. Hierarchical File System − Linux provides a standard file structure in which system files/ user files are arranged. Shell − Linux provides a special interpreter program which can be used to execute commands of the operating system. It can be used to do various types of operations, call application programs. etc. Security − Linux provides user security using authentication features like password protection/ controlled access to specific files/ encryption of data. |
| 3a. |
MS Office and Open Office are popular software that users prefer. Though both of the software offers the same functionality to the users, they have many differences between them.
1. MS Office is used more than Open Office. 2. Unlike Open Office, MS Office is not free. 3. Open Office comes only in a single version. On the other hand, MS Office has many versions, such as, Professional, Home and Student. 4. Open Office offers support for all MS Office document formats. However, only new MS Office supports Open Office documents. 5. Older MS Office versions, like MS Office 2003, had a menu-based system which was similar to Open Office. Today, MS Office uses a ribbon-like interface. 6. Updates in Open Office are free whereas it is not like that with MS Office updates. 7. Open Office Impress is better then MS PowerPoint. |
| 3b. |
Using the Wizard to create a form: We will use the Wizard to create forms: Step 1: Select fields. Under Tables or queries, select Vacations as the table. Available fields lists the fields for the Vacations table. Click the right double arrow to move all of these fields to the Fields in the form list. Click Next. Step 2: Set up a subform. Since we have already created a relationship between the Fuel and Vacations tables, we will use that relationship. If no relationship had been defined, this would be done in step 4. Click the box labeled Add Subform. Click the radio button labeled Subform based upon existing relation. Fuel is listed as a relation we want to add. So, click Fuel to highlight it as in Figure 22. Click Next. Step 3: Add subform fields. This step is exactly the same as step 1. The only difference is that not all of the fields will be used in the subform. Select Fuel under Tables or queries. Use the >> button to move all the fields to the right. Click the FuelID field to highlight it. Use the < button to move the FuelID to the left (Figure 23). Click Next. Step 4: Get joined fields. This step is for tables or queries for which no relationship has been defined. Since we want to list all expenses by the day they occur in both the form and subform, we will join the Date fields of these two tables Select Date from the First joined subform field dropdown list. This is the Date field in the Fuel table. This is not the Primary key for the Fuel table, but it is known as a Foreign key. Select Date from the First joined main form field dropdown list. This is the Date field in the Vacations table. This is the Primary key for the Vacations table. Click Next.. Step 5: Arrange controls. Arrangement of the main form: Click Columnar - Labels on top. (The labels will be placed above their field. Arrangement of the subform: Click As Data Sheet. (The labels are column headings and the field entries are in spreadsheet format.) Click Next. Step 6: Set data entry. Unless you have a need for any of these entries to be checked, accept the default settings. Click Next. Step 7: Apply styles. Select the color you want in the Apply Styles list. (I chose the beige which is Orange 4 in the Color table.) Select the Field border you want. (I prefer the 3-D look. You might want to experiment with the different possible settings.)) Click Next. 8: Set name. Enter the name for the form. In this case, it is Fuel. Click the circle in from of Modify the form. (This circle is called a radio button.) Click Next. The form opens in Edit mode. |
| 4a. |
In Word, you can create a TOC based on a portion of the text in a paragraph without including the whole paragraph. You can mark text by using the Lead-in Emphasis feature with heading styles to include the text in a TOC.
To insert a table of contents, follow these steps: Start Word, and then open your document. Click an empty paragraph where you want to insert the TOC. click Table of Contents in the Table of Contents group on the References tab. Then, click Insert Table of Contents. Select the options that you want to apply to the TOC in the Table of Contents dialog box, and then click OK. Note If the text that is contained in your document is not marked to be included in a TOC, you receive the following error message in your document instead of the TOC: Error! No table of contents entries found. |
| 4b. |
Excel offers the following major chart types − Column Chart Line Chart Pie Chart Doughnut Chart Bar Chart Area Chart XY (Scatter) Chart Bubble Chart Stock Chart Surface Chart Radar Chart Combo Chart |
| 5a. |
~
Open the Navigation pane. ~ Click the table or query on which you want to base your report. ~ Activate the Create tab. ~ Click the Report button in the Reports group. Access creates your report and displays your report in Layout view. You can modify the report. To create a simple one-table query: ~ Select the Create tab on the Ribbon, and locate the Queries group. br> ~ Click the Query Design command. ~ Access will switch to Query Design view. ... ~~ Click Add, then click Close. ~ The selected table will appear as a small window in the Object Relationship pane. |
| 5b. |
~
Open Microsoft PowerPoint. ~ Go to File at the top of the screen and click New. ... ~ In the “New Presentation” dialog box, click on “From Design Template.” ... ~ Slide Design. ... ~ Slide Layout. ... ~ Adding Text. ... ~ Adding Pictures. ... ~ Resizing Pictures. |
| 6a |
A web browser is a program on your computer that allows you to access websites on the internet.
The web is written in a computer language called HTML (HyperText Markup Language). Browsers translate this so that we can read it easily.
There are many browsers available. If you're using a Windows PC, your machine probably came with the browser Internet Explorer. If you are using an Apple Mac, you'll have been supplied with Safari. No matter which browser you're using, you'll find that they all do more or less the same job. Here are the most popular browsers: ~ Internet Explorer (Microsoft) ~ Safari (Apple) ~ Firefox (Mozilla) ~ Chrome (Google) |
| 6b |
Steps to Create an Email ID: ~ Visit a website that offers an email service.Go to mail.yahoo.com. ~ Find where to sign in. ... ~ To create your Yahoo! mail account. ... ~ Click in "Get started" button and your new Yahoo! email is now available for use. ~ Go to mail.yahoo.com and sign in. ~ Enter your correct email ID and password and then Click to "SIGN IN" button. Step: Turn on the computer and log onto the internet. Step: Type in the web address of your email host in the address bar and log onto your email account. Step: Click on "Compose" to write a new email. Step: Click on the icon to attach a file. This icon appears as a paperclip symbol in most email programs. After you click on the icon to attach a file a box will pop up onto your screen. Step: Browse the information on your computer my clicking on the folder that contains the file that you would like to attach. When you find the needed file, click on it and then click on "open." This will start the process of attaching the file to your outgoing email message. Step: Read the directions on your computer screen. It will most likely say that the file was attached successfully. Step: Write the text of your email, insert your recipient's email address and then click on "send." |