Excel workbook project | Business & Finance homework help

Excel Workbook Project
Description of the Study:
Mr. Johnson is a 5th grade teacher. Up until this year, he has regularly tracked information about his students using notebooks, index cards and his excellent memory. When it came time to provide reports cards, attendance records or other reports such as honor roll information or class rosters – he did these by hand. This project will create an easy to use application to electronically collect information about his students and then generate interesting and required reports.
The information below can be used as a guideline in creating and completing your project.

Connect with a professional writer in 5 simple steps

Please provide as many details about your writing struggle as possible

Academic level of your paper

Type of Paper

When is it due?

How many pages is this assigment?

Create worksheets that will contain excel lists that will track (but not limited to)
Student Data
Attendance Data
Class Data
Grade Data
Lists should share/reference data across worksheets (where appropriate)
Create tables from lists use table formatting
Use of formatting (styles, conditional, table formatting, numbers, percentages, text, etc.)
Use functions to perform useful calculations:
Create at least 3 different formulas
Utilize relative, absolute and mixed cell referencing (where applicable)
Use at least 3 different functions including
Use the Vlookup function at least once
Create at least one conditional and one nested If function
Create interesting charts to showcase the data
Create at meaningful at least one chart for each worksheet of data. Be sure to include a call-out object on your chart to being attention to the chart’s meaning.
Create at least 1 combination chart.
In one of your worksheets add a column for data bars sparklines (hint: if you have a worksheet of students grades this would be an excellent place to use data bars or sparklines)
Utilize sorting, filters and subtotals
Create at least 2 interesting pivot tables and a related pivot chart for each pivot table
Create one summary worksheet that uses 3-D references to “collect” data from the other worksheets in the workbook (hint: if you have separate worksheets that collect data about a student’s grades, attendance, and demographic data – reference this data to create a “report card” summarizing a student’s progress)
Use named ranges in at least one of the worksheets
Create validation on selected cells to ensure the integrity of the data
Create at least one macro to automate a process within the workbook (hint: automate the print preview of a particular cell range)
Create buttons to manage the macros
As appropriate all data and charts should be formatted using formatting concepts learned in the text. Themes and styles should be taken advantage of to enhance the appearance the content.
Save the project as: Excel Project-YourName
This project is worth 100 points.

What does it consist of?
As you complete each chapter in the textbook you will learn new concepts in Excel. Each of these concepts should be applied to your design. For example, if the chapter covers the use of logical functions, you must aptly apply instances of using logical functions to your design – and so forth

You should at the very least include:
3 or more related sheets of data, relating/referencing the data where possible
Use of formatting (styles, conditional, table formatting, etc.)
Create at least 3 different formulas
Use at least 3 different functions including at least one conditional and one nested If function
Utilize relative, absolute and mixed cell referencing
Create at least 3 meaningful charts. Be sure to include a call-out object on your chart to being attention to the chart’s meaning.
Create at least 1 combination chart.
In one of your worksheets add a column for data bars sparklines (hint: if you have a worksheet of students grades this would be an excellent place to use data bars or sparklines)
Creating lists of data on your worksheets
Utilize sorting, filters and subtotals
Create at least 2 interesting pivot tables and a related pivot chart for each pivot table
Create one summary worksheet that uses 3-D references to “collect” data from the other worksheets in the workbook (hint: if you have separate worksheets that collect data about a student’s grades, attendance, and demographic data – reference this data to create a “report card” summarizing a student’s progress)
Use named ranges in at least one of the worksheets
Create at least one macro