First Year First Semester (EIT 1501 and 1502).
Out here our aim is to have a clear understanding of OS fundamentals, MS office (word, spreadsheet, multimedia) and Internet.
Under OS Fundamentals i have learn
- Introduction to Hardware
- managing the keyboard
- Operating system, managing mouse(I), logging into the network
- Internet account, send & receive mail
I also learn resizing the window, moving the window, files and folders, Create folders, name and examine our folders,
Word Processing
- System Software Vs Application software
- Various application software
- Standard toolbar, Page setup, Selecting Text.
- Formatting Text, Symbols, Line spacing, Indentation, use of bullets
- More about keyboard, alignment, Header and footer, Page Break
- Formatting table, insert and delete columns/rows.
- Merge and split cells, bordering and coloring table/cell
- Inserting images: inserting symbols, equations, pictures
- Find and replace Drawing Toolbar: WordArt, Textbox, Auto Shape.
So here are some works i have learn in ms word.
- What is Spreadsheet?
The use of spreadsheet. Differences between spreadsheet and word document.
What is a cell? Rows & columns.
- Cell address.
- Using cell references
- Moving around a spreadsheet using various keys.
- Changing row heights and columns and width
- Keying in Text and numbers
Formatting
- Auto fill feature.
- Inserting and Deleting Entering and Confirming entries.
- Inserting and deleting rows. Inserting and deleting columns.
Formatting a worksheet
- Aligning data across two or more columns. Merging two or more cells. Shading and Border. Setting Grids.
- Number format- Date, Currency, Decimal Places.
Formulae
- Why use formulae. Addition and Subtraction.
- Multiplication and Division.
- Absolute Cell referencing.
Functions
- What is a Function? Auto-sum. Average. Max. min. Countif. Rank.
Sorting
- Sort data in ascending and descending order.
Filtering.
- Changes in formulae – insertion deletion of columns and rows
Functions
- Changes in functions – insertion and deletion of columns and row.
For example:
Charts
- Why use chart? The different types of charts. When to use which type of chart. Column/Bar Chart
- Creating a column chart. Parts of a Column chart. Formatting the bar chart. Presenting multiple data within the same
First Year Second Semester (EIT 1503 and 1504).
In this two model we have dialed with mostly designing with various types of software. So i will put some examples of my design.
With Publisher
Microsoft Publisher is a desktop publishing application that allows us to create and fine-tune publications from a variety of templates or blank publications.
We can create many different types of publications including items such as promotional flyers, company brochures, garage sale flyers, business cards, school newsletters, and more.
Download
Whereas in EIT 04 i learn basic HTML designing, like instructional design and etc.
Download
Made calender with the help of HTML.
Download |