Computer Applications Revision

Computing Skills - 2

Session 1: Theory

• Gauging the level of understanding of the batch of level 1
• Revising operating system
• Recap on basics from Term 1 book:
  • Types of computers
  • Hardware and software
  • Operating system:
    • Windows 10 desktop
    • Icons
    • Background
    • Start menu
    • Search box
    • Task bar
    • Notification area
    • File explorer

Session 2: Theory

• Revising Internet and purposive surfing
• Revising Microsoft Word
• Covering basics from Term 1 book:
  • What is Internet?
  • IP address
  • Domain name
  • Web browsers
• Definitions of the above terms

Session 3-4: Practical

• Creating a file in MS Word with all the basic features covered in Semester 1

Session 5: Practical

• Internet surfing
• Creating a Google account and email
• Creating a spreadsheet and entering data in Microsoft Excel
• Saving, deleting, and moving around in a workbook

Session 6: Theory

• Recap of Semester 1:
  • Creating a spreadsheet and entering data
  • Saving, deleting, and moving around in a workbook
• Inserting a formula in Microsoft Excel
• Excel – copy and paste, paste special, find and replace, and special symbols and characters
• Adding a comment to a cell

Session 7-8: Practical

• Typing a table of two columns and inserting simple formulas using * and / in Microsoft Excel
• Copying and pasting the table in another sheet as such and with values
• Using the find and replace option
• Inserting 5 symbols and characters
• Inserting comments in two cells

Session 9: Theory

• Formatting cells for different types of data in Microsoft Excel
• Setting fonts, background color, text alignment, merge cells, wrap text, and shrink to fit
• Borders and shading

Session 10: Practical

• Creating a table and showing two font options
• Changing a background color
• Setting vertical and horizontal alignment
• Formatting the table with borders and shading
• Typing a header and merging it

Session 11: Theory

• Freezing panes in Microsoft Excel
• Conditional formatting
• Creating a formula
• Copying a formula

Session 12: Practical

• Creating a table with imaginary data and doing the following:
  • Freezing panes
  • Conditional formatting
  • Creating a formula
  • Copying a formula

Session 13: Theory

• Cell references in formula
• Using functions in Microsoft Excel
• Built-in functions

Session 14: Practical

• Creating cell references in formula – all types
• Inserting functions and using one built-in function from each category

Session 15: Theory

• Data filtering
• Data sorting
• Using ranges
• Using macros

Session 16: Practical

• Filtering and sorting a list created earlier
• Creating a macro to make a cell bold, italic, and underline
• Showing cell ranges

Session 17: Theory

• Cross referencing – VLOOKUP function
• Pivot table

Session 18: Practical

• Creating a pivot table report from a data table
• Showing the VLOOKUP function

Session 19: Theory

• Charts
• Pivot charts
• List of Excel keyboard shortcuts

Session 20: Practical

• Creating charts (bar, pie, and formatting)
• Creating a pivot chart
• Using keyboard shortcuts (any 10)

Session 21: Theory

• Introduction to Microsoft PowerPoint
• Areas in a standard PowerPoint file
• Creating a presentation

Session 22: Theory

• Adding new slides
• Entering text in boxes
• Adding a text box

Session 23-24: Practical

• Starting Microsoft PowerPoint
• Areas in a standard PowerPoint file
• Creating a presentation
• Adding new slides
• Entering text
• Adding a text box

Session 25: Theory

• Deleting an existing slide
• Rearranging slides
• Working with outlines

Session 26: Theory

• Sidebars
• Presentation views

Session 27: Practical

• Sidebars
• Presentation views
• Setting backgrounds
• Slide orientation

Session 28: Theory

• Saving presentations
• Reviewing presentations

Session 29: Theory

• Running a slideshow
• Using slide master

Session 30: Theory

• Saving a design template
• Adding pictures

Session 31: Practical

• Running a slideshow
• Using slide master
• Adding pictures

Session 32: Theory

• Adding and previewing animations
• Adding and previewing transitions

Session 33: Practical

• Adding and editing pictures/images in PowerPoint
• Saving and reviewing presentations

Session 34: Practical

• Adding animations and transitions
• Editing the above

Session 35-36: Practical

