- My presentations
Auth with social network:
Download presentation
We think you have liked this presentation. If you wish to download it, please recommend it to your friends in any social system. Share buttons are a little bit lower. Thank you!
Presentation is loading. Please wait.
To view this video please enable JavaScript, and consider upgrading to a web browser that supports HTML5 video
Unit 9 Spreadsheet Development Assignment 1
Published by Easter Carroll Modified over 8 years ago
Similar presentations
Presentation on theme: "Unit 9 Spreadsheet Development Assignment 1"— Presentation transcript:
ADMINISTRATION Information Technology for Administrators SPREADSHEETS Click To Continue.
Mr Watsons Introduction to Spreadsheets The Quick and Easy guide to using Microsoft Excel.
Mr Watson’s Introduction to Spreadsheets
A spreadsheet is an application which allows you to calculate many simple or complex figures You can create this figures by using formulas; this helps.
INFORMATION TECHNOLOGY Software Applications. WORD PROCESSING WP is the most commonly used package in business. A large number of documents are produced.
SPREADSHEETS Chapter 3 By Michael & Russell What are Spreadsheets used for? SIMPLE CALCULATIONS SIMPLE CALCULATIONS (shop’s weekly profits) COMPLEX CALCULATIONS.
An Introduction to Spreadsheets Technology Applications North Ridge Middle School.
Spreadsheets A spreadsheet package is a general purpose computer package that is designed to perform calculations. A spreadsheet is a table which is divided.
Unit 27 Spreadsheet Modelling
Spreadsheets in Finance and Forecasting Introduction to Charts, Summary Values and Pivot Tables.
Welcome to CMPE003 Personal Computer Concepts: Hardware and Software Winter 2003 UC Santa Cruz Instructor: Guy Cox.
1 Introduction to OBIEE: Learning to Access, Navigate, and Find Data in the SWIFT Data Warehouse Lesson 8: Printing and Exporting an OBIEE Analysis This.
Chapter 12 Information Systems. 2 Chapter Goals Define the role of general information systems Explain how spreadsheets are organized Create spreadsheets.
Spreadsheet in excel o Spreadsheet in excel o Uses of spreadsheet o Advantages Prepared by: Yusra Waseem 8 th C.
Database Design IST 7-10 Presented by Miss Egan and Miss Richards.
P1 & D1 Finish report by 3rd May 2011.
Spreadsheets Mynde Sean Daley And maybe zombie john.
General Purpose Packages Spreadsheets. What is a Spreadsheet? A Spreadsheet is a computer program used mainly for recording mathematical data such as.
Use of spreadsheet Software!
About project
© 2024 SlidePlayer.com Inc. All rights reserved.
David Sweetman
Web designer / games designer/ photographer, spredsheet development.
This page is about Unit 9 Spreadsheet Development
This document is the Assignment Brief for Assignment 1 in Unit 9
This document is the completed work for Assignment 1 in unit 9
This document is the Assignment Brief for Assignment 2 in Unit 9
This document is the completed work for Assignment 2 in unit 9
This document is the spreadsheet test plan for unit 9
This document is the Assingment brief for Assingment 3 for unit
This document is the first version of the spreadsheet before the review
This document is the questions that people answered to review the spreadsheet
This document is the altered version of the spreadsheet after the review
This document is the formula prints for for Assignment 3
This document is the spreadsheet pages for Assignment 3 anotated to show the features
this is the Assingment breif for Assingment 4 for unit 9
this the completed Assignment for Assignment 4 for unit 9
Unit 9: Spreadsheet Development
This unit is about spreadsheets and the development of spreadsheets. The goal of this unit is to make the student understand the uses of spreadsheets. This unit will also tell the features available in the spreadsheet. The goal of this unit is to tell us how to design a spreadsheet and how to develop and test a spreadsheet.
The highest grade you can get in this unit is Level 2 Distinction. You can get this grade by discussing the strengths and weaknesses of spreadsheets. You will also need to justify how the spreadsheets fulfil the requirements and the stated purpose. You will also need to produce a detailed worksheet and data structure of data.
The content of this unit is to tell what spreadsheet is about and the use of it. This unit will also tell us how spreadsheets help us to improve productivity and accuracy. Spreadsheets also help us to present information. This unit will also tell us how to perform calculations and use formulae.
Data in the spreadsheet
A video explaing about the spreadsheets.
- International
- Schools directory
- Resources Jobs Schools directory News Search
Unit 9 (Spreadsheet Development) Checklist - BTEC Level 2 Extended Certificate in ICT
Subject: Computing
Age range: 16+
Resource type: Assessment and revision
Last updated
13 January 2020
- Share through email
- Share through twitter
- Share through linkedin
- Share through facebook
- Share through pinterest
A colourful, concise, easy to use checklist for use by teachers / students to track progress through Unit 9 (Spreadsheet Development) of BTEC Level 2 ICT.
Marking criteria has been condensed down into an easy to follow checklist. This provides excellent assessment for learning rather than advising students to trudge through the 300-page specification to ensure they’ve met all the criteria.
Great for students to tick off their progress as they work through the unit, or for teachers to track progress and accurately mark coursework at a glance. Very effective for both staff and students whilst saving hours of marking time.
Tes paid licence How can I reuse this?
Your rating is required to reflect your happiness.
It's good to leave some feedback.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resource to let us know if it violates our terms and conditions. Our customer service team will review your report and will be in touch.
Not quite what you were looking for? Search by keyword to find the right resource:
Unit 9- Spreadsheet Development
In this unit we were given a scenario to produce a spreadsheet to manage information about the club’s season-ticket holders for a football team. The spreadsheet had three worksheets. The first one was Ticket Holder Details. The second worksheet was summary of information and the third worksheet was Ticket Type Details.
I added lots of skills in my spreadsheet such as VLOOKUP, Countif and conditional formatting. The requirements I set up for ticket holder details are to add the names, address and contact details of each ticket applicant. I also need to add at least three types of ticket such as adult, child and concession. I also need to add requested seating area and allocated seating area. My second worksheet should include summary of the totals of the season-ticket applications and ticket allocations. A series of calculations will be needed, as well as conversion of some data to charts, in order to generate management information. The third worksheet should include the type of ticket, the price of the ticket, the numbers of seats available in each seating area and any relevant further details, e.g. restrictions, age limits.
I am proud of my spreadsheet as I have used lots of skills and tools. I have also added lots of colour to my spreadsheet, and the spreadsheet is easy and clear to understand.
BTEC First Diploma in Information and Creative Technology
Liam rodgers, assignment 2, assignment 3, assignment 4.
UNIT 9 SPREADSHEET DEVELOPMENT ASSIGNMENT 1 WHAT IS
UNIT 9 SPREADSHEET DEVELOPMENT ASSIGNMENT 1
WHAT IS A SPREADSHEET? • A spreadsheet is a electronic document where date is shown in rows and columns. Also you put numbers in it and the spreadsheet dose calculation for you. furthermore it display on the result in the screen. Spreadsheet is mostly done in excel. • • • Designed to carry out calculations Used in many different organisations, in particular within small/medium enterprises To record and store data. Present information clearly and effectively Perform calculations and help analyse data Manipulate large data
REASONS WHY SPREADSHEETS ARE USED IN ORGANISATIONS • Business use spreadsheet to calculate how much profit they make in the companies. • School will use spread sheets to make time table for the students. • Business Spreadsheet are used to make charts like pie chart , bar chart , line graph and scatter graph. • Also you can use it to make meeting plane in businesses.
PURPOSE OF TOOLS AND TECHNIQUE • Tools and technique will be used to make the spread sheet look better. • Furthermore it will be used to improve the spreadsheet. • Lastly with the tools and technique the user will be able to design it so it is appealing for the user so the user know where averting is so it is easy to find the information.
ACTIVITIES WHERE SPREADSHEETS ARE USED • Cost modelling • Analysis of large data • Creating timetables band results • Stock control
MY TWO DIFFERENT SPREADSHEETS Spreadsheet 1 this sheet is showing the average of the prices Spreadsheet 2 this is a spread showing a pie chart
PURPOSE OF THE SPREADSHEETS • Spreadsheet 1 This spreadsheet is calculating the profit what he or she can make buy selling to product • Spreadsheet 2 • The spreadsheet 2 is showing a pie chart. And the percentage of grade what people are getting
THE PURPOSE OF THE TOOLS AND TECHNIQUES OF BOTH SPREADSHEETS • Spreadsheet 1 - For the newspaper agency, to calculate the total value there was a code to add up all the weeks and multiply it by the price.
HOW THE TOOLS ARE USED • The spreadsheets are used as they are easy for the viewer to interoperate, appealing to a modern audience. Also it is very easy to make calculations such as an average or a total.
HOW THE FUNCTIONS HELP • Functions such as the average key help the user a lot as if there any changes made such as a value that will affect the average value the spreadsheet software will automatically change it.
STRENGTHS AND WEAKNESSES Spreadsheet strengths weaknesses You can make time tables and also store date in spreadsheets. The spreadsheet doesn’t use conditional validation Furthermore it is very is to read and store information in. It has good layout
IMAGES
VIDEO
COMMENTS
unit 9 spreadsheet development assignment 1 nathan mckenzie-hirst - Free download as PDF File (.pdf), Text File (.txt) or view presentation slides online. Scribd is the world's largest social reading and publishing site. ...
UNIT 9: SPREADSHEET DEVELOPMENT Assignment 1: Uses and Features of Spreadsheet Software Packages By: Luca Ivanov 211446 AIM • In this presentation I am considering two spreadsheets designed for two different purposes: Tracking Learners progress and recording results, Stock Control.
Presentation on theme: "Unit 9 Spreadsheet Development Assignment 1"— Presentation transcript: 1 Unit 9 Spreadsheet Development Assignment 1. 2 What is a spreadsheet? A spreadsheet is a electronic document where date is shown in rows and columns. Also you put numbers in it and the spreadsheet dose calculation for you .furthermore it display ...
copy of unit 9 spreadsheet development assignment 1 - joshua hetherington - Free download as PDF File (.pdf), Text File (.txt) or view presentation slides online.
This document is the completed work for Assignment 2 in unit 9. This document is the spreadsheet test plan for unit 9. This document is the Assingment brief for Assingment 3 for unit. This document is the first version of the spreadsheet before the review. This document is the questions that people answered to review the spreadsheet.
UNIT 9 : Spreadsheet Development Student Number:104146 Name:Araiz Ghani. Introduction In this assignment I am completing a work placement at the local football club in its administration department. I Have been asked to produce a spreadsheet to manage ... spreadsheet 1 Tools and techniques spreadsheet 2 The tools and techniques that have been
To achieve the criteria you must show that you are able to: Unit Criterion reference Identify how spreadsheets are used for two different activities and how the features are used in the spreadsheets. 9 1A.1 Identify the purpose and user requirements for the spreadsheet. 9 1B.2 With guidance, produce a design for a spreadsheet including:
UNIT 9 - SPREADSHEET DEVELOPMENT. Spreadsheets are used to store, manipulate and analyse data and to present it in easy-to-understand ways. They are invaluable for collecting and manipulating data of all types. Spreadsheets can be formatted to create clear, concise reports and can be sorted, filtered and updated with the touch of a button.
Unit 9: Spreadsheet Development 1 01/30/2022 Warehouse stock 1. The purpose of this spreadsheet is to show the records of a businesses' stock transferred from their store to their retail stores. The business are dealing with over 100 different products in a period of 3 months. There are over 6000 records in total, however this spreadsheet only shows very few of them.
The goal of this unit is to make the student understand the uses of spreadsheets. This unit will also tell the features available in the spreadsheet. The goal of this unit is to tell us how to design a spreadsheet and how to develop and test a spreadsheet. The highest grade you can get in this unit is Level 2 Distinction.
A colourful, concise, easy to use checklist for use by teachers / students to track progress through Unit 9 (Spreadsheet Development) of BTEC Level 2 ICT. Marking criteria has been condensed down into an easy to follow checklist. This provides excellent assessment for learning rather than advising students to trudge through the 300-page ...
Unit 1 assignment 3 - these documents are for BTEC business level 3; UNIT 5 assignment 3: International business: Unit 5,assignment 1: international business: ... The managers and business need to ensure that they are also helping their staff, for instance, performing personal development reviews might be necessary to identify the employees ...
spreadsheet development (unit 9) 3 3 documents. 0 0 questions 0 0 students. Follow this module Chat. Lecture notes. Date Rating. year. Ratings. Unit 4 Assignment 1 - Notes. 2 pages 2022/2023 100% (2) 2022/2023 100% (2) Save. Coursework. Date Rating. year. Ratings. Spreadsheet Development. 5 pages 2014/2015 None. 2014/2015 None. Save.
Unit 9 is all about spreadsheets, we are learning about creating formulas and everything needed to create a fully working, productive spreadsheet so if we ever need to create one in the future then we will know exactly what tools are available to use. ... Assignment 1: In assignment 1 we were tasked with creating a spreadsheet based on the cost ...
In this unit we were given a scenario to produce a spreadsheet to manage information about the club's season-ticket holders for a football team. The spreadsheet had three worksheets. The first one was Ticket Holder Details. The second worksheet was summary of information and the third worksheet was Ticket Type Details.
A2 purpose and requirment P2.docx. assignment 2 D2 CRITERIA (2).docx. assignment 2 P2 test plan.docx. SCAFFOLDING FOR ASSIGNMENT 2 P CRITERIA.docx. detailed structure diagram.docx. UNIT 9 A2 ASSIGNMENT.doc. ASSIGNMENT 2 M2 CRITERIA (2).docx. multiplication test.xlsx.
View Notes - Unit 9 spreadsheet (1).xlsx from BUSINESS MT209 at Kaplan University, Davenport. Unit 9 Assignment Spreadsheet Month 1 Revenue Number of customers Average price Total ... Fees 75 Property Taxes 100 Rent 500 Repairs & Maintenance 175 Shipping & Delivery 200 Telephone 160 Training & Development 300 Travel Utilities 200 Vehicle 200 ...
UNIT 9 SPREADSHEET DEVELOPMENT ASSIGNMENT 1 . WHAT IS A SPREADSHEET? • A spreadsheet is a electronic document where date is shown in rows and columns. Also you put numbers in it and the spreadsheet dose calculation for you. furthermore it display on the result in the screen. Spreadsheet is mostly done in excel.
Unit 9 Team Building in Business - TMG - January 2024 Assignment 1 - Report Help Sheet Task 1 Part one of Assignment 1 will be due in on: Thursday 8th February 2024 This will be submitted by 4pm and will be screened through Turnitin You must ensure that you complete all elements of the assignment with appropriate depth.
The student spreadsheet - contains details of every student. The loans spreadsheet - this shows which students have loaned which items, and provides details of their return dates. Graphs helpfully provide information on the trendiness of items. A chart that shows the popularity of items among certain groups of students.
Assignment title Assignment-1 Project Management - an investigation Assessor Bahman Parsapour Issue date W/B 12 Sept 2022 Hand in deadline 22 Sept 22 Important Assessment Information The tasks for the units 9 and 15 have been integrated should you fall behind with the spreadsheet development for Unit-15, it will have an impact on both units ...