Excel Review Assignment #1 – ISM3011 Ask before/after/during class or come into office/online hours if you have questions on any of this. Refer to the syllabus on Academic Dishonesty and group/individual work and allowable help for all projects – also remember it’s your responsibility to protect your work. Before you start — read this whole assignment and use your optional text and/or review the tutorials as necessary on Canvas or www.bwarner.org/tips. A project overview for each project is also available. Part 1 – Create / Download / Parts • Create a blank workbook. Name it using your Last name followed by your initials and _ 1EX (underscore then 1EX). For Example: WarnerBL_1EX .xlsx. Either extension is fine. • Download the Word file Ex1 Data1-F15.docx and copy/paste Word table from the file into the 2nd worksheet in your workbook. Name the tab ‘2014 Sales’. • Download the Word file Ex1 Data2-F15.docx and copy/paste Word table from the file into the 3rd worksheet in your workbook. Name the tab ‘2015 Sales’. • Adjust the column widths of both Sales worksheets so that no data is cut off. • Do not add any formulas or cells to the Sales worksheets Part 2 – Summary Worksheet • Create a summary sheet from the Sales worksheets. Name the worksheet ‘Summary’. Build two summaries on this worksheet. Summary 1: Comparison of Sales by Month and Summary 2: Comparison of Sales by Store ID. • Use the project overview as a guide for the format. Use colors, borders and backgrounds to make the worksheet look professional. o Include the following:  Month and Store ID headings that reference the 2014 Sales worksheet. This means if ‘January’ is changed to ‘Jan’ in the 2014 Sales worksheet, the summary worksheet heading will also change. Do the same with the Store ID and 2014 Sales worksheet.  Formulas that reference the 2014 and 2015 Sales worksheets. If the Sales worksheets change, the summary worksheet should also adjust automatically.  Correct format for all book totals (commas, no decimal places)  Correct % change formulas in both tables. This is how much the totals have changed compared to the 2014 totals.  Correct format for all % change (% sign, 1 decimal place).  Use borders and background colors on the column & row headings for both tables of data • On the summary worksheet, use conditional formatting to highlight any % change cell that greater than zero with a bright color background. If the % change is negative, display the value with a red font and no background color. o There should be only two conditional formats set on each cell. o **Note – to do the conditional formatting steps, you can set the conditional formatting for one cell and then use the format painter to apply to other appropriate cells. If the values are all changed, the conditional formatting should still work. Once you have it working, check by changing some values & see if the conditional formatting changes correctly. Return to the original values/formulas in the cell before you submit. If you don’t use the format painter for this be sure you still try it out & understand how it works. Part 3 – Chart • Create 2 column graphs displaying Totals by Month and Totals by Store ID. Include: • Titles on both chart as well as labeling on the x and the y axis. • Color fonts for the title and axis labels (not dark blue or black) • Large font for the title (at least 16 point) • Include a legend • Format the background (chart area/walls) of the graph with a texture – use one that is easy to see. • Be sure that if any headings or numbers in the worksheets change, these changes are automatically reflected in your chart. • Add a star or banner shape between the two charts and add your name. Be sure the text is part of the shape (not a shape and a separate text box). Part 4 – Finishing Up • Be sure your worksheet tabs are named correctly and if possible, make each worksheet tab a distinctly different color. If your version of Excel doesn’t allow this, don’t worry about it. But do delete any additional worksheets in the workbook. • Create a title in the first row of your summary worksheet. Use the merge and center feature (across all columns with data) and a larger font & different font color (not blue or black). Also add a background color. Add a comment with your email address and the date your spreadsheet was created. • Below the title, add a row with the current date (use the today or now formula) so it is updated whenever the spreadsheet is opened). • Check your formulas, be sure they are correct and make sense. For example, if you are subtracting 2 numbers don’t use the SUM formulas (sum is for adding). Excel may figure out what you mean, but we want the formulas to be used correctly (show that you understand how to use them). • Check your worksheet for errors! Potential errors in cells show up as small green triangles in the top left corner of each cell. Do a little Googling on error checking for your version of Excel and be sure you have error checking turned on and that you reconcile each error so they don’t display when we open your project for grading. Sample: Project Submission Instructions / Notes: • Office/online hours get busy as deadlines approach. If you procrastinate and wait until the last days to work on your project, you may not be able to get all the help you want. • The only way we can fairly grade the projects is if we check for each requirement. Please go through the instructions before you submit & be sure you have done each one correctly so you don’t miss out on points. Compare your solution to the project overview. • Submitting: o Remember to leave all of the internal file properties intact for your project, if they are modified or deleted, you project won’t be accepted (see syllabus for more on this). o Read and follow the instructions in the Assignments section of Canvas on uploading and checking your upload. If you follow these instructions you can ensure that your project is uploaded correctly (and is the correct project). Be sure that Access / Excel are closed before you try to upload your project files. o If your project doesn’t upload correctly before the due date, it will be considered late and be assessed the late penalty – even it was finished on time. This is the only way we can ensure that students check their Canvas submissions. • Technology problems relating to your home computer (Windows based or Mac), internet connection or slow Canvas access are not valid excuses for late/missing work, unless Canvas is down for 6+ hours on the due date. Computers at USF computer labs and the library are available; leave enough time to access them as needed. Also give yourself enough time that if a TA can’t answer a question, you’ll have time to contact me & I can either help you or make an allowance in your grade. If you wait until the last days, I may not be able to do either.

