Microsoft Excel – Collecting & Organizing Data

Microsoft Excel – Collecting & Organizing Data

Introduction

Now that you have made a proposal, we need to collect evidence! This week you will be researching and collecting data that shows why you believe it is important to pursue your proposal. Make sure to collect as much as information as possible so you can create meaningful charts next week. This week’s work will be the basis for next week’s assignment.

Learn

Textbook Reading

Below you will find the textbook reading for the week. Remember to complete your reading by Wednesday to be prepared for the week!

Microsoft Excel

Microsoft Office 2016 at work for dummies (Links to an external site.)

Understanding Excel interface – Chapter 7

Entering and editing data – Chapter 7

Autofill – Chapter 7

Cell management – Chapter 7

Sheet management – Chapter 7

Cell References – Chapter 8

Basic Formulas – Chapter 8

Insert Functions – Chapter 8

Tables – Chapter 10

Office 2016 All-In-One for Dummies (Links to an external site.)

Number Formatting – Chapter 1 of Book III Excel 2016

Review

Below you will find videos that review what we have covered this week.

Apply

Required Resources

The following resources will be used to complete your assignment:

Microsoft Excel

This week you will complete the first draft of your Excel spreadsheet. Follow the steps listed below to complete the first part of your data collection.

Create a new Excel file and call it “YourName_COMP150_W5_Assignment”.

Add two new sheets and name them as “Read Me” and “Main Data”.

The “Read Me” sheet is the place where you will add your name and date. You will also explain the purpose of the document and the type of information you are providing. See an example below.

screenshot of example “read me” sheet

Based on your research topic, you need to provide a large set of data that can be used for analysis during this week and next. Your data set must be at least of 10 rows and 3 columns and no more than 50 rows or 10 columns. You can make this up or do research to find a data set. The data set must have numbers to help with the calculations in the next steps, so it is recommended to review the entire assignment before you create the data set.

The table with the dataset must have a header that is merged and center.

The data must be visible so make sure the columns and rows have enough spacing

You are expected to have all of the following calculations

A formula using a relative reference

A formula using absolute reference

Use at least three different functions

Ensure the different types of data have the right formatting. Here are some guidelines

Dates should have “date” formatting

Any currency should have two decimals

Any text should be setup as “text” or “general”

Feel free to be creative by adding images or other formatting, and complete the file. Make sure the file is named “YourName_COMP150_W5_Assignment” and submit the file.

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.