Introduction to Information Technology WEEK 7
Summary of Week 7
LECTURE 13:
In the first lecture of this week we will be continuing exploring MS Excel and explore following importent features:
Creating Excel Function, Filling Cells, and Printing
By using functions, you can quickly and easily make many useful calculations, such as finding an average, the highest number, the lowest number, and a count of the number of items in a list. Microsoft Excel has many functions you can use. You can also use Microsoft Excel to fill cells automatically with a series. For example, you can have Excel automatically fill your worksheet with days of the week, months of the year, years, or other types of series.
Creating Header/Footer
A header is text that appears at the top of every page of your printed worksheet. A footer is text that appears at the bottom of every page of your printed worksheet. You can use a header or footer to display among other things titles, page numbers, or logos. Once you have completed your Excel worksheet, you may want to print it. In this week you will also learn how to use functions, how to create a series, how to create headers and footers, and how to print.
Using Reference Operators
Understanding Functions
Fill Cells Automatically
Set Print Options
Print
Creating Charts
In Microsoft Excel, you can represent numbers in a chart. On the Insert tab, you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter. The basic procedure for creating a chart is the same no matter what type of chart you choose. As you change your data, your chart will automatically update. This week we will also learn about:
Create a Chart
Apply A Chart Layout
Add Labels
Switch Data
Change the Style of a Chart
Change the Size and Position of a Chart
Move A Chart to a Chart Sheet
Change the Chart Type
Students are advised to spend time in lab to practice these aspects of MS Excel. In case of any difficulty get help from the lab staff.
LECTURE 14
Storage devices allow us to save our work permanently. They are also called as backup devices. Presently there are many kinds of storage devices are available in the market like CD, DVD (Digital Versatile Disc), Blu - Ray Disc, Flash Drives, etc. In this lecture we will be discussing about following topics:
Difference between storage devices and storage media
haracteristics of magnetic disks
Characteristics of a hard disk
Types of miniature, external, and removable hard disk
Characteristics of optical discs
Differences among CD-ROMs,recordable CDs, rewritable CDs, DVD-ROMs, BD-ROMs, HD DVD-ROMs, recordable DVDs, and rewritable DVDs
PC Cards, ExpressCard modules, and the various types of miniature mobile storage media
Uses of microfilm and microfiche
LECTURE SLIDES: Storage Media
LECTURE 13:
In the first lecture of this week we will be continuing exploring MS Excel and explore following importent features:
Creating Excel Function, Filling Cells, and Printing
By using functions, you can quickly and easily make many useful calculations, such as finding an average, the highest number, the lowest number, and a count of the number of items in a list. Microsoft Excel has many functions you can use. You can also use Microsoft Excel to fill cells automatically with a series. For example, you can have Excel automatically fill your worksheet with days of the week, months of the year, years, or other types of series.
Creating Header/Footer
A header is text that appears at the top of every page of your printed worksheet. A footer is text that appears at the bottom of every page of your printed worksheet. You can use a header or footer to display among other things titles, page numbers, or logos. Once you have completed your Excel worksheet, you may want to print it. In this week you will also learn how to use functions, how to create a series, how to create headers and footers, and how to print.
Using Reference Operators
Understanding Functions
Fill Cells Automatically
Set Print Options
Creating Charts
In Microsoft Excel, you can represent numbers in a chart. On the Insert tab, you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter. The basic procedure for creating a chart is the same no matter what type of chart you choose. As you change your data, your chart will automatically update. This week we will also learn about:
Create a Chart
Apply A Chart Layout
Add Labels
Switch Data
Change the Style of a Chart
Change the Size and Position of a Chart
Move A Chart to a Chart Sheet
Change the Chart Type
Students are advised to spend time in lab to practice these aspects of MS Excel. In case of any difficulty get help from the lab staff.
LECTURE 14
Storage devices allow us to save our work permanently. They are also called as backup devices. Presently there are many kinds of storage devices are available in the market like CD, DVD (Digital Versatile Disc), Blu - Ray Disc, Flash Drives, etc. In this lecture we will be discussing about following topics:
Difference between storage devices and storage media
haracteristics of magnetic disks
Characteristics of a hard disk
Types of miniature, external, and removable hard disk
Characteristics of optical discs
Differences among CD-ROMs,recordable CDs, rewritable CDs, DVD-ROMs, BD-ROMs, HD DVD-ROMs, recordable DVDs, and rewritable DVDs
PC Cards, ExpressCard modules, and the various types of miniature mobile storage media
Uses of microfilm and microfiche
LECTURE SLIDES: Storage Media
No comments:
Post a Comment