100% found this document useful (1 vote)
3K views4 pages

Computer Fundamentals Course Syllabus

This document outlines the course objectives, contents, and textbooks for a course on basics of computers and MS Office applications. The course aims to provide basic knowledge of computers and their applications. It is divided into 5 units that cover basics of computer systems, using MS Word, Excel, PowerPoint, and the internet/email. The labs complement the lectures and allow students hands-on practice with using the mouse, windows explorer, word processing, spreadsheets, presentations, and email.

Uploaded by

Navneet Vishnoi
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
100% found this document useful (1 vote)
3K views4 pages

Computer Fundamentals Course Syllabus

This document outlines the course objectives, contents, and textbooks for a course on basics of computers and MS Office applications. The course aims to provide basic knowledge of computers and their applications. It is divided into 5 units that cover basics of computer systems, using MS Word, Excel, PowerPoint, and the internet/email. The labs complement the lectures and allow students hands-on practice with using the mouse, windows explorer, word processing, spreadsheets, presentations, and email.

Uploaded by

Navneet Vishnoi
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
  • Unit 4: MS-PowerPoint
  • Unit 2: MS-Word
  • Unit 3: MS-Excel
  • Unit 1: Basics of Computer System
  • Unit 6: Text Books
  • Unit 5: Internet & its Applications
  • Lab Content: Computer Fundamentals & MS-Office Lab
  • Internet & Email

Basics of Computer & its Applications

L-3, T-2, P-0, C-4


Course Code: BCH-104, BCP-104, BBA-204, AR-353, BAG-206, BJM-105, BFA-203,
BML-107, BRT-107, BCO-108, BBN-107, BSA-101, BCA-103, CSC-101, ICA-106, BCA107, BPH-204, DIP-106/206, BCS-301/401, ECS-101/201
Objective: To give the basic knowledge of Computer & its applications to the
students.
Course Contents
UNIT-1
Basics of Computer System: Definition, Characteristics of Computers, Basic
Applications of Computer, Generations of computers. Components of Computer
System: Central Processing Unit (CPU), input/output Devices, computer Memory:
primary and secondary memory, magnetic and optical storage devices, Concepts of
Hardware and Software. Introduction of number system.
(Lecture 8)
UNIT-2
Using MS-Word: Overview of Word processor, Basics of Font type, size, color,
Effects like Bold, italic , underline, Subscript and superscript, Case changing options,
Inserting, deleting, undo and redo, Copy and Moving (cutting) text within a
document, Formatting Paragraphs and Lists Setting line spacing; single, Page
settings and margins including header and footer, Spelling and Grammatical checks,
Table and its options, Inserting rows or columns, merging and splitting cells,
Arithmetic Calculations in a Table, Working with pictures, Inserting Pictures from
Files, Using Drawings and WordArt; Lines and Shapes, Modifying Drawn Objects,
Formatting Drawn Objects, options for Creating and Modifying a WordArt Object.
(Lecture 8)
UNIT-3
Using MS-Excel: Introduction to data, Cell address, Excel Data Types, Concept of
Hyperlink, Introduction to formatting, number, text and date formatting, Concept of
worksheet and workbook, Understanding formulas, Operators in Excel, Operators
Precedence, Understanding Functions, Common Excel Functions such as sum,
average, min, max, date, transpose, In, And, or, sqrt, power, upper, lower, Types of
graphics: Word art, auto shapes , Images, Introduction to charts, overview of
different types of charts available with Excel, Concept of print area, margins,
header, footer and other page setup options.
(Lecture 8)
UNIT-4
Using MS-Power Point: Outline of an effective presentation, starting a New
Presentation Files, Saving work, creating new Slides, Working with textboxes.
Changing a slides Layout, Applying a theme, Changing Colors, fonts and effects,
Creating and managing custom Color & font theme, changing the background.
Managing slides master, Managing theme. Changing the font, font size, font color,
texts fill. Working with drawing tools, Applying shape or picture styles, Embed a
video, Link to a video, Size a video, Video playback options, Configuring a sound

playback, Assigning sound to an object, Adding a digital music sound track,


