AA-110: Computer Fundamentals Practice syllabus for AA 1st Year C20 regulation APSBTET

Computer Fundamentals Practice detailed syllabus for Diploma in Architectural Assistantship (AA) for C20 regulation curriculum has been taken from the APSBTET official website and presented for the AA students. For course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below.

For Diploma in Architectural Assistantship 1st Year scheme and its subjects, do visit AA 1st Year C20 regulation scheme. The detailed syllabus of computer fundamentals practice is as follows.

Course Objectives

For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.

Course Outcomes:

At the End of the Course Students Will be able To

Identify hardware and software components
Prepare documents with given specifications using word processing software
Use Spread sheet software to make calculation and to draw various graphs / charts.
Use Power point software to develop effective presentation for a given theme or topic.
Edit digital or scanned images using Photoshop

I. Computer Hardware Basics

To Familiarize with Computer system and hardware connections
To Start and Shut down Computer correctly
To check the software details of the computer
To check the hardware present in your computer

II. Windows’S Operating System

III. Practice With Ms-Word

To familiarize with Ribbon layout of MS Word

Home – Insert- Page layout – References – Review- View.

To practice Word Processing Basics
To practice Formatting techniques
To insert a table of required number of rows and columns
To insert Objects, Clipart and Hyperlinks
To use Mail Merge feature of MS Word
To use Equations and symbols features

IV.Practice With Ms-Excel

To familiarize with MS-EXCEL layout
To access and enter data in the cells
To edit a spread sheet- Copy, Cut, Paste, and selecting Cells
To use built in functions and Formatting Data
To create Excel Functions, Filling Cells
To enter a Formula for automatic calculations
To sort and filter data in table.
To present data using Excel Graphs and Charts.
To develop lab reports of respective discipline.
To format a Worksheet in Excel, Page Setup and Print

V. Practice With Ms-Powerpoint

To familiarize with Ribbon layout features of PowerPoint 2007.
To create a simple PowerPoint Presentation
To set up a Master Slide in PowerPoint
To insert Text and Objects
To insert a Flow Charts
To insert a Table
To insert a Charts/Graphs
To insert video and audio
To practice Animating text and objects
To Review presentation

Vi. Practice With Adobe Photoshop

1.To Familiarize With Computer System and Hardware Connections

Identify the parts of a Computer system:
CPU

Mother Board
Monitor
CD/DVD Drive

Power Switch

Start Button
Reset Button

Identify and connect various peripherals
Identify and connect the cables used with computer system
Identify various ports on CPU and connect Keyboard & Mouse Connect cables to external hardware and operate the computer

2.To Start and Shut Down Computer Correctly

Log in using the password
Start and shut down the computer
Use Mouse and Key Board
Login and logout as per the standard procedure
Operate mouse &Key Board

3.To Explore Windows Desktop

Familiarize with Start Menu, Taskbar, Icons and Shortcuts
Access application programs using Start menu, Task manager
Use Help support
Access application programs using Start menu
Use taskbar and Task manager

4.To Check the Software Details of the Computer

6.Working With Files and Folders

Create folders and organizing files in different folders
Use copy / paste move commands to organize files and folders
Create files and folders Rename , arrange and search for the required folder/file
Working with Files and Folders Continued….
Arrange icons – name wise, size, type, Modified
Search a file or folder and find its path
Create shortcut to files and folders (in other folders) on Desktop
Familiarize with the use of My Documents
Familiarize with the use of Recycle Bin
Restore deleted files from Recycle bin

8.To Familiarize With Ribbon Layout of Ms Word. – Home – Insertpage Layout-References-Review-View

Create/Open a document
Use Save and Save as features
Work on two Word documents simultaneously
Choose correct Paper size and Printing options
Create a Document and name appropriately and save
Set paper size and print options

9.To Practice Word Processing Basics

Typing text
Keyboard usage
Use mouse (Left click / Right click / Scroll)
Use key board and mouse to enter/edit text in the document.
Use Keyboard shortcuts
Use Find and Replace features in MS- word f. Use Undo and Redo Features
Use spell check to correct Spellings and Grammar
Use shortcuts c. Use spell check/ Grammar features for auto corrections.

10.To Practice Formatting Techniques

Formatting Text b.Formatting Paragraphs
Setting Tabs
Formatting Pages
The Styles of Word
Insert bullets and numbers
Themes and Templates
Insert page numbers, header and footer
Format Text and paragraphs and use various text styles.
Use bullets and numbers to create lists
Use Templates /Themes
Insert page numbers date, headers and footers

