Microcomputer Applications

1
Microcomputer Applications
CIT 1503 -- Fall 2005 www.clt.astate.edu/jseydel/m
is1503

• Getting Started with Excel

Instructor John Seydel, Ph.D.
2
Student Objectives

• Complete Excel Project 1
• Tutorials
• Identify parts of the Excel interface
• Open, save, and close workbooks
• View and edit cell contents
• Modify charts
• Perform simple sorts and filters
• Use print and print preview buttons
• Get help
• Challenge exercises 1, 2
• Work on Excel Project 2
• Tutorials
• Enter text, numbers, and formulae
• Select worksheet items
• Insert/delete rows and columns
• Copy/move cell contents
• Use AutoSum
• Copy formulae
• Spell-check workbooks

3
Miscellaneous Items

• First, a short quiz
• Info about Exam 1
• Tuesday, September 20
• Two parts
• Multiple choice (15)
• Practical exercise (85)
• Preparation
• Work through all multiple choice (beyond
  memorization)
• Rework and understand assigned Challenge
  exercises
• Turn in all remaining Word exercises

4
Information Technology Overview

• Recall the five components of information systems
• All information systems
• People
• Data
• Procedures
• Information technology components
• Hardware
• Software
• Now, consider the software component
• Systems programs
• Applications programs
• Data management ? Analysis ? Communication
• Communication Word, PowerPoint
• Data management Access
• Analysis Excel

5
Some Excel Concepts

• Interface very similar to that of Word
• Layout (e.g., toolbars)
• Behavior (e.g., double-clicking a word)
• Purpose is very different
• Primary for analysis
• But often used also for
• Data management
• Communication (presentation)
• Thats why the original Lotus was Lotus 123
• Note first spreadsheet software was VisiCalc
• Lets take a look open EE1_0101

6
Appendix
7
Posting Files to the Server

• All homework (and class exercise) files to be
  turned in are to be posted to your SuSE1 server
  account
• Well use FTP to do this
• Heres how
• In IE, go to ftp//www.SuSE1.astate.edu
• Enter your UserID and password
• First initial plus lastname (e.g., jseydel)
• Last 4 digits of student number plus first
  initial (e.g., 1234j)
• Navigate to Documents folder (not public_html)
• Copy the file from Windows Explorer
• Paste into Documents
• If its a web page, you can now view it anywhere
  in the world
• http//www.SuSE1.astate.edu/jseydel/index.html

8
Organization of the Textbook

• Note the layout
• Sections (e.g., Word, Excel, . . . )
• Chapters (i.e., Projects)
• Tutorials (i.e., Lessons)
• Chapter-end materials
• Summary, Concepts, Quiz, Discussion
• Skill Drills
• Challenges
• Discovery Zone
• Prep for class typically Lessons
• In class typically Challenges

9
Organize Your Files

• Note the following structure
• My Documents
• Misc
• index.html
• index.txt
• Access
• Excel
• PowerPoint
• Word
• Create the above folder/file structure
• Files are indicated by their extensions
• Folders are those names without extensions
• Copy this structure to your portable disk
• Open Windows Explorer (should already be open)
• Scroll to top in Folders panel and click on
  Desktop
• In Contents panel select the folders youve
  created
• Click on first
• While holding down the Ctrl key, click on the
  other folders
• Click on Edit on the Menu bar