Entertainment Project Management

Project Management in Live Entertainment

  • Project Management
  • Instructions
    • Syllabus
    • Course Schedule
    • Online etiquette
  • Lecture Content
    • Project Management 101
    • Excel 101
    • How to Estimate
    • WBS Charts
    • Estimating Project Presentation Day and PERT Charts
    • Proposal part 1
    • Reading executive summaries
    • Proposal part 2
    • Poster Preparation
    • Final project lecture 1
    • Defining the Tour part 2
    • Contracts and labor law
    • Obstacle assignments
  • Projects
    • Writing assignments
      • Ted Talk 1
      • Ted Talk 2
      • Ted Talk 3
      • Ted Talk 4
      • Ted Talk 5
      • TED TALK 6
    • Estimating project the Boiler
    • Proposal project
    • Poster Project
    • Final project version 2
  • Tools
    • Culmination preparation
    • Excel Spreadsheets
    • Executive Summary
    • GANTT Chart
    • How to do Citations
    • People skills
    • PERT Chart
    • Work breakdown structure
    • Draw.io workshop
  • Faculty 2
City Tech OpenLab > Entertainment Project Management > Excel 101

Excel 101

Today you are going to learn to make a budget on one excel spreed sheet. I suggest you open excel and build your spread sheet with the tutorials. Each tutorial is an example of a specific sheet. The first video tutorial demonstrates how to create a materials estimate sheet. The secondĀ  video tutorial demonstrates how to create a labor estimate sheet. The third tutorial demonstrates how to create a totals page collecting information from your materials and labor sheets to create a totals sheet. This is the link to theĀ three short videos for you to watch inside the tools tab.

 

Turn in the sheet you made in the assignment tab on black board: Excel 101 spreadsheet to earn your grade.

Grading rubric

Excel 101 assignment Rubric

DescriptionIgnored=0attempted =550% done=10Completed= 20Total 100 points
Header on each page event name on each pagePM name on each pagetab labeled
Totals sheet
information organized and labeledformulas are correct and worktotals transferred from other pages
Sheet materialsinformation organized and labeledformulas are correct and worktab labeled
Sheet labor information organized and labeledformulas are correct and worktab labeled
Excel sheetPDF turned in Completed sheet turned in lateCompleted sheet turned in on time

Watch Ted TAlk 2. Write an essay using the rubric provided with TED TALK 2.

 

 

License

Attribution-NonCommercial-ShareAlike (CC BY-NC-SA)

Unless otherwise noted, this site by sbrandt has a Creative Commons Attribution-NonCommercial-ShareAlike (CC BY-NC-SA) license. Learn more.

Funded in part by the CUNY OER Initiative.

Creative Commons License
This header image take by Ryoya Terao is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Education Pro Theme on Genesis Framework · WordPress · Log in

The OpenLab at City Tech:A place to learn, work, and share

The OpenLab is an open-source, digital platform designed to support teaching and learning at City Tech (New York City College of Technology), and to promote student and faculty engagement in the intellectual and social life of the college community.

New York City College of Technology City University of New York

New York City College of Technology | City University of New York

Support

Help | Contact Us | Privacy Policy | Terms of Use | Credits

Accessibility

Our goal is to make the OpenLab accessible for all users.

Learn more about accessibility on the OpenLab

Copyright

Creative Commons

  • - Attribution
  • - NonCommercial
  • - ShareAlike
Creative Commons

© New York City College of Technology | City University of New York


top

The OpenLab at City Tech:A place to learn, work, and share

The OpenLab is an open-source, digital platform designed to support teaching and learning at City Tech (New York City College of Technology), and to promote student and faculty engagement in the intellectual and social life of the college community.

New York City College of Technology City University of New York

New York City College of Technology | City University of New York

Support

Help | Contact Us | Privacy Policy | Terms of Use | Credits

Accessibility

Our goal is to make the OpenLab accessible for all users.

Learn more about accessibility on the OpenLab

Copyright

Creative Commons

  • - Attribution
  • - NonCommercial
  • - ShareAlike
Creative Commons

© New York City College of Technology | City University of New York

Entertainment Project Management
Skip to toolbar
  • OpenLab Logo
    • Home
    • About
    • People
    • Courses
    • Projects
    • Clubs
    • Portfolios
    • Help
  • My OpenLab
    • Home
    • About
    • People
    • Courses
    • Projects
    • Clubs
    • Portfolios
    • Help
  • Sign Up
  • Log In