Date
Topic
Computer Concepts(CC)/
Win NT/MS Office97
Recommended Lab Practices
(Important: Specify your Name; HW # on both printouts and diskette label)
(Computer Concepts Ch1)
A. Computers: Mind Tools
B. Computer Systems Basics
C. The User Interface
D. User Focus:Help, Tutorials, and Manuals
 | Definition of computer by Von Neuman |
| Computer system basic: Software; Categories of computer; System components; Microcomputer compatibility; Peripheral devices; Computer network |
| The User Interface: Prompted Dialog;Commands; Menu & Dialog Boxes; Wizards;GUI |
| Peripheral Devices(#1) |
| Using a Mouse (#1 & #2) |
| Using a Keyboard (#1) |
HW #1 (due 6/29) User Interface (#1 & #2)- CC Page 1-40
Note: See CC Page 1-39 for instructions how to run the Lab Assignments
Links
2. Computer History
3. Computer Currents Dictionary
A. Digital Electronics
B. Memory
C. CPU
D. I/O
E. The Boot Process
| Inside the system unit;Mother board |
| Memory: RAM; Virtual Memory; ROM; CMOS; Cache (internal/external) |
| CPU: Control unit; ALU |
| I/O: Expansion bus; Expansion slot; Expansion Card; Expansion Port; Cable; Output Device |
| The Boot Process: Power-up; Boot Program in ROM; Power-on-Self Test(POST); Load Operating System; Check Configuration & Customization; Ready for Commands & Data |
Lab Assignment:
CC Page 5-43
CPU Simulator #1 & #4
A. Software Basics
B. Installing S/W
| S/W Categories: Systems/Applications |
| Liscensed s/w: Shrink-wrap, Concurrent-user, & Site license |
| Shareware, Freeware,Public domain |
| Business s/w: Horizontal-market & Vertical-market s/w |
| Installing s/w |
| View the desktop |
| Start a program; Resize a window; Use menus & toolbars |
| Use dialog boxes & scroll bars |
| Fomatting a disk |
| Creating & saving a file( Save/Save As) |
| Copy, Move, Delete, Restore, Rename files |
| My Computer vs. Win Explore |
Page NT A-21 Skills Review
#1 thru #6
Suggestions: Win
NT 4 Pracice
Page NT B-23-25 Skills Review
#1 thru #9
| Organize FD/HD using folders/subfolders |
| Create/Save As/ Copy/Rename/Remove file |
| Ctrl/Shift click to select multiple file |
| Delete; Restore; Empty the Recycle Bin |
| Rename Folder/File |
| Data & Information |
| File: Execution files; Data files; Source files |
| Document centric approach to files |
| File naming convention |
| Windows Directories, Folders, and Files |
| File Open, New, Save, Save As, Copy, Rename, Delete operations |
Lab Assignments:
1)Windows, Directories, Folders & Files (CC Page 4-43) #1 thru #4
2)Using Files (page 4-44) #1 thru #3
A. How It Works
B. The Web Browser
C. Web Authoring
D. Connecting to the Internet
| The Internet background & basics: TCP/IP, Router, ISP, modem, IP address, Domain name, Top-level domain, URL, e-mail address, http, web server, web site, web page, web browser, search engines, push/pull technology |
| Web authoring: HTML tags( HTML, HEAD, TITLE, BODY, IMG SRC=, BR, B, FONT) |
1)The Internet:WWW- #1,2,3 (CC P8-37)
2)Web pages & HTML- #1,2 (CC P8-38)(note: print the HTML code for both problems #1 & #2)
Links
HTML Tutor A
HTML Tutor B
HTML Tutor C
A Free Web Site
Project 1. Creating and Editing a Word Document
(pages WD 1.9-1.60)
Formatting documents: Word's default settings; Document navigation; Text selection; Character Formatting; Paragraph Formatting; Downloading image from the Web
Page WD 1.67-Creating an announcement w/ ClipArt - Hand in a disk w/ printout as directed in textbook.
Note: Include the following in your MS Word document and on diskette label:
HW/Lab #
CIS115
Your Name
Today's date
| Margin settings; double space; header; footnote |
| Table |
| Ruler: hanging indent |
| Sort paragraphs |
Quiz #1 Results:
Class Average=76.5
Stem-and-Leaf Display:
8|114
7|0
6|6
HW #6: due
7/15/99
Page WD 3.59-2. Preparing a Research Report with a Footnote and a Table:
Hand in a disk w/ printout as directed in textbook
Project #1: Computer Discount Daily Sales (Pages E 1.6 - E 1.45)
| Starting Excel |
| The Excel window |
| Moving arounding a worksheet |
| Navigating/opening a workbook |
HW
#7: due 7/20/99
Page E 1.67 #1 Creating and Modifying a Sales Analysis Worksheet
Project #2: High-Tech Stock Club(Pages E 2.4 - E 2.65)
| Multiple lines of text in a cell |
| Formula & Functions |
| Formatting: font; boarder; align text; col width & row height |
| Chart: 3-D Pie chart |
|
Page E 2.73 #2 Esther's Emporium Monthly Accounts Receivable Balance Sheet
Project #3: What-If Analysis & Working w/ Large Worksheet
| Using assumptions |
| Absolute/Relative addressing |
| IF function |
| Freeze/Split the worksheet |
| 3-D chart formatting |
| What-If analysis |
| Goal seeking |
Page E 3.71 #3 Solar Works, Inc. Projected quarterly report
Medaille.mdb
| Spreadsheet vs. Database |
| Database concepts |
| Create a Table |
| Add records to a table |
| Use a form to view data |
| Create a report |
Project #1:Pilotech Services Database
| Create a Table |
| Add records to a table |
| Use a form to view data |
| Create a report |
HW #10: due 8/3T
Page A 1.65 #1. Creating Museum Mercantile Database
Project #2: Querying the Pilotech Services Database
| Query Criteria: use number; comparison; compound criteria using and & or |
| Sorting the query; Omitting duplicates |
| Joining tables |
| To use a computing field |
| To calculate statistics |
Page A 2.54 #1. Querying the Museum Mercantile Database
Quiz
#2 Results:
Class Average=75.4
Stem-and-Leaf Display:
8|4
7|257
6|9
| Add/delete a new record using a form |
| Update/Delete Query |
| Required field; Default value; Automatic Conversion to Uppercase |
| Referential Integrity |
Page A 3.54 #1. Maintaining the Museum Mercantile Database
| PowerPoint: Project 1 - Using a Design Template (PP 1.8-1.39) |
| Project 2: Using Outline View & Clip Art |
| Animation Effects |
P 1.69 #1. Designing and Creating a Presentation
HW #14
(due 8/12/99):
P 2.65 #1. Adding clip art & animation effects to a presentation created in
outline view
| Network: WAN & LAN |
| Network: Hardware |
| Network: Software |
| What can go wrong |
| Viruses |
| Backup |