Excel Review Assignment #1 – ISM3011 Ask before/after/during class or come into office/online hours if you have questions on any of this. Refer to the syllabus on Academic Dishonesty and group/individual work and allowable help for all projects – also remember it’s your responsibility to protect your work. Before you start — read this whole assignment and use your optional text and/or review the tutorials as necessary on Canvas or www.bwarner.org/tips. A project overview for each project is also available. Part 1 – Create / Download / Parts • Create a blank workbook. Name it using your Last name followed by your initials and _ 1EX (underscore then 1EX). For Example: WarnerBL_1EX .xlsx. Either extension is fine. • Download the Word file Ex1 Data1-F15.docx and copy/paste Word table from the file into the 2nd worksheet in your workbook. Name the tab ‘2014 Sales’. • Download the Word file Ex1 Data2-F15.docx and copy/paste Word table from the file into the 3rd worksheet in your workbook. Name the tab ‘2015 Sales’. • Adjust the column widths of both Sales worksheets so that no data is cut off. • Do not add any formulas or cells to the Sales worksheets Part 2 – Summary Worksheet • Create a summary sheet from the Sales worksheets. Name the worksheet ‘Summary’. Build two summaries on this worksheet. Summary 1: Comparison of Sales by Month and Summary 2: Comparison of Sales by Store ID. • Use the project overview as a guide for the format. Use colors, borders and backgrounds to make the worksheet look professional. o Include the following:  Month and Store ID headings that reference the 2014 Sales worksheet. This means if ‘January’ is changed to ‘Jan’ in the 2014 Sales worksheet, the summary worksheet heading will also change. Do the same with the Store ID and 2014 Sales worksheet.  Formulas that reference the 2014 and 2015 Sales worksheets. If the Sales worksheets change, the summary worksheet should also adjust automatically.  Correct format for all book totals (commas, no decimal places)  Correct % change formulas in both tables. This is how much the totals have changed compared to the 2014 totals.  Correct format for all % change (% sign, 1 decimal place).  Use borders and background colors on the column & row headings for both tables of data • On the summary worksheet, use conditional formatting to highlight any % change cell that greater than zero with a bright color background. If the % change is negative, display the value with a red font and no background color. o There should be only two conditional formats set on each cell. o **Note – to do the conditional formatting steps, you can set the conditional formatting for one cell and then use the format painter to apply to other appropriate cells. If the values are all changed, the conditional formatting should still work. Once you have it working, check by changing some values & see if the conditional formatting changes correctly. Return to the original values/formulas in the cell before you submit. If you don’t use the format painter for this be sure you still try it out & understand how it works. Part 3 – Chart • Create 2 column graphs displaying Totals by Month and Totals by Store ID. Include: • Titles on both chart as well as labeling on the x and the y axis. • Color fonts for the title and axis labels (not dark blue or black) • Large font for the title (at least 16 point) • Include a legend • Format the background (chart area/walls) of the graph with a texture – use one that is easy to see. • Be sure that if any headings or numbers in the worksheets change, these changes are automatically reflected in your chart. • Add a star or banner shape between the two charts and add your name. Be sure the text is part of the shape (not a shape and a separate text box). Part 4 – Finishing Up • Be sure your worksheet tabs are named correctly and if possible, make each worksheet tab a distinctly different color. If your version of Excel doesn’t allow this, don’t worry about it. But do delete any additional worksheets in the workbook. • Create a title in the first row of your summary worksheet. Use the merge and center feature (across all columns with data) and a larger font & different font color (not blue or black). Also add a background color. Add a comment with your email address and the date your spreadsheet was created. • Below the title, add a row with the current date (use the today or now formula) so it is updated whenever the spreadsheet is opened). • Check your formulas, be sure they are correct and make sense. For example, if you are subtracting 2 numbers don’t use the SUM formulas (sum is for adding). Excel may figure out what you mean, but we want the formulas to be used correctly (show that you understand how to use them). • Check your worksheet for errors! Potential errors in cells show up as small green triangles in the top left corner of each cell. Do a little Googling on error checking for your version of Excel and be sure you have error checking turned on and that you reconcile each error so they don’t display when we open your project for grading. Sample: Project Submission Instructions / Notes: • Office/online hours get busy as deadlines approach. If you procrastinate and wait until the last days to work on your project, you may not be able to get all the help you want. • The only way we can fairly grade the projects is if we check for each requirement. Please go through the instructions before you submit & be sure you have done each one correctly so you don’t miss out on points. Compare your solution to the project overview. • Submitting: o Remember to leave all of the internal file properties intact for your project, if they are modified or deleted, you project won’t be accepted (see syllabus for more on this). o Read and follow the instructions in the Assignments section of Canvas on uploading and checking your upload. If you follow these instructions you can ensure that your project is uploaded correctly (and is the correct project). Be sure that Access / Excel are closed before you try to upload your project files. o If your project doesn’t upload correctly before the due date, it will be considered late and be assessed the late penalty – even it was finished on time. This is the only way we can ensure that students check their Canvas submissions. • Technology problems relating to your home computer (Windows based or Mac), internet connection or slow Canvas access are not valid excuses for late/missing work, unless Canvas is down for 6+ hours on the due date. Computers at USF computer labs and the library are available; leave enough time to access them as needed. Also give yourself enough time that if a TA can’t answer a question, you’ll have time to contact me & I can either help you or make an allowance in your grade. If you wait until the last days, I may not be able to do either.

