Ss2
THIRD TERM E-LEARNING NOTE
SUBJECT: DATA PROCESSING CLASS: SS2
SCHEME OF WORK
WEEKTOPIC
Revision
Presentation Package I
Presentation Package II
Web Design Package I
Web Design Package II
Web Design Package III
Graphical Package I
Graphic Package II
Graphic Package III
Maintenance of Computer I
Revision
Examination
REFERENCE TEXTBOOK
DATA PROCESSING for SENIOR SECONDARY EDUCATION byHiiTPlc
WEEK ONE
TOPIC: Revision
Questions on previous term topic
1. Give four examples of a web browser
2. Explain internet security
3. List four types of file organization
4. List four types of internet security
5. What are the criteria for choosing a file organization
6. What is the full meaning of the following: i.SQL ii.RDBMS iii. DML iv. DDL
7. List four standard SQL Command
8. Explain the following: i. Entity ii. Relationship iii. Attributes iv identifiers
9. What is Normalization
10. What is Data Modeling?
11. List types of data model
12. Write down the full meaning of the following basic internet terminologies: i. POP ii. SMTP iii. ISP iv. HTML v. HTTP
WEEK TWO
TOPIC: Presentation Package
CONTENT
Definition:A presentation package is a computer software package that is used to display information usually in form of a slide show.
Examples of presentation package
Microsoft PowerPoint
Macromedia flash
Windows movie maker
Open Office
Uses of Presentation Package
(1) As a slide show
(2) In delivering multimedia lectures
(3) In writing multimedia story book
Getting Started with PowerPoint
Ways to start PowerPoint
(1) Double-clicking the icon on the desktop
(2) Using the Start menu
Ways to Create a New Presentation
(1) Using Blank presentation
(2) Using Templates
(3) Auto Content Wizard
How to Insert Text
Placeholders are the dotted outline that appear when you create a new slide. These boxes serve as placeholders for objects such as the slide title, text, chart, table, and clip art.
Just click to add text in any placeholder or double click to add the specified object.
Evaluation
1. Mention two ways to start a PowerPoint
2. State two ways to create a new presentation
General Evaluation
1. What is a presentation package
2. List three examples of a presentation package
3. State two uses of a presentation package
4. Describe how you would create a slide in Ms- PowerPoint
Reading Assignment
Data Processing for senior secondary education by Hiit Plc. Pages 89-95
Weekend Assignment
SECTION A
Instruction: Choose the correct option from the ones lettered A to D
1. The following are examples of a presentation package except
(a) Ms-PowerPoint (b) Macromedia Flash (c) Windows Movie Maker (d) Ms Excel
2. is the main reason/use of presentation package(a) calculation (b) word processing
(c) presentation (d) analysis
3. package is a software package that is used to display information usually in form
of a slide(a) graphic (b) spreadsheet (c) database (d) presentation
4. is an act of delivering a seminar, talk, lecture etc to the audience either formally or
informally (a) presentation (b) chanting (c) teaching (d) talking
5. are the dotted outline that appears when you create a new slide (a) slides (b) template (c) placeholder (d) animation
SECTION B
1. State two uses of a presentation package
2. List five examples of a presentation package
WEEK THREE
TOPIC: Features of a Presentation Package
A presentation package has certain features such as:
Creation of Slides: to create presentations, group of slides are created. Presentation packages contain slides.
Insertion of Pictures: presentation packages allow users to insert pictures and objects into their presentation from external sources.
Insertion of Video and Audio: presentation packages allow users to insert video and audio into their presentation from external sources.
Animation: this feature makes presentation package different from other packages. It allows users to create motion effect on their slides.
Slide Show: this feature makes users to view how the group of slides will be displayed. It displays the content to the audience during the presentation.
Creation of Graphics: this feature enables the presentation package to provide users with graphics inform of shapes that can create an object from the scratch.
Creating organizational and other Types of Chart: charts such as pie chart, bar chart etc. can be created easily with presentation package.
Evaluation
1. What is a presentation package?
2. Mention two features of a presentation package.
Using Presentation Package Microsoft PowerPoint 2007
How a window displays depends on the size of the window. Resolution determines how much information your computer monitor can display. If you use a low resolution, less information fits on your screen, but the size of your text and images are larger. If you use a high resolution, more information fits on your screen, but the size of the text and images are smaller.
Microsoft Office Button: in the upper-left corner is this button. You can use the menu to create a new file, open an existing file, save a file, etc.
Quick Access Toolbar: this tool providers you with access to commands you frequently use. The save, undo and redo appear on the Quick access toolbar.
Title Bar: it displays the name of the currently working presentation. PowerPoint names presentation start with Presentation1.
Ribbon: this is located near the top of the PowerPoint window, below the Quick Access toolbar.
Ruler: rulers are vertical and horizontal guides. Thy are used to determine where you want to place an object.
Slides, Placeholders and Notes: slides appear in the center of the window to create your presentation. Placeholders hold the objects in your slide. You can use placeholders to hold text, clip art, charts, and more. You use the notes area to create your notes. You can refer to these notes as you give your presentation.
Status Bar, Tabs and View Buttons: The view buttons appear near the button of the screen. It is used to change between Normal view, slider sorter view, and the slide show view.
Zoom:Thisallows you to zoom in and zoom out on the window. Zooming makes the window larger so you focus on an object. Zooming out makes the object smaller so you can see the entire window. You can click and drag the vertical and horizontal splitter bars to change the size of your panes.
To open the Ms PowerPoint application: click on START button, navigate to All programs, navigate to Microsoft Office, click on Microsoft Office PowerPoint.
Creating a New Presentation: PowerPoint presentation can be created on slides. Use layouts to organize the content on each slide. PowerPoint has several slide layouts. You can add effects such as theme and backgrounds to slides. Themes are set of colours, fonts, and special effects. Backgrounds add a coloured background to your slides.
Evaluation
1. Mention four features of Microsoft PowerPoint 2007
2. Mention the uses of the above-mentioned features
Inserting the Contents: PowerPoint displays default slides in the slide pane when you open the package.
To Enter Text: click and type the title of your presentation in the “click to add title area”, “click and type a subtitle in the click to add subtitle” area.
To Insert Graphics or Pictures: Click in the “click to add title” or “click to add subtitle” area, press the enter key to bring the cursor down, from the ribbon bar, click on the insert menu, select the type of graphic options from clip art, select shapes, and pictures buttons from the menu.
To Add Clip Art Object: Click on clip art button, in the search for textbox, type a general description of the graphics you want to insert, then click on the ‘Go’ button., click on any image from the list of displayed graphics to insert into the slide.
To Add Picture Object: Click on picture button, the insert dialog box is displayed, cick on the location of the picture on the computer from the look in options, click on the desired image and click on insert command button. The picture is inserted into the slide as desired.
To Choose an Effect: Select the object you want to animate, choose the animation tab, click the custom animation button, the custom animation button pane appears, click the Add Effect button a menu appears, choose the type of effect you want. A submenu appears, click the effect you want, PowerPoint applies the effect.
To Add New Slides: Choose the Home tab, click the New slide button in the slides group, the office theme dialog box appears and displays several layout templates, click the layout you want, the layout appears in the slide pane of the PowerPoint window. To add text, click inside the placeholder and type. To add additional slide to your presentation, right click the slide layout, a menu appears, click layout and then click the layout you want, choose the Home tab, click the New slide button, select from the options.
To Save a Presentation: Click on the office button, select save from the options displayed, select the drive you want to save the document, click on the file name, type the desired document name, click on the save button.
To Run a Slide Show: Choose the slide show tab, click the “from the beginning button” in the start slide show group, click the slide show icon on the bottom right corner of your screen. Your slide show appears on your screen.
To Print Presentation: Click the Ms office button, a menu appears, choose print, click print preview, click the down arrow next to the print what field in the page setup group and then select what you would like to print. A preview appears on the screen, click the print, the print dialog box appears, click the down arrow next to the colour/grayscale field to select whether you want your slides to print in colour, grayscale, or black and white, click ok.
To Close Presentation: click on the close button from the title bar.
General Evaluation
Define a presentation package.
Mention two examples of presentation packages.
Describe how you would do the following in Ms PowerPoint: (i) add new slide (ii) print
(iii) add picture
Reading Assignment
Data Processing for Senior Secondary Education by HiiT Plc. Pages 89-94
Weekend Assignment
SECTION A
Instruction: Choose the correct option from the ones lettered A to D
1. To close a presentation, click on the __ bar. a) title b) task c) status d) menu
2. To add new slides, you choose the __.a) animation b) Home tab c) office button d) file
3. To save a document, which of these will you click on? a) animation b) Home tab c) office
button d) file
4. To run a slide, you choose from the __ tab. a) menu bar b) taskbar c) quick access toolbar
d) slide show tab
5. To add clip art object, you click the __button. a) clip art b) office c) home d) graphic
SECTION B
1. Describe how you would add picture objects to your slides
2. Describe how you would create a new presentation
(a) insert pictures(b) animate the presentation(c) run a slide(d) close the presentation
WEEK FOUR
TOPIC: WEB DESIGN PACKAGE I
Meaning of Web Design
Website design means planning, creation and updating of websites. Website design also involves information architecture, website structure, user interface, navigation ergonomics, website layout colors, contrasts, fonts and photography as well as icons design. All these website elements combined together to form websites.
Understanding a Web Page
A web page is a text file containing Hypertext Markup Language (HTML) formatting tags and links to graphic files and other web pages thorough a web server. Web pages are unique in such a way that the can be interactive and use multimedia. The main thing to remember when creating a web is to establish a goal by setting many links.
Uses of a Web Design Package
A web page is basically used to create web pages. Other uses include:
Accessibility Checker: Which gives the users the ability to check if their codes is standard complaint and their website is easily accessible for people width disabilities.
Split View Option: Allow users to code in code view and preview in design view without the hassle of switching from design and code view tab.
Interactive Buttons: Give users a new easy way to create web graphics for navigation and eliminating the need for a complicated image –editing package such as Adobe Photoshop.
Dynamic Web Template (DWT): Allow users to create a single template that could be used across multiple pages and even the whole website.
Code Snippets: Give users the advantage to create snippets of their commonly used pieces of code allowing them to store it for easy access when next it is needed.
Evaluation
1. What is the meaning of HTML?
2. What is Dynamic Web Template?
General Evaluation
1. Explain the meaning of the term web design
2. State three uses of a web design package
Reading Assignment
Data Processing for Senior Secondary School by Hiit Plc. Pages 95-97
Weekend Assignment
SECTION A
Instruction: Choose the correct option from the ones lettered A to D
1. ____ package is used create web pages.(a) graphic (b) web design (c) presentation
(d) word processing
2. ____ means planning, creation, and updating of websites. (a) animation (b) website design (c) database (d) download
3. ____ gives the user the ability to check if their code is standard complaint.
(a) accessibility checker (b) dynamic web template (c) code snippets (d) split view
4. ____ gives users a new easy way to create web graphics for navigation(a) code snippets (b) accessibility checker (c) dynamic web template (d) interactive button
5. ____ gives users the advantage to create snippets of their commonly used pieces of code (a) accessibility checker (b) dynamic web template (c) code snippets (d) split view
SECTION B
1. Explain the meaning of the term web design
2. Explain the following:(a) code snippets (b) Interactive buttons (c) Split view option
WEEK FIVE
TOPIC: Web Design Package II
Component of a Web Design Package
1. A Solid Layout: In web design, the foundation is your layout. Laying out a web design involves placing all the content and navigational elements.
2. Effective Typography: It is the flow of the words and it is important for a web design’s typography to be easy to read and follow while establishing structure and hierarchy within the content.
3. The Right Color Scheme: Choosing the right color scheme is extremely important, because it will set the mood of your design more so than any other component.
4. Appropriate Design Elements: Your creativity can go wild here with texture, icons, patterns, etc. However, keep in mind that design elements also play a big role in setting the mood of the design. So keep things consistent with the goals of the website and it’s audience.
5. Hit Counter: This gives details about the number of a visitor to a website through a graphic counter.
6. Advertising Banner: The advertising banner will produce and ad-banner rotator with images of your choice . Ad-banner are usually used to generate revenue and can however be used to rotate many images to create a slide show effects.
7. Table of Content: This will repeatedly create a page with hyperlinks to each page on your site. The table of content can be used as a site map.
8. Marquees: A marquee is a text that scrolls across the screen. The marquee is used when you want to draw attention to a certain point.
9. Scheduled Pictures: This component can be used when you have a limited offer or you want to add variety to your page,
10. Search Form: This lets one have an easy way to search one’s site.
Evaluation
1. What is a search form?
2. Explain the term, Hit Counter.
General Evaluation
1. List five components of a web design package
2. Write short note on the following component of web design package: solid layout, scheduled pictures, marquees and animation button.
Reading Assignment
Data Processing for Senior Secondary Education by HiiT Plc. Pages 95-97
Weekend Assignment
SECTION A
Instruction: Choose the correct option from the ones lettered A to D
1. ___ can be used when you have a limited time offer or you want to add variety to your page (a) scheduled pictures (b) search form (c) marquees (d) animated button
2. ___ is a text that scrolls across the screen (a) scheduled pictures (b) search form
(c) marquees (d) animated button
3. ___ will repeatedly create a page with hyperlink to each page on your site. (a) scheduled pictures (b) search form (c) marquees (d) animated button
4. ___ uses a java applet to generate button that respond to mouse-over movement.
(a) scheduled pictures (b) search form (c) marquees (d) animated button
5. ___ will produce an ad-banner rotator with images of your choice. (a) advertising banner (b) scheduled pictures (c) table of content (d) marquees
SECTION B
1. List five component of a web design package
2. Write short note on the following component of web design package: scheduled pictures, marquees, animated button, hit counter, advertising banner, and table of content.
WEEK SIX
TOPIC: WEB DESIGN PACKAGE III
Examples of a Web Design Package
Examples are as follows:
1. iWeb: iWeb allows users to create websites and blogs and customize them with their own text, photos and movies. iWeb integrates with other services, including Facebook, YouTube, Google Adsense and Google Maps. It allows user to create a website in just a few minutes without the knowledge of programming or HTML. iWeb provides beautiful, Apple-designed templates that you can easily customized so don’t have to worry about design.
2. Microsoft FrontPage: It is a web tool that allow users to create accustom web sites without having to know HTML code. It helps you to manage the pages in your web as well as create and edit web pages in a What-You-See-Is-What-You-Get (WHSIWYG) fashion.
3. Adobe Dreamweaver: It is a web design package that is suitable for everything from simple page design to development of dynamic pages written with ColdFusion, PHP, ASP, CSS, XML, XSLT, and JavaScript. Dreamweaver is the most powerful, most fully featured web developer tool. It combines a great WYSIWYG editor, an FTP client, and a convenient scripting environment.
4. Microsoft Expression Web & Studio: It is a web design tool you can use to design and developed web pages using XML, CSS, ASP.NET, ASP.NET AJAX, XHTML, XSLT, PHP and JAVAScript. Expression Web requires .NET Framework and Silverlight to install and run. It uses its own standards-based rendering engine which is different from internet Explorer’s Trident engine.
5. Webplus X4: Is the quick and easy way for anyone who wants to create and publish eye-catching desktop and mobile sites, without having to use any code.
6. NetObjects Fusion: Are commercial programs with a graphical user interfaces and generates HTML or XHTML through its own proprietary database.
7. Amaya: Is a free and open source WHYSIWYG authoring tool with browsing abilities. It has XML-based capabilities such as XHTML, MathML and Scalable Vector Graphics (SVG). It displays free and open image formats such as PNG and SVG, as well as a subset of SVG animation.
Evaluation
1. What is WHYSIWYG?
2. Mention one commercial web design package
General Evaluation
1. Explain the term web design.
2. Mention four examples of web design package and where they are used.
Reading Assignment
Data Processing for Senior Secondary Education by HiiT Plc. Pages 95-97
WEEKEND ASSIGNMENT
SECTION A
Instruction: Choose the correct option from the ones lettered A to D
1 ___ allows users to create website and blogs and customized them with their own text,
photos and movies (a) Microsoft Frontpage (b) iweb (c) Dreamweaver (d) Amaya
2. ___ is a web tool that allow users to create accustom websites without having to know HTML code(a)Microsoft Frontpage(b) iweb (c) Dreamweaver (d) Amaya
3. One of the following is not an example of a web design package (a) iWeb
(b) CorelDraw (c) Microsoft Frontpage(d) Amaya
4. ___ is the most powerful, most fully featured web developer tool (a) Microsoft Frontpage (b) iweb (c) Dreamweaver (d) Amaya
5. Which of the following web design tool is both a design and developer tool …………
(a) Expression Web (b) Dreamweaver (c) Frontapage (d) Amaya
SECTION B
1. List and explain four examples of a web design package
2. Explain the following examples of web design package(a)iweb (b)Dreamweaver
(c) Microsoft Frontpage
WEEK SEVEN
TOPIC: GRAPHICS (Introduction to CorelDraw)
Definition of Graphics
Computer Graphics are graphics created using computer and, more generally, the representation and manipulation of image data by a computer.
Examples of Graphics Packages
Paint
CorelDraw
Adobe Photoshop
Harvard graphics
Print Master
Ventura
Photoshop Pro
Adobe Page Maker
Features of CorelDraw or CorelDraw Environment
Title Bar
The title bar displays the name of the CorelDraw file on which you are working. It is also used to reposition the CorelDraw window on the screen.
Menu Bar
There are 11 pull down menus in the menu bar. All menu commands are found in these pull down menus.
Rulers
Rulers serve as a positioning and sizing aid. They can be turned off optionally. In addition, you can drag guidelines off the rulers to serve as drawing aids.
Scroll Bars
The scroll bars allow you to shift the page horizontally and vertically.
Drawing Windows
The large white portion of the screen is the drawing windows. The rectangle with the drop shadow is the printable page.
Roll-up Window
The Transform (Position) roll-up is shown on the left. Although they are not permanent part of the interface (they can be if you want). You can use them to control many of CorelDraw’s operations. Their beauty lies in the fact that they can remain active for playing quick “what-ifs” without going through the longer process of invoking a standard menu dialog box.
Status Bar
Status bar shows the fill pattern, outline location, movement and absolute coordinates of selected object.
Colour Palette
The colour palette allows for the quick application of a colored fill or outline colour. Selecting the scrollbar at the bottom of the palette opens an expanded color palette.
Page Counter
CorelDraw allows you to create drawings consisting of multiple pages. The total number of pages is displayed in the page counter box along with arrows that allow you to page forward or back in your document.
Standard Toolbar
Toolbar provides quick access to commonly used features. Almost all of these can be accessed through the Menu Bar. CorelDraw provides a series of different toolbars for your use. Additionally, toolbar are completely customizable. You can add buttons to invoke just about any command that you regularly use.
NOTE: There are keyboard shortcuts that are often faster that toolbar usage. Once memorized, you won’t need to waste precious time with a Toolbar button.
Ctrl + S = Save; Ctrl + P=Print; Ctrl + Z=Undo; Ctrl + X = Cut; Ctrl + C =Copy; Ctrl + V= Paste
Evaluation
1. Differentiate between a standard toolbar and status bar
2. What is a page counter?
General Evaluation:
1. Give four examples of graphic package.
2. Mention four features a graphic package.
Reading Assignment
Senior Secondary Education by HiiT Plc. Pages 149-153
Weekend Assignment
SECTION A
Instruction: Choose the correct option from the ones lettered A to D
1. ___ software is used for representation and manipulation of image data by a computer.(a) graphics (b) presentation (c) spreadsheet (d) word processor
2. Which of these is not a graphic software? (a) Tally (b) Adobe Fireworks (c) Print Artist (d) Instant Artist
3. ___ is used to display the name of the program and the user file(a) Title Bar (b) Status Bar(c) Scroll Bar (d) Printable Page
4. ___ portion will print all the objects that are required to be printed(a) printable page (b) drawing window (c) canvas (d) text area
5. ___ bar provides quick access to commonly used features (a) standard tool (b) title (c) status (d) scroll
SECTION B
1 What is a graphic software?
2. Explain two features of a CorelDraw
WEEK EIGHT
Topic: Operational Tools
The operational tools are as follows:
The Toolbox
The toolbox provides you with operational tools. The basic categories of tools are:
Utility Tools
Diagramming Objects
Interactive Tools
Painting Tools
Utility Tools
The Pick Tool
For selecting objects.
For moving, sizing, rotating and skewing object.
The Shape Tool
For editing the shapes of the diagramming object and text.
The shape fly-out give access to knife tool, eraser tool, Free Transform tools.
The Zoom Tool
For changing views.
The zoom fly-out gives you access to the Panning tool.
Diagramming Object
The Freehand Tool
For drawing straight lines, curves.
For auto-tracking a bitmap images.
The freehand fly-out gives you access to the Bezier (curve) tool; Natural Pen tool; Dimension line tool and connector line tool.
Rectangle Tool
For drawing rectangles and squares
Ellipse tool
For drawing ellipse and circles.
The polygon Tool
For drawing multi-sided shapes like stars or polygons.
The polygon fly-out gives access to the spiral tool and Graph paper tool.
The Text tool
For placing Artistic text and paragraph text.
Interactive Tools
Interactive fill Tool
For placing various fills on the page interactively.
Interactive Transparency Tool
For creating transparent effects interactively.
Interactive Blend tool
The interactive Blend fly-out gives you access to the new distorted tool; Interactive envelop; Extrude and Drop shadow tools.
Painting Tool
Outline Tool
For setting outline thickness and color.
For creating line ending attributes.
For creating calligraphic effect.
For applying dash line patterns.
Fill Tool
For setting fill colors and screens.
For creating fountain fill.
For applying pattern tile fills.
For applying texture fills.
For applying special PostScript fills.
Evaluation
1. What is the function of the shape tool?
2. Differentiate between a fill tool and an outline tool
General Evaluation
1. List the categories of a toolbox
2. Explain four functions of any tool in the tool box
Reading Assignment
Senior Secondary Education by HiiT Plc. Pages 149 – 153.
Weekend Assignment
SECTION A
Instruction: Choose the correct option from the ones lettered A to D
1. Which of these is not a category for a tool box? (a) diagrammatic (b) interactive
(c) utility(d) shaping
2. Which of these is not a utility tool? (a) pick tool(b) zoom tool(c) shape tool(d) outline tool
3. Which of these is not diagramming object tool?(a) freehand tool (b) polygon tool (c) text tool (d) fill tool
4. ___ tool is used for placing various fills on a page interactively(a) interactive fill
(b) interactive transparency(c) interactive blend(d) fill
5. ___ tool is used for setting outline thickness and colour(a) outline (b) fill
(c) transparency(d) interactive
SECTION B
1. List 10 tools that you can find in the tool box.
2. Explain the functions of 5 tools mentioned above.
WEEK NINE
TOPIC: Graphical Package III
Practical Class
Designing Drawings
Loading CorelDraw Application
To access the CorelDraw application, take the following steps:
Click on the start button
Point to all Program
Point to CorelDraw Graphic Suite 12 (Depending on the version you are using)
Select CorelDraw
Exiting CorelDraw
To leave the CorelDraw environment, take the following actions;
Save your drawing (In CorelDraw your document is called drawing)
Click on File Menu and select exit.
Drawing Shapes
After loading application
On the tool bar, Click Shapes
At the drawing area, drag to create shape.
Add Colour to your Shapes
After drawing your shapes
Select the Drawing by clicking on it
On the Tool bar, Click on the Fill Colour
Convert your Writing to Curve
On your drawing area, type the text
Draw a circle shape beneath the text
Select all
On the Text Menu, Click on “Fit text to Path”
Click on the Circle Shape only and delete it
Evaluation
1. Explain how to convert a curve a text
2. How would you add colour to a shape?
General Evaluation
1. Explain the meaning of the term Graphics package
2. State uses of Graphics package
3. Menton 4 examples of Graphics package
Practical Assignment
Design the following:
National Flag
School Logo/Badge
Coat of Arm
Complimentary Card
Letter Head
Weekend Assignment
SECTION A
Instruction: Choose the correct option from the ones lettered A to D
1. ___ package is the representation and manipulation of image data by a computer.(a) web (b) database ( c) graphics (d) word
2. Which of these is not an example of graphics package (a) Paint (b) Corel Draw
(c) Amaya (d) Adobe Photoshop
3. The large white portion of the screen is the (a) Docker(b) Roll-up window (c) Rulers (d) Drawing window
4. ___ tool is used to paint diagrammatic objects(a) text (b) zoom (c) shape (d) outline
5. Which of these tools might not be classified as diagramming objects(a) pick tool
(b) curve tool (c) interactive tool (d) polygon tool
SECTION B
1. State the features of CorelDraw or CorelDraw environment.
2. List five (5) tools you can find in the toolbox.
WEEK TEN
TOPIC: Maintenance of Computer I
General Computer Cleaning
Cleaning Mouse
Step 1: Disconnect the mouse cable from the back of the computer case.
Step 2: Lightly dampen a cleaning cloth with isopropyl alcohol and wipe down the outside of the
computer mouse and mouse pad.
Step 3: Remove the bottom cover of the mouse. To this, turn it over and note the directional
arrows that indicate the direction of rotation, or how to slide it off. Press with your
fingers in the direction of the arrows and then turn the mouse right side up, letting the
cover and mouse ball drop into your hand.
Step 4: Wipe the computer mouse ball wi ha lint-free cloth dampened with isopropyl alcohol.
Put it aside.
Step 5: Dampen a swab with isopropyl alcohol and clean between, around and on top the keys.
Change swabs as they become dirty. You may need several swabs.
Step 6: Replace the mouse ball and cover.
Step 7: Wipe the mouse cord. Lightly dampen a cleaning cloth with mild soap solution and
gently pull the cord through the cloth.
Step 8: Plug the mouse back into the computer.
How to Clean Your Monitor
Step 1: Unplug the power supply cord and cable from the back of the monitor and allow it to cool for at least 20 minutes.
Step 2: Vacuum the outside of the monitor, particularly the cooling grooves, holes or slots in the top surface where heavy dust or other debris may have collected. Blow compressed air in short puffs at an angle to the monitor surface. The goal is to remove dust and dirt without letting anything fall into the ventilation holes.
Step 3: Lightly dampen a cloth with a mild soap solution and wipe down the outside plastic portions of the monitor.
Step 4: Clean the monitor cables and power cord while they are disconnected. Lightly dampen a cloth with mild soap solution and gently pull the cables and cords through the cloth.
Step 5: Check the documentation or call the manufacturer to find out if your monitor screen has anti-glare, or other delicate coatings. If so, ask the manufacturer or cleaning instructions. If it does not have these special coatings you may spray a window cleaner unto a lint-free cloth and wipe it clean. Do not spray directly onto the screen. Chemicals may drip inside the monitor and damage it.
Step 6: For dusty or dirty manufacturing environments use a computer dust cover to protect the monitor
Evaluation
1. State how you would clean a mouse
2. List the steps to clean a monitor
How to Clean a Keyboard
Step 1: Remove the cable from the back of the computer case.
Step 2: Use a vacuum cleaner to remove debris between the key. If no vacuum is available, turn the keyboard upside down and gently tap on the back side dislodge debris.
Step 3: Aim between the keys and compressed air to remove remaining dust and debris. Use short puffs of air applied at about a 30-45 degree angle to the keyboard surface. Alternate between blowing the keys and tapping the keyboard upside down to dislodge particles until it is clean.
Step 4: Lightly dampen a cloth with a mild soap solution and wipe down the outside of the keyboard. Do not spray soap solution directly onto the keyboard.
Step 5: Dampen a swab with isopropyl alcohol and clean between, around and on top of the keys. Change swabs as they become dirty. You may need several swabs.
Step 6: Wipe the keyboard cord. Lightly dampen a cleaning cloth with mild soap solution and gently pull the cord through the cloth. Dry the cord with a dry cloth.
Step 7: For dusty or dirty manufacturing environments a good keyboard cover is recommended.
How to Charge a Laptop Battery
1. Plug your laptop into the socket and you can leave it there whenever possible.
2. You can recharge your laptop’s battery whether the battery is fully drained or not.
3. There is no need to fully drain your laptop’s lithium-ion battery every time you use it.
4. Lithium-ion battery have a rapid-charging option. This option is available either on a custom tab inside the Power Option dialog box or from special battery software that came with your laptop.
How to Clean a DVD Drive
1. Purchase DVD laser cleaning kit. The kit is comprised of a single disc that is design to spin in your drive and remove all dust from the lens.
2. Place the CD/DVD laser lens cleaning disc inside your DVD drive’s tray. Close the tray and allow the CD spin in the drive. As it spins, it will clear your lens of most, if not all, of the dust that is on it.
3. Purchase a can of spray air. As an extra precaution, open your drive’s disc tray and gently spray a can of spray air into it. This will remove any of the big pieces of dust that may be lurking inside the tray.
General Evaluation
1. Explain steps for cleaning the following (a) Keyboard (b) Monitor
2. List steps to clean DVD drive lens.
Weekend Assignment
SECTION A
Instruction: Choose the correct option from the ones lettered A to D
1. ___ is the first thing to do when cleaning a mouse (a) connect the mouse (b) disconnect the mouse (c) plug the mouse (d) do not touch the mouse
2. One of the following options is not a step to be taken when cleaning a mouse (a) remove the cable from the back of the computer case (b) use a vacuum cleaner to remove debris between the key. (c) use a wet a cloth (d) dampen a swab with isopropyl alcohol and clean between, around and on tap the keys
3. One of the following options is not a step to be taken when cleaning a monitor (a) unplug the power supply cord and cable from the back of the monitor and allow it to cool for at least 20 minutes(b) vacuum the outside of the monitor(c) lightly dampen a cloth with a mild soap solution and wipe down the outside plastic portions of the monitor(d) clean the monitor cables and power cord while they are connected
4. One of the following options is not a step to be taken when cleaning a keyboard
(a) remove the cable from the back of the computer case(b) use a vacuum cleaner to remove debris between the keys (c) aim between the keys and compressed air to remove the remaining dust and debris (d) wet cloth with soap solution and wipe down the outside of the keyboard
5. The first thing to do when cleaning a DVD Drive (a) connect the drive (b) disconnect
(c) purchase a DVD laser cleaning kit (d) do not touch the DVD
SECTION B
1. State one reason why you have to disconnect the cable before any cleaning
2. Explain steps for cleaning the following: (a) Keyboard (b) Monitor
SCHEME OF WORK FOR 3RD
TERM
CLASS
: SS1
|
WEEKS |
TOPICS |
|
1. |
Revision |
|
2. |
Word Processing : definition and uses |
|
3. |
Word Processing : examples of word
processing package; Ms office suite |
|
4. |
Word Processing : loading ,exiting
,creating , saving ,and retrieving files |
|
5. |
Spreadsheet : definition and uses |
|
6. |
Spreadsheet : examples ,using MS
EXCEL |
|
7. |
Spreadsheet : loading ,exiting , Ms excel
,creating ,saving and retrieving files |
|
8. |
Databases management : definition and
examples |
|
9. |
Database management : uses of Ms Access
and spreadsheet for database |
|
10. |
Database management : loading ,editing Ms
access, creating , saving and retrieving files |
|
11. |
Revision |
|
12. |
Examination |
WEEK 1 AND 2
Word
Processing
Word
processing means to use a computer to create, edit, format and print documents.
The great advantage of word processing over using a typewriter is that you can
make changes without retyping the entire document
Word
Processor
A
word processor is computer application software that enables a user to create a
document,editand format, store it electronically and print
Uses of Word
Processing
Some
of the functions of word processing software include:
·
Creating, editing, saving and printing documents.
·
Copying, pasting, moving and deleting text within a document.
·
Formatting text, such as font type, bolding, underlining or
italicizing.
·
Creating and editing tables.
·
Inserting elements from other software, such as illustrations
or photographs.
·
Correcting spelling and grammar.
Application
of Word Processor
A
word processor can be used for creating documents like :
·
Memo
·
Letters
·
Resumes
·
Examinations
·
Books
·
Invitations
·
Invoices
·
Postcard etc
EXERCISE
Define
the following terms
1.
Word processing
2.
Word processor
WEEK THREE
Examples Of
Word Processor
The
examples of word processor include the following
1. Word star
2. Microsoft Word
3. Word Perfect
4. Word Pad etc.
Features of
the word processor
The
basic features of the word processors are
1. Insert Text : allow you to insert text anywhere
2. Delete text : allows you to erase text , characters, words or lines
3. Cut ,copy , paste : cut allows you to move an item in
a copy mode, copy allows you to duplicate while paste allows you to insert an
item that has already being cut or copied
4. Page size and Margin : this allows you to adjust your
page size and margins
5. Search and replace: this allow you to search for a particular
word with the option of replacing it with another word .
Other
features of the standard Word processor are :
·
File management
·
Font specification
·
Headers , footers and page numbers
·
Layouts
·
Macros
·
Spell checkers
·
Thesaurus
·
Table of content and index.
Office Application
The
Microsoft Office suite incorporates the following:
1. Word Processori.e. Ms Word
2. Spread sheet i.e. Ms Excel
3. Presentation Package i.e.
Ms PowerPoint
4. Database Package i.e. Ms
Access
5. Web Page/ website
development package i.e Front Page
Common
features of the office suite
1. Title Bar : this is the to bar of the window that displays the name of
the active document and the application name.
2. Menu Bar : this is displayed under the title bar which contains some
categories of commands such as home , insert , page layout , references , review
, view etc.
3. Status Bar : it displays information about the current page number
4. Workspace : it is the area where actual work processing is done
5. Ruler : this display the current page width , left and right
margins and the set tab stop if any.
Entering
Text
To
enter text, just begin typing from the keyboard at the insertion point. The
insertion point moves to the right as you type. When you come to the end of the
line continue to type as you don’t need to press ENTER key before it automatically
goes to the next line.
Moving
around the document
Use
the following combination of keys to move around the document
|
Key combinations |
Movement |
|
Home |
Move to the beginning of the line |
|
End |
Move to the end of the line |
|
Ctrl + right arrow |
Move one word to the right |
|
Ctrl + left arrow |
Move one word to the left |
|
Ctrl + up arrow |
Moves to the previous paragraph |
|
Page up |
Move up one window |
|
Page down |
Move down one window |
|
Ctrl + Pgup |
Move up one page |
|
Ctrl + Pgdn |
Move down one page |
|
Ctrl + home |
Move to the top of the document |
|
Ctrl + End |
Move to the bottom of the document |
Selecting
Text with the Mouse
The
mouse is an excellent tool for selecting text in your document during the
editing process. The following steps guides you in text selection
1. Double clicking : double a word to select it
2. Triple clicking : triple in a paragraph to select it
3. Ctrl + click : is used for selecting a sentence
Font formatting
in Word processing
Formatting : this is the
manipulation carried out on the font . this is also called text called Text Formatting.
The
various text formatting includes :
1. Changing font : font is a
collection of letters ,numbers ,and special characters that contains the same
type face, thickness and size.
2. Changing font sizes : font sizes of characters can be
increased up to 72
3. Font Attribute : the following can be carried out on the font
i.
Bold
ii.
Italic
iii.
Underline
4. Font colours: the colour of the characters can be changed to a
suitable one
Page Setup
The
following can be done under page setup
1. Settings Margins
2. Setting Paper size
3. Page orientation
EXERCISE
State
the feautures of the word processor
WEEK FOUR
Closing the Ms Word
1. You can simply close your
document by clicking the close button on the database window
Exiting
Ms Word
After all present work have been saved ,
one can exit by :
1. Click
the Ms Office button 
at the top left corner of the window and click exit Word
2. Or
Using the keyboard shortcut : Alt + f4
Loading
Ms Word
1. From
the windows desktop (window 7) , click
the start button
2. Select
All programs
3. Navigate
to Ms Office and select Ms word
Creating
a New file
1. Click
the office button and then click New
2. Select
Blank document
Saving
A File
1. Click
Office button
2. Click
Save or use the keyboard Shortcut Crtl + S
Open
or Retrieve A File
1. Click
the office button
2. Click
the Open Button and select from the files you want to open .
Keyboard
shortcut :Crtl + o
EXERCISE
State the procedures on how to
1. load the Ms word
2. close the ms word
WEEK : FIVE
Spreadsheet
A spreadsheet is a sheet of paper that
shows accounting or other data in rows and columns; a spreadsheet is also a computer application program
that simulates a physical spreadsheet by capturing, displaying, and
manipulating data arranged in rows and columns.
Alternatively
referred to as a worksheet, a spreadsheet is a
file made of rows andcolumns that
help sort data, arrange data easily, and calculate numerical data.
What makes a spreadsheet software program
unique is its ability to calculate values using mathematical formulas and
the data in cells.
A good example of how a spreadsheet may be used is creating an overview of your
bank's balance. Below is a basic example of what a Microsoft Excel spreadsheet
looks like, as well as all the major portions of a spreadsheet highlighted.
What is an active
worksheet?
An active worksheet is
the worksheet that is currently open. For example, in the picture above, the
sheet tabs at the bottom of the window show "Sheet1",
"Sheet2", and "Sheet3", with Sheet1 being the active
worksheet. The active tab usually has a white background behind the tab name.
uses of spreadsheets.
Finance
Spreadsheets are great at
any financial data, such as your checking account information, budgets,
transactions, billing, invoices, receipts, forecasts, and any payment system.
Forms
Form templates can be
created to handle inventory, evaluations, performance reviews, quizzes, time
sheets, patient information, and surveys.
School and Grades
Teachers can use
spreadsheets to track students, calculate grades, and identify important data,
such as high and low scores, missing tests, and students who are struggling.
Lists
Managing a list in a
spreadsheet is a great example of data that does not contain numbers, but still
can be used in a spreadsheet. Great examples of spreadsheet lists include
telephone, to-do, and grocery lists.
Sports
Spreadsheets can keep
track of your favorite player stats or stats on the whole team. With the
collected data, you can also find averages, high scores, and other statistical
data. Spreadsheets can even be used to create tournament brackets.
EXERCISE
1. Define the spreadsheet
2. state 3 uses of the spreadsheet
WEEK
SIX
Examples of spreadsheet
programs
Today, Microsoft
Excel is the most popular and widely
used spreadsheet program, but there are also many alternatives. Below is a list
of spreadsheet programs that can be used to create a spreadsheet.
·
Google Docs -
(Online and free)
·
iWork Numbers -
Apple Office Suite
·
LibreOffice ->Calc
(Free)
·
Lotus
1-2-3 (Discontinued)
·
Lotus
Symphony - Spreadsheets
·
OpenOffice ->Calc
(Free)
·
VisiCalc (Discontinued)
Other examples and uses
of a spreadsheet
Although spreadsheets are
typically used with anything containing numbers, the uses of a spreadsheet are
almost endless. Below are some other popular
EXERCISE
State 6 examples of the spreadsheet
programs
WEEK SEVEN
How to
Start and Exit Excel 2010
Microsoft Office Excel 2010 provides several methods
for starting and exiting the program. You can open Excel by using the Start
menu or a desktop shortcut. When you want to exit Excel, you can do so by using
the File tab, the Close button, or a keyboard shortcut.
Starting Excel 2010 from the Start menu
To start Excel 2010 from the Windows Start menu,
choose Start→AllPrograms→MicrosoftOffice→Microsoft Excel 2010. A new, blank
workbook appears, ready for you to enter data.
Excel 2010
displays a new, blank workbook when you start the program.
Creating an Excel 2010 desktop shortcut
You may prefer having the Excel 2010 program icon
appear on the Windows desktop so that you can launch the program from there.
To create an Excel 2010 desktop shortcut, follow
these steps:
1.
Choose Start→AllPrograms→Microsoft Office.
2.
Right-click Microsoft Excel 2010, highlight Send To
on the shortcut menu, and click Desktop (Create Shortcut) on its continuation
menu.
A shortcut named Microsoft Excel
2010 appears on your desktop. You can rename the shortcut to something shorter,
such as Excel 2010.
3.
Right-click the Microsoft Excel 2010 icon on the
desktop and then click Rename on the shortcut menu.
4.
Replace the current name by typing a new shortcut
name, such as Excel 2010, and then click anywhere on the desktop.
Exiting Excel 2010
When you’re ready to quit Excel, you have several
choices for shutting down the program:
·
Choose File→Exit.
·
Press Alt+F4.
·
Click the Close button (the X) in the upper-right corner of the
Excel 2010 program window.
If you try to exit Excel after
working on a workbook and you haven’t saved your latest changes, Excel displays
an alert box asking whether you want to save your changes. To save your changes
before exiting, click the Save button. If you don’t want to save your changes,
click Don't Save.
Saving
A File
3. Click
Office button
4. Click
Save or use the keyboard Shortcut Crtl + S
Open
or Retrieve A File
3. Click
the office button
4. Click
the Open Button and select from the files you want to open .
Keyboard shortcut :Crtl + o
EXERCISE
State the procedures on how to
1. Load the Ms Excel
2. Close the Ms Excel
WEEK
EIGHT
DBMS - database management
system
Data
Data is the information in a form suitable for processing
by the computer, such as digital representation of numbers, text, graphic
images or sounds.
Database
A database of collection of related information organized
for rapid search and retrieval. Database can contain all types of data from an
address list to students’ scores and grades. Ms Access is a database program
that allows you to organize andmanipulates data in many different ways.
Database Management System (DBMS)
A database management system (DBMS)
is a collection of programs that
enables you to store,
modify, and extract information from a database.
There are many different types of database management systems, ranging from
small systems that run on
personal
computers to huge systems that run
on mainframes.
Examples of Dbms Packages
DBASE
RBASE
ACCESS
DATACOM/DB
DB2
FOXPRO
IDMS
INFOMIX
INGRES
ORACLE
PARADOX
SQL SERVER
SYBASE
SYSTEM 2000
Examples of Database Applications
The
following are examples of database
applications:
computerized library systems
automated teller machines
flight reservation systems
computerized parts inventory systems
A Microsoft
Access Interface
File
The collection of data that makes up a
computerized database must be stored physically on some computer storage
medium. The Dbms can then retrieve, update, and process this data as needed.
A file is a sequence of records.
Record
A database is a row of data in a database
table consisting of a single value from each column of data in the table. The
data in the column of a table are all of the same type of data, while the rows
represent a given.
Field
A field is a data element that is an
essential part of a data record. Withoutit, there would be no record in the
database.
Key
This is a field in a record that holds
unique data which identifies that record from other records in the file or database.
Examples of keys are Account no. , product code, student’s admission no. etc.
as an identifier, each key value must be unique in each record.
Types of keys in database include the
following:
1. Super
key
2. Candidate
key
3. Composite
key
4. Primary
key
Tables
A table in a ddatabase, alternatively known as
relation, is a two-dimensional structure used to hold related information. A
database consists of one or more related tables. it correspond to rows and
columns
Rows
A row in a table is a
collection or instance of one thing, such as a student’s one line record or one
line item on an invoice.
Column
A column contains all
information of a single type, and the piece of data at the intersection of a
row and a column, a field, is the smallest piece of information that can be
retrieved with the database’s query language.
An example of
column/field is the a field record of lastname
EXERCISE
Define The Folowing Terms
1. Database
2. Field/ column
3. Key
WEEK NINE
Advantages of
a DBMS
Advantages
of DBMS
The
database management system has promising potential advantages, which are
explained below:
1.
Controlling Redundancy: By having centralized database, repeated data that are not
necessary can be avoided. It is not possible that all redundancy should be
eliminated; however this redundancy can be controlled.
2.
Integrity can be enforced: Integrity of data means that data in database is always
accurate, such that incorrect information cannot be stored in database. In
order to maintain the integrity of data, some integrity constraints are
enforced on the database.
3.
Inconsistency can be avoided: When the same data is duplicated and changes are made at
one site, which is not propagated to the other site, it gives rise to
inconsistency. So, if the redundancy is removed chances of having inconsistent
data is also removed.
4.
Data can be shared: A database can be shared by multiple applications in
centralized DBMS as compared to file system, so now applications can be
developed to operate against the same stored data.
5.
Standards can be enforced : Since DBMS is a central system, so standard can be
enforced easily may be at Company level, Department level, National level or
International level.
6.
Restricting unauthorized access: When multiple users share a database but access to data and
information in the database will be controlled. For example, only authorized
persons are allowed to access account office data.
7. Providing Backup and Recovery: A
DBMS must provide facilities for recovering from hardware or software failures.
The backup and recovery subsystem of the DBMS is responsible for recovery.
Disadvantages
of DBMS
The
disadvantages of the database approach are summarized as follows:
1. Complexity : the
functionality of a good DBMS makes it an extremely complex piece of software.
2. Size : The complexity of the
DBMS makes it an extremely large piece of software, occupying many megabytes of
disk space large amounts of memory to run efficiently.
3. Performance: with the DBMS
written for many applications rather than just one, some applications may not
run as fast as they used to.
4. Higher impact of a failure: The
centralization of resources increases the vulnerability of the system
5. Cost of DBMS: The cost of
DBMS varies significantly, depending on the environment and functionality
provided.
6.
Additional Hardware costs: The disk storage requirements for the DBMS may necessitate
the purchase of additional storage space or even additional machines.
7.
Cost of Conversion: this include; the cost of converting existing applications
to new DBMS and hardware, cost of training staff to use the new systems and cost
of specialist staff to help with conversion and running of the system.
Applications
and Uses of MS-Access
1. Microsoft
Access Used For in Business
Microsoft Access can be used for business For example, you
want to make the data of financial report of your business.
2. Microsoft
Access Used For in Schools
MS Access can be used in administration and statistics. It
can also be used for the teachers and students to make the schedules and time
table
3. For Office
For office, there are many positions of people who often
work with database. For examples are secretary, HRD, and financial planner.
4. Microsoft
Access Used For In The Workplace
It can be used in some organizations for carrying out
activities such as are income and
outcome report, activity plan and reports.
5. For Programmer
Programmers also often work with database. Ms Access is
very useful for programmers to ease their activities related to programming.
WEEK
TEN
Loading the Microsoft Access
Open an Access database from Windows
Explorer
- In
Windows Explorer, navigate to the drive or folder containing the Access
database file you want to open and double-click the database.
Access starts and the database is opened.
Open
a database from within Access
If Access is already running, use the
following procedure to open a database:
- Click
the Microsoft Office Button , and
then click Open.
- Click
a shortcut in the Open dialog box, or in the Look
in box, click the drive or folder that contains the database that
you want.
- In
the folder list, browse to the folder that contains the database.
- When
you find the database, do one of the following:
- Double-click
the database to open it in the default mode specified in the Access
Options dialog box or the mode that was set by an administrative
policy.
- Click Open to
open the database for shared access in a multi-user environment so that
you and other users can read and write to the database.
- Click
the arrow next to the Open button and then click Open
Read-Only to open the database for read-only access so that you
can view but not edit it. Other users can still read and write to the
database.
- Click
the arrow next to the Open button and then click Open
Exclusive to open the database with exclusive access. When you
have a database open with exclusive access, anyone else who tries to open
the database receives a "file already in use" message.
- Click
the arrow next to the Open button and then click Open
Exclusive Read-Only to open the database for read-only access.
Other users can still open the database, but they are limited to read-only
mode.
Closing the Ms Access
2. You can simply close the
database by clicking the close button on the database window
Exiting
Ms Access
After all present work have been saved ,
one can exit by :
3. Click
the Ms Office button at the top left corner of the window and click exit Access 
4. Or
Using the keyboard shortcut : Alt + f4
Loading
Ms Access
4. From
the windows desktop (window 7) , click
the start button
5. Select
All programs
6. Navigate
to Ms Office and select Ms Access
Creating
a New file
3. Click
the office button and then
click New
4. Select
Blank Database or select from local templates
Saving
A File
5. Click
Office button
6. Click
Save or use the keyboard Shortcut Crtl + S
Open
or Retrieve A File
5. Click
the office button
6. Click
the Open Button and select from the files you want to open .
Keyboard
shortcut :Crtl + o