FSSAI Computer Notes PDF: Food Safety and Standards Authority of India (FSSAI) will soon release the admit card for various Posts including Central Food Safety Officer, Technical Officer, Assistant, Junior Assistant, Assistant Director (Technical) and Other Posts. All those candidates who applied for the posts will be able to download the admit card, once it is uploaded on the official website.The exact Date and Time for FSSAI Exam 2019 will be available on the admit card. Admit Cards for the CBT will be issued from 22 June 2019. Earlier FSSAI announced exam dates on 14 June 2019 for various posts. The exam dates are- 24, 25 & 26 July 2019. For cracking FSSAI 2019 Exam, you need to build a smart preparation strategy which must include the task of practicing FSSAI Previous Year Papers as it will help in improving your speed and accuracy. So, to enhance your chances of clearing FSSAI 2019 Exam, we are sharing Computers Theory Notes in this post. You can download the PDF File from the link given below.
FSSAI Computer Notes PDF: Complete Theory Notes for FSSAI Exam
Basics of Computers
A Computer is a general purpose device that can be programmed to carry out a set of arithmetic or logical operations automatically. Since a sequence of operations can be readily changed, the computer can solve more than one kind of problem.
- A general purpose computer has four main components: the arithmetic logic unit (ALU), the control unit, the memory, and the input and output devices (collectively termed I/O).
- The data that is fed into a computer processor received into the computer by a keyboard or other sources is called Input.
- A computer is an electronic device that accepts data from the user (input), processes the data by performing calculations and operations on it and generates the desired Output.
- The device which is used with a computer to display or store data is called Peripherals.
- The mechanical, magnetic, electronic and electrical components that comprises a computer system such as the Central Processing Unit (CPU), monitor, keyboard, etc. is known as Hardware.
- A set of instructions that tells the computer about the tasks to be performed and how these tasks are to performed, is known as Software.
- An unprocessed collection or representation of raw facts represented in a manner suitable for communication, interpretation or processing by humans or by automatic means, is known as Data.
- The result of processing, manipulating and organising data in a way that adds to the knowledge of the person receiving it, is known as Information.
- The smallest unit of information, a computer can understand and process, is known as Bit.
- The primary goal of computer is to process information that it receives and output the results. The process of control and alter information is known as Processing.
- The number system computer used to store data and perform calculation – Binary Number System.
- Computer Speed, Accuracy, Diligence, Storage Capability, Automation, Remembrance Power and Versatility are the main Characteristics of Computer.
- Self Intelligence, Decision-Making power, Learning power, Self care, Feelings are the Limitations of Computer.
- A mainframe computer is a much larger computer that typically fills a room and may cost many hundreds or thousands of times as much as a personal computer. They are designed to perform large numbers of calculations for governments and large enterprises.
- Read-only memory (ROM) is a storage medium used in computers and other electronic devices. Data stored in ROM can only be modified slowly or with difficulty, or not at all.
- ROM is non-volatile and the contents are retained even after the power is switched off.
- It only allows reading.
- The types of ROM include PROM, EPROM and EEPROM.
- Random Access Memory (RAM), allows the computer to store data for immediate for immediate manipulation and to keep track of what is currently being processed.
- RAM is referred to as volatile memory and is lost when the power is turned off.
It allows reading and writing.
- The two main types of RAM are static RAM and dynamic RAM.
- SRAM retains data as long as power is provided to the memory chip and need not be refreshed periodically. SRAM stands for Static Random Access Memory.
- The data on DRAM continues to move in and out of the memory as long as power is available and must be continually refreshed to maintain the data. DRAM stands for Dynamic Random Access Memory.
- Primary memory is computer memory that a processor or computer accesses first or directly.
- For example: RAM, and Cache Memory.
- Secondary memory (or secondary storage) is the slowest and cheapest form of memory. It cannot be processed directly by the CPU.
- Secondary memory devices include magnetic disks like hard drives and floppy disks, optical disks such as CDs and CDROMs, and magnetic tapes, which were the first forms of secondary memory.
- Virtual memory is memory on the hard disk that the CPU uses as an extended RAM.
- Installation is the process of copying software programs from secondary storage media to the hard disk.
- A central computer that holds collections of data and programs for many PCs, workstations and other computers is a Server.
MS Office: Microsoft Office or Microsoft Office System is a collection of computer programs made by Microsoft.
The programs are created for all users. There are different versions of the software for home users and for business users.
- It was first announced by Bill Gates of Microsoft on August 1, 1988 at COMDEX in Las Vegas.
- MS office primarily includes Word, Excel, PowerPoint, Access and Outlook. It also includes OneNote, Groove, InfoPath and Publisher.
- Microsoft Word is a word processor developed by Microsoft.
- It is used for creating, editing, formatting, storing, retrieving and printing of a text document.
- Microsoft Word’s native file formats are denoted either by a .doc or .docx file extension.
Some Important Tools in Microsoft Word –
Header and Footer option is used to display information such as title and page number of the document.
Title Bar -The bar at the top of the window that bears the name of the window.
Menu Bar – A screen element of MS Word that is usually located below the title bar that provides categorisedoption.
Thesaurus – is used for finding a synonym for a word in the document.
Style – Changes the style of the selected text
Font – Changes the font for the selected text
Font Size – Changes the point size of the selected text
Bold – Makes the selected text bold
Italic – Makes the selected text italic
Underline – Underlines the selected text
Align Left,Align Right,Center – Aligns the selected text/paragraph
Justify – Justifies the selected text/paragraph
New – Creates a new, blank document
Open – Displays the Open dialog box so that you can retrieve an existing document
Save,Print,Print Preview – Saves the active document to a specified location,Prints active document Displays what the document will look like when you print it
Spell Checker – Checks active document for spelling and grammatical errors
Cut,Copy,Paste – Cuts the selected text and places it on the clipboard then Copies Select text and Pastes the contents of the clipboard to a new location
Undo – Undoes the last document change
Redo – Redoes the last action that was undone
Insert Hyperlink – Creates a hyperlink from the selected text.
- Microsoft Excel is a software program developed by Microsoft Corp. that allow users to organize, format and calculate data with formulas using a spreadsheet system. The exact number of rows and columns are 1,048,576 rows and 16,384 columns.
- It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Some Important Terms used in Excel:
Cell – A cell is the intersection of a row and a column. A cell can contain a label, a numeric value, or a formula.
Cell address – A cell address is the location of a cell on a worksheet and is defined by the column letter and the row number.
Active Cell – cell in which we are currently working.
Formula bar – The formula bar is located under the toolbars at the top of the working screen. It contains the edit line for working with formulas, and provides information regarding cell addresses.
Functions – A function is a preset formula. Functions consist of the function name and its arguments. The function name tells Excel what calculation you want it to perform.
PivotTable Wizard – The PivotTable Wizard is a series of dialog boxes that guides you step-by-step through the process of creating a PivotTable.
Print Preview Controls – Print Preview mode offers a set of control buttons to make the feature more useful. Click Close to exit Print Preview mode.
Spreadsheet – Spreadsheet is the generic term for applications, such as Excel, that you can use to enter, analyze, and calculate data. It performs mathematical calculations and projections based on data entered. Common spreadsheet uses include analysis, charting, and budgeting.
Syntax – The syntax of the function refers to the order of the functions arguments. In some functions, the order of the arguments determines how Excel solves the function.
Worksheet – A worksheet is an electronic spreadsheet that lets you enter, analyze, and calculate data. Within a workbook, worksheets can share information, and calculations pertaining to several worksheets can be performed at one time. The default number of worksheets in a new workbook is three.
- The application software that can create professional looking visual aids is called Presentation Graphics Software.
- MS-PowerPoint can be started by clicking at Start—Program—Microsoft PowerPoint.
- A slide can contain one or more of these components: Titles, Graphs, Drawing objects, ClipArt and Pictures.
- The slide components that are used for reference are: Handouts, Notes, Outlines.
A new presentation can be created through one of these methods:
- Auto content Wizard (ii) Design Templates (iii) Sample Presentation and (iv) Blank Presentation
Some important terms used in Power Point :
Animations – Animations are effects that allow you to reveal the points on a slide one by one.
AutoClipArt – Use the AutoClipArt command to begin a concept keyword search of your slideshow. PowerPoint searches your slideshow for keywords that relate to the keywords associated with clip art images in the Clip Gallery.
Background – The Background dialog box provides various options that let you change the background look of a single slide or every slide in the presentation.
Presentation – A presentation is a collection of slides, handouts, speaker’s notes, and an outline, all combined into a file that can be printed onto transparencies or projected from a computer.
Slides – Slides are the individual pages of your presentation. Slides can be designed with different titles, graphics, text, and much more.
Slide Sorter Toolbar – The Slide Sorter toolbar is available only in Slide Sorter view, and allows quick access to special PowerPoint effects such as transitions, builds, rehearse timing, and hide slides.
Slide Sorter View – Slide Sorter View displays a reduced image of all the slides in a grid-like fashion. This view makes it easier to rearrange the slides in a presentation and add transitions and special effects.
Slide View – Slide View allows you to work on one slide at a time. While in Slide View, you can add any element to a slide, including text, graphics, shapes, and graphs.
Short cut keys for documents
F2 = Edit the selected cell
F5 = Go to a specific cell
F7 = Spell check selected text and/or document
F11 = Create chart
Ctrl + Shift + ; = Enter the current time
Ctrl + ; = Enter the current date
Shift + F3 = Open the Excel formula window
Shift + F5 =Bring up search box.
Ctrl + A = Select all contents of the worksheet
Ctrl + B = Bold highlighted selection
Ctrl + I =Italic highlighted selection
Ctrl + U = Underline highlighted selection
Ctrl + P =Bring up the print dialog box to begin printing
Ctrl + Z = Undo last action
Ctrl + F9 = Minimize current workbook
Ctrl + F10 =Maximize currently selected workbook
Ctrl + F6 = Switch between open workbooks/window
Ctrl + Page Up = Move between Excel worksheet in the same Excel document.
Ctrl + Page Down = Move between Excel worksheets in the same Excel document
Ctrl + Tab -=Move between two or more open Excel files
Alt + = = Create a formula to sum all of the above cells
Ctrl + ’ = Insert the value of the above cell into cell currently selected.
Ctrl + Arrow key = Move to next section to text
Ctrl + Space = Select entire column
Shift + Space = Select entire row
Common shortcut keys
Ctrl + Shift + Space-bar = Create a non-breaking space
Ctrl + B = Make letters bold
Ctrl + I = Make letters italic
Ctrl + U = Make letters underline
Ctrl + Shift+ < =Decrease font size one value
Ctrl + Shift + > =Increase the font size one value
Ctrl + ] = Increase the font size by 1 point
Ctrl + [ = Decrease the font size by 1 point
Ctrl + Space-bar = Remove paragraph or character formatting.
Ctrl + C =Copy the selected text or object
Ctrl + X =Cut the selected text or object
Ctrl + V =Paste text or an object
Ctrl + Alt + V = Paste special
Ctrl + Shift + V =Paste formatting only
Ctrl + Z =Undo the last action
Ctrl + Y =Redo the last action Control + function keys
Ctrl+F2 = Choose the print preview command (Microsoft office Button) Ctrl+F3 = Cut on the spike
Ctrl+F4 = Close the window Ctrl+F6 =Go to the next window Ctrl+F9 = Insert an empty field
Ctrl+F10 = Maximize the document window Ctrl+F11 = Lock a field
Ctrl+F12 = Choose the Open command (Microsoft Office Button) Function keys
Ctrl+F2 = Choose the print preview command (Microsoft office Button) Ctrl+F3 = Cut on the spike
Ctrl+F4 = Close the window Ctrl+F6 = Go to the next window Ctrl+F9 = Insert an empty field
Ctrl+F10 =Maximize the document window Ctrl+F11 = Lock a field
Ctrl+F12 = Choose the Open command (Microsoft Office Button) Ctrl+F2 = Choose the print preview command (Microsoft office Button) Ctrl+F3 = Cut on the spike
Ctrl+F4 = Close the window