130 likes | 265 Vues
This guide covers essential computer literacy skills across Microsoft Office applications, including Word, Excel, PowerPoint, and general computer fundamentals. Learn to navigate Word's features, utilize Excel's spreadsheet capabilities, and create impactful presentations with PowerPoint. Additionally, explore the basics of computer operation, internet functionality, networking, security, and application management. Each chapter is designed to increase your proficiency and confidence in using computers for academic and professional purposes. Perfect for students and anyone looking to improve their digital skills.
E N D
My Computer Literacy By Bradley Scott Melis
Microsoft Word • 1. Understand Word Basics • 2. Use AutoText • 3. View a Document • 4. Set Margins and Specify page orientation • 5. Insert page breaks • 6. Create sections • 7. Insert a cover page • 8. Select Printing Options • 9. Customize Word • 10. Check spelling and grammer
CAYF Ch 1 & 2Computer s and You/The World Wide Web • Computer Fundamentals • Input • Processing • Output • Storage • Types of Computers • Computers for individuals • Computers for Organizations • How the Internet Works • Interoperability= The ability to work with a computer even if it is a different brand or model. • Exploring Internet Services • E-mail • Instant Messaging • Internet Relay Chat • File Transfer Protocol • Usenet: Joining Online Discussions
Microsoft Excel • 1. Define Worksheets and workbooks • 2. Use spreadsheets across disciplines • 3. Plan for good workbook and worksheet design • 4. Enter and edit data in cells • 5. Display Cell formulas • 6. Insert and Delete rows and columns • 7. Format worksheets • 8. Manage cell comments • 9. Identify Excel window components • 10. Select page setup options and printing
CAYF Ch 3 & 4Communication/System Software • Moving Data: Bandwidth and Modems • Bandwidth=Refers to the amount of data that can be transmitted through a given communications channel. • Modems= Communication devices used to transmit data over telephone lines. • Wired and Wireless Transmission Media • Twisted Pair • Coaxial Cable • Fiber Optic Cable • Infrared • Radio • Microwaves • Wired and Wireless Applications • Internet Telephony • Faxing • Satellite Radio, GPS • Text, Picture, and Video Messaging • The Operating System • Starting the Computer • Managing applications • Providing the User interface • System Utilities • Backup Software • Antivirus Software • Managing Files • Troubleshooting
Microsoft PowerPoint • 1. Identify PowerPoint user interface elements • 2. Open and Save a slideshow • 3. Get Help • 4. Create a storyboard • 5. Use slide layouts • 6. Apply Themes • 7. Add a table • 8. Insert clip art • 9. Use transitions and animations • 10. Print with PowerPoint
CAYF Ch 5 & 6Application Software/System Unit • General-Purpose Applications • Personal Productivity Programs • Multimedia and Graphics Software • Home and Educational Programs • System Requirements and Software • System Upgrades • Distribution and Documentation • Managing Application Software • Installing Applications • Launching Applications • Choosing Options • Inside the System Unit • Motherboard • Power supply • Cooling Fan • Internal Speaker • Drive bays • The Motherboard • The motherboard contains the computer’s CPU • Outside of the Box • The front panel • Connectors and Ports
CAYF Ch 7 & 8Input, Output, Storage/Networks • Input Devices • Keyboard • The Mouse and Other pointing devices • Speech and Voice Recognition • Scanners • Output Devices • Monitors • Printers • Speakers • Projectors • Storage • Memory Versus Storage • Hard Drive Disks • Floppy and Disk Drives • Network Fundamental s • Network= A group of two or more computer systems liked together. • LAN • WAN • Communication Devices (Computers, Modems, etc…)
CH 8 Networks Cont… • Local Area Networks (LANs) • Two or more computers that communicate with each other and with peripheral devices. • Peer-to-Peer Networks • Client/Server Networks • LAN Topologies • LAN Protocols • Wide Area Networks (WANs) • WANs are similar to long distance telephone systems • Point of Presence • Backbones • WAN Protocols • WAN Applications
CAYF Ch 9Privacy, Crime, and Security • Privacy in Cyberspace • Collection of information without consent is one of the major problems in cyberspace • Technology and Anonymity • Protection • Computer Crime and Cybercrime • Types of Cybercrime • Identity Theft • Computer Viruses • Rouge Programs • Security • UPS • Controlling Access • Firewalls • The Encryption Debate • Encryption= coding or scrambling process that renders a message unreadable by anyone except the intended recipient. • Public Key Encryption
Microsoft Office 2007 • Open a file • Save a file • Print a document • Select text to edit • Insert text • Move and copy text • Use language tools • Copy formats with the format painter • Apply font attriubutes
Summary • I have very much enjoyed taking this class and enhancing my computer literacy. • The things I have learned so far will sincerely help me in my future career and throughout the following years of my College education. • Thank you!