Using Count If Formula

Submitted By Emmanuel-Amankwah
Words: 672
Pages: 3
Open Document
TO: COWBOYS ACADEMY
FROM: EMMANUEL AMANKWAH
DATE: 7TH April, 2015.
USE APPROPRIATE TOOLS TO PRESENT DATA, ANALYSING AND INTERPRETING THE DATA PRESENTED.
In order to refine data from the spreadsheet thus finding the number of students attending each course on the enrolment sheet. Specific functions has to be used to help select the data we are generating to analyse and interpret. Count if as a function in excel is used to count the number of cells within a set range that meets a specific criteria. For the function to fit into the specified data, the formulae for count if had to be written in the following ways to generate the specified data thus the number of students attending a particular course.
The number of courses present for students to enrol had to be grouped and given a name. This serves as a part of the count if formula thus the array or range where the number will be looked at.

The column for which the number of students attending each will be displayed was created against the various courses.

The count if formula was then typed under the column to display the number of students attending each course. The count if formula involves two parts, thus the range and criteria. The range is the courses I grouped in the enrolment sheet and named it “course enrol”. The criteria is the courses against the number of attendees which is going to serve as a lookup value.

The formula was then applied to the other cells by dragging the formula down to the other cells to apply the function. This then filtered the results from the enrolment sheet providing the student attending each course.

From the enrolment sheet which provided the details of the student such as name and course enrolled. It also provided the exact number of students registered or enrolled on the spreadsheet.

Although the enrolment sheet provided the important details of the students and the number of courses which has been registered on the sheet. However the sheet does not provide the number of students on each course. Therefore the data which has been provided from the enrolment was filtered in order to help specify the number of students which have been on a course. From the clarified data provided. I noticed that some courses had more students registered on it than the ones. It also showed some courses were not selected by any student meaning the interest and pursuing of the course has decreased. The figure below show the results of the data from the enrolment sheet which has been filtered.

A graph showing the number of students registered on a course
INTERPRETATION OF
Show More

Related Documents: Using Count If Formula

Manage Quality Unit Essay example

Registrationl enrolment number mE:.Ci (\:~ "J) f\V\ ES (tK..L\-J..J..s-9 '9 ~ ~ l~ 'I~ Ii ; b /8/13 ." ~ TutorCare Unit Summary Sheet Assessment and Verification Declaration Qcr title: Health & Social Care Unit no~,:).ksc ........, ~..6~~ Candidate declaration: I confirm that the evidence listed for this unit is authentic and a true representation of my own work. Candidate name: _OO :D..ts.V.LCS _ .. Candidate enrolment number: f:t .. f?:…

Words 302 - Pages 2

Level 3 Award In Preparing To Teach In The Lifelong Learning Sector

to speak without interruption, no swearing, listen to others opinions and respect them etc. I would then ensure that a registration form has been filled in and identification has been checked if needed. I would also have learners fill out an enrolment form at the beginning and an evaluation form at the end of the course. This is vital to help improve future courses. During the course I would demonstrate good listening skills by reiterating and feeding back to the learner. I would also be aware…

Words 1531 - Pages 7

Enrollment System High School Essay

important role in our society, most especially in school premise. Most school uses computer to help their students deal in our modern technology. But as the population of the students continue to grow, many school face difficulties in handling their enrolment in a manual process. And one of the solutions in this problem is to make their manual enrollment into a computerized system. The School was conceptualized by the Division of City Schools of Cabanatuan through the leadership of the late Cabanatuan…

Words 4473 - Pages 18

World Anti-doping Agency and Original Question Essay

Assignment cover sheet Diploma courses Student Name Student ID Unit Name and Number 700002 Business Academic Skills Workshop Day and Time Workshop Tutor Title of Assignment Researching Section 1: Analyse the Question Length (Word Count) 50 Words Due Date In Week 4 Workshop Date Submitted Campus enrolment Declaration: (an examiner or lecturer/tutor has the right not to mark this assignment if the declaration below has not been made)…

Words 612 - Pages 3

FRA Coursehandbook FINAL Essay

Contents Page Contacts 2 Course Programme and assignment submission dates 3-5 City & Guilds 6302 Learning Pathway and Principal aims of the course 6 Assignment Criteria and tips for writing assignments, etc 6-8 City Lit Policies and Procedures 9-11 Recommended Reading 12 C&G Assignment Assessment Criteria 13-17 Pro forma 18-23 Contacts Centre for Teacher and Management Training, City Lit Course tutor Jennie Kitteringham…

Words 3861 - Pages 16

Educational Psychology and Data Protection Essay example

Application and Enrolment Form Section 1. Course Details (Please use CAPITAL LETTERS) I want to study: I want to start in: YYYY I want to study:  Full-time  Part-time Section 2. Personal Details Mr/Ms/Miss/Other: First name(s): Last name: Date of birth: DD / MM / YY Age: Gender: Previous last name (if changed): National Insurance no: Car registration no: Unique learner no. (if known): Last school/college attended: Address: Postcode: Usual permanent…

Words 1723 - Pages 7

Essay on project management

examination (25%) 11 Overview 11 Details 11 Marking criteria and standards 12 General submission requirements 12 Assignment cover sheet 12 TurnitIn 13 Late submission 13 Extension of due date for submission 13 SECTION FIVE YOU AND THIS UNIT 20 SGSM Client Services 20 Enrolment changes 20 Teaching staff 20 What is expected of you 20 Attendance and workload 20 Special requirements 22 Key policies 22…

Words 6308 - Pages 26

Essay on Bs Omg

BUSINESS STRATEGY (ST3S03A) RYANAIR JUNE 2013 COURSEWORK INSTRUCTION Contact Details Hazel Mawdsley e-mail: hmawdsle@glam.ac.uk Tel: 01443 480480 Business Strategy Case Study Assignment Students will produce a report based on the following questions on the Ryanair Airlines: Questions 1. Identify Ryanair’s strategic position 2. How do the key external drivers of change affect Ryanair? 3. How does Ryanair add value to its strategic position? 4. Identify…

Words 1144 - Pages 5

Positive Behaviour Support Essay

As Willert & Willert suggest, ‘positive behaviour supports developed through the implementation of simple reinforcement strategies…can have a significant influence on the social climate of an entire school.’ (As cited in Zirpoli, 2012, p. 257). With this in mind, this paper aims to analyse and compare the School’s management, welfare, and discipline policies with positive behaviour support models, specifically Mayer’s (1999) constructive discipline approach. The School reflects the view that the…

Words 2125 - Pages 9

Essay Chapter 6 3

Chapter 6 Compensation IBUS 618 Dr. Yang 1 Chapter Objectives In the introductory chapter we described IHR managers as grappling with complex issues:  Manage more activities from a broader perspective,  Be more involved in the lives of their far-flung employees  Balance the needs of PCNs, HCNs and TCNs  Control exposure to financial and political risks and  Be increasingly aware of and responsive to hostcountry and regional influences. In this chapter, all of these issues and concerns are…

Words 3365 - Pages 14