Transition effects and timings.
(Lecture 8)
UNIT-5
Internet and its application
Introduction, Internet evolution, Working of Internet, Use of Internet. Overview of
World Wide Web (Web Server and Client), Introduction to Search engine and
Searching the Web, Downloading files Introduction to Web Browsers, Working with Email (creation and use of the same)

Images and their formats, Image editing- tools and techniques, Image capturing, digital image,
bit depth, resolution, color modes, aspect ratio., Printing of documents, print set up, print
preview.

(Lecture 8)
Text Books:
1. Sinha P.K., Computer Fundamentals, BPB Publishing.
2. OLeary Timothy, OLeary Linda, Microsoft Office2007,TMH Publication
3. Adobe Photoshop CS5 Classroom in a Book (Author: Adobe Creative Team) Adobe
Press
Reference Books:
1. Leon A. & Leon M., Introductions to Computers, Vikas Publication.
2. Cyganski, Information Technology:Inside and outside, Pearson Education.
3. Norton Peter, Introductions to Computers, TMHPublication.
4. Price Michael, Office 2010 in Easy Steps ,TMH Publication.
*Latest editions of all the suggested books are recommended

Computer Fundamental & MS-Office Lab


Lab Contents

L-0, T-0, P-4, C-2

The User Interface


Using Mouse and Moving Icons on the screen, The My Computer Icon, The Recycle
Bin, Status Bar, Start and Menu & Menu selection, Running an Application, Windows
Explorer Viewing of File, Folders and Directories, Creating and Renaming of files and
folders.
MS-Word
An Introduction to Word Processing, Opening Word Processing Package, the Menu
Bar, Using the Help, Using the Icons below menu bar, Opening Documents, Save
and Save AS, Page Setup, Printing of Documents, Display/Hiding of Paragraph Marks
and Inter Word Space, Moving Around in a Document, Scrolling the Document,
Scrolling by line/paragraph, Fast Scrolling and Moving Pages, Using a
Document/Help Wizard, Paragraph and Tab Setting, Text Selection, Cut, copy and
paste, Font and Size selection, Bold ,Italic and Underline, Alignment of Text: Center,
Left, right and Justify, Changing font, Size and Color, Paragraph indenting, Bullets
and Numbering, Use of Tab and Tab setting, Changing case, Opening and closing of
Multiple documents, Cut, Copy and Paste across the documents, Saving of Clip
boards, Draw Table, Changing cell Width and Height, Alignment of Text in Cell,
Delete/insertion of row and columns, Borders for Table.
MS-Excel
Application/usage of Electronic Spread Sheet, Opening of Spread Sheet, The menu
bar, Creation of cells and addressing of cells, Enter texts numbers and dates,
Creation of tables Cell Height and Widths, Copying of cells, Providing Formulas,
Using basic functions / formalism a cell, Sum function, Average, Percentage, Other
basic functions
Spread sheets for Small accountings: Maintaining invoices/budgets, Totaling of
various transactions, maintaining daily and monthly sales reports.
MS-Power Point
Difference between presentation and document, Opening a Power Point
Presentation, Using Wizard for creating a presentation, Creation of Presentation:
Title, Text Creation, Fonts and Sizes, Bullets and indenting, Moving to Next Slide,
Selection of type of Slides, Importing text from word documents, The Slide manager,
Slide Designs, Background and Text colors, Making your own slide format, Footnotes
and slide numbering, Slide Manipulation and Slide Show, Using the Slide Show,

Printing the Slides and Handouts, Slide sorter, Title sorter. Making of a photo album,
linking of video & sound files.
Internet & Email
Surfing the Internet: Giving the URL address, Search, Moving Around in a web-site,
Printing or saving portion of web pages, Downloading.
Basic of electronic mail: Email addressing, Mailbox: Inbox and outbox, Viewing an
email, Sending an Email, Saving mails, Sending same mail to various users, Sending
soft copy as attachment, Enclosures to email, Sending a Portion of document as
email.

Common questions

Powered by AI

The evolution of the Internet—from its beginnings as a Pentagon-funded network (ARPANET) for military communication to a global network—has broadened its applications vastly. Today, the Internet forms the backbone of digital connectivity and impacts everyday life through services like social networking, e-commerce, online education, entertainment, and information dissemination. Its development has enabled extensive digital communication platforms such as email, social media, and various web services, making information and communication more accessible and efficient .

