Computer class project EXCEL for 6th grade to do in School and at home (Synchronous and Asynchronous)
Jacqueline Losada
Foundations of Virtual Instruction
Students will:
Follow instructions Learn independently trough tutorials (videos) Work on EXCEL (make charts, do graphs, make some calculations, write formulas…) Navigate and use a School page to receive instructions Integrate Math concepts with technology programs
Computer Benchmarks to be covered: 2.2 Knows basic distinctions among computer software programs such as word processors, special purpose programs and games. 2.3 Uses menu options and commands 2.4 Knows how to select and edit text in EXCEL 2.5 Knows how to format characters. (e.g. font, size color, alignment, line spacing, page set-up) in EXCEL 2.6 Knows how to insert cells, columns and rows in Excel. 2.7 Knows how to processor to copy, paste, move, find and replace text in Excel 2.8 Knows how to create graphics in Excel 2.13 Identifies each part of Excel windows 2.19 Understands a Spreadsheet is a tool to create worksheets, charts and database. 5.1 Applies and reinforces other subject skills
6th grade Math Benchmarks to be covered: 8.1 Compute the range, mean, median, and mode of data sets. 8.2 Understand how additional data added to data sets may affect these computations of measures of central tendency. 8.3 understand how the inclusion or exclusion of outliers affects measures of central tendency.
8.4 Know why a specific measure of central tendency (mean, median) provides the most useful information in a given context. Grading system: Every week you have to do the part that is explained in each tutorial, with the data or other specifications the teacher will give you.
The first 2 classes will be in the Computer lab (in school). (10 points each. Formative) The next 4 weeks you will be working independently (at home) You will bring your work (in a portable memory- USB) to save it in your PERSONAL FOLDER. The teacher will evaluate the work you did at home. (20 points Formative, and 20 points for Work Habits) The project about EXCEL will continue the next 2 classes (in school). (10 points Formative. 20 points Summative)
Jacqueline Losada
Foundations of Virtual Instruction
What students have to do? 1- Click in the link to see and listen the tutorials, each week you will have a new tutorial. 2- Follow the instructions in the tutorial to do the same activities, but with the data provided by the teacher. 3- You need to bring, in a portable memory stick (USB), what you did. Your work will be evaluated, and you will continue working with it at school. 4- Your work will be evaluated, (Formative 20 points, Work Habits 20) and you will continue working with it at school. 5- The last week you will complete a summative assessment doing an exercise related with what you already learned. (20 points Summative)
Week #1 (to do in Computer class) *The teacher will teach students how to follow instructions using a video tutorial. The teacher will pause the video to practice something, or move back the video to understand something better, and then do it.
TUTORIAL #1 (Formative 10 points) Microsoft Excel Tutorial for Beginners #1 - Overview http://www.youtube.com/watch?v=8L1OVkw2ZQ8 1- Follow the instructions in the tutorial to do a chart in EXCEL, using the following data: School Assistance
BOYS GIRLS MALE TEACHERS FEMALE TEACHERS TOTALS
MONDAY 17 15
TUESDAY 15 20
WEDNESDAY THURSDAY 14 18 22 19
FRIDAY 16 21
7
5
6
4
4
10
12
13
11
14
TOTALS
2- Do all the formats the tutorial explains: Write data that have some continuity (as Monday, Tuesday….) using the drag and drop feature. Write the other labels and data. Auto sum the data (the rows and the columns) Merge and center the tittle. Bold, underline and put color to the cell Grid all chart.
Jacqueline Losada
Foundations of Virtual Instruction
Bold and put color to totals cells, and another color to total of totals Center the data in the chart 3- Select the data, NOT the totals, to do a column graph 4- Do NOT change the data to currency. 5- Save you file in your PERSONAL FOLDER (Elementary/Your grade/your name) with the name: Tutorial#1
Week #2 (to do in Computer class) *The teacher will let students follow instructions using a video tutorial at their own pace. They could stop the video to practice something, or move back in the video to understand something better, and then do it. Teacher just watch how everyone in going on.
TUTORIAL #2 and #3 (Formative 10 points) Microsoft Excel Tutorial for Beginners #2 - Get Started http://www.youtube.com/watch?v=lJqfZw5j2R0
Microsoft Excel Tutorial for Beginners #3 - Calculations (Formulas) http://www.youtube.com/watch?annotation_id=annotation_144171&feature=iv&src_vid=lJqfZ w5j2R0&v=rpCaVZCURZQ 1- Follow the instructions in the tutorial to do a chart using the following data: The title will be: (Your name)’s (Video- Books- DVDs) In the label for title you can put movies (others than the tutorial has), or books, or Music DVDs; at least 7. In the other labels (rental price, rentals, income); you may put other numbers as you want (be logical, please!!). 2- You will learn to: Adapt size width of cells to what you write on them Change a column of general number to currency Move fast around the cells Write the correct symbol to do calculations in Excel ( /division, *multiplication, +addition, -subtraction ) Make some calculations using simple formulas in EXCEL (multiplication, addition, average, etc.) Quickly write the formula in many cells 3- Save your work in a portable memory stick (USB) to use the chart during the next tutorials the next weeks at home.
Jacqueline Losada
Foundations of Virtual Instruction
Week #3 *The students follow instructions using a video tutorial and work as their own pace at home. Teacher is available by e-mail to answer student’s questions.
TUTORIAL #3 and #4 (to do at HOME) (Formative 20 points, Work Habits 20) Microsoft Excel Tutorial for Beginners #3 - Calculations (Formulas) http://www.youtube.com/watch?annotation_id=annotation_144171&feature=iv&src_vid=lJqfZ w5j2R0&v=rpCaVZCURZQ
Microsoft Excel Tutorial for Beginners #4 - Functions (Formulas) http://www.youtube.com/watch?annotation_id=annotation_524564&feature=iv&src_vid=rpCa VZCURZQ&v=sYxiYzx0_yY 1- Using the chart you did in the last class, you will make different calculations. 2- In addition to what the tutorial teaches (total, average or mean, max., min., and count); you need to calculate the median, mode, and range. REMEMBER. Mean is the "average" (Average refers to the sum of numbers divided by the amount of numbers). To find it, you add up all the numbers and then divide by the number of numbers. Median is the middle value in the list of numbers. To find the median, your numbers have to be listed in numerical order, so you may have to rewrite your list first. Mode is the value that occurs most often. If no number is repeated, then there is no mode for the list. Range is just the difference between the largest and smallest values (the max. and the min.)
Week #4 TUTORIAL #5 and #6 (to do at HOME) (at the end of Week #6: Formative 20 points, Work Habits 20)
Microsoft Excel Tutorial for Beginners #5 - Number Formats http://www.youtube.com/watch?v=RIIcRArOCok
Microsoft Excel Tutorial for Beginners #6 - Formatting Pt.1 http://www.youtube.com/watch?annotation_id=annotation_611624&feature=iv&src_vid=RIIcR ArOCok&v=qZbWJC7mO4o 1- Using the chart you did in the last class, you will make some formats to numbers. 2- Choose what currency you want to use in your chart (you may use $ instead of ÂŁ)
Jacqueline Losada
Foundations of Virtual Instruction
Week #5 (at the end of Week #6: Formative 20 points, Work Habits 20) TUTORIAL #7 and #8 (to do at HOME) Microsoft Excel Tutorial for Beginners #7 - Formatting Pt.2 http://www.youtube.com/watch?v=csQrfaAXin0
Microsoft Excel Tutorial for Beginners #8 - Formatting Pt.3 http://www.youtube.com/watch?v=YU-KmgpG-ew 1- Using the chart you did in the last class, you will make some formatting in it 2- Use the colors you want
Week #6
(at the end of Week #6: Formative 20 points, Work Habits 20)
TUTORIAL #9 and #10 (to do at HOME) Microsoft Excel Tutorial for Beginners #9 - Charts Pt.1 http://www.youtube.com/watch?v=HVX2tAHq_J0
Microsoft Excel Tutorial for Beginners #10 - Charts Pt.2 http://www.youtube.com/watch?v=qwx_h6DlypU 1- Using the chart you did in the last class, you will make a column graph. 2- Use the RENTALS column data 3- You may use the pictures and colors you want
You need to bring, in a portable memory stick (USB), what you did. Your work will be evaluated, (Formative 20 points, Work Habits 20) and you will continue working with it at school.
At the end of week #6, we will have a synchronous section through the school platform with questions and answers, to resolved doubts. The time and day will be informed to all students by e-mail.
Jacqueline Losada
Foundations of Virtual Instruction
Week #7 (Formative 10 points) TUTORIAL #11 (to do in School) Microsoft Excel Tutorial for Beginners #11 - Charts Pt.3 http://www.youtube.com/watch?v=TSwaU1w2NqY 1- Using the chart you did in the last class, you will make a pie graph, with the formatting the tutorial explains.
Week #8 (Summative 20 points) Last class- Summative (to do in School) 1- Using the data the teacher will provide you, you will make a chart and a bar graph by your own, with the formatting you already learned.
Jacqueline Losada
Foundations of Virtual Instruction
Jacqueline Losada
Foundations of Virtual Instruction