|Perfect Number of Pages to Order||5-10 Pages|
Spreadsheets and Media Presentations
Submit your complete assignment by clicking the blue submit button at the bottom of the page. We recommend that you submit your work on Sunday of the week that you start the module.
Introduction to Computers- Module 5 Assignment Instructions
Create a Power Point Presentation that consist of:
Title Page – Title of Presentation and your first and last name. (1 slide)
This is a title page. Include your name, the date, and something that makes a personal statement about you. Include a photo of you.
Mission Statement – A broad statement of your values and your aspirations. (1 slide)
This should be a clear statement of who you are, where you are headed, and what you hope to accomplish. Including a graphic or photo here is also encouraged but points will not be deducted if that is left out.
Career Goals – Tell not only the career, but the area of specialty if applicable. (1 slide)
Describe the career and examples of the kind of work you will do, if that particular field is growing, and where you hope to be in the next 5 years.
Summary – A summary of what you have learned in this course so far and how it will help you achieve your goals. (1 slide)
A reflective statement that clearly summarizes your presentation and your direction in life.
Length 4 slides
Font 12 point, Calibri Font
Program/File Type Submit in PowerPoint
Referencing system APA referencing system is necessary in assignments, especially material copied from the Internet.
For examples of correct citations, visit the following links:
File Name Lastname_firstname_C10_M5 Assignment
Module 5 Assignment Grading Rubric
Your work will be evaluated on the following criteria:
CATEGORY Exceeds Expectations Meets Expectations Does Not Meet Expectations Significantly Below Expectations
Mechanics – Grammar, Punctuation, Spelling 20 points
Student makes no errors in grammar, punctuation, or spelling that distract the reader from the content. 15 points
Student makes 1-2 errors in grammar, punctuation, or spelling that distract the reader from the content. 5 points
Student makes 3-4 errors in grammar, punctuation, or spelling that distract the reader from the content. 2 points
Student makes more than 4 errors in grammar, punctuation, or spelling that distract the reader from the content.
Writing Style – Organization, Transitions, Tone 20 points
The assignment is written with excellent organization, thoughtful transitions, and the appropriate tone. 15 points
This writing assignment is adequately organized, but has some errors in the transitions or the tone. 5 points
This writing assignment is poorly organized, or it contains ineffective transitions and/or inappropriate tone. 2 points
This writing assignment displays little to no organization or transitions, and/or does not use the appropriate tone.
Presentation Format – Margins, Font, Spacing, Headings and Cover Page 20 points
The margins, font, spacing, headings, and title page are all formatted properly. 15 points
There are 1-2 errors in the formatting of the margins, font, spacing, headings, or cover page. 5 points
There are 3-4 errors in the formatting of the margins, font, spacing, headings, or cover page. 5 points
There are more than 4 errors in the formatting of the margins, font, spacing, headings, or cover page.
Presentation Format – 4 slides, Title, Mission Statement, Career Goals, and Summary 40 points
All title slides are included with complete content following the flow: Title Page, Mission Statement, Career Goals, and Summary. 30 points
All title slides are included with complete content but does NOT follow the flow: Title Page, Mission Statement, Career Goals, and Summary. 20 points
Two of the four slides are not included with complete content and does NOT follow the flow: Title Page, Mission Statement, Career Goals, and Summary. 10 points
Slides and content are incomplete and does NOT follow the flow and instructions.
Module 5: Spreadsheets and Media Presentations
Lesson 5 of 8
The simple spreadsheet is one of the most powerful data analysis tools that exists, and it’s available to almost anyone. Major corporations and small businesses alike use spreadsheet models to determine where key measures of their success are now, and where they are likely to be in the future. But in order to get the most out of a spreadsheet, you must have the know-how to use it. This module is designed to give you an introduction to basic spreadsheet tools and formulas so that you can begin to harness the power of spreadsheets to map the data you have now and to predict the data you will have in the future.
A spreadsheet or worksheet is a file made of rows and columns that helps sort data, arrange data easily, and calculate numerical data. What makes a spreadsheet software program unique is its ability to calculate values using mathematical formulas and the data in cells. A good example of how a spreadsheet may be utilized is creating an overview of your bank’s balance.
A Brief History of Spreadsheets
Spreadsheets have been used by accountants for hundreds of years. Computerized or electronic spreadsheets are of much more recent origin. Information Systems oral history and some published newspaper and magazine stories celebrate Dan Bricklin as the “father” of the electronic spreadsheet. In 1978, Harvard Business School student, Daniel Bricklin, came up with the idea for an interactive visible calculator. Bricklin and Bob Frankston then co-invented or co-created the software program VisiCalc. We can look back and recognize that VisiCalc was the first “killer” application for personal computers.
Functions of a Spreadsheet
In the realm of accounting jargon a “spread sheet” or spreadsheet was and is a large sheet of paper with columns and rows that organizes data about transactions for a business person to examine. It spreads or shows all of the costs, income, taxes, and other related data on a single sheet of paper for a manager to examine when making decisions.
An electronic spreadsheet organizes information into software defined columns and rows. The data can then be “added up” by a formula to give a total or sum. The spreadsheet program summarizes information from many paper sources in one place and presents the information in a format to help a decision maker see the financial “big picture” for the company.
What about Microsoft Excel and Bill Gates?
The next milestone was the Microsoft Excel spreadsheet. Excel was originally written for the 512K Apple Macintosh in 1984-1985. Excel was one of the first spreadsheets to use a graphical interface with pull down menus and a point and click capability using a mouse pointing device. The Excel spreadsheet with a graphical user interface was easier for most people to use than the command line interface of PC-DOS spreadsheet products. Many people bought Apple Macintosh so that they could use Bill Gates’ Excel spreadsheet program. There is some controversy about whether a graphical version of Microsoft Excel was released in a DOS version. Microsoft documents show the launch of Excel 2.0 for MS-DOS version 3.0 on 10/31/87.
When Microsoft launched the Windows operating system in 1987, Excel was one of the first application products released for it. When Windows finally gained wide acceptance with Version 3.0 in late 1989 Excel was Microsoft’s flagship product. For nearly 3 years, Excel remained the only Windows spreadsheet program and it has only received competition from other spreadsheet products since the summer of 1992.
By the late 1980s many companies had introduced spreadsheet products. Spreadsheet products and the spreadsheet software industry were maturing. Microsoft and Bill Gates had joined the fray with the innovative Excel spreadsheet. Lotus had acquired Software Arts and the rights to VisiCalc. Jim Manzi had become CEO at Lotus in April 1986 and in July 1986 Mitch Kapor resigned as Chairman of the Board. The spreadsheet entrepreneurs were moving on .
Excel 2013 has a variety of viewing options that change how your workbook is displayed. You can choose to view any workbook in Normal view, Page Layout view, or Page Break view. These views can be useful for various tasks, especially if you’re planning to print the spreadsheet.
To change worksheet views, locate and select the desired worksheet view command in the bottom-right corner of the Excel window.
Click the arrows in the slideshow below to review the different worksheet view options.
Normal view: This is the default view for all worksheets in Excel.
The Difference between a Workbook, a Worksheet, and a Spreadsheet
Because the terms spreadsheet, workbook, and worksheet are so similar, there can be a lot of confusion when trying to understand their differences. When you open Microsoft Excel (a spreadsheet program), you’re opening a workbook. A workbook can contain one or more different worksheets that can be accessed through the tabs at the bottom of the worksheet your currently viewing. What’s often most confusing is that a worksheet is synonymous with a spreadsheet. In other words, a spreadsheet and worksheet mean the same thing. However, most people only refer to the program as a spreadsheet program and the files it creates as spreadsheet files.
Examples of Spreadsheet Programs
Today, Microsoft Excel is the most popular and widely used spreadsheet program, but there are also many alternatives. Below is a list of spreadsheet programs that can be used to create a spreadsheet.
Google Sheets – (online and free)
iWork Numbers – Apple Office Suite
LibreOffice -> Calc (free)
Lotus 1-2-3 (discontinued)
Lotus Symphony – Spreadsheets
OpenOffice -> Calc (free)
Examples and Uses of a Spreadsheet
Although spreadsheets are typically used with anything containing numbers, the uses of a spreadsheet are almost endless. Below are some other popular uses of spreadsheets.
What is an Active Worksheet?
An active worksheet is the worksheet that is currently open. For example, in the Excel picture above, the sheet tabs at the bottom of the window show “Sheet1,” “Sheet2,” and “Sheet3,” with Sheet1 being the active worksheet. The active tab usually has a white background behind the tab name.
How many worksheets open by default?
In Microsoft Excel and OpenOffice Calc by default there are three sheet tabs that open (Sheet1, Sheet2, and Sheet3). In Google Sheets it starts with one sheet (Sheet1).
What is the length limit of a worksheet sheet name?
Not to be confused with the file name, in Microsoft Excel there is a 31 character limit for each worksheet sheet name.
How are rows and columns labeled?
In all spreadsheet programs including Microsoft Excel, rows are labeled using numbers (e.g., 1 to 1,048,576). All columns are labeled with letters from A to Z, then with two letters. For example, after the letter Z, the next column is AA, AB, AC, …, AZ and then incrementing to BA, BB, BC, etc., to the last column XFD.
When working with a cell, you combine the column with the row. For example, the very first cell is in column A and on row 1, so the cell is labeled as A1.
Why wouldn’t I just use a word processor?
While it may be true that some of the things mentioned above could be done in a word processor, spreadsheets have a huge advantage over word processors when it comes to numbers. It would be impossible to calculate multiple numbers in a word processor and have the value of the calculation immediately appear. Spreadsheets are also much more dynamic with the data and can hide, show, and sort information to make processing lots of information easier.
Spreadsheets and Media Presentations
GET THIS PROJECT NOW BY CLICKING ON THIS LINK TO PLACE THE ORDER