• Creating a full presentation using features studied in this section

Session 37: Theory

• Introduction to Cyber laws
• Categories of Cyber laws

Session 38: Theory

• Countering cyber crimes
• Software piracy
• Code of ethics - Dos and Don'ts

Session 39: Theory

• Introduction to MS Outlook
• Creating an account
• Creating a new mail message
• Adding an email signature

Session 40: Theory

• Using the calendar
• Creating a contact
• Adding notes/tasks
• Printing an email message, contact, or calendar item

Session 41: Theory/Practical

• Introduction to social media
• Various avenues
• Practical training

Session 42: Theory

• Introduction to video conferencing
• Types of video conference sessions
• Desktop conferencing
• Managing video conferencing
• Live streaming

Sessions 43-45: Practical

• Based on the vertical

• Related to the work situation to be conducted; different for each vertical### Microsoft Word

• Starting MS Word: various tabs, options under each tab

• Moving in the workbook with a keyboard/mouse

• Editing text: inserting, selecting, deleting, moving - sentence/paragraph

• Cut, copy, paste

• Find and replace

• Spell check and grammar

• Formatting text

• Password protection

• Types of paragraph alignment

• Format painter

Computing Skills - Practical Tasks

• Create a new file, type a paragraph, and perform various tasks:
  • Cut, copy, paste
  • Bold, italic, underline
  • Paragraph alignment
  • Edit/delete text
  • Insert page numbers
  • Insert table
  • Header and footer
  • Check spelling and grammar
  • Word art
  • Change text color/font
  • Bullets and numbering
  • Save file
  • Rename file
  • Password protect the file
  • Other features based on student requests

Internet Surfing and Email

• Open web browsers
• Browse for 'top business news of the day', pick up 3 important pages, and save the same
• Send/reply and forward an email to/from a friend, inviting them for a birthday party, using formatting tools available in Gmail
• Learn to upload/download files from Google Drive
• Use Google Talk and transfer files using it

Microsoft Excel

• Revising basics of MS Excel from Semester 1:
  • Creating a spreadsheet and entering data
  • Saving, deleting a workbook
  • Moving around in the workbook
• Excel overview: file tab, ribbons, title bar, sheet area, view buttons
• Entering data
• Moving on the spreadsheet with the keyboard and mouse
• Saving a workbook
• Inserting/hiding sheets
• What is a cell/row/column

Excel Formulas and Functions

• Inserting a formula: typing the formula in the formula bar and pressing enter or the navigation key
• Copying and pasting: using the copy paste option in different ways, including:
  • Method 1: selecting the cells to copy, right-clicking, and selecting paste
  • Method 2: using the Office Clipboard
• Paste special: options for pasting, including:
  • All
  • Formulas
  • Values
  • Formats
  • Comments
  • Validation
  • All using source theme
  • All except borders
  • Column width
  • Formulas & Number Formats
  • Values & Number Formats
  • Merge Conditional Formatting
  • Transpose

Excel Find and Replace

• Accessing the Find & Replace feature: using the Home -> Find & Select -> Find option or pressing Control + F key
• Find and Replace dialogue: options for searching and replacing text, including:
  • Within: specifying the search should be in the sheet or workbook
  • Search By: specifying the internal search method by rows or by columns
  • Look In: specifying if the search should be in the formula as well
  • Match Case: specifying if the search should match the case
  • Match Entire Cell Content: specifying if the search should match the exact cell content

Excel Special Symbols and Characters

• Inserting special symbols: using the Insert -> Symbols -> Symbol option
• Viewing available symbols: including Pi, alpha, beta, etc.
• Inserting special characters: using the Insert -> Symbols -> Special Characters option
• Viewing available special characters: including Copyright, Registered, etc.

Excel Comments

• Adding a comment to a cell: using the Review -> Comments -> New Comment option or right-clicking and selecting Insert Comment
• Modifying a comment: selecting the cell, right-clicking, and selecting Edit Comment### Computing Skills - 2

Formatting a Comment

• Right-click on a cell to edit a comment, select the comment, right-click on it, and format the comment.
• Options available for formatting a comment include changing the color, font, size, etc.

Session 8

Confirmation on practicals