No expert has answered this question yet. You can browse … Read More...
Please read the following case scenario and describe how you would handle it using one of the following ethical theories: Utilitarianism, Deontological, Contractarian, Virtue or Feminist. Case: You are taking a math class at the University of Hartford. It is a very difficult class. You must take and pass the class in order to graduate. You have worked very hard to just barely scrape by with a low C going into the final. You are talking to one of your classmates before the last class and she tells you that her roommate has a copy of the test that will be given. Her roommate works nights as part of the cleaning crew and “found a copy in her files”. You could really use the advance copy to help study. What do you do? Use the first paragraph to describe what you would do and why. In the second paragraph describe how you came to that solution using one of the Ethical Theories that are listed.

Please read the following case scenario and describe how you would handle it using one of the following ethical theories: Utilitarianism, Deontological, Contractarian, Virtue or Feminist. Case: You are taking a math class at the University of Hartford. It is a very difficult class. You must take and pass the class in order to graduate. You have worked very hard to just barely scrape by with a low C going into the final. You are talking to one of your classmates before the last class and she tells you that her roommate has a copy of the test that will be given. Her roommate works nights as part of the cleaning crew and “found a copy in her files”. You could really use the advance copy to help study. What do you do? Use the first paragraph to describe what you would do and why. In the second paragraph describe how you came to that solution using one of the Ethical Theories that are listed.

