ICS 100 Week 4 Topics and Objectives (1) Create content in Myitlab using the basic the basic features in Excel. (2) Create a word document describing how to set-up a computer (3) Create a Ning blog comparing compare software programs. Introduction: Application Software: Programs That Let You Work and Play. This week you will look at the kinds of software you can use to perform a variety of tasks, from simple word processing to digital image editing. We’ll also discuss how you can buy software, what the different versions of software mean, how you can legally get software for free off the Web, and how you install and uninstall software safely on your system. Presentation: 1. What’s the difference between application software and system software? System software is the software that helps run the computer and coordinates instructions between application software and the computer’s hardware devices. o System software includes the operating system and utility programs. Application software is the software you use to do everyday tasks at home, school, and work. o Application software is productivity software, such as word-processing and finance programs; media software, such as those used for image editing; home/entertainment, such as games or educational programs; and business software. 2. What kinds of applications are included in productivity software I might use at home? Productivity software programs include word-processing, spreadsheet, presentation, personal information manager (PIM), and database programs. You use word processing software to create and edit written documents. Spreadsheet software enables you to do calculations and numerical and what-if analyses easily. Presentation software enables you to create slide presentations. Personal information manager (PIM) software helps keep you organized by putting a calendar, address book, notepad, and to-do lists within your computer. Database programs are electronic filing systems that allow you to filter, sort, and retrieve data easily. Individuals can also use software to help with business-like tasks such as preparing taxes or managing personal finances. 3. What are the different types of multimedia software? Multimedia software includes digital image, video- and audio-editing software, animation software, and other specialty software required to produce computer games. Wide varieties of software programs are used to play, copy, record, edit, and organize MP3 files. Modern users have so many audio, video, and image files that there are a number of software solutions for organizing and distributing these types of files. 4. What are the different types of entertainment software? Beyond the games that most of us are familiar with, entertainment software includes virtual reality programs that use special equipment to make users feel as though they are actually experiencing the program in a realistic 3-D environment. 5. What is reference software? Software applications that act as sources for reference materials, such as the standard atlases, dictionaries, and thesauri, are referred to collectively as reference software. A lot of reference software on the market incorporates complex multimedia. 6. What are the different types of drawing software? Drawing software lets you create and edit line-based drawings to produce both imaginative and technical illustrations. Floor plans, animations, and mind-maps are some of the types of images that can be created. 7. What kinds of software do small and large businesses use? Many businesses, including home businesses, use general business software, such as Business Plan Pro and Marketing Plan Pro, to help them with tasks common to most businesses. In addition, businesses may use specialized business software (or vertical market software) that is designed for their specific industry. 8. Where can I go for help when I have a problem with my software? Most software programs have a Help menu built into the program with which you can search through an index or subject directory to find answers. Some programs group those most commonly asked questions in a single frequently asked questions (FAQ) document. In addition, vast resources of free or fee-based help and training are available on the Internet or at booksellers. 9. How can I purchase software or get it for free? Almost every new computer system comes with some form of software to help you accomplish basic tasks. All other software you need to purchase unless it is freeware or open-source code, which you can download from the Internet for free. You can also find special software called shareware that lets you run it free of charge for a test period. Although you can find software in almost any store, as a student you can purchase the same software at a reduced price with an academic discount. 10. How do I install, uninstall, and open software? When installing and uninstalling software, it’s best to use the specific Add/Remove Program feature that comes with the operating system. Most programs are installed using an installation wizard that steps you through the installation. Other software programs may require you to activate the setup program, which will begin the installation wizard. Using the Add/Remove Programs feature when uninstalling a program will help you ensure that all ancillary program files are removed from your computer. Software Presentation: 1. Define worksheets and workbooks. A spreadsheet is the computerized equivalent of an accountant’s ledger. It is divided into rows and columns, with each row and column assigned a heading. The intersection of a row and column forms a cell. Spreadsheet is a generic term. Workbook and worksheet are Excel specific. An Excel workbook contains one or more worksheets. 2. Use spreadsheets across disciplines. Spreadsheets are used in many areas other than business. Because of the powerful graphing or charting feature of Excel, geologists and physical scientists use spreadsheets to gather data about earthquakes or other physical phenomena and then graph it. Historians and social scientists have long used the power of spreadsheets for such uses as predicting voting behavior. 3. Plan for good workbook and worksheet design. Planning a spreadsheet before entering data into it is a necessary activity. The more prior planning that is done, the better the spreadsheet will appear, and it also will ensure that the spreadsheet shows what it is supposed to. 4. Identify Excel window components. The elements of the Excel window include the ribbon, tabs, and groups. There are also quick buttons above the tabs to simplify some functions. The Formula Bar, sheet tabs, the status bar, and the Select All button are parts of the Excel window. 5. Enter and edit data in cells. There are three types of data that can be entered in an Excel worksheet. They are text, values, and formulas. Each of these types of data has different uses in Excel. Assignments Optional reading TIA CH5 1. Week 4 Ning blog http://walkerics100.ning.com/profiles/blogs/week-4-blog-activity http://www.myitlab.com/ MyItlab 2. Excel Chapter 1 Hands-On Exercise 1: Introduction to Microsoft Excel Study Plan Project-Based Training and Test 3. Excel Chapter 1 Hands-On Exercise 2: Jakes Gym Continued Study Plan Project-Based Training and Test 4. TIA Word Project Draft Discussion Forum-Project needs to be posted in the discussion by Wednesday 11:59pm and replies by Friday http://walkerics100.ning.com/forum/topics/week-4-final-project 5. ******TIA Word Project Due final version of your project needs to be upload in Laulima in the assignments section by Friday 11:59pm******* Ning Blog Activity: Locate two CURRENT reputable web resources (that are different resources from those used by other students in the course) based on one of the following topics. Choosing different free and academic (priced for students) productivity software Choosing different types of multimedia software Choosing different types of business software Choosing different types image and drawing software In your blog complete the 4 steps listed in the blog rubric. (100-150 words) (1) Summarize and integrated information from your two reputable web resources with your own personal experience. (8 points) (2) Summarized what you learned (4 points) (3) Explained how you can continue this learning forward to improve your life and/or work. (4 points) (4) Explained feelings (good and bad feelings) about what you learned and what attitudes, expectations, values you need to change to learn more efficiently and effectively in the future. (4 points) Reply to two of your classmates blog postings ( 50-100 word per reply) In each reply complete the 2 steps listed in the blog rubric. (1) Build on or add to the blogs ideas. (2.5 points each reply) Go beyond agreeing or disagreeing with the content in the blog post. State why you agree or disagree with proof e.g., “I agree or disagree because….” (2.5 points each reply) Blog Rubric Total 20 total points Weight Incomplete Average Excellent possible 2 Points 3 Points 4 Points points (1) Narrative summarized and integrated information from two x2 8 reputable CURRENT web resources and provided own personal experience. (2) Summarized what you x1 4 learned. (3) Explained how you can continue this x1 4 learning forward to improve your life and/or work. (4) Explained feelings 1 4 (good and bad feelings) about what you learned and what attitudes, expectations, values you need to change to learn more efficiently and effectively in the future. Blog Reply Rubric- 10 points Average Incomplete Excellent Total 5 points for each reply 2.0 1.5 Points 2.5 Points possible Points per reply per reply points per reply (1) Builds on or adds to the 5 blogs ideas (2) Goes beyond agreeing or 5 disagreeing with the content in the blog post. States why they agree or disagree with proof e.g., “I agree or disagree because….” Links Academic Superstore: www.academicsuperstore.com. This site focuses on the academic market, providing discounted software to educators and students. CampusTech: www.campustech.com. This online store offers technology solutions, including hardware and software, to students and faculty. Download.com: www.download.com. This site offers a variety of freeware and shareware titles to download, as well as user and editor reviews for various products. Dummies eTips: etips.dummies.com. Visit the Dummies site and sign up for tips via a newsletter on a variety of topics, including various software applications, the Internet, and even non-computer-related topics. Freeware Home: www.freewarehome.com. This site includes an indexed collection of free software titles. Note that proper safety procedures should always be used anytime software is downloaded, including checking for viruses and spyware. Google Docs & Spreadsheets: www.docs.google.com. This is a free web-based word processing and spreadsheet program that keeps documents current and lets the people you choose update files from their own computers. You can, for example, coordinate your student group’s homework assignments, access your family to-do list from work or home, or collaborate with remote colleagues on a new business plan. JourneyEd.com: www.journeyed.com. Visit this online retailer to obtain discounted pricing on academic software and other related technology products. Shareware.com: www.shareware.com. Locate and download freeware and shareware titles on this Web site. SourceForge.net: sourceforge.net. SourceForge.net is the world’s largest open source software development Web site, hosting more than 100,000 projects and with over 1,000,000 registered users. Think Free: www.thinkfree.com. This site provides a free, online, alternative to Microsoft Office. Tucows: www.tucows.com. This is a popular site for downloading software, especially shareware and freeware. Gradware: www.gradware.com. This online retailer provides student and faculty discounts for academic software. OpenOffice.org: www.openoffice.org. The OpenOffice open-source productivity suite is available to download for free from this site. Student Discounts.com: www.studentdiscounts.com. This site is a great resource for obtaining various software titles and computer products at academic prices. Next week Basic features of operating systems.
Pages to are hidden for
"ICS 100 Week 4"Please download to view full document