The purpose of the assignment is to show your excel skills

Assignment Help Humanities
Reference no: EM131343386

AIM OF THE ASSIGNMENT

The purpose of this assignment is to show your Excel skills.

The assignment is based around you developing a suitable spreadsheet which you can use to track your study progress, assignment due dates and assignment results.

While you must meet the minimum requirements set out below, feel free to add additional information which you think will be useful. In particular, for students who have already completed courses, feel free to add the final results to the course planning worksheet.

TASK 1 - SPREADSHEET SETUP

Skills to Show

  • Create, and use at least once, a suitably named range for the Course data listed on the Courses tab
  • Create, and use at least once, a suitably named range for the Grade data listed on the Grades Tab
  • Use a suitable formula for the AVERAGE column on the Grades tab
  • Create a suitably named tab for Task 2
  • Create a suitably named tab for Task 3
  • Create a suitably named tab for Task 4 Master
  • Create suitably named tabs for each of the 6 actual courses being entered in Task 4
  • Overall Structure of worksheets
  • Includes: layout, formatting, alignment, spelling, and suitable use and structure of formulas and functions, use of ISBLANK to make the spreadsheet more visually appealing

TASK 2 - COURSE PLANNING WORKSHEET

Create a new worksheet (not workbook) which you could use by a student to record your planned courses of study for all courses completed to date, courses currently enrolled in, and future enrolments.

Remember to refer to the examples in Appendix B for guidance.

Features

Your worksheet should include details for Year, Semester, Course Code and Name, Final Grade, Grade

Range summary for each grade received as a minimum but other details can also be included.

Skills to Show

  • Add your name and date birth to this worksheet
  • Use at least 2 VLOOKUPs (must be for 2 different purposes)
  • Calculate statistics for each course showing minimum and maximum possible mark for each grade and a grade average
  • Calculate overall statistics for all courses completed to date showing the minimum mark, the maximum mark and the average mark obtained overall
  • Use a COUNT function to calculate the frequency of each Grade received to date
  • Create at least 1 drop down list with suitable messages
  • Use at least 1 IF(ISBLANK) to ensure all calculations work as intended
  • Use data validation to ensure the semester is one of the following: 1, 2 FY or SS where FY stands for full year and SS stands for summer school. Include suitable messages.
  • Use at least 1 absolute cell reference (in addition to using named ranges)

Data to Enter

  • Enter the relevant study plan data provided in Appendix A and use calculated values to check your formulas are accurate
  • Add at least 1 other course details of your choice (either real or desired)

TASK 3 - ASSIGNMENT TRACKING WORKSHEET
Create a new worksheet (not workbook) which you can use to summarise your assignments and their due dates. Remember to refer to the examples provided in Appendix B for further guidance.

Features
Your spreadsheet must include the following:
• Date so it will show the current date when the spreadsheet is opened
• Course code and name
• Assessment number, due date, whether it has been submitted or not and days until due

  • The days until due should show either the number of days from the current date until the day due, or
  • "submitted" if it has been handed in, or
  • "overdue" if the assignment due date has passed and it has not yet been submitted

• Raw mark and raw percentage mark

  • Raw mark is the actual mark received
  • Raw Percentage is raw mark divided by total mark

Skills to show

  • Use dropdown list at least once. Include suitable messages.
  • Use VLOOKUP at least once
  • Create a nested IF statement to display the message showing the number of days until the assignment is to be submitted or that it has been submitted, or is overdue (ie to show the information in the Status column above)
  • Use at least 2 different DATE functions
  • Use at least 1 absolute reference in addition to any named ranges used
  • Calculate the Raw Percentage mark

Data to enter
Enter all the relevant assessments for the course XXX104 shown above and use to check your formulas
Enter all your assessments for NZD550 including your result for assignment 1 (if not marked, make up a mark!)
Enter all your assessments for at least 1 other course you are enrolled in for 2016.

TASK 4 - COURSE ASSESSMENT SUMMARY SHEET
Create a new worksheet (not workbook) which you could use to track your assignment results and calculate the minimum mark required for the final exam for each course you are enrolled in.

Create a new worksheet which could be used as a master sheet (ie has formulas entered where required but no numbers for the actual results) labelled as Course Master

Copy the master to a different worksheet for each course in Appendix A and label each worksheet with the course code

Remember to refer to the examples in Appendix B for further information.

Features
Your spreadsheet must contain the following:
• Year and semester (a course may be offered in semester 1, 2, full year or summer school)
• Course code, name and credits
• The raw percentage, weighting and weighted mark for each assessment
• Calculates the minimum mark required for the final exam (as a mark out of 100)

  • To pass the course, the final exam mark must be at least 40%
  • Some courses do not have a final exam. If there is no final exam, display a suitable message instead
  • All course weightings (assessments and final exam) must total 100%

Refer to the examples provided to see how the minimum mark calculations are made.

