Download Computer Application-Computer Science-Assignment and more Exercises Computer Applications in PDF only on Docsity!
WARNING
1. PLAGIARISM OR HIRING OF GHOST WRITER(S) FOR SOLVING
THE ASSIGNMENT(S) WILL DEBAR THE STUDENT FROM AWARD
OF DEGREE/CERTIFICATE, IF FOUND AT ANY STAGE.
2. SUBMITTING ASSIGNMENTS BORROWED OR STOLEN FROM
OTHER(S) AS ONE’S OWN WILL BE PENALIZED AS DEFINED IN
Course: Computer Applications for Business (184) Semester: Spring 2012
Level: BBA Total Marks: 100
Pass Marks: 40
ASSIGNMENT No. 1
Note: All questions are compulsory and carry equal marks. Q. 1 Describe the different types of computers. What are the advantages and drawbacks of each? Explain.
Q. 2 Discuss the use of various components of MS Word window.
Q. 3 Write the procedure to develop/format a webpage for your organization using MS Word.
Q. 4 Discuss the application of Worksheets/Workbooks in businesses. Support your answer with atleast two examples of different organizations.
Q. 5 Write the procedure for creating, editing, formatting, moving, and sizing bar charts in MS Excel.
ASSIGNMENT No. 2
Total Marks: 100
Pass Marks: 40
Note: All questions are compulsory and equal marks.
Q. 1 How are different statistical and financial functions used in a worksheet? Explain with examples.
Q. 2 Differentiate the following: i. Hard and Soft Return ii. Insert and Overtype Modes iii. Save and Save as Commands iv. Table and Database v. Forms and Reports
Q. 3 Write down the procedure to design or develop a database in MS Access.
Q. 4 To prepare a business presentation, how can you apply different themes, background styles, background picture, and animations in MS PowerPoint? Explain with an example.
Q. 5 Discuss the social and ethical impact of Information Technology on our society.
COMPUTER APPLICATIONS FOR BUSINESS
Course Outline (BBA-184)
Unit - 1: Fundamentals of Computers Concepts and Introduction to Windows Vista
- Basics of computers and computing functions
- The rise of the computer and its types
- Computer equipment, hardware and software's and its safety measures
- Common type of business packages
- Introduction to Windows Vista
- Using start menu and managing windows - Resizing, moving, and scrolling windows
- Common features in computer application packages
- Managing folders
- Working with files and folders
Unit - 2: Computer Application Package for Word Processing in Business Development of Complex Business Reports- I
- Creating word processing documents
- Applying editing techniques on the document text
- Applying text enhancements through fonts and fonts styles and highlighting text to give a distance look
- Applying special formatting and aligning business text documents
- Automatically numbering or bulleting lists, giving date and time
- Using the spelling and grammar checker
- Printing documents after print preview, inserting page break, changing page orientation and paper size, aligning text vertically and setting margins
- Formatting pages and setting text flow options
- Changing text and paragraph layout
Unit - 3: Computer Application Package for Word Processing in Business and Development of Complex Business Reports - II
- Constructing high quality tables in the business documents and reports, creating and revising tables, modifying table structure and formatting tables
- Using styles templates and shortcut
- Creating and modifying and outlines with or without help of templates
- Managing data in word processing computer application packages
- Creating and manipulating data sources and the concept of mail merger
- Managing data in word processing documents
- Saving web pages in the word processing packages
- The usage of worksheets in processing business transactions such as payroll, invoicing, accounts receivable, cash receipts, purchasing and receiving transactions, inventory control, vendor evaluation, development of general ledger, and financial statements
Unit -6-7 Data Base Management Packages
- Planning and creating tables by using any data base application package, designing a data base determining need or purpose deciding what should be included in data base and determining table fields, deciding how tables or related and design review, populating the data base and creating forms and reports from the data base
- Creating a data base and a table, entering modifying and saving a table in the existing or any previous version of the package, comparing the data
- Creating and using fonts, auto fonts, entering, editing and printing forms, sorting records and searching for records
- Modifying tables, modifying field properties, adding objects to records and working with name auto correct
- Modifying tables and field properties, adding objects
- Working the external data, importing data verses linking to a spreadsheet or data base
- Creating the relational data base, setting lookup fields, working with relationships, setting referential integrity, creating relationships, drilling down into tables
- Enhancing and creating fonts for multiple tables, modifying form design, relative sizing and alignment, re-arranging the tab order, formatting data in form view, adding control to forms and changing properties of forms and control
- Designing reports and report snap shots, creating a report, generating auto reports, using of report wizard, modifying the report, specifying dates and page number codes in the reports, changing sort order and grouping levels, adding and deleting report control, application of report snap shots
- Viewing pages saved in the database management packages, understanding database pages, creating auto pages, application of page wizard entering and editing data in database application software packages
- Creating from an existing web page
- Modifying data page design
- Creating and viewing database management pages on the web
- Retrieval of customize sets of data from the table using queries, creating queries and crossed tab queries
Unit - 8: Creating Desktop Publishing of Business Documents
- Creating business presentations using MS PowerPoint: opening, viewing and saving a presentation
- Editing and formatting a PowerPoint presentation
- Printing and using headers and footers
- Slide Sorter view, inserting and formatting pictures, shapes and clip arts
- Applying themes and background styles, formatting background with a picture, changing font themes and applying animations
- Creating and formatting tables and charts
Unit - 9: Business Application Packages on Time Management, Office Management and Controlling Electronic Mails
- Application packages to monitor and manage office appointments, contacts, needing e-mail messages, tasks to perform projects on hand, and notes
- Understanding the basic desktop information manger application package
- Navigating the package
- Entering and organizing data of office manger/executives
- Tracking contacts, adding contacts, adding another contact from the same organization, viewing contacts and communicating contacts
- Viewing the days information, customizing the day’s view
- Using the package as electronic mail client, creating receiving and keeping track of electronic mail
- Creating tracking and managing tasks of the particular day/week/ month/year
- Viewing, navigating and keeping calendar in the application package, scheduling appointment
- Creating shortcuts and new shortcut groups
- Using journal and notes, the procedure of automatically recording journal events, the procedure of manually recording journal events, locating events and creating notes
- Managing data and files in the package and integrating the modules of the package, creating custom view.
Recommended Book: Exploring Microsoft Office 2007 by: Gaskin, Ferret, Vargas, Mclellan, Fry, Townsend, and Coyle
