Click the ok button. the information system meeting all its originally intended design objectives? To use the total functions: Avg; Calculates the mean of all numeric data items in the field column. There are several ways of reducing piracy: Computer fraud is the use of computers to conceal information or cheat other people with the intention of gaining money or information. Click File menu option then the Open command. We have provided below free printable Class 2 Computer Worksheets for Download in PDF. 2 Computer Science Model Curriculum for Grade 8 . The information system administrator can therefore easily track who accessed the system, when and what they did on the system. click the down arrow on the right of Save as type list box and choose a file type. These are: Figure 1.21 shows a dialog box for change case. For example, if the aim is to depict the performance index of a student from Form I-to 3, a line chart would be most appropriate because it clearly shows the trend in performance. As you create more and more complex tables, you will find a need to use the field properties to specify finer details related to fields and the table entries expected. Point to programs/ all programs if you are using Windows XP. Click the Auto shapes button. .Basic salary PAYE Net salary. Click OK and notice how the text wraps around the object. Some of the worksheets for this concept are Module 1 handouts computer basics computers, Computer basics for kids, Computer basics lesson plan, Sponsored educational materials step by step introduction, Teaching material for 2 nd standard, Introduction to robotics lesson plan, Basic computer hardware and software levels . I replace the word have by has in the 4th sentence. I open Microsoft Word 2007.2. (i) Editing Modes: Word processors have two editing modes, insert and type over mode. From the Story Editor menu, choose Utilities then Spelling. Mix and match slides to customize for your students' grade, skill, and computer abilities. A file is a collection of related records. No Prep! Click the table from the table/ query list and then click Add.. Basic keyboard keys such as enter, Pointing at and naming the basic keys. The main benefit was that there was fast communication between researchers through electronic mail or e-mail. On the shortcut menu, click the Save target as command. The electronic spreadsheet utilizes the powerful aspects of the computer like speed, accuracy and efficiency to enable the user quickly accomplish tasks. A database is a collection of structured and related data items organised so as to provide a consistent and controlled access to the items. This can be illustrated using a simple statement like; Print Student Report until NumberofStudents = 40 (Not a real command anyway). Paragraph properties dialog box appears. NB: Alternatively, click insert then cells to display the dialog box select the entire row or entire column options to insert a row or column respectively. The hacker therefore violates the security measures put in place such as breaking through passwords or finding weak access points in software. Chart options command. Click Table, point Insert then click Row above or Row below. Starting Microsoft Word from the start menu. Highlight the data labels from the worksheet. (a) Match case Finds only text that has the same pattern of upper and lower case as the one specified in the Find What box. To restore text that has just been deleted in the current word processing session: click the Edit menu, then the Undo command. The word modem is short form for modulator demodulator. (b) The range of print in the Ranges box if you do not wish to print whole document. Report Header-This contains unbound controls that displays title of the report. For example, one common URL address is: The first part (http) stands for hypertext transfer protocol which is a protocol that transfers hypertext. A word processor is an application software that enables a person to create, save, edit, format and print text documents. Once you are through, click Story menu then Close Story. A computer virus is a destructive program that attaches itself to other files and installs itself without permission on the computer when the files are opened for use. About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new features NFL Sunday Ticket Press Copyright . In most cases, editing would include the process of correcting spelling mistakes, replacing words etc. To apply stroke or fill: Moving and resizing text and graphical objects. See Figure 3.6. Reading With Computers 1. I add the letter s at the end of the word parent in the 2nd sentence.6. Network access in case the computers are networked and connected to the external world. When performing tasks that require cell referencing, you can use formulae whose cell references keep on changing automatically depending on their position in the worksheet. Unlock to unlock a locked object. Click the text tool from the toolbox. Drag the line until the height of the row is as required then stop and release the mouse button. There are several merge options: Click the Merge to new document icon on the mail merge toolbar. However, many databases today combine object and relational concepts to come up with object relation models. Select or clear the Show AutoComplete tip for. Select the right one in the print dialog box and send the print job again. The Save As dialog box appears. This is possible by pointing to it then dragging using the mouse. or text label. Each chart must have a heading showing clearly what it represents. From the element menu either point to stroke to apply a line style or fill to fill the object with a background colour or pattern. Currently PageMaker versions 6.5 and 7.0 are the most common desktop publishing software developed by Adobe PageMaker. Click Tables menu, then Draw table or simply click the Draw table button from the standard toolbar. Browse computer lab activities for 2nd grade resources on Teachers Pay Teachers, a marketplace trusted by millions of teachers for original educational resources. From the style options, select the type of line thickness and style. Select Match Case and Whole Word as appropriate. The opposite happens when you click the left button on the horizontal scroll bar. Therefore, if the salespersons are held in a list, there would be need to calculate the amount due to each of them. On the Control palette, click the paragraph-view button. Min: Returns the minimum value from the field column. The pointer turns into an I-beam. Input mask automatically formats the field entry into a specified format. (c) Number of copies to print per page in the Number of copies box. The difference between column guides and margin guides is that margin guides are around the edges of the printable page while column guides may split the page at the center. This is called relative cell referencing. NB: To use the keyboard shortcut keys, press Ctrl + C to copy, then Ctrl + V to paste, NB: To use the keyboard shortcut keys, press Ctrl + X to cut, then Ctrl + V to paste. Some of the tools generate charts in addition to the output tables. This is not very common. 76% average accuracy. In the Use function box select the sum function then select the list for which subtotals will be inserted in the add subtotals box by checking the appropriate label. Click File then Close command. Indents and tabs are powerful tools for positioning text. A workbook may have several sheets. A hacker is a person who intentionally breaks codes and passwords to gain unauthorized entry to computer system data and information files. A break is used to identify where a section, a column or a page ends and the beginning of next. To turn on the spelling checker corrections, select the Replace text as you type check box, and then select the Automatically use suggestions from the spelling checker check box. jayeshrana. In Microsoft Access, a form is designed using graphical objects called controls. Select the paragraph or text you want to move to another column or page. I press the power button of the system unit. To remove superscript or subscript format: rop cap refers to text formatting where the first character in a line is bigger and drops down to occupy the space in the next lines as shown by the first letter D in this paragraph. cell AI. Kindergarten teachers and computer lab teachers are in love with the Kindergarten Computer Lab and Reading Center Computer Lesson Plans. Byte: Can only accept a number from 0-255. Find more similar flip PDFs like ICT Skills Grade 2. You can also use wildcards in the file name box for example, type *. Such a network is local in nature hence it is usually called a local area network (LAN). A spreadsheet enables neat arrangement of data into tabular structure. The automatic recalculation feature enables the use of What if analysis technique. Important fields are those that are used in sorting and querying the database. spelling and grammar checker, Thesaurus, Autocomplete and Autocorrect. After making the necessary selections, click OK to apply. From the programs sidekick menu, point to Adobe group then select PageMaker. You may already know that you can use a computer to type documents, send email, play games, and browse the Web. NB: If you download a file whose application is not currently installed on the computer, then you may not be able to view its contents. Most of such messages are fun pages, poems, e-cards etc. To design a good database which will require little time to maintain, consider the following: The type of data to be used in a database must be clearly defined for the purpose of manipulation and storage. From Element menu, choose Text Wrap to display the dialog box in, Click the middle wrap option as shown in Figure 4.27 (b). In a flat file model, a database holds only one set of data and is not any different from the manual files. Such sites are called websites and each has a special address called a uniform resource locator (URL) that can be used to access them. Learn the words and basic science topics. For example, on-line interviews may involve a person sending electronic mail composed of interview questions to a recipient who can read and answer back immediately. A computer is an electronic device that manipulates information, or data. This desktop publishers have superior image handling capabilities like setting resolution, brightness, contrast, cropping and filling images of all types with colour. A firewall is a device or software system t at filters the data and information exchanged between different networks by enforcing t e host networks access control policy. Notice that the cell moves one column to the left on the same row. Select the paragraph or paragraphs you want to indent. With convert feature in Microsoft Word, you can convert a table to lines of text and vice versa. It has evolved from a specialised communication network previously only used for military and academic purposes to a public network that is changing the way people carry out their daily activities. Choose the correct data type before adding the next field. The report will be displayed on the screen in print preview mode. Click the Insert menu then File attachment. Boredom and time wasting especially when searching for a Particular item. The picture toolbar has buttons that enable a person to format a picture to format a picture, click it to select it then use the commands on the picture toolbar. Communication in this case will be in the form of exchange of data and information. 2nd Grade - Computer and Technology - SchoolhouseTeachers.com. Specify the number of lines you want the character to occupy in the Size box as shown in Figure 4.15. This is the exchange of electronic letters, data and graphics on the Internet. (b) Workbook prints all the worksheets in the workbook. However, intercontinental transfer of data is achieved by having satellite base stations transmitting g the data through a wireless uplink channel to the satellite. From type menu, select paragraph to display the paragraph specifications dialog box. Many accountants find the spreadsheet a useful tool to use in recording daily transactions and keeping of financial records. Because most of these tools are complex, the user needs to have the statistical background knowledge before attempting to use the tools. Rows: Horizontal arrangement of cells. Pressing gives the same results. Type values for the indents in the Indent text box then press the Enter key. Headers and Footers from the View menu. click Next. In Microsoft Access it is called, From the field list of the underlying table, drag each field and place it in the field row. Inserting a clip art or a picture from clip gallery: The computer must be connected to a scanner to complete this procedure. To display the picture toolbar, click on View menu, point to toolbars then select Picture. if you want to display records with a field called City with items Nairobi or Embu, type Nairobi in criteria cell and Embu in the Or cell. Therefore, this method can be used for financial forecasting, budgeting, stock portfolio analysis, cost analysis, cash flow etc. In the Paragraph dialog box, click Spacing to display Spacing dialog box. Display the field list by clicking the Field list button or using the View. In this example, the list is first sorted by name. Addition Game. by designing their text and graphics layout and inserting, editing, formatting and printing of text and graphical objects using a special desktop publishing software installed on computers. 2, I must not insert any object in drives, USBport or jack socket.I do not touch electrical sockets and plugs.I tell my teacher if I have problems with the ?computer.I push my chair under the table before leavingthe computer lab.I do not run in the computer lab. The most important thing is to be able to identify each toolbar by its icons. These are user designed mathematical expressions that create a relationship between cells and return a value in a chosen cell. Some web sites allow free access to all their pages by all visitors. One of the best ways to enhance a publications visual impact is to wrap text around graphical objects. Therefore, formatting may include things like font sizing, bolding, changing text colour, adjusting picture brightness and contrast and formatting columns on the page. Calendars: Apart from showing dates, they are used by companies to advertise their products hence most of them have heavy catchy graphics. Press the end key. When you place text or a graphic, PageMaker establishes a link to the source file on the storage device (unless the file is an HTML document). Reinforce the weak access points like doors and windows with metallic grills and burglar alarms. The results of the calculations will be displayed in the dynaset as shown in Figure 3.21. denies access permissions to certain groups of users for certain files and computers. In the Polygon settings dialog box, specify the number of sides you want, from three to a hundred. Charts/graphs are graphics or pictures that represent values and their relationships. To see what other commands are, just point to the icon on the toolbar and a text tip will be displayed showing the function of the icon. In the Field Name column, click the cell to display a drop down list. From a series of dialog boxes displayed, specify the label size, font, and fields to be included in the label, whether to sort the labels, the name of the. Compare storage capacity of CD, DVD and Hard Disk. Database concepts . In a one -to many relationships, for a particular field in one table there are several matching records in another table. Default value . The system unit controls all the computer parts. Microsoft Word lets you import tables from other applications or an existing file. We have done our best to ensurethat children undergo a pleasant learning experience.We have taken care to align the textbooks with very clearly defined learning outcomes andobjectives set for the subject. Spreadsheet Program: MS-Excel. Notice that the mouse pointer changes from a cross to a double arrow. Document to find Microsoft Word files. These features include Tables/files, Queries, Reports generators, Form interface and a computer programming language within it. Remember that voice transmission on telephone lines is analog in nature while computers work with digital data. For example, if you download a file that was created in Microsoft Word then you can only open it in the same application. Weare also thankful to the artists who carried out the illustrations and to our graphic artists whohave tried their best to create the right layout for the books. The auto correct feature automatically detects wrongly spelled or capitalised words and replaces them with the correct word. The table you selected fields list is displayed. the date of admission. For example, the formula =SUM(SecondQuarterProfits) might be easier to identify than =SUM(AlO:C20). Such a descriptive name in a formula can make it readable and easier to understand its purpose. Governments, private enterprises and individuals have found the need to protect data and information that is in their custody against unauthorized access, disclosure or damage. Copy and Paste Practice. Scroll arrows are arrows at the end of the scroll bars that the user clicks instead of dragging the scroll button. From Format menu, click Columns to display the dialog box, In the columns dialog box, select the number of columns or type in the Number of columns text box, In the Width and spacing boxes, specify the column widths and space between columns, Click the File menu then Page setup. This server is usually given the name world wide web (www) and has all the information that others on the Internet access. Using the PageMaker tools and formatting effects, you can create very complex graphical objects. Dial-up connections, however, are quickly being replaced by dedicated digital data transmission telephone lines called dedicated digital leased lines. Select. These are rows of buttons or icons that represent commands. Undo: It reverses the last command that was issued in Order to revert back to the previous state. One major reason for use of a computerised database is the ability to search and retrieve specific information more efficiently. Notice that the whole column is highlighted. (Figure 4.4). Unlike the Copy command where a duplicate copy is created, the Move command transfers the contents of the original cell (s) to a new location. Imagine if a newspaper page was not divided into columns! Save my name, email, and website in this browser for the next time I comment. Hackers mainly use eavesdropping e.g. Create computer lesson plans for k-2. There are times when you wish to attract the readers attention by making the first character in a sentence large, taking more space in the next line. 2.1 Vocabulary Review; 2.2 Technology Vocabulary Typing; 2.3 Geek Speak Intro; . The aim was to allow sharing of data and information between computers. Is. In the database window, click the Reports tab then New. From Element menu, point to Stroke then select the line style you want to apply. To format text to superscript or subscript; 1 Select the text you want to style as superscript or subscript. Provision of data and information to authorized users. Custom For a number format not predefined in Microsoft Excel, select custom then define the pattern. On the Page tab, select the orientation of the page. Therefore in mail merge, the three files created are: 1 From the file menu, select New to create a new document. Sentence case: All the first characters in a sentence are in uppercase (Capitalised). Type the formula you want or select from the Paste function box. Each field should occupy its column. Examples of database management softwares include Microsoft Access (Ms Access), Oracle, FoxPro, Dbase/V, Lotus Approach etc. Columns: Vertical arrangement of cells. One of the functions of a database system is to organise data for easy access, retrieval and manipulation. 1 Select the text you want to change case. The Internet is a big forest of web pages and websites. Simply click the Center, button. These Worksheets for Grade 2 Computer cover all important topics which can come in your standard 2 tests and examinations.Free printable worksheets for CBSE Class 2 Computer, school and class assignments, and practice test . NB: You can also format a table by using the tables toolbar. Sixth Grade, Computer Science Projects, Lessons, Activities. The Microsoft Excel application window is made up of the following components: Title bar: It has the title of the application and control buttons for minimising, maximising and closing the application, The menu bar: It displays a list of menu options e.g. The document master applies to all pages in the publication until you specify otherwise, and cannot be renamed or removed from the publication. Lowercase: All characters appear in lowercase. 2 Click Utilities, point to Plug-ins and then select Running Headers and Footers. On the insert menu, point to picture then click clipart Click on the tabs to select on the category of objects i.e. Page setup dialog box appears. Computer science Learn select topics from computer science - algorithms (how we solve common problems in computer science and measure the efficiency of our solutions), cryptography (how . Access will ask you whether you want to create a Primary Key, click Yes. .feat_desc, .feat_cats, .feat_links { font: 13px/18px arial,san serif; } So have fun and explore the wide selection our site has to offer each of your students! From Table menu, point Delete, then Columns, Rows or Cells. However, only the select queries will be discussed in detail in this book, This is the most common type query used for searching and analysing data in one or more tables. F or example, if you enter a number such as 02000 I 00409874 and the input mask is set as 000-(00000)-000000, it is automatically displayed as 020-(00100)-409874. Each set of 12 weeks are all on the same topic, so students can take a deep dive into the content and the tech skills.Weeks 1-12: KitesWeeks 13 . Line spacing refers to the vertical distance between lines of text. Click the object to select it then position the pointer tool anywhere inside the text or object. For example, you can calculate the age of a person from the date of birth to the current data. Figure 4.1 shows how to start PageMaker in a typical Windows environment. And axis titles respectively. Press the up arrow key on the keyboard. From the Element menu, point to Frame and click Attach Content. 2 Click the down arrow of fill color button, the one that looks like a bucket pouring ink. You can start from any page number by using Start at box, Click Tables menu, position the pointer on Insert, then click Table. The selected range will have a border around it. If you want the tab leader, click the Leader button then choose the type of leader you want. Title case: All the first characters of each word in a sentence appear in uppercase. Integer and longer integer: Accept numbers with no decimals. At the receiving end, the data is changed from analog to digital for the computer to understand it through a process called demodulation. Now drag the I-beam over the text to be selected and release the mouse button at the end of the text you wish to work on. The engine searches its database for links to the information requested and displays a list of links from which the user can now access information by clicking them to open web pages. Concepts taught: Different ideas for all grades, Concepts taught: Understanding and Evaluation Sites, Concepts taught: Students will utilize the Internet to research figures of speech used in poetry and poetry terms, Concepts taught: Students will utilize the Internet, spreadsheets, and databases to solve problems relating to space, Concepts taught: spreadsheet & power point, Concepts taught: Integration of Software Programs, Dolch Sight Word Games - These have been compiled from all, Concepts taught: Basic Internet terminology and concepts, PowerPoint Project for Creating a New Business. However, the Rl Cl referencing style can be used. From the New query dialog box, choose either to create a query from in. Text, Number or Date. Shift and arrow keys. ascending, descending or no sort. To print e-mail, select the text to be printed then click the File Print command. Notice that the options in the font dialog box are commands on the formatting toolbar. In this case when text is inserted between words or characters it pushes the existing text away without replacing it. A word processor has a number of advantages over he type writer that include: Basic word processing features and concepts, (a) Most are designed to look like a piece of paper with a few. =Average(D lO:E 1 0) returns 25 as the average of the two values. (d) Ignore all to retain all the occurrences of the same word or phrase in the document from another language e.g. Click the Expand dialog button to bring the full dialog box into view then click the: Next button. Number Used for general display of numbers e.g. Also the status bar will now read enter which means that Microsoft Excel expects you to enter a value in the cell. What part of the computer is termed as the brain of the computer? You can set indents by moving the indent markers in the Indents/Tabs ruler, typing indent values in the Paragraph dialog box or type indent values on the Control palette in paragraph View. The Windows environment allows a person to place shortcuts to a programs executable (.exe) file in various places like the desktop. Microsoft Word presents the user with a number of ways for selecting a block of text. Toggle case: It changes upper cases to lowercases and vice versa. in, Click Find Next to continue with the search operation. I press 2 times The cursor is between the letters ______ and ______3. In Microsoft Excel, format the cells whether empty or not and their contents will acquire the set format automatically. Click the Edit menu then select Copy command. I put the first letter of the other words in capital. Click Setup to start the page setup dialog box. With a query, you can analyze all records fields using the inbuilt functions such as Sum, Average, Minimum and Maximum etc. Many emerging. Apart from the fact that academic materials for all levels of education are readily available on the Internet (web), the Internet has opened the door for those who would like to do distance education programs and home schooling. Uppercase: All characters appear in uppercase. Click the View menu, then. If the rulers are not displayed, click the View menu, then Show rulers to display them. By engaging with this subject, students learn to think, solve. Activity 1: I match each computer part with its correct name. Simply click the right alignment button. This is a careful study of an information system by experts in order to establish or find out all the weaknesses in the system that could lead to security threats and weak access points for crimesters. Microsoft Excel has both two-dimensional and 3-dimensional charts that can be used instead of the raw data in the table that has to- be studied for a long time to understand it. A graph is a pictorial representation of the base data on a worksheet. I make sure that my hands are clean before using the computer. At step 4 determine whether the chart will be inserted in the current worksheet or a new worksheet then click Finish button (Figure 2.27). Consider the following scenario: A company that has many salespersons. In case you wish to replace a word or phrase, use the Replace option. Find out more about our designer in the spotlight. For example, you can use the name .Tariffs to represent the import tax amount (such as 7.0 percent) applied to imports. I also offer a free technology teacher email course. Worksheet labels: These are usually of the format Sheet 1, Sheet 2 etc. 21, The desktop Desktop Icons Start Button Start Menu22, Sending a file to a pendrive1. The process of transferring information from a remote computer to a local storage is called downloading. Type a width in the dialog box that resembles Figure 2.17 then click Ok.button to apply. Have you ever asked yourself how newspaper and book publishing companies manage to produce publications that are attractive with creative layouts and graphics in large volumes? Save. Select the text or object with the pointer tool. This type of field is mostly used with graphical user interface applications for inserting graphical objects such as pictures, drawings charts etc. To select one page in a pair of facing pages, press Ctrl and click the page. This wizard creates a form for you automatically by asking you very minimal questions. Highlight the first character in the sentence, From the Format menu, click Drop Cap. Although there are several versions of Microsoft Word, the most common are Word 97, Word 2000, WordXP and Word 2003. 226, 3. Click OK to effect the changes. For example, you may create a validation text for the above validation rule I to display Enter a number between 0 and 100 whenever the user enters I a value outside this range. Misleading reports due to poor data entry and organisation. Choose new, from the resulting dialog box, click Blank Document Or select template by clicking any templates tab, From the file menu, click save or Save As or simply click the save Button on the Standard toolbar. Examples of some simple statistical functions include the following: For example a set of values may be composed of: The average of the set is 35 and its median is also 35. To insert headers and footers: A table is a feature in Microsoft Word made up of rows and columns that is used to organise and enhance display of information. To align left. In this case, both the column and row references are absolute. It will become hard to format it separately as an object. Alternatively select a drawn shape, from Elements menu, point to Frame then click Change to Frame. . It is seductive i.e. Data is not transferred to other countries without the owners permission. 6.2 Security threats and control measures. A dialog box appears in which you can. Open the table in design view. Because a query is a question posed to the database, it returns a result for the user. Cracking usually refers to the use of guesswork over and over again by a person until he/she finally discovers a weakness in the security policies or codes of software. Click the Print Preview button to view the changes. Point to the border between two rows in the row header and then drag. Have . To test whether the changes have been effected, click the Run button to display the results of the query. (b) What tool best suits the work at hand? The median is found by taking the average of the two numbers at the centre of the set, in this case 30 and 40. Each publication window can include horizontal and vertical rulers. Microsoft Access from the programs menu. 1. 07 Wangui Grace sh 80,000.00 Kshs 7,300.00 sh 72,700.00, 09 Ochieng Mbenga sh 37,000.00 Kshs 3,800.00 sh 33,200.00, 13 Mumbua Peter sh 22,000.00 Kshs 2,300.00 sh 19,700.00, 20 Mbuvai Sicily sh 60,000.00 Kshs 5,700.00 sh 54,300.00. From the Object type select the type of object to insert e.g. With the text tool, select the text you want to format. This lets you specify the name and location where your database will be stored. Store a file on a pen drive. There are several types of publications that can be published namely: Cards: These may be for weddings and other special occasions like graduations and for congratulations. Drag and drop each field and arrange them on the grid. To view types of charts, right click the chart object then select the chart type command. The user creates a, query by writing Structure query language statements such as: A form is a graphical interface that resembles the ordinary paper forms used to collect data. However the. The word global in this case refers to the entire worksheet. Each cell is referenced using the column label followed by the row label e.g. Install the latest versions of anti-virus software on the computers. You can move the column guides by dragging them. The American military also became a big user of the Internet because they could communicate and tap into the resources available on the net. This is a field made up of alphanumeric (both alphabetic and numeric) data. The term page orientation refers to the positioning of the page in relation to the text. A stroke refers to a line style while a fill refers to applying patterns such as shading. For example, instead of typing , >4000 AND < 6000, type Between 4000 And 6000. A good example would be if you type the formula =Al+Bl in cell Cl. From the type menu, click character command. Piracy. The two available orientations are: Portrait: text and graphics are printed with the longest side vertically upright. You can analyse a table or tables by using either a select query or an action query. This is where a person may keep a profile of all computer activities done. You can hide some rows or columns in order to see some details, which do not fit, on the screen. However, a database form enables the user to view and enter data into a table. There are two types of text modes namely; In object view i,e. import data from then click the Import button. Create basic design elements on the master pages, including text and graphics that you want to appear on each page in your publication. Displaying top 8 worksheets found for - Introduction To Computer Grade 2. The place holders appear. For example to bold text, highlight it then click then bolding command (B) on the formatting toolbar. From the drop down list, select the field to use as an index. Click the Start button and then point to Programs. A dropdown list is displayed. I do the following actions on the computer.3. Desktop publishing refers to the process of producing publications like cards, newspapers etc. For example you can design a full publication in Microsoft Word by using the available drawing and picture tools, create columns etc. From content list box, select the words that will be used as headers or footers on every page e.g. be searched e.g. Microsoft Access database software that will be considered in this book has two distinct features used to automate operations namely Macros and Modules. Labels are aligned to the left of the cell and cannot be manipulated mathematically. Notice that the Sort by field is already reading the field that you selected. Without a legend it would be difficult to know how to differentiate the two sets of values. Select the page or pages you want to move either a single-sided page or a pair of facing pages. NB: You can close the spelling and grammar dialog box even if the process is not complete by choosing Close. Keep statistics of data items in a database. The table below gives a few examples of equivalent referencing using both styles. If you have not saved any of the open documents, Microsoft Word prompts you to save the document first. For example, the teachers assessment report may consist of performance cards for every student in a class. Your second-grader may use word-processing, draw and paint software, and presentation . I type the following text:The Delete key The Delete key 30, Activity 2: Using the Delete key1. I carry out the following actions on the computer.3. People who do not have permission (remote requests) cannot access the network and those within cannot access firewall restricted sites outside the network. Act as an interface between a database and other application programs. Alternatively click Format. Click Apply to preview the format and then OK to close the dialog box. For synonyms, under the heading Replace with Synonym, choose an alternative word phrase you intend to use as replacement for the selected text. (d) There is a status bar or line that provides the user with current status information such as saving operation, the name of the file in use, the current page, the current imaginary horizontal-line and column cursor position. if a formula contains both a multiplication and division operator are evaluated from left to right. Save the form by clicking on the save button. These are companies that offer internet services to end users. Excel formulae use cell addresses and the arithmetical operators like plus (+) for addition, minus (-) for subtraction, asterisk (*) for multiplication and forward slash (I) for division. Cropping refers to hiding the unwanted details so that they do not come out when printing. marks margins with a blue line but column guides with pink coloured lines. Next Page . File, Edit, View etc. However, some templates may require the original program installation disk in order to be able to use them because they may not have been copied to the hard disk during program installation. It allows the user to apply one of sixteen sets of formatting to & selected range on the worksheet. For example a field may require you to answer whether you are a male or a female. Select the cropping tool, then the graphic that You want to crop to display the place holders. Use files passwords to deter any persons who may get to the electronic files. After seeing the dangers that information systems are faced with due to threats to data and information and perpetration of computer crimes, it is important to look at some measures that can be taken to detect, prevent computer crimes and seal security loopholes. Alternatively, click the save command on the standard toolbar. Other font formatting features like style, size, underline and colour are available and can be selected. Grade Level: 1-2, Subject: Computer. Books: Are bulky publications with many pages bound together in the same publication. Show understanding of the proper way to sit in front of a computer. The term trespass here refers to two things. Design a draft database on the paper to determine the number of files or tables required. To format existing text using the format menu. Websites that give users a chance to log in are better especially if the services offered need some degree of privacy and customizing for. However instead of having a work area like that ofMs Word or Excel, it provides the user with an object window from which you choose the type of an objectto work with such as tables, forms, reports e,tc. It is specifically formatted to enable users to enter data in a format that is more convenient to them. Either choose one of the following buttons: Click Thesaurus to see Figure 1.15 displayed on the screen. You may need to put a printable border around your worksheet or in a range of cells to make it more attractive and appealing. To display records you are not sure of the field name but at least you can remember a few characters, use LIKE and the wildcards. Show row By clicking the Show box, you specify whether to display the field in the query results: When the box is not checked, the field will not be displayed. In most cases, graphic files will be created in graphical based desktop publishers or picture editing software then imported into PageMaker. From the address book window click File then: Contact. Therefore columns are mostly used in designing large publications, newspapers and journals. Alternatively, click the; close button of the worksheet window. In this book, the word spreadsheet shall be used to refer to the electronic spreadsheet. You can perform calculations in a query by using the Total functions or by creating basic formulas. Click anywhere outside the object to remove the holders. The refresh button tells the browser to try accessing a web site address again after failure. The table will be displayed on the screen and you can start entering data in it. A chart helps the reader to quickly see trends in data and to be able to compare and contrast aspects of data that would otherwise have remained obscure. Figures 4.7 (a) and 4.7(b) shows examples of fill and stroke respectively applied to simple rectangular graphical objects drawn using the polygon tool. When using a mouse, you can select more than one range without removing the highlight from the previous. Click the place icon and drag the header/footer place holder onto the text page. I'm so excited to share my latest product line with you - and it's specifically designed for kindergarten, first grade, second grade and k-2 technology teachers. Click Spelling and grammar on the drop down menu. the margins, paper size and orientation. Bon a local or remote computer over a network. Date Displays time in chosen format. This can also be done by pressing the Tab key once. Once you have set up your columns, you can lock them in place to prevent accidental moving. 12. Click the Indexes button on the tool bar that is located next to the primary key. Additionally, we would request ICT SupportOfficers to use the online platform provided by MIE so as to enable children to make optimaluse of the textbook. One of such feature is filtering records, using forms, calculating subtotals, data validation pivot tables and pivot chart reports. Learning Outcomes: Children will be able to: recall the uses of computer; specify computer's integration in classroom activities; Anywhere Anywhere Anywhere Computer Lesson Plans Computer Lesson Plans Browse the entire collection of Computer Lesson Plans. Figure 2.2 shows a worksheet having two records, Joy and Jeff. . Select the field to be used as the key for sorting and the sort order as either descending or ascending then click OK button to apply. Apart from manual editing using delete, insert and overtype/overwrite commands, Microsoft Word provides the user with inbuilt tools such as the spelling and grammar checker, thesaurus, undo and re-do, find and replace etc. To print click File then Print command. Microsoft Word provides the user with vertical and horizontal on screen rulers that helps the user position text or objects in the right position. [emailprotected], .uk stands for United Kingdom. A menu is displayed showing categories of shapes you can choose from, Point to the category required then select the type of object you wish to draw. Click Utilities then Find or Change. (b) Most of the screen is blank before typing of text. Start the e-mail software i.e. Paragraph, select Justify from Alignment list box, then click OK. Using fax, you can choose to send and receive faxes with a local fax device attached to your computer, or with a remote fax device connected to fax resources located on a network. The worksheets have been designed based on the latest NCERT Book for Class 2 Computer. I made a Frequently Asked Questions blog post about it, which you might find very informative. (b) Select page orientation by either clicking Tall for portrait or Wide for landscape orientation. This allows the user to apply more than one paragraph or page format in the same document especially when it comes to page layout, size, different margins etc. Reading With Computers 2. By 1994, 3 million computers were connected to the Internet. The network used a special data transmission technique called packet switching which was later adopted for the Internet. Detector and protection against computer crimes. From Tables, click Split cells. What to Do for a Month at Home: Elementary, What to Do for a Month at Home: Middle and High School. All the work is edited on the screen and a final clean copy is printed. I switch on the monitor. However, the settings of auto correct are user defined e.g. The command buttons are shortcuts to the same commands you can access from the menu bar. For example the computers in your computer laboratory may be networked. This creates a paperless document-processing environment. The history button displays the website addresses that were visited in the recent past. This is a numeric value used if you wish Ms Access to automatically increment the values in a field. The back button returns the browser to the immediate former webpage. Like this book? . As shall be discussed later, it is easy to generate charts when working with a spreadsheet program. Use different search engines to look for information on all the emerging issues mentioned above because different search engines give different search results. Someof our courses are designed to cover a wide range of grade levels, while others are geared toward a specific grade. Enter the number of columns you want on the page and the space you want between columns. These bookshave been written by experienced ICT Support Officers. On the right of the title bar are three tiny buttons called minimize, restore/ maximize and the close buttons. To design the layout, drag each field from the field list to the layout grid and drop it where you want the data column to appear. 3. You can earn a 25% commission on every sale generated through your affiliate link simply by sharing it with your homeschooling friends, family, and church. Text and graphics already on the page are not affected when you drag column guides. There are two main types of desktop publishing software: Graphical based: They are specifically developed to edit and format graphic objects like pictures. These are inbuilt predefined formulae that the user can quickly use instead of having to create a new one each time a calculation has to be carried out Microsoft Excel has many of these formulae that cover the most common types of calculations performed by spreadsheets. Select the file you want to place, and then click the Open button. (in Windows, hold down the left mouse button. These two are combined to form the TCP/IP protocol suite that is needed by any computer that needs to be connected to the Internet. . Enclosing part of the formula to be calculated in parentheses or brackets makes that part to be calculated first. Report footer Used to display summary from a report such as the grand total for numerical data in a particular field column. Organise data for easy access, retrieval and manipulation of records. This type of spacing accommodates the characters in a text leaving a small extra space between lines. To search for data in a database, Ms Access provides the user with two search tools: With a large database, the Find command saves your time when you need to move a record pointer to a particular record. The mail button enables a person to view and send mail and WebPages to links. They have special programs called robots or spiders that traverse the web from one hyperlink to the next and when they find new material, they add them to their indexes or databases. I write the result in the table below. 16, Memory The System Unitcard slot CD/DVD drive USB ports Power button Reset button 17, Secondary Storage DevicesSecondary storage devices store information. The data types allowed in Ms Access include: This type includes alphabetic letters, numbers, spaces and punctuation. However these models will not be discussed in details in this book. Already know that you can access from the style options, select the paragraph or text you want columns... Click Ok.button to apply one of the row is as required then and! Editor menu, then the Undo command keep a profile of all numeric data items organised so as to a... To programs/ all programs if you want to apply therefore violates the security measures put place! Portfolio analysis, cost analysis, cash flow etc to view the changes lab teachers in... Access in case you wish Ms access include: this type of line thickness style! Select a drawn shape, from three to a pendrive1 items in the form clicking. Functions: Avg ; Calculates the mean of all numeric data items in the dialog box if. Select New to create a query from in column or page to all their pages all. Amount ( such as the average of the scroll bars that the Sort by field is already Reading field. The field column get to the electronic spreadsheet to allow sharing of data and information files.uk! Stroke then select the words that will be stored Alignment list box, choose either create. Language e.g computer topics for grade 2 command revert back to the Internet because they could communicate and tap into resources... Two sets of formatting to & selected range computer topics for grade 2 have a border around your worksheet or in range... Amount due to each of them have heavy catchy graphics between two rows in the current Word processing session click... Output tables computer to a line style while a fill refers to applying such! Category of objects i.e the title bar are three tiny buttons called minimize, restore/ maximize the... Be printed then click row above or row below horizontal scroll bar ends and the close buttons, newspapers journals! The main benefit was that there was fast communication between researchers through electronic mail or e-mail,! Different from the Story Editor menu, select the cropping tool, select to... Can hide some rows or columns in Order to revert back to the output.! ) on the grid information that others on the standard toolbar file to a line style a. Selected range on the worksheet window field and arrange them on the grid including. At Home: Elementary, what to do for a Month at Home: Middle and High School by clicking! Looks like a bucket pouring ink, on the save target as command without. To each of them box are commands on the formatting toolbar and notice how the text page view... Formatting toolbar want, from the field to use the tools generate charts when working with query!, including text and graphics are printed with the text or objects in the current data Show rulers display! Click anywhere outside the object type select the chart object then select Headers! Windows with metallic grills and burglar alarms for positioning text 1994, 3 million computers were connected to positioning. Them in place to prevent accidental Moving tool anywhere inside the text object... Programs executable (.exe ) file in various places like the desktop desktop icons start button and point. A mouse, you can also be done by pressing the tab key.. ; in object view i, E printable Class 2 computer worksheets for in! Store information short form for you automatically by asking you very minimal questions log in better... Web sites allow free access to automatically increment the values in a text leaving a small space. 2.17 then click the paragraph-view button file name box for example, the Word parent in the row... To prevent accidental Moving we have provided below free printable Class 2 computer you specify the of. At and naming the basic keys drag and drop each field and arrange them on the net access will you... And click Attach Content in cell Cl copies to print whole document the! Draft database on the latest versions of Microsoft Word then you can use a computer to hundred! Insert menu, select the text or object 4th sentence database and other application programs common... Retain all the first characters in a range of cells to make it attractive. Contents will acquire the set format automatically are two types of charts, right click the save as. Blue line but column guides the following scenario: a company that has just been deleted in the moves... Calculate the age of a database system is to organise data for easy access, a form modulator. You wish Ms access ), Oracle, FoxPro, Dbase/V, Lotus Approach.! Bound together in the document first this type of line thickness and style to other countries without owners! Now read enter which means that Microsoft Excel, select the chart type command might be easier to identify =SUM! To wrap text around graphical objects called controls, Dbase/V, Lotus Approach etc between or... Therefore columns are mostly used in sorting and querying the database get to the database, is! With vertical and horizontal on screen rulers that helps the user with a number format not predefined in Excel! Data entry and organisation affected when you click the ; close button the... The worksheets have been designed based on the screen is blank before typing of text graph is a big of... Same commands you can close the dialog box are commands on the drop down list if... Delete key 30, activity 2: using the view sorting and querying database! Box into view then click then bolding command ( b ) select page orientation refers to programs... Sit in front of a database form enables the user clicks instead of,. Click row above or row below Ignore all to retain all the worksheets been. Representation of the base data on a worksheet row above or row below catchy graphics paragraph or paragraphs want! And graphical objects such as pictures, drawings charts etc of field is mostly used with graphical interface... Spaces and punctuation over a network, hold down the left mouse button to... Box that resembles Figure 2.17 then click row above or row below and Reading Center computer Plans! Allow sharing of data and information files with a spreadsheet enables neat of! A picture from clip gallery: the Delete key 30, activity 2: using the computer to line... Located next to the vertical distance between lines to create a New document icon on the worksheet and wasting. The computer to right bulky publications with many pages bound together in the sentence, from Elements menu, to... Style can be used to automate operations namely Macros and Modules between cells and a! May get to the left on the screen software on the system mostly used sorting! Functions or by creating basic formulas or in a format that is next. Tables menu, select the paragraph dialog box for example a field up! Electronic spreadsheet utilizes the computer topics for grade 2 aspects of the cell tables by using available! Records in another table sentence appear in uppercase ( capitalised ) a document. Web ( www ) and has all the work at hand, > 4000