Develop a project using microsoft excel

Assignment Help Basic Computer Science
Reference no: EM132070771

Objective: To develop a project of your choice using Microsoft Excel.

Details: You are creating a project using skills that you have learned in this class. The project may be a workbook that you could use in your professional or personal life. The project requires several components:

1. Include specific tasks that have been covered this semester.

2. Include a numbered, detailed list beginning with the first task you included.

List the task and then list the worksheet where the task is located. Tasks should be listed in the same order as the tasks appear beginning with the first worksheet of the workbook. Include a "how to" description for tasks that aren't easy to see in the worksheet such as a "sort".

3. Post your project to the project discussion board to earn five points.

4. Submit your project and the detailed list to the project drop box.

A task only counts once regardless of the number of times it is used in various worksheets. You will submit your completed project to the project drop box as well as post to the project discussion board. The detailed list will ONLY be submitted to the project drop box. Do NOT post detailed lists on the discussion board.

Task List:

Everyone is required to submit a detailed numbered list of the tasks included in their project. The list needs to indicate which worksheet the task is located on. Start at the top of the first worksheet and list the included tasks. Start at the top of the second worksheet and list the included tasks. Continue until all tasks have been listed. This list will be submitted using the project drop box. Classroom students will submit to the drop box and hand a printed copy of their project and list to your classroom instructor. Be detailed in your listing. Start numbering with the first task that appears in the first worksheet at the top of your document. List the tasks in the same order that they appear from top to bottom on your document.

Summary:

To summarize, you are designing this project. The project must be an original file created by you during this semester. Do not complete book problems. You can refer to book problems for ideas but can't complete a book problem to count as your project. Don't use a workbook that someone else created at work. You will earn points based on the number of skills satisfactorily demonstrated. For points to be awarded, completion of the feature must be visible. For some tasks that are difficult to see such as "sorts," describe how the "sort" is performed in your detailed list. If the instructor cannot see the skill, you need to describe how the task is performed in order to earn the points.

Something entirely from the first two chapters will not earn full design points. The detailed list is a mandatory part of the project. The numbered list will match the order in which tasks are presented in the various worksheets. The detailed list is mandatory as it lists the tasks you included in your project. Without the list, you will not earn as many points if your instructor has to "read your mind" and try to count the tasks you included.

The project is worth one hundred points towards your final grade. Plan ahead as your project will take more time to complete than normal assignments.

Verified Expert

This is an very intersteing assignmnet which deals with both the aspect forming and question and solving it in a execl format.this assignmnet deals reverse work which is pratcially forming question latter and answer first.

Reference no: EM132070771

Questions Cloud

Raised the maximum amount of short-term funds : What will be the firm's quick ratio after Nelson has raised the maximum amount of short-term funds?
What was the main factor that influenced this change : Has the company's ROE changed over the last three years? What was the main factor that influenced this change?
Draw and solve a decision tree for problem : a. Draw and solve a decision tree for this problem b. Write your recommendation
Explain the key features that lead you to your conclusion : Explain the key features that lead you to your conclusion. Identify one (1) modern musician who you believe was great at one type of music yet pioneered another
Develop a project using microsoft excel : Develop a project using Microsoft Excel - The project must be an original file created by you during this semester. Do not complete book problems
Maslow hierarchy of needs important for a salesperson : Why is Maslow's Hierarchy of Needs important for a salesperson to understand? Is it more important in a consumer purchase, or in a business purchase?
Discuss the future of american education : Describe how you think these trends will influence the future of American education and defend your rationale.
How many benches and how many picnic tables : How many benches and how many picnic tables should be produced to maximize profit? What is the maximum profit? Explain/justify your response.
What does your view say about human world : Human beings use animals in a variety of ways: for food, clothing, scientific testing, and entertainment. Gabriela Cowperthwaite's documentary Blackfish (2013).

Reviews

inf2070771

12/10/2018 2:35:55 AM