Virtue Ethics (Aristotle): “Strive for happiness, to be as fully … Read More...
For your first reflection paper assignment, the draft is due on 9/17 and the final paper is due on 9/24. The length of the paper should be about 1,000 words, typed double-spaced, using 12 pt Times Roman font with 1” margins on every side. (Just keep your default margins.) A reflection essay, also known as a reflective essay , is a work in which the writer will take the opportunity to review and analyze a certain experience in a personal way. In this assignment the “experience” is your reaction to the essays we have read so far in FYS. A reflection essay does not involve research, as many other types of essays do. Instead, authors may reflect on their personal interpretations of an experience; this can be something as simple as reading a book or watching a film, or it may occur after a greater life event. These are just a few of the many examples in which writers may take some time to reflect on what they learned. Your reflective essay assignment is to reflect on the readings so far – • Plato’s “Allegory of the Cave”; • Professor Eve’s, The Cave”, • Ray’s “Resident Alien”, • King’s “Letter From Birmingham Jail”, • Kristof’s Half the Sky , and reflect on what you learned from one or more of those essays. The point of a reflection essay is to analyze the readings in a personal way, and both positive and negative aspects should be touched upon. For instance, students writing a reflection essay on an essay they have read are not going to simply provide a summary of the writing. Instead, they might write • what they learned while reading the essay, • if any of this information altered their existing viewpoints, • if they can relate it to their life in some way. Instructors often assign these types of essays to ensure that students are actually reading and thinking about this information; of course, professional authors have also been known to write and publish such essays as well. While students do not have to do research per se, they should include: • quotes, facts and evidence from the readings to support their reflection points, • especially those parts that made them think about a particular issue in a different way • or made them change their mind about some way they used to think before they read the passage. • In other words, if these readings illuminated you in some way, tell how, and use examples from the texts to demonstrate clearly what you mean. Reflection papers can be personal, are personal and can include your own past experiences or ways of thinking to make a point about what your thinking is now after having read the essays. I am including a rubric in the Canvas files that will help with the organi zation of your reflection paper. The file is called “Rubric for Literacy Narrative or Reflective Writing.”

For your first reflection paper assignment, the draft is due on 9/17 and the final paper is due on 9/24. The length of the paper should be about 1,000 words, typed double-spaced, using 12 pt Times Roman font with 1” margins on every side. (Just keep your default margins.) A reflection essay, also known as a reflective essay , is a work in which the writer will take the opportunity to review and analyze a certain experience in a personal way. In this assignment the “experience” is your reaction to the essays we have read so far in FYS. A reflection essay does not involve research, as many other types of essays do. Instead, authors may reflect on their personal interpretations of an experience; this can be something as simple as reading a book or watching a film, or it may occur after a greater life event. These are just a few of the many examples in which writers may take some time to reflect on what they learned. Your reflective essay assignment is to reflect on the readings so far – • Plato’s “Allegory of the Cave”; • Professor Eve’s, The Cave”, • Ray’s “Resident Alien”, • King’s “Letter From Birmingham Jail”, • Kristof’s Half the Sky , and reflect on what you learned from one or more of those essays. The point of a reflection essay is to analyze the readings in a personal way, and both positive and negative aspects should be touched upon. For instance, students writing a reflection essay on an essay they have read are not going to simply provide a summary of the writing. Instead, they might write • what they learned while reading the essay, • if any of this information altered their existing viewpoints, • if they can relate it to their life in some way. Instructors often assign these types of essays to ensure that students are actually reading and thinking about this information; of course, professional authors have also been known to write and publish such essays as well. While students do not have to do research per se, they should include: • quotes, facts and evidence from the readings to support their reflection points, • especially those parts that made them think about a particular issue in a different way • or made them change their mind about some way they used to think before they read the passage. • In other words, if these readings illuminated you in some way, tell how, and use examples from the texts to demonstrate clearly what you mean. Reflection papers can be personal, are personal and can include your own past experiences or ways of thinking to make a point about what your thinking is now after having read the essays. I am including a rubric in the Canvas files that will help with the organi zation of your reflection paper. The file is called “Rubric for Literacy Narrative or Reflective Writing.”

