Microsoft Windows and Office : word, powerpoint, excel and access
Backup webpages : http://www.yonok.ac.th/burin/office | http://www.thaiall.com/office
ปรับปรุง : 2548-02-25 (update final score)
Questions for my students?
1. What is the student functions?
2. Why the students should be on time?
3. What will be happen after the retirement?

NO.All student have 100% M
class
(5%)		 F
class
(5%)		 Apt.
(10%)		 M
Quiz
(5%)		 F
Quiz
(5%)		 M
Proj
(5%)		 F
Proj
(5%)		 M
Assign
(10%)		 F
Assign
(5/10%)		 Mid.
(20%)		 Fin.
(20%)
Course grading for 100 %
(Students have 100% at the beginning)
Class participation
Aptitude
Quizzes
Projects
Assignments
Midterm examination
Final examination
10 %
10 %
10 %
10 %
20 %
20 %
20 %

Syllabus of BCOM 201
Automated correspondence and survey of software packages
:: Students will use commercial software packages in the microcomputer laboratory to gain an understanding of software functions and to develop personal competency in practical applications of microcomputers including the operating system, word processing, spreadsheets, database management, presentation, adn graphics.
1 4651007 1 % 1 % 10 % 3 % 1 % 4 % 5 % 6 % 5 % 16 %
2 4651008 1 % 1 % 10 % 3 % 2 % 0 % 2 % 4 % 5 % 11 %
3. 4651009 0 % 3 % 10 % 2 % 4 % 3 % 1 % 8 % 10 % 20 %
4 4651010 4 % 4 % 10 % 5 % 4 % 4 % 5 % 10 % 8 % 19 %
5 4741001 2 % 4 % 10 % 2 % 4 % 4 % 4 % 7 % 7 % 17 %
6 4741002 5 % 5 % 10 % 5 % 4 % 5 % 5 % 10 % 10 % 17 %
7 4751001 5 % 5 % 10 % 5 % 5 % 3 % 2 % 8 % 10 % 18 %
8 4751004 4 % 5 % 10 % 5 % 4 % 4 % 4 % 10 % 8 % 18 %
9 4751005 4 % 5 % 10 % 2 % 4 % 5 % 4 % 10 % 10 % 17 %
10 4751006 0 % 0 % 0 % 0 % 0 % 0 % 0 % 0 % 0 % W
11 4751007 0 % 0 % 0 % 0 % 0 % 0 % 0 % 0 % 0 % W
12 4751008 5 % 5 % 10 % 5 % 4 % 4 % 4 % 10 % 10 % 18 %
13 4751010 0 % 0 % 0 % 0 % 0 % 0 % 0 % 0 % 0 % 0 %
14 4751012 5 % 5 % 10 % 3 % 4 % 5 % 5 % 10 % 8 % 7 %
15 4751016 3 % 2 % 10 % 5 % 4 % 5 % 2 % 9 % 5 % 20 %
16 4751018 3 % 2 % 10 % 3 % 4 % 5 % 5 % 10 % 7 % 13 %
17 4751022 1 % 3 % 10 % 4 % 4 % 4 % 5 % 6 % 5 % 8 %
18 4751023 4 % 5 % 10 % 5 % 5 % 4 % 5 % 10 % 10 % 19 %
19 4751024 3 % 5 % 10 % 4 % 4 % 5 % 5 % 10 % 10 % 7 %
20 4751025 0 % 1 % 8 % 3 % 0 % 4 % 3 % 5 % 5 % 19 %
21 4751026 5 % 5 % 10 % 4 % 3 % 4 % 1 % 8 % 8 % 18 %
22 4751027 1 % 1 % 8 % 5 % 0 % 4 % 0 % 9 % 0 % 19 %
    Information about this subject
  1. Microsoft Office
    Microsoft's primary desktop applications for Windows and Mac. Depending on the package, it includes some combination of Word, Excel, PowerPoint, Access and Outlook along with a host of Internet and other related utilities. The applications share common functions such as spell checking and graphing, and objects can be dragged and dropped between applications. Microsoft Office is the leading application suite on the market.
    Microsoft Office 2003, introduced in late 2003, provides extensive support for XML and data collaboration. Office files can be saved as native XML for easier integration with other applications, and Microsoft's SharePoint portal turns Office into a groupware system that is administered on a Web server. Designed to be a front end to Microsoft's .NET initiative, Office 2003 applications run under XP and 2000 only. Microsoft no longer refers to Office as a "suite," rather it became the Microsoft Office System.
    Office XP, introduced in 2001, added document sharing over the Web, a significant document recovery feature and also integrated Microsoft's Web-based Hotmail e-mail service.
    Office 2000 was a major upgrade with numerous enhancements and changes. More integrated with the Web, it added collaboration features and support for opening and saving HTML documents, even doubling as an HTML editor.
    Office 2000 is a software suite that consists of different applications that complete different activities. MS Office 2000 is by far the most widely recognized software suite in the world.
    Office 95 was the first 32-bit version of Office, followed by Office 97, which added Internet integration and Outlook. The formats in Excel 97, PowerPoint 97 and Word 97 were changed, but files could be saved in a dual 95/97 format for backward compatibility. Access 97 files were not backward compatible. The last 16-bit versions of Office were Office 4.x.
    1. Microsoft word
    is the word processing program of the Microsoft Office suite that allows you to create documents and reports.
    Microsoft Word 2000 provides powerful tools for creating and sharing professional word processing documents. Click here for help on Microsoft Word. Take a Virtual Tour on Microsoft's website by clicking Microsoft Word 2000 Virtual Tour.
    2. Microsoft Excel
    lets you develop spreadsheets that display data in various tabular and visual formats.
    Microsoft Excel 2000 With Microsoft Excel 2000, you can create detailed spreadsheets for viewing and collaboration. Create customized formulas for your data and analyze it with the easy to construct charts. Click here for help on Microsoft Excel. Take a Virtual Tour on Microsoft's website by clicking Microsoft Excel 2000 Virtual Tour.
    3. Microsoft PowerPoint
    creates multimedia presentations to display information in a graphical format.
    Microsoft PowerPoint 2000 provides a complete set of tools for creating powerful presentations. Organize and format your material easily, illustrate your points with your own images or clip art, and even broadcast your presentations over the web. Click here for help on Microsoft PowerPoint. Take a Virtual Tour on Microsoft's website by clicking Microsoft PowerPoint 2000 Virtual Tour.
    4. Microsoft Access
    is a database program that stores information that can be manipulated, sorted, and filtered to meet your specific needs.
    Microsoft Access 2000 gives you powerful new tools for managing your databases. Share your database with co-workers over a network, find and retrieve information quickly, and take advantage of automated, pre-packaged wizards and solutions to quickly create databases. Click here for help on Microsoft Access. Take a Virtual Tour on Microsoft's website by clicking Microsoft Access 2000 Virtual Tour.
    5. Microsoft Frontpage
    allows you to create professional-looking web pages for the Internet.
    6. Microsoft Publlisher
    Microsoft Publisher 2000 helps you easily create, customize, and publish materials such as newsletters, brochures, flyers, catalogs, and Web sites. Publish easily on your desktop printer. Click here for help on Microsoft Publisher. Take a Virtual Tour on Microsoft's website by clicking Microsoft Publisher 2000 Virtual Tour.
    7. Microsoft Outlook
    8. Microsoft Internet Explorer
    9. Microsoft Paint

    from techweb.com
  2. countactivities.zip
    Activities department of YONOK college want program to count the activities of students so i use Microsoft excel to count it. I use pivot table the count. It have 2 sheets which have primary activities and secondary activities.
  3. Step by step tutorials for Microsoft Windows and Products
    WindowsXP
    Windows98
    Office2003
  4. What is RGB (Red Green Blue)?
    If you see T.V. screen with a magnifying glass, you will notice only three colors are used. These three colors, Red(R), Green(G), and Blue(B), are combined to form color monitors of T.V. and computer. This method is called RGB form. RGB is three primary colors of light. From far, unable to distinguish individual colors, these colors are merged within eyes and see as combined colors.
    (Red Green Blue) The color model used for generating video on a display screen. It displays colors as varying intensities of red, green and blue dots. When all three are turned on high, white is produced. As intensities are equally lowered, shades of gray are derived. The base color of the screen appears when all dots are off
    Color sample
    <font color=#ff0000 size=6> is red
    <font color=#0000ff size=0> is blue
    <font color=#00ff00 size=0> is green
  5. Windows Metafile (from techweb.com)
    The native vector graphics file format in Windows. Windows Metafiles also can hold bitmaps and text. The original 16-bit format uses the .WMF file extension. The subsequent 32-bit format, which supports more sophisticated graphics functions, generates .EMF (Enhanced MetaFile) files.
    WMF and EMF files are made up of actual Windows drawing commands (GDI calls) which results in an efficient format that renders illustrations very quickly. Metafiles are also used by programs to hold data between sessions, and Windows uses it for temporary storage.
    The standard WMF file uses an 18-byte header followed by GDI command records. There are two additional WMF variations that place another header in front of the standard header. A Placeable Metafile uses a 22-byte header containing x-y coordinates for positioning the image on the page. A Clipboard Metafile uses an 8- or 16-byte header. In an EMF file, all header information, including Placeable and Clipboard data, is stored in the first GDI command record.
  6. Graphic format extension (from http://kb.indiana.edu)
    click for more
    click for more
    .bmp Windows and OS/2 bitmap
    .cur Microsoft Windows cursor image file
    .gmf Computer Graphics Metafile (various venders)
    .img Boeing Graph
    .mgr MGR bitmap file
    .psd Adobe Photoshop native format
    click for more
    click for more
  7. Sample step in Macro of Microsoft excel
    1. Click tool, macro, record and ok
    2. type 5 in A1, 10 in A2 and 15 in A3
    3. type =sum(a1:a3) in a4
    4. Click on stop button
    5. go to sheet2 and call macro1
    6. type =count(sheet1!A1:A15) in A5 of sheet2
Image of Microsoft windows
from http://ioc.unesco.org/oceanteacher/resourcekit/Module2/Computers/OS/Windows/desktop.html



enlarge
When you click on a drive, folder, document or program icon, a window opens. Every window has its own menus, icon and controls. This is the My Computer window that shows the different drives installed on the computer. Each window has common basic components such as the minimise, maximise and close buttons to control the window size. The title bar at the top of the window displays the window content. In this example the name of the window is My Computer.
The My Computer icon on the desktop provides quick access to the major components of the computer. This icon appears as a default on the desktop.
Click on the My Computer icon to open the window containing the disk drives, the Control Panel, printers, networking and task folders.
The My Computer folders include:
- Control Panel Settings to personalise the computer
- Printers Add and set-up printers
- Dial-up Networking Connect to a network
- Schedules Tasks Routine tasks such as Disk Defragmenter




enlarge
The main elements that comprise the desktop are:
Window is the area that displays an open program or the contents of a folder.
Icons are the graphic objects representing shortcuts to programs and documents that are stored on computer.
The Taskbar, located at the bottom of the desktop screen indicates what programs are currently running on the computer and what windows are open.
Click the Start button to open the Start menu. A complete listing of all the programs and operating system options are listed under the Start menu. These include:
- Programs option will display a listing of all of the available programs on the computer.
- Settings option will display a listing of all of the available settings that can be changed on the computer. For example the monitor display size and the desktop background image.
- Search option will search for files or programs that are stored on the computer.
- Run will execute (start) a program on the computer
- Shut Down will shut the computer down.



enlarge
Programs are the application software stored on the computer. An example of a program is Microsoft Word. Sometimes there are short-cuts to the programs on the desktop in the form of an icon. If there is no short-cut the program can be accessed using the Start button. Click on Programs from the Start button to display the following options. Some programs are grouped under general headings like "Accessories". The small arrow to the right of these words indicates that there are more options under them. Other programs are represented by themselves such as "Microsoft Word". These do not have the small arrows to the right of them. Clicking on any of these options will either launch the program or reveal more options.



enlarge
Icons for all of the printers installed on the computer are displayed. Notice the black circle containing the white check mark above the "Lexmark Optra" printer icon. This indicates that this is the default printer.
Click on the Add Printer icon to install additional printers. Click on the printer icon to display the Printer Spool dialog box. The printer spool allows the management of print jobs. To delete a document that has already been sent to the printer, select the item, and then go to Document on the Menu Bar, Under the Document Menu, select Pause or Cancel a printing job that has been sent to the printer.



enlarge
The left side frame contains a list of the drives and folders (or directories). The right side displays the contents of the selected folder.
A quick way of to open Windows Explorer to view the folders and files is to right-click on My Computer and select Explore.
Expanding and Collapsing Folders. In the right pane of Explorer, notice that some of the drives and folders have a + or - sign next to them. The + sign indicates that there are more items in that particular folder and the - sign indicates that there are no more items in that folder aside from the ones that are displayed in the right window. Clicking on a + sign next to an object will expand the view of that object to display sub-folders and files located within it. Clicking on the - sign next to an object will collapse the view so that any sub-folders are hidden.



enlarge
The Control Panel under the settings option provides access to various devices attached to the system. Click on Control Panel under Settings to display the dialog box (left)
In this dialog box you can change the settings of several computer devices like the mouse and the display.
Clicking on any of these icons will display another dialog box for that particular device, from which you can make changes.



enlarge
Folders are ways of organising or grouping documents. Inside folders there can be documents or there can be more folders. Some folders are automatically created, for example, in the case of program files. Other folders are manually created by the users of the computer.
To create a new folder:
1. Open My Computer.
2. Select the drive or folder where you want to put the new folder. The drive of folder window will open.
3. Select File > New > Folder. The new folder appears in the window.
4. Type in a name for the folder, then press Enter
    Web guides
  1. http://www.mrexcel.com/search.shtml search for excel using
  2. http://www.greytrout.com/manuals/SS_user_guide/node30.html Listing of excel functions
  3. http://www.j-walk.com/ss/excel/usertips/tip015.htm (Tip: Referencing a sheet indirectly)
  4. http://www.amherst.edu/it/software/excel/excel-basics/excel-calculate/ Calculating with excel
  5. http://www.canberra.edu.au/cts/training/websters/xl97book/Contents.htm image of excel program
  6. http://www.math.vanderbilt.edu/~schectex/wincd/list_intro.htm introduction to windows application
  7. http://www.pac-its.psu.edu/windows Introduction to windows
  8. http://www.fgcu.edu/support/office2000/ Tutorial of Office 2000
  9. http://www.bcschools.net/staff/MicrosoftOffice.htm Tutorial of Microsoft office
Header assignment sample
BCOM 201 : Automated correspondence and survey of software packages
By : 4701000 Mr.yourname yoursurname
yourname@yourhost.com http://www.weblampang.com/home/yourname
Assignment : 1
Nov 15,2004
แนะนำเว็บใหม่ : ผลการจัดอันดับ
รักลำปาง : thcity.com : korattown.com : topsiam.com : มหาวิทยาลัยโยนก
ศูนย์สอบ : รวมบทความ : ไอทีในชีวิตประจำวัน : ดาวน์โหลด : yourname@thaiall.com
ติดต่อ ทีมงาน ชาวลำปาง มีฝันเพื่อการศึกษา Tel.08-1992-7223