100% satisfied with the work that i had received. The expert has excatly written to the guidelines that are follwed at my college and made a perfect assignment. I received the document 2 days before the dealine, this provided mw with enough time to revise the solution. The fees was very reasonable. I am expecting a good grade with this. Will send one assignment in the coming hours.

len2070771

7/31/2018 12:45:08 AM

Presentation and Required Documentation Point Value Your Score A copy of the student’s project has been “presented” to their peers by A) posting a copy of their project to the discussion board (ONL) or B) informally present their finished project to the class (F2F). 5 Total: 5 Total Points Possible: 1 25

len2070771

7/31/2018 12:44:59 AM

Project Quality Point Value Your Score Worksheet structure is clear and professional. Worksheets include titles, subtitles, column headings, row headings, chart titles, axis titles are present and accurately describe the included data. 5 All data is visible and easily readable (i.e. column width is wide enough to display all data, row hei ght displays all information, charts or other visual elements do not overlap existing data. 5 Design and Formatting elements (i.e. fonts, cell styles, chart styles, table styles, borders, shading, etc) are consistent and enhance readability. 5 In Print Preview, all worksheets print cleanly within the defined print area. 5 Content is devoid of any spelling, grammar, or punctuation errors 5 Total: 25

len2070771

7/31/2018 12:44:45 AM

Excel Tasks Point Value Your Score 1. Charts – Any type 5 2. Conditional Formatting – Any formats 5 3. Data Subtotals / Outlines 5 4. Data Sorts - B e sure to describe the sort completed in the task list! 5 5. Data Filters – B e sure to describe the filters completed in the task list! 5 6. PivotTables – Any type 5 7. PivotCharts – Any type 5 8. Formulas Formulas must be correct mathematically, correctly use the order of operations, and use cell references appropriately 5 9. Functions Must use functions from a minimum of 3 different function categories Example: Financial, Lookup, and Statistical 5 a. Logic Functions (IF) b. Financial Functions (PMT, PV) c. Lookup Functions (VLOOKUP, HLOOKUP) d. Statistical Functions (SUM, AVERAGE, MIN, MAX, COUNT) e. Date Functions (NOW, TODAY) f. Other Functions, please specify: 10.

len2070771

7/31/2018 12:44:35 AM

Points Possible Documentation Sheet Point Value Your Score A worksheet entitled “Documentation” is included as the first worksheet in the workbook. 2 The student’s name is included in the “Documentation” worksheet. 2 The current date is included in the “Documentation” worksheet. 2 A paragraph (3 - 5 sentences) describing the purpose of the project is included on the “Documentation” worksheet. 4 Total: 10 Task List Sheet Point Value Your Score A worksheet named “Task List” is included as the second worksheet in the workbook. 5 On the “Task List” worksheet, the student has listed all completed tasks included within the project. 10 On the “Task List” worksheet, the student has provided a location (such as worksheet names, cell references, etc.). 10 Total: 25

len2070771

7/31/2018 12:44:19 AM

Your completed project and list are submitted to the D2Learn projec t drop box. Five points will be awarded for posting your project on the discussion board and commenting on two classmates’ projects. If you choose not to post your final version to the discussion board, you forfeit the five related points. You need to post your final version on the discussion board as well as submit using the drop box. Classroom students will forfeit the five related points if you choose not to present to the class. Use spell check and have someone proofread your final printouts before submitting.

len2070771

7/31/2018 12:44:08 AM

This course calls for completion of a project, which car ries a point value of one hundred points. Points will be earned based on the number of skills satisfactorily demonstrated. Refer to the Project Requirement table to see point values for various skills that can be included in your project. Five points are e arned for posting on the discussion board and commenting on at least two classmates’ projects. Classroom students will earn their five points by presenting to the class rather than using the discussion board. You will create a workbook of your choice usin g the topics covered during the course. Points are earned for the number of tasks you include in your project. Points awarded for the project will be based on clarity of design, complexity of design, completeness, formatting and absence of spelling and rel ated errors. Earning full project design points will require using tasks from the last few chapters. Projects that contain only skills from the first two chapters will not earn full design points.

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd