First Christian Academy
Computers & Technology Class, Spring 2015.
Final Project
We’re going to work on a final project for the next three weeks. The project will have multiple components that need your time and planning:
- A video you will create and host on Youtube
- A spreadsheet for the business
- A website with five pages
You’re going to pretend to open up a tutoring company that serves middle and high school students.
The video will contain pictures that you take along with a narration you’ll write and record. Write the script within a week, you can record your narration in class next week if you like (I’ll bring in the equipment for you to use). Take at least 10 pictures of various textbooks, desks, and other images that support your message. (You may not use pictures from the web, you must take your own pictures and use them in the video, no personal pictures, lose 15 points). You might need to resize the pictures if they are very high resolution. Try here or here. 800 pixels is a good size to use. The video needs to be 30 - 60 seconds long. This will be 75 to 150 words of text for your narration.
Plan the finances. You’ll setup a spreadsheet that will show how the business will function financially. You must use google drive spreadsheets for the project. How many students can you work with each afternoon? Operating hours are probably 3pm to 8pm. Most students will stay 2-3 hours. Tutors can work with 2-4 students at once. If you hire 3 tutors, how many students can you serve each day? Assume 80% capacity most days. Tutors will earn $15 per hour. Parents will pay $45 per hour for tutoring. Set up your spreadsheet to show income from tutoring. Then show expenses to operate the business. You should include at least 10 expense items, here are some to get you started: Tutors, electricity, rent, phones, internet, water. (You come up with at least 4 more). Setup the spreadsheet with monthly and yearly columns. You must use formulas to calculate the answers; if formulas are not used, you will miss out on 30 percent of the possible points. Your spreadsheet can look similar to this one:
Setup the website. Register a name at wordpress.com and setup the site. It needs to have at least 5 pages: home page, about us page that includes the video, ‘investor page’ that has the spreadsheet embedded or linked from google drive, a contact page that includes an embedded map from google maps and a contact form. The contact form needs to ask for the parent’s name, student's name, use a multiple choice button for students grade (6, 7, 8, 9, 10, 11, 12), their address (including city, state zip), their phone. The results of the contact form should email to you so you can show me it works correctly. Finally, a meet the tutor page that will include pictures of the three tutors (you can pick random pictures from google images for these people). Include a paragraph you’ll make up about who the tutors are, their qualifications, and what subjects they specialize in.
Since this is a large project, you’ll need to pace yourself to complete it on time.
Next week, May 6, you need to have your pictures ready at the beginning of class. No pictures, no points.
May 13 you need to have the spreadsheet completed and website partially setup at the beginning of class.
May 20 you need to have the project completed and ready to show at the start of class.
Read over the project a few times and contact me in class or via email if you have any questions or issues. I look forward to seeing your business begin!