info@checkyourstudy.com
Important Instructions for submitting this, and all subsequent projects: • Name your project .m file as follows: proj4fml.m where the “4” refers to the project number and fml are your first, middle, and last initials. • Inside the project.m file, you MUST have a comment section at the beginning with the following information: A short description of the project, your name, and Bengal ID number, and a listing of all the relevant variables (those that the user sees when using the project), and their meaning. • You will upload the proj4fml.m file to the provided link, on or before the due date and time. NOTE: The upload link will become inactive after the expiration of this due date and time, and you will NOT receive ANY credit for late submissions. Project 4 Instructions: Your program should allow the user to run it as many times as wished. Use an appropriate loop. Your program should implement the following tasks: 1) Display to the user the purpose of this program 2) In this program you will be converting temperature entered by the user in degree Fahrenheit to a) Degree Celsius b) Degree Kelvin c) Rankine or d) Réaumur 3) The formulae for conversion is as follows; Fahrenheit to Celsius C = (F – 32) / 1.8 Fahrenheit to Kelvin K = (F + 459.67) / 1.8 Fahrenheit to Rankine Ra = F + 459.67 Fahrenheit to Réaumur Re = (F – 32) / 2.25 4) You will create a main file which will call any one of the 4 functions. The name of the function files that you will create are as follows; F2C, F2K, F2Ra and F2Re where the actual calculation of the selected conversion will be computed. 5) Each of the function files will have temperature in Fahrenheit as the input argument and the corresponding conversion as its output argument. 6) The program is to run as many times as the user wishes. 7) At the end of the program display an output statement which has the user input (temperature) and the corresponding conversion.

Important Instructions for submitting this, and all subsequent projects: • Name your project .m file as follows: proj4fml.m where the “4” refers to the project number and fml are your first, middle, and last initials. • Inside the project.m file, you MUST have a comment section at the beginning with the following information: A short description of the project, your name, and Bengal ID number, and a listing of all the relevant variables (those that the user sees when using the project), and their meaning. • You will upload the proj4fml.m file to the provided link, on or before the due date and time. NOTE: The upload link will become inactive after the expiration of this due date and time, and you will NOT receive ANY credit for late submissions. Project 4 Instructions: Your program should allow the user to run it as many times as wished. Use an appropriate loop. Your program should implement the following tasks: 1) Display to the user the purpose of this program 2) In this program you will be converting temperature entered by the user in degree Fahrenheit to a) Degree Celsius b) Degree Kelvin c) Rankine or d) Réaumur 3) The formulae for conversion is as follows; Fahrenheit to Celsius C = (F – 32) / 1.8 Fahrenheit to Kelvin K = (F + 459.67) / 1.8 Fahrenheit to Rankine Ra = F + 459.67 Fahrenheit to Réaumur Re = (F – 32) / 2.25 4) You will create a main file which will call any one of the 4 functions. The name of the function files that you will create are as follows; F2C, F2K, F2Ra and F2Re where the actual calculation of the selected conversion will be computed. 5) Each of the function files will have temperature in Fahrenheit as the input argument and the corresponding conversion as its output argument. 6) The program is to run as many times as the user wishes. 7) At the end of the program display an output statement which has the user input (temperature) and the corresponding conversion.

Solution available on request: Please get in touch with us … Read More...
Discuss the importance of diet and/or exercise. Choose one: Why is exercise important? 1) Create your writing assignment in Word .doc or .docx files. This is a 3rd person formal essay and needs to be a minimum of 5 paragraphs.

Discuss the importance of diet and/or exercise. Choose one: Why is exercise important? 1) Create your writing assignment in Word .doc or .docx files. This is a 3rd person formal essay and needs to be a minimum of 5 paragraphs.

For any additional help, please contact: info@checkyourstudy.com Call and Whatsapp … Read More...