Skills to Show - in master

  • Use VLOOKUP at least once
  • Create at least 2 different Drop Down Lists, including suitable messages
  • Create at least 3 different IF statements (NB a nested IF statement would count as more than 1 IF statement based on number of IFs included)
  • Use of suitable formulae throughout
  • Use data validation to provide information on the data to be included in
  • the Assessment, Weighting and Raw Percentage cells.

 

Data to enter - copy your master to a separate tab for each course

  • Enter all the assessments for the Introductory courses XXX101, XXX102, XXX103 and XXX104 as shown in Appendix A. Only enter the relevant information and check and use to make sure your formulas are working correctly. Choose your own semester of study.
  • Enter all your assessments for or NZD550 including your result for assignment 1.
  • Enter all your assessments for at least 1 other course you are enrolled in for 2016 or completed in a prior year. If this is the only course you are enrolled in, choose any other course and make up the data.

Reference no: EM131343386

Questions Cloud

Draw graphs depicting the general shape of each relationship : Dollinger, Matyja, and Huber (2008) studied the correlations between overall exam performance in an upper-division psychology course and several other variables.
Reactions for the oxidation of pyrite : Write three reactions for the oxidation of pyrite and explain how these can result in the production of acid waters that are enriched in trace metals and metalloids.
Different beliefs about how education matters : The difference in these beliefs is usually based on how cultures are exposed to information. In these cultures, it is important to note that access to information is often different. This is based on the fact that different cultures have different..
Discuss the strengths of using multiple triangulation : PAD 520- From the case studies, Case 1.1 and Case 1.2, discuss the strengths and limitations of using multiple triangulation, also called critical multiplism. Provide at least one example to support your answer.
The purpose of the assignment is to show your excel skills : The purpose of this assignment is to show your Excel skills.- The assignment is based around you developing a suitable spreadsheet which you can use to track your study progress.
Definition of the diagnosis of the dissociative disorders : Definition of the diagnosis, symptoms, and epidemiology of the obsessive-compulsive and trauma-related disorders; definition of the diagnosis and symptoms of the dissociative disorders;explanation of the diagnosis and symptoms of somatic disorders, ..
Partial pressure due to oxygen : A mixture of gases has the partial pressures of 0.308 atm due to He, .259 atm due to N2, and the rest is due to O2.  If the total pressure of the mixture is 752 mmHg, what is the partial pressure due to oxygen?
Permanganate solution to exactly react with the arsenic : The manganese was reduced to the +2 state.  If it took 10.64 mL of the permanganate solution to exactly react with the arsenic, what is the percentage of arsenic in the sample?
Describe at least five instances of actual data presented : These can include surveys, experiments, business data, and even sports information.

Reviews

Write a Review

 

Humanities Questions & Answers

  Briefly summarise the sentence that you chose for the

visit view and explore the following web resourcehttpwww.directgov.coionline.tvjudgeforyourselfchoose one of the

  Design a mos differential amplifier

D 9.14 Design a MOS differential amplifier to operate from ±1-V power supplies and dissipate no more than 1 mW in the equilibrium state. The differential voltage gain Ad is to be 10 V/V and the output common-mode dc voltage is to be 0.2 V.

  Did us handle the cuban missile crisis appropriately

Evaluate Nikita Khrushchev's attempt to change the Soviet Union. To what extent did he succeed? To what extent did he succeed in changing the Cold War?Did the United States handle the Cuban Missile Crisis appropriately? Did the Soviet Union?Why wer..

  Explore the background on a social problem or policy issue

The student will use this paper assignment to explore the background on a social problem or policy issue of his or her choice. The paper should serve as a tool for basic education of the students' peers on the chosen social issue.

  Basic current mirror to implement the current source

Design the circuit of Fig. 9.36(a) using a basic current mirror to implement the current source I. It is required that the short-circuit transconductance be 5 mA/V. Use ± 5-V power supplies and BJTs that have β = 100 and VA =100 V. Give the comple..

  Describe a contemporary monument in your city

Describe a contemporary monument in your city or in another U.S. city and whether it holds some special significance for the citizens of the city where it was erected.

  Ethical position paper on same sex marriage.

Given a description about the ETHICAL POSITION PAPER on SAME SEX MARRIAGE.

  Awareness of oppression and arousing sympathy of supporters

By creating awareness of oppression and arousing sympathy of supporters, the arts can be a form of protest. Identify and describe an example of how either black slaves or white abolitionists used the arts as a form of protest against slavery.

  Write a research paper about to study bikers as a subculture

Write a research paper about to study bikers as a subculture.

  How much confidence do you have in an organized religion

Independent variable: How much confidence do you have in an organized religion?Dependent variables: Nativity, political ideology, and sexual orientation.Find three articles create a short power point presentation.

  Determine a state variable representation

A multi-loop block diagram is shown in Figure E3.9.The state variables are denoted by x1 and x2. (a) Determine a state variable representation of the closed-loop system where the output is denoted by y(t) and the input is r(t). (b) Determine the c..

  The mann-whitney u test for a large sample

You are using the Mann-Whitney U test for a large sample and have been given the following statistics: T = 258, n1 = 15 and n2 = 25. Using a 5 per cent significance level you would compare a z value of:

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