• Tasks include:
  • Typing a table with two columns and inserting simple formulas using * and /
  • Copying and pasting the table in another sheet with values
  • Using the find and replace option
  • Inserting 5 symbols and characters
  • Inserting comments in two cells

Session 9

Session Objectives

• Format cells for different types of data
• Set fonts in Excel
• Change background color
• Set text alignment
• Merge cells
• Wrap text and shrink to fit
• Apply borders and shading

Formatting Cells

• Format cells for different types of data, such as numbers, currency, dates, etc.
• Options available:
  • General: default cell format
  • Number: displays cell as a number with a separator
  • Currency: displays cell as currency with a currency sign
  • Accounting: similar to currency, used for accounting purposes
  • Date: various date formats available
  • Time: various time formats available
  • Percentage: displays cell as a percentage with decimal places
  • Fraction: displays cell as a fraction
  • Scientific: displays cell as an exponential
  • Text: displays cell as normal text
  • Special: special formats for cells, such as Zip code or Phone Number
  • Custom: allows custom formatting using a specific format

Setting Fonts

• Set fonts in Excel using the Home tab, Font group, or by right-clicking on the cell, selecting Format cells, and then Font Tab
• Options available:
  • Font style
  • Font size
  • Font color

Changing Background Color

• Change background color using the Home tab, Font group, or by right-clicking on the cell, selecting Format cells, and then Font Tab
• Options available:
  • Background color
  • Foreground color

Text Alignment

• Horizontal alignment options:
  • Left: aligns cell contents to the left side of the cell
  • Center: centers cell contents in the cell
  • Right: aligns cell contents to the right side of the cell
  • Fill: repeats cell contents until the cell's width is filled
  • Justify: justifies text to the left and right of the cell
• Vertical alignment options:
  • Top: aligns cell contents to the top of the cell
  • Center: centers cell contents vertically in the cell
  • Bottom: aligns cell contents to the bottom of the cell
  • Justify: justifies text vertically in the cell

Merging Cells

• Merge cells to combine multiple cells into a single cell
• Options available:
  • Merge & Center: merges cells and centers the contents
  • Merge Across: merges cells across multiple rows
  • Merge Cells: merges cells without applying center attribute
  • Unmerge Cells: unmerges cells

Wrap Text and Shrink to Fit

• Wrap text to fit the column width
• Options available:
  • Wrap text
  • Shrink to fit

Borders and Shading

• Apply borders to cells using the Home tab, Font group, or by right-clicking on the cell, selecting Format cells, and then Border Tab
• Options available:
  • Border style
  • Border color
• Apply shading to cells using the Home tab, Font group, or by right-clicking on the cell, selecting Format cells, and then Font Tab
• Options available:
  • Shading color

Session 10

Confirmation on practicals

• Tasks include:
  • Creating a table with 5 columns and showing different cell formats for each column
  • Showing two font options in Excel
  • Changing the background color to yellow
  • Applying vertical and horizontal alignment
  • Formatting the table with borders and shading
  • Typing a header and merging it to cover the 5 columns

Session 11

Session Objectives

• Freeze panes
• Conditional formatting
• Creating a formula
• Copying a formula

Freeze Panes

• Freeze panes to keep row or column headings visible when scrolling
• Options available:
  • Freeze Panes: to freeze area of cells
  • Freeze Top Row: to freeze the first row of the worksheet
  • Freeze First Column: to freeze the first column of the worksheet

Conditional Formatting

• Use conditional formatting to highlight cells that meet certain conditions
• Options available:
  • Highlight Cells Rules: to highlight cells that contain certain values, text, or dates
  • Top/Bottom Rules: to highlight top and bottom values, percentages, and above and below average values
  • Data Bars: to indicate cell values relative to each other using data bars
  • Color Scales: to indicate cell values relative to each other using color scales
  • Icon Sets: to indicate cell values relative to each other using icons
  • New Rule: to define a custom conditional formatting rule
  • Clear Rules: to remove conditional formatting rules
  • Manage Rules: to edit and delete conditional formatting rules

This quiz covers topics from computer applications, including operating systems, internet surfing, and Microsoft Word. It's ideal for students revising for their semester 1 exams.