Formatting in MS Word significantly enhances document readability and professionalism. Proper use of fonts, sizes, colors, paragraph spacing, and styles (such as headings, tables, and bullet points) makes documents more visually appealing and easier to navigate. Consistent formatting ensures that the document is organized and highlights key information effectively, improving reader comprehension. Professional formatting reflects attention to detail and can impact the perceived credibility and quality of the document, especially in business and academic contexts .

Slide master management in MS PowerPoint is crucial for maintaining consistency across a presentation. By setting uniform styles for fonts, colors, themes, backgrounds, and effects through the slide master, users ensure that all slides adhere to the same design standards, enhancing the overall professionalism and cohesiveness of the presentation. This uniformity is particularly important in corporate and educational settings, where consistency reflects attention to detail and helps to convey a clear, unified message .

Understanding operators and operator precedence is essential in MS Excel for creating accurate and efficient formulas. Operators such as addition, subtraction, multiplication, and division dictate how calculations are performed. Operator precedence determines the order of operations, similar to mathematical rules (PEMDAS/BODMAS), ensuring that calculations yield correct results by prioritizing operations accordingly. This understanding helps prevent errors, enhances computational reliability, and allows users to construct complex formulas that drive data analysis effectively .

Different types of charts in MS Excel—such as bar charts, line graphs, pie charts, and scatter plots—serve various data visualization needs, enhancing the presentation and interpretation of complex datasets. Bar charts effectively compare quantities across different categories, line graphs track changes over time, pie charts show proportions and percentages of a whole, and scatter plots depict correlations between variables. Each chart type helps in discovering patterns, trends, and insights that might not be immediately apparent from raw data, thus facilitating comprehensive analysis .

Digital image editing tools offer substantial benefits by allowing users to enhance image quality, correct flaws, and creatively transform images with filters, layers, and effects. They enable precise modifications such as adjusting bit depth, resolution, and color modes, aiding in professional photo editing and creative projects. However, the limitations include a steep learning curve for mastering advanced features, potential quality degradation if not done properly, and ethical concerns regarding authenticity. Despite these challenges, skillful use of these tools provides users versatile capabilities in digital creative expressions .

Computers are defined by several key characteristics, including speed, accuracy, diligence, storage capacity, and versatility. They can perform complex calculations quickly and accurately, and unlike humans, they do not suffer from fatigue over repeated tasks, ensuring consistent performance. Computers have extensive storage capabilities and can process various types of data activities ranging from data computation to multimedia processing, highlighting their versatile nature .

MS PowerPoint features such as transitions and animations can significantly enhance viewer engagement by adding visual interest and highlighting important points. Transitions between slides and animations of text and objects create a dynamic flow, keeping the audience's attention. They can emphasize key messages, demonstrate changes over time, or show processes step-by-step. However, excessive or inappropriate use may distract, so balance and relevance are essential to maintain focus on the presentation content .

Primary memory, also known as RAM, is volatile memory used for temporarily storing data and programs that are actively being used by the CPU during processing. It enables the quick access and execution of applications. In contrast, secondary memory is non-volatile, storing data permanently. It includes devices like hard drives, SSDs, and CDs, used for long-term data storage. While primary memory is faster, it has less capacity compared to secondary memory, which is slower but capable of holding larger volumes of data .

Email communication is a cornerstone of modern business, offering benefits such as instantaneous global communication, documentation of interactions, and the ability to send attachments. Its asynchronous nature allows recipients to respond at their convenience, facilitating international operations. However, challenges include information overload, security risks from phishing and spam, and potential misinterpretation of messages without non-verbal cues. Despite these challenges, email remains a highly effective tool for professional interactions when managed with best practices .

Basics of Computer & it’s Applications
L-3, T-2, P-0, C-4
Course Code:  BCH-104, BCP-104, BBA-204, AR-353, BAG-206, BJM-105,
playback,  Assigning  sound  to  an  object,  Adding  a  digital  music  sound  track,
Transition effects and timings.
Computer Fundamental & MS-Office Lab
Lab Contents
Printing the Slides and Handouts, Slide sorter, Title sorter. Making of a photo album,
linking of video & sound files.
Intern

You might also like