11.To Insert a Table of Required Number of Rows and Columns

Edit the table by adding the fields – Deleting rows and columns -inserting sub table -marking borders. Merging and splitting of cells in a Table
Changing the background colour of the table
Use table design tools
Use auto fit – fixed row/ column height/length – Even distribution of rows / columns features
Convert Text to table and Table to Text
Use Sort feature of the Table to arrange data in ascending/descending order
Insert table in the word document and edit
Use sort option for arranging data.

12.To Insert Objects, Clipart and Hyperlinks

Create a 2-page document. &Insert hyperlinks and t Bookmarks.
Create an organization chart
Practice examples like preparing an Examination schedule notice with a hyperlink to Exam schedule table.
Insert hyperlinks &Bookmarks
Create organization charts/flow charts

13.To Use Mail Merge Feature of Ms Word

Use mail merge to prepare individually addressed letters
Use mail merge to print envelopes. Use Mail merge feature

14.To Use Equations and Symbols Features.

Explore various symbols available in MS Word
Insert a symbol in the text c. Insert mathematical equations in the document Enter Mathematical symbols and Equations in the word document

15.To Practice With Ms- Excel

Open /create an MS Excel spreadsheet and familiarize with MS Excel 2007 layout like MS office Button-
Use Quick Access Toolbar- Title Bar- Ribbon-Worksheets- Formula Bar-Status Bar
Familiarize with excel layout and use
Use various features available in toolbar

16. to Access and Enter Data in the Cells

Move Around a Worksheets-Quick access -Select Cells
Enter Data-Edit a Cell-Wrap TextDelete a Cell Entry-Save a FileClose Excel
Access and select the required cells by various addressing methods
Enter data and edit

17.To Edit Spread Sheet Copy, Cut, Paste, and Selecting Cells

Insert and Delete Columns and Rows-Create Borders-Merge and Center
Add Background Color-Change the Font, Font Size, and Font Color
Format text with Bold, Italicize, and Underline-Work with Long Text-Change a Column’s Width Format the excel sheet

18. to Use Built in Functions and Formatting Data

Perform Mathematical Calculations verify -AutoSum b.Perform Automatic Calculations- Align Cell Entries Use built in functions in Excel

19.To Enter a Formula for Automatic Calculations

Enter formula
Use Cell References in Formulae
Use Automatic updating function of Excel Formulae d.Use Mathematical Operators in Formulae e.Use Excel Error Message and Help Enter formula for automatic calculations

20.To Create Excel Functions, Filling Cells

Use Reference Operators
Work with sum, Sum if , Count and Count If Functions
Fill Cells Automatically
Create Excel sheets involving cross references and equations
Use the advanced functions for conditional calculations

21.To Sort and Filter Data in Table

Sort data in multiple columns
Sort data in a row
Sort data using Custom order
Filter data in work sheet
Refine the data in a worksheet and keep it organized
Narrow a worksheet by selecting specific choice

22.To Practice Excel Graphs and Charts

Produce an Excel Pie Chart
Produce
Excel Column Chart
Use data in Excel sheet to Create technical charts and graphs Produce Excel Line Graph
Produce a Pictograph in Excel

23.To Develop Lab Reports of Respective Discipline Create Lab Reports Using Ms Word and Excel

Insert Practical subject name in Header and page numbers in Footer

24.To Format a Worksheet in Excel, Page Setup and Print

Shade alternate rows of data
Add currency and percentage symbols
Change height of a row and width of a column
Change data alignment
Insert Headers and Footers
Set Print Options and Print
Format Excel sheet b. Insert headers &footers and print

25.To Familiarize With Ribbon Layout &Features of Powerpoint 2007. Use Various Options in Powerpoint

Home
Insert
Design
Animation
Slideshow
View
Review Access required options in the tool bar

26.To Create a Simple Powerpoint Presentation

Insert a New Slide into PowerPoint
Change the Title of a PowerPoint Slide
PowerPoint Bullets
Add an Image to a PowerPoint Slide
Add a Textbox to a PowerPoint slide
Create simple PowerPoint presentation with photographs/ClipAr t and text boxes
Use bullets option

27.To Set Up a Master Slide in Powerpoint and Add Notes

