ICS 100 Week 4 by zhouwenjuan


									                                     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.


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.


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

2. What kinds of applications are included in productivity software I might use at
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
     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
     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
      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.

Optional reading TIA CH5
   1. Week 4 Ning blog

       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
    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
     (2) Summarized what you
                                           x1                                                         4
     (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

 Blog Reply Rubric- 10 points                            Average
                                         Incomplete                   Excellent      Total
 5 points for each reply                                    2.0
                                          1.5 Points                  2.5 Points    possible
                                          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

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

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.

To top