Create a PowerPoint Design Template
Modify themes
Switch between Slide master view and Normal view
Setup Master slide and format
Add notes
Format a Design Template Master Slide
Add a Title Slide to a Design Template
The Slide Show Footer in PowerPoint
Add Notes to a PowerPoint Presentation

28.To Insert Text and Objects

Insert Text and objects
Set Indents and line spacing
Insert pictures/ clipart
Format pictures
Insert shapes and word art
Use 3d features
Arrange objects Insert Text and Objects Use 3d features

29.To Insert a Flow Chart / Organizational Charts

Create a Flow Chart in PowerPoint
Group and Ungroup Shapes
Use smart art Create organizational charts and flow charts using smart art

30.To Insert a Table

PowerPoint Tables
Format the Table Data
Change Table Background
Format Series Legend Insert tables and format

31.To Insert a Charts/Graphs

Create 3D Bar Graphs in PowerPoint
Work with the PowerPoint Datasheet
Format a PowerPoint Chart Axis
Format the Bars of a Chart
Create PowerPoint Pie Charts
Use Pie Chart Segments
Create 2D Bar Charts in PowerPoint
Format the 2D Chart
Format a Chart Background Create charts and Bar graphs, Pie Charts and format.

32.To Insert Audio & Video, Hyperlinks in a Slide Add Narration to the Slide

Insert sounds in the slide and hide the audio symbol
Adjust the volume in the settings
Insert video file in the format supported by PowerPoint in a slide
Use automatic and on click options
Add narration to the slide
Insert Hyperlinks
Insert Sounds and Video in appropriate format.
Add narration to the slide
Use hyperlinks to switch to different slides and files

33.To Practice Animation Effects

Apply transitions to slides
To explore and practice special animation effects like Entrance, Emphasis, Motion Paths &Exit Add animation effects

34.Reviewing Presentation

Checking spelling and grammar
Previewing presentation
Set up slide show
Set up resolution
Exercise with Rehearse Timings feature in PowerPoint f. Use PowerPoint Pen Tool during slide show
Saving h. Printing presentation (a) Slides (b) Hand-out
Use Spell check and Grammar feature
Setup slide show
Add timing to the slides
Setup automatic slide show

35.To Familiarize With Standard Toolbox

Open Adobe Photoshop
Use various tools such as
The Layer Tool

The Color & Swatches Tool
Custom Fonts & The Text Tool
Brush Tool

The Select Tool

The Move Tool
The Zoom Tool
The Eraser
The Crop Tool

The Fill Tool Open a photograph and save it in Photoshop

36.To Edit a Photograph

Use the Crop tool
Trim edges
Change the shape and size of a photo
Remove the part of photograph including graphics and text
Able to edit image by using corresponding tools.

37.To Insert Borders Around Photograph

Start with a single background layer
Bring the background forward
Enlarge the canvas
Create a border color
Send the border color to the back
Experiment with different colors Able to create a border or frame around an image to add visual interest to a photo

38.To Change Background of a Photograph

open the foreground and background image
Use different selection tools to paint over the image
Copy background image and paste it on the foreground.
Resize and/or drag the background image to reposition.
In the Layers panel, drag the background layer below the foreground image layer. Able to swap background elements using the Select and Mask tool and layers.

39.To Change Colors of Photograph

Change colors using:
Color Replacement tool

Hue/Saturation adjustment layer tool Able to control color saturation

To prepare a cover page for the book in subject area

open a file with height 500 and width 400 for the cover page.
apply two different colors to work area by dividing it into two parts using Rectangle tool.
Copy any picture and place it on work area^ resize it using free transform tool.
Type text and apply color and style
Apply effects using blended options Able to prepare cover page for the book

41.To Adjust the Brightness and Contrast of Picture to Give An Elegant Look

open a file.
Go to imaged adjustments^ Brightness/Contrast.
adjust the brightness and contrast.
Save the image. Able to control brightness/contrast.

42.To Type a Word and Apply the Shadow Emboss Effects

open a file
Select the text tool and type text.
Select the typed text go to layers layer styled blended option^ drop shadow, inner shadow, bevel and emboss^ contour^ sating gradient overlay
Save the image. Able to apply shadow emboss effects

For detailed syllabus of all other subjects of Diploma in Architectural Assistantship, C20 regulation curriculum do visit AA 1st Year subject syllabuses for C20 regulation.

For all Diploma in Architectural Assistantship exam timetable, visit APSBTET AA all semester